Benchmark result on isu3(16,449)

[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)
29797	0	29790	0	7	0	GET	/api/user/[a-zA-Z0-9]+/icon	0.004	0.396	513.569	0.017	0.040	0.068	0.136	0.026	0.000	164797.000	1682805956.000	56475.684
74	0	66	0	8	0	POST	/api/livestream/[a-zA-Z0-9]+/moderate	0.288	19.999	437.954	5.918	10.100	11.603	19.999	3.236	0.000	23.000	1518.000	20.514
2833	0	2826	0	7	0	GET	/api/livestream/[a-zA-Z0-9]+/livecomment	0.004	0.596	413.052	0.146	0.312	0.372	0.480	0.114	0.000	117443.000	79708874.000	28135.854
2930	0	2921	0	9	0	GET	/api/livestream/[a-zA-Z0-9]+/reaction	0.004	0.628	393.311	0.134	0.300	0.360	0.476	0.113	0.000	113397.000	73276820.000	25009.154
842	0	834	0	5	3	POST	/api/register	0.004	0.528	171.711	0.204	0.280	0.312	0.396	0.068	0.000	513.000	391331.000	464.764
336	0	324	0	12	0	POST	/api/livestream/[a-zA-Z0-9]+$	0.096	0.984	133.259	0.397	0.804	0.864	0.960	0.310	0.000	1482.000	364204.000	1083.940
2857	0	2830	0	27	0	POST	/api/livestream/[a-zA-Z0-9]+/livecomment	0.004	0.316	118.972	0.042	0.072	0.096	0.176	0.032	57.000	2736.000	5554482.000	1944.166
2601	0	2599	0	2	0	POST	/api/livestream/[a-zA-Z0-9]+/reaction	0.004	0.304	96.763	0.037	0.072	0.096	0.160	0.030	0.000	2218.000	4820389.000	1853.283
312	0	312	0	0	0	GET	/api/livestream/[a-zA-Z0-9]+$	0.004	1.812	68.740	0.220	1.264	1.488	1.672	0.464	1462.000	144921.000	21559018.000	69099.417
4	0	4	0	0	0	POST	/api/initialize	10.060	11.260	41.612	10.403	11.260	11.260	11.260	0.496	27.000	27.000	108.000	27.000
415	0	415	0	0	0	GET	/api/livestream$	0.004	0.232	29.472	0.071	0.120	0.144	0.184	0.037	3.000	22656.000	484704.000	1167.961
862	0	856	0	6	0	POST	/api/login	0.004	0.392	18.352	0.021	0.052	0.076	0.140	0.030	0.000	64.000	384.000	0.445
49	0	49	0	0	0	GET	/api/user/[a-zA-Z0-9]+/statistics	0.024	0.500	15.172	0.310	0.452	0.456	0.500	0.135	133.000	165.000	6942.000	141.673
278	0	278	0	0	0	POST	/api/livestream/[a-zA-Z0-9]+/enter	0.004	0.380	12.484	0.045	0.108	0.180	0.268	0.054	0.000	0.000	0.000	0.000
282	0	282	0	0	0	GET	/api/tag	0.036	0.248	8.056	0.029	0.068	0.096	0.200	0.038	6089.000	6095.000	1718562.000	6094.191
246	0	246	0	0	0	DELETE	/api/livestream/[a-zA-Z0-9]+/exit	0.004	0.200	7.480	0.030	0.072	0.100	0.156	0.031	0.000	0.000	0.000	0.000
302	0	298	0	0	4	GET	/api/livestream/[a-zA-Z0-9]+/report	0.004	0.168	5.652	0.019	0.040	0.068	0.116	0.023	3.000	8344.000	123122.000	407.689
182	0	182	0	0	0	GET	/api/livestream/[a-zA-Z0-9]+/ngwords	0.004	0.376	3.700	0.020	0.048	0.060	0.152	0.035	5.000	146.000	2986.000	16.407
834	0	834	0	0	0	POST	/api/icon	0.000	0.020	3.328	0.004	0.008	0.008	0.012	0.003	14.000	14.000	11676.000	14.000
41	0	41	0	0	0	GET	/api/user/[a-zA-Z0-9]+/livestream	0.036	0.160	3.308	0.081	0.112	0.120	0.160	0.027	1236.000	5110.000	89360.000	2179.512
47	0	27	0	20	0	GET	/api/livestream/[a-zA-Z0-9]+/statistics	0.004	0.348	3.116	0.066	0.228	0.256	0.348	0.095	55.000	104.000	3858.000	82.085
45	0	45	0	0	0	GET	/api/user/[a-zA-Z0-9]+/theme	0.012	0.112	0.896	0.020	0.056	0.068	0.112	0.025	38.000	38.000	1710.000	38.000
18	0	17	0	1	0	GET	/api/user/[a-zA-Z0-9]+$	0.000	0.004	0.016	0.001	0.004	0.004	0.004	0.002	55.000	247.000	4158.000	231.000
4	0	4	0	0	0	GET	/api/payment	0.000	0.004	0.008	0.002	0.004	0.004	0.004	0.002	21.000	21.000	84.000	21.000
2	0	0	2	0	0	GET	/assets/index.esm-bd2deef7.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
2	0	0	2	0	0	GET	/assets/FormLabel-c342aa29.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
2	0	0	2	0	0	GET	/assets/login-dc4055a7.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	0	0	1	0	GET	/linear-swap-ws	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	134.000	134.000	134.000	134.000

[github-actions[bot]]

Reading from STDIN ...

# 95.2s user time, 340ms system time, 38.39M rss, 44.80M vsz
# Current date: Sat Nov 25 08:26:13 2023
# Hostname: ip-192-168-0-13
# Files: STDIN
# Overall: 1.57M total, 89 unique, 1.62k QPS, 0.85x concurrency __________
# Time range: 2023-11-25T08:07:38 to 2023-11-25T08:23:52
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time           826s     1us   438ms   524us     2ms     3ms    60us
# Lock time             2s       0    44ms     1us     1us    96us       0
# Rows sent        849.12k       0   7.40k    0.55    0.99   33.42       0
# Rows examine      89.20M       0  17.93k   59.40    1.96  483.99       0
# Query size       106.99M       5   1.94M   71.25  313.99   3.29k   31.70

# Profile
# Rank Query ID                           Response time  Calls  R/Call V/M
# ==== ================================== ============== ====== ====== ===
#    1 0x42EF7D7D98FBCC9723BF896EBFC51D24 157.7270 19.1%  18058 0.0087  0.01 SELECT records
#    2 0xDA556F9115773A1A99AA0165670CE848 115.7859 14.0% 471706 0.0002  0.01 ADMIN PREPARE
#    3 0x3D83BC87F3B3A00D571FFC8104A6E50C 107.6464 13.0%  14420 0.0075  0.01 SELECT records
#    4 0x59F1B6DD8D9FEC059E55B3BFD624E8C3  58.4609  7.1%   2642 0.0221  0.01 SELECT reservation_slots
#    5 0xFFFCA4D67EA0A788813031B8BBC3B329  54.5921  6.6%  16248 0.0034  0.00 COMMIT
#    6 0x38BC86A45F31C6B1EE324671506C898A  37.5147  4.5%  90582 0.0004  0.00 SELECT themes
#    7 0x4ADE2DC90689F1C4891749AF54FB8D14  36.5924  4.4% 122757 0.0003  0.00 DELETE SELECT livecomments
#    8 0xD6032FE08E1FE706A928B8B7CBA06B85  24.2744  2.9%  93136 0.0003  0.00 SELECT livestreams
#    9 0x9EAD6C0CE525E3693EE27FFC9AAF05A3  24.1962  2.9%    505 0.0479  0.01 SELECT livestreams
#   10 0xEA1E6309EEEFF9A6831AD2FB940FC23C  21.8920  2.7%  89706 0.0002  0.00 SELECT users
#   11 0x22279D81D51006139E0C76405B54C261  19.2814  2.3%  20334 0.0009  0.00 SELECT domains domainmetadata
#   12 0x859BBB7E9D760686137A944406874C4D  17.3871  2.1%    836 0.0208  0.01 DELETE records
#   13 0x8F7679D452333ED3C7D60D22131CEFD4  17.0330  2.1%  57406 0.0003  0.00 ADMIN RESET STMT
#   14 0xDFFCC1D78939C4D781C7C58349101F50  16.0476  1.9%   4000 0.0040  0.00 INSERT users
#   15 0xD2A0864774622BA36F6557496405CF75  15.6856  1.9%   4836 0.0032  0.00 INSERT themes
#   16 0xA3401CA3ABCC04C3AB221DB8AD5CBF26  13.9741  1.7%    324 0.0431  0.03 UPDATE reservation_slots
#   17 0x7F9C0C0BA9473953B723EE16C08655F1  11.7638  1.4%    330 0.0356  0.02 SELECT reservation_slots
#   18 0x9AC623FA477E73A44D191D296850A025  11.0135  1.3%   1672 0.0066  0.01 SELECT records
#   19 0x3F155F5E71EFF856F0CF7B8430DE8C23  10.6202  1.3%  30746 0.0003  0.00 SELECT users
#   20 0xB78E63D0D9C72DDDAB7A3E53517FA04C   7.9355  1.0%   2560 0.0031  0.00 SELECT livecomments
#   21 0xAD0C28443E1E5CFAFF1569DBB4F7E63A   6.9546  0.8%   2660 0.0026  0.00 SELECT reactions
#   22 0x611999F76068C4DC4F90E0A389918E63   6.3338  0.8%     49 0.1293  0.03 SELECT users livestreams reactions livestreams livecomments
#   23 0x07890000813C4CC7111FD2D3F3B3B4EB   4.8233  0.6% 471653 0.0000  0.00 ADMIN CLOSE STMT
#   24 0xE4555A2709C09FD9BFF6688D80B0AA49   2.0088  0.2%     27 0.0744  0.08 SELECT livestreams reactions livecomments
#   25 0xF7144185D9A142A426A36DC55C1D2623   1.8892  0.2%   7956 0.0002  0.00 SELECT livestream_tags
#   26 0x55C45664C0A27CA4AF92DD1D2D0ABDAA   1.6411  0.2%   7828 0.0002  0.00 SELECT tags
#   27 0x02B6A87E51A5A1B7646675DB67C57DE3   1.6089  0.2%      4 0.4022  0.00 INSERT ng_words
#   28 0x98F959E03B684A5538FD8402A0EE94AD   1.5803  0.2%    412 0.0038  0.00 INSERT tags
#   29 0x9E2DA589A20EC24C34E11DDE0FBF5564   1.5666  0.2%  15529 0.0001  0.00 START
#   30 0x49F80FBE1AC70F23A3DD076174FF1AA9   1.4384  0.2%     49 0.0294  0.02 SELECT users livestreams reactions
#   31 0x77FB9E134D073862D1E78FEEC3436291   1.3987  0.2%   5956 0.0002  0.00 INSERT records
#   32 0xF985E5835B84E84C7A721801818E98CE   1.3480  0.2%     49 0.0275  0.02 SELECT users livestreams reactions
#   33 0x0C1FCBB4E25B178AA3A46D4FECBA9BDC   1.1960  0.1%     88 0.0136  0.00 INSERT livestream_tags
#   34 0x80E10371CE74ED05E09C79C72C73F8E1   1.1398  0.1%    328 0.0035  0.20 INSERT livestreams
#   35 0xF3A502CCF34F7DA288CC1B75AD5AFA37   1.0464  0.1%   2693 0.0004  0.00 INSERT livecomments
#   36 0x651E3772B8767A368CB47EE7389EEB33   0.9817  0.1%     78 0.0126  0.01 SELECT livestream_tags
#   37 0x64CC8A4E8E4B390203375597CE4D611F   0.9131  0.1%   2697 0.0003  0.00 SELECT ng_words
#   38 0x5AEB6E4A781A3854CF642125E293FEE0   0.8687  0.1%   2599 0.0003  0.00 INSERT reactions
#   39 0xEE4C51AE2BF74414C4892CBE11E894AA   0.7914  0.1%    273 0.0029  0.00 SELECT livecomments
#   40 0xE64D50F7AFC1AD5F465809A92DF4935E   0.7612  0.1%    269 0.0028  0.00 SELECT reactions
#   41 0xB9AC05A7AE6C4E30B5B45F6F3CE05BE0   0.5550  0.1%   1694 0.0003  0.00 SET
#   42 0xDF0AAE38E2AAFC85E6F50569CEF2285D   0.5369  0.1%      4 0.1342  0.00 INSERT reservation_slots
#   43 0x5D469B53C536D19CD15E40763ACC23C7   0.4870  0.1%   1328 0.0004  0.00 INSERT livestream_tags
#   44 0x41F805E95754958A974F41AE07BEA625   0.4408  0.1%     91 0.0048  0.00 SELECT livecomments
#   45 0x2B760561C10B5D133155AA306D0F407C   0.4131  0.1%    141 0.0029  0.01 SELECT livecomments
#   46 0x64052B1C32B30DF53AB3292208B783B4   0.4087  0.0%    839 0.0005  0.00 INSERT users
#   47 0xE623383C5D789800DC0946925F90039F   0.2623  0.0%    840 0.0003  0.00 SELECT domains
#   48 0x4B6FA79E206C6CED71D433A2FC998D69   0.2177  0.0%    640 0.0003  0.00 SELECT
#   49 0x24C44C3518CE12293EF12410AEDA2393   0.2134  0.0%    230 0.0009  0.00 SELECT livestreams
#   50 0x1FB70DBF74628C9F2E9F0C3478771936   0.1769  0.0%      4 0.0442  0.00 TRUNCATE TABLE ng_words
#   51 0x544239977D2094F805A7B062DE95673A   0.1504  0.0%    282 0.0005  0.00 SELECT tags
#   52 0xD2978B45C67B47B5D73AC532EB40A95E   0.1343  0.0%      4 0.0336  0.00 TRUNCATE TABLE themes
#   53 0xBB7F4DC4E67BF30E0588D296FFAF009F   0.1302  0.0%      4 0.0325  0.00 TRUNCATE TABLE tags
#   54 0xDBB1C17D6ABA0156D8ABCE105DDDA1B2   0.1298  0.0%      4 0.0325  0.00 TRUNCATE TABLE users
#   55 0x8D589AFA4DFAEEED85FFF5AA78E5FF6A   0.1277  0.0%    840 0.0002  0.00 BEGIN
#   56 0x07F6C3FF39ADD79FC63923A7EE938953   0.1267  0.0%      4 0.0317  0.00 INSERT livecomments
#   57 0x08A6ACD83D579DD8A808134B32AD376B   0.1218  0.0%      4 0.0305  0.00 TRUNCATE TABLE livestream_tags
#   58 0xAFFDC331C1D4BA089978A0B8DD00BFC8   0.1180  0.0%      4 0.0295  0.00 TRUNCATE TABLE livestreams
#   59 0x9C697B3F0446BBF7602663588252F020   0.1160  0.0%      4 0.0290  0.00 TRUNCATE TABLE livestream_viewers_history
#   60 0xFB296F703ACC41C3F94A9B7D75044F3C   0.1106  0.0%      4 0.0276  0.00 TRUNCATE TABLE reactions
#   61 0xA0D956F292B7FEA0DCE68A5DD5F529E1   0.1080  0.0%    246 0.0004  0.00 DELETE livestream_viewers_history
#   62 0xA7C2E59AEF14D03CB65B227F3E3BA469   0.1057  0.0%      4 0.0264  0.00 TRUNCATE TABLE reservation_slots
#   63 0x2AAED5867123C749367FD8E4BBD796D2   0.1049  0.0%      4 0.0262  0.00 TRUNCATE TABLE livecomments
#   64 0x253CA101A906B3D56A95D1B8DCEE28EF   0.1048  0.0%      4 0.0262  0.00 TRUNCATE TABLE icons
#   65 0x93A42F50BF286ACA749DF5F342FAC07B   0.1003  0.0%      4 0.0251  0.00 TRUNCATE TABLE livecomment_reports
#   66 0x74232BDFFB94C567F0340DBE3285E458   0.0854  0.0%      4 0.0214  0.00 INSERT reactions
#   67 0x81E419F4B58AEB9B280B03DE44DD8B94   0.0812  0.0%    345 0.0002  0.00 SELECT livecomments
#   68 0xB962B14EDA3C9149DE2F648A5F0347D5   0.0770  0.0%      2 0.0385  0.01 SELECT domains records
#   69 0xBF3194A2446AC20FC99B6CC7FA476A57   0.0738  0.0%    278 0.0003  0.00 INSERT livestream_viewers_history
#   70 0x466EE4C87B17CAD4E692DE1D44EAD84D   0.0641  0.0%    302 0.0002  0.00 SELECT livecomment_reports
#   71 0xDFEFE5BA5D8654534DC8550C6E3DC9C0   0.0462  0.0%      4 0.0116  0.00 DELETE records
#   72 0xEDE18C1523658A19E07525EAFCBA6BFE   0.0457  0.0%    182 0.0003  0.00 SELECT ng_words
#   73 0xFFF66E9B3D962FA319C8068B5C1997CD   0.0429  0.0%     95 0.0005  0.00 ROLLBACK
#   74 0x2C17BCA1E1077820CDC2EC6106F4D93E   0.0400  0.0%    141 0.0003  0.00 SELECT livestream_viewers_history
#   75 0x827F41D30F8E37F04D8BDCD46C556FB3   0.0351  0.0%    138 0.0003  0.00 INSERT livecomment_reports
#   76 0x0C655718656DD9DDA39A0D11554A0C64   0.0346  0.0%     74 0.0005  0.00 INSERT ng_words
#   77 0xB871CC5B0472067402F5739D108B2C1C   0.0238  0.0%     74 0.0003  0.00 SELECT livestreams
#   78 0xEBE4AF9F935DE1D48BB5BB3558C7FCC4   0.0220  0.0%     27 0.0008  0.00 SELECT livestreams livecomments
#   79 0xB08B7B7486D2DFE2F2FE9CE78689FD79   0.0209  0.0%     74 0.0003  0.00 SELECT ng_words
#   80 0x8F885091E23CB955C051B1204EE7D91D   0.0177  0.0%     27 0.0007  0.00 SELECT livestreams reactions
#   81 0x20CD15DC47AF2F861B8F3C25D195ABE9   0.0146  0.0%     78 0.0002  0.00 SELECT tags
#   82 0x8B2044ADAE690405979131C33185F22A   0.0094  0.0%     45 0.0002  0.00 SELECT users
#   83 0xEDBC971AEC392917AA353644DE4C4CB4   0.0058  0.0%   1490 0.0000  0.00 ADMIN QUIT
#   84 0x0E7680C04FF2596BE3A3649C5FAC418D   0.0035  0.0%     36 0.0001  0.00 SELECT
#   85 0xC4625761E0CFD817F41B4802F152A489   0.0034  0.0%      4 0.0008  0.00 SELECT livecomments
#   86 0x394E66DDE2823A903078D4C0F235B948   0.0033  0.0%     27 0.0001  0.00 SELECT livestreams livecomment_reports
#   87 0xF085F31DC1964EA538732B713E4B4108   0.0031  0.0%     27 0.0001  0.00 SELECT livestreams livestream_viewers_history
#   88 0xE84E602C0D0858D5661956B70D72A215   0.0008  0.0%      4 0.0002  0.00 SELECT icons
#   89 0xE8390778DC20D4CC04FE01C5B31FD305   0.0000  0.0%      2 0.0000  0.00 ADMIN PING

# Query 1: 18.54 QPS, 0.16x concurrency, ID 0x42EF7D7D98FBCC9723BF896EBFC51D24 at byte 286774378
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T08:07:38 to 2023-11-25T08:23:52
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          1   18058
# Exec time     19    158s   713us    61ms     9ms    23ms     7ms     6ms
# Lock time      4   102ms       0    10ms     5us     1us   127us     1us
# Rows sent      0   6.46k       0       1    0.37    0.99    0.48       0
# Rows examine  27  24.49M   1.25k   1.52k   1.39k   1.46k   78.99   1.33k
# Query size     2   2.40M     129     217  139.64  151.03   10.47  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='ygfiwzwkojrto5qi0.u.isucon.dev' and domain_id=2\G

# Query 2: 484.30 QPS, 0.12x concurrency, ID 0xDA556F9115773A1A99AA0165670CE848 at byte 22004168
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T08:07:38 to 2023-11-25T08:23:52
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         29  471706
# Exec time     14    116s    20us   401ms   245us   972us     1ms    73us
# Lock time      0    82us       0    55us       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  13.50M      30      30      30      30       0      30
# String:
# Databases    isupipe (466645/98%), isudns (5061/1%)
# Hosts        localhost
# Users        isucon (466645/98%), isudns (5061/1%)
# Query_time distribution
#   1us
#  10us  ################################################################
# 100us  #################################
#   1ms  #####
#  10ms  #
# 100ms  #
#    1s
#  10s+
administrator command: Prepare\G

# Query 3: 14.80 QPS, 0.11x concurrency, ID 0x3D83BC87F3B3A00D571FFC8104A6E50C at byte 340653974
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T08:07:38 to 2023-11-25T08:23:52
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0   14420
# Exec time     13    108s   674us    70ms     7ms    21ms     7ms     5ms
# Lock time      2    47ms       0     6ms     3us     1us    64us     1us
# Rows sent      0   7.40k       0       1    0.53    0.99    0.50    0.99
# Rows examine  21  19.55M   1.25k   1.52k   1.39k   1.46k   79.44   1.33k
# Query size     1   1.83M     126     216  133.22  151.03    9.62  124.25
# 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 type='SOA' and name='pipe.u.isucon.dev'\G

# Query 4: 2.74 QPS, 0.06x concurrency, ID 0x59F1B6DD8D9FEC059E55B3BFD624E8C3 at byte 270662962
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T08:07:49 to 2023-11-25T08:23:52
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0    2642
# Exec time      7     58s     2ms    83ms    22ms    48ms    14ms    20ms
# Lock time      1    38ms       0    13ms    14us     1us   335us     1us
# Rows sent      0   2.58k       1       1       1       1       0       1
# Rows examine  24  22.07M   8.55k   8.55k   8.55k   8.55k       0   8.55k
# Query size     0 221.89k      86      86      86      86       0      86
# 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 'reservation_slots'\G
#    SHOW CREATE TABLE `isupipe`.`reservation_slots`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT slot FROM reservation_slots WHERE start_at = 1701410400 AND end_at = 1701414000\G

# Query 5: 16.87 QPS, 0.06x concurrency, ID 0xFFFCA4D67EA0A788813031B8BBC3B329 at byte 328707634
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T08:07:49 to 2023-11-25T08:23:52
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          1   16248
# Exec time      6     55s    17us    73ms     3ms    10ms     4ms     3ms
# 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     0  95.20k       6       6       6       6       0       6
# String:
# Databases    isupipe (15408/94%), isudns (840/5%)
# Hosts        localhost
# Users        isucon (15408/94%), isudns (840/5%)
# Query_time distribution
#   1us
#  10us  ##################################################
# 100us  ##########
#   1ms  ################################################################
#  10ms  ########
# 100ms
#    1s
#  10s+
COMMIT\G

[yukiex]

2023-11-25T08:22:34.687Z    info    isupipe-benchmarker SSL接続が有効になっています
2023-11-25T08:22:34.687Z    info    isupipe-benchmarker 静的ファイルチェックを行います
2023-11-25T08:22:34.687Z    info    isupipe-benchmarker 静的ファイルチェックが完了しました
2023-11-25T08:22:34.687Z    info    isupipe-benchmarker webappの初期化を行います
2023-11-25T08:22:44.772Z    info    isupipe-benchmarker ベンチマーク走行前のデータ整合性チェックを行います
2023-11-25T08:22:52.442Z    info    isupipe-benchmarker 整合性チェックが成功しました
2023-11-25T08:22:52.442Z    info    isupipe-benchmarker ベンチマーク走行を開始します
2023-11-25T08:23:52.443Z    info    isupipe-benchmarker ベンチマーク走行を停止します
2023-11-25T08:23:52.444Z    warn    isupipe-benchmarker ライブコメントを配信に投稿できないため、視聴者が離脱します   {"viewer": "yamamototaichi0", "livestream_id": 7536, "error": "Post \"https://nishikawa0.u.isucon.dev:443/api/livestream/7536/livecomment\": context canceled: ベンチマーク走行が継続できないエラーが発生しました"}
2023-11-25T08:23:52.444Z    warn    isupipe-benchmarker ライブコメントを配信に投稿できないため、視聴者が離脱します   {"viewer": "inakamura2", "livestream_id": 7568, "error": "Post \"https://bhasegawa0.u.isucon.dev:443/api/livestream/7568/livecomment\": context canceled: ベンチマーク走行が継続できないエラーが発生しました"}
2023-11-25T08:23:52.444Z    warn    isupipe-benchmarker ライブコメントを配信に投稿できないため、視聴者が離脱します   {"viewer": "nanamisato0", "livestream_id": 7551, "error": "Post \"https://yamamotomai0.u.isucon.dev:443/api/livestream/7551/livecomment\": context canceled: ベンチマーク走行が継続できないエラーが発生しました"}
2023-11-25T08:23:52.445Z    warn    isupipe-benchmarker ライブコメントを配信に投稿できないため、視聴者が離脱します   {"viewer": "shota222", "livestream_id": 7545, "error": "Post \"https://satomiishii0.u.isucon.dev:443/api/livestream/7545/livecomment\": context canceled: ベンチマーク走行が継続できないエラーが発生しました"}
2023-11-25T08:23:52.775Z    info    isupipe-benchmarker ベンチマーク走行終了
2023-11-25T08:23:52.775Z    info    isupipe-benchmarker 最終チェックを実施します
2023-11-25T08:23:52.775Z    info    isupipe-benchmarker 最終チェックが成功しました
2023-11-25T08:23:52.775Z    info    isupipe-benchmarker 重複排除したログを以下に出力します
2023-11-25T08:23:52.775Z    info    isupipe-benchmarker 配信を最後まで視聴できた視聴者数    {"viewers": 81}

[一般エラー] POST /api/livestream/7523/livecomment/1016/report へのリクエストに対して、期待されたHTTPステータスコードが確認できませんでした (expected:201, actual:404)
[一般エラー] POST /api/livestream/7527/livecomment/1063/report へのリクエストに対して、期待されたHTTPステータスコードが確認できませんでした (expected:201, actual:404)
[一般エラー] GET /api/livestream/7523/report へのリクエストに対して、期待されたHTTPステータスコードが確認できませんでした (expected:200, actual:500)
[一般エラー] POST /api/livestream/7528/livecomment/1079/report へのリクエストに対して、期待されたHTTPステータスコードが確認できませんでした (expected:201, actual:404)
[一般エラー] POST /api/livestream/7531/livecomment/1131/report へのリクエストに対して、期待されたHTTPステータスコードが確認できませんでした (expected:201, actual:404)
名前解決成功数 2164
売上: 16449