Cheat Sheet logoCheat Sheet Today
MySQL Indexes, EXPLAIN, and Performance Cheatsheet/Run EXPLAIN ANALYZE

Execute the query and include actual timing information.

Back to sheetBrowse commands
Sign in to save
Section: explain and analysis

Run EXPLAIN ANALYZE

sql
sql
EXPLAIN ANALYZE SELECT * FROM orders WHERE user_id = 42 ORDER BY created_at DESC LIMIT 20;
Explanation

Great for validating whether the expected index strategy is actually helping.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing explain and analysis
Explain a SELECT query
View the optimizer's execution plan.
OpenIn sheetsqlsame section
Refresh table statistics
Update optimizer statistics for a table.
OpenIn sheetsqlsame section
Optimize a table
Reorganize table storage and update index statistics for supported engines.
OpenIn sheetsqlsame section
Explain a currently running connection
Obtain the plan for a statement running in another session.
OpenIn sheetsqlsame section
Create a simple index
Add an index for a frequently filtered column.
OpenIn sheetsql
Create a composite index
Index multiple columns in left-to-right order.
OpenIn sheetsql