Skip to main content

EXPLAIN ANALYZE

Learn EXPLAIN ANALYZE (Query Optimization, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction EXPLAIN ANALYZE (MySQL 8.0.18+) actually executes the query and reports, per plan step, the estimated cost/rows next to the measured time, rows and loops. Output format is a TREE.

More lessons in Query Optimization