Query Lifecycle

Every query you run takes the same journey through Postgres: parsed into a tree, rewritten (views, rules, row-level security), planned into the cheapest execution strategy, then executed row by row. Trace it end to end below — the planner and executor stages run live against a real Postgres in your browser.

query lifecycle · liveone query, top to bottom

SELECT dept, count(*) AS n, round(avg(salary)) AS avg_salary
FROM high_earners
WHERE dept <> 'ops'
GROUP BY dept
HAVING count(*) > 1
ORDER BY n DESC
LIMIT 5;

SELECT dept, count(*) AS n, round(avg(salary)) AS avg_salary
FROM high_earners
WHERE dept <> 'ops'
GROUP BY dept
HAVING count(*) > 1
ORDER BY n DESC
LIMIT 5;

press “trace the lifecycle” — watch one query pass through Postgres, stage by stage. The Planner and Executor stages are live from EXPLAIN in your browser.