search

niftyisucon / isucon13

0 stars 0 forks source link

Benchmark result on isu3(11,709) #30

Open github-actions[bot] opened 11 months ago

github-actions[bot] commented 11 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)
12839 0 12835 0 4 0 GET /api/user/[a-zA-Z0-9]+/icon 0.004 0.452 326.988 0.025 0.068 0.104 0.192 0.039 0.000 171652.000 741751689.000 57773.323
1292 0 1288 0 4 0 GET /api/livestream/[a-zA-Z0-9]+/livecomment 0.004 0.904 279.296 0.216 0.456 0.548 0.704 0.166 0.000 80311.000 25630656.000 19837.969
1355 0 1350 0 5 0 GET /api/livestream/[a-zA-Z0-9]+/reaction 0.004 0.832 269.108 0.199 0.448 0.536 0.680 0.167 0.000 77436.000 23409095.000 17276.085
46 0 42 0 4 0 POST /api/livestream/[a-zA-Z0-9]+/moderate 0.288 15.012 252.972 5.499 9.988 13.704 15.012 3.226 0.000 23.000 966.000 21.000
1349 0 1335 0 14 0 POST /api/livestream/[a-zA-Z0-9]+/livecomment 0.004 0.504 117.100 0.087 0.156 0.192 0.276 0.057 0.000 2695.000 2640184.000 1957.142
574 0 569 0 3 2 POST /api/register 0.004 0.728 114.560 0.200 0.280 0.316 0.428 0.078 0.000 516.000 266844.000 464.885
151 0 150 0 1 0 GET /api/livestream/[a-zA-Z0-9]+$ 0.040 1.768 88.876 0.589 1.324 1.568 1.724 0.401 0.000 129113.000 10470644.000 69342.013
211 0 203 0 8 0 POST /api/livestream/[a-zA-Z0-9]+$ 0.176 1.004 87.672 0.416 0.772 0.832 0.936 0.292 0.000 1475.000 230092.000 1090.483
1187 0 1186 0 1 0 POST /api/livestream/[a-zA-Z0-9]+/reaction 0.004 0.544 67.112 0.057 0.112 0.156 0.228 0.047 1552.000 2215.000 2200093.000 1853.490
2 0 2 0 0 0 POST /api/initialize 10.832 10.888 21.720 10.860 10.888 10.888 10.888 0.028 27.000 27.000 54.000 27.000
585 0 581 0 4 0 POST /api/login 0.004 0.344 18.208 0.031 0.080 0.104 0.208 0.042 0.000 64.000 256.000 0.438
199 0 198 0 1 0 GET /api/livestream$ 0.004 0.504 16.660 0.084 0.156 0.184 0.272 0.059 3.000 22520.000 269079.000 1352.156
183 0 183 0 0 0 GET /api/tag 0.004 0.404 7.824 0.043 0.108 0.152 0.392 0.058 17.000 6095.000 1109007.000 6060.148
26 0 26 0 0 0 GET /api/user/[a-zA-Z0-9]+/statistics 0.024 0.512 7.300 0.281 0.412 0.440 0.512 0.133 133.000 155.000 3613.000 138.962
131 0 131 0 0 0 POST /api/livestream/[a-zA-Z0-9]+/enter 0.004 0.336 6.256 0.048 0.116 0.144 0.256 0.051 0.000 0.000 0.000 0.000
124 0 121 0 0 3 GET /api/livestream/[a-zA-Z0-9]+/report 0.004 0.348 5.552 0.045 0.120 0.136 0.256 0.055 3.000 26949.000 159717.000 1288.040
82 0 82 0 0 0 GET /api/livestream/[a-zA-Z0-9]+/ngwords 0.004 0.228 5.016 0.061 0.112 0.132 0.228 0.046 5.000 265.000 1741.000 21.232
28 0 18 0 10 0 GET /api/livestream/[a-zA-Z0-9]+/statistics 0.016 0.652 4.132 0.148 0.356 0.396 0.652 0.168 76.000 104.000 2598.000 92.786
110 0 109 0 1 0 DELETE /api/livestream/[a-zA-Z0-9]+/exit 0.004 0.224 3.988 0.036 0.076 0.116 0.216 0.038 0.000 0.000 0.000 0.000
22 0 22 0 0 0 GET /api/user/[a-zA-Z0-9]+/livestream 0.044 0.200 2.536 0.115 0.168 0.176 0.200 0.035 1222.000 2622.000 36944.000 1679.273
570 0 570 0 0 0 POST /api/icon 0.000 0.016 1.572 0.003 0.004 0.008 0.012 0.003 14.000 14.000 7980.000 14.000
24 0 24 0 0 0 GET /api/user/[a-zA-Z0-9]+/theme 0.004 0.124 0.712 0.030 0.076 0.096 0.124 0.032 38.000 38.000 912.000 38.000
10 0 10 0 0 0 GET /api/user/[a-zA-Z0-9]+$ 0.000 0.060 0.076 0.008 0.004 0.060 0.060 0.018 235.000 247.000 2422.000 242.200
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
2 0 0 0 2 0 GET /.env 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 197.000 666.000 863.000 431.500
1 0 0 0 1 0 GET /fapi/v1/order 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] commented 11 months ago 
Reading from STDIN ...

# 67.5s user time, 240ms system time, 38.26M rss, 44.89M vsz
# Current date: Sat Nov 25 06:41:57 2023
# Hostname: ip-192-168-0-13
# Files: STDIN
# Overall: 1.12M total, 89 unique, 1.40k QPS, 0.76x concurrency __________
# Time range: 2023-11-25T06:26:25 to 2023-11-25T06:39:44
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time           604s     1us   397ms   540us     2ms     3ms    63us
# Lock time             1s       0    30ms     1us     1us    78us       0
# Rows sent        788.38k       0   7.42k    0.72    4.96   32.00       0
# Rows examine      66.14M       0  18.01k   62.11    4.96  570.40       0
# Query size        69.74M       5   1.94M   65.49  313.99   2.76k   31.70

# Profile
# Rank Query ID                           Response time  Calls  R/Call V/M
# ==== ================================== ============== ====== ====== ===
#    1 0x42EF7D7D98FBCC9723BF896EBFC51D24 101.6486 16.8%  12328 0.0082  0.01 SELECT records
#    2 0xDA556F9115773A1A99AA0165670CE848  98.0057 16.2% 338989 0.0003  0.00 ADMIN PREPARE
#    3 0x3D83BC87F3B3A00D571FFC8104A6E50C  67.3734 11.2%   9719 0.0069  0.01 SELECT records
#    4 0x59F1B6DD8D9FEC059E55B3BFD624E8C3  38.4474  6.4%   1760 0.0218  0.01 SELECT reservation_slots
#    5 0x38BC86A45F31C6B1EE324671506C898A  33.3258  5.5%  64779 0.0005  0.00 SELECT themes
#    6 0x64CC8A4E8E4B390203375597CE4D611F  28.8662  4.8%   1245 0.0232  0.03 SELECT ng_words
#    7 0xFFFCA4D67EA0A788813031B8BBC3B329  28.7425  4.8%   8178 0.0035  0.00 COMMIT
#    8 0x4ADE2DC90689F1C4891749AF54FB8D14  27.1011  4.5%  74974 0.0004  0.00 DELETE SELECT livecomments
#    9 0xEA1E6309EEEFF9A6831AD2FB940FC23C  19.0116  3.1%  64186 0.0003  0.00 SELECT users
#   10 0xF7144185D9A142A426A36DC55C1D2623  14.6577  2.4%  37031 0.0004  0.00 SELECT livestream_tags
#   11 0x22279D81D51006139E0C76405B54C261  13.1910  2.2%  13974 0.0009  0.00 SELECT domains domainmetadata
#   12 0x55C45664C0A27CA4AF92DD1D2D0ABDAA  12.6494  2.1%  35834 0.0004  0.00 SELECT tags
#   13 0x9EAD6C0CE525E3693EE27FFC9AAF05A3  11.6596  1.9%    246 0.0474  0.01 SELECT livestreams
#   14 0x8F7679D452333ED3C7D60D22131CEFD4  11.3580  1.9%  38445 0.0003  0.00 ADMIN RESET STMT
#   15 0x859BBB7E9D760686137A944406874C4D  11.2449  1.9%    570 0.0197  0.01 DELETE records
#   16 0xD6032FE08E1FE706A928B8B7CBA06B85   9.6100  1.6%  32748 0.0003  0.00 SELECT livestreams
#   17 0xA3401CA3ABCC04C3AB221DB8AD5CBF26   8.8591  1.5%    204 0.0434  0.02 UPDATE reservation_slots
#   18 0xD2A0864774622BA36F6557496405CF75   8.6021  1.4%   2570 0.0033  0.00 INSERT themes
#   19 0xDFFCC1D78939C4D781C7C58349101F50   8.4737  1.4%   2000 0.0042  0.00 INSERT users
#   20 0x7F9C0C0BA9473953B723EE16C08655F1   7.8218  1.3%    207 0.0378  0.02 SELECT reservation_slots
#   21 0x9AC623FA477E73A44D191D296850A025   7.1559  1.2%   1140 0.0063  0.01 SELECT records
#   22 0x3F155F5E71EFF856F0CF7B8430DE8C23   5.3711  0.9%  13471 0.0004  0.00 SELECT users
#   23 0xB78E63D0D9C72DDDAB7A3E53517FA04C   3.6916  0.6%   1162 0.0032  0.00 SELECT livecomments
#   24 0x07890000813C4CC7111FD2D3F3B3B4EB   3.5205  0.6% 338961 0.0000  0.00 ADMIN CLOSE STMT
#   25 0xAD0C28443E1E5CFAFF1569DBB4F7E63A   3.3257  0.6%   1227 0.0027  0.00 SELECT reactions
#   26 0x611999F76068C4DC4F90E0A389918E63   2.8957  0.5%     26 0.1114  0.03 SELECT users livestreams reactions livestreams livecomments
#   27 0xE4555A2709C09FD9BFF6688D80B0AA49   2.2115  0.4%     18 0.1229  0.04 SELECT livestreams reactions livecomments
#   28 0xEDE18C1523658A19E07525EAFCBA6BFE   1.9025  0.3%     82 0.0232  0.04 SELECT ng_words
#   29 0xB08B7B7486D2DFE2F2FE9CE78689FD79   1.2185  0.2%     46 0.0265  0.04 SELECT ng_words
#   30 0x9E2DA589A20EC24C34E11DDE0FBF5564   1.0733  0.2%   7684 0.0001  0.00 START
#   31 0x77FB9E134D073862D1E78FEEC3436291   0.8027  0.1%   3130 0.0003  0.00 INSERT records
#   32 0x98F959E03B684A5538FD8402A0EE94AD   0.7829  0.1%    206 0.0038  0.00 INSERT tags
#   33 0x02B6A87E51A5A1B7646675DB67C57DE3   0.7774  0.1%      2 0.3887  0.00 INSERT ng_words
#   34 0xF3A502CCF34F7DA288CC1B75AD5AFA37   0.6635  0.1%   1241 0.0005  0.00 INSERT livecomments
#   35 0xF985E5835B84E84C7A721801818E98CE   0.6213  0.1%     26 0.0239  0.01 SELECT users livestreams reactions
#   36 0x651E3772B8767A368CB47EE7389EEB33   0.6206  0.1%     40 0.0155  0.02 SELECT livestream_tags
#   37 0x80E10371CE74ED05E09C79C72C73F8E1   0.6147  0.1%    205 0.0030  0.20 INSERT livestreams
#   38 0x0C1FCBB4E25B178AA3A46D4FECBA9BDC   0.5747  0.1%     44 0.0131  0.00 INSERT livestream_tags
#   39 0x49F80FBE1AC70F23A3DD076174FF1AA9   0.5542  0.1%     26 0.0213  0.02 SELECT users livestreams reactions
#   40 0x5AEB6E4A781A3854CF642125E293FEE0   0.4407  0.1%   1187 0.0004  0.00 INSERT reactions
#   41 0xE64D50F7AFC1AD5F465809A92DF4935E   0.3602  0.1%    127 0.0028  0.00 SELECT reactions
#   42 0xB9AC05A7AE6C4E30B5B45F6F3CE05BE0   0.3320  0.1%   1144 0.0003  0.00 SET
#   43 0x41F805E95754958A974F41AE07BEA625   0.3319  0.1%     59 0.0056  0.00 SELECT livecomments
#   44 0x64052B1C32B30DF53AB3292208B783B4   0.3306  0.1%    572 0.0006  0.00 INSERT users
#   45 0x5D469B53C536D19CD15E40763ACC23C7   0.3284  0.1%    859 0.0004  0.00 INSERT livestream_tags
#   46 0xEE4C51AE2BF74414C4892CBE11E894AA   0.3023  0.1%    129 0.0023  0.00 SELECT livecomments
#   47 0xDF0AAE38E2AAFC85E6F50569CEF2285D   0.2606  0.0%      2 0.1303  0.00 INSERT reservation_slots
#   48 0x2B760561C10B5D133155AA306D0F407C   0.1896  0.0%     65 0.0029  0.01 SELECT livecomments
#   49 0xE623383C5D789800DC0946925F90039F   0.1561  0.0%    572 0.0003  0.00 SELECT domains
#   50 0x4B6FA79E206C6CED71D433A2FC998D69   0.1012  0.0%    287 0.0004  0.00 SELECT
#   51 0x544239977D2094F805A7B062DE95673A   0.0961  0.0%    183 0.0005  0.00 SELECT tags
#   52 0x1FB70DBF74628C9F2E9F0C3478771936   0.0937  0.0%      2 0.0469  0.01 TRUNCATE TABLE ng_words
#   53 0xBB7F4DC4E67BF30E0588D296FFAF009F   0.0788  0.0%      2 0.0394  0.00 TRUNCATE TABLE tags
#   54 0x08A6ACD83D579DD8A808134B32AD376B   0.0764  0.0%      2 0.0382  0.00 TRUNCATE TABLE livestream_tags
#   55 0xD2978B45C67B47B5D73AC532EB40A95E   0.0727  0.0%      2 0.0364  0.00 TRUNCATE TABLE themes
#   56 0xDBB1C17D6ABA0156D8ABCE105DDDA1B2   0.0705  0.0%      2 0.0353  0.00 TRUNCATE TABLE users
#   57 0xFB296F703ACC41C3F94A9B7D75044F3C   0.0680  0.0%      2 0.0340  0.00 TRUNCATE TABLE reactions
#   58 0x8D589AFA4DFAEEED85FFF5AA78E5FF6A   0.0679  0.0%    572 0.0001  0.00 BEGIN
#   59 0x2AAED5867123C749367FD8E4BBD796D2   0.0632  0.0%      2 0.0316  0.00 TRUNCATE TABLE livecomments
#   60 0x24C44C3518CE12293EF12410AEDA2393   0.0622  0.0%    109 0.0006  0.00 SELECT livestreams
#   61 0x81E419F4B58AEB9B280B03DE44DD8B94   0.0622  0.0%    259 0.0002  0.00 SELECT livecomments
#   62 0x07F6C3FF39ADD79FC63923A7EE938953   0.0621  0.0%      2 0.0311  0.00 INSERT livecomments
#   63 0xAFFDC331C1D4BA089978A0B8DD00BFC8   0.0613  0.0%      2 0.0307  0.00 TRUNCATE TABLE livestreams
#   64 0x93A42F50BF286ACA749DF5F342FAC07B   0.0608  0.0%      2 0.0304  0.00 TRUNCATE TABLE livecomment_reports
#   65 0x253CA101A906B3D56A95D1B8DCEE28EF   0.0597  0.0%      2 0.0298  0.00 TRUNCATE TABLE icons
#   66 0x9C697B3F0446BBF7602663588252F020   0.0554  0.0%      2 0.0277  0.00 TRUNCATE TABLE livestream_viewers_history
#   67 0xA7C2E59AEF14D03CB65B227F3E3BA469   0.0519  0.0%      2 0.0260  0.00 TRUNCATE TABLE reservation_slots
#   68 0xA0D956F292B7FEA0DCE68A5DD5F529E1   0.0483  0.0%    109 0.0004  0.00 DELETE livestream_viewers_history
#   69 0x466EE4C87B17CAD4E692DE1D44EAD84D   0.0474  0.0%    124 0.0004  0.00 SELECT livecomment_reports
#   70 0xBF3194A2446AC20FC99B6CC7FA476A57   0.0473  0.0%    131 0.0004  0.00 INSERT livestream_viewers_history
#   71 0xFFF66E9B3D962FA319C8068B5C1997CD   0.0468  0.0%     60 0.0008  0.01 ROLLBACK
#   72 0x8F885091E23CB955C051B1204EE7D91D   0.0447  0.0%     18 0.0025  0.00 SELECT livestreams reactions
#   73 0x74232BDFFB94C567F0340DBE3285E458   0.0405  0.0%      2 0.0203  0.00 INSERT reactions
#   74 0x827F41D30F8E37F04D8BDCD46C556FB3   0.0308  0.0%     95 0.0003  0.00 INSERT livecomment_reports
#   75 0xDFEFE5BA5D8654534DC8550C6E3DC9C0   0.0254  0.0%      2 0.0127  0.00 DELETE records
#   76 0x2C17BCA1E1077820CDC2EC6106F4D93E   0.0221  0.0%     65 0.0003  0.00 SELECT livestream_viewers_history
#   77 0xEBE4AF9F935DE1D48BB5BB3558C7FCC4   0.0196  0.0%     18 0.0011  0.00 SELECT livestreams livecomments
#   78 0x0C655718656DD9DDA39A0D11554A0C64   0.0196  0.0%     46 0.0004  0.00 INSERT ng_words
#   79 0xB871CC5B0472067402F5739D108B2C1C   0.0086  0.0%     46 0.0002  0.00 SELECT livestreams
#   80 0x394E66DDE2823A903078D4C0F235B948   0.0071  0.0%     18 0.0004  0.00 SELECT livestreams livecomment_reports
#   81 0x8B2044ADAE690405979131C33185F22A   0.0062  0.0%     24 0.0003  0.00 SELECT users
#   82 0xF085F31DC1964EA538732B713E4B4108   0.0054  0.0%     18 0.0003  0.00 SELECT livestreams livestream_viewers_history
#   83 0x20CD15DC47AF2F861B8F3C25D195ABE9   0.0053  0.0%     40 0.0001  0.00 SELECT tags
#   84 0xEDBC971AEC392917AA353644DE4C4CB4   0.0018  0.0%    886 0.0000  0.00 ADMIN QUIT
#   85 0x0E7680C04FF2596BE3A3649C5FAC418D   0.0015  0.0%     19 0.0001  0.00 SELECT
#   86 0x751417D45B8E80EE5CBA2034458B5BC9   0.0013  0.0%      1 0.0013  0.00 SHOW DATABASES
#   87 0x489B4CEB2F4301A7132628303F99240D   0.0010  0.0%      1 0.0010  0.00 SHOW TABLES
#   88 0xC4625761E0CFD817F41B4802F152A489   0.0008  0.0%      2 0.0004  0.00 SELECT livecomments
#   89 0xE84E602C0D0858D5661956B70D72A215   0.0004  0.0%      2 0.0002  0.00 SELECT icons

# Query 1: 15.43 QPS, 0.13x 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:39:44
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          1   12328
# Exec time     16    102s   717us    67ms     8ms    22ms     7ms     6ms
# Lock time      5    70ms       0    12ms     5us     1us   139us     1us
# Rows sent      0   4.06k       0       1    0.34    0.99    0.47       0
# Rows examine  25  16.76M   1.25k   1.53k   1.39k   1.46k   78.84   1.39k
# Query size     2   1.65M     129     217  140.13  158.58   11.07  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: 424.27 QPS, 0.12x concurrency, ID 0xDA556F9115773A1A99AA0165670CE848 at byte 12675656
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T06:26:25 to 2023-11-25T06:39:44
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         30  338989
# Exec time     16     98s    21us   332ms   289us     1ms     1ms    80us
# 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   9.70M      30      30      30      30       0      30
# String:
# Databases    isupipe (335552/98%), isudns (3437/1%)
# Hosts        localhost
# Users        isucon (335552/98%), isudns (3437/1%)
# Query_time distribution
#   1us
#  10us  ################################################################
# 100us  #######################################
#   1ms  #######
#  10ms  #
# 100ms  #
#    1s
#  10s+
administrator command: Prepare\G

# Query 3: 12.16 QPS, 0.08x 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:39:44
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0    9719
# Exec time     11     67s   676us    64ms     7ms    21ms     7ms     4ms
# Lock time      4    62ms       0     9ms     6us     1us   148us     1us
# Rows sent      0   4.99k       0       1    0.53    0.99    0.50    0.99
# Rows examine  19  13.21M   1.25k   1.53k   1.39k   1.46k   79.21   1.39k
# Query size     1   1.24M     126     216  133.60  151.03   10.23  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: 2.23 QPS, 0.05x 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:39:44
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0    1760
# Exec time      6     38s     2ms    82ms    22ms    48ms    14ms    19ms
# Lock time      1    16ms       0     6ms     8us     1us   188us     1us
# Rows sent      0   1.72k       1       1       1       1       0       1
# Rows examine  22  14.70M   8.55k   8.55k   8.55k   8.55k       0   8.55k
# Query size     0 147.81k      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

# Query 5: 81.18 QPS, 0.04x concurrency, ID 0x38BC86A45F31C6B1EE324671506C898A at byte 129300229
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T06:26:26 to 2023-11-25T06:39:44
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          5   64779
# Exec time      5     33s    55us    29ms   514us     2ms   905us   113us
# Lock time      8   118ms       0     3ms     1us     1us    25us     1us
# Rows sent      8  63.26k       1       1       1       1       0       1
# Rows examine   0  63.26k       1       1       1       1       0       1
# Query size     3   2.53M      38      41   40.91   40.45    0.53   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 = 1013\G