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.

Correctness last checked 2026-11-13. How we verify

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

  1. Run EXPLAIN (FORMAT JSON) … in Postgres and paste the result.
  2. Read the tree of node types, relations and costs.
  3. Prefer fixing sequential scans on large estimates first.

Things to watch for

  • MySQL EXPLAIN text 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.