Postgres EXPLAIN visualizer

← All tools

Paste output from EXPLAIN (FORMAT JSON) orEXPLAIN (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

NodeScoreCostRows

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; runEXPLAIN (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