Page MenuHomePhabricator
Paste P5915

(An Untitled Masterwork)
ActivePublic

Authored by Mattflaschen-WMF on Aug 24 2017, 7:02 PM.
mysql:wikiadmin@db1093 [ruwiki]> EXPLAIN SELECT rc_id,rc_timestamp,rc_user,rc_user_text,rc_namespace,rc_title,rc_comment,rc_minor,rc_bot,rc_new,rc_cur_id,rc_this_oldid,rc_last_oldid,rc_type,rc_source,rc_patrolled,rc_ip,rc_old_len,rc_new_len,rc_deleted,rc_logid,rc_log_type,rc_log_action,rc_params,wl_notificationtimestamp,page_latest FROM `recentchanges` INNER JOIN `watchlist` ON (wl_user = '529055' AND (wl_namespace=rc_namespace) AND (wl_title=rc_title)) LEFT JOIN `page` ON ((rc_cur_id=page_id)) WHERE (rc_type != '6') AND (rc_source != 'wb') AND (rc_timestamp > '20170716043245') AND ((rc_type != 3) OR ((rc_deleted & 1) != 1)) ORDER BY rc_timestamp DESC LIMIT 1000 \G
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: watchlist
type: ref
possible_keys: wl_user,namespace_title,wl_user_notificationtimestamp
key: wl_user
key_len: 4
ref: const
rows: 138546
Extra: Using temporary; Using filesort
*************************** 2. row ***************************
id: 1
select_type: SIMPLE
table: recentchanges
type: ref
possible_keys: rc_timestamp,rc_namespace_title,rc_ns_usertext,tmp_3,rc_name_type_patrolled_timestamp
key: rc_namespace_title
key_len: 261
ref: ruwiki.watchlist.wl_namespace,ruwiki.watchlist.wl_title
rows: 13
Extra: Using where
*************************** 3. row ***************************
id: 1
select_type: SIMPLE
table: page
type: eq_ref
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: ruwiki.recentchanges.rc_cur_id
rows: 1
Extra:
3 rows in set (0.00 sec)