Skip to content

Instantly share code, notes, and snippets.

@tatsuru

tatsuru/gist:c74b61a4d3e25e01727b784424765008 Secret

Created September 12, 2020 05:58
Show Gist options
  • Save tatsuru/c74b61a4d3e25e01727b784424765008 to your computer and use it in GitHub Desktop.
Save tatsuru/c74b61a4d3e25e01727b784424765008 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
Reading from STDIN ...
# 7.5s user time, 70ms system time, 36.43M rss, 4.14G vsz
# Current date: Sat Sep 12 14:58:05 2020
# Hostname: hagyou.local
# Files: STDIN
# Overall: 74.12k total, 91 unique, 25.94 QPS, 0.15x concurrency _________
# Time range: 2020-09-12T05:05:15 to 2020-09-12T05:52:52
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 442s 1us 469ms 6ms 61ms 22ms 119us
# Lock time 2s 0 27ms 28us 18us 377us 0
# Rows sent 97.56k 0 1.23k 1.35 0.99 11.87 0
# Rows examine 139.35M 0 30.53k 1.93k 28.66k 7.10k 0
# Query size 33.35M 6 241.06k 471.81 313.99 8.88k 31.70
# Profile
# Rank Query ID Response time Calls R/Call V/M Ite
# ==== ============================= ============== ===== ====== ===== ===
# 1 0x1592B6A6C5962A79A3BBB20F... 37.0811 8.4% 389 0.0953 0.01 SELECT chair
# 2 0xF8D9C0871992B1AF9C572B62... 30.4686 6.9% 389 0.0783 0.00 SELECT estate
# 3 0x3D7F9AD8D0B5ECFA387A1968... 30.3563 6.9% 263 0.1154 0.01 SELECT estate
# 4 0x07E5ED76C7A93E48E37BD5D8... 28.3383 6.4% 324 0.0875 0.01 SELECT estate
# 5 0x7239C60E5785569730222108... 23.1296 5.2% 324 0.0714 0.01 SELECT estate
# 6 0x7274240B816F1937BB555617... 14.0860 3.2% 16782 0.0008 0.00 SELECT estate
# 7 0x747A5415F890FCD0F418F895... 12.7361 2.9% 147 0.0866 0.01 SELECT estate
# 8 0xDAF418A1CBFF50D9A9A4F380... 12.2790 2.8% 132 0.0930 0.01 SELECT chair
# 9 0x644E34B4F9AC414D98107693... 12.0702 2.7% 153 0.0789 0.00 SELECT estate
# 10 0x5DE2A94FD483D5087F578E61... 11.3969 2.6% 150 0.0760 0.00 SELECT estate
# 11 0xDA556F9115773A1A99AA0165... 10.8139 2.4% 24452 0.0004 0.00 ADMIN PREPARE
# 12 0x929E86BFE887C4E10B23D92E... 10.4639 2.4% 147 0.0712 0.01 SELECT estate
# 13 0x3D16910D1C54800461F4988B... 10.0768 2.3% 101 0.0998 0.01 SELECT chair
# 14 0x4E8EAE12D58B73C2F3EFAD49... 10.0242 2.3% 132 0.0759 0.01 SELECT chair
# 15 0x4CD8BC51141C351DC73BFA73... 9.8160 2.2% 153 0.0642 0.00 SELECT estate
# 16 0x55402B93A43729A085DF0F23... 9.7917 2.2% 79 0.1239 0.01 SELECT estate
# 17 0xBF1444BD9A8EAD17F291508A... 9.4988 2.2% 150 0.0633 0.00 SELECT estate
# 18 0x335F7FF70A5B1F5BBC792221... 8.3535 1.9% 101 0.0827 0.01 SELECT chair
# 19 0x4A8E12431038633B5ADF2C46... 8.1267 1.8% 78 0.1042 0.01 SELECT chair
# 20 0xE5EB3FC758DE6E117FEEE42B... 8.0480 1.8% 87 0.0925 0.01 SELECT chair
# MISC 0xMISC 134.5802 30.5% 29589 0.0045 0.0 <71 ITEMS>
# Query 1: 0.14 QPS, 0.01x concurrency, ID 0x1592B6A6C5962A79A3BBB20FFD7BCE7C at byte 27408726
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2020-09-12T05:05:15 to 2020-09-12T05:52:52
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 389
# Exec time 8 37s 47ms 174ms 95ms 134ms 23ms 91ms
# Lock time 1 29ms 10us 4ms 74us 35us 381us 13us
# Rows sent 7 7.60k 20 20 20 20 0 20
# Rows examine 7 11.14M 28.83k 29.32k 29.32k 28.66k 0 28.66k
# Query size 0 26.97k 71 71 71 71 0 71
# String:
# Databases isuumo
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms ################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isuumo` LIKE 'chair'\G
# SHOW CREATE TABLE `isuumo`.`chair`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM chair WHERE stock > 0 ORDER BY price ASC, id ASC LIMIT 20\G
# Query 2: 0.14 QPS, 0.01x concurrency, ID 0xF8D9C0871992B1AF9C572B62B2210476 at byte 27415080
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2020-09-12T05:05:15 to 2020-09-12T05:52:52
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 389
# Exec time 6 30s 40ms 156ms 78ms 110ms 20ms 75ms
# Lock time 0 14ms 8us 3ms 35us 31us 177us 12us
# Rows sent 7 7.60k 20 20 20 20 0 20
# Rows examine 7 11.14M 28.83k 29.32k 29.32k 28.66k 0 28.66k
# Query size 0 20.89k 55 55 55 55 0 55
# String:
# Databases isuumo
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms ###############
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isuumo` LIKE 'estate'\G
# SHOW CREATE TABLE `isuumo`.`estate`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM estate ORDER BY rent ASC, id ASC LIMIT 20\G
# Query 3: 4.38 QPS, 0.51x concurrency, ID 0x3D7F9AD8D0B5ECFA387A1968AED87BF9 at byte 27710964
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2020-09-12T05:51:51 to 2020-09-12T05:52:51
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 263
# Exec time 6 30s 35ms 262ms 115ms 163ms 31ms 105ms
# Lock time 0 16ms 17us 4ms 59us 40us 347us 19us
# Rows sent 5 5.14k 20 20 20 20 0 20
# Rows examine 5 7.53M 28.83k 29.32k 29.31k 28.66k 0 28.66k
# Query size 0 86.31k 329 341 336.06 329.68 3.96 329.68
# String:
# Databases isuumo
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms #######################
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isuumo` LIKE 'estate'\G
# SHOW CREATE TABLE `isuumo`.`estate`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM estate WHERE (door_width >= 34 AND door_height >= 185) OR (door_width >= 34 AND door_height >= 61) OR (door_width >= 185 AND door_height >= 34) OR (door_width >= 185 AND door_height >= 61) OR (door_width >= 61 AND door_height >= 34) OR (door_width >= 61 AND door_height >= 185) ORDER BY popularity DESC, id ASC LIMIT 20\G
# Query 4: 5.49 QPS, 0.48x concurrency, ID 0x07E5ED76C7A93E48E37BD5D8F0FF2FDE at byte 37815609
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2020-09-12T05:51:53 to 2020-09-12T05:52:52
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 324
# Exec time 6 28s 43ms 174ms 87ms 128ms 22ms 78ms
# Lock time 0 10ms 11us 3ms 31us 33us 144us 15us
# Rows sent 8 7.91k 25 25 25 25 0 25
# Rows examine 6 9.29M 29.32k 29.42k 29.35k 28.66k 0 28.66k
# Query size 0 34.86k 109 112 110.16 107.34 0 107.34
# String:
# Databases isuumo
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms ############################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isuumo` LIKE 'estate'\G
# SHOW CREATE TABLE `isuumo`.`estate`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM estate WHERE rent >= 50000 AND rent < 100000 ORDER BY popularity DESC, id ASC LIMIT 25 OFFSET 100\G
# Query 5: 5.49 QPS, 0.39x concurrency, ID 0x7239C60E5785569730222108492FF4F7 at byte 46753159
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2020-09-12T05:51:53 to 2020-09-12T05:52:52
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 324
# Exec time 5 23s 36ms 137ms 71ms 105ms 19ms 65ms
# Lock time 0 6ms 8us 662us 17us 31us 37us 12us
# Rows sent 0 324 1 1 1 1 0 1
# Rows examine 6 9.27M 29.30k 29.30k 29.30k 29.30k 0 29.30k
# Query size 0 20.72k 65 66 65.49 65.89 0.50 62.76
# String:
# Databases isuumo
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms ########
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isuumo` LIKE 'estate'\G
# SHOW CREATE TABLE `isuumo`.`estate`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT COUNT(*) FROM estate WHERE rent >= 50000 AND rent < 100000\G
# Query 6: 275.11 QPS, 0.23x concurrency, ID 0x7274240B816F1937BB5556170BADF35E at byte 37435666
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2020-09-12T05:51:51 to 2020-09-12T05:52:52
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 22 16782
# Exec time 3 14s 49us 25ms 839us 4ms 2ms 287us
# Lock time 40 862ms 7us 17ms 51us 113us 337us 12us
# Rows sent 11 11.69k 0 1 0.71 0.99 0.45 0.99
# Rows examine 0 11.69k 0 1 0.71 0.99 0.45 0.99
# Query size 14 4.72M 238 366 294.65 313.99 23.75 299.03
# String:
# Databases isuumo
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us ###
# 100us ################################################################
# 1ms ##############
# 10ms #
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isuumo` LIKE 'estate'\G
# SHOW CREATE TABLE `isuumo`.`estate`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM estate WHERE id = 18503 AND ST_Contains(ST_PolygonFromText('POLYGON((34.534979 138.011855,34.595411 137.564329,35.096892 137.555049,35.109123 137.817730,35.085358 138.096735,34.965003 138.160313,34.686252 138.206096,34.534979 138.011855))'), ST_GeomFromText('POINT(34.813288 137.937439)'))\G
# Query 7: 2.67 QPS, 0.23x concurrency, ID 0x747A5415F890FCD0F418F8958C3A84C3 at byte 48278798
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2020-09-12T05:51:57 to 2020-09-12T05:52:52
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 147
# Exec time 2 13s 44ms 152ms 87ms 134ms 23ms 78ms
# Lock time 0 20ms 12us 14ms 133us 35us 1ms 15us
# Rows sent 3 3.59k 25 25 25 25 0 25
# Rows examine 3 4.21M 29.32k 29.42k 29.36k 28.66k 0 28.66k
# Query size 0 16.69k 115 118 116.26 112.70 0 112.70
# String:
# Databases isuumo
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms ############################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isuumo` LIKE 'estate'\G
# SHOW CREATE TABLE `isuumo`.`estate`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM estate WHERE door_width >= 80 AND door_width < 110 ORDER BY popularity DESC, id ASC LIMIT 25 OFFSET 0\G
# Query 8: 2.24 QPS, 0.21x concurrency, ID 0xDAF418A1CBFF50D9A9A4F380692DE1C8 at byte 37465546
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2020-09-12T05:51:53 to 2020-09-12T05:52:52
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 132
# Exec time 2 12s 57ms 171ms 93ms 134ms 23ms 87ms
# Lock time 0 4ms 12us 623us 26us 28us 62us 16us
# Rows sent 3 3.22k 25 25 25 25 0 25
# Rows examine 2 3.78M 29.32k 29.42k 29.35k 28.66k 0 28.66k
# Query size 0 15.78k 121 125 122.41 118.34 1.23 118.34
# String:
# Databases isuumo
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms #################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isuumo` LIKE 'chair'\G
# SHOW CREATE TABLE `isuumo`.`chair`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM chair WHERE price >= 3000 AND price < 6000 AND stock > 0 ORDER BY popularity DESC, id ASC LIMIT 25 OFFSET 0\G
# Query 9: 2.68 QPS, 0.21x concurrency, ID 0x644E34B4F9AC414D9810769325CA5A5E at byte 40907705
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2020-09-12T05:51:53 to 2020-09-12T05:52:50
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 153
# Exec time 2 12s 47ms 135ms 79ms 110ms 17ms 71ms
# Lock time 0 9ms 10us 4ms 56us 33us 310us 14us
# Rows sent 3 3.74k 25 25 25 25 0 25
# Rows examine 3 4.39M 29.32k 29.42k 29.35k 28.66k 0 28.66k
# Query size 0 13.85k 92 94 92.69 92.72 1 92.72
# String:
# Databases isuumo
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms #############
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isuumo` LIKE 'estate'\G
# SHOW CREATE TABLE `isuumo`.`estate`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM estate WHERE rent >= 150000 ORDER BY popularity DESC, id ASC LIMIT 25 OFFSET 75\G
# Query 10: 3 QPS, 0.23x concurrency, ID 0x5DE2A94FD483D5087F578E6167724DBF at byte 36890439
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2020-09-12T05:51:53 to 2020-09-12T05:52:43
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 150
# Exec time 2 11s 38ms 142ms 76ms 105ms 19ms 71ms
# Lock time 0 3ms 11us 39us 17us 30us 5us 14us
# Rows sent 3 3.66k 25 25 25 25 0 25
# Rows examine 3 4.30M 29.32k 29.42k 29.35k 28.66k 0 28.66k
# Query size 0 13.28k 90 92 90.63 88.31 0 88.31
# String:
# Databases isuumo
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms ###########
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isuumo` LIKE 'estate'\G
# SHOW CREATE TABLE `isuumo`.`estate`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM estate WHERE rent < 50000 ORDER BY popularity DESC, id ASC LIMIT 25 OFFSET 0\G
# Query 11: 8.56 QPS, 0.00x concurrency, ID 0xDA556F9115773A1A99AA0165670CE848 at byte 46063815
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2020-09-12T05:05:15 to 2020-09-12T05:52:52
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 32 24452
# Exec time 2 11s 25us 24ms 442us 2ms 1ms 131us
# 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 2 716.37k 30 30 30 30 0 30
# String:
# Databases isuumo
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us ######################################
# 100us ################################################################
# 1ms #########
# 10ms #
# 100ms
# 1s
# 10s+
administrator command: Prepare\G
# Query 12: 2.67 QPS, 0.19x concurrency, ID 0x929E86BFE887C4E10B23D92EDD8D61BC at byte 38582543
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2020-09-12T05:51:57 to 2020-09-12T05:52:52
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 147
# Exec time 2 10s 30ms 133ms 71ms 105ms 20ms 65ms
# Lock time 0 2ms 8us 179us 15us 20us 14us 12us
# Rows sent 0 147 1 1 1 1 0 1
# Rows examine 3 4.21M 29.30k 29.30k 29.30k 29.30k 0 29.30k
# Query size 0 10.27k 71 72 71.53 69.19 0 69.19
# String:
# Databases isuumo
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms ###########
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isuumo` LIKE 'estate'\G
# SHOW CREATE TABLE `isuumo`.`estate`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT COUNT(*) FROM estate WHERE door_width >= 80 AND door_width < 110\G
# Query 13: 1.71 QPS, 0.17x concurrency, ID 0x3D16910D1C54800461F4988BE0D150F8 at byte 43655688
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2020-09-12T05:51:53 to 2020-09-12T05:52:52
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 101
# Exec time 2 10s 39ms 178ms 100ms 148ms 28ms 91ms
# Lock time 0 5ms 13us 2ms 46us 38us 230us 16us
# Rows sent 2 2.47k 25 25 25 25 0 25
# Rows examine 2 2.90M 29.32k 29.42k 29.35k 28.66k 0.00 28.66k
# Query size 0 11.95k 120 123 121.15 118.34 0 118.34
# String:
# Databases isuumo
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms #######################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isuumo` LIKE 'chair'\G
# SHOW CREATE TABLE `isuumo`.`chair`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM chair WHERE height >= 110 AND height < 150 AND stock > 0 ORDER BY popularity DESC, id ASC LIMIT 25 OFFSET 0\G
# Query 14: 2.20 QPS, 0.17x concurrency, ID 0x4E8EAE12D58B73C2F3EFAD4903F0402F at byte 37372228
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2020-09-12T05:51:52 to 2020-09-12T05:52:52
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 132
# Exec time 2 10s 36ms 132ms 76ms 116ms 21ms 71ms
# Lock time 0 2ms 10us 119us 16us 26us 9us 13us
# Rows sent 0 132 1 1 1 1 0 1
# Rows examine 2 3.78M 29.30k 29.30k 29.30k 29.30k 0 29.30k
# Query size 0 10.02k 77 79 77.75 76.28 0 76.28
# String:
# Databases isuumo
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms ##############
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isuumo` LIKE 'chair'\G
# SHOW CREATE TABLE `isuumo`.`chair`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT COUNT(*) FROM chair WHERE price >= 3000 AND price < 6000 AND stock > 0\G
# Query 15: 2.64 QPS, 0.17x concurrency, ID 0x4CD8BC51141C351DC73BFA73427CD78F at byte 42274274
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2020-09-12T05:51:52 to 2020-09-12T05:52:50
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 153
# Exec time 2 10s 30ms 116ms 64ms 91ms 15ms 59ms
# Lock time 0 5ms 8us 2ms 35us 23us 197us 12us
# Rows sent 0 153 1 1 1 1 0 1
# Rows examine 3 4.38M 29.30k 29.30k 29.30k 29.30k 0 29.30k
# Query size 0 7.17k 48 48 48 48 0 48
# String:
# Databases isuumo
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms ###
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isuumo` LIKE 'estate'\G
# SHOW CREATE TABLE `isuumo`.`estate`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT COUNT(*) FROM estate WHERE rent >= 150000\G
# Query 16: 1.30 QPS, 0.16x concurrency, ID 0x55402B93A43729A085DF0F23BB694539 at byte 27406825
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2020-09-12T05:51:51 to 2020-09-12T05:52:52
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 79
# Exec time 2 10s 81ms 223ms 124ms 155ms 25ms 122ms
# Lock time 0 6ms 17us 3ms 70us 54us 276us 23us
# Rows sent 16 16.39k 0 1.23k 212.43 719.66 266.13 62.76
# Rows examine 1 2.27M 28.81k 30.53k 29.47k 28.66k 230.47 28.66k
# Query size 0 15.02k 192 197 194.71 192.76 1.03 192.76
# String:
# Databases isuumo
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms #####
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isuumo` LIKE 'estate'\G
# SHOW CREATE TABLE `isuumo`.`estate`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM estate WHERE latitude <= 35.63740609651147 AND latitude >= 35.09339935486106 AND longitude <= 137.3825709966546 AND longitude >= 137.043524630572 ORDER BY popularity DESC, id ASC\G
# Query 17: 3 QPS, 0.19x concurrency, ID 0xBF1444BD9A8EAD17F291508A52D09114 at byte 40149072
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2020-09-12T05:51:53 to 2020-09-12T05:52:43
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 150
# Exec time 2 9s 40ms 112ms 63ms 91ms 14ms 59ms
# Lock time 0 3ms 7us 623us 18us 21us 47us 12us
# Rows sent 0 150 1 1 1 1 0 1
# Rows examine 3 4.29M 29.30k 29.30k 29.30k 29.30k 0 29.30k
# Query size 0 6.74k 46 46 46 46 0 46
# String:
# Databases isuumo
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms #
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isuumo` LIKE 'estate'\G
# SHOW CREATE TABLE `isuumo`.`estate`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT COUNT(*) FROM estate WHERE rent < 50000\G
# Query 18: 1.71 QPS, 0.14x concurrency, ID 0x335F7FF70A5B1F5BBC792221FF0E74ED at byte 34110670
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2020-09-12T05:51:53 to 2020-09-12T05:52:52
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 101
# Exec time 1 8s 47ms 144ms 83ms 122ms 24ms 75ms
# Lock time 0 2ms 9us 196us 18us 22us 21us 13us
# Rows sent 0 101 1 1 1 1 0 1
# Rows examine 2 2.89M 29.30k 29.30k 29.30k 29.30k 0 29.30k
# Query size 0 7.54k 76 77 76.47 76.28 0.50 72.65
# String:
# Databases isuumo
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms ########################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isuumo` LIKE 'chair'\G
# SHOW CREATE TABLE `isuumo`.`chair`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT COUNT(*) FROM chair WHERE height >= 110 AND height < 150 AND stock > 0\G
# Query 19: 1.34 QPS, 0.14x concurrency, ID 0x4A8E12431038633B5ADF2C461C6F48FE at byte 40433359
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2020-09-12T05:51:54 to 2020-09-12T05:52:52
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 78
# Exec time 1 8s 62ms 188ms 104ms 148ms 24ms 95ms
# Lock time 0 2ms 15us 288us 25us 42us 32us 17us
# Rows sent 1 1.90k 25 25 25 25 0 25
# Rows examine 1 2.24M 29.32k 29.42k 29.36k 28.66k 0 28.66k
# Query size 0 8.89k 109 126 116.69 124.25 5.36 112.70
# String:
# Databases isuumo
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms #########################################################
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isuumo` LIKE 'chair'\G
# SHOW CREATE TABLE `isuumo`.`chair`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM chair WHERE kind = 'ハンモック' AND stock > 0 ORDER BY popularity DESC, id ASC LIMIT 25 OFFSET 75\G
# Query 20: 1.64 QPS, 0.15x concurrency, ID 0xE5EB3FC758DE6E117FEEE42B5C7412D2 at byte 43750586
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2020-09-12T05:51:54 to 2020-09-12T05:52:47
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 87
# Exec time 1 8s 65ms 160ms 93ms 141ms 22ms 82ms
# Lock time 0 7ms 14us 4ms 85us 38us 416us 18us
# Rows sent 2 2.12k 25 25 25 25 0 25
# Rows examine 1 2.49M 29.32k 29.42k 29.36k 28.66k 0.00 28.66k
# Query size 0 9.05k 104 115 106.55 112.70 3.74 102.22
# String:
# Databases isuumo
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms ###########################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isuumo` LIKE 'chair'\G
# SHOW CREATE TABLE `isuumo`.`chair`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM chair WHERE color = 'ベージュ' AND stock > 0 ORDER BY popularity DESC, id ASC LIMIT 25 OFFSET 0\G
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment