Reading the Postgres planner without flinching
A field guide to EXPLAIN (ANALYZE, BUFFERS): what the planner tells you, where row estimates go wrong, and the three rewrites that fix most slow queries.
Notes tagged performance
1 min
A field guide to EXPLAIN (ANALYZE, BUFFERS): what the planner tells you, where row estimates go wrong, and the three rewrites that fix most slow queries.