Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P13573
(An Untitled Masterwork)
Active
Public
Actions
Authored by
Marostegui
on Dec 17 2020, 1:08 PM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Referenced Files
F33948097: raw-paste-data.txt
Dec 17 2020, 1:08 PM
2020-12-17 13:08:30 (UTC+0)
Subscribers
None
Mariadb 10.1
root@db1136.eqiad.wmnet[arwiki]> explain SELECT /* ApiQueryUserContribs::execute */ rev_id, rev_page, rev_timestamp, rev_minor_edit, rev_deleted, rev_len, rev_parent_id, rev_sha1, comment_rev_comment.comment_text AS `rev_comment_text`, comment_rev_comment.comment_data AS `rev_comment_data`, comment_rev_comment.comment_id AS `rev_comment_cid`, actor_rev_user.actor_user AS `rev_user`, actor_rev_user.actor_name AS `rev_user_text`, temp_rev_user.revactor_actor AS `rev_actor`, page_namespace, page_title, page_id, page_latest, page_is_redirect, page_len FROM `revision` JOIN `revision_comment_temp` `temp_rev_comment` ON ((temp_rev_comment.revcomment_rev = rev_id)) JOIN `comment` `comment_rev_comment` ON ((comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id)) JOIN `revision_actor_temp` `temp_rev_user` force index (actor_timestamp) ON ((temp_rev_user.revactor_rev = rev_id)) JOIN `actor` `actor_rev_user` ON ((actor_rev_user.actor_id = temp_rev_user.revactor_actor)) JOIN `page` ON ((page_id = rev_page)) WHERE ((temp_rev_user.revactor_actor = 8)) AND ((rev_deleted & 4) != 4) ORDER BY revactor_timestamp, revactor_rev LIMIT 2;
+------+-------------+---------------------+--------+-------------------------------------------------------------+-----------------+---------+-----------------------------------------------+----------+--------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------+-------------+---------------------+--------+-------------------------------------------------------------+-----------------+---------+-----------------------------------------------+----------+--------------------------+
| 1 | SIMPLE | actor_rev_user | const | PRIMARY | PRIMARY | 8 | const | 1 | |
| 1 | SIMPLE | temp_rev_user | ref | actor_timestamp | actor_timestamp | 8 | const | 22519407 | Using where; Using index |
| 1 | SIMPLE | temp_rev_comment | ref | PRIMARY,revcomment_rev | PRIMARY | 4 | arwiki.temp_rev_user.revactor_rev | 1 | Using index |
| 1 | SIMPLE | comment_rev_comment | eq_ref | PRIMARY | PRIMARY | 8 | arwiki.temp_rev_comment.revcomment_comment_id | 1 | |
| 1 | SIMPLE | revision | eq_ref | PRIMARY,page_timestamp,rev_page_id,rev_page_actor_timestamp | PRIMARY | 4 | arwiki.temp_rev_user.revactor_rev | 1 | Using where |
| 1 | SIMPLE | page | eq_ref | PRIMARY | PRIMARY | 4 | arwiki.revision.rev_page | 1 | |
+------+-------------+---------------------+--------+-------------------------------------------------------------+-----------------+---------+-----------------------------------------------+----------+--------------------------+
6 rows in set (0.001 sec)
Mariadb 10.4
root@db1090.eqiad.wmnet[arwiki]> explain SELECT /* ApiQueryUserContribs::execute */ rev_id, rev_page, rev_timestamp, rev_minor_edit, rev_deleted, rev_len, rev_parent_id, rev_sha1, comment_rev_comment.comment_text AS `rev_comment_text`, comment_rev_comment.comment_data AS `rev_comment_data`, comment_rev_comment.comment_id AS `rev_comment_cid`, actor_rev_user.actor_user AS `rev_user`, actor_rev_user.actor_name AS `rev_user_text`, temp_rev_user.revactor_actor AS `rev_actor`, page_namespace, page_title, page_id, page_latest, page_is_redirect, page_len FROM `revision` JOIN `revision_comment_temp` `temp_rev_comment` ON ((temp_rev_comment.revcomment_rev = rev_id)) JOIN `comment` `comment_rev_comment` ON ((comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id)) JOIN `revision_actor_temp` `temp_rev_user` force index (actor_timestamp) ON ((temp_rev_user.revactor_rev = rev_id)) JOIN `actor` `actor_rev_user` ON ((actor_rev_user.actor_id = temp_rev_user.revactor_actor)) JOIN `page` ON ((page_id = rev_page)) WHERE ((temp_rev_user.revactor_actor = 8)) AND ((rev_deleted & 4) != 4) ORDER BY revactor_timestamp, revactor_rev LIMIT 2;
+------+-------------+---------------------+--------+-------------------------------------------------------------+-----------------+---------+-----------------------------------------------+----------+--------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------+-------------+---------------------+--------+-------------------------------------------------------------+-----------------+---------+-----------------------------------------------+----------+--------------------------+
| 1 | SIMPLE | actor_rev_user | const | PRIMARY | PRIMARY | 8 | const | 1 | |
| 1 | SIMPLE | temp_rev_user | ref | actor_timestamp | actor_timestamp | 8 | const | 22436878 | Using where; Using index |
| 1 | SIMPLE | temp_rev_comment | eq_ref | PRIMARY,revcomment_rev | revcomment_rev | 4 | arwiki.temp_rev_user.revactor_rev | 1 | Using index |
| 1 | SIMPLE | comment_rev_comment | eq_ref | PRIMARY | PRIMARY | 8 | arwiki.temp_rev_comment.revcomment_comment_id | 1 | |
| 1 | SIMPLE | revision | eq_ref | PRIMARY,page_timestamp,rev_page_id,rev_page_actor_timestamp | PRIMARY | 4 | arwiki.temp_rev_user.revactor_rev | 1 | Using where |
| 1 | SIMPLE | page | eq_ref | PRIMARY | PRIMARY | 4 | arwiki.revision.rev_page | 1 | |
+------+-------------+---------------------+--------+-------------------------------------------------------------+-----------------+---------+-----------------------------------------------+----------+--------------------------+
6 rows in set (0.004 sec)
root@db1090.eqiad.wmnet[arwiki]>
Event Timeline
Marostegui
created this paste.
Dec 17 2020, 1:08 PM
2020-12-17 13:08:30 (UTC+0)
Log In to Comment