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.
EXPLAIN output
auto-detectedNothing is uploaded. Parsing and analysis happen in this page.
Execution plan
waitingHow 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.