search

niftyisucon / isucon13

0 stars 0 forks source link

Benchmark result on isu3 #15

Open github-actions[bot] opened 11 months ago

github-actions[bot] commented 11 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)
3327 0 3325 0 2 0 GET /api/user/[a-zA-Z0-9]+/icon 0.004 0.932 151.580 0.046 0.132 0.192 0.336 0.072 0.000 98957.000 183545177.000 55168.373
27 0 25 0 2 0 POST /api/livestream/[a-zA-Z0-9]+/moderate 0.288 11.972 118.464 4.388 7.768 7.980 11.972 2.296 0.000 23.000 575.000 21.296
7 0 2 0 5 0 GET /api/user/[a-zA-Z0-9]+/statistics 5.100 20.004 110.280 15.754 20.004 20.004 20.004 6.714 0.000 139.000 272.000 38.857
394 0 393 0 1 0 GET /api/livestream/[a-zA-Z0-9]+/livecomment 0.004 0.768 106.300 0.270 0.536 0.608 0.736 0.186 0.000 39219.000 5381261.000 13658.023
429 0 426 0 3 0 GET /api/livestream/[a-zA-Z0-9]+/reaction 0.004 1.068 100.396 0.234 0.516 0.584 0.680 0.193 0.000 37844.000 4799393.000 11187.396
446 0 431 0 15 0 POST /api/livestream/[a-zA-Z0-9]+/livecomment 0.008 0.612 67.272 0.151 0.264 0.316 0.536 0.092 0.000 2674.000 854029.000 1914.863
280 0 277 0 2 1 POST /api/register 0.004 0.628 58.972 0.211 0.332 0.416 0.496 0.095 0.000 504.000 129818.000 463.636
58 0 56 0 2 0 GET /api/livestream/[a-zA-Z0-9]+$ 0.004 2.304 48.204 0.831 1.496 1.736 2.304 0.512 0.000 126624.000 3958954.000 68257.828
99 0 95 0 4 0 POST /api/livestream/[a-zA-Z0-9]+$ 0.000 1.232 44.964 0.454 0.832 0.944 1.232 0.335 0.000 1446.000 107061.000 1081.424
372 0 372 0 0 0 POST /api/livestream/[a-zA-Z0-9]+/reaction 0.004 0.556 32.896 0.088 0.192 0.264 0.372 0.078 1552.000 2186.000 687117.000 1847.089
2 0 2 0 0 0 GET /api/livestream/[a-zA-Z0-9]+/statistics 6.852 6.852 13.704 6.852 6.852 6.852 6.852 0.000 100.000 102.000 202.000 101.000
285 0 283 0 2 0 POST /api/login 0.004 0.528 13.564 0.048 0.132 0.176 0.416 0.074 0.000 64.000 128.000 0.449
1 0 1 0 0 0 POST /api/initialize 10.788 10.788 10.788 10.788 10.788 10.788 10.788 0.000 27.000 27.000 27.000 27.000
63 0 63 0 0 0 GET /api/livestream$ 0.008 0.292 7.252 0.115 0.232 0.268 0.292 0.081 3.000 22391.000 120789.000 1917.286
79 0 79 0 0 0 GET /api/tag 0.004 0.356 4.284 0.054 0.148 0.188 0.356 0.064 6089.000 6095.000 481313.000 6092.570
44 0 42 0 0 2 GET /api/livestream/[a-zA-Z0-9]+/report 0.008 0.428 3.904 0.089 0.260 0.280 0.428 0.102 3.000 5514.000 43797.000 995.386
33 0 33 0 0 0 GET /api/livestream/[a-zA-Z0-9]+/ngwords 0.004 0.396 3.812 0.116 0.180 0.272 0.396 0.072 5.000 277.000 956.000 28.970
38 0 38 0 0 0 POST /api/livestream/[a-zA-Z0-9]+/enter 0.004 0.460 2.916 0.077 0.220 0.436 0.460 0.107 0.000 0.000 0.000 0.000
31 0 31 0 0 0 DELETE /api/livestream/[a-zA-Z0-9]+/exit 0.004 0.460 1.644 0.053 0.112 0.228 0.460 0.089 0.000 0.000 0.000 0.000
278 0 278 0 0 0 POST /api/icon 0.000 0.016 0.728 0.003 0.004 0.008 0.012 0.003 14.000 14.000 3892.000 14.000
6 0 6 0 0 0 GET /api/user/[a-zA-Z0-9]+/theme 0.008 0.124 0.296 0.049 0.124 0.124 0.124 0.043 38.000 38.000 228.000 38.000
4 0 4 0 0 0 GET /api/user/[a-zA-Z0-9]+$ 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 235.000 247.000 964.000 241.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
github-actions[bot] commented 11 months ago 
Reading from STDIN ...

# 35.7s user time, 160ms system time, 35.81M rss, 42.34M vsz
# Current date: Sat Nov 25 05:03:36 2023
# Hostname: ip-192-168-0-13
# Files: STDIN
# Overall: 579.95k total, 93 unique, 233.10 QPS, 0.17x concurrency _______
# Time range: 2023-11-25T04:16:40 to 2023-11-25T04:58:08
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time           432s     1us   335ms   745us     3ms     4ms    66us
# Lock time          786ms       0    36ms     1us     1us   106us       0
# Rows sent        239.16k       0   7.32k    0.42    0.99   16.98       0
# Rows examine      91.85M       0  14.03k  166.08   1.09k  663.15       0
# Query size        38.18M       5   1.94M   69.03  299.03   2.71k   31.70

# Profile
# Rank Query ID                           Response time Calls  R/Call V/M 
# ==== ================================== ============= ====== ====== ====
#    1 0xDA556F9115773A1A99AA0165670CE848 60.0274 13.9% 174616 0.0003  0.00 ADMIN PREPARE
#    2 0x42EF7D7D98FBCC9723BF896EBFC51D24 52.0896 12.1%   6479 0.0080  0.01 SELECT records
#    3 0xF1B8EF06D6CA63B24BFF433E06CCEB22 44.3210 10.3%   3240 0.0137  0.02 SELECT users livestreams livecomments
#    4 0xDB74D52D39A7090F224C4DEEAF3028C9 44.0947 10.2%   3242 0.0136  0.02 SELECT users livestreams reactions
#    5 0x38BC86A45F31C6B1EE324671506C898A 39.7303  9.2%  15953 0.0025  0.00 SELECT themes
#    6 0x3D83BC87F3B3A00D571FFC8104A6E50C 31.3455  7.3%   4981 0.0063  0.01 SELECT records
#    7 0x4ADE2DC90689F1C4891749AF54FB8D14 20.1224  4.7%  39700 0.0005  0.00 DELETE SELECT livecomments
#    8 0x64CC8A4E8E4B390203375597CE4D611F 20.0209  4.6%    396 0.0506  0.01 SELECT ng_words
#    9 0x59F1B6DD8D9FEC059E55B3BFD624E8C3 18.7469  4.3%    793 0.0236  0.01 SELECT reservation_slots
#   10 0xFBC5564AE716EAE82F20BFB45F6C37E7 14.0795  3.3%  39132 0.0004  0.00 SELECT tags
#   11 0xFFFCA4D67EA0A788813031B8BBC3B329  9.9078  2.3%   2937 0.0034  0.00 COMMIT
#   12 0x22279D81D51006139E0C76405B54C261  6.0001  1.4%   7420 0.0008  0.00 SELECT domains domainmetadata
#   13 0xEA1E6309EEEFF9A6831AD2FB940FC23C  5.8727  1.4%  15672 0.0004  0.00 SELECT users
#   14 0xF7144185D9A142A426A36DC55C1D2623  5.4304  1.3%   9725 0.0006  0.00 SELECT livestream_tags
#   15 0x859BBB7E9D760686137A944406874C4D  5.1668  1.2%    278 0.0186  0.01 DELETE records
#   16 0x8F7679D452333ED3C7D60D22131CEFD4  5.1291  1.2%  20370 0.0003  0.00 ADMIN RESET STMT
#   17 0xA3401CA3ABCC04C3AB221DB8AD5CBF26  4.8540  1.1%     95 0.0511  0.03 UPDATE reservation_slots
#   18 0x7F9C0C0BA9473953B723EE16C08655F1  4.3192  1.0%     96 0.0450  0.02 SELECT reservation_slots
#   19 0xFD38427AE3D09E3883A680F7BAF95D3A  4.2273  1.0%  14992 0.0003  0.00 SELECT livestreams livecomments
#   20 0xDFFCC1D78939C4D781C7C58349101F50  4.2247  1.0%   1000 0.0042  0.00 INSERT users
#   21 0xD2A0864774622BA36F6557496405CF75  4.2231  1.0%   1278 0.0033  0.00 INSERT themes
#   22 0xC499D81D570D361DB61FC43A94BB888A  3.7533  0.9%  14992 0.0003  0.00 SELECT livestreams reactions
#   23 0xD6032FE08E1FE706A928B8B7CBA06B85  3.2884  0.8%   7994 0.0004  0.00 SELECT livestreams
#   24 0x9AC623FA477E73A44D191D296850A025  3.0239  0.7%    556 0.0054  0.01 SELECT records
#   25 0x9EAD6C0CE525E3693EE27FFC9AAF05A3  2.8605  0.7%     65 0.0440  0.02 SELECT livestreams
#   26 0xEDE18C1523658A19E07525EAFCBA6BFE  1.8753  0.4%     33 0.0568  0.01 SELECT ng_words
#   27 0x07890000813C4CC7111FD2D3F3B3B4EB  1.7984  0.4% 174593 0.0000  0.00 ADMIN CLOSE STMT
#   28 0xB08B7B7486D2DFE2F2FE9CE78689FD79  1.5159  0.4%     27 0.0561  0.01 SELECT ng_words
#   29 0x3F155F5E71EFF856F0CF7B8430DE8C23  1.2843  0.3%   3618 0.0004  0.00 SELECT users
#   30 0xFFF66E9B3D962FA319C8068B5C1997CD  1.1664  0.3%   3349 0.0003  0.00 ROLLBACK
#   31 0xB78E63D0D9C72DDDAB7A3E53517FA04C  1.1592  0.3%    357 0.0032  0.00 SELECT livecomments
#   32 0xAD0C28443E1E5CFAFF1569DBB4F7E63A  1.1012  0.3%    393 0.0028  0.00 SELECT reactions
#   33 0x9E2DA589A20EC24C34E11DDE0FBF5564  0.9034  0.2%   6021 0.0002  0.00 START
#   34 0x98F959E03B684A5538FD8402A0EE94AD  0.4298  0.1%    103 0.0042  0.00 INSERT tags
#   35 0x77FB9E134D073862D1E78FEEC3436291  0.4048  0.1%   1558 0.0003  0.00 INSERT records
#   36 0x02B6A87E51A5A1B7646675DB67C57DE3  0.3347  0.1%      1 0.3347  0.00 INSERT ng_words
#   37 0x41F805E95754958A974F41AE07BEA625  0.3300  0.1%     34 0.0097  0.01 SELECT livecomments
#   38 0x80E10371CE74ED05E09C79C72C73F8E1  0.3283  0.1%     96 0.0034  0.21 INSERT livestreams
#   39 0x0C1FCBB4E25B178AA3A46D4FECBA9BDC  0.3047  0.1%     22 0.0138  0.00 INSERT livestream_tags
#   40 0xF3A502CCF34F7DA288CC1B75AD5AFA37  0.2675  0.1%    395 0.0007  0.00 INSERT livecomments
#   41 0xB9AC05A7AE6C4E30B5B45F6F3CE05BE0  0.1881  0.0%    566 0.0003  0.00 SET
#   42 0x5AEB6E4A781A3854CF642125E293FEE0  0.1792  0.0%    372 0.0005  0.00 INSERT reactions
#   43 0x5D469B53C536D19CD15E40763ACC23C7  0.1634  0.0%    397 0.0004  0.00 INSERT livestream_tags
#   44 0x64052B1C32B30DF53AB3292208B783B4  0.1454  0.0%    279 0.0005  0.00 INSERT users
#   45 0xDF0AAE38E2AAFC85E6F50569CEF2285D  0.1341  0.0%      1 0.1341  0.00 INSERT reservation_slots
#   46 0x651E3772B8767A368CB47EE7389EEB33  0.1330  0.0%     15 0.0089  0.02 SELECT livestream_tags
#   47 0xE64D50F7AFC1AD5F465809A92DF4935E  0.1082  0.0%     36 0.0030  0.00 SELECT reactions
#   48 0xEE4C51AE2BF74414C4892CBE11E894AA  0.0973  0.0%     37 0.0026  0.00 SELECT livecomments
#   49 0x4B6FA79E206C6CED71D433A2FC998D69  0.0878  0.0%    131 0.0007  0.00 SELECT
#   50 0xE623383C5D789800DC0946925F90039F  0.0650  0.0%    279 0.0002  0.00 SELECT domains
#   51 0x24C44C3518CE12293EF12410AEDA2393  0.0509  0.0%     42 0.0012  0.00 SELECT livestreams
#   52 0x544239977D2094F805A7B062DE95673A  0.0466  0.0%     79 0.0006  0.00 SELECT tags
#   53 0xAFFDC331C1D4BA089978A0B8DD00BFC8  0.0428  0.0%      1 0.0428  0.00 TRUNCATE TABLE livestreams
#   54 0x08A6ACD83D579DD8A808134B32AD376B  0.0389  0.0%      1 0.0389  0.00 TRUNCATE TABLE livestream_tags
#   55 0xDBB1C17D6ABA0156D8ABCE105DDDA1B2  0.0364  0.0%      1 0.0364  0.00 TRUNCATE TABLE users
#   56 0x1FB70DBF74628C9F2E9F0C3478771936  0.0358  0.0%      1 0.0358  0.00 TRUNCATE TABLE ng_words
#   57 0x19A1F14EFC0F221D30AFCB1E1344BEBD  0.0356  0.0%      7 0.0051  0.00 SELECT users
#   58 0x2AAED5867123C749367FD8E4BBD796D2  0.0323  0.0%      1 0.0323  0.00 TRUNCATE TABLE livecomments
#   59 0xBB7F4DC4E67BF30E0588D296FFAF009F  0.0318  0.0%      1 0.0318  0.00 TRUNCATE TABLE tags
#   60 0xD2978B45C67B47B5D73AC532EB40A95E  0.0299  0.0%      1 0.0299  0.00 TRUNCATE TABLE themes
#   61 0x07F6C3FF39ADD79FC63923A7EE938953  0.0295  0.0%      1 0.0295  0.00 INSERT livecomments
#   62 0x9C697B3F0446BBF7602663588252F020  0.0294  0.0%      1 0.0294  0.00 TRUNCATE TABLE livestream_viewers_history
#   63 0x81E419F4B58AEB9B280B03DE44DD8B94  0.0288  0.0%    105 0.0003  0.00 SELECT livecomments
#   64 0x253CA101A906B3D56A95D1B8DCEE28EF  0.0285  0.0%      1 0.0285  0.00 TRUNCATE TABLE icons
#   65 0x8D589AFA4DFAEEED85FFF5AA78E5FF6A  0.0281  0.0%    279 0.0001  0.00 BEGIN
#   66 0xA7C2E59AEF14D03CB65B227F3E3BA469  0.0280  0.0%      1 0.0280  0.00 TRUNCATE TABLE reservation_slots
#   67 0x050F7D44808F43E5D33D0B90BCF57CC9  0.0262  0.0%      2 0.0131  0.00 SELECT livestreams
#   68 0xFB296F703ACC41C3F94A9B7D75044F3C  0.0258  0.0%      1 0.0258  0.00 TRUNCATE TABLE reactions
#   69 0x93A42F50BF286ACA749DF5F342FAC07B  0.0252  0.0%      1 0.0252  0.00 TRUNCATE TABLE livecomment_reports
#   70 0xB871CC5B0472067402F5739D108B2C1C  0.0252  0.0%     27 0.0009  0.00 SELECT livestreams
#   71 0x74232BDFFB94C567F0340DBE3285E458  0.0197  0.0%      1 0.0197  0.00 INSERT reactions
#   72 0xB962B14EDA3C9149DE2F648A5F0347D5  0.0197  0.0%      1 0.0197  0.00 SELECT domains records
#   73 0x0C655718656DD9DDA39A0D11554A0C64  0.0139  0.0%     27 0.0005  0.00 INSERT ng_words
#   74 0x466EE4C87B17CAD4E692DE1D44EAD84D  0.0135  0.0%     44 0.0003  0.00 SELECT livecomment_reports
#   75 0xBF3194A2446AC20FC99B6CC7FA476A57  0.0125  0.0%     38 0.0003  0.00 INSERT livestream_viewers_history
#   76 0xA0D956F292B7FEA0DCE68A5DD5F529E1  0.0116  0.0%     31 0.0004  0.00 DELETE livestream_viewers_history
#   77 0x827F41D30F8E37F04D8BDCD46C556FB3  0.0114  0.0%     37 0.0003  0.00 INSERT livecomment_reports
#   78 0xDFEFE5BA5D8654534DC8550C6E3DC9C0  0.0113  0.0%      1 0.0113  0.00 DELETE records
#   79 0x2B760561C10B5D133155AA306D0F407C  0.0071  0.0%     18 0.0004  0.00 SELECT livecomments
#   80 0xF985E5835B84E84C7A721801818E98CE  0.0050  0.0%      2 0.0025  0.00 SELECT users livestreams reactions
#   81 0x49F80FBE1AC70F23A3DD076174FF1AA9  0.0046  0.0%      2 0.0023  0.00 SELECT users livestreams reactions
#   82 0x20CD15DC47AF2F861B8F3C25D195ABE9  0.0019  0.0%     15 0.0001  0.00 SELECT tags
#   83 0x2C17BCA1E1077820CDC2EC6106F4D93E  0.0011  0.0%     18 0.0001  0.00 SELECT livestream_viewers_history
#   84 0x8B2044ADAE690405979131C33185F22A  0.0010  0.0%      6 0.0002  0.00 SELECT users
#   85 0xEDBC971AEC392917AA353644DE4C4CB4  0.0009  0.0%    416 0.0000  0.00 ADMIN QUIT
#   86 0x0E7680C04FF2596BE3A3649C5FAC418D  0.0007  0.0%      9 0.0001  0.00 SELECT
#   87 0xEBE4AF9F935DE1D48BB5BB3558C7FCC4  0.0006  0.0%      2 0.0003  0.00 SELECT livestreams livecomments
#   88 0x8F885091E23CB955C051B1204EE7D91D  0.0005  0.0%      2 0.0002  0.00 SELECT livestreams reactions
#   89 0xC4625761E0CFD817F41B4802F152A489  0.0004  0.0%      1 0.0004  0.00 SELECT livecomments
#   90 0xE84E602C0D0858D5661956B70D72A215  0.0002  0.0%      1 0.0002  0.00 SELECT icons
#   91 0x394E66DDE2823A903078D4C0F235B948  0.0002  0.0%      2 0.0001  0.00 SELECT livestreams livecomment_reports
#   92 0xF085F31DC1964EA538732B713E4B4108  0.0002  0.0%      2 0.0001  0.00 SELECT livestreams livestream_viewers_history
#   93 0xE8390778DC20D4CC04FE01C5B31FD305  0.0000  0.0%      1 0.0000  0.00 ADMIN PING

# Query 1: 253.80 QPS, 0.09x concurrency, ID 0xDA556F9115773A1A99AA0165670CE848 at byte 40432457
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T04:16:40 to 2023-11-25T04:28:08
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         30  174616
# Exec time     13     60s    21us   198ms   343us     1ms     1ms    84us
# Lock time      0    15us       0    13us       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    13   5.00M      30      30      30      30       0      30
# String:
# Databases    isupipe (172934/99%), isudns (1682/0%)
# Hosts        localhost
# Users        isucon (172934/99%), isudns (1682/0%)
# Query_time distribution
#   1us
#  10us  ################################################################
# 100us  ###########################################
#   1ms  #########
#  10ms  #
# 100ms  #
#    1s
#  10s+
administrator command: Prepare\G

# Query 2: 62.90 QPS, 0.51x concurrency, ID 0x42EF7D7D98FBCC9723BF896EBFC51D24 at byte 116043915
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T04:16:40 to 2023-11-25T04:18:23
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          1    6479
# Exec time     12     52s   715us    72ms     8ms    21ms     7ms     6ms
# Lock time      3    31ms       0     6ms     4us     1us   101us     1us
# Rows sent      0   1.83k       0       1    0.29    0.99    0.45       0
# Rows examine   9   8.78M   1.25k   1.52k   1.39k   1.46k   77.96   1.33k
# Query size     2 888.81k     129     211  140.48  158.58   11.03  136.99
# String:
# Databases    isudns
# 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 3: 37.67 QPS, 0.52x concurrency, ID 0xF1B8EF06D6CA63B24BFF433E06CCEB22 at byte 138515776
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.02
# Time range: 2023-11-25T04:16:51 to 2023-11-25T04:18:17
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0    3240
# Exec time     10     44s     2ms   101ms    14ms    51ms    17ms     2ms
# Lock time      0     7ms       0     1ms     2us     1us    20us     1us
# Rows sent      1   3.16k       1       1       1       1       0       1
# Rows examine   7   6.44M   1.96k   2.40k   2.04k   2.38k  142.19   1.96k
# Query size     1 521.33k     163     166  164.77  158.58       0  158.58
# String:
# Databases    isupipe
# 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 = 194\G

# Query 4: 37.70 QPS, 0.51x concurrency, ID 0xDB74D52D39A7090F224C4DEEAF3028C9 at byte 55625663
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.02
# Time range: 2023-11-25T04:16:51 to 2023-11-25T04:18:17
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0    3242
# Exec time     10     44s     2ms    96ms    14ms    48ms    17ms     2ms
# Lock time      1    14ms       0     5ms     4us     1us    95us     1us
# Rows sent      1   3.17k       1       1       1       1       0       1
# Rows examine   7   6.46M   1.96k   2.38k   2.04k   2.38k  142.18   1.96k
# Query size     1 458.34k     143     146  144.77  143.84    0.95  143.84
# String:
# Databases    isupipe
# 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 = 58\G

# Query 5: 173.40 QPS, 0.43x concurrency, ID 0x38BC86A45F31C6B1EE324671506C898A at byte 46719901
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T04:16:51 to 2023-11-25T04:18:23
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          2   15953
# Exec time      9     40s   242us    44ms     2ms     8ms     3ms     1ms
# Lock time      3    27ms       0     2ms     1us     1us    19us     1us
# Rows sent      6  15.58k       1       1       1       1       0       1
# Rows examine  18  17.34M    1000   1.25k   1.11k   1.20k   85.33   1.09k
# Query size     1 636.59k      38      41   40.86   40.45    0.65   40.45
# String:
# Databases    isupipe
# Hosts        localhost
# Users        isucon
# Query_time distribution
#   1us
#  10us
# 100us  ###############################################
#   1ms  ################################################################
#  10ms  ###
# 100ms
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS FROM `isupipe` LIKE 'themes'\G
#    SHOW CREATE TABLE `isupipe`.`themes`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM themes WHERE user_id = 1032\G