Marostegui added subscribers: Anomie, Marostegui.
Marostegui added a comment.
This is the explain for wikidatawiki:
+------+--------------------+---------------------+--------+----------------------------------------------------------------------+-----------------------+---------+-----------------------------------------------------+----------+--------------------------+
| id | select_type | table | type | possible_keys
| key |
key_len | ref | rows |
Extra |
+------+--------------------+---------------------+--------+----------------------------------------------------------------------+-----------------------+---------+-----------------------------------------------------+----------+--------------------------+
| 1 | PRIMARY | actor_rev_user | const | PRIMARY
| PRIMARY |
8 | const | 1 |
|
| 1 | PRIMARY | user | const | PRIMARY
| PRIMARY |
4 | const | 1 |
|
| 1 | PRIMARY | temp_rev_user | ref |
actor_timestamp |
actor_timestamp | 8 | const
| 45815350 | Using where; Using index |
| 1 | PRIMARY | revision | eq_ref |
PRIMARY,rev_timestamp,page_timestamp,page_user_timestamp,rev_page_id | PRIMARY
| 4 | wikidatawiki.temp_rev_user.revactor_rev |
1 | Using where |
| 1 | PRIMARY | ores_damaging_cls | eq_ref |
oresc_rev_model_class |
oresc_rev_model_class | 7 |
wikidatawiki.temp_rev_user.revactor_rev,const,const | 1 |
|
| 1 | PRIMARY | page | eq_ref | PRIMARY
| PRIMARY |
4 | wikidatawiki.revision.rev_page | 1 |
|
| 1 | PRIMARY | temp_rev_comment | ref |
PRIMARY,revcomment_rev | PRIMARY
| 4 | wikidatawiki.temp_rev_user.revactor_rev |
1 | Using index |
| 1 | PRIMARY | comment_rev_comment | eq_ref | PRIMARY
| PRIMARY |
8 | wikidatawiki.temp_rev_comment.revcomment_comment_id | 1 |
|
| 2 | DEPENDENT SUBQUERY | change_tag | ref |
change_tag_rev_tag_id,change_tag_tag_id_id |
change_tag_rev_tag_id | 5 | wikidatawiki.revision.rev_id
| 1 | Using index |
| 2 | DEPENDENT SUBQUERY | change_tag_def | eq_ref | PRIMARY
| PRIMARY |
4 | wikidatawiki.change_tag.ct_tag_id | 1 |
|
+------+--------------------+---------------------+--------+----------------------------------------------------------------------+-----------------------+---------+-----------------------------------------------------+----------+--------------------------+
10 rows in set (0.01 sec)
TASK DETAIL
https://phabricator.wikimedia.org/T221380
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Marostegui
Cc: Marostegui, Anomie, Daimona, matej_suchanek, MisterSynergy, Framawiki,
TerraCodes, Liuxinyu970226, Aklapper, Jc86035, alaa_wmde, DannyS712, Nandana,
Lahi, Gq86, Lsherwinforone, GoranSMilovanovic, Jayprakash12345, QZanden,
LawExplorer, Sethakill, _jensen, rosalieper, Wong128hk, Wikidata-bugs, aude,
Mbch331
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
