Postgres EXPLAIN visualizer
Turn Postgres EXPLAIN (FORMAT JSON) into a readable plan tree with costs and rows.
Runs in your browser. Your input is not uploaded.
Loading the tool…
What it does, how to use it, and questions
What it does
Postgres EXPLAIN (FORMAT JSON) returns a tree of plan nodes with costs and row estimates. EXPLAIN ANALYZE adds actual rows and timing.
This page turns that JSON into an indented tree. It does not connect to a database.
How to use it
- Run
EXPLAIN (FORMAT JSON) …in Postgres and paste the result. - Read the tree of node types, relations and costs.
- Prefer fixing sequential scans on large estimates first.
Things to watch for
- MySQL
EXPLAINtext format is not accepted. Use Postgres JSON. - Costs are planner units, not milliseconds, unless you used ANALYZE timing fields.
Questions
- Why is there no database login?
- Paste JSON you already have. Connecting to a database would break the privacy promise.
- What does cost=a..b mean?
- Startup cost and total cost from the planner.
- Where are actual rows?
- Only when you used
EXPLAIN (ANALYZE, FORMAT JSON). - Is the plan uploaded?
- No.