Open kumaotto opened 2 years ago
alp sort by count
+-------+-----+------+-----+-----+-----+--------+---------------------------------------+-------+--------+----------+-------+-------+-------+--------+--------+-----------+------------+--------------+-----------+
| COUNT | 1XX | 2XX | 3XX | 4XX | 5XX | METHOD | URI | MIN | MAX | SUM | AVG | P90 | P95 | P99 | STDDEV | MIN(BODY) | MAX(BODY) | SUM(BODY) | AVG(BODY) |
+-------+-----+------+-----+-----+-----+--------+---------------------------------------+-------+--------+----------+-------+-------+-------+--------+--------+-----------+------------+--------------+-----------+
| 1340 | 0 | 1276 | 0 | 61 | 3 | GET | /api/player/player/.+ | 0.004 | 12.112 | 1308.513 | 0.977 | 2.612 | 3.192 | 9.204 | 1.801 | 0.000 | 2021.000 | 1264892.000 | 943.949 |
| 1312 | 0 | 1260 | 0 | 50 | 2 | GET | /api/player/competition/.+/ranking | 0.008 | 11.128 | 1323.868 | 1.009 | 2.916 | 5.088 | 10.556 | 2.034 | 0.000 | 20133.000 | 16167175.000 | 12322.542 |
| 202 | 0 | 186 | 0 | 16 | 0 | GET | /api/player/competitions | 1.284 | 2.852 | 108.490 | 0.537 | 2.288 | 2.476 | 2.768 | 0.879 | 0.000 | 2710.000 | 251559.000 | 1245.342 |
| 140 | 0 | 132 | 0 | 8 | 0 | POST | /api/organizer/competition/.+ | 0.004 | 10.972 | 120.078 | 0.858 | 2.424 | 2.960 | 8.932 | 1.580 | 0.000 | 62.000 | 5503.000 | 39.307 |
| 63 | 0 | 62 | 0 | 1 | 0 | POST | /api/organizer/competitions/add | 0.004 | 0.036 | 0.792 | 0.013 | 0.020 | 0.028 | 0.036 | 0.007 | 39.000 | 251.000 | 13663.000 | 216.873 |
| 45 | 0 | 45 | 0 | 0 | 0 | GET | /api/organizer/players | 0.000 | 0.056 | 0.360 | 0.008 | 0.016 | 0.032 | 0.056 | 0.011 | 3088.000 | 602067.000 | 2115018.000 | 47000.400 |
| 36 | 0 | 35 | 0 | 1 | 0 | GET | /api/organizer/billing | 0.004 | 1.484 | 3.653 | 0.101 | 0.240 | 0.348 | 1.484 | 0.248 | 0.000 | 4667.000 | 74531.000 | 2070.306 |
| 27 | 0 | 26 | 0 | 1 | 0 | GET | /api/admin/tenants/billing | 2.296 | 19.804 | 89.766 | 3.325 | 5.752 | 9.692 | 19.804 | 3.662 | 0.000 | 1572.000 | 37783.000 | 1399.370 |
| 17 | 0 | 16 | 0 | 1 | 0 | POST | /api/organizer/player/.+/disqualified | 0.004 | 0.024 | 0.188 | 0.011 | 0.020 | 0.024 | 0.024 | 0.005 | 39.000 | 213.000 | 2642.000 | 155.412 |
| 12 | 0 | 7 | 0 | 5 | 0 | POST | /api/admin/tenants/add | 0.008 | 0.084 | 0.424 | 0.035 | 0.072 | 0.084 | 0.084 | 0.030 | 39.000 | 200.000 | 1501.000 | 125.083 |
| 11 | 0 | 11 | 0 | 0 | 0 | POST | /api/organizer/players/add | 0.860 | 2.060 | 16.500 | 1.500 | 1.912 | 2.060 | 2.060 | 0.433 | 17750.000 | 40380.000 | 336719.000 | 30610.818 |
| 1 | 0 | 1 | 0 | 0 | 0 | POST | /initialize | 3.308 | 3.308 | 3.308 | 3.308 | 3.308 | 3.308 | 3.308 | 0.000 | 55.000 | 55.000 | 55.000 | 55.000 |
| 1 | 0 | 1 | 0 | 0 | 0 | GET | /css/app.83b4c321.css | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 4868.000 | 4868.000 | 4868.000 | 4868.000 |
| 1 | 0 | 1 | 0 | 0 | 0 | GET | /js/app.3a4ec98c.js | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 33294.000 | 33294.000 | 33294.000 | 33294.000 |
| 1 | 0 | 1 | 0 | 0 | 0 | GET | /index.html | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 479.000 | 479.000 | 479.000 | 479.000 |
| 1 | 0 | 1 | 0 | 0 | 0 | GET | /api/organizer/competitions | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 | 0.000 | 233.000 | 233.000 | 233.000 | 233.000 |
| 1 | 0 | 0 | 0 | 1 | 0 | GET | / | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 134.000 | 134.000 | 134.000 | 134.000 |
+-------+-----+------+-----+-----+-----+--------+---------------------------------------+-------+--------+----------+-------+-------+-------+--------+--------+-----------+------------+--------------+-----------+
alp sort by sum
+-------+-----+------+-----+-----+-----+--------+---------------------------------------+-------+--------+----------+-------+-------+-------+--------+--------+-----------+------------+--------------+-----------+
| COUNT | 1XX | 2XX | 3XX | 4XX | 5XX | METHOD | URI | MIN | MAX | SUM | AVG | P90 | P95 | P99 | STDDEV | MIN(BODY) | MAX(BODY) | SUM(BODY) | AVG(BODY) |
+-------+-----+------+-----+-----+-----+--------+---------------------------------------+-------+--------+----------+-------+-------+-------+--------+--------+-----------+------------+--------------+-----------+
| 1312 | 0 | 1260 | 0 | 50 | 2 | GET | /api/player/competition/.+/ranking | 0.008 | 11.128 | 1323.868 | 1.009 | 2.916 | 5.088 | 10.556 | 2.034 | 0.000 | 20133.000 | 16167175.000 | 12322.542 |
| 1340 | 0 | 1276 | 0 | 61 | 3 | GET | /api/player/player/.+ | 0.004 | 12.112 | 1308.513 | 0.977 | 2.612 | 3.192 | 9.204 | 1.801 | 0.000 | 2021.000 | 1264892.000 | 943.949 |
| 140 | 0 | 132 | 0 | 8 | 0 | POST | /api/organizer/competition/.+ | 0.004 | 10.972 | 120.078 | 0.858 | 2.424 | 2.960 | 8.932 | 1.580 | 0.000 | 62.000 | 5503.000 | 39.307 |
| 202 | 0 | 186 | 0 | 16 | 0 | GET | /api/player/competitions | 1.284 | 2.852 | 108.490 | 0.537 | 2.288 | 2.476 | 2.768 | 0.879 | 0.000 | 2710.000 | 251559.000 | 1245.342 |
| 27 | 0 | 26 | 0 | 1 | 0 | GET | /api/admin/tenants/billing | 2.296 | 19.804 | 89.766 | 3.325 | 5.752 | 9.692 | 19.804 | 3.662 | 0.000 | 1572.000 | 37783.000 | 1399.370 |
| 11 | 0 | 11 | 0 | 0 | 0 | POST | /api/organizer/players/add | 0.860 | 2.060 | 16.500 | 1.500 | 1.912 | 2.060 | 2.060 | 0.433 | 17750.000 | 40380.000 | 336719.000 | 30610.818 |
| 36 | 0 | 35 | 0 | 1 | 0 | GET | /api/organizer/billing | 0.004 | 1.484 | 3.653 | 0.101 | 0.240 | 0.348 | 1.484 | 0.248 | 0.000 | 4667.000 | 74531.000 | 2070.306 |
| 1 | 0 | 1 | 0 | 0 | 0 | POST | /initialize | 3.308 | 3.308 | 3.308 | 3.308 | 3.308 | 3.308 | 3.308 | 0.000 | 55.000 | 55.000 | 55.000 | 55.000 |
| 63 | 0 | 62 | 0 | 1 | 0 | POST | /api/organizer/competitions/add | 0.004 | 0.036 | 0.792 | 0.013 | 0.020 | 0.028 | 0.036 | 0.007 | 39.000 | 251.000 | 13663.000 | 216.873 |
| 12 | 0 | 7 | 0 | 5 | 0 | POST | /api/admin/tenants/add | 0.008 | 0.084 | 0.424 | 0.035 | 0.072 | 0.084 | 0.084 | 0.030 | 39.000 | 200.000 | 1501.000 | 125.083 |
| 45 | 0 | 45 | 0 | 0 | 0 | GET | /api/organizer/players | 0.000 | 0.056 | 0.360 | 0.008 | 0.016 | 0.032 | 0.056 | 0.011 | 3088.000 | 602067.000 | 2115018.000 | 47000.400 |
| 17 | 0 | 16 | 0 | 1 | 0 | POST | /api/organizer/player/.+/disqualified | 0.004 | 0.024 | 0.188 | 0.011 | 0.020 | 0.024 | 0.024 | 0.005 | 39.000 | 213.000 | 2642.000 | 155.412 |
| 1 | 0 | 1 | 0 | 0 | 0 | GET | /api/organizer/competitions | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 | 0.000 | 233.000 | 233.000 | 233.000 | 233.000 |
| 1 | 0 | 1 | 0 | 0 | 0 | GET | /css/app.83b4c321.css | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 4868.000 | 4868.000 | 4868.000 | 4868.000 |
| 1 | 0 | 1 | 0 | 0 | 0 | GET | /js/app.3a4ec98c.js | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 33294.000 | 33294.000 | 33294.000 | 33294.000 |
| 1 | 0 | 1 | 0 | 0 | 0 | GET | /index.html | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 479.000 | 479.000 | 479.000 | 479.000 |
| 1 | 0 | 0 | 0 | 1 | 0 | GET | / | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 134.000 | 134.000 | 134.000 | 134.000 |
+-------+-----+------+-----+-----+-----+--------+---------------------------------------+-------+--------+----------+-------+-------+-------+--------+--------+-----------+------------+--------------+-----------+
pt-query-digest
# 4.5s user time, 100ms system time, 31.81M rss, 32.09G vsz
# Current date: Sat Jul 23 15:24:38 2022
# Hostname: kobayashimasatonoMacBook-Pro.local
# Files: /Users/shoutokobayashi/Apps/isucon/isucon/output/metrics/mysql/slow.log
# Overall: 46.29k total, 15 unique, 526.01 QPS, 1.67x concurrency ________
# Time range: 2022-07-23T06:21:23 to 2022-07-23T06:22:51
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 147s 1us 3s 3ms 8ms 20ms 424us
# Lock time 36ms 0 247us 0 1us 1us 1us
# Rows sent 372.05k 0 4.88k 8.23 44.60 95.20 0
# Rows examine 8.75M 0 3.08M 198.27 652.75 14.49k 0
# Query size 3.38M 10 261 76.50 136.99 48.54 97.36
# Profile
# Rank Query ID Response time Calls R/Call V/M
# ==== =================================== ============= ===== ====== ====
# 1 0xFD3308B62AB786FE8B6857F218B353CB 84.3034 57.3% 18727 0.0045 0.00 INSERT player_score
# 2 0x676347F321DB8BC7FCB05D4948FC2248 49.8142 33.9% 3225 0.0154 0.18 SELECT visit_history
# 3 0x2E69352DE16B15042A1217500A0400FE 8.4542 5.7% 1294 0.0065 0.00 INSERT visit_history
# MISC 0xMISC 4.4700 3.0% 23043 0.0002 0.0 <12 ITEMS>
# Query 1: 212.81 QPS, 0.96x concurrency, ID 0xFD3308B62AB786FE8B6857F218B353CB at byte 4042086
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2022-07-23T06:21:23 to 2022-07-23T06:22:51
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 40 18727
# Exec time 57 84s 2ms 78ms 5ms 6ms 1ms 4ms
# Lock time 62 23ms 0 25us 1us 1us 0 1us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Query size 54 1.86M 98 105 103.90 102.22 1.31 102.22
# String:
# Databases isuports
# Hosts isuports-1.t.isucon.dev
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms ################################################################
# 10ms #
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isuports` LIKE 'player_score'\G
# SHOW CREATE TABLE `isuports`.`player_score`\G
INSERT INTO player_score VALUES('3db091f5d',1,'ed6bb966','174f069ca',161700,51906,1653019171,1653019171)\G
# Query 2: 48.13 QPS, 0.74x concurrency, ID 0x676347F321DB8BC7FCB05D4948FC2248 at byte 8010572
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.18
# Time range: 2022-07-23T06:21:31 to 2022-07-23T06:22:38
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 6 3225
# Exec time 33 50s 146us 1s 15ms 33ms 53ms 9ms
# Lock time 12 5ms 0 38us 1us 1us 1us 1us
# Rows sent 98 364.90k 0 4.88k 115.86 183.58 343.78 80.10
# Rows examine 64 5.67M 0 78.96k 1.80k 2.89k 5.41k 1.26k
# Query size 13 464.42k 141 199 147.46 192.76 15.21 136.99
# String:
# Databases isuports
# Hosts isuports-1.t.isucon.dev
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us ###########
# 1ms ###########################################################
# 10ms ################################################################
# 100ms #
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isuports` LIKE 'visit_history'\G
# SHOW CREATE TABLE `isuports`.`visit_history`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT player_id, MIN(created_at) AS min_created_at FROM visit_history WHERE tenant_id = 1 AND competition_id = '4ce9b66c7' GROUP BY player_id\G
# Query 3: 19.61 QPS, 0.13x concurrency, ID 0x2E69352DE16B15042A1217500A0400FE at byte 8191760
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2022-07-23T06:21:33 to 2022-07-23T06:22:39
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 1294
# Exec time 5 8s 2ms 53ms 7ms 13ms 4ms 5ms
# Lock time 5 2ms 0 40us 1us 1us 2us 1us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Query size 9 315.80k 150 261 249.91 258.32 22.45 258.32
# String:
# Databases isuports
# Hosts isuports-1.t.isucon.dev
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms ################################################################
# 10ms #########
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isuports` LIKE 'visit_history'\G
# SHOW CREATE TABLE `isuports`.`visit_history`\G
INSERT INTO visit_history (player_id, tenant_id, competition_id, created_at, updated_at) VALUES ('oQPnY3TElG5NDu63mLmvXhprOko8nIXl3zainO971XAwKsswrRtwrHlfDsujmYQE', 23, 'EZgumbwLquL2sZFPKtWXkWc8d2auxMJpvUsg7URPqDc0JGEaToAH2NWAapMtPCpy', 1658557335, 1658557335)\G
スコア
4889
ブランチ
main
コミット
06060a023b56eb589e4ebe0ed694c42a047dc259
結果