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

See also

• EXPLAIN, EXPLAIN ANALYZE, EXPLAIN VERBOSE
• SQL, NewSQL: GraphQL (2015), SQLite, select, insert, select count, Distributed SQL, TablePlus, Cache hit ratio, pg_stat_user_tables, EXPLAIN, Index (PostgreSQL), DDL, SQL/MED, Group by, List users, SQL Injection, SQLAlchemy, CREATE USER, CREATE ROLE, EXPLAIN, ALTER DATABASE, REVOKE, NOLOCK, NOWAIT, EXISTS, Unique constraint
• MySQL, mysqldump, mysqladmin, XtraBackup, MySQL Enterprise Backup, MyISAM, /var/log/mysql/, MySQL Workbench, Adminer, ib_logfile0, mysqld --help --verbose, MySQL versions