EXPLAIN ANALYZE (MySQL)

EXPLAIN ANALYZE is a profiling tool for your queries that will show you where MySQL spends time on your query and why.

EXPLAIN [ ( option [, ...] ) ] statement
EXPLAIN [ ANALYZE ] [ VERBOSE ] statement

Related terms

• EXPLAIN ANALYZE (PostgreSQL)

See also

• EXPLAIN, EXPLAIN ANALYZE, EXPLAIN VERBOSE