Creative Workflow Helpers

MySQL EXPLAIN Visualizer

Paste EXPLAIN output and turn it into a readable execution plan with plain-English warnings. Supports classic table output, FORMAT=JSON, EXPLAIN ANALYZE / FORMAT=TREE, and \G vertical output.

Runs in your browser v1.0.0

EXPLAIN output

auto-detected

Nothing is uploaded. Parsing and analysis happen in this page.

Execution plan

waiting

How to read this

Steps are listed in the order MySQL reports them. A full table scan (type: ALL) reads every row, a filesort sorts after reading, and a temporary table materialises an intermediate result. These are the usual signals that an index or query rewrite will help.