Query Plan Visualizer

A Postgres EXPLAIN ANALYZE plan viewer: paste plan text to get a collapsible node tree with per-node cost/rows/width, actual timing, a self-cost bar, and estimate-vs-actual row misestimate flags — plus planning/execution time summary.

npx shadcn@latest add https://rocket.gozturk.dev/r/query-plan-visualizer.json

Flag row misestimates

Sortcost=125.66..129.41rows=1500actual 1.23ms..1.25ms rows=1500 loops=1

Sort Key: o.created_at DESCSort Method: quicksort Memory: 133kB

Hash Joincost=64.62..131.25rows=1500actual 0.61ms..1.02ms rows=1500 loops=1

Hash Cond: (o.customer_id = c.id)

Seq Scan on orders ocost=0.00..55.50rows=1500actual 0.01ms..0.41ms rows=1500 loops=1

Filter: (status = 'completed'::text)Rows Removed by Filter: 320

Hashcost=48.00..48.00rows=1200actual 0.48ms..0.48ms rows=1200 loops=1

Buckets: 2048 Batches: 1 Memory Usage: 73kB

Seq Scan on customers ccost=0.00..48.00rows=1200actual 0.01ms..0.22ms rows=1200 loops=1

5 nodesPlanning 0.22msExecution 1.49ms