gistfile1.txt

> EXPLAIN SELECT <cut> FROM `wagtailcore_pagerevision` INNER JOIN `wagtailcore_page` ON ( `wagtailcore_pagerevision`.`page_id` = `wagtailcore_page`.`id` ) LEFT OUTER JOIN `auth_user` ON ( `wagtailcore_pagerevision`.`user_id` = `auth_user`.`id` ) WHERE `wagtailcore_pagerevision`.`submitted_for_moderation` = TRUE ORDER BY `wagtailcore_pagerevision`.`created_at` DESC;
+----+-------------+--------------------------+--------+------------------------------------------------------------------+------------------------------------------------------------------+---------+-----------------------------------------+--------+----------------------------------------------+
| id | select_type | table                    | type   | possible_keys                                                    | key                                                              | key_len | ref                                     | rows   | Extra                                        |
+----+-------------+--------------------------+--------+------------------------------------------------------------------+------------------------------------------------------------------+---------+-----------------------------------------+--------+----------------------------------------------+
|  1 | SIMPLE      | wagtailcore_page         | index  | PRIMARY                                                          | wagtailcore_p_content_type_id_49acab89_fk_django_content_type_id | 4       | NULL                                    | 154103 | Using index; Using temporary; Using filesort |
|  1 | SIMPLE      | wagtailcore_pagerevision | ref    | wagtailcore_pagerevision_page_id_55a20280_fk_wagtailcore_page_id | wagtailcore_pagerevision_page_id_55a20280_fk_wagtailcore_page_id | 4       | ahmigr.wagtailcore_page.id              |      1 | Using where                                  |
|  1 | SIMPLE      | auth_user                | eq_ref | PRIMARY                                                          | PRIMARY                                                          | 4       | ahmigr.wagtailcore_pagerevision.user_id |      1 | NULL                                         |
+----+-------------+--------------------------+--------+------------------------------------------------------------------+------------------------------------------------------------------+---------+-----------------------------------------+--------+----------------------------------------------+

> CREATE INDEX testindex ON wagtailcore_pagerevision (submitted_for_moderation, created_at);

> EXPLAIN SELECT <cut> FROM `wagtailcore_pagerevision` INNER JOIN `wagtailcore_page` ON ( `wagtailcore_pagerevision`.`page_id` = `wagtailcore_page`.`id` ) LEFT OUTER JOIN `auth_user` ON ( `wagtailcore_pagerevision`.`user_id` = `auth_user`.`id` ) WHERE `wagtailcore_pagerevision`.`submitted_for_moderation` = TRUE ORDER BY `wagtailcore_pagerevision`.`created_at` DESC;
+----+-------------+--------------------------+--------+----------------------------------------------------------------------------+-----------+---------+-----------------------------------------+------+-------------+
| id | select_type | table                    | type   | possible_keys                                                              | key       | key_len | ref                                     | rows | Extra       |
+----+-------------+--------------------------+--------+----------------------------------------------------------------------------+-----------+---------+-----------------------------------------+------+-------------+
|  1 | SIMPLE      | wagtailcore_pagerevision | ref    | wagtailcore_pagerevision_page_id_55a20280_fk_wagtailcore_page_id,testindex | testindex | 1       | const                                   |    1 | Using where |
|  1 | SIMPLE      | auth_user                | eq_ref | PRIMARY                                                                    | PRIMARY   | 4       | ahmigr.wagtailcore_pagerevision.user_id |    1 | NULL        |
|  1 | SIMPLE      | wagtailcore_page         | eq_ref | PRIMARY                                                                    | PRIMARY   | 4       | ahmigr.wagtailcore_pagerevision.page_id |    1 | Using index |
+----+-------------+--------------------------+--------+----------------------------------------------------------------------------+-----------+---------+-----------------------------------------+------+-------------+