NEWTECHIE TOOLS · FREE ONLINE UTILITY

MySQL EXPLAIN Plan Visualizer

Paste MySQL EXPLAIN FORMAT=JSON, EXPLAIN FORMAT=TREE or EXPLAIN ANALYZE output. Explore the execution plan, table access methods, join operations, index usage, estimated rows and actual iterator details when available.

FREE TO USE100% BROWSER-BASEDNO DATABASE CONNECTION
1

Paste or load your MySQL plan

Supported: MySQL JSON format version 1 and version 2, plus common TREE output from EXPLAIN or EXPLAIN ANALYZE. Traditional tabular EXPLAIN output is not supported in this version.

2

Execution plan overview

Visual plan tree

Indentation represents the nesting shown in the supplied plan. Operation names and metrics are taken from the pasted output.

3

Operation details

Operation / tableAccessSelected indexEstimated rowsActual rows / timingCost
4

Review prompts

How to interpret this report: A table scan, filesort, temporary table or large row estimate is not automatically a problem. Review table size, indexes, filtering, data distribution, query shape and workload before changing a query. These checks are prompts for investigation, not proof that a query is slow.

How to use the MySQL EXPLAIN Plan Visualizer

Run EXPLAIN in your own MySQL environment, copy the returned JSON or TREE output, paste it above and select Analyze plan. Use the sample buttons to explore the supported formats without connecting to a database.

What the visualizer can show

Query-block and iterator operations, table names, access types, possible and selected indexes, estimated rows, optimizer costs, filesort and temporary-table indicators, and actual rows, timing and loops when supplied in TREE output.

Frequently asked questions

Does this tool connect to my MySQL database?

No. It only parses the EXPLAIN output that you paste into the page. It does not connect to a database, execute SQL or upload your input.

Which MySQL EXPLAIN formats are supported?

The visualizer supports MySQL JSON output in the common version 1 structure and the access-path version 2 structure, as well as common TREE output. It does not currently parse traditional tabular EXPLAIN output.

Can it read EXPLAIN ANALYZE output?

Yes. EXPLAIN ANALYZE uses TREE output and can include actual rows, timing and loop counts. The visualizer displays those values when they are present in the pasted text.

Does EXPLAIN ANALYZE execute my query?

Yes. MySQL EXPLAIN ANALYZE runs the statement it analyzes. Run it only when you understand the statement and its possible effects. This page does not run the statement; it only reads output you already generated.

Does the tool automatically recommend indexes?

No. It highlights plan details and common review signals. Choosing an index depends on table structure, indexes, cardinality, predicates, data distribution and workload.

Why can a table scan be acceptable?

A scan can be reasonable for a small table, a query returning a large share of rows, or a plan where an index would not be selective. Consider the full workload and actual execution metrics before treating it as a problem.

Are JSON version 1 and version 2 different?

Yes. MySQL 8.4 supports two JSON plan structures. Version 1 uses query-block and table details; version 2 is based on access paths and includes operation and input information. This tool recognizes both common structures.