MySQL 8.4 · Performance and maintenance
Run a query and see real timings
Execute the query and show the plan with actual row counts and times.
EXPLAIN ANALYZE SELECT * FROM users WHERE email = '[email protected]';
Caution: EXPLAIN ANALYZE really executes the statement, so don't point it at INSERT, UPDATE or DELETE outside a test database.
Official MySQL 8.4 documentation
More performance and maintenance commands
- See a query's plan
- Create an index
- Refresh index statistics
- See running queries
- Check a server setting
- Count open connections
All performance and maintenance commands · MySQL 8.4 cheatsheet