Skip to content

Instantly share code, notes, and snippets.

@bobbytables

bobbytables/explain.md

Created December 3, 2012 19:49
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 bobbytables/4197482 to your computer and use it in GitHub Desktop.
Save bobbytables/4197482 to your computer and use it in GitHub Desktop.
Download ZIP
Problem query explain
Raw
explain.md 
+----+-------------+-------+------+------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+---------+----------------------------------+---------+---------------------------------+
| id | select_type | table | type | possible_keys                                                                                                                            | key                                           | key_len | ref                              | rows    | Extra                           |
+----+-------------+-------+------+------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+---------+----------------------------------+---------+---------------------------------+
|  1 | SIMPLE      | users | ALL  | NULL                                                                                                                                     | NULL                                          | NULL    | NULL                             | 1474348 | Using temporary; Using filesort |
|  1 | SIMPLE      | av    | ref  | index_article_views_on_user_id,index_article_views_on_created_at,index_article_views_on_user_id_and_created_at,av_user_id_and_created_at | index_article_views_on_user_id_and_created_at | 5       | the_rundown_development.users.id |      12 | Using index                     |
|  1 | SIMPLE      | af    | ref  | index_article_favorites_on_user_id,index_article_favorites_on_created_at,af_user_id_and_created_at                                       | index_article_favorites_on_user_id            | 5       | the_rundown_development.users.id |       5 |                                 |
|  1 | SIMPLE      | lc    | ref  | index_link_clicks_on_user_id,index_link_clicks_on_created_at,lc_user_id_and_created_at                                                   | lc_user_id_and_created_at                     | 5       | the_rundown_development.users.id |       7 | Using index                     |
|  1 | SIMPLE      | ai    | ref  | index_ad_impressions_on_user_id,index_ad_impressions_on_created_at,ai_user_id_and_created_at                                             | ai_user_id_and_created_at                     | 5       | the_rundown_development.users.id |      12 | Using index                     |
|  1 | SIMPLE      | ac    | ref  | index_ad_clicks_on_user_id,index_ad_clicks_on_created_at,ac_user_id_and_created_at                                                       | ac_user_id_and_created_at                     | 5       | the_rundown_development.users.id |       2 | Using index                     |
+----+-------------+-------+------+------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+---------+----------------------------------+---------+---------------------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment