Skip to content

Instantly share code, notes, and snippets.

@simonrenoult

simonrenoult/explain_select.sql

Created July 1, 2019 08:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save simonrenoult/1a7fbf1f876a1d02638a94d62b3869a4 to your computer and use it in GitHub Desktop.
Save simonrenoult/1a7fbf1f876a1d02638a94d62b3869a4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
explain_select.sql
mysql> EXPLAIN SELECT * FROM articles WHERE article_id = 150000;
+----+-------------+----------+------------+------+---------------+------+---------+------+---------+----------+-------------+
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
+----+-------------+----------+------------+------+---------------+------+---------+------+---------+----------+-------------+
| 1 | SIMPLE | articles | NULL | ALL | PRIMARY | NULL | NULL | NULL | 1271825 | 10.00 | Using where |
+----+-------------+----------+------------+------+---------------+------+---------+------+---------+----------+-------------+
1 row in set, 3 warnings (0.01 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment