Daemon Labs Labs

MySQL EXPLAIN visualizer

Switch tool
About

MySQL EXPLAIN visualizer

ToolMySQLPerformance

Paste MySQL EXPLAIN output and get a readable plan tree, the problems in plain English, and the index that would fix them.

PostgreSQL has great free plan visualizers; MySQL mostly has Workbench. This reads EXPLAIN FORMAT=JSON, EXPLAIN ANALYZE and the classic table, then flags full scans, unused indexes, filesorts, temporary tables, unindexed joins, dependent subqueries, bad row estimates and hot inner loops, and suggests an index built from the actual filter conditions.

Open on its own