Postgres EXPLAIN visualizer
Paste output from EXPLAIN (FORMAT JSON) or EXPLAIN (ANALYZE, FORMAT JSON) to browse the plan tree, compare estimated vs actual rows/time, and see hotspot nodes ranked by cost and runtime.
Your query plan never leaves the browser — no upload, no server.
Input
Nodes · · planning ms · execution ms · ANALYZE timings present
Hotspots
| Node | Score | Cost | Rows |
|---|---|---|---|
Plan tree
Node detail
About this tool
Postgres query plans show how the executor reads your data — sequential scans, index lookups, joins, sorts. JSON format is machine-readable; run EXPLAIN (FORMAT JSON) SELECT … in psql and paste the result here.
Add ANALYZE to compare estimated rows and cost against actual runtime (the query really runs, so use on non-destructive statements). Plain-text EXPLAIN output is rejected — export JSON instead.
Read more
Free books, courses, and software
Get my programming books, course editions, and complete software.
Get the download library →