Skip to content

Instantly share code, notes, and snippets.

@simonrenoult
Created July 1, 2019 09:04
Show Gist options
  • Save simonrenoult/a7343f7c4e019f40e0faf766c8fb04ac to your computer and use it in GitHub Desktop.
Save simonrenoult/a7343f7c4e019f40e0faf766c8fb04ac to your computer and use it in GitHub Desktop.
mysql> EXPLAIN SELECT SQL_NO_CACHE * FROM articles WHERE article_id = '150001';
+----+-------------+----------+------------+-------+---------------+---------+---------+-------+------+----------+-------+
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
+----+-------------+----------+------------+-------+---------------+---------+---------+-------+------+----------+-------+
| 1 | SIMPLE | articles | NULL | const | PRIMARY | PRIMARY | 34 | const | 1 | 100.00 | NULL |
+----+-------------+----------+------------+-------+---------------+---------+---------+-------+------+----------+-------+
1 row in set, 1 warning (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment