mysql

MySQL Simple Select

A basic MySQL execution plan showing a simple table lookup.

SELECT * FROM customers WHERE id = 10;

In this MySQL plan, the "const" access type indicates that the table has at most one matching row, which is read at the start of the query execution. This is very fast.

Interactive Execution Plan

EXPLAIN Output

Run: EXPLAIN FORMAT=JSON your_query; or EXPLAIN your_query;

Enter SQL EXPLAIN output to visualizeSupports PostgreSQL EXPLAIN ANALYZE, MySQL EXPLAIN, and SQLite EXPLAIN QUERY PLAN formats