Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P8557
enwiki revision table full table scan explain rows
Active
Public
Actions
Authored by
Volans
on May 23 2019, 10:20 AM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Referenced Files
F29220739: raw.txt
May 23 2019, 10:20 AM
2019-05-23 10:20:55 (UTC+0)
Subscribers
None
db[2072,2112,2116].codfw.wmnet
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE revision ALL NULL NULL NULL NULL 717692523 Using where
db1067.eqiad.wmnet
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE revision ALL NULL NULL NULL NULL 717584975 Using where
db1134.eqiad.wmnet
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE revision ALL NULL NULL NULL NULL 800419243 Using where
db2055.codfw.wmnet
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE revision ALL NULL NULL NULL NULL 812699059 Using where
db1083.eqiad.wmnet
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE revision ALL NULL NULL NULL NULL 800419235 Using where
db1089.eqiad.wmnet
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE revision ALL NULL NULL NULL NULL 817279524 Using where
db2048.codfw.wmnet
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE revision ALL NULL NULL NULL NULL 829847800 Using where
db1106.eqiad.wmnet
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE revision ALL NULL NULL NULL NULL 800358343 Using where
db2071.codfw.wmnet
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE revision ALL NULL NULL NULL NULL 809464457 Using where
db[2062,2092].codfw.wmnet
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE revision ALL NULL NULL NULL NULL 771602630 Using where
db1118.eqiad.wmnet
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE revision ALL NULL NULL NULL NULL 785385545 Using where
db1119.eqiad.wmnet
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE revision ALL NULL NULL NULL NULL 805311460 Using where
db1080.eqiad.wmnet
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE revision ALL NULL NULL NULL NULL 830807594 Using where
db2103.codfw.wmnet
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE revision ALL NULL NULL NULL NULL 830575333 Using where
Event Timeline
Volans
created this paste.
May 23 2019, 10:20 AM
2019-05-23 10:20:55 (UTC+0)
Volans
mentioned this in
T224017: Slow query ApiQueryRevisions on enwiki
.
May 23 2019, 10:30 AM
2019-05-23 10:30:04 (UTC+0)
Log In to Comment