Lucas_Werkmeister_WMDE added a comment.
Yeah, I don’t think the `wb_changes_change_revision_id` is used for that view.
MariaDB [wikidatawiki]> explain select change_id, change_type, change_time,
change_object_id, change_revision_id, if(rev_deleted&4 OR
ar_deleted&4,null,change_user_id) as change_user_id, if(rev_deleted&6 OR
ar_deleted&6,null,change_info) as change_info from wb_changes left join
revision on rev_id = change_revision_id left join archive on ar_rev_id =
change_revision_id limit 10;
+------+-------------+------------+--------+---------------+---------------+---------+--------------------------------------------+------+-------+
| id | select_type | table | type | possible_keys | key
| key_len | ref | rows | Extra |
+------+-------------+------------+--------+---------------+---------------+---------+--------------------------------------------+------+-------+
| 1 | SIMPLE | wb_changes | ALL | NULL | NULL
| NULL | NULL | 7 | |
| 1 | SIMPLE | revision | eq_ref | PRIMARY | PRIMARY
| 4 | wikidatawiki.wb_changes.change_revision_id | 1 | |
| 1 | SIMPLE | archive | eq_ref | ar_revid_uniq | ar_revid_uniq
| 4 | wikidatawiki.wb_changes.change_revision_id | 1 | |
+------+-------------+------------+--------+---------------+---------------+---------+--------------------------------------------+------+-------+
TASK DETAIL
https://phabricator.wikimedia.org/T292548
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Lucas_Werkmeister_WMDE
Cc: Lucas_Werkmeister_WMDE, Aklapper, Michael, karapayneWMDE, Invadibot,
maantietaja, Akuckartz, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden,
LawExplorer, _jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude,
Lydia_Pintscher, Addshore, Mbch331
_______________________________________________
Wikidata-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]
