How to Get Explain Plan of a Query in Mysql or MariaDB

<<Back to MySQL & MariaDB How To Page

Find  Explain Plan of a Query in Mysql or MariaDB

mysql> explain extended <query>

For Example:

mysql> explain extended select host,user from mysql.user;
+----+-------------+-------+-------+---------------+---------+---------+------+------+----------+-------------+
| id | select_type | table | type  | possible_keys | key     | key_len | ref  | rows | filtered | Extra       |
+----+-------------+-------+-------+---------------+---------+---------+------+------+----------+-------------+
|  1 | SIMPLE      | user  | index | NULL          | PRIMARY | 228     | NULL |  116 |   100.00 | Using index |
+----+-------------+-------+-------+---------------+---------+---------+------+------+----------+-------------+
1 row in set, 1 warning (0.00 sec)