Using EXPLAIN
Listed inQuery PlansDatabaseson
The PostgreSQL manual on reading a query plan: node types, cost units, and what ANALYZE adds to the picture.
External
PostgreSQL · postgresql.org#databases
#performance
Reading EXPLAIN, spotting the sequential scan that matters, and fixing statistics rather than guessing.
2 articles
Listed inQuery PlansDatabaseson
The PostgreSQL manual on reading a query plan: node types, cost units, and what ANALYZE adds to the picture.
Listed inQuery PlansDatabaseson
Reading EXPLAIN, spotting the sequential scan that matters, and fixing statistics rather than guessing.