Skip to content

Instantly share code, notes, and snippets.

@hulucc
Created February 12, 2019 14:28
Show Gist options
  • Save hulucc/c1057b9b317c27cd982e6268ce210702 to your computer and use it in GitHub Desktop.
Save hulucc/c1057b9b317c27cd982e6268ce210702 to your computer and use it in GitHub Desktop.
Warning: Using a password on the command line interface can be insecure.
+----+-------------+----------------+------------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+---------+------+------+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
+----+-------------+----------------+------------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+---------+------+------+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 1 | UPDATE | favor_reminder | NULL | index_merge | favor_reminder_account_id_2729048d_fk_user_account_id,favor_reminder_deactivated_at_687992fe,favor_reminder_content_type_id_036c5bc2_fk_django_co | favor_reminder_account_id_2729048d_fk_user_account_id,favor_reminder_deactivated_at_687992fe,favor_reminder_content_type_id_036c5bc2_fk_django_co | 4,9,5 | NULL | 592 | 100.00 | Using intersect(favor_reminder_account_id_2729048d_fk_user_account_id,favor_reminder_deactivated_at_687992fe,favor_reminder_content_type_id_036c5bc2_fk_django_co); Using where |
+----+-------------+----------------+------------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+---------+------+------+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment