Series

Inside PostgreSQL

From SQL text to rows: parsing, planning, execution, and storage.

1 Part

1. Part 1

   How PostgreSQL executes a query

   From SQL text to rows: parsing, analysis, rewriting, planning, and execution, plus where EXPLAIN ANALYZE fits and why the planner sometimes chooses the wrong path.

   November 5, 2026·5 min read