Benchmark result on isu3(11,795)

[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)
686	0	683	0	3	0	GET	/api/livestream/[a-zA-Z0-9]+/livecomment	0.004	0.888	164.364	0.240	0.516	0.632	0.768	0.185	0.000	80917.000	14911231.000	21736.488
7074	0	7071	0	3	0	GET	/api/user/[a-zA-Z0-9]+/icon	0.004	0.560	153.500	0.022	0.056	0.084	0.164	0.033	0.000	171652.000	436192199.000	61661.323
756	0	755	0	1	0	GET	/api/livestream/[a-zA-Z0-9]+/reaction	0.004	1.048	139.064	0.184	0.436	0.564	0.732	0.177	0.000	76510.000	12208137.000	16148.329
198	0	197	0	1	0	GET	/api/livestream/[a-zA-Z0-9]+$	0.004	2.156	112.376	0.568	0.704	1.368	1.916	0.323	0.000	143410.000	13203671.000	66685.207
269	0	266	0	2	1	POST	/api/register	0.004	0.660	54.828	0.204	0.288	0.316	0.376	0.073	0.000	516.000	124638.000	463.338
877	0	869	0	8	0	POST	/api/livestream/[a-zA-Z0-9]+/livecomment	0.008	0.388	50.340	0.057	0.100	0.128	0.208	0.039	0.000	2743.000	1703901.000	1942.875
131	0	127	0	4	0	POST	/api/livestream/[a-zA-Z0-9]+$	0.156	1.052	47.376	0.362	0.784	0.888	1.008	0.316	0.000	1463.000	141353.000	1079.031
653	0	651	0	2	0	POST	/api/livestream/[a-zA-Z0-9]+/reaction	0.004	0.312	32.868	0.050	0.092	0.128	0.204	0.038	0.000	2206.000	1202059.000	1840.825
303	0	302	0	1	0	GET	/api/livestream$	0.012	0.324	30.180	0.100	0.164	0.196	0.288	0.053	0.000	22554.000	369079.000	1218.083
2	0	2	0	0	0	POST	/api/initialize	11.248	11.856	23.104	11.552	11.856	11.856	11.856	0.304	27.000	27.000	54.000	27.000
90	0	89	0	0	1	POST	/api/livestream/[a-zA-Z0-9]+/moderate	0.004	0.600	11.328	0.126	0.248	0.292	0.600	0.106	23.000	135.000	2182.000	24.244
280	0	278	0	2	0	POST	/api/login	0.004	0.168	7.676	0.027	0.076	0.096	0.144	0.033	0.000	64.000	128.000	0.457
213	0	207	0	0	6	GET	/api/livestream/[a-zA-Z0-9]+/report	0.004	0.204	5.768	0.027	0.064	0.080	0.116	0.028	3.000	8182.000	42624.000	200.113
152	0	152	0	0	0	GET	/api/livestream/[a-zA-Z0-9]+/ngwords	0.004	0.184	5.524	0.036	0.088	0.124	0.180	0.037	5.000	932.000	19776.000	130.105
15	0	15	0	0	0	GET	/api/user/[a-zA-Z0-9]+/statistics	0.024	0.448	3.752	0.250	0.444	0.448	0.448	0.147	133.000	152.000	2097.000	139.800
70	0	70	0	0	0	POST	/api/livestream/[a-zA-Z0-9]+/enter	0.004	0.188	2.520	0.036	0.080	0.116	0.188	0.035	0.000	0.000	0.000	0.000
98	0	98	0	0	0	GET	/api/tag	0.004	0.204	2.344	0.024	0.052	0.096	0.204	0.032	6089.000	6095.000	597220.000	6094.082
58	0	58	0	0	0	DELETE	/api/livestream/[a-zA-Z0-9]+/exit	0.004	0.476	2.228	0.038	0.064	0.152	0.476	0.066	0.000	0.000	0.000	0.000
27	0	17	0	10	0	GET	/api/livestream/[a-zA-Z0-9]+/statistics	0.016	0.336	1.752	0.065	0.172	0.332	0.336	0.089	76.000	103.000	2483.000	91.963
11	0	11	0	0	0	GET	/api/user/[a-zA-Z0-9]+/livestream	0.068	0.204	1.424	0.129	0.168	0.204	0.204	0.039	1262.000	7664.000	33095.000	3008.636
265	0	265	0	0	0	POST	/api/icon	0.004	0.012	0.880	0.003	0.008	0.008	0.012	0.003	14.000	14.000	3710.000	14.000
13	0	13	0	0	0	GET	/api/user/[a-zA-Z0-9]+/theme	0.004	0.024	0.120	0.009	0.020	0.024	0.024	0.008	38.000	38.000	494.000	38.000
9	0	9	0	0	0	GET	/api/user/[a-zA-Z0-9]+$	0.004	0.004	0.012	0.001	0.004	0.004	0.004	0.002	235.000	247.000	2175.000	241.667
2	0	2	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	42.000	21.000

[github-actions[bot]]

Reading from STDIN ...

# 34.1s user time, 120ms system time, 39.67M rss, 46.21M vsz
# Current date: Sat Nov 25 07:13:22 2023
# Hostname: ip-192-168-0-13
# Files: STDIN
# Overall: 580.29k total, 89 unique, 1.20k QPS, 0.61x concurrency ________
# Time range: 2023-11-25T07:03:51 to 2023-11-25T07:11:54
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time           294s     1us   457ms   506us     2ms     3ms    52us
# Lock time          610ms       0    34ms     1us     1us    76us       0
# Rows sent        516.47k       0   7.42k    0.91    4.96   40.93       0
# Rows examine      32.29M       0  18.12k   58.34    4.96  495.53       0
# Query size        29.29M       5   1.94M   52.93   84.10   3.83k   31.70

# Profile
# Rank Query ID                           Response time Calls  R/Call V/M 
# ==== ================================== ============= ====== ====== ====
#    1 0x42EF7D7D98FBCC9723BF896EBFC51D24 54.8448 18.7%   6324 0.0087  0.01 SELECT records
#    2 0x3D83BC87F3B3A00D571FFC8104A6E50C 38.3629 13.1%   5131 0.0075  0.01 SELECT records
#    3 0xDA556F9115773A1A99AA0165670CE848 32.9927 11.2% 174377 0.0002  0.01 ADMIN PREPARE
#    4 0x59F1B6DD8D9FEC059E55B3BFD624E8C3 21.2713  7.2%    954 0.0223  0.01 SELECT reservation_slots
#    5 0xFFFCA4D67EA0A788813031B8BBC3B329 17.0535  5.8%   5126 0.0033  0.01 COMMIT
#    6 0x38BC86A45F31C6B1EE324671506C898A 17.0304  5.8%  42364 0.0004  0.00 SELECT themes
#    7 0x9EAD6C0CE525E3693EE27FFC9AAF05A3 15.9739  5.4%    328 0.0487  0.01 SELECT livestreams
#    8 0xEA1E6309EEEFF9A6831AD2FB940FC23C 10.1338  3.4%  42084 0.0002  0.00 SELECT users
#    9 0xDFFCC1D78939C4D781C7C58349101F50  8.9328  3.0%   2000 0.0045  0.00 INSERT users
#   10 0xD2A0864774622BA36F6557496405CF75  8.5375  2.9%   2267 0.0038  0.00 INSERT themes
#   11 0xF7144185D9A142A426A36DC55C1D2623  8.2307  2.8%  27000 0.0003  0.00 SELECT livestream_tags
#   12 0x55C45664C0A27CA4AF92DD1D2D0ABDAA  7.1902  2.4%  25850 0.0003  0.00 SELECT tags
#   13 0x22279D81D51006139E0C76405B54C261  6.3322  2.2%   7102 0.0009  0.00 SELECT domains domainmetadata
#   14 0x8F7679D452333ED3C7D60D22131CEFD4  5.5190  1.9%  20424 0.0003  0.00 ADMIN RESET STMT
#   15 0x859BBB7E9D760686137A944406874C4D  5.2211  1.8%    267 0.0196  0.01 DELETE records
#   16 0xA3401CA3ABCC04C3AB221DB8AD5CBF26  4.7799  1.6%    127 0.0376  0.03 UPDATE reservation_slots
#   17 0xD6032FE08E1FE706A928B8B7CBA06B85  4.4085  1.5%  19377 0.0002  0.00 SELECT livestreams
#   18 0x7F9C0C0BA9473953B723EE16C08655F1  3.9774  1.4%    129 0.0308  0.02 SELECT reservation_slots
#   19 0x9AC623FA477E73A44D191D296850A025  3.3656  1.1%    534 0.0063  0.01 SELECT records
#   20 0x3F155F5E71EFF856F0CF7B8430DE8C23  2.5259  0.9%   7379 0.0003  0.00 SELECT users
#   21 0xB78E63D0D9C72DDDAB7A3E53517FA04C  2.0454  0.7%    618 0.0033  0.00 SELECT livecomments
#   22 0xAD0C28443E1E5CFAFF1569DBB4F7E63A  1.6471  0.6%    690 0.0024  0.00 SELECT reactions
#   23 0x611999F76068C4DC4F90E0A389918E63  1.4102  0.5%     15 0.0940  0.04 SELECT users livestreams reactions livestreams livecomments
#   24 0x07890000813C4CC7111FD2D3F3B3B4EB  1.3794  0.5% 174352 0.0000  0.00 ADMIN CLOSE STMT
#   25 0xE4555A2709C09FD9BFF6688D80B0AA49  1.1602  0.4%     17 0.0682  0.07 SELECT livestreams reactions livecomments
#   26 0x98F959E03B684A5538FD8402A0EE94AD  0.9261  0.3%    206 0.0045  0.00 INSERT tags
#   27 0x02B6A87E51A5A1B7646675DB67C57DE3  0.9040  0.3%      2 0.4520  0.00 INSERT ng_words
#   28 0x0C1FCBB4E25B178AA3A46D4FECBA9BDC  0.6793  0.2%     44 0.0154  0.00 INSERT livestream_tags
#   29 0x80E10371CE74ED05E09C79C72C73F8E1  0.5981  0.2%    129 0.0046  0.23 INSERT livestreams
#   30 0x9E2DA589A20EC24C34E11DDE0FBF5564  0.5332  0.2%   4908 0.0001  0.00 START
#   31 0x77FB9E134D073862D1E78FEEC3436291  0.5161  0.2%   2827 0.0002  0.00 INSERT records
#   32 0x9FE1EB375E9ADFD57E719AA0C2924155  0.4625  0.2%    177 0.0026  0.00 SELECT livecomments
#   33 0x49F80FBE1AC70F23A3DD076174FF1AA9  0.3649  0.1%     15 0.0243  0.01 SELECT users livestreams reactions
#   34 0x651E3772B8767A368CB47EE7389EEB33  0.3517  0.1%     29 0.0121  0.02 SELECT livestream_tags
#   35 0x64CC8A4E8E4B390203375597CE4D611F  0.3119  0.1%    823 0.0004  0.00 SELECT ng_words
#   36 0xF985E5835B84E84C7A721801818E98CE  0.3112  0.1%     15 0.0207  0.02 SELECT users livestreams reactions
#   37 0xF3A502CCF34F7DA288CC1B75AD5AFA37  0.2972  0.1%    821 0.0004  0.00 INSERT livecomments
#   38 0xDF0AAE38E2AAFC85E6F50569CEF2285D  0.2732  0.1%      2 0.1366  0.00 INSERT reservation_slots
#   39 0x4B6FA79E206C6CED71D433A2FC998D69  0.2617  0.1%    842 0.0003  0.00 SELECT
#   40 0x5AEB6E4A781A3854CF642125E293FEE0  0.2152  0.1%    652 0.0003  0.00 INSERT reactions
#   41 0xEE4C51AE2BF74414C4892CBE11E894AA  0.2025  0.1%     68 0.0030  0.00 SELECT livecomments
#   42 0xE64D50F7AFC1AD5F465809A92DF4935E  0.1348  0.0%     66 0.0020  0.00 SELECT reactions
#   43 0x5D469B53C536D19CD15E40763ACC23C7  0.1347  0.0%    499 0.0003  0.00 INSERT livestream_tags
#   44 0x24C44C3518CE12293EF12410AEDA2393  0.1333  0.0%    167 0.0008  0.00 SELECT livestreams
#   45 0x2B760561C10B5D133155AA306D0F407C  0.1317  0.0%     62 0.0021  0.01 SELECT livecomments
#   46 0x64052B1C32B30DF53AB3292208B783B4  0.1221  0.0%    268 0.0005  0.00 INSERT users
#   47 0xB9AC05A7AE6C4E30B5B45F6F3CE05BE0  0.1217  0.0%    545 0.0002  0.00 SET
#   48 0xE623383C5D789800DC0946925F90039F  0.0882  0.0%    269 0.0003  0.00 SELECT domains
#   49 0x1FB70DBF74628C9F2E9F0C3478771936  0.0862  0.0%      2 0.0431  0.00 TRUNCATE TABLE ng_words
#   50 0xD2978B45C67B47B5D73AC532EB40A95E  0.0857  0.0%      2 0.0429  0.00 TRUNCATE TABLE themes
#   51 0xDBB1C17D6ABA0156D8ABCE105DDDA1B2  0.0818  0.0%      2 0.0409  0.00 TRUNCATE TABLE users
#   52 0x07F6C3FF39ADD79FC63923A7EE938953  0.0771  0.0%      2 0.0386  0.00 INSERT livecomments
#   53 0xAFFDC331C1D4BA089978A0B8DD00BFC8  0.0767  0.0%      2 0.0383  0.00 TRUNCATE TABLE livestreams
#   54 0x08A6ACD83D579DD8A808134B32AD376B  0.0739  0.0%      2 0.0369  0.00 TRUNCATE TABLE livestream_tags
#   55 0x466EE4C87B17CAD4E692DE1D44EAD84D  0.0729  0.0%    213 0.0003  0.00 SELECT livecomment_reports
#   56 0xBB7F4DC4E67BF30E0588D296FFAF009F  0.0719  0.0%      2 0.0360  0.00 TRUNCATE TABLE tags
#   57 0x2AAED5867123C749367FD8E4BBD796D2  0.0691  0.0%      2 0.0345  0.01 TRUNCATE TABLE livecomments
#   58 0x253CA101A906B3D56A95D1B8DCEE28EF  0.0677  0.0%      2 0.0339  0.00 TRUNCATE TABLE icons
#   59 0x93A42F50BF286ACA749DF5F342FAC07B  0.0655  0.0%      2 0.0327  0.00 TRUNCATE TABLE livecomment_reports
#   60 0xA7C2E59AEF14D03CB65B227F3E3BA469  0.0646  0.0%      2 0.0323  0.00 TRUNCATE TABLE reservation_slots
#   61 0xFB296F703ACC41C3F94A9B7D75044F3C  0.0631  0.0%      2 0.0316  0.00 TRUNCATE TABLE reactions
#   62 0x9C697B3F0446BBF7602663588252F020  0.0586  0.0%      2 0.0293  0.00 TRUNCATE TABLE livestream_viewers_history
#   63 0x8D589AFA4DFAEEED85FFF5AA78E5FF6A  0.0498  0.0%    269 0.0002  0.00 BEGIN
#   64 0xEDE18C1523658A19E07525EAFCBA6BFE  0.0489  0.0%    152 0.0003  0.00 SELECT ng_words
#   65 0x74232BDFFB94C567F0340DBE3285E458  0.0469  0.0%      2 0.0235  0.00 INSERT reactions
#   66 0x722BF793949484884D382A709285091D  0.0422  0.0%      6 0.0070  0.00 DELETE livecomments
#   67 0x544239977D2094F805A7B062DE95673A  0.0399  0.0%     98 0.0004  0.00 SELECT tags
#   68 0x0C655718656DD9DDA39A0D11554A0C64  0.0345  0.0%     90 0.0004  0.00 INSERT ng_words
#   69 0x81E419F4B58AEB9B280B03DE44DD8B94  0.0339  0.0%    124 0.0003  0.00 SELECT livecomments
#   70 0xB871CC5B0472067402F5739D108B2C1C  0.0314  0.0%     90 0.0003  0.00 SELECT livestreams
#   71 0xDFEFE5BA5D8654534DC8550C6E3DC9C0  0.0235  0.0%      2 0.0117  0.00 DELETE records
#   72 0xB08B7B7486D2DFE2F2FE9CE78689FD79  0.0227  0.0%     90 0.0003  0.00 SELECT ng_words
#   73 0xB962B14EDA3C9149DE2F648A5F0347D5  0.0223  0.0%      1 0.0223  0.00 SELECT domains records
#   74 0xA0D956F292B7FEA0DCE68A5DD5F529E1  0.0212  0.0%     58 0.0004  0.00 DELETE livestream_viewers_history
#   75 0xFFF66E9B3D962FA319C8068B5C1997CD  0.0142  0.0%     44 0.0003  0.00 ROLLBACK
#   76 0x8F885091E23CB955C051B1204EE7D91D  0.0136  0.0%     17 0.0008  0.00 SELECT livestreams reactions
#   77 0xBF3194A2446AC20FC99B6CC7FA476A57  0.0126  0.0%     70 0.0002  0.00 INSERT livestream_viewers_history
#   78 0x827F41D30F8E37F04D8BDCD46C556FB3  0.0123  0.0%     49 0.0003  0.00 INSERT livecomment_reports
#   79 0xEBE4AF9F935DE1D48BB5BB3558C7FCC4  0.0113  0.0%     17 0.0007  0.00 SELECT livestreams livecomments
#   80 0x2C17BCA1E1077820CDC2EC6106F4D93E  0.0100  0.0%     62 0.0002  0.00 SELECT livestream_viewers_history
#   81 0x20CD15DC47AF2F861B8F3C25D195ABE9  0.0059  0.0%     29 0.0002  0.00 SELECT tags
#   82 0xF085F31DC1964EA538732B713E4B4108  0.0046  0.0%     17 0.0003  0.00 SELECT livestreams livestream_viewers_history
#   83 0x8B2044ADAE690405979131C33185F22A  0.0043  0.0%     13 0.0003  0.00 SELECT users
#   84 0x394E66DDE2823A903078D4C0F235B948  0.0034  0.0%     17 0.0002  0.00 SELECT livestreams livecomment_reports
#   85 0x0E7680C04FF2596BE3A3649C5FAC418D  0.0014  0.0%     18 0.0001  0.00 SELECT
#   86 0xC4625761E0CFD817F41B4802F152A489  0.0012  0.0%      2 0.0006  0.00 SELECT livecomments
#   87 0xEDBC971AEC392917AA353644DE4C4CB4  0.0009  0.0%    442 0.0000  0.00 ADMIN QUIT
#   88 0xE84E602C0D0858D5661956B70D72A215  0.0004  0.0%      2 0.0002  0.00 SELECT icons
#   89 0xE8390778DC20D4CC04FE01C5B31FD305  0.0000  0.0%      1 0.0000  0.00 ADMIN PING

# Query 1: 13.09 QPS, 0.11x concurrency, ID 0x42EF7D7D98FBCC9723BF896EBFC51D24 at byte 75713391
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T07:03:51 to 2023-11-25T07:11:54
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          1    6324
# Exec time     18     55s   713us    66ms     9ms    23ms     8ms     6ms
# Lock time      8    49ms       0    13ms     7us     1us   203us     1us
# Rows sent      0   2.50k       0       1    0.41    0.99    0.49       0
# Rows examine  26   8.54M   1.25k   1.53k   1.38k   1.46k   77.06   1.33k
# Query size     2 861.41k     129     204  139.48  151.03   10.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 2: 10.62 QPS, 0.08x concurrency, ID 0x3D83BC87F3B3A00D571FFC8104A6E50C at byte 146957224
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T07:03:51 to 2023-11-25T07:11:54
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0    5131
# Exec time     13     38s   673us    52ms     7ms    21ms     7ms     5ms
# Lock time      4    27ms       0    10ms     5us     1us   140us     1us
# Rows sent      0   2.62k       0       1    0.52    0.99    0.50    0.99
# Rows examine  21   6.93M   1.25k   1.53k   1.38k   1.46k   77.87   1.33k
# Query size     2 666.85k     126     203  133.08  151.03    9.30  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 3: 361.03 QPS, 0.07x concurrency, ID 0xDA556F9115773A1A99AA0165670CE848 at byte 22795015
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T07:03:51 to 2023-11-25T07:11:54
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         30  174377
# Exec time     11     33s    21us   337ms   189us   761us     1ms    49us
# Lock time      0    21us       0    15us       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    17   4.99M      30      30      30      30       0      30
# String:
# Databases    isupipe (172748/99%), isudns (1629/0%)
# Hosts        localhost
# Users        isucon (172748/99%), isudns (1629/0%)
# Query_time distribution
#   1us
#  10us  ################################################################
# 100us  #################
#   1ms  ###
#  10ms  #
# 100ms  #
#    1s
#  10s+
administrator command: Prepare\G

# Query 4: 2.02 QPS, 0.05x concurrency, ID 0x59F1B6DD8D9FEC059E55B3BFD624E8C3 at byte 60641582
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T07:04:02 to 2023-11-25T07:11:54
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0     954
# Exec time      7     21s     2ms    87ms    22ms    48ms    14ms    19ms
# Lock time      0     3ms       0     1ms     3us     1us    44us     1us
# Rows sent      0     954       1       1       1       1       0       1
# Rows examine  24   7.97M   8.55k   8.55k   8.55k   8.55k       0   8.55k
# Query size     0  80.12k      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 = 1701154800 AND end_at = 1701158400\G

# Query 5: 10.86 QPS, 0.04x concurrency, ID 0xFFFCA4D67EA0A788813031B8BBC3B329 at byte 67861156
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T07:04:02 to 2023-11-25T07:11:54
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0    5126
# Exec time      5     17s    19us    73ms     3ms    11ms     4ms     1ms
# 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  30.04k       6       6       6       6       0       6
# String:
# Databases    isupipe (4857/94%), isudns (269/5%)
# Hosts        localhost
# Users        isucon (4857/94%), isudns (269/5%)
# Query_time distribution
#   1us
#  10us  ######################################################
# 100us  ############
#   1ms  ################################################################
#  10ms  #########
# 100ms
#    1s
#  10s+
commit\G

[yukiex]

2023-11-25T07:10:35.244Z    info    isupipe-benchmarker SSL接続が有効になっています
2023-11-25T07:10:35.244Z    info    isupipe-benchmarker 静的ファイルチェックを行います
2023-11-25T07:10:35.244Z    info    isupipe-benchmarker 静的ファイルチェックが完了しました
2023-11-25T07:10:35.244Z    info    isupipe-benchmarker webappの初期化を行います
2023-11-25T07:10:47.125Z    info    isupipe-benchmarker ベンチマーク走行前のデータ整合性チェックを行います
2023-11-25T07:10:54.673Z    info    isupipe-benchmarker 整合性チェックが成功しました
2023-11-25T07:10:54.673Z    info    isupipe-benchmarker ベンチマーク走行を開始します
2023-11-25T07:11:54.674Z    info    isupipe-benchmarker ベンチマーク走行を停止します
2023-11-25T07:11:54.675Z    warn    isupipe-benchmarker ライブコメントを配信に投稿できないため、視聴者が離脱します   {"viewer": "jwatanabe3", "livestream_id": 7586, "error": "Post \"https://hyoshida0.u.isucon.dev:443/api/livestream/7586/livecomment\": context canceled: ベンチマーク走行が継続できないエラーが発生しました"}
2023-11-25T07:11:54.675Z    warn    isupipe-benchmarker ライブコメントを配信に投稿できないため、視聴者が離脱します   {"viewer": "nanamitanaka2", "livestream_id": 7581, "error": "Post \"https://bhasegawa0.u.isucon.dev:443/api/livestream/7581/livecomment\": context canceled: ベンチマーク走行が継続できないエラーが発生しました"}
2023-11-25T07:11:54.675Z    warn    isupipe-benchmarker ライブコメントを配信に投稿できないため、視聴者が離脱します   {"viewer": "yamadaatsushi1", "livestream_id": 7541, "error": "Post \"https://shayashi0.u.isucon.dev:443/api/livestream/7541/livecomment\": context canceled: ベンチマーク走行が継続できないエラーが発生しました"}
2023-11-25T07:11:54.676Z    warn    isupipe-benchmarker ライブコメントを配信に投稿できないため、視聴者が離脱します   {"viewer": "naokiyamaguchi0", "livestream_id": 7559, "error": "Post \"https://wito0.u.isucon.dev:443/api/livestream/7559/livecomment\": context canceled: ベンチマーク走行が継続できないエラーが発生しました"}
2023-11-25T07:11:54.759Z    info    isupipe-benchmarker ベンチマーク走行終了
2023-11-25T07:11:54.759Z    info    isupipe-benchmarker 最終チェックを実施します
2023-11-25T07:11:54.760Z    info    isupipe-benchmarker 最終チェックが成功しました
2023-11-25T07:11:54.760Z    info    isupipe-benchmarker 重複排除したログを以下に出力します
2023-11-25T07:11:54.760Z    info    isupipe-benchmarker 配信を最後まで視聴できた視聴者数    {"viewers": 56}

[一般エラー] POST /api/livestream/7523/livecomment/1021/report へのリクエストに対して、期待されたHTTPステータスコードが確認できませんでした (expected:201, actual:404)
[一般エラー] GET /api/livestream/7523/report へのリクエストに対して、期待されたHTTPステータスコードが確認できませんでした (expected:200, actual:500)
[一般エラー] POST /api/livestream/7538/livecomment へのリクエストに対して、期待されたHTTPステータスコードが確認できませんでした (expected:400, actual:201)
[一般エラー] GET /api/livestream/7522/report へのリクエストに対して、期待されたHTTPステータスコードが確認できませんでした (expected:200, actual:500)
[一般エラー] GET /api/livestream/7527/report へのリクエストに対して、期待されたHTTPステータスコードが確認できませんでした (expected:200, actual:500)
[一般エラー] POST /api/livestream/7527/livecomment/1051/report へのリクエストに対して、期待されたHTTPステータスコードが確認できませんでした (expected:201, actual:404)
[一般エラー] POST /api/livestream/7527/livecomment/1052/report へのリクエストに対して、期待されたHTTPステータスコードが確認できませんでした (expected:201, actual:404)
[一般エラー] POST /api/livestream/7522/livecomment/1065/report へのリクエストに対して、期待されたHTTPステータスコードが確認できませんでした (expected:201, actual:404)
[リクエストタイムアウト] GET /api/livestream: Get "https://pipe.u.isucon.dev:443/api/livestream": read udp 10.0.27.76:37053->57.180.159.35:53: i/o timeout: タイムアウトによりリクエスト失敗
名前解決成功数 2316
売上: 11795