MariaDB/query performance/coreproduction-main-20170207
db1089
1 day of queries, sampled at 1/100:
# 1670.2s user time, 3.2s system time, 228.34M rss, 291.58M vsz
# Current date: Wed Feb 8 18:12:21 2017
# Hostname: db1089
# Files: STDIN
# Overall: 10.39M total, 1.14k unique, 120.42 QPS, 0.02x concurrency _____
# Time range: 2017-02-07 14:43:51 to 2017-02-08 14:42:17
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 1815s 1us 2s 174us 445us 862us 113us
# Lock time 456s 0 8ms 43us 76us 109us 33us
# Rows sent 16.77M 0 3.45k 1.69 3.89 14.11 0.99
# Rows examine 52.55M 0 6.14M 5.30 13.83 1.95k 0.99
# Merge passes 0 0 0 0 0 0 0
# Query size 1.81G 8 81.54k 186.60 441.81 390.17 151.03
# Boolean:
# Filesort 85% yes, 14% no
# Full scan 98% yes, 1% no
# Priority que 84% yes, 15% no
# Tmp table 2% yes, 97% no
# Tmp table on 0% yes, 99% no
# Profile
# Rank Query ID Response time Calls R/Call V/M Item
# ==== ================== ============== ======= ====== ===== ============
# 1 0xSANITIZED 411.7317 22.7% 2388097 0.0002 0.00 SELECT page
# 2 0xSANITIZED 135.0172 7.4% 688675 0.0002 0.00 SELECT page
# 3 0xSANITIZED 132.4130 7.3% 721116 0.0002 0.00 SELECT heartbeat.heartbeat
# 4 0xSANITIZED 79.1531 4.4% 185390 0.0004 0.00 SELECT page
# 5 0xSANITIZED 77.0136 4.2% 101100 0.0008 0.00 SELECT redirect page
# 6 0xSANITIZED 67.9033 3.7% 100997 0.0007 0.00 SELECT page_props
# 7 0xSANITIZED 44.9982 2.5% 65863 0.0007 0.00 SELECT page page_props
# 8 0xSANITIZED 43.3802 2.4% 162336 0.0003 0.00 SELECT page_props
# 9 0xSANITIZED 40.8492 2.3% 285934 0.0001 0.00 SELECT user
# 10 0xSANITIZED 38.6305 2.1% 731282 0.0001 0.00 SET
# 11 0xSANITIZED 35.4164 2.0% 94114 0.0004 0.00 SELECT page_props
# 12 0xSANITIZED 31.1360 1.7% 148009 0.0002 0.00 SELECT page revision
# 13 0xSANITIZED 30.8223 1.7% 156899 0.0002 0.00 SELECT page_restrictions
# 14 0xSANITIZED 29.4367 1.6% 97956 0.0003 0.00 SELECT page flaggedpages flaggedpage_config
# 15 0xSANITIZED 27.3598 1.5% 79427 0.0003 0.00 SELECT page
# 16 0xSANITIZED 22.0859 1.2% 56258 0.0004 0.00 SELECT page_props
# 17 0xSANITIZED 21.3652 1.2% 120666 0.0002 0.00 SELECT user_newtalk
# 18 0xSANITIZED 20.0430 1.1% 50747 0.0004 0.00 SELECT revision page user
# 19 0xSANITIZED 19.6389 1.1% 660776 0.0000 0.00 COMMIT
# 20 0xSANITIZED 19.5793 1.1% 1966 0.0100 0.00 SELECT page
# 21 0xSANITIZED 19.5613 1.1% 105162 0.0002 0.00 SELECT redirect page
# 22 0xSANITIZED 18.6875 1.0% 138469 0.0001 0.00 SELECT text
...
# 76 0xSANITIZED 2.4706 0.1% 1 2.4706 0.00 SELECT page page_restrictions log_search logging
...
# 154 0xSANITIZED 0.2920 0.0% 1 0.2920 0.00 SELECT querycachetwo user recentchanges ipblocks
...
# 172 0xSANITIZED 0.2205 0.0% 1 0.2205 0.00 SELECT pagetriage_page page
...
# 195 0xSANITIZED 0.1629 0.0% 1 0.1629 0.00 SELECT pagetriage_page page
# 196 0xSANITIZED 0.1622 0.0% 1 0.1622 0.00 SELECT pagetriage_page page
...
# Query 1: 27.67 QPS, 0.00x concurrency, ID 0xSANITIZED at byte 2132000035
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2017-02-07 14:43:51 to 2017-02-08 14:42:17
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 22 2388097
# Exec time 22 412s 41us 5ms 172us 301us 210us 125us
# Lock time 29 137s 13us 4ms 57us 108us 115us 36us
# Rows sent 12 2.08M 0 1 0.92 0.99 0.28 0.99
# Rows examine 3 2.08M 0 1 0.92 0.99 0.28 0.99
# Query size 23 441.09M 176 429 193.68 212.52 11.48 183.58
# String:
# Databases enwiki
# Hosts 10.64.16.54 (36184/1%), 10.64.16.55 (36040/1%)... 128 more
# Users wikiuser
# Query_time distribution
# 1us
# 10us ######
# 100us ################################################################
# 1ms #
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `enwiki` LIKE 'page'\G
# SHOW CREATE TABLE `enwiki`.`page`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /* LinkCache::fetchPageRow */ page_id,page_len,page_is_redirect,page_latest,page_content_model FROM `page`
WHERE page_namespace = '828' AND page_title = 'WPMILHIST_Infobox_style' LIMIT 1\G
# Query 2: 7.98 QPS, 0.00x concurrency, ID 0xSANITIZED at byte 2413960693
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2017-02-07 14:43:51 to 2017-02-08 14:42:17
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 6 688675
# Exec time 7 135s 64us 4ms 196us 348us 229us 144us
# Lock time 9 44s 17us 3ms 63us 89us 126us 40us
# Rows sent 3 648.30k 0 1 0.96 0.99 0.18 0.99
# Rows examine 1 648.30k 0 1 0.96 0.99 0.18 0.99
# Query size 10 189.82M 270 516 289.01 299.03 11.75 284.79
# String:
# Databases enwiki
# Hosts 10.64.16.50 (16060/2%), 10.64.16.53 (16027/2%)... 138 more
# Users wikiuser
# Query_time distribution
# 1us
# 10us #
# 100us ################################################################
# 1ms #
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `enwiki` LIKE 'page'\G
# SHOW CREATE TABLE `enwiki`.`page`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /* WikiPage::pageData */ page_id,page_namespace,page_title,page_restrictions,page_is_redirect,page_is_new,page_random,page_touched,page_links_updated,page_latest,page_len,page_content_model
FROM `page` WHERE page_namespace = '0' AND page_title = 'Diane_Farr' LIMIT 1\G
# Query 3: 8.36 QPS, 0.00x concurrency, ID 0xSANITIZED at byte 2807332459
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2017-02-07 14:43:51 to 2017-02-08 14:42:17
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 6 721116
# Exec time 7 132s 58us 4ms 183us 287us 212us 138us
# Lock time 9 44s 18us 4ms 61us 69us 116us 44us
# Rows sent 4 704.21k 1 1 1 1 0 1
# Rows examine 18 9.63M 14 14 14 14 0 14
# Merge passes 0 0 0 0 0 0 0 0
# Query size 4 86.66M 126 144 126.01 124.25 0.37 124.25
# Boolean:
# Filesort 100% yes, 0% no
# Full scan 100% yes, 0% no
# Priority que 100% yes, 0% no
# String:
# Databases enwiki
# Hosts 10.64.16.55 (13262/1%), 10.64.0.74 (13259/1%)... 140 more
# Users wikiuser (721104/99%), wikiadmin (12/0%)
# Query_time distribution
# 1us
# 10us #
# 100us ################################################################
# 1ms #
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `heartbeat` LIKE 'heartbeat'\G
# SHOW CREATE TABLE `heartbeat`.`heartbeat`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /* Database::query */ ts FROM heartbeat.heartbeat WHERE shard = 's1' AND datacenter = 'eqiad'
ORDER BY ts DESC LIMIT 1\G
# Query 4: 2.15 QPS, 0.00x concurrency, ID 0xSANITIZED at byte 839990925
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2017-02-07 14:43:51 to 2017-02-08 14:42:17
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 185390
# Exec time 4 79s 97us 21ms 426us 972us 516us 301us
# Lock time 3 14s 22us 3ms 74us 131us 133us 49us
# Rows sent 12 2.06M 0 1001 11.67 24.84 20.80 9.83
# Rows examine 3 2.06M 0 1001 11.67 24.84 20.80 9.83
# Query size 4 86.99M 204 39.04k 492.01 793.42 520.27 420.77
# String:
# Databases enwiki
# Hosts 10.64.16.54 (5036/2%), 10.64.0.74 (4997/2%)... 128 more
# Users wikiuser
# Query_time distribution
# 1us
# 10us #
# 100us ################################################################
# 1ms ###
# 10ms #
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `enwiki` LIKE 'page'\G
# SHOW CREATE TABLE `enwiki`.`page`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /* LinkHolderArray::replaceInternal */ page_id,page_len,page_is_redirect,page_latest,page_content_model,page_namespace,page_title
FROM `page` WHERE (page_namespace = '0' AND page_title IN ( ***1000 comma-separated string titles***) )\G
# Query 5: 1.17 QPS, 0.00x concurrency, ID 0xSANITIZED at byte 2661632618
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2017-02-07 14:43:51 to 2017-02-08 14:42:17
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 101100
# Exec time 4 77s 97us 14ms 761us 3ms 1ms 301us
# Lock time 2 11s 25us 3ms 104us 316us 179us 57us
# Rows sent 3 573.02k 0 957 5.80 24.84 15.37 1.96
# Rows examine 2 1.12M 0 1.87k 11.61 51.63 31.22 3.89
# Query size 3 70.46M 209 10.94k 730.74 3.04k 1.14k 313.99
# String:
# Databases enwiki
# Hosts 10.64.16.54 (1669/1%), 10.64.16.53 (1649/1%)... 130 more
# Users wikiuser
# Query_time distribution
# 1us
# 10us #
# 100us ################################################################
# 1ms #############
# 10ms #
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `enwiki` LIKE 'redirect'\G
# SHOW CREATE TABLE `enwiki`.`redirect`\G
# SHOW TABLE STATUS FROM `enwiki` LIKE 'page'\G
# SHOW CREATE TABLE `enwiki`.`page`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /* DisambiguatorHooks::filterDisambiguationPageIds */ page_id,rd_from
FROM `redirect` INNER JOIN `page` ON ((rd_namespace=page_namespace) AND (rd_title=page_title))
WHERE rd_from IN (***1000 comma-separated page ids***)\G
# Query 6: 1.17 QPS, 0.00x concurrency, ID 0xSANITIZED at byte 76586862
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2017-02-07 14:43:52 to 2017-02-08 14:42:14
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 100997
# Exec time 3 68s 94us 12ms 672us 3ms 1ms 273us
# Lock time 1 8s 17us 3ms 80us 236us 160us 42us
# Rows sent 0 15.06k 0 217 0.15 0.99 1.39 0
# Rows examine 0 15.06k 0 217 0.15 0.99 1.39 0
# Query size 3 64.75M 161 10.89k 672.29 2.89k 1.13k 271.23
# String:
# Databases enwiki
# Hosts 10.64.16.52 (1700/1%), 10.64.16.50 (1676/1%)... 129 more
# Users wikiuser
# Query_time distribution
# 1us
# 10us #
# 100us ################################################################
# 1ms ###########
# 10ms #
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `enwiki` LIKE 'page_props'\G
# SHOW CREATE TABLE `enwiki`.`page_props`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /* DisambiguatorHooks::filterDisambiguationPageIds */ pp_page
FROM `page_props`
WHERE pp_page IN (***1000 comma-separated page ids***) AND pp_propname = 'disambiguation'\G
# Query 7: 0.76 QPS, 0.00x concurrency, ID 0xSANITIZED at byte 1973278259
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2017-02-07 14:43:52 to 2017-02-08 14:42:16
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 65863
# Exec time 2 45s 191us 9ms 683us 2ms 502us 515us
# Lock time 1 6s 27us 6ms 92us 204us 145us 60us
# Rows sent 4 727.25k 1 224 11.31 30.19 10.18 7.70
# Rows examine 1 1.01M 1 235 16.06 44.60 14.88 10.84
# Query size 2 43.83M 321 6.18k 697.79 1.39k 378.34 563.87
# String:
# Databases enwiki
# Hosts 10.64.0.56 (1442/2%), 10.64.0.61 (1406/2%)... 105 more
# Users wikiuser
# Query_time distribution
# 1us
# 10us
# 100us ################################################################
# 1ms ##########
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `enwiki` LIKE 'page'\G
# SHOW CREATE TABLE `enwiki`.`page`\G
# SHOW TABLE STATUS FROM `enwiki` LIKE 'page_props'\G
# SHOW CREATE TABLE `enwiki`.`page_props`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /* OutputPage::addCategoryLinksToLBAndGetResult */ page_id,page_len,page_is_redirect,page_latest,page_content_model,page_namespace,page_title,pp_value
FROM `page` LEFT JOIN `page_props` ON (pp_propname = 'hiddencat' AND (pp_page = page_id))
WHERE (page_namespace = '14' AND page_title IN ( ***1000 comma-separated string titles***)\G
# Query 8: 1.88 QPS, 0.00x concurrency, ID 0xSANITIZED at byte 459735077
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2017-02-07 14:43:51 to 2017-02-08 14:42:17
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 162336
# Exec time 2 43s 84us 4ms 267us 490us 266us 194us
# Lock time 2 10s 15us 3ms 59us 76us 122us 38us
# Rows sent 0 53.36k 0 1 0.34 0.99 0.47 0
# Rows examine 0 53.36k 0 1 0.34 0.99 0.47 0
# Query size 1 27.37M 173 180 176.78 174.84 3.50 174.84
# String:
# Databases enwiki
# Hosts 10.64.0.69 (2929/1%), 10.64.0.58 (2923/1%)... 123 more
# Users wikiuser
# Query_time distribution
# 1us
# 10us #
# 100us ################################################################
# 1ms #
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `enwiki` LIKE 'page_props'\G
# SHOW CREATE TABLE `enwiki`.`page_props`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /* PageImages::getPageImage */ pp_value FROM `page_props`
WHERE pp_page = '***page id***' AND pp_propname IN ('page_image','page_image_free')
ORDER BY pp_propname LIMIT 1\G
# Query 9: 3.31 QPS, 0.00x concurrency, ID 0xSANITIZED at byte 3659878952
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2017-02-07 14:43:51 to 2017-02-08 14:42:17
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 285934
# Exec time 2 41s 36us 3ms 142us 260us 196us 98us
# Lock time 3 15s 12us 3ms 52us 60us 112us 33us
# Rows sent 1 274.82k 0 1 0.98 0.99 0.12 0.99
# Rows examine 0 274.82k 0 1 0.98 0.99 0.12 0.99
# Query size 1 26.32M 86 167 96.52 107.34 6.49 92.72
# String:
# Databases enwiki
# Hosts 10.64.16.106 (6116/2%), 10.64.32.31 (5655/1%)... 128 more
# Users wikiuser
# Query_time distribution
# 1us
# 10us ##############################################
# 100us ################################################################
# 1ms #
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `enwiki` LIKE 'user'\G
# SHOW CREATE TABLE `enwiki`.`user`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /* User::idFromName */ user_id FROM `user`
WHERE user_name = '***anonymous user name***' LIMIT 1\G
# Query 10: 8.47 QPS, 0.00x concurrency, ID 0xSANITIZED at byte 1886098029
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2017-02-07 14:43:51 to 2017-02-08 14:42:17
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 7 731282
# Exec time 2 39s 13us 6ms 52us 60us 102us 38us
# Lock time 0 0 0 0 0 0 0 0
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Query size 3 56.49M 81 81 81 81 0 81
# String:
# Databases enwiki (731280/99%), informatio... (2/0%)
# Hosts 10.64.16.51 (13273/1%), 10.64.16.50 (13085/1%)... 140 more
# Users wikiuser (731272/99%), wikiadmin (10/0%)
# Query_time distribution
# 1us
# 10us ################################################################
# 100us #
# 1ms #
# 10ms
# 100ms
# 1s
# 10s+
SET group_concat_max_len = 262144, sql_mode = , `innodb_lock_wait_timeout` = 15\G
# Query 11: 1.09 QPS, 0.00x concurrency, ID 0xSANITIZED at byte 1234445189
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2017-02-07 14:43:52 to 2017-02-08 14:42:17
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 94114
# Exec time 1 35s 114us 4ms 376us 799us 337us 273us
# Lock time 1 6s 17us 3ms 66us 176us 127us 40us
# Rows sent 5 954.10k 0 100 10.38 22.53 6.55 5.75
# Rows examine 1 954.10k 0 100 10.38 22.53 6.55 5.75
# Query size 1 24.54M 184 1.21k 273.43 381.65 65.47 234.30
# String:
# Databases enwiki
# Hosts 10.64.0.73 (2824/3%), 10.64.16.51 (2818/2%)... 48 more
# Users wikiuser
# Query_time distribution
# 1us
# 10us
# 100us ################################################################
# 1ms ##
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `enwiki` LIKE 'page_props'\G
# SHOW CREATE TABLE `enwiki`.`page_props`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /* Wikibase\Client\Store\Sql\PagePropsEntityIdLookup::getEntityIds */ pp_page,pp_value
FROM `page_props` WHERE pp_page IN (***15 page ids***) AND pp_propname = 'wikibase_item'\G
# Query 12: 1.71 QPS, 0.00x concurrency, ID 0xSANITIZED at byte 2366708632
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2017-02-07 14:43:52 to 2017-02-08 14:42:16
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 148009
# Exec time 1 31s 70us 5ms 210us 424us 238us 152us
# Lock time 2 10s 19us 3ms 70us 185us 134us 44us
# Rows sent 0 144.54k 1 1 1 1 0 1
# Rows examine 0 144.54k 1 1 1 1 0 1
# Query size 1 26.96M 188 191 190.99 183.58 0 183.58
# String:
# Databases enwiki
# Hosts 10.64.0.78 (2447/1%), 10.64.16.54 (2384/1%)... 128 more
# Users wikiuser
# Query_time distribution
# 1us
# 10us #
# 100us ################################################################
# 1ms #
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `enwiki` LIKE 'page'\G
# SHOW CREATE TABLE `enwiki`.`page`\G
# SHOW TABLE STATUS FROM `enwiki` LIKE 'revision'\G
# SHOW CREATE TABLE `enwiki`.`revision`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /* Revision::getTitle */ page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len
FROM `page`,`revision` WHERE (page_id=rev_page) AND rev_id = '*** revision id***' LIMIT 1\G
# Query 13: 1.82 QPS, 0.00x concurrency, ID 0xSANITIZED at byte 487605545
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2017-02-07 14:43:51 to 2017-02-08 14:42:14
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 156899
# Exec time 1 31s 68us 4ms 196us 332us 237us 144us
# Lock time 1 8s 15us 3ms 51us 54us 115us 31us
# Rows sent 0 498 0 2 0.00 0 0.08 0
# Rows examine 0 498 0 2 0.00 0 0.08 0
# Query size 1 18.65M 120 125 124.63 124.25 2.50 124.25
# String:
# Databases enwiki
# Hosts 10.64.16.54 (3118/1%), 10.64.16.52 (3103/1%)... 128 more
# Users wikiuser
# Query_time distribution
# 1us
# 10us #
# 100us ################################################################
# 1ms #
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `enwiki` LIKE 'page_restrictions'\G
# SHOW CREATE TABLE `enwiki`.`page_restrictions`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /* Title::{closure} */ pr_type,pr_expiry,pr_level,pr_cascade
FROM `page_restrictions` WHERE pr_page = '*** page id***'\G
# Query 14: 1.14 QPS, 0.00x concurrency, ID 0xSANITIZED at byte 1801504797
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2017-02-07 14:43:52 to 2017-02-08 14:42:15
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 97956
# Exec time 1 29s 100us 7ms 300us 626us 292us 214us
# Lock time 2 10s 32us 3ms 103us 224us 164us 66us
# Rows sent 0 85.97k 0 1 0.90 0.99 0.30 0.99
# Rows examine 0 85.97k 0 1 0.90 0.99 0.30 0.99
# Query size 2 45.25M 465 711 484.37 487.09 13.83 463.90
# String:
# Databases enwiki
# Hosts 10.64.0.66 (2062/2%), 10.64.0.65 (2033/2%)... 130 more
# Users wikiuser
# Query_time distribution
# 1us
# 10us
# 100us ################################################################
# 1ms ##
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `enwiki` LIKE 'page'\G
# SHOW CREATE TABLE `enwiki`.`page`\G
# SHOW TABLE STATUS FROM `enwiki` LIKE 'flaggedpages'\G
# SHOW CREATE TABLE `enwiki`.`flaggedpages`\G
# SHOW TABLE STATUS FROM `enwiki` LIKE 'flaggedpage_config'\G
# SHOW CREATE TABLE `enwiki`.`flaggedpage_config`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /* FlaggableWikiPage::pageData */ page_id,page_namespace,page_title,page_restrictions,page_is_redirect,page_is_new,page_random,page_touched,page_links_updated,page_latest,page_len,page_content_model,fpc_override,fpc_level,fpc_expiry,fp_pending_since,fp_stable,fp_reviewed
FROM `page` LEFT JOIN `flaggedpages` ON ((fp_page_id = page_id)) LEFT JOIN `flaggedpage_config` ON ((fpc_page_id = page_id))
WHERE page_namespace = '6' AND page_title = '*** page title string ***' LIMIT 1\G
# Query 15: 0.92 QPS, 0.00x concurrency, ID 0xSANITIZED at byte 580292246
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2017-02-07 14:43:52 to 2017-02-08 14:42:15
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 79427
# Exec time 1 27s 124us 4ms 344us 690us 314us 260us
# Lock time 1 6s 24us 3ms 79us 194us 149us 49us
# Rows sent 1 293.47k 3 45 3.78 3.89 0.47 3.89
# Rows examine 0 293.47k 3 45 3.78 3.89 0.47 3.89
# Query size 1 33.68M 392 1.30k 444.65 463.90 16.71 420.77
# String:
# Databases enwiki
# Hosts 10.64.0.65 (1675/2%), 10.64.0.62 (1670/2%)... 126 more
# Users wikiuser
# Query_time distribution
# 1us
# 10us
# 100us ################################################################
# 1ms ##
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `enwiki` LIKE 'page'\G
# SHOW CREATE TABLE `enwiki`.`page`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /* LinkBatch::doQuery (for Skin::preloadExistence) */
page_id,page_len,page_is_redirect,page_latest,page_content_model,page_namespace,page_title
FROM `page`
WHERE (page_namespace = '1' AND page_title = '*** page title string ***') OR
(page_namespace = '0' AND page_title = '*** page title string ***') OR
(page_namespace = '4' AND page_title IN ('*** page title string ***','*** page title string ***') ) OR
(page_namespace = '2' AND page_title = '*** page title string ***')\G
# Query 16: 0.65 QPS, 0.00x concurrency, ID 0xSANITIZED at byte 1657590515
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2017-02-07 14:43:51 to 2017-02-08 14:42:13
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 56258
# Exec time 1 22s 127us 9ms 392us 839us 368us 287us
# Lock time 0 4s 18us 3ms 70us 185us 139us 42us
# Rows sent 0 81.80k 0 489 1.49 5.75 3.71 0
# Rows examine 0 81.80k 0 489 1.49 5.75 3.71 0
# Query size 0 13.20M 157 5.08k 246.04 299.03 100.74 202.40
# String:
# Databases enwiki
# Hosts 10.64.16.51 (1755/3%), 10.64.16.52 (1741/3%)... 48 more
# Users wikiuser
# Query_time distribution
# 1us
# 10us
# 100us ################################################################
# 1ms ###
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `enwiki` LIKE 'page_props'\G
# SHOW CREATE TABLE `enwiki`.`page_props`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /* PageProps::getProperties */ pp_page,pp_propname,pp_value FROM `page_props`
WHERE pp_page IN (*** 463 page ids strings ***) AND pp_propname = 'disambiguation'\G
# Query 17: 1.40 QPS, 0.00x concurrency, ID 0xSANITIZED at byte 3585662189
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2017-02-07 14:43:51 to 2017-02-08 14:42:16
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 120666
# Exec time 1 21s 59us 4ms 177us 316us 222us 125us
# Lock time 1 6s 16us 3ms 52us 60us 115us 31us
# Rows sent 0 339 0 1 0.00 0 0.05 0
# Rows examine 0 339 0 1 0.00 0 0.05 0
# Query size 0 12.41M 101 132 107.87 124.25 6.81 102.22
# String:
# Databases enwiki
# Hosts 10.64.0.56 (2484/2%), 10.64.0.69 (2476/2%)... 123 more
# Users wikiuser
# Query_time distribution
# 1us
# 10us ##
# 100us ################################################################
# 1ms #
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `enwiki` LIKE 'user_newtalk'\G
# SHOW CREATE TABLE `enwiki`.`user_newtalk`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /* User::checkNewtalk */ user_ip FROM `user_newtalk`
WHERE user_ip = '*** user ip ***' LIMIT 1\G
# Query 18: 0.59 QPS, 0.00x concurrency, ID 0xSANITIZED at byte 3225039153
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2017-02-07 14:43:53 to 2017-02-08 14:42:14
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 50747
# Exec time 1 20s 127us 7ms 394us 881us 366us 260us
# Lock time 1 6s 38us 3ms 112us 224us 174us 76us
# Rows sent 0 49.56k 0 1 1.00 0.99 0.01 0.99
# Rows examine 0 49.56k 0 1 1.00 0.99 0.01 0.99
# Query size 1 24.46M 494 506 505.39 487.09 0 487.09
# String:
# Databases enwiki
# Hosts 10.64.32.34 (738/1%), 10.64.32.32 (705/1%)... 128 more
# Users wikiuser
# Query_time distribution
# 1us
# 10us
# 100us ################################################################
# 1ms ###
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `enwiki` LIKE 'revision'\G
# SHOW CREATE TABLE `enwiki`.`revision`\G
# SHOW TABLE STATUS FROM `enwiki` LIKE 'page'\G
# SHOW CREATE TABLE `enwiki`.`page`\G
# SHOW TABLE STATUS FROM `enwiki` LIKE 'user'\G
# SHOW CREATE TABLE `enwiki`.`user`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /* Revision::fetchFromConds */ rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,rev_content_format,rev_content_model,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name
FROM `revision` INNER JOIN `page` ON ((page_id = rev_page)) LEFT JOIN `user` ON ((rev_user != 0) AND (user_id = rev_user))
WHERE rev_page = '*** page id ***' AND page_id = '*** same page id ***' AND rev_id = '*** revision id ***' LIMIT 1\G
# Query 19: 7.66 QPS, 0.00x concurrency, ID 0xSANITIZED at byte 823040584
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2017-02-07 14:43:51 to 2017-02-08 14:42:17
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 6 660776
# Exec time 1 20s 4us 3ms 29us 33us 74us 17us
# Lock time 0 0 0 0 0 0 0 0
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Query size 0 18.38M 29 47 29.17 28.75 1.18 28.75
# String:
# Databases enwiki
# Hosts 10.64.16.55 (12669/1%), 10.64.16.49 (12643/1%)... 138 more
# Users wikiuser
# Query_time distribution
# 1us #
# 10us ################################################################
# 100us ##
# 1ms #
# 10ms
# 100ms
# 1s
# 10s+
COMMIT /* Database::close */\G
# Query 20: 0.02 QPS, 0.00x concurrency, ID 0xSANITIZED at byte 659445605
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2017-02-07 14:44:10 to 2017-02-08 14:41:42
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1966
# Exec time 1 20s 338us 22ms 10ms 12ms 3ms 10ms
# Lock time 0 1s 40us 3ms 540us 1ms 405us 445us
# Rows sent 5 980.10k 9 815 510.49 537.02 120.45 537.02
# Rows examine 1 980.10k 9 815 510.49 537.02 120.45 537.02
# Query size 1 24.75M 606 28.71k 12.89k 13.13k 2.91k 13.13k
# String:
# Databases enwiki
# Hosts 10.64.0.63 (49/2%), 10.64.0.65 (48/2%)... 94 more
# Users wikiuser
# Query_time distribution
# 1us
# 10us
# 100us ##
# 1ms #######################
# 10ms ################################################################
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `enwiki` LIKE 'page'\G
# SHOW CREATE TABLE `enwiki`.`page`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /* LinkHolderArray::replaceInternal */ page_id,page_len,page_is_redirect,page_latest,page_content_model,page_namespace,page_title
FROM `page`
WHERE (page_namespace = '0' AND page_title IN ( *** ~400 page titles ***) ) OR
(page_namespace = '4' AND page_title IN ( *** 800 page titles*** ) OR
(page_namespace = '5' AND page_title IN ( *** 2 page titles *** ) ) OR
(page_namespace = '12' AND page_title = '*** page title ***' ) OR
(page_namespace = '14' AND page_title = '*** page title ***')\G
# Query 21: 1.22 QPS, 0.00x concurrency, ID 0xSANITIZED at byte 3673875781
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2017-02-07 14:43:52 to 2017-02-08 14:42:12
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 105162
# Exec time 1 20s 62us 6ms 186us 384us 232us 131us
# Lock time 1 7s 21us 3ms 69us 176us 133us 44us
# Rows sent 0 1.40k 0 1 0.01 0 0.12 0
# Rows examine 0 1.40k 0 1 0.01 0 0.12 0
# Query size 1 20.27M 197 203 202.13 202.40 3 192.76
# String:
# Databases enwiki
# Hosts 10.64.0.70 (2190/2%), 10.64.0.69 (2130/2%)... 128 more
# Users wikiuser
# Query_time distribution
# 1us
# 10us #
# 100us ################################################################
# 1ms #
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `enwiki` LIKE 'redirect'\G
# SHOW CREATE TABLE `enwiki`.`redirect`\G
# SHOW TABLE STATUS FROM `enwiki` LIKE 'page'\G
# SHOW CREATE TABLE `enwiki`.`page`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /* DisambiguatorHooks::filterDisambiguationPageIds */ page_id,rd_from
FROM `redirect` INNER JOIN `page` ON ((rd_namespace=page_namespace) AND (rd_title=page_title))
WHERE rd_from = '*** page id ***'\G
# Query 22: 1.60 QPS, 0.00x concurrency, ID 0xSANITIZED at byte 3919960039
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2017-02-07 14:43:52 to 2017-02-08 14:42:17
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 138469
# Exec time 1 19s 45us 3ms 134us 273us 129us 103us
# Lock time 1 6s 15us 3ms 43us 54us 63us 33us
# Rows sent 0 135.20k 0 1 1.00 0.99 0.01 0.99
# Rows examine 0 135.20k 0 1 1.00 0.99 0.01 0.99
# Query size 0 13.95M 102 110 105.67 102.22 0.17 102.22
# String:
# Databases enwiki
# Hosts 10.64.0.9 (120231/86%), 10.64.32.32 (584/0%)... 129 more
# Users wikiadmin (120231/86%), wikiuser (18238/13%)
# Query_time distribution
# 1us
# 10us #####################################
# 100us ################################################################
# 1ms #
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `enwiki` LIKE 'text'\G
# SHOW CREATE TABLE `enwiki`.`text`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /* FetchText::doGetText */ old_text,old_flags FROM `text`
WHERE old_id = '*** text id ***' LIMIT 1\G
...
# Query 76: 0 QPS, 0x concurrency, ID 0xSANITIZED at byte 4154245286
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2017-02-08 14:23:38
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1
# Exec time 0 2s 2s 2s 2s 2s 0 2s
# Lock time 0 81us 81us 81us 81us 81us 0 81us
# Rows sent 0 51 51 51 51 51 0 51
# Rows examine 11 6.14M 6.14M 6.14M 6.14M 6.14M 0 6.14M
# Query size 0 466 466 466 466 466 0 466
# String:
# Databases enwiki
# Hosts 10.64.32.58
# Users wikiuser
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+
# Tables
# SHOW TABLE STATUS FROM `enwiki` LIKE 'page'\G
# SHOW CREATE TABLE `enwiki`.`page`\G
# SHOW TABLE STATUS FROM `enwiki` LIKE 'page_restrictions'\G
# SHOW CREATE TABLE `enwiki`.`page_restrictions`\G
# SHOW TABLE STATUS FROM `enwiki` LIKE 'log_search'\G
# SHOW CREATE TABLE `enwiki`.`log_search`\G
# SHOW TABLE STATUS FROM `enwiki` LIKE 'logging'\G
# SHOW CREATE TABLE `enwiki`.`logging`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /* IndexPager::buildQueryInfo (ProtectedPagesPager) */ pr_id,page_namespace,page_title,page_len,pr_type,pr_level,pr_expiry,pr_cascade,log_timestamp,log_user,log_comment,log_deleted
FROM `page`,`page_restrictions` LEFT JOIN `log_search` ON (ls_field = 'pr_id' AND (ls_value = pr_id)) LEFT JOIN `logging` ON ((ls_log_id = log_id))
WHERE (pr_expiry > '20170208142336' OR pr_expiry IS NULL) AND (page_id=pr_page) AND (pr_type='edit')
ORDER BY pr_id LIMIT 51\G
...
# Query 154: 0 QPS, 0x concurrency, ID 0xSANITIZED at byte 3281226737
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2017-02-08 08:49:32
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1
# Exec time 0 292ms 292ms 292ms 292ms 292ms 0 292ms
# Lock time 0 73us 73us 73us 73us 73us 0 73us
# Rows sent 0 101 101 101 101 101 0 101
# Rows examine 1 999.05k 999.05k 999.05k 999.05k 999.05k 0 999.05k
# Merge passes 0 0 0 0 0 0 0 0
# Query size 0 583 583 583 583 583 0 583
# Boolean:
# Full scan 100% yes, 0% no
# Tmp table 100% yes, 0% no
# String:
# Databases enwiki
# Hosts 10.64.32.49
# Users wikiuser
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `enwiki` LIKE 'querycachetwo'\G
# SHOW CREATE TABLE `enwiki`.`querycachetwo`\G
# SHOW TABLE STATUS FROM `enwiki` LIKE 'user'\G
# SHOW CREATE TABLE `enwiki`.`user`\G
# SHOW TABLE STATUS FROM `enwiki` LIKE 'recentchanges'\G
# SHOW CREATE TABLE `enwiki`.`recentchanges`\G
# SHOW TABLE STATUS FROM `enwiki` LIKE 'ipblocks'\G
# SHOW CREATE TABLE `enwiki`.`ipblocks`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /* IndexPager::buildQueryInfo (ActiveUsersPager) */ user_name,user_id,COUNT(*) AS `recentedits`,qcc_title
FROM `querycachetwo`,`user`,`recentchanges`
WHERE qcc_type = 'activeusers' AND qcc_namespace = '2' AND (user_name = qcc_title) AND (rc_user_text = qcc_title) AND (rc_type != '5') AND (rc_type != '6') AND (rc_log_type IS NULL OR rc_log_type != 'newusers') AND (rc_timestamp >= '20170109084931') AND (NOT EXISTS (SELECT 1 FROM `ipblocks` WHERE (ipb_user=user_id) AND ipb_deleted = '1' )) AND (qcc_title>'-sche')
GROUP BY qcc_title ORDER BY qcc_title LIMIT 101\G
...
# Query 172: 0 QPS, 0x concurrency, ID 0xSANITIZED at byte 1201408166
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2017-02-07 20:55:08
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1
# Exec time 0 221ms 221ms 221ms 221ms 221ms 0 221ms
# Lock time 0 52us 52us 52us 52us 52us 0 52us
# Rows sent 0 100 100 100 100 100 0 100
# Rows examine 0 78.21k 78.21k 78.21k 78.21k 78.21k 0 78.21k
# Merge passes 0 0 0 0 0 0 0 0
# Query size 0 403 403 403 403 403 0 403
# Boolean:
# Full scan 100% yes, 0% no
# String:
# Databases enwiki
# Hosts 10.64.32.13
# Users wikiadmin
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `enwiki` LIKE 'pagetriage_page'\G
# SHOW CREATE TABLE `enwiki`.`pagetriage_page`\G
# SHOW TABLE STATUS FROM `enwiki` LIKE 'page'\G
# SHOW CREATE TABLE `enwiki`.`page`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /* UpdatePageTriageQueue::execute */ ptrp_page_id,ptrp_created,page_namespace,ptrp_reviewed FROM `pagetriage_page`,`page` WHERE ((ptrp_created < '20170108102826') OR
(ptrp_created = '20170108102826' AND ptrp_page_id < 52807587)) AND (ptrp_page_id = page_id) AND (page_namespace != 0 OR ptrp_reviewed > 0 OR page_is_redirect = 1)
ORDER BY ptrp_created DESC, ptrp_page_id DESC LIMIT 100\G
...
# Query 195: 0 QPS, 0x concurrency, ID 0xSANITIZED at byte 2593918973
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2017-02-08 04:20:34
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1
# Exec time 0 163ms 163ms 163ms 163ms 163ms 0 163ms
# Lock time 0 27us 27us 27us 27us 27us 0 27us
# Rows sent 0 1 1 1 1 1 0 1
# Rows examine 0 105.71k 105.71k 105.71k 105.71k 105.71k 0 105.71k
# Query size 0 213 213 213 213 213 0 213
# String:
# Databases enwiki
# Hosts 10.64.0.72
# Users wikiuser
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `enwiki` LIKE 'pagetriage_page'\G
# SHOW CREATE TABLE `enwiki`.`pagetriage_page`\G
# SHOW TABLE STATUS FROM `enwiki` LIKE 'page'\G
# SHOW CREATE TABLE `enwiki`.`page`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /* Database::selectRow */ COUNT(ptrp_page_id) AS total
FROM `pagetriage_page`,`page`
WHERE (page_id = ptrp_page_id) AND page_namespace = '0' AND (ptrp_reviewed = 0) AND page_is_redirect = '0' LIMIT 1\G
# Query 196: 0 QPS, 0x concurrency, ID 0xSANITIZED at byte 2968282142
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2017-02-08 06:40:52
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1
# Exec time 0 162ms 162ms 162ms 162ms 162ms 0 162ms
# Lock time 0 49us 49us 49us 49us 49us 0 49us
# Rows sent 0 1 1 1 1 1 0 1
# Rows examine 0 105.98k 105.98k 105.98k 105.98k 105.98k 0 105.98k
# Query size 0 236 236 236 236 236 0 236
# String:
# Databases enwiki
# Hosts 10.64.0.209
# Users wikiuser
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `enwiki` LIKE 'pagetriage_page'\G
# SHOW CREATE TABLE `enwiki`.`pagetriage_page`\G
# SHOW TABLE STATUS FROM `enwiki` LIKE 'page'\G
# SHOW CREATE TABLE `enwiki`.`page`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /* Database::selectRow */ COUNT(ptrp_page_id) AS total FROM `pagetriage_page`,`page`
WHERE (page_id = ptrp_page_id) AND page_namespace = '0' AND (ptrp_reviewed = 0) AND ptrp_deleted = '0' AND page_is_redirect = '0'
LIMIT 1\G