Open github-actions[bot] opened 10 months ago
COUNT | 1XX | 2XX | 3XX | 4XX | 5XX | METHOD | URI | MIN | MAX | SUM | AVG | P90 | P95 | P99 | STDDEV | MIN(BODY) | MAX(BODY) | SUM(BODY) | AVG(BODY) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2398 | 0 | 2389 | 0 | 9 | 0 | GET | /api/user/[a-zA-Z0-9]+ | 0.004 | 20.000 | 273.156 | 0.114 | 0.188 | 0.280 | 0.568 | 0.831 | 0.000 | 164985.000 | 127905184.000 | 53338.275 |
712 | 0 | 706 | 0 | 5 | 1 | GET | /api/livestream | 0.004 | 6.900 | 245.236 | 0.344 | 0.792 | 0.980 | 1.296 | 0.467 | 0.000 | 42801.000 | 6614433.000 | 9289.934 |
615 | 0 | 607 | 0 | 8 | 0 | POST | /api/livestream | 0.004 | 13.652 | 193.260 | 0.314 | 0.360 | 0.632 | 3.620 | 0.915 | 0.000 | 2701.000 | 1076057.000 | 1749.686 |
53 | 0 | 53 | 0 | 0 | 0 | GET | /api/livestream/search | 0.072 | 3.564 | 66.920 | 1.263 | 2.052 | 2.512 | 3.564 | 0.781 | 49549.000 | 126660.000 | 3824059.000 | 72152.057 |
213 | 0 | 210 | 0 | 2 | 1 | POST | /api/register | 0.004 | 0.900 | 48.700 | 0.229 | 0.416 | 0.544 | 0.740 | 0.135 | 0.000 | 504.000 | 98501.000 | 462.446 |
100 | 0 | 96 | 0 | 4 | 0 | POST | /api/livestream/reservation | 0.004 | 1.136 | 45.264 | 0.453 | 0.848 | 0.884 | 1.044 | 0.322 | 0.000 | 1501.000 | 108363.000 | 1083.630 |
210 | 0 | 209 | 0 | 1 | 0 | POST | /api/icon | 0.016 | 0.596 | 26.600 | 0.127 | 0.280 | 0.444 | 0.548 | 0.120 | 0.000 | 16.000 | 3236.000 | 15.410 |
218 | 0 | 216 | 0 | 2 | 0 | POST | /api/login | 0.004 | 0.732 | 16.188 | 0.074 | 0.224 | 0.288 | 0.504 | 0.116 | 0.000 | 64.000 | 128.000 | 0.587 |
1 | 0 | 1 | 0 | 0 | 0 | POST | /api/initialize | 14.228 | 14.228 | 14.228 | 14.228 | 14.228 | 14.228 | 14.228 | 0.000 | 27.000 | 27.000 | 27.000 | 27.000 |
79 | 0 | 79 | 0 | 0 | 0 | GET | /api/tag | 0.004 | 0.516 | 5.808 | 0.074 | 0.176 | 0.292 | 0.516 | 0.102 | 6089.000 | 6095.000 | 481349.000 | 6093.025 |
17 | 0 | 17 | 0 | 0 | 0 | DELETE | /api/livestream | 0.004 | 0.500 | 1.824 | 0.107 | 0.436 | 0.500 | 0.500 | 0.142 | 0.000 | 0.000 | 0.000 | 0.000 |
6 | 0 | 6 | 0 | 0 | 0 | GET | /api/user/[a-zA-Z0-9]+/theme | 0.016 | 0.076 | 0.184 | 0.031 | 0.076 | 0.076 | 0.076 | 0.024 | 38.000 | 38.000 | 228.000 | 38.000 |
3 | 0 | 3 | 0 | 0 | 0 | GET | /api/user/me | 0.000 | 0.004 | 0.004 | 0.001 | 0.004 | 0.004 | 0.004 | 0.002 | 235.000 | 247.000 | 729.000 | 243.000 |
1 | 0 | 1 | 0 | 0 | 0 | GET | /api/payment | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 21.000 | 21.000 | 21.000 | 21.000 |
Reading from STDIN ...
# 32.8s user time, 110ms system time, 37.11M rss, 43.59M vsz
# Current date: Sat Nov 25 02:02:44 2023
# Hostname: ip-192-168-0-11
# Files: STDIN
# Overall: 525.76k total, 81 unique, 5.15k QPS, 4.17x concurrency ________
# Time range: 2023-11-25T01:58:27 to 2023-11-25T02:00:09
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 426s 1us 472ms 809us 3ms 4ms 66us
# Lock time 656ms 0 49ms 1us 1us 90us 0
# Rows sent 211.21k 0 7.32k 0.41 0.99 17.57 0
# Rows examine 85.03M 0 14.02k 169.59 1.04k 651.61 0
# Query size 51.75M 5 1.94M 103.21 299.03 3.30k 31.70
# Profile
# Rank Query ID Response time Calls R/Call V/M
# ==== ================================== ============= ====== ====== ====
# 1 0x84B457C910C4A79FC9EBECB8B1065C66 68.5303 16.1% 13957 0.0049 0.01 SELECT icons
# 2 0xDA556F9115773A1A99AA0165670CE848 53.0400 12.5% 157488 0.0003 0.01 ADMIN PREPARE
# 3 0x42EF7D7D98FBCC9723BF896EBFC51D24 47.0552 11.1% 6612 0.0071 0.01 SELECT records
# 4 0xF1B8EF06D6CA63B24BFF433E06CCEB22 35.4315 8.3% 3133 0.0113 0.02 SELECT users livestreams livecomments
# 5 0xDB74D52D39A7090F224C4DEEAF3028C9 34.2424 8.0% 3135 0.0109 0.02 SELECT users livestreams reactions
# 6 0x3D83BC87F3B3A00D571FFC8104A6E50C 25.7449 6.1% 4935 0.0052 0.01 SELECT records
# 7 0x38BC86A45F31C6B1EE324671506C898A 22.3119 5.2% 11577 0.0019 0.00 SELECT themes
# 8 0x59F1B6DD8D9FEC059E55B3BFD624E8C3 17.0770 4.0% 820 0.0208 0.01 SELECT reservation_slots
# 9 0x4ADE2DC90689F1C4891749AF54FB8D14 16.9045 4.0% 34691 0.0005 0.00 DELETE SELECT livecomments
# 10 0xFFFCA4D67EA0A788813031B8BBC3B329 12.2821 2.9% 2416 0.0051 0.01 COMMIT
# 11 0x64CC8A4E8E4B390203375597CE4D611F 11.9233 2.8% 266 0.0448 0.01 SELECT ng_words
# 12 0xFBC5564AE716EAE82F20BFB45F6C37E7 9.7524 2.3% 28281 0.0003 0.00 SELECT tags
# 13 0x22279D81D51006139E0C76405B54C261 6.6507 1.6% 7880 0.0008 0.00 SELECT domains domainmetadata
# 14 0x8F7679D452333ED3C7D60D22131CEFD4 5.1684 1.2% 20854 0.0002 0.00 ADMIN RESET STMT
# 15 0xA3401CA3ABCC04C3AB221DB8AD5CBF26 4.5558 1.1% 96 0.0475 0.02 UPDATE reservation_slots
# 16 0xFD38427AE3D09E3883A680F7BAF95D3A 4.2618 1.0% 14992 0.0003 0.00 SELECT livestreams livecomments
# 17 0xF7144185D9A142A426A36DC55C1D2623 4.1539 1.0% 7497 0.0006 0.00 SELECT livestream_tags
# 18 0xEA1E6309EEEFF9A6831AD2FB940FC23C 4.1414 1.0% 11360 0.0004 0.00 SELECT users
# 19 0xC499D81D570D361DB61FC43A94BB888A 3.7467 0.9% 14992 0.0002 0.00 SELECT livestreams reactions
# 20 0xD2A0864774622BA36F6557496405CF75 3.7006 0.9% 844 0.0044 0.00 INSERT themes
# 21 0x7F9C0C0BA9473953B723EE16C08655F1 3.6949 0.9% 98 0.0377 0.02 SELECT reservation_slots
# 22 0xDFFCC1D78939C4D781C7C58349101F50 3.5086 0.8% 633 0.0055 0.00 INSERT users
# 23 0x859BBB7E9D760686137A944406874C4D 3.3082 0.8% 210 0.0158 0.01 DELETE records
# 24 0x9EAD6C0CE525E3693EE27FFC9AAF05A3 3.0720 0.7% 78 0.0394 0.02 SELECT livestreams
# 25 0xD6032FE08E1FE706A928B8B7CBA06B85 2.3839 0.6% 5701 0.0004 0.00 SELECT livestreams
# 26 0x3A2B0EDA41C4E3576FCA6DA29A9B91DF 2.3284 0.5% 209 0.0111 0.01 INSERT icons
# 27 0x9AC623FA477E73A44D191D296850A025 2.1487 0.5% 420 0.0051 0.00 SELECT records
# 28 0xEDE18C1523658A19E07525EAFCBA6BFE 1.8012 0.4% 33 0.0546 0.01 SELECT ng_words
# 29 0x07890000813C4CC7111FD2D3F3B3B4EB 1.7404 0.4% 157467 0.0000 0.00 ADMIN CLOSE STMT
# 30 0xB08B7B7486D2DFE2F2FE9CE78689FD79 1.3228 0.3% 26 0.0509 0.01 SELECT ng_words
# 31 0x3F155F5E71EFF856F0CF7B8430DE8C23 1.1287 0.3% 2612 0.0004 0.00 SELECT users
# 32 0xFFF66E9B3D962FA319C8068B5C1997CD 1.0827 0.3% 2399 0.0005 0.00 ROLLBACK
# 33 0xF1E5C5B0483E8BF764220BFACAE7CD16 1.0123 0.2% 209 0.0048 0.01 DELETE icons
# 34 0xB78E63D0D9C72DDDAB7A3E53517FA04C 0.8575 0.2% 237 0.0036 0.00 SELECT livecomments
# 35 0x9E2DA589A20EC24C34E11DDE0FBF5564 0.7835 0.2% 4619 0.0002 0.00 START
# 36 0xAD0C28443E1E5CFAFF1569DBB4F7E63A 0.6008 0.1% 267 0.0023 0.00 SELECT reactions
# 37 0x98F959E03B684A5538FD8402A0EE94AD 0.5435 0.1% 103 0.0053 0.00 INSERT tags
# 38 0x02B6A87E51A5A1B7646675DB67C57DE3 0.4717 0.1% 1 0.4717 0.00 INSERT ng_words
# 39 0x0C1FCBB4E25B178AA3A46D4FECBA9BDC 0.4141 0.1% 22 0.0188 0.00 INSERT livestream_tags
# 40 0x80E10371CE74ED05E09C79C72C73F8E1 0.3990 0.1% 97 0.0041 0.26 INSERT livestreams
# 41 0x77FB9E134D073862D1E78FEEC3436291 0.3264 0.1% 1490 0.0002 0.00 INSERT records
# 42 0x41F805E95754958A974F41AE07BEA625 0.2766 0.1% 32 0.0086 0.01 SELECT livecomments
# 43 0xF3A502CCF34F7DA288CC1B75AD5AFA37 0.1802 0.0% 265 0.0007 0.00 INSERT livecomments
# 44 0x5D469B53C536D19CD15E40763ACC23C7 0.1671 0.0% 402 0.0004 0.00 INSERT livestream_tags
# 45 0xDF0AAE38E2AAFC85E6F50569CEF2285D 0.1475 0.0% 1 0.1475 0.00 INSERT reservation_slots
# 46 0xB9AC05A7AE6C4E30B5B45F6F3CE05BE0 0.1388 0.0% 422 0.0003 0.00 SET
# 47 0x64052B1C32B30DF53AB3292208B783B4 0.1247 0.0% 212 0.0006 0.00 INSERT users
# 48 0x651E3772B8767A368CB47EE7389EEB33 0.1144 0.0% 14 0.0082 0.01 SELECT livestream_tags
# 49 0x5AEB6E4A781A3854CF642125E293FEE0 0.0991 0.0% 249 0.0004 0.00 INSERT reactions
# 50 0xEE4C51AE2BF74414C4892CBE11E894AA 0.0725 0.0% 26 0.0028 0.00 SELECT livecomments
# 51 0xE64D50F7AFC1AD5F465809A92DF4935E 0.0687 0.0% 25 0.0027 0.00 SELECT reactions
# 52 0x544239977D2094F805A7B062DE95673A 0.0603 0.0% 79 0.0008 0.00 SELECT tags
# 53 0xDFEFE5BA5D8654534DC8550C6E3DC9C0 0.0521 0.0% 1 0.0521 0.00 DELETE records
# 54 0xE623383C5D789800DC0946925F90039F 0.0498 0.0% 211 0.0002 0.00 SELECT domains
# 55 0x4B6FA79E206C6CED71D433A2FC998D69 0.0488 0.0% 89 0.0005 0.00 SELECT
# 56 0x81E419F4B58AEB9B280B03DE44DD8B94 0.0425 0.0% 106 0.0004 0.00 SELECT livecomments
# 57 0x07F6C3FF39ADD79FC63923A7EE938953 0.0409 0.0% 1 0.0409 0.00 INSERT livecomments
# 58 0x24C44C3518CE12293EF12410AEDA2393 0.0405 0.0% 39 0.0010 0.00 SELECT livestreams
# 59 0x74232BDFFB94C567F0340DBE3285E458 0.0266 0.0% 1 0.0266 0.00 INSERT reactions
# 60 0x050F7D44808F43E5D33D0B90BCF57CC9 0.0264 0.0% 2 0.0132 0.00 SELECT livestreams
# 61 0x827F41D30F8E37F04D8BDCD46C556FB3 0.0252 0.0% 43 0.0006 0.00 INSERT livecomment_reports
# 62 0x8D589AFA4DFAEEED85FFF5AA78E5FF6A 0.0195 0.0% 211 0.0001 0.00 BEGIN
# 63 0x19A1F14EFC0F221D30AFCB1E1344BEBD 0.0187 0.0% 7 0.0027 0.00 SELECT users
# 64 0x466EE4C87B17CAD4E692DE1D44EAD84D 0.0131 0.0% 44 0.0003 0.00 SELECT livecomment_reports
# 65 0x0C655718656DD9DDA39A0D11554A0C64 0.0090 0.0% 26 0.0003 0.00 INSERT ng_words
# 66 0xA0D956F292B7FEA0DCE68A5DD5F529E1 0.0089 0.0% 17 0.0005 0.00 DELETE livestream_viewers_history
# 67 0xB871CC5B0472067402F5739D108B2C1C 0.0073 0.0% 26 0.0003 0.00 SELECT livestreams
# 68 0xBF3194A2446AC20FC99B6CC7FA476A57 0.0071 0.0% 27 0.0003 0.00 INSERT livestream_viewers_history
# 69 0x2B760561C10B5D133155AA306D0F407C 0.0070 0.0% 18 0.0004 0.00 SELECT livecomments
# 70 0x49F80FBE1AC70F23A3DD076174FF1AA9 0.0043 0.0% 2 0.0022 0.00 SELECT users livestreams reactions
# 71 0xF985E5835B84E84C7A721801818E98CE 0.0043 0.0% 2 0.0021 0.00 SELECT users livestreams reactions
# 72 0x2C17BCA1E1077820CDC2EC6106F4D93E 0.0011 0.0% 18 0.0001 0.00 SELECT livestream_viewers_history
# 73 0x8B2044ADAE690405979131C33185F22A 0.0011 0.0% 6 0.0002 0.00 SELECT users
# 74 0x20CD15DC47AF2F861B8F3C25D195ABE9 0.0010 0.0% 14 0.0001 0.00 SELECT tags
# 75 0xEDBC971AEC392917AA353644DE4C4CB4 0.0007 0.0% 346 0.0000 0.00 ADMIN QUIT
# 76 0x0E7680C04FF2596BE3A3649C5FAC418D 0.0006 0.0% 7 0.0001 0.00 SELECT
# 77 0xEBE4AF9F935DE1D48BB5BB3558C7FCC4 0.0006 0.0% 2 0.0003 0.00 SELECT livestreams livecomments
# 78 0x8F885091E23CB955C051B1204EE7D91D 0.0005 0.0% 2 0.0002 0.00 SELECT livestreams reactions
# 79 0xC4625761E0CFD817F41B4802F152A489 0.0004 0.0% 1 0.0004 0.00 SELECT livecomments
# 80 0xF085F31DC1964EA538732B713E4B4108 0.0002 0.0% 2 0.0001 0.00 SELECT livestreams livestream_viewers_history
# 81 0x394E66DDE2823A903078D4C0F235B948 0.0002 0.0% 2 0.0001 0.00 SELECT livestreams livecomment_reports
# Query 1: 151.71 QPS, 0.74x concurrency, ID 0x84B457C910C4A79FC9EBECB8B1065C66 at byte 135711340
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T01:58:37 to 2023-11-25T02:00:09
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 13957
# Exec time 16 69s 46us 48ms 5ms 17ms 6ms 2ms
# Lock time 5 38ms 0 3ms 2us 1us 47us 1us
# Rows sent 5 10.66k 0 1 0.78 0.99 0.41 0.99
# Rows examine 1 1.20M 0 202 89.83 183.58 58.87 84.10
# Query size 1 596.99k 41 44 43.80 42.48 0.28 42.48
# String:
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us ###########
# 100us ######################
# 1ms ################################################################
# 10ms ####################
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isupipe` LIKE 'icons'\G
# SHOW CREATE TABLE `isupipe`.`icons`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT image FROM icons WHERE user_id = 1021\G
# Query 2: 1.69k QPS, 0.57x concurrency, ID 0xDA556F9115773A1A99AA0165670CE848 at byte 43578596
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T01:58:36 to 2023-11-25T02:00:09
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 29 157488
# Exec time 12 53s 21us 321ms 336us 1ms 1ms 80us
# 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 8 4.51M 30 30 30 30 0 30
# String:
# Hosts localhost
# Users isucon (156218/99%), isudns (1270/0%)
# Query_time distribution
# 1us
# 10us ################################################################
# 100us #########################################
# 1ms ########
# 10ms #
# 100ms #
# 1s
# 10s+
administrator command: Prepare\G
# Query 3: 71.10 QPS, 0.51x concurrency, ID 0x42EF7D7D98FBCC9723BF896EBFC51D24 at byte 136078185
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T01:58:36 to 2023-11-25T02:00:09
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 6612
# Exec time 11 47s 719us 58ms 7ms 18ms 6ms 5ms
# Lock time 5 37ms 0 12ms 5us 1us 162us 1us
# Rows sent 0 1.45k 0 1 0.23 0.99 0.41 0
# Rows examine 10 8.78M 1.25k 1.46k 1.36k 1.39k 56.51 1.33k
# Query size 1 910.84k 129 214 141.06 158.58 11.39 136.99
# String:
# Hosts localhost
# Users isudns
# Query_time distribution
# 1us
# 10us
# 100us #
# 1ms ################################################################
# 10ms ########################
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isudns` LIKE 'records'\G
# SHOW CREATE TABLE `isudns`.`records`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and name='*.u.isucon.dev' and domain_id=2\G
# Query 4: 34.05 QPS, 0.39x concurrency, ID 0xF1B8EF06D6CA63B24BFF433E06CCEB22 at byte 125753795
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.02
# Time range: 2023-11-25T01:58:37 to 2023-11-25T02:00:09
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 3133
# Exec time 8 35s 2ms 98ms 11ms 42ms 15ms 2ms
# Lock time 1 12ms 0 5ms 3us 1us 86us 1us
# Rows sent 1 3.06k 1 1 1 1 0 1
# Rows examine 7 6.22M 1.96k 2.46k 2.03k 2.27k 118.55 1.96k
# Query size 0 504.17k 163 166 164.79 158.58 0 158.58
# String:
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms ################################################################
# 10ms ##############################
# 100ms #
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isupipe` LIKE 'users'\G
# SHOW CREATE TABLE `isupipe`.`users`\G
# SHOW TABLE STATUS FROM `isupipe` LIKE 'livestreams'\G
# SHOW CREATE TABLE `isupipe`.`livestreams`\G
# SHOW TABLE STATUS FROM `isupipe` LIKE 'livecomments'\G
# SHOW CREATE TABLE `isupipe`.`livecomments`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT IFNULL(SUM(l2.tip), 0) FROM users u
INNER JOIN livestreams l ON l.user_id = u.id
INNER JOIN livecomments l2 ON l2.livestream_id = l.id
WHERE u.id = 88\G
# Query 5: 34.08 QPS, 0.37x concurrency, ID 0xDB74D52D39A7090F224C4DEEAF3028C9 at byte 64271856
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.02
# Time range: 2023-11-25T01:58:37 to 2023-11-25T02:00:09
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 3135
# Exec time 8 34s 2ms 89ms 11ms 40ms 14ms 2ms
# Lock time 2 14ms 0 3ms 4us 1us 79us 1us
# Rows sent 1 3.06k 1 1 1 1 0 1
# Rows examine 7 6.22M 1.96k 2.43k 2.03k 2.27k 118.63 1.96k
# Query size 0 443.27k 143 146 144.79 143.84 0.96 143.84
# String:
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms ################################################################
# 10ms ##############################
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isupipe` LIKE 'users'\G
# SHOW CREATE TABLE `isupipe`.`users`\G
# SHOW TABLE STATUS FROM `isupipe` LIKE 'livestreams'\G
# SHOW CREATE TABLE `isupipe`.`livestreams`\G
# SHOW TABLE STATUS FROM `isupipe` LIKE 'reactions'\G
# SHOW CREATE TABLE `isupipe`.`reactions`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT COUNT(*) FROM users u
INNER JOIN livestreams l ON l.user_id = u.id
INNER JOIN reactions r ON r.livestream_id = l.id
WHERE u.id = 28\G