EXPLAIN Statement •Estimated number of returned rows •Time to return first row •Time to return all rows (actual cost), in milliseconds •Number of rows returned by the iterator •Number of loops (When there are multiple loops, this figure shows the average time per loop.) The query execution information is displayed using the  TREE  output format, in which nodes represent iterators.  EXPLAIN ANALYZE  always uses the  TREE  output format. In MySQL 8.0.21 and later, this can optionally be specified explicitly using  FORMAT=TREE ; formats other than  TREE  remain unsupported. EXPLAIN ANALYZE  can be used with  SELECT  statements, as well as with multi-table  UPDATE  and DELETE  statements. Beginning with MySQL 8.0.19, it can also be used with  TABLE  statements. Beginning with MySQL 8.0.20, you can terminate this statement using  KILL QUERY  or  CTRL-C . EXPLAIN ANALYZE  cannot be used with  FOR CONNECTION . Example output: The tables used in the example output were created by the statements shown here: 2985 CREATE TABLE t1 ( c1 INTEGER DEFAULT NULL, c2 INTEGER DEFAULT NULL ); CREATE TABLE t2 ( c1 INTEGER DEFAULT NULL, c2 INTEGER DEFAULT NULL ); CREATE TABLE t3 ( pk INTEGER NOT NULL PRIMARY KEY, mysql>  EXPLAIN ANALYZE SELECT * FROM t1 JOIN t2 ON (t1.c1 = t2.c2)\G *************************** 1. row *************************** EXPLAIN: -> Inner hash join (t2.c2 = t1.c1) (cost=4.70 rows=6) (actual time=0.032..0.035 rows=6 loops=1) -> Table scan on t2 (cost=0.06 rows=6) (actual time=0.003..0.005 rows=6 loops=1) -> Hash -> Table scan on t1 (cost=0.85 rows=6) (actual time=0.018..0.022 rows=6 loops=1) mysql> EXPLAIN ANALYZE SELECT * FROM t3 WHERE i > 8\G *************************** 1. row *************************** EXPLAIN: -> Filter: (t3.i > 8) (cost=1.75 rows=5) (actual time=0.019..0.021 rows=6 loops=1) -> Table scan on t3 (cost=1.75 rows=15) (actual time=0.017..0.019 rows=15 loops=1) mysql> EXPLAIN ANALYZE SELECT * FROM t3 WHERE pk > 17\G *************************** 1. row *************************** EXPLAIN: -> Filter: (t3.pk > 17) (cost=1.26 rows=5) (actual time=0.013..0.016 rows=5 loops=1) -> Index range scan on t3 using PRIMARY (cost=1.26 rows=5) (actual time=0.012..0.014 rows=5 loops=1)