Benchmark result on isu1 (3,274)

[github-actions[bot]]

COUNT	1XX	2XX	3XX	4XX	5XX	METHOD	URI	MIN	MAX	SUM	AVG	P90	P95	P99	STDDEV	MIN(BODY)	MAX(BODY)	SUM(BODY)	AVG(BODY)
524	0	520	0	4	0	GET	/api/livestream	0.004	53.749	507.921	0.969	0.856	1.708	21.732	5.301	102.000	37211.000	3887944.000	7419.740
456	0	445	0	11	0	POST	/api/livestream	0.004	9.972	225.120	0.494	1.240	2.896	5.532	1.117	0.000	2705.000	777948.000	1706.026
1612	0	1608	0	4	0	GET	/api/user/[a-zA-Z0-9]+/icon	0.004	4.404	215.156	0.133	0.260	0.484	1.916	0.352	0.000	103167.000	81963587.000	50845.898
8	0	4	0	4	0	GET	/api/user/[a-zA-Z0-9]+/statistics	3.384	39.321	146.921	18.365	39.321	39.321	39.321	10.623	157.000	157.000	587.000	73.375
44	0	44	0	0	0	GET	/api/livestream/search	0.068	4.340	52.284	1.188	2.180	2.488	4.340	0.850	49391.000	126615.000	3176320.000	72189.091
139	0	136	0	2	1	POST	/api/register	0.008	2.992	45.736	0.329	0.572	1.156	2.724	0.483	0.000	504.000	63634.000	457.799
79	0	75	0	4	0	POST	/api/livestream/reservation	0.212	1.920	39.140	0.495	1.088	1.616	1.920	0.471	0.000	1459.000	83527.000	1057.304
135	0	135	0	0	0	POST	/api/icon	0.012	3.316	35.100	0.260	0.572	1.164	2.944	0.520	14.000	16.000	2052.000	15.200
144	0	141	0	3	0	POST	/api/login	0.004	3.788	23.244	0.161	0.332	0.488	2.424	0.460	0.000	64.000	128.000	0.889
59	0	59	0	0	0	GET	/api/tag	0.004	3.660	14.880	0.252	0.644	1.360	3.660	0.602	6089.000	6095.000	359449.000	6092.356
1	0	1	0	0	0	POST	/api/initialize	13.728	13.728	13.728	13.728	13.728	13.728	13.728	0.000	27.000	27.000	27.000	27.000
14	0	14	0	0	0	DELETE	/api/livestream	0.004	2.108	3.448	0.246	0.432	2.108	2.108	0.529	0.000	0.000	0.000	0.000
2	0	2	0	0	0	GET	/api/user/[a-zA-Z0-9]+/livestream	0.184	1.212	1.396	0.698	1.212	1.212	1.212	0.514	5728.000	5728.000	11456.000	5728.000
5	0	5	0	0	0	GET	/api/user/me	0.036	0.404	0.440	0.088	0.404	0.404	0.404	0.159	235.000	247.000	1223.000	244.600
5	0	5	0	0	0	GET	/api/user/[a-zA-Z0-9]+/theme	0.008	0.152	0.268	0.054	0.152	0.152	0.152	0.059	38.000	38.000	190.000	38.000
3	0	3	0	0	0	GET	/api/user/[a-zA-Z0-9]+$	0.004	0.040	0.064	0.021	0.040	0.040	0.040	0.015	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

[github-actions[bot]]

Reading from STDIN ...

# 83.2s user time, 440ms system time, 36.30M rss, 42.89M vsz
# Current date: Sat Nov 25 02:20:03 2023
# Hostname: ip-192-168-0-11
# Files: STDIN
# Overall: 1.10M total, 95 unique, 5.31k QPS, 3.31x concurrency __________
# Time range: 2023-11-25T02:15:37 to 2023-11-25T02:19:05
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time           688s     1us   428ms   622us     2ms     2ms    84us
# Lock time             1s       0    22ms     1us     1us    49us       0
# Rows sent        490.85k       0   7.39k    0.46    0.99   29.29       0
# Rows examine     324.57M       0  14.02k  308.18   1.14k  597.88       0
# Query size        80.57M       5   1.94M   76.50  143.84   2.15k   31.70

# Profile
# Rank Query ID                           Response time  Calls  R/Call V/M
# ==== ================================== ============== ====== ====== ===
#    1 0xFD38427AE3D09E3883A680F7BAF95D3A 149.6751 21.8% 120893 0.0012  0.00 SELECT livestreams livecomments
#    2 0xC499D81D570D361DB61FC43A94BB888A 126.0852 18.3% 120893 0.0010  0.00 SELECT livestreams reactions
#    3 0xDA556F9115773A1A99AA0165670CE848 100.9048 14.7% 349901 0.0003  0.00 ADMIN PREPARE
#    4 0xF1B8EF06D6CA63B24BFF433E06CCEB22  47.8660  7.0%   5849 0.0082  0.01 SELECT users livestreams livecomments
#    5 0xDB74D52D39A7090F224C4DEEAF3028C9  45.3786  6.6%   5852 0.0078  0.01 SELECT users livestreams reactions
#    6 0x42EF7D7D98FBCC9723BF896EBFC51D24  44.5520  6.5%   7314 0.0061  0.00 SELECT records
#    7 0x84B457C910C4A79FC9EBECB8B1065C66  29.0529  4.2%   9477 0.0031  0.00 SELECT icons
#    8 0x3D83BC87F3B3A00D571FFC8104A6E50C  22.6955  3.3%   5247 0.0043  0.00 SELECT records
#    9 0x4ADE2DC90689F1C4891749AF54FB8D14  19.0290  2.8%  37824 0.0005  0.00 DELETE SELECT livecomments
#   10 0x38BC86A45F31C6B1EE324671506C898A  14.2785  2.1%   7874 0.0018  0.00 SELECT themes
#   11 0x59F1B6DD8D9FEC059E55B3BFD624E8C3  11.0963  1.6%    562 0.0197  0.01 SELECT reservation_slots
#   12 0xFFFCA4D67EA0A788813031B8BBC3B329   8.2400  1.2%   1730 0.0048  0.01 COMMIT
#   13 0x64CC8A4E8E4B390203375597CE4D611F   8.1046  1.2%    194 0.0418  0.01 SELECT ng_words
#   14 0xFBC5564AE716EAE82F20BFB45F6C37E7   6.0674  0.9%  18384 0.0003  0.00 SELECT tags
#   15 0x22279D81D51006139E0C76405B54C261   5.9442  0.9%   8996 0.0007  0.00 SELECT domains domainmetadata
#   16 0xDFFCC1D78939C4D781C7C58349101F50   5.4957  0.8%   1000 0.0055  0.00 INSERT users
#   17 0xD2A0864774622BA36F6557496405CF75   5.2003  0.8%   1136 0.0046  0.00 INSERT themes
#   18 0x8F7679D452333ED3C7D60D22131CEFD4   4.6231  0.7%  22437 0.0002  0.00 ADMIN RESET STMT
#   19 0x07890000813C4CC7111FD2D3F3B3B4EB   3.6172  0.5% 349887 0.0000  0.00 ADMIN CLOSE STMT
#   20 0x7F9C0C0BA9473953B723EE16C08655F1   2.9397  0.4%     77 0.0382  0.02 SELECT reservation_slots
#   21 0xA3401CA3ABCC04C3AB221DB8AD5CBF26   2.7274  0.4%     75 0.0364  0.02 UPDATE reservation_slots
#   22 0xF7144185D9A142A426A36DC55C1D2623   2.6852  0.4%   5403 0.0005  0.00 SELECT livestream_tags
#   23 0xEA1E6309EEEFF9A6831AD2FB940FC23C   2.6115  0.4%   7730 0.0003  0.00 SELECT users
#   24 0x9EAD6C0CE525E3693EE27FFC9AAF05A3   2.5699  0.4%     71 0.0362  0.01 SELECT livestreams
#   25 0x859BBB7E9D760686137A944406874C4D   1.9848  0.3%    136 0.0146  0.01 DELETE records
#   26 0x3A2B0EDA41C4E3576FCA6DA29A9B91DF   1.4043  0.2%    135 0.0104  0.01 INSERT icons
#   27 0xD6032FE08E1FE706A928B8B7CBA06B85   1.3034  0.2%   3944 0.0003  0.00 SELECT livestreams
#   28 0x9AC623FA477E73A44D191D296850A025   1.2003  0.2%    272 0.0044  0.00 SELECT records
#   29 0xEDE18C1523658A19E07525EAFCBA6BFE   1.1775  0.2%     24 0.0491  0.01 SELECT ng_words
#   30 0xB08B7B7486D2DFE2F2FE9CE78689FD79   1.0856  0.2%     23 0.0472  0.01 SELECT ng_words
#   31 0xFFF66E9B3D962FA319C8068B5C1997CD   0.7288  0.1%   1621 0.0004  0.00 ROLLBACK
#   32 0x3F155F5E71EFF856F0CF7B8430DE8C23   0.6966  0.1%   1764 0.0004  0.00 SELECT users
#   33 0x050F7D44808F43E5D33D0B90BCF57CC9   0.5908  0.1%     16 0.0369  0.02 SELECT livestreams
#   34 0x9E2DA589A20EC24C34E11DDE0FBF5564   0.5779  0.1%   3223 0.0002  0.00 START
#   35 0x98F959E03B684A5538FD8402A0EE94AD   0.5418  0.1%    103 0.0053  0.00 INSERT tags
#   36 0x02B6A87E51A5A1B7646675DB67C57DE3   0.4278  0.1%      1 0.4278  0.00 INSERT ng_words
#   37 0xB78E63D0D9C72DDDAB7A3E53517FA04C   0.4089  0.1%    156 0.0026  0.00 SELECT livecomments
#   38 0xF1E5C5B0483E8BF764220BFACAE7CD16   0.3910  0.1%    135 0.0029  0.00 DELETE icons
#   39 0xAD0C28443E1E5CFAFF1569DBB4F7E63A   0.3876  0.1%    190 0.0020  0.00 SELECT reactions
#   40 0x80E10371CE74ED05E09C79C72C73F8E1   0.3740  0.1%     76 0.0049  0.25 INSERT livestreams
#   41 0x0C1FCBB4E25B178AA3A46D4FECBA9BDC   0.3537  0.1%     22 0.0161  0.00 INSERT livestream_tags
#   42 0x41F805E95754958A974F41AE07BEA625   0.2901  0.0%     34 0.0085  0.01 SELECT livecomments
#   43 0x77FB9E134D073862D1E78FEEC3436291   0.2626  0.0%   1416 0.0002  0.00 INSERT records
#   44 0x651E3772B8767A368CB47EE7389EEB33   0.1615  0.0%     13 0.0124  0.02 SELECT livestream_tags
#   45 0xF3A502CCF34F7DA288CC1B75AD5AFA37   0.1480  0.0%    193 0.0008  0.00 INSERT livecomments
#   46 0xDF0AAE38E2AAFC85E6F50569CEF2285D   0.1424  0.0%      1 0.1424  0.00 INSERT reservation_slots
#   47 0x5AEB6E4A781A3854CF642125E293FEE0   0.1121  0.0%    169 0.0007  0.00 INSERT reactions
#   48 0xB9AC05A7AE6C4E30B5B45F6F3CE05BE0   0.1104  0.0%    274 0.0004  0.00 SET
#   49 0x5D469B53C536D19CD15E40763ACC23C7   0.0992  0.0%    297 0.0003  0.00 INSERT livestream_tags
#   50 0x64052B1C32B30DF53AB3292208B783B4   0.0794  0.0%    137 0.0006  0.00 INSERT users
#   51 0x19A1F14EFC0F221D30AFCB1E1344BEBD   0.0747  0.0%      8 0.0093  0.00 SELECT users
#   52 0x9C697B3F0446BBF7602663588252F020   0.0556  0.0%      1 0.0556  0.00 TRUNCATE TABLE livestream_viewers_history
#   53 0xEE4C51AE2BF74414C4892CBE11E894AA   0.0535  0.0%     23 0.0023  0.00 SELECT livecomments
#   54 0x544239977D2094F805A7B062DE95673A   0.0531  0.0%     59 0.0009  0.00 SELECT tags
#   55 0xE64D50F7AFC1AD5F465809A92DF4935E   0.0520  0.0%     22 0.0024  0.00 SELECT reactions
#   56 0xDFEFE5BA5D8654534DC8550C6E3DC9C0   0.0503  0.0%      1 0.0503  0.00 DELETE records
#   57 0xBB7F4DC4E67BF30E0588D296FFAF009F   0.0459  0.0%      1 0.0459  0.00 TRUNCATE TABLE tags
#   58 0xA7C2E59AEF14D03CB65B227F3E3BA469   0.0442  0.0%      1 0.0442  0.00 TRUNCATE TABLE reservation_slots
#   59 0xAFFDC331C1D4BA089978A0B8DD00BFC8   0.0441  0.0%      1 0.0441  0.00 TRUNCATE TABLE livestreams
#   60 0x93A42F50BF286ACA749DF5F342FAC07B   0.0441  0.0%      1 0.0441  0.00 TRUNCATE TABLE livecomment_reports
#   61 0x1FB70DBF74628C9F2E9F0C3478771936   0.0441  0.0%      1 0.0441  0.00 TRUNCATE TABLE ng_words
#   62 0xD2978B45C67B47B5D73AC532EB40A95E   0.0441  0.0%      1 0.0441  0.00 TRUNCATE TABLE themes
#   63 0x2AAED5867123C749367FD8E4BBD796D2   0.0425  0.0%      1 0.0425  0.00 TRUNCATE TABLE livecomments
#   64 0x08A6ACD83D579DD8A808134B32AD376B   0.0417  0.0%      1 0.0417  0.00 TRUNCATE TABLE livestream_tags
#   65 0xDBB1C17D6ABA0156D8ABCE105DDDA1B2   0.0411  0.0%      1 0.0411  0.00 TRUNCATE TABLE users
#   66 0x07F6C3FF39ADD79FC63923A7EE938953   0.0405  0.0%      1 0.0405  0.00 INSERT livecomments
#   67 0xFB296F703ACC41C3F94A9B7D75044F3C   0.0402  0.0%      1 0.0402  0.00 TRUNCATE TABLE reactions
#   68 0x4B6FA79E206C6CED71D433A2FC998D69   0.0398  0.0%     71 0.0006  0.00 SELECT
#   69 0x253CA101A906B3D56A95D1B8DCEE28EF   0.0375  0.0%      1 0.0375  0.00 TRUNCATE TABLE icons
#   70 0x81E419F4B58AEB9B280B03DE44DD8B94   0.0322  0.0%    102 0.0003  0.00 SELECT livecomments
#   71 0xEBE4AF9F935DE1D48BB5BB3558C7FCC4   0.0271  0.0%     16 0.0017  0.00 SELECT livestreams livecomments
#   72 0x24C44C3518CE12293EF12410AEDA2393   0.0269  0.0%     31 0.0009  0.00 SELECT livestreams
#   73 0xE623383C5D789800DC0946925F90039F   0.0263  0.0%    137 0.0002  0.00 SELECT domains
#   74 0x74232BDFFB94C567F0340DBE3285E458   0.0259  0.0%      1 0.0259  0.00 INSERT reactions
#   75 0x2B760561C10B5D133155AA306D0F407C   0.0259  0.0%     32 0.0008  0.00 SELECT livecomments
#   76 0xF985E5835B84E84C7A721801818E98CE   0.0221  0.0%      4 0.0055  0.00 SELECT users livestreams reactions
#   77 0x8F885091E23CB955C051B1204EE7D91D   0.0212  0.0%     16 0.0013  0.00 SELECT livestreams reactions
#   78 0x49F80FBE1AC70F23A3DD076174FF1AA9   0.0172  0.0%      4 0.0043  0.00 SELECT users livestreams reactions
#   79 0x827F41D30F8E37F04D8BDCD46C556FB3   0.0162  0.0%     38 0.0004  0.00 INSERT livecomment_reports
#   80 0x8D589AFA4DFAEEED85FFF5AA78E5FF6A   0.0103  0.0%    137 0.0001  0.00 BEGIN
#   81 0xBF3194A2446AC20FC99B6CC7FA476A57   0.0076  0.0%     24 0.0003  0.00 INSERT livestream_viewers_history
#   82 0x466EE4C87B17CAD4E692DE1D44EAD84D   0.0070  0.0%     31 0.0002  0.00 SELECT livecomment_reports
#   83 0xB871CC5B0472067402F5739D108B2C1C   0.0069  0.0%     23 0.0003  0.00 SELECT livestreams
#   84 0x0C655718656DD9DDA39A0D11554A0C64   0.0065  0.0%     23 0.0003  0.00 INSERT ng_words
#   85 0x394E66DDE2823A903078D4C0F235B948   0.0060  0.0%     16 0.0004  0.00 SELECT livestreams livecomment_reports
#   86 0xF085F31DC1964EA538732B713E4B4108   0.0058  0.0%     16 0.0004  0.00 SELECT livestreams livestream_viewers_history
#   87 0xA0D956F292B7FEA0DCE68A5DD5F529E1   0.0050  0.0%     14 0.0004  0.00 DELETE livestream_viewers_history
#   88 0x2C17BCA1E1077820CDC2EC6106F4D93E   0.0040  0.0%     32 0.0001  0.00 SELECT livestream_viewers_history
#   89 0x20CD15DC47AF2F861B8F3C25D195ABE9   0.0022  0.0%     13 0.0002  0.00 SELECT tags
#   90 0x751417D45B8E80EE5CBA2034458B5BC9   0.0021  0.0%      1 0.0021  0.00 SHOW DATABASES
#   91 0x489B4CEB2F4301A7132628303F99240D   0.0015  0.0%      1 0.0015  0.00 SHOW TABLES
#   92 0x0E7680C04FF2596BE3A3649C5FAC418D   0.0009  0.0%     10 0.0001  0.00 SELECT
#   93 0x8B2044ADAE690405979131C33185F22A   0.0007  0.0%      5 0.0001  0.00 SELECT users
#   94 0xEDBC971AEC392917AA353644DE4C4CB4   0.0005  0.0%    229 0.0000  0.00 ADMIN QUIT
#   95 0xC4625761E0CFD817F41B4802F152A489   0.0004  0.0%      1 0.0004  0.00 SELECT livecomments

# Query 1: 632.95 QPS, 0.78x concurrency, ID 0xFD38427AE3D09E3883A680F7BAF95D3A at byte 135298045
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T02:15:54 to 2023-11-25T02:19:05
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         10  120893
# Exec time     21    150s   261us    29ms     1ms     4ms     1ms   657us
# Lock time     29   332ms       0     6ms     2us     1us    44us     1us
# Rows sent     24 118.06k       1       1       1       1       0       1
# Rows examine  40 132.69M    1001   1.16k   1.12k   1.14k   66.80   1.14k
# Query size    17  13.82M     117     120  119.85  118.34    0.64  118.34
# 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 '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 livestreams l INNER JOIN livecomments l2 ON l.id = l2.livestream_id WHERE l.id = 1459\G

# Query 2: 632.95 QPS, 0.66x concurrency, ID 0xC499D81D570D361DB61FC43A94BB888A at byte 136514495
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T02:15:54 to 2023-11-25T02:19:05
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         10  120893
# Exec time     18    126s   227us    33ms     1ms     3ms     1ms   541us
# Lock time     24   283ms       0     3ms     2us     1us    24us     1us
# Rows sent     24 118.06k       1       1       1       1       0       1
# Rows examine  40 131.33M    1001   1.14k   1.11k   1.09k   50.10   1.09k
# Query size    14  11.63M      98     101  100.85   97.36       0   97.36
# 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 '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 livestreams l INNER JOIN reactions r ON l.id = r.livestream_id WHERE l.id = 1422\G

# Query 3: 1.68k QPS, 0.49x concurrency, ID 0xDA556F9115773A1A99AA0165670CE848 at byte 43792757
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T02:15:37 to 2023-11-25T02:19:05
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         31  349901
# Exec time     14    101s    22us   302ms   288us     1ms   812us    98us
# Lock time      0     6us       0     6us       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  10.01M      30      30      30      30       0      30
# String:
# Hosts        localhost
# Users        isucon (349075/99%), isudns (826/0%)
# Query_time distribution
#   1us
#  10us  ################################################################
# 100us  ########################################################
#   1ms  #######
#  10ms  #
# 100ms  #
#    1s
#  10s+
administrator command: Prepare\G

# Query 4: 37.74 QPS, 0.31x concurrency, ID 0xF1B8EF06D6CA63B24BFF433E06CCEB22 at byte 90045272
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T02:15:50 to 2023-11-25T02:18:25
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0    5849
# Exec time      6     48s     1ms    82ms     8ms    27ms     9ms     4ms
# Lock time      1    15ms       0     6ms     2us     1us    77us     1us
# Rows sent      1   5.71k       1       1       1       1       0       1
# Rows examine   3  12.18M   1.96k   2.32k   2.13k   2.27k  140.99   2.06k
# Query size     1 941.87k     163     166  164.90  158.58    0.00  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 = 223\G

# Query 5: 37.75 QPS, 0.29x concurrency, ID 0xDB74D52D39A7090F224C4DEEAF3028C9 at byte 102136227
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T02:15:50 to 2023-11-25T02:18:25
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0    5852
# Exec time      6     45s     1ms    74ms     8ms    26ms     9ms     3ms
# Lock time      1    20ms       0     5ms     3us     1us    76us     1us
# Rows sent      1   5.71k       1       1       1       1       0       1
# Rows examine   3  12.14M   1.96k   2.29k   2.12k   2.27k  140.96   2.06k
# Query size     1 828.06k     143     146  144.90  143.84    0.76  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 = 334\G