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