EXPLAIN Render - visualize MySQL and PostgreSQL EXPLAIN plans

Plan JSON

Samples

Options

Show cost on the arrows Details on hover Render as you type

Legend

How to use it

Get the plan as JSON:
EXPLAIN FORMAT=JSON <query>; on MySQL
EXPLAIN (FORMAT JSON) <query>; on PostgreSQL
Copy the result and paste it in the box above.
Export the diagram as SVG (vector) or PNG.

On PostgreSQL, adding ANALYZE brings the real execution numbers, and the diagram starts comparing the estimate against what happened.

Nothing is sent to any server: everything runs in your browser.

Paste the JSON of a MySQL or PostgreSQL EXPLAIN, or pick a sample.