View source for 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