Skip to content

Instantly share code, notes, and snippets.

@coneybeare

coneybeare/gist:4493304

Created January 9, 2013 14: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 coneybeare/4493304 to your computer and use it in GitHub Desktop.
Save coneybeare/4493304 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
EXPLAIN for: SELECT `logs`.* FROM `logs` INNER JOIN `cloud_logs` ON `cloud_logs`.`id` = `logs`.`cloud_log_id` INNER JOIN `client_application_versions` ON `client_application_versions`.`id` = `cloud_logs`.`client_application_version_id` INNER JOIN `client_applications` ON `client_applications`.`id` = `client_application_versions`.`client_application_id` INNER JOIN `cloud_logs` `cloud_logs_logs_join` ON `cloud_logs_logs_join`.`id` = `logs`.`cloud_log_id` INNER JOIN `client_application_versions` `client_application_versions_logs` ON `client_application_versions_logs`.`id` = `cloud_logs_logs_join`.`client_application_version_id` WHERE (logs.deleted_at IS NULL) AND (client_applications.account_id = '3') AND (client_applications.id = '5') AND (client_application_versions.id = '15') ORDER BY timestamp DESC LIMIT 100 OFFSET 0
+----+-------------+----------------------------------+--------+--------------------------------------------------------------------+---------------------------------------------------+---------+------------------------------------------------------------------------+------+---------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+----------------------------------+--------+--------------------------------------------------------------------+---------------------------------------------------+---------+------------------------------------------------------------------------+------+---------------------------------+
| 1 | SIMPLE | client_application_versions | const | PRIMARY,index_client_application_versions_on_client_application_id | PRIMARY | 4 | const | 1 | Using temporary; Using filesort |
| 1 | SIMPLE | client_applications | const | PRIMARY,index_client_applications_on_account_id | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | cloud_logs | ref | PRIMARY,index_cloud_logs_on_client_application_version_id | index_cloud_logs_on_client_application_version_id | 5 | const | 3346 | Using where; Using index |
| 1 | SIMPLE | cloud_logs_logs_join | eq_ref | PRIMARY,index_cloud_logs_on_client_application_version_id | PRIMARY | 4 | cloudlog_production.cloud_logs.id | 1 | |
| 1 | SIMPLE | client_application_versions_logs | eq_ref | PRIMARY | PRIMARY | 4 | cloudlog_production.cloud_logs_logs_join.client_application_version_id | 1 | Using index |
| 1 | SIMPLE | logs | ref | index_logs_on_cloud_log_id | index_logs_on_cloud_log_id | 5 | cloudlog_production.cloud_logs.id | 5 | Using where |
+----+-------------+----------------------------------+--------+--------------------------------------------------------------------+---------------------------------------------------+---------+------------------------------------------------------------------------+------+---------------------------------+
EXPLAIN for SELECT `logs`.* FROM `logs` INNER JOIN `cloud_logs` ON `cloud_logs`.`id` = `logs`.`cloud_log_id` INNER JOIN `client_application_versions` ON `client_application_versions`.`id` = `cloud_logs`.`client_application_version_id` INNER JOIN `client_applications` ON `client_applications`.`id` = `client_application_versions`.`client_application_id` WHERE (logs.deleted_at IS NULL) AND (client_applications.account_id = '3') AND (client_applications.id = '5') ORDER BY timestamp DESC LIMIT 100 OFFSET 0
+----+-------------+-----------------------------+-------+--------------------------------------------------------------------+------------------------------------------------------------+---------+----------------------------------------------------+------+---------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-----------------------------+-------+--------------------------------------------------------------------+------------------------------------------------------------+---------+----------------------------------------------------+------+---------------------------------+
| 1 | SIMPLE | client_applications | const | PRIMARY,index_client_applications_on_account_id | PRIMARY | 4 | const | 1 | Using temporary; Using filesort |
| 1 | SIMPLE | client_application_versions | ref | PRIMARY,index_client_application_versions_on_client_application_id | index_client_application_versions_on_client_application_id | 5 | const | 7 | Using where; Using index |
| 1 | SIMPLE | cloud_logs | ref | PRIMARY,index_cloud_logs_on_client_application_version_id | index_cloud_logs_on_client_application_version_id | 5 | cloudlog_production.client_application_versions.id | 557 | Using where; Using index |
| 1 | SIMPLE | logs | ref | index_logs_on_cloud_log_id | index_logs_on_cloud_log_id | 5 | cloudlog_production.cloud_logs.id | 5 | Using where |
+----+-------------+-----------------------------+-------+--------------------------------------------------------------------+------------------------------------------------------------+---------+----------------------------------------------------+------+---------------------------------+
EXPLAIN for: SELECT `logs`.* FROM `logs` INNER JOIN `cloud_logs` ON `cloud_logs`.`id` = `logs`.`cloud_log_id` INNER JOIN `client_application_versions` ON `client_application_versions`.`id` = `cloud_logs`.`client_application_version_id` INNER JOIN `client_applications` ON `client_applications`.`id` = `client_application_versions`.`client_application_id` WHERE (logs.deleted_at IS NULL) AND (client_applications.account_id = '3') ORDER BY timestamp DESC LIMIT 100 OFFSET 0
+----+-------------+-----------------------------+------+--------------------------------------------------------------------+------------------------------------------------------------+---------+----------------------------------------------------+------+-----------------------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-----------------------------+------+--------------------------------------------------------------------+------------------------------------------------------------+---------+----------------------------------------------------+------+-----------------------------------------------------------+
| 1 | SIMPLE | client_applications | ref | PRIMARY,index_client_applications_on_account_id | index_client_applications_on_account_id | 5 | const | 1 | Using where; Using index; Using temporary; Using filesort |
| 1 | SIMPLE | client_application_versions | ref | PRIMARY,index_client_application_versions_on_client_application_id | index_client_application_versions_on_client_application_id | 5 | cloudlog_production.client_applications.id | 4 | Using where; Using index |
| 1 | SIMPLE | cloud_logs | ref | PRIMARY,index_cloud_logs_on_client_application_version_id | index_cloud_logs_on_client_application_version_id | 5 | cloudlog_production.client_application_versions.id | 557 | Using where; Using index |
| 1 | SIMPLE | logs | ref | index_logs_on_cloud_log_id | index_logs_on_cloud_log_id | 5 | cloudlog_production.cloud_logs.id | 5 | Using where |
+----+-------------+-----------------------------+------+--------------------------------------------------------------------+------------------------------------------------------------+---------+----------------------------------------------------+------+-----------------------------------------------------------+
EXPLAIN for: SELECT `logs`.* FROM `logs` WHERE (logs.deleted_at IS NULL) ORDER BY timestamp DESC LIMIT 100 OFFSET 0
+----+-------------+----------------------------------+-------+---------------+-------------------------+---------+-----+--------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+----------------------------------+-------+---------------+-------------------------+---------+-----+--------+-------------+
| 1 | SIMPLE | logs | index | | index_logs_on_timestamp | 5 | | 694335 | Using where |
+----+-------------+----------------------------------+-------+---------------+-------------------------+---------+-----+--------+-------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment