MariaDB/query performance/coreproduction-main-20170207

From Wikitech
Jump to navigation Jump to search

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