pt-query-digest@17:02 - Githubissues


# 290ms user time, 20ms system time, 36.31M rss, 33.24G vsz
# Current date: Sat Jul  9 17:02:58 2022
# Hostname: kahma
# Files: log/0709-170240/slow.log
# Overall: 1.02k total, 7 unique, 15.77 QPS, 2.34x concurrency ___________
# Time range: 2022-07-09 17:01:29 to 17:02:34
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time           152s   100ms   646ms   148ms   219ms    55ms   134ms
# Lock time          147ms       0    16ms   143us   348us   861us    18us
# Rows sent        471.37k       0   1.54k  470.91   1.26k  480.02  299.03
# Rows examine      52.44M       0  73.43k  52.39k  68.96k  14.97k  54.03k
# Rows affecte          28       0      28    0.03       0    0.85       0
# Bytes sent        73.85M      11 248.29k  73.78k 201.74k  75.16k  46.68k
# Query size       917.36k       6 790.36k  916.47  151.03  23.51k  124.25

# Profile
# Rank Query ID                            Response time Calls R/Call V/M 
# ==== =================================== ============= ===== ====== ====
#    1 0x931A992E852C61FC6D46141A39DEF4FE  45.5692 30.0%   321 0.1420  0.01 SELECT isu_condition
#    2 0x8155B89FFD74A9D523D19AC409FD97AF  42.7226 28.1%   294 0.1453  0.01 SELECT isu_condition
#    3 0x9C6C682008AE0D08F3E2A0049B030C70  41.6065 27.4%   295 0.1410  0.01 SELECT isu_condition
#    4 0x5F580A12ADA1633C9634298BE5BD9422  10.6602  7.0%    75 0.1421  0.01 SELECT isu_condition
#    5 0xFFFCA4D67EA0A788813031B8BBC3B329  10.4907  6.9%    33 0.3179  0.09 COMMIT
# MISC 0xMISC                               0.9765  0.6%     7 0.1395   0.0 <2 ITEMS>

# Query 1: 7.64 QPS, 1.08x concurrency, ID 0x931A992E852C61FC6D46141A39DEF4FE at byte 1163629
# Scores: V/M = 0.01
# Time range: 2022-07-09 17:01:52 to 17:02:34
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         31     321
# Exec time     29     46s   100ms   307ms   142ms   208ms    36ms   128ms
# Lock time     34    51ms    12us    16ms   159us   204us     1ms    18us
# Rows sent     49 231.71k       6   1.54k  739.16   1.33k  504.38  874.75
# Rows examine  32  16.94M  21.25k  73.43k  54.04k  68.96k  11.88k  54.03k
# Rows affecte   0       0       0       0       0       0       0       0
# Bytes sent    48  35.81M   1.45k 248.29k 114.24k 211.82k  78.20k 136.54k
# Query size     3  36.05k     115     115     115     115       0     115
# String:
# Databases    isucondition
# Hosts        localhost
# Users        isucon
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms
#  10ms
# 100ms  ################################################################
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_condition'\G
#    SHOW CREATE TABLE `isucondition`.`isu_condition`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = '4e711bce-9a84-41cb-96b2-774d6e4445fe' ORDER BY timestamp DESC\G

# Query 2: 6.68 QPS, 0.97x concurrency, ID 0x8155B89FFD74A9D523D19AC409FD97AF at byte 1154876
# Scores: V/M = 0.01
# Time range: 2022-07-09 17:01:50 to 17:02:34
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         28     294
# Exec time     28     43s   100ms   318ms   145ms   208ms    37ms   134ms
# Lock time     39    58ms    10us     7ms   197us   384us   843us    18us
# Rows sent      0     294       1       1       1       1       0       1
# Rows examine  31  16.39M  18.05k  72.23k  57.08k  68.96k  11.36k  59.57k
# Rows affecte   0       0       0       0       0       0       0       0
# Bytes sent     0 213.80k     712     789  744.65  755.64   13.50  719.66
# Query size     3  35.89k     125     125     125     125       0     125
# String:
# Databases    isucondition
# Hosts        localhost
# Users        isucon
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms
#  10ms
# 100ms  ################################################################
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_condition'\G
#    SHOW CREATE TABLE `isucondition`.`isu_condition`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = 'df00a0ae-8c26-47fa-925b-140e262b7886' ORDER BY `timestamp` DESC LIMIT 1\G

# Query 3: 7.38 QPS, 1.04x concurrency, ID 0x9C6C682008AE0D08F3E2A0049B030C70 at byte 1091965
# Scores: V/M = 0.01
# Time range: 2022-07-09 17:01:54 to 17:02:34
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         28     295
# Exec time     27     42s   100ms   348ms   141ms   208ms    35ms   128ms
# Lock time     19    29ms    12us     6ms    99us   366us   411us    19us
# Rows sent     35 166.12k       0   1.44k  576.62   1.14k  344.74  537.02
# Rows examine  28  15.06M  23.74k  72.92k  52.28k  68.96k  11.63k  51.46k
# Rows affecte   0       0       0       0       0       0       0       0
# Bytes sent    35  26.07M     589 236.75k  90.50k 192.13k  54.79k  88.02k
# Query size     4  45.23k     157     157     157     157       0     157
# String:
# Databases    isucondition
# Hosts        localhost
# Users        isucon
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms
#  10ms
# 100ms  ################################################################
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_condition'\G
#    SHOW CREATE TABLE `isucondition`.`isu_condition`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = '6da1f0e3-51f9-43c8-8735-4b427970036a' AND `timestamp` < '2021-08-15 12:47:37' ORDER BY `timestamp` DESC\G

# Query 4: 2.14 QPS, 0.30x concurrency, ID 0x5F580A12ADA1633C9634298BE5BD9422 at byte 855215
# Scores: V/M = 0.01
# Time range: 2022-07-09 17:01:58 to 17:02:33
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          7      75
# Exec time      7     11s   101ms   236ms   142ms   198ms    31ms   134ms
# Lock time      2     4ms    13us   894us    54us   185us   133us    18us
# Rows sent     15  73.25k     496   1.41k 1000.09   1.33k  230.12  918.49
# Rows examine   7   3.78M  27.85k  72.31k  51.62k  68.96k  10.93k  49.01k
# Rows affecte   0       0       0       0       0       0       0       0
# Bytes sent    15  11.75M  77.86k 239.29k 160.40k 233.54k  40.76k 150.54k
# Query size     0   8.50k     116     116     116     116       0     116
# String:
# Databases    isucondition
# Hosts        localhost
# Users        isucon
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms
#  10ms
# 100ms  ################################################################
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_condition'\G
#    SHOW CREATE TABLE `isucondition`.`isu_condition`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = '47a47917-dc3c-47e2-b4b2-4a2643c675ad' ORDER BY `timestamp` ASC\G

# Query 5: 0.75 QPS, 0.24x concurrency, ID 0xFFFCA4D67EA0A788813031B8BBC3B329 at byte 838937
# Scores: V/M = 0.09
# Time range: 2022-07-09 17:01:46 to 17:02:30
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          3      33
# Exec time      6     10s   101ms   646ms   318ms   609ms   169ms   230ms
# 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
# Rows affecte   0       0       0       0       0       0       0       0
# Bytes sent     0     363      11      11      11      11       0      11
# Query size     0     198       6       6       6       6       0       6
# String:
# Databases    isucondition
# Hosts        localhost
# Users        isucon
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms
#  10ms
# 100ms  ################################################################
#    1s
#  10s+
COMMIT\G
ushmz / isucon-utils

pt-query-digest@17:02 #57
