Content tab takes a very long time to load
I am not exactly sure if it is the best solution but it works for me.
I changed default nodes view to use GROUP BY (without any aggregation function) instead of DISTINCT and it works 40 times faster in my case.