search

niftyisucon / isucon13

0 stars 0 forks source link

Benchmark result on isu2(9972) #32

Open github-actions[bot] opened 10 months ago

github-actions[bot] commented 10 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)
5756 0 5753 0 3 0 GET /api/user/[a-zA-Z0-9]+/icon 0.012 0.416 176.896 0.031 0.084 0.124 0.216 0.044 0.000 98957.000 345647944.000 60050.025
603 0 602 0 1 0 GET /api/livestream/[a-zA-Z0-9]+/livecomment 0.004 1.052 150.008 0.249 0.508 0.632 0.828 0.189 0.000 74288.000 11578051.000 19200.748
636 0 631 0 5 0 GET /api/livestream/[a-zA-Z0-9]+/reaction 0.004 0.904 137.024 0.215 0.512 0.596 0.736 0.187 0.000 69547.000 10408309.000 16365.266
23 0 21 0 2 0 POST /api/livestream/[a-zA-Z0-9]+/moderate 0.288 16.484 129.920 5.649 10.032 10.892 16.484 3.237 0.000 23.000 483.000 21.000
458 0 454 0 3 1 POST /api/register 0.004 0.588 74.720 0.163 0.256 0.296 0.372 0.067 0.000 522.000 213327.000 465.779
125 0 121 0 4 0 POST /api/livestream/[a-zA-Z0-9]+$ 0.188 0.920 49.904 0.399 0.724 0.824 0.900 0.259 0.000 1499.000 138171.000 1105.368
655 0 648 0 7 0 POST /api/livestream/[a-zA-Z0-9]+/livecomment 0.004 0.424 45.748 0.070 0.140 0.184 0.296 0.056 0.000 2650.000 1282650.000 1958.244
64 0 64 0 0 0 GET /api/livestream/[a-zA-Z0-9]+$ 0.040 2.008 44.944 0.702 1.748 1.852 2.008 0.491 1499.000 131376.000 4688404.000 73256.312
559 0 559 0 0 0 POST /api/livestream/[a-zA-Z0-9]+/reaction 0.004 0.444 36.204 0.065 0.124 0.164 0.228 0.048 1552.000 2242.000 1037979.000 1856.850
462 0 460 0 2 0 POST /api/login 0.004 0.468 14.740 0.032 0.072 0.104 0.260 0.047 0.000 64.000 128.000 0.277
1 0 1 0 0 0 POST /api/initialize 11.545 11.545 11.545 11.545 11.545 11.545 11.545 0.000 27.000 27.000 27.000 27.000
107 0 107 0 0 0 GET /api/livestream$ 0.012 0.472 9.868 0.092 0.184 0.240 0.400 0.078 3.000 22539.000 122646.000 1146.224
108 0 108 0 0 0 GET /api/tag 0.004 0.224 4.300 0.040 0.100 0.128 0.156 0.041 6089.000 6095.000 658104.000 6093.556
11 0 11 0 0 0 GET /api/user/[a-zA-Z0-9]+/statistics 0.024 0.464 3.144 0.286 0.428 0.464 0.464 0.143 133.000 146.000 1507.000 137.000
56 0 56 0 0 0 POST /api/livestream/[a-zA-Z0-9]+/enter 0.004 0.244 3.084 0.055 0.144 0.176 0.244 0.053 0.000 0.000 0.000 0.000
50 0 48 0 1 1 GET /api/livestream/[a-zA-Z0-9]+/report 0.004 0.368 2.500 0.050 0.112 0.152 0.368 0.073 0.000 24129.000 78500.000 1570.000
45 0 45 0 0 0 DELETE /api/livestream/[a-zA-Z0-9]+/exit 0.004 0.168 1.928 0.043 0.092 0.112 0.168 0.038 0.000 0.000 0.000 0.000
35 0 35 0 0 0 GET /api/livestream/[a-zA-Z0-9]+/ngwords 0.004 0.232 1.472 0.042 0.092 0.152 0.232 0.049 5.000 274.000 828.000 23.657
457 0 457 0 0 0 POST /api/icon 0.008 0.016 1.288 0.003 0.004 0.008 0.012 0.003 14.000 14.000 6398.000 14.000
9 0 9 0 0 0 GET /api/user/[a-zA-Z0-9]+/livestream 0.056 0.416 1.284 0.143 0.416 0.416 0.416 0.101 1249.000 2611.000 15436.000 1715.111
10 0 10 0 0 0 GET /api/user/[a-zA-Z0-9]+/theme 0.012 0.080 0.308 0.031 0.080 0.080 0.080 0.027 38.000 38.000 380.000 38.000
2 0 2 0 0 0 GET /api/livestream/[a-zA-Z0-9]+/statistics 0.016 0.016 0.032 0.016 0.016 0.016 0.016 0.000 100.000 102.000 202.000 101.000
4 0 4 0 0 0 GET /api/user/[a-zA-Z0-9]+$ 0.000 0.004 0.008 0.002 0.004 0.004 0.004 0.002 235.000 247.000 964.000 241.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] commented 10 months ago 
Reading from STDIN ...

# 36.5s user time, 150ms system time, 35.85M rss, 42.32M vsz
# Current date: Sat Nov 25 06:48:06 2023
# Hostname: ip-192-168-0-12
# Files: STDIN
# Overall: 606.48k total, 87 unique, 7.68k QPS, 2.78x concurrency ________
# Time range: 2023-11-25T06:44:45 to 2023-11-25T06:46:04
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time           219s     1us   414ms   361us     1ms     2ms    69us
# Lock time          871ms       0    27ms     1us     1us    81us       0
# Rows sent        322.44k       0   7.32k    0.54    1.96   16.94       0
# Rows examine      14.82M       0  16.60k   25.62    4.96  429.45       0
# Query size        39.64M       5   1.94M   68.54  299.03   2.65k   31.70

# Profile
# Rank Query ID                           Response time Calls  R/Call V/M 
# ==== ================================== ============= ====== ====== ====
#    1 0xDA556F9115773A1A99AA0165670CE848 43.5948 19.9% 156118 0.0003  0.00 ADMIN PREPARE
#    2 0xFFFCA4D67EA0A788813031B8BBC3B329 16.9509  7.7%   4442 0.0038  0.00 COMMIT
#    3 0x59F1B6DD8D9FEC059E55B3BFD624E8C3 16.8757  7.7%   1075 0.0157  0.01 SELECT reservation_slots
#    4 0x22279D81D51006139E0C76405B54C261 15.5028  7.1%  26242 0.0006  0.00 SELECT domains domainmetadata
#    5 0x38BC86A45F31C6B1EE324671506C898A 14.6783  6.7%  29373 0.0005  0.00 SELECT themes
#    6 0x42EF7D7D98FBCC9723BF896EBFC51D24 13.4848  6.1%  21409 0.0006  0.00 SELECT records
#    7 0x4ADE2DC90689F1C4891749AF54FB8D14 11.8183  5.4%  34433 0.0003  0.00 DELETE SELECT livecomments
#    8 0x8F7679D452333ED3C7D60D22131CEFD4 11.5292  5.3%  61621 0.0002  0.00 ADMIN RESET STMT
#    9 0x3D83BC87F3B3A00D571FFC8104A6E50C  9.7618  4.4%  15207 0.0006  0.00 SELECT records
#   10 0xEA1E6309EEEFF9A6831AD2FB940FC23C  8.9614  4.1%  28908 0.0003  0.00 SELECT users
#   11 0xF7144185D9A142A426A36DC55C1D2623  6.2532  2.8%  16651 0.0004  0.00 SELECT livestream_tags
#   12 0x55C45664C0A27CA4AF92DD1D2D0ABDAA  5.2786  2.4%  16222 0.0003  0.00 SELECT tags
#   13 0x859BBB7E9D760686137A944406874C4D  4.6998  2.1%    455 0.0103  0.01 DELETE records
#   14 0xD2A0864774622BA36F6557496405CF75  4.6730  2.1%   1455 0.0032  0.00 INSERT themes
#   15 0xDFFCC1D78939C4D781C7C58349101F50  4.5316  2.1%   1000 0.0045  0.00 INSERT users
#   16 0x9EAD6C0CE525E3693EE27FFC9AAF05A3  4.2934  2.0%    127 0.0338  0.02 SELECT livestreams
#   17 0xD6032FE08E1FE706A928B8B7CBA06B85  4.2753  1.9%  14864 0.0003  0.00 SELECT livestreams
#   18 0xA3401CA3ABCC04C3AB221DB8AD5CBF26  4.0753  1.9%    121 0.0337  0.02 UPDATE reservation_slots
#   19 0x7F9C0C0BA9473953B723EE16C08655F1  3.5116  1.6%    123 0.0285  0.01 SELECT reservation_slots
#   20 0x3F155F5E71EFF856F0CF7B8430DE8C23  2.4597  1.1%   6236 0.0004  0.00 SELECT users
#   21 0x07890000813C4CC7111FD2D3F3B3B4EB  1.7124  0.8% 156100 0.0000  0.00 ADMIN CLOSE STMT
#   22 0xB78E63D0D9C72DDDAB7A3E53517FA04C  1.5465  0.7%    548 0.0028  0.00 SELECT livecomments
#   23 0xAD0C28443E1E5CFAFF1569DBB4F7E63A  1.3365  0.6%    582 0.0023  0.00 SELECT reactions
#   24 0x611999F76068C4DC4F90E0A389918E63  1.0518  0.5%     11 0.0956  0.03 SELECT users livestreams reactions livestreams livecomments
#   25 0x9E2DA589A20EC24C34E11DDE0FBF5564  0.5421  0.2%   4019 0.0001  0.00 START
#   26 0x77FB9E134D073862D1E78FEEC3436291  0.5300  0.2%   1735 0.0003  0.00 INSERT records
#   27 0x9AC623FA477E73A44D191D296850A025  0.4635  0.2%    910 0.0005  0.00 SELECT records
#   28 0x98F959E03B684A5538FD8402A0EE94AD  0.4201  0.2%    103 0.0041  0.00 INSERT tags
#   29 0x02B6A87E51A5A1B7646675DB67C57DE3  0.4140  0.2%      1 0.4140  0.00 INSERT ng_words
#   30 0x64052B1C32B30DF53AB3292208B783B4  0.3497  0.2%    456 0.0008  0.02 INSERT users
#   31 0x0C1FCBB4E25B178AA3A46D4FECBA9BDC  0.3193  0.1%     22 0.0145  0.00 INSERT livestream_tags
#   32 0x80E10371CE74ED05E09C79C72C73F8E1  0.3084  0.1%    122 0.0025  0.21 INSERT livestreams
#   33 0x5D469B53C536D19CD15E40763ACC23C7  0.2500  0.1%    527 0.0005  0.00 INSERT livestream_tags
#   34 0xF3A502CCF34F7DA288CC1B75AD5AFA37  0.2320  0.1%    598 0.0004  0.00 INSERT livecomments
#   35 0xB9AC05A7AE6C4E30B5B45F6F3CE05BE0  0.2250  0.1%    912 0.0002  0.00 SET
#   36 0x49F80FBE1AC70F23A3DD076174FF1AA9  0.2248  0.1%     11 0.0204  0.01 SELECT users livestreams reactions
#   37 0x64CC8A4E8E4B390203375597CE4D611F  0.2124  0.1%    599 0.0004  0.00 SELECT ng_words
#   38 0x651E3772B8767A368CB47EE7389EEB33  0.1917  0.1%     18 0.0107  0.01 SELECT livestream_tags
#   39 0x5AEB6E4A781A3854CF642125E293FEE0  0.1701  0.1%    559 0.0003  0.00 INSERT reactions
#   40 0x41F805E95754958A974F41AE07BEA625  0.1459  0.1%     28 0.0052  0.00 SELECT livecomments
#   41 0xF985E5835B84E84C7A721801818E98CE  0.1398  0.1%     11 0.0127  0.01 SELECT users livestreams reactions
#   42 0xEE4C51AE2BF74414C4892CBE11E894AA  0.1377  0.1%     55 0.0025  0.00 SELECT livecomments
#   43 0xDF0AAE38E2AAFC85E6F50569CEF2285D  0.1295  0.1%      1 0.1295  0.00 INSERT reservation_slots
#   44 0xE64D50F7AFC1AD5F465809A92DF4935E  0.1288  0.1%     54 0.0024  0.00 SELECT reactions
#   45 0x2B760561C10B5D133155AA306D0F407C  0.1226  0.1%     30 0.0041  0.02 SELECT livecomments
#   46 0xE623383C5D789800DC0946925F90039F  0.1086  0.0%    456 0.0002  0.00 SELECT domains
#   47 0x08A6ACD83D579DD8A808134B32AD376B  0.0435  0.0%      1 0.0435  0.00 TRUNCATE TABLE livestream_tags
#   48 0x81E419F4B58AEB9B280B03DE44DD8B94  0.0418  0.0%    135 0.0003  0.00 SELECT livecomments
#   49 0x1FB70DBF74628C9F2E9F0C3478771936  0.0410  0.0%      1 0.0410  0.00 TRUNCATE TABLE ng_words
#   50 0x544239977D2094F805A7B062DE95673A  0.0401  0.0%    108 0.0004  0.00 SELECT tags
#   51 0x24C44C3518CE12293EF12410AEDA2393  0.0400  0.0%     45 0.0009  0.00 SELECT livestreams
#   52 0x8D589AFA4DFAEEED85FFF5AA78E5FF6A  0.0388  0.0%    456 0.0001  0.00 BEGIN
#   53 0xD2978B45C67B47B5D73AC532EB40A95E  0.0363  0.0%      1 0.0363  0.00 TRUNCATE TABLE themes
#   54 0xDBB1C17D6ABA0156D8ABCE105DDDA1B2  0.0362  0.0%      1 0.0362  0.00 TRUNCATE TABLE users
#   55 0xBB7F4DC4E67BF30E0588D296FFAF009F  0.0331  0.0%      1 0.0331  0.00 TRUNCATE TABLE tags
#   56 0x07F6C3FF39ADD79FC63923A7EE938953  0.0329  0.0%      1 0.0329  0.00 INSERT livecomments
#   57 0xA7C2E59AEF14D03CB65B227F3E3BA469  0.0328  0.0%      1 0.0328  0.00 TRUNCATE TABLE reservation_slots
#   58 0x253CA101A906B3D56A95D1B8DCEE28EF  0.0322  0.0%      1 0.0322  0.00 TRUNCATE TABLE icons
#   59 0x9C697B3F0446BBF7602663588252F020  0.0310  0.0%      1 0.0310  0.00 TRUNCATE TABLE livestream_viewers_history
#   60 0x93A42F50BF286ACA749DF5F342FAC07B  0.0299  0.0%      1 0.0299  0.00 TRUNCATE TABLE livecomment_reports
#   61 0x2AAED5867123C749367FD8E4BBD796D2  0.0297  0.0%      1 0.0297  0.00 TRUNCATE TABLE livecomments
#   62 0xAFFDC331C1D4BA089978A0B8DD00BFC8  0.0290  0.0%      1 0.0290  0.00 TRUNCATE TABLE livestreams
#   63 0xFB296F703ACC41C3F94A9B7D75044F3C  0.0285  0.0%      1 0.0285  0.00 TRUNCATE TABLE reactions
#   64 0x4B6FA79E206C6CED71D433A2FC998D69  0.0270  0.0%    108 0.0003  0.00 SELECT
#   65 0xDFEFE5BA5D8654534DC8550C6E3DC9C0  0.0237  0.0%      1 0.0237  0.00 DELETE records
#   66 0xA0D956F292B7FEA0DCE68A5DD5F529E1  0.0218  0.0%     45 0.0005  0.00 DELETE livestream_viewers_history
#   67 0xE4555A2709C09FD9BFF6688D80B0AA49  0.0211  0.0%      2 0.0106  0.00 SELECT livestreams reactions livecomments
#   68 0x74232BDFFB94C567F0340DBE3285E458  0.0210  0.0%      1 0.0210  0.00 INSERT reactions
#   69 0xFFF66E9B3D962FA319C8068B5C1997CD  0.0186  0.0%     24 0.0008  0.00 ROLLBACK
#   70 0xBF3194A2446AC20FC99B6CC7FA476A57  0.0181  0.0%     56 0.0003  0.00 INSERT livestream_viewers_history
#   71 0x466EE4C87B17CAD4E692DE1D44EAD84D  0.0170  0.0%     49 0.0003  0.00 SELECT livecomment_reports
#   72 0x2C17BCA1E1077820CDC2EC6106F4D93E  0.0139  0.0%     30 0.0005  0.00 SELECT livestream_viewers_history
#   73 0x0C655718656DD9DDA39A0D11554A0C64  0.0127  0.0%     23 0.0006  0.00 INSERT ng_words
#   74 0x827F41D30F8E37F04D8BDCD46C556FB3  0.0122  0.0%     50 0.0002  0.00 INSERT livecomment_reports
#   75 0xB08B7B7486D2DFE2F2FE9CE78689FD79  0.0093  0.0%     23 0.0004  0.00 SELECT ng_words
#   76 0xEDE18C1523658A19E07525EAFCBA6BFE  0.0062  0.0%     35 0.0002  0.00 SELECT ng_words
#   77 0xB871CC5B0472067402F5739D108B2C1C  0.0049  0.0%     23 0.0002  0.00 SELECT livestreams
#   78 0x20CD15DC47AF2F861B8F3C25D195ABE9  0.0019  0.0%     18 0.0001  0.00 SELECT tags
#   79 0xEDBC971AEC392917AA353644DE4C4CB4  0.0018  0.0%    655 0.0000  0.00 ADMIN QUIT
#   80 0x8B2044ADAE690405979131C33185F22A  0.0012  0.0%     10 0.0001  0.00 SELECT users
#   81 0x0E7680C04FF2596BE3A3649C5FAC418D  0.0006  0.0%      9 0.0001  0.00 SELECT
#   82 0xEBE4AF9F935DE1D48BB5BB3558C7FCC4  0.0006  0.0%      2 0.0003  0.00 SELECT livestreams livecomments
#   83 0x8F885091E23CB955C051B1204EE7D91D  0.0005  0.0%      2 0.0002  0.00 SELECT livestreams reactions
#   84 0xC4625761E0CFD817F41B4802F152A489  0.0004  0.0%      1 0.0004  0.00 SELECT livecomments
#   85 0xF085F31DC1964EA538732B713E4B4108  0.0002  0.0%      2 0.0001  0.00 SELECT livestreams livestream_viewers_history
#   86 0x394E66DDE2823A903078D4C0F235B948  0.0002  0.0%      2 0.0001  0.00 SELECT livestreams livecomment_reports
#   87 0xE84E602C0D0858D5661956B70D72A215  0.0002  0.0%      1 0.0002  0.00 SELECT icons

# Query 1: 1.98k QPS, 0.55x concurrency, ID 0xDA556F9115773A1A99AA0165670CE848 at byte 13363849
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T06:44:45 to 2023-11-25T06:46:04
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         25  156118
# Exec time     19     44s    20us   113ms   279us     1ms   751us    80us
# Lock time      0     5us       0     5us       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    11   4.47M      30      30      30      30       0      30
# String:
# Databases    isupipe (153375/98%), isudns (2743/1%)
# Hosts        localhost
# Users        isucon (153375/98%), isudns (2743/1%)
# Query_time distribution
#   1us
#  10us  ################################################################
# 100us  ######################################
#   1ms  ######
#  10ms  #
# 100ms  #
#    1s
#  10s+
administrator command: Prepare\G

# Query 2: 65.32 QPS, 0.25x concurrency, ID 0xFFFCA4D67EA0A788813031B8BBC3B329 at byte 143765677
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T06:44:56 to 2023-11-25T06:46:04
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0    4442
# Exec time      7     17s    21us    67ms     4ms    11ms     4ms     4ms
# 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  26.03k       6       6       6       6       0       6
# String:
# Databases    isupipe (3986/89%), isudns (456/10%)
# Hosts        localhost
# Users        isucon (3986/89%), isudns (456/10%)
# Query_time distribution
#   1us
#  10us  #####################################
# 100us  ##########
#   1ms  ################################################################
#  10ms  #########
# 100ms
#    1s
#  10s+
COMMIT\G

# Query 3: 15.81 QPS, 0.25x concurrency, ID 0x59F1B6DD8D9FEC059E55B3BFD624E8C3 at byte 16800343
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T06:44:56 to 2023-11-25T06:46:04
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0    1075
# Exec time      7     17s     2ms    87ms    16ms    38ms    11ms    12ms
# Lock time      0     1ms       0    81us     1us     1us     2us     1us
# Rows sent      0   1.05k       1       1       1       1       0       1
# Rows examine  60   8.98M   8.55k   8.55k   8.55k   8.55k       0   8.55k
# Query size     0  90.28k      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 = 1700938800 AND end_at = 1700942400\G

# Query 4: 332.18 QPS, 0.20x concurrency, ID 0x22279D81D51006139E0C76405B54C261 at byte 153091403
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T06:44:45 to 2023-11-25T06:46:04
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          4   26242
# Exec time      7     16s    80us    22ms   590us     2ms     1ms   194us
# Lock time     11   103ms       0     7ms     3us     1us    73us     1us
# Rows sent      0       0       0       0       0       0       0       0
# Rows examine   0       0       0       0       0       0       0       0
# Query size     7   2.85M     114     114     114     114       0     114
# 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 'domains'\G
#    SHOW CREATE TABLE `isudns`.`domains`\G
#    SHOW TABLE STATUS FROM `isudns` LIKE 'domainmetadata'\G
#    SHOW CREATE TABLE `isudns`.`domainmetadata`\G
# EXPLAIN /*!50100 PARTITIONS*/
select kind,content from domains, domainmetadata where domainmetadata.domain_id=domains.id and name='u.isucon.dev'\G

# Query 5: 431.96 QPS, 0.22x concurrency, ID 0x38BC86A45F31C6B1EE324671506C898A at byte 164920752
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T06:44:56 to 2023-11-25T06:46:04
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          4   29373
# Exec time      6     15s    54us    24ms   499us     2ms   896us   108us
# Lock time      6    59ms       0     2ms     2us     1us    31us     1us
# Rows sent      8  28.68k       1       1       1       1       0       1
# Rows examine   0  28.68k       1       1       1       1       0       1
# Query size     2   1.15M      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 = 1194\G