The EXPLAIN Analyzer is an online tool for analyzing and optionally sharing the output of both EXPLAIN
and EXPLAIN EXTENDED
.
Using the analyzer is very simple.
EXPLAIN
on a query and copy the output. For example: MariaDB [test]> EXPLAIN SELECT * FROM t1 INNER JOIN t2 INNER JOIN t3 WHERE t1.a=t2.a AND t2.a=t3.a; +------+-------------+-------+------+---------------+------+---------+------+------+--------------------------------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +------+-------------+-------+------+---------------+------+---------+------+------+--------------------------------------------------------+ | 1 | SIMPLE | t1 | ALL | NULL | NULL | NULL | NULL | 3 | | | 1 | SIMPLE | t2 | ALL | NULL | NULL | NULL | NULL | 3 | Using where; Using join buffer (flat, BNL join) | | 1 | SIMPLE | t3 | ALL | NULL | NULL | NULL | NULL | 3 | Using where; Using join buffer (incremental, BNL join) | +------+-------------+-------+------+---------------+------+---------+------+------+--------------------------------------------------------+ 3 rows in set (0.00 sec)
EXPLAIN
Analyzer input box and click the "Analyze Explain" button. EXPLAIN
will be shown. You can now click on various part to get more information about them. EXPLAIN
. For example, the above explain can be viewed here: https://mariadb.org/explain_analyzer/analyze/ EXPLAIN
are clickable. Clicking on them will show pop-up help related to that element. The Analyzer has an API that client programs can use to send EXPLAINs. If you are a client application developer, see the EXPLAIN Analyzer API page for details.
The following clients have support for the EXPLAIN Analyzer built in:
HeidiSQL has a button when viewing a query that sends the query to the explain analyzer.
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/explain-analyzer/