Your files stay on your device

SQL explain plan visualizer

Paste a PostgreSQL or MySQL EXPLAIN output and see the plan as an operator tree with hot nodes and row estimate warnings.

Paste an EXPLAIN output to see the plan tree.

This tool reads plans you paste; it never connects to a database and never runs your query. PostgreSQL reports actual time and rows as per-loop averages, so every cross-node comparison here multiplies by loops first, and exclusive time floors at 0 because parallel workers and InitPlans can push the arithmetic negative. Wrapped lines from narrow terminals can break the text-plan parse; JSON plans have no such weakness. MySQL EXPLAIN=TREE output, SQL Server showplan XML, and Oracle plans are not read.
Options

More regex & cron tools

- JSON query (/json/query)
- JSON formatter (/json/formatter)
- JSON diff (/json/diff)
All regex & cron tools (/dev)

Was this tool useful?
YesNo

Canonical HTML: https://nutter.tools/dev/sql-explain-plan-visualizer
Markdown version: https://nutter.tools/dev/sql-explain-plan-visualizer.md
Plain-text version: https://nutter.tools/dev/sql-explain-plan-visualizer.txt
Agent index: https://nutter.tools/llms.txt