4 ms·
Is this something that would be evident upon running EXPLAIN over a query?
by lr4444lr 8y ago
Is this something that would be evident upon running EXPLAIN over a query?
- dspillett 8y agoExcess index (or full table) scans on the recursively referenced tables, or "wrong" index choices otherwise on those objects, where your filtering/joining clauses would otherwise allow for more efficient options with the indexes that are available. I'm not an expert on postgres (I spend most of my life in MS SQL Server's domain) so I'll not try be more detailed than that for fear of accidentally spreading/creating misinformation. Search for "postgress CTE optimisation fence explain" and you'll hopefully find some good examples as it is a commonly discussed topic once you know the right keywords to search for.