Benchmark result on isu3(10,667)

[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)
6236	0	6235	0	1	0	GET	/api/user/[a-zA-Z0-9]+/icon	0.004	0.444	164.620	0.026	0.072	0.112	0.200	0.042	0.000	164797.000	362458692.000	58123.588
23	0	21	0	2	0	POST	/api/livestream/[a-zA-Z0-9]+/moderate	0.288	14.252	130.664	5.681	12.744	13.704	14.252	3.456	0.000	23.000	483.000	21.000
609	0	608	0	1	0	GET	/api/livestream/[a-zA-Z0-9]+/livecomment	0.004	0.848	128.244	0.211	0.444	0.544	0.652	0.161	0.000	73397.000	12111205.000	19887.036
641	0	639	0	2	0	GET	/api/livestream/[a-zA-Z0-9]+/reaction	0.004	0.724	126.220	0.197	0.448	0.520	0.660	0.163	0.000	68386.000	10938729.000	17065.100
638	0	630	0	8	0	POST	/api/livestream/[a-zA-Z0-9]+/livecomment	0.008	0.504	76.796	0.120	0.180	0.216	0.280	0.052	1955.000	2695.000	1249705.000	1958.785
285	0	283	0	1	1	POST	/api/register	0.004	0.728	57.544	0.202	0.288	0.336	0.536	0.081	67.000	504.000	132647.000	465.428
103	0	99	0	4	0	POST	/api/livestream/[a-zA-Z0-9]+$	0.192	0.940	42.896	0.416	0.772	0.804	0.892	0.295	0.000	1475.000	111956.000	1086.951
73	0	73	0	0	0	GET	/api/livestream/[a-zA-Z0-9]+$	0.044	1.724	42.016	0.576	1.200	1.568	1.724	0.404	3.000	128364.000	5091868.000	69751.616
560	0	559	0	1	0	POST	/api/livestream/[a-zA-Z0-9]+/reaction	0.004	0.544	32.652	0.058	0.128	0.172	0.236	0.052	0.000	2215.000	1037655.000	1852.955
1	0	1	0	0	0	POST	/api/initialize	10.888	10.888	10.888	10.888	10.888	10.888	10.888	0.000	27.000	27.000	27.000	27.000
291	0	289	0	2	0	POST	/api/login	0.004	0.344	9.568	0.033	0.084	0.108	0.192	0.043	0.000	64.000	128.000	0.440
96	0	95	0	1	0	GET	/api/livestream$	0.004	0.504	8.244	0.086	0.148	0.208	0.504	0.066	0.000	22444.000	128705.000	1340.677
90	0	90	0	0	0	GET	/api/tag	0.004	0.392	4.116	0.046	0.108	0.152	0.392	0.058	17.000	6095.000	542340.000	6026.000
13	0	13	0	0	0	GET	/api/user/[a-zA-Z0-9]+/statistics	0.024	0.512	3.904	0.300	0.412	0.512	0.512	0.136	133.000	154.000	1770.000	136.154
23	0	13	0	10	0	GET	/api/livestream/[a-zA-Z0-9]+/statistics	0.016	0.652	3.508	0.153	0.356	0.396	0.652	0.177	76.000	104.000	2087.000	90.739
38	0	38	0	0	0	GET	/api/livestream/[a-zA-Z0-9]+/ngwords	0.008	0.228	3.424	0.090	0.132	0.184	0.228	0.041	5.000	265.000	867.000	22.816
63	0	63	0	0	0	POST	/api/livestream/[a-zA-Z0-9]+/enter	0.004	0.256	2.840	0.045	0.116	0.136	0.256	0.048	0.000	0.000	0.000	0.000
56	0	55	0	0	1	GET	/api/livestream/[a-zA-Z0-9]+/report	0.004	0.228	2.308	0.041	0.124	0.136	0.228	0.050	3.000	16522.000	85979.000	1535.339
53	0	52	0	1	0	DELETE	/api/livestream/[a-zA-Z0-9]+/exit	0.000	0.224	2.224	0.042	0.096	0.140	0.224	0.046	0.000	0.000	0.000	0.000
11	0	11	0	0	0	GET	/api/user/[a-zA-Z0-9]+/livestream	0.068	0.200	1.340	0.122	0.176	0.200	0.200	0.038	1243.000	2571.000	16575.000	1506.818
284	0	284	0	0	0	POST	/api/icon	0.004	0.012	0.776	0.003	0.004	0.008	0.012	0.002	14.000	14.000	3976.000	14.000
12	0	12	0	0	0	GET	/api/user/[a-zA-Z0-9]+/theme	0.004	0.096	0.360	0.030	0.076	0.096	0.096	0.030	38.000	38.000	456.000	38.000
6	0	6	0	0	0	GET	/api/user/[a-zA-Z0-9]+$	0.004	0.060	0.072	0.012	0.060	0.060	0.060	0.022	235.000	247.000	1458.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 ...

# 32.5s user time, 140ms system time, 35.91M rss, 42.42M vsz
# Current date: Sat Nov 25 06:29:21 2023
# Hostname: ip-192-168-0-13
# Files: STDIN
# Overall: 542.50k total, 87 unique, 6.96k QPS, 4.13x concurrency ________
# Time range: 2023-11-25T06:26:25 to 2023-11-25T06:27:43
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time           322s     1us   381ms   593us     2ms     3ms    66us
# Lock time          632ms       0    21ms     1us     1us    59us       0
# Rows sent        409.42k       0   7.41k    0.77    4.96   38.31       0
# Rows examine      36.97M       0  17.76k   71.47    4.96  669.22       0
# Query size        34.77M       5   1.94M   67.20  313.99   2.80k   31.70

# Profile
# Rank Query ID                           Response time Calls  R/Call V/M 
# ==== ================================== ============= ====== ====== ====
#    1 0x42EF7D7D98FBCC9723BF896EBFC51D24 51.9638 16.1%   6140 0.0085  0.01 SELECT records
#    2 0xDA556F9115773A1A99AA0165670CE848 50.4973 15.7% 164361 0.0003  0.01 ADMIN PREPARE
#    3 0x3D83BC87F3B3A00D571FFC8104A6E50C 34.0068 10.6%   4833 0.0070  0.01 SELECT records
#    4 0x64CC8A4E8E4B390203375597CE4D611F 28.6017  8.9%    587 0.0487  0.01 SELECT ng_words
#    5 0x59F1B6DD8D9FEC059E55B3BFD624E8C3 18.9189  5.9%    842 0.0225  0.01 SELECT reservation_slots
#    6 0x38BC86A45F31C6B1EE324671506C898A 16.6402  5.2%  30615 0.0005  0.00 SELECT themes
#    7 0x4ADE2DC90689F1C4891749AF54FB8D14 14.6587  4.6%  39067 0.0004  0.00 DELETE SELECT livecomments
#    8 0xFFFCA4D67EA0A788813031B8BBC3B329 14.1885  4.4%   3922 0.0036  0.00 COMMIT
#    9 0xEA1E6309EEEFF9A6831AD2FB940FC23C  9.5068  3.0%  30320 0.0003  0.00 SELECT users
#   10 0xF7144185D9A142A426A36DC55C1D2623  7.1283  2.2%  17574 0.0004  0.00 SELECT livestream_tags
#   11 0x22279D81D51006139E0C76405B54C261  6.7145  2.1%   6960 0.0010  0.00 SELECT domains domainmetadata
#   12 0x55C45664C0A27CA4AF92DD1D2D0ABDAA  6.3023  2.0%  16947 0.0004  0.00 SELECT tags
#   13 0x9EAD6C0CE525E3693EE27FFC9AAF05A3  5.7797  1.8%    119 0.0486  0.01 SELECT livestreams
#   14 0x8F7679D452333ED3C7D60D22131CEFD4  5.6024  1.7%  19240 0.0003  0.00 ADMIN RESET STMT
#   15 0x859BBB7E9D760686137A944406874C4D  5.4902  1.7%    283 0.0194  0.01 DELETE records
#   16 0xA3401CA3ABCC04C3AB221DB8AD5CBF26  4.5947  1.4%     99 0.0464  0.02 UPDATE reservation_slots
#   17 0xD6032FE08E1FE706A928B8B7CBA06B85  4.5665  1.4%  15555 0.0003  0.00 SELECT livestreams
#   18 0xD2A0864774622BA36F6557496405CF75  4.3807  1.4%   1283 0.0034  0.00 INSERT themes
#   19 0xDFFCC1D78939C4D781C7C58349101F50  4.2501  1.3%   1000 0.0043  0.00 INSERT users
#   20 0x9AC623FA477E73A44D191D296850A025  3.8156  1.2%    566 0.0067  0.01 SELECT records
#   21 0x7F9C0C0BA9473953B723EE16C08655F1  3.8080  1.2%    101 0.0377  0.02 SELECT reservation_slots
#   22 0x3F155F5E71EFF856F0CF7B8430DE8C23  2.7071  0.8%   6551 0.0004  0.00 SELECT users
#   23 0xEDE18C1523658A19E07525EAFCBA6BFE  1.8885  0.6%     38 0.0497  0.01 SELECT ng_words
#   24 0xE4555A2709C09FD9BFF6688D80B0AA49  1.7699  0.5%     13 0.1361  0.03 SELECT livestreams reactions livecomments
#   25 0xB78E63D0D9C72DDDAB7A3E53517FA04C  1.7249  0.5%    547 0.0032  0.00 SELECT livecomments
#   26 0x07890000813C4CC7111FD2D3F3B3B4EB  1.6952  0.5% 164342 0.0000  0.00 ADMIN CLOSE STMT
#   27 0x611999F76068C4DC4F90E0A389918E63  1.6674  0.5%     13 0.1283  0.04 SELECT users livestreams reactions livestreams livecomments
#   28 0xAD0C28443E1E5CFAFF1569DBB4F7E63A  1.5756  0.5%    580 0.0027  0.00 SELECT reactions
#   29 0xB08B7B7486D2DFE2F2FE9CE78689FD79  1.2143  0.4%     23 0.0528  0.01 SELECT ng_words
#   30 0x9E2DA589A20EC24C34E11DDE0FBF5564  0.5479  0.2%   3682 0.0001  0.00 START
#   31 0x98F959E03B684A5538FD8402A0EE94AD  0.4060  0.1%    103 0.0039  0.00 INSERT tags
#   32 0x02B6A87E51A5A1B7646675DB67C57DE3  0.3809  0.1%      1 0.3809  0.00 INSERT ng_words
#   33 0xF3A502CCF34F7DA288CC1B75AD5AFA37  0.3776  0.1%    584 0.0006  0.00 INSERT livecomments
#   34 0xF985E5835B84E84C7A721801818E98CE  0.3760  0.1%     13 0.0289  0.01 SELECT users livestreams reactions
#   35 0x77FB9E134D073862D1E78FEEC3436291  0.3758  0.1%   1563 0.0002  0.00 INSERT records
#   36 0x49F80FBE1AC70F23A3DD076174FF1AA9  0.3493  0.1%     13 0.0269  0.02 SELECT users livestreams reactions
#   37 0x80E10371CE74ED05E09C79C72C73F8E1  0.3382  0.1%    100 0.0034  0.19 INSERT livestreams
#   38 0x651E3772B8767A368CB47EE7389EEB33  0.3175  0.1%     20 0.0159  0.02 SELECT livestream_tags
#   39 0x0C1FCBB4E25B178AA3A46D4FECBA9BDC  0.2929  0.1%     22 0.0133  0.00 INSERT livestream_tags
#   40 0x41F805E95754958A974F41AE07BEA625  0.2205  0.1%     31 0.0071  0.00 SELECT livecomments
#   41 0x5AEB6E4A781A3854CF642125E293FEE0  0.2161  0.1%    560 0.0004  0.00 INSERT reactions
#   42 0xE64D50F7AFC1AD5F465809A92DF4935E  0.1988  0.1%     61 0.0033  0.00 SELECT reactions
#   43 0x64052B1C32B30DF53AB3292208B783B4  0.1787  0.1%    284 0.0006  0.00 INSERT users
#   44 0xB9AC05A7AE6C4E30B5B45F6F3CE05BE0  0.1539  0.0%    568 0.0003  0.00 SET
#   45 0xEE4C51AE2BF74414C4892CBE11E894AA  0.1405  0.0%     62 0.0023  0.00 SELECT livecomments
#   46 0x5D469B53C536D19CD15E40763ACC23C7  0.1312  0.0%    417 0.0003  0.00 INSERT livestream_tags
#   47 0xDF0AAE38E2AAFC85E6F50569CEF2285D  0.1300  0.0%      1 0.1300  0.00 INSERT reservation_slots
#   48 0x2B760561C10B5D133155AA306D0F407C  0.0998  0.0%     31 0.0032  0.01 SELECT livecomments
#   49 0xE623383C5D789800DC0946925F90039F  0.0804  0.0%    284 0.0003  0.00 SELECT domains
#   50 0x4B6FA79E206C6CED71D433A2FC998D69  0.0612  0.0%    144 0.0004  0.00 SELECT
#   51 0x544239977D2094F805A7B062DE95673A  0.0593  0.0%     90 0.0007  0.00 SELECT tags
#   52 0x8F885091E23CB955C051B1204EE7D91D  0.0415  0.0%     13 0.0032  0.00 SELECT livestreams reactions
#   53 0xBB7F4DC4E67BF30E0588D296FFAF009F  0.0402  0.0%      1 0.0402  0.00 TRUNCATE TABLE tags
#   54 0x2AAED5867123C749367FD8E4BBD796D2  0.0361  0.0%      1 0.0361  0.00 TRUNCATE TABLE livecomments
#   55 0x1FB70DBF74628C9F2E9F0C3478771936  0.0360  0.0%      1 0.0360  0.00 TRUNCATE TABLE ng_words
#   56 0x08A6ACD83D579DD8A808134B32AD376B  0.0359  0.0%      1 0.0359  0.00 TRUNCATE TABLE livestream_tags
#   57 0x8D589AFA4DFAEEED85FFF5AA78E5FF6A  0.0353  0.0%    284 0.0001  0.00 BEGIN
#   58 0xFB296F703ACC41C3F94A9B7D75044F3C  0.0324  0.0%      1 0.0324  0.00 TRUNCATE TABLE reactions
#   59 0xD2978B45C67B47B5D73AC532EB40A95E  0.0324  0.0%      1 0.0324  0.00 TRUNCATE TABLE themes
#   60 0x07F6C3FF39ADD79FC63923A7EE938953  0.0324  0.0%      1 0.0324  0.00 INSERT livecomments
#   61 0xDBB1C17D6ABA0156D8ABCE105DDDA1B2  0.0317  0.0%      1 0.0317  0.00 TRUNCATE TABLE users
#   62 0xAFFDC331C1D4BA089978A0B8DD00BFC8  0.0311  0.0%      1 0.0311  0.00 TRUNCATE TABLE livestreams
#   63 0x81E419F4B58AEB9B280B03DE44DD8B94  0.0291  0.0%    130 0.0002  0.00 SELECT livecomments
#   64 0x93A42F50BF286ACA749DF5F342FAC07B  0.0284  0.0%      1 0.0284  0.00 TRUNCATE TABLE livecomment_reports
#   65 0x24C44C3518CE12293EF12410AEDA2393  0.0274  0.0%     52 0.0005  0.00 SELECT livestreams
#   66 0x253CA101A906B3D56A95D1B8DCEE28EF  0.0270  0.0%      1 0.0270  0.00 TRUNCATE TABLE icons
#   67 0xBF3194A2446AC20FC99B6CC7FA476A57  0.0250  0.0%     63 0.0004  0.00 INSERT livestream_viewers_history
#   68 0x9C697B3F0446BBF7602663588252F020  0.0245  0.0%      1 0.0245  0.00 TRUNCATE TABLE livestream_viewers_history
#   69 0xA7C2E59AEF14D03CB65B227F3E3BA469  0.0237  0.0%      1 0.0237  0.00 TRUNCATE TABLE reservation_slots
#   70 0xA0D956F292B7FEA0DCE68A5DD5F529E1  0.0233  0.0%     52 0.0004  0.00 DELETE livestream_viewers_history
#   71 0x466EE4C87B17CAD4E692DE1D44EAD84D  0.0209  0.0%     56 0.0004  0.00 SELECT livecomment_reports
#   72 0x74232BDFFB94C567F0340DBE3285E458  0.0201  0.0%      1 0.0201  0.00 INSERT reactions
#   73 0xFFF66E9B3D962FA319C8068B5C1997CD  0.0192  0.0%     34 0.0006  0.00 ROLLBACK
#   74 0x827F41D30F8E37F04D8BDCD46C556FB3  0.0176  0.0%     47 0.0004  0.00 INSERT livecomment_reports
#   75 0x2C17BCA1E1077820CDC2EC6106F4D93E  0.0159  0.0%     31 0.0005  0.00 SELECT livestream_viewers_history
#   76 0xEBE4AF9F935DE1D48BB5BB3558C7FCC4  0.0151  0.0%     13 0.0012  0.00 SELECT livestreams livecomments
#   77 0x0C655718656DD9DDA39A0D11554A0C64  0.0135  0.0%     23 0.0006  0.00 INSERT ng_words
#   78 0xDFEFE5BA5D8654534DC8550C6E3DC9C0  0.0123  0.0%      1 0.0123  0.00 DELETE records
#   79 0x394E66DDE2823A903078D4C0F235B948  0.0066  0.0%     13 0.0005  0.00 SELECT livestreams livecomment_reports
#   80 0xB871CC5B0472067402F5739D108B2C1C  0.0042  0.0%     23 0.0002  0.00 SELECT livestreams
#   81 0xF085F31DC1964EA538732B713E4B4108  0.0036  0.0%     13 0.0003  0.00 SELECT livestreams livestream_viewers_history
#   82 0x20CD15DC47AF2F861B8F3C25D195ABE9  0.0036  0.0%     20 0.0002  0.00 SELECT tags
#   83 0x8B2044ADAE690405979131C33185F22A  0.0019  0.0%     12 0.0002  0.00 SELECT users
#   84 0xEDBC971AEC392917AA353644DE4C4CB4  0.0009  0.0%    438 0.0000  0.00 ADMIN QUIT
#   85 0x0E7680C04FF2596BE3A3649C5FAC418D  0.0007  0.0%      9 0.0001  0.00 SELECT
#   86 0xC4625761E0CFD817F41B4802F152A489  0.0004  0.0%      1 0.0004  0.00 SELECT livecomments
#   87 0xE84E602C0D0858D5661956B70D72A215  0.0002  0.0%      1 0.0002  0.00 SELECT icons

# Query 1: 78.72 QPS, 0.67x concurrency, ID 0x42EF7D7D98FBCC9723BF896EBFC51D24 at byte 43088310
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T06:26:25 to 2023-11-25T06:27:43
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          1    6140
# Exec time     16     52s   717us    67ms     8ms    23ms     7ms     6ms
# Lock time      7    47ms       0    12ms     7us     1us   185us     1us
# Rows sent      0   2.01k       0       1    0.33    0.99    0.47       0
# Rows examine  22   8.35M   1.25k   1.53k   1.39k   1.46k   78.19   1.39k
# Query size     2 840.86k     129     214  140.23  158.58   11.15  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='pipe.u.isucon.dev' and domain_id=2\G

# Query 2: 2.11k QPS, 0.65x concurrency, ID 0xDA556F9115773A1A99AA0165670CE848 at byte 12675656
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T06:26:25 to 2023-11-25T06:27:43
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         30  164361
# Exec time     15     50s    23us   332ms   307us     1ms     1ms    84us
# Lock time      0     3us       0     3us       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   4.70M      30      30      30      30       0      30
# String:
# Databases    isupipe (162650/98%), isudns (1711/1%)
# Hosts        localhost
# Users        isucon (162650/98%), isudns (1711/1%)
# Query_time distribution
#   1us
#  10us  ################################################################
# 100us  ##########################################
#   1ms  ########
#  10ms  #
# 100ms  #
#    1s
#  10s+
administrator command: Prepare\G

# Query 3: 61.96 QPS, 0.44x concurrency, ID 0x3D83BC87F3B3A00D571FFC8104A6E50C at byte 130495564
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T06:26:25 to 2023-11-25T06:27:43
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0    4833
# Exec time     10     34s   676us    64ms     7ms    21ms     7ms     4ms
# Lock time      4    31ms       0     9ms     6us     1us   168us     1us
# Rows sent      0   2.48k       0       1    0.53    0.99    0.50    0.99
# Rows examine  17   6.57M   1.25k   1.53k   1.39k   1.46k   78.61   1.39k
# Query size     1 630.90k     126     213  133.67  151.03   10.29  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='oly3sz8xci5t905xun0.u.isucon.dev'\G

# Query 4: 8.76 QPS, 0.43x concurrency, ID 0x64CC8A4E8E4B390203375597CE4D611F at byte 50382094
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T06:26:36 to 2023-11-25T06:27:43
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0     587
# Exec time      8     29s     4ms   128ms    49ms    87ms    22ms    46ms
# Lock time      0     2ms       0     1ms     3us     1us    44us     1us
# Rows sent      0     145       0       3    0.25    0.99    0.55       0
# Rows examine  21   8.03M  14.00k  14.02k  14.01k  13.78k       0  13.78k
# Query size     0  56.75k      97      99   98.99   97.36    0.27   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 'ng_words'\G
#    SHOW CREATE TABLE `isupipe`.`ng_words`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT id, user_id, livestream_id, word FROM ng_words WHERE user_id = 1028 AND livestream_id = 7536\G

# Query 5: 12.57 QPS, 0.28x concurrency, ID 0x59F1B6DD8D9FEC059E55B3BFD624E8C3 at byte 70943949
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T06:26:36 to 2023-11-25T06:27:43
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0     842
# Exec time      5     19s     2ms    82ms    22ms    51ms    15ms    20ms
# Lock time      1     9ms       0     6ms    10us     1us   207us     1us
# Rows sent      0     842       1       1       1       1       0       1
# Rows examine  19   7.03M   8.55k   8.55k   8.55k   8.55k       0   8.55k
# Query size     0  70.71k      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 = 1701176400 AND end_at = 1701180000\G