We have too many slow queries. Rewriting sql can increase 10x times or more the speed. The worse thing I think of the cost of the queries is postgres version dependent. Sniff.
(Our DB have a similar size than Roc DB.)
Regards, Agustin