Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@simonrenoult
Created July 1, 2019 09:00
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/858cbf72431423540c6e090a90068d53 to your computer and use it in GitHub Desktop.
Save simonrenoult/858cbf72431423540c6e090a90068d53 to your computer and use it in GitHub Desktop.
mysql> EXPLAIN SELECT SQL_NO_CACHE * 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 | 996520 | 10.00 | Using where |
+----+-------------+----------+------------+------+---------------+------+---------+------+--------+----------+-------------+
1 row in set, 4 warnings (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment