search

niftyisucon / isucon13

0 stars 0 forks source link

Benchmark result on isu2(6422) #18

Open github-actions[bot] opened 10 months ago

github-actions[bot] commented 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)
3381 0 3377 0 4 0 GET /api/user/[a-zA-Z0-9]+/icon 0.004 0.968 152.320 0.045 0.128 0.184 0.360 0.074 0.000 171652.000 187686003.000 55511.980
375 0 373 0 2 0 GET /api/livestream/[a-zA-Z0-9]+/livecomment 0.004 1.048 112.852 0.301 0.632 0.764 0.940 0.228 0.000 50746.000 5795741.000 15455.309
8 0 2 0 6 0 GET /api/user/[a-zA-Z0-9]+/statistics 1.420 20.004 108.088 13.511 20.004 20.004 20.004 8.396 0.000 140.000 273.000 34.125
26 0 25 0 1 0 POST /api/livestream/[a-zA-Z0-9]+/moderate 0.104 10.252 107.844 4.148 7.784 7.872 10.252 2.134 0.000 23.000 575.000 22.115
407 0 404 0 3 0 GET /api/livestream/[a-zA-Z0-9]+/reaction 0.004 1.264 106.832 0.262 0.596 0.708 0.988 0.242 0.000 45189.000 4935570.000 12126.708
428 0 420 0 8 0 POST /api/livestream/[a-zA-Z0-9]+/livecomment 0.008 0.640 59.772 0.140 0.232 0.280 0.428 0.078 57.000 2655.000 835452.000 1951.991
279 0 276 0 2 1 POST /api/register 0.004 0.732 59.612 0.214 0.348 0.420 0.568 0.106 0.000 513.000 129300.000 463.441
62 0 60 0 2 0 GET /api/livestream/[a-zA-Z0-9]+$ 0.004 2.176 53.240 0.859 1.272 1.832 2.176 0.502 0.000 126628.000 4210309.000 67908.210
101 0 97 0 4 0 POST /api/livestream/[a-zA-Z0-9]+$ 0.032 1.056 44.244 0.438 0.800 0.864 1.020 0.311 0.000 1470.000 109532.000 1084.475
350 0 350 0 0 0 POST /api/livestream/[a-zA-Z0-9]+/reaction 0.004 0.472 28.864 0.082 0.168 0.248 0.328 0.071 1552.000 2213.000 644700.000 1842.000
284 0 282 0 2 0 POST /api/login 0.004 0.396 14.348 0.051 0.140 0.220 0.356 0.076 0.000 64.000 128.000 0.451
73 0 73 0 0 0 GET /api/livestream$ 0.012 0.680 9.952 0.136 0.264 0.440 0.680 0.131 3.000 22475.000 128479.000 1759.986
1 0 1 0 0 0 POST /api/initialize 9.488 9.488 9.488 9.488 9.488 9.488 9.488 0.000 27.000 27.000 27.000 27.000
82 0 82 0 0 0 GET /api/tag 0.008 0.460 5.572 0.068 0.168 0.248 0.460 0.086 6089.000 6095.000 499592.000 6092.585
36 0 36 0 0 0 GET /api/livestream/[a-zA-Z0-9]+/ngwords 0.004 0.624 4.588 0.127 0.256 0.492 0.624 0.121 5.000 149.000 846.000 23.500
51 0 50 0 0 1 GET /api/livestream/[a-zA-Z0-9]+/report 0.004 0.392 3.656 0.072 0.196 0.284 0.392 0.092 3.000 19380.000 60178.000 1179.961
38 0 38 0 0 0 POST /api/livestream/[a-zA-Z0-9]+/enter 0.004 0.460 2.540 0.067 0.232 0.240 0.460 0.092 0.000 0.000 0.000 0.000
7 0 0 0 7 0 - - 0.110 0.217 1.401 0.200 0.217 0.217 0.217 0.037 166.000 166.000 1162.000 166.000
28 0 28 0 0 0 DELETE /api/livestream/[a-zA-Z0-9]+/exit 0.004 0.344 1.328 0.047 0.160 0.204 0.344 0.074 0.000 0.000 0.000 0.000
276 0 276 0 0 0 POST /api/icon 0.004 0.012 0.612 0.002 0.004 0.004 0.012 0.002 14.000 14.000 3864.000 14.000
7 0 7 0 0 0 GET /api/user/[a-zA-Z0-9]+/theme 0.004 0.104 0.276 0.039 0.104 0.104 0.104 0.035 38.000 38.000 266.000 38.000
22 0 2 0 20 0 GET /api/livestream/[a-zA-Z0-9]+/statistics 0.016 0.020 0.044 0.002 0.004 0.016 0.020 0.005 55.000 102.000 1302.000 59.182
5 0 4 0 1 0 GET /api/user/[a-zA-Z0-9]+$ 0.004 0.004 0.008 0.002 0.004 0.004 0.004 0.002 55.000 247.000 1019.000 203.800
1 0 0 1 0 0 GET /assets/index-5265c558.css 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
1 0 0 1 0 0 GET /assets/ISUPipe_yoko_color-fc80178e.png 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
2 0 0 2 0 0 GET /assets/index-55457d82.js 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.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
1 0 0 0 1 0 GET /api/v1/timestamp 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 134.000 134.000 134.000 134.000
1 0 0 1 0 0 GET /favicon.ico 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
2 0 0 1 1 0 GET / 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 264.000 264.000 132.000
github-actions[bot] commented 10 months ago 
Reading from STDIN ...

# 30s user time, 150ms system time, 36.07M rss, 42.48M vsz
# Current date: Sat Nov 25 05:29:15 2023
# Hostname: ip-192-168-0-12
# Files: STDIN
# Overall: 501.60k total, 97 unique, 382.32 QPS, 0.31x concurrency _______
# Time range: 2023-11-25T05:05:15 to 2023-11-25T05:27:07
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time           401s     1us   320ms   800us     3ms     3ms    73us
# Lock time          593ms       0    24ms     1us     1us    77us       0
# Rows sent        217.91k       0   7.32k    0.44    0.99   18.05       0
# Rows examine      67.98M       0  16.60k  142.11   1.20k  695.28       0
# Query size        32.90M       5   1.94M   68.78  313.99   2.92k   31.70

# Profile
# Rank Query ID                           Response time Calls  R/Call V/M 
# ==== ================================== ============= ====== ====== ====
#    1 0xDA556F9115773A1A99AA0165670CE848 59.0366 14.7% 148123 0.0004  0.00 ADMIN PREPARE
#    2 0x42EF7D7D98FBCC9723BF896EBFC51D24 50.6444 12.6%   6621 0.0076  0.01 SELECT records
#    3 0x38BC86A45F31C6B1EE324671506C898A 40.7231 10.1%  16718 0.0024  0.00 SELECT themes
#    4 0xF1B8EF06D6CA63B24BFF433E06CCEB22 37.0606  9.2%   4032 0.0092  0.01 SELECT users livestreams livecomments
#    5 0xDB74D52D39A7090F224C4DEEAF3028C9 36.0857  9.0%   4035 0.0089  0.01 SELECT users livestreams reactions
#    6 0x3D83BC87F3B3A00D571FFC8104A6E50C 30.7103  7.6%   5092 0.0060  0.01 SELECT records
#    7 0x4ADE2DC90689F1C4891749AF54FB8D14 18.7111  4.7%  36441 0.0005  0.00 DELETE SELECT livecomments
#    8 0x59F1B6DD8D9FEC059E55B3BFD624E8C3 17.8006  4.4%    827 0.0215  0.01 SELECT reservation_slots
#    9 0x64CC8A4E8E4B390203375597CE4D611F 17.6624  4.4%    377 0.0468  0.01 SELECT ng_words
#   10 0xFBC5564AE716EAE82F20BFB45F6C37E7 15.1628  3.8%  41996 0.0004  0.00 SELECT tags
#   11 0xFFFCA4D67EA0A788813031B8BBC3B329  9.9055  2.5%   2887 0.0034  0.00 COMMIT
#   12 0xEA1E6309EEEFF9A6831AD2FB940FC23C  6.2306  1.6%  16435 0.0004  0.00 SELECT users
#   13 0x22279D81D51006139E0C76405B54C261  6.0341  1.5%   7674 0.0008  0.00 SELECT domains domainmetadata
#   14 0xF7144185D9A142A426A36DC55C1D2623  5.3679  1.3%  10200 0.0005  0.00 SELECT livestream_tags
#   15 0x859BBB7E9D760686137A944406874C4D  5.0385  1.3%    277 0.0182  0.01 DELETE records
#   16 0x8F7679D452333ED3C7D60D22131CEFD4  5.0165  1.2%  20991 0.0002  0.00 ADMIN RESET STMT
#   17 0xA3401CA3ABCC04C3AB221DB8AD5CBF26  4.3789  1.1%     97 0.0451  0.02 UPDATE reservation_slots
#   18 0x7F9C0C0BA9473953B723EE16C08655F1  4.1942  1.0%     98 0.0428  0.02 SELECT reservation_slots
#   19 0xD2A0864774622BA36F6557496405CF75  3.8779  1.0%   1277 0.0030  0.00 INSERT themes
#   20 0xDFFCC1D78939C4D781C7C58349101F50  3.6479  0.9%   1000 0.0036  0.00 INSERT users
#   21 0x9EAD6C0CE525E3693EE27FFC9AAF05A3  3.3981  0.8%     75 0.0453  0.01 SELECT livestreams
#   22 0xD6032FE08E1FE706A928B8B7CBA06B85  3.1765  0.8%   8267 0.0004  0.00 SELECT livestreams
#   23 0x9AC623FA477E73A44D191D296850A025  2.8951  0.7%    554 0.0052  0.01 SELECT records
#   24 0xEDE18C1523658A19E07525EAFCBA6BFE  1.7768  0.4%     36 0.0494  0.01 SELECT ng_words
#   25 0x07890000813C4CC7111FD2D3F3B3B4EB  1.6962  0.4% 148102 0.0000  0.00 ADMIN CLOSE STMT
#   26 0x3F155F5E71EFF856F0CF7B8430DE8C23  1.4758  0.4%   3670 0.0004  0.00 SELECT users
#   27 0xB08B7B7486D2DFE2F2FE9CE78689FD79  1.3122  0.3%     26 0.0505  0.01 SELECT ng_words
#   28 0xFFF66E9B3D962FA319C8068B5C1997CD  1.2492  0.3%   3395 0.0004  0.00 ROLLBACK
#   29 0xB78E63D0D9C72DDDAB7A3E53517FA04C  1.0473  0.3%    338 0.0031  0.00 SELECT livecomments
#   30 0xAD0C28443E1E5CFAFF1569DBB4F7E63A  0.9819  0.2%    371 0.0026  0.00 SELECT reactions
#   31 0x9E2DA589A20EC24C34E11DDE0FBF5564  0.9640  0.2%   6017 0.0002  0.00 START
#   32 0x77FB9E134D073862D1E78FEEC3436291  0.3630  0.1%   1557 0.0002  0.00 INSERT records
#   33 0x98F959E03B684A5538FD8402A0EE94AD  0.3594  0.1%    103 0.0035  0.00 INSERT tags
#   34 0x02B6A87E51A5A1B7646675DB67C57DE3  0.3196  0.1%      1 0.3196  0.00 INSERT ng_words
#   35 0x41F805E95754958A974F41AE07BEA625  0.3129  0.1%     32 0.0098  0.01 SELECT livecomments
#   36 0x80E10371CE74ED05E09C79C72C73F8E1  0.3062  0.1%     98 0.0031  0.17 INSERT livestreams
#   37 0x0C1FCBB4E25B178AA3A46D4FECBA9BDC  0.2645  0.1%     22 0.0120  0.00 INSERT livestream_tags
#   38 0xF3A502CCF34F7DA288CC1B75AD5AFA37  0.2393  0.1%    376 0.0006  0.00 INSERT livecomments
#   39 0xB9AC05A7AE6C4E30B5B45F6F3CE05BE0  0.2030  0.1%    557 0.0004  0.00 SET
#   40 0x5D469B53C536D19CD15E40763ACC23C7  0.1798  0.0%    407 0.0004  0.00 INSERT livestream_tags
#   41 0x5AEB6E4A781A3854CF642125E293FEE0  0.1385  0.0%    350 0.0004  0.00 INSERT reactions
#   42 0x64052B1C32B30DF53AB3292208B783B4  0.1312  0.0%    278 0.0005  0.00 INSERT users
#   43 0x651E3772B8767A368CB47EE7389EEB33  0.1304  0.0%     15 0.0087  0.01 SELECT livestream_tags
#   44 0xDF0AAE38E2AAFC85E6F50569CEF2285D  0.1288  0.0%      1 0.1288  0.00 INSERT reservation_slots
#   45 0xEE4C51AE2BF74414C4892CBE11E894AA  0.1273  0.0%     37 0.0034  0.00 SELECT livecomments
#   46 0xE64D50F7AFC1AD5F465809A92DF4935E  0.1182  0.0%     36 0.0033  0.00 SELECT reactions
#   47 0x19A1F14EFC0F221D30AFCB1E1344BEBD  0.0779  0.0%      8 0.0097  0.01 SELECT users
#   48 0xE623383C5D789800DC0946925F90039F  0.0648  0.0%    278 0.0002  0.00 SELECT domains
#   49 0x4B6FA79E206C6CED71D433A2FC998D69  0.0635  0.0%    129 0.0005  0.00 SELECT
#   50 0x544239977D2094F805A7B062DE95673A  0.0564  0.0%     82 0.0007  0.00 SELECT tags
#   51 0x81E419F4B58AEB9B280B03DE44DD8B94  0.0467  0.0%    118 0.0004  0.00 SELECT livecomments
#   52 0xAFFDC331C1D4BA089978A0B8DD00BFC8  0.0387  0.0%      1 0.0387  0.00 TRUNCATE TABLE livestreams
#   53 0x24C44C3518CE12293EF12410AEDA2393  0.0382  0.0%     46 0.0008  0.00 SELECT livestreams
#   54 0xDBB1C17D6ABA0156D8ABCE105DDDA1B2  0.0361  0.0%      1 0.0361  0.00 TRUNCATE TABLE users
#   55 0x1FB70DBF74628C9F2E9F0C3478771936  0.0332  0.0%      1 0.0332  0.00 TRUNCATE TABLE ng_words
#   56 0x253CA101A906B3D56A95D1B8DCEE28EF  0.0288  0.0%      1 0.0288  0.00 TRUNCATE TABLE icons
#   57 0xD2978B45C67B47B5D73AC532EB40A95E  0.0278  0.0%      1 0.0278  0.00 TRUNCATE TABLE themes
#   58 0x08A6ACD83D579DD8A808134B32AD376B  0.0269  0.0%      1 0.0269  0.00 TRUNCATE TABLE livestream_tags
#   59 0x07F6C3FF39ADD79FC63923A7EE938953  0.0267  0.0%      1 0.0267  0.00 INSERT livecomments
#   60 0x2AAED5867123C749367FD8E4BBD796D2  0.0249  0.0%      1 0.0249  0.00 TRUNCATE TABLE livecomments
#   61 0x9C697B3F0446BBF7602663588252F020  0.0249  0.0%      1 0.0249  0.00 TRUNCATE TABLE livestream_viewers_history
#   62 0xBB7F4DC4E67BF30E0588D296FFAF009F  0.0247  0.0%      1 0.0247  0.00 TRUNCATE TABLE tags
#   63 0x8D589AFA4DFAEEED85FFF5AA78E5FF6A  0.0247  0.0%    278 0.0001  0.00 BEGIN
#   64 0xFB296F703ACC41C3F94A9B7D75044F3C  0.0234  0.0%      1 0.0234  0.00 TRUNCATE TABLE reactions
#   65 0xA7C2E59AEF14D03CB65B227F3E3BA469  0.0232  0.0%      1 0.0232  0.00 TRUNCATE TABLE reservation_slots
#   66 0xE4555A2709C09FD9BFF6688D80B0AA49  0.0214  0.0%      2 0.0107  0.00 SELECT livestreams reactions livecomments
#   67 0x93A42F50BF286ACA749DF5F342FAC07B  0.0213  0.0%      1 0.0213  0.00 TRUNCATE TABLE livecomment_reports
#   68 0x74232BDFFB94C567F0340DBE3285E458  0.0202  0.0%      1 0.0202  0.00 INSERT reactions
#   69 0xA0D956F292B7FEA0DCE68A5DD5F529E1  0.0193  0.0%     28 0.0007  0.01 DELETE livestream_viewers_history
#   70 0x466EE4C87B17CAD4E692DE1D44EAD84D  0.0178  0.0%     51 0.0003  0.00 SELECT livecomment_reports
#   71 0x0C655718656DD9DDA39A0D11554A0C64  0.0161  0.0%     26 0.0006  0.00 INSERT ng_words
#   72 0x827F41D30F8E37F04D8BDCD46C556FB3  0.0134  0.0%     44 0.0003  0.00 INSERT livecomment_reports
#   73 0xDFEFE5BA5D8654534DC8550C6E3DC9C0  0.0104  0.0%      1 0.0104  0.00 DELETE records
#   74 0xBF3194A2446AC20FC99B6CC7FA476A57  0.0085  0.0%     38 0.0002  0.00 INSERT livestream_viewers_history
#   75 0xB871CC5B0472067402F5739D108B2C1C  0.0073  0.0%     26 0.0003  0.00 SELECT livestreams
#   76 0xD5F9AAF38A54E3229B21BBFF69416C3E  0.0071  0.0%      1 0.0071  0.00 SELECT users livestreams reactions livestreams livecomments
#   77 0x8B4C4496A5E88C5D47D52AF3344B9AA9  0.0070  0.0%      1 0.0070  0.00 SELECT users livestreams reactions livecomments
#   78 0x2B760561C10B5D133155AA306D0F407C  0.0070  0.0%     18 0.0004  0.00 SELECT livecomments
#   79 0xF985E5835B84E84C7A721801818E98CE  0.0030  0.0%      2 0.0015  0.00 SELECT users livestreams reactions
#   80 0x49F80FBE1AC70F23A3DD076174FF1AA9  0.0029  0.0%      2 0.0014  0.00 SELECT users livestreams reactions
#   81 0x751417D45B8E80EE5CBA2034458B5BC9  0.0023  0.0%      1 0.0023  0.00 SHOW DATABASES
#   82 0xEDBC971AEC392917AA353644DE4C4CB4  0.0020  0.0%    424 0.0000  0.00 ADMIN QUIT
#   83 0x81A16A50C109F5D807127F5ACDDC6A37  0.0019  0.0%      1 0.0019  0.00 SELECT users livestreams reactions livecomments
#   84 0x66B16B71506EF61EC8C50F38C7168831  0.0019  0.0%      1 0.0019  0.00 SELECT users livestreams reactions livecomments
#   85 0x837E160B18AB01A5B165621760787579  0.0019  0.0%      1 0.0019  0.00 SELECT users livestreams reactions livecomments
#   86 0x20CD15DC47AF2F861B8F3C25D195ABE9  0.0018  0.0%     15 0.0001  0.00 SELECT tags
#   87 0x8B2044ADAE690405979131C33185F22A  0.0014  0.0%      7 0.0002  0.00 SELECT users
#   88 0x2C17BCA1E1077820CDC2EC6106F4D93E  0.0011  0.0%     18 0.0001  0.00 SELECT livestream_viewers_history
#   89 0x489B4CEB2F4301A7132628303F99240D  0.0011  0.0%      1 0.0011  0.00 SHOW TABLES
#   90 0x0E7680C04FF2596BE3A3649C5FAC418D  0.0008  0.0%     10 0.0001  0.00 SELECT
#   91 0xEBE4AF9F935DE1D48BB5BB3558C7FCC4  0.0006  0.0%      2 0.0003  0.00 SELECT livestreams livecomments
#   92 0x8F885091E23CB955C051B1204EE7D91D  0.0005  0.0%      2 0.0002  0.00 SELECT livestreams reactions
#   93 0xC4625761E0CFD817F41B4802F152A489  0.0004  0.0%      1 0.0004  0.00 SELECT livecomments
#   94 0x882C6C5CFFB6E00681341C0C7A67D2BF  0.0002  0.0%      1 0.0002  0.00 SELECT users
#   95 0x394E66DDE2823A903078D4C0F235B948  0.0002  0.0%      2 0.0001  0.00 SELECT livestreams livecomment_reports
#   96 0xF085F31DC1964EA538732B713E4B4108  0.0002  0.0%      2 0.0001  0.00 SELECT livestreams livestream_viewers_history
#   97 0xE84E602C0D0858D5661956B70D72A215  0.0002  0.0%      1 0.0002  0.00 SELECT icons

# Query 1: 1.45k QPS, 0.58x concurrency, ID 0xDA556F9115773A1A99AA0165670CE848 at byte 17062360
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T05:25:25 to 2023-11-25T05:27:07
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         29  148123
# Exec time     14     59s    21us   234ms   398us     2ms     1ms   103us
# Lock time      0     2us       0     2us       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    12   4.24M      30      30      30      30       0      30
# String:
# Databases    isupipe (146448/98%), isudns (1675/1%)
# Hosts        localhost
# Users        isucon (146448/98%), isudns (1675/1%)
# Query_time distribution
#   1us
#  10us  ################################################################
# 100us  ##########################################################
#   1ms  #############
#  10ms  #
# 100ms  #
#    1s
#  10s+
administrator command: Prepare\G

# Query 2: 78.82 QPS, 0.60x concurrency, ID 0x42EF7D7D98FBCC9723BF896EBFC51D24 at byte 64808359
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T05:25:43 to 2023-11-25T05:27:07
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          1    6621
# Exec time     12     51s   696us    60ms     8ms    20ms     7ms     6ms
# Lock time      3    22ms       0     3ms     3us     1us    46us     1us
# Rows sent      0   1.83k       0       1    0.28    0.99    0.45       0
# Rows examine  13   8.98M   1.25k   1.52k   1.39k   1.46k   78.64   1.33k
# Query size     2 907.44k     129     218  140.34  158.58   11.11  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='gy33xfp6rat3qxctglugjexfct3smt0.u.isucon.dev' and domain_id=2\G

# Query 3: 163.90 QPS, 0.40x concurrency, ID 0x38BC86A45F31C6B1EE324671506C898A at byte 136773182
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T05:25:25 to 2023-11-25T05:27:07
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          3   16718
# Exec time     10     41s   238us    39ms     2ms     8ms     3ms     1ms
# Lock time      5    31ms       0     3ms     1us     1us    26us     1us
# Rows sent      7  16.33k       1       1       1       1       0       1
# Rows examine  26  18.23M    1000   1.25k   1.12k   1.20k   86.27   1.09k
# Query size     1 667.24k      38      41   40.87   40.45    0.63   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 = 1014\G

# Query 4: 54.49 QPS, 0.50x concurrency, ID 0xF1B8EF06D6CA63B24BFF433E06CCEB22 at byte 84122039
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T05:25:53 to 2023-11-25T05:27:07
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0    4032
# Exec time      9     37s     1ms    79ms     9ms    31ms    11ms     2ms
# Lock time      1    11ms       0     4ms     2us     1us    60us     1us
# Rows sent      1   3.94k       1       1       1       1       0       1
# Rows examine  11   8.15M   1.96k   2.65k   2.07k   2.38k  167.42   2.06k
# Query size     1 648.92k     163     166  164.81  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 = 22\G

# Query 5: 54.53 QPS, 0.49x concurrency, ID 0xDB74D52D39A7090F224C4DEEAF3028C9 at byte 41768980
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T05:25:53 to 2023-11-25T05:27:07
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0    4035
# Exec time      8     36s     1ms    78ms     9ms    30ms    10ms     2ms
# Lock time      1     7ms       0   709us     1us     1us    13us     1us
# Rows sent      1   3.94k       1       1       1       1       0       1
# Rows examine  12   8.16M   1.96k   2.62k   2.07k   2.27k  144.83   2.06k
# Query size     1 570.60k     143     146  144.81  143.84    0.91  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 = 126\G