search

yasu-yamasaki / isucon2020-himetex

0 stars 0 forks source link

alpのスコア #10

Open t-Asai opened 4 years ago

t-Asai commented 4 years ago 
+-------+-------+-------+---------+-------+-------+-------+-------+--------+------------+------------+--------------+------------+--------+---------------------------------------------------------------------------------------+
| COUNT |  MIN  |  MAX  |   SUM   |  AVG  |  P1   |  P50  |  P99  | STDDEV | MIN(BODY)  | MAX(BODY)  |  SUM(BODY)   | AVG(BODY)  | METHOD |                                          URI                                          |
+-------+-------+-------+---------+-------+-------+-------+-------+--------+------------+------------+--------------+------------+--------+---------------------------------------------------------------------------------------+
|  2951 | 0.028 | 1.000 | 463.298 | 0.157 | 0.076 | 0.144 | 0.348 |  0.063 |      0.000 |  22036.000 | 49170071.000 |  16662.172 | GET    | /api/estate/search                                                                    |
|  2174 | 0.007 | 0.928 | 392.961 | 0.181 | 0.104 | 0.160 | 0.416 |  0.069 |      0.000 |  29577.000 | 32349383.000 |  14880.121 | GET    | /api/chair/search                                                                     |
|  1073 | 0.020 | 0.624 | 111.608 | 0.104 | 0.044 | 0.096 | 0.216 |  0.046 |  12139.000 |  12153.000 | 13025665.000 |  12139.483 | GET    | /api/chair/low_priced                                                                 |
|   236 | 0.017 | 2.001 | 109.226 | 0.463 | 0.064 | 0.240 | 2.000 |  0.472 |      0.000 |  34073.000 |  3902641.000 |  16536.614 | POST   | /api/estate/nazotte                                                                   |
|  1073 | 0.020 | 0.536 |  89.892 | 0.084 | 0.032 | 0.076 | 0.176 |  0.035 |  13383.000 |  13398.000 | 14360812.000 |  13383.795 | GET    | /api/estate/low_priced                                                                |
|     5 | 4.212 | 4.532 |  21.452 | 4.290 | 4.212 | 4.220 | 4.264 |  0.122 |     23.000 |     23.000 |      115.000 |     23.000 | POST   | /initialize
t-Asai commented 4 years ago 
+-------+-------+--------+----------+-------+-------+-------+--------+--------+------------+------------+---------------+------------+--------+---------------------------------------------------------------------------------------+
| COUNT |  MIN  |  MAX   |   SUM    |  AVG  |  P1   |  P50  |  P99   | STDDEV | MIN(BODY)  | MAX(BODY)  |   SUM(BODY)   | AVG(BODY)  | METHOD |                                          URI                                          |
+-------+-------+--------+----------+-------+-------+-------+--------+--------+------------+------------+---------------+------------+--------+---------------------------------------------------------------------------------------+
|  7719 | 0.004 |  1.544 | 1008.108 | 0.131 | 0.004 | 0.124 |  0.408 |  0.096 |      0.000 |  31515.000 | 126310334.000 |  16363.562 | GET    | /api/estate/search                                                                    |
|  5034 | 0.016 |  1.568 |  891.791 | 0.177 | 0.048 | 0.156 |  0.480 |  0.095 |      0.000 |  29577.000 |  72666040.000 |  14435.050 | GET    | /api/chair/search                                                                     |
|   722 | 0.004 |  2.001 |  298.145 | 0.413 | 0.000 | 0.180 |  2.000 |  0.530 |      0.000 |  34238.000 |  11973635.000 |  16583.982 | POST   | /api/estate/nazotte                                                                   |
|  2750 | 0.004 |  0.624 |  125.060 | 0.045 | 0.000 | 0.012 |  0.188 |  0.056 |  12139.000 |  12153.000 |  33357299.000 |  12129.927 | GET    | /api/chair/low_priced                                                                 |
|  2750 | 0.004 |  0.536 |  101.475 | 0.037 | 0.000 | 0.008 |  0.160 |  0.045 |  13383.000 |  13427.000 |  36765234.000 |  13369.176 | GET    | /api/estate/low_priced                                                                |
|    20 | 0.012 | 18.696 |   94.948 | 4.747 | 0.000 | 4.212 | 18.620 |  6.168 |     23.000 |     23.000 |       253.000 |     12.650 | POST   | /initialize                                                                           |
t-Asai commented 4 years ago 
+-------+-------+--------+---------+-------+-------+-------+--------+--------+------------+------------+--------------+------------+--------+---------------------------------------------------------------------------------------+
| COUNT |  MIN  |  MAX   |   SUM   |  AVG  |  P1   |  P50  |  P99   | STDDEV | MIN(BODY)  | MAX(BODY)  |  SUM(BODY)   | AVG(BODY)  | METHOD |                                          URI                                          |
+-------+-------+--------+---------+-------+-------+-------+--------+--------+------------+------------+--------------+------------+--------+---------------------------------------------------------------------------------------+
|  4820 | 0.004 |  2.452 | 565.511 | 0.117 | 0.004 | 0.044 |  0.828 |  0.182 |     34.000 |  33354.000 | 73458930.000 |  15240.442 | GET    | /api/estate/search                                                                    |
|  3451 | 0.012 |  2.304 | 518.974 | 0.150 | 0.020 | 0.100 |  0.848 |  0.176 |     33.000 |  29577.000 | 44965813.000 |  13029.792 | GET    | /api/chair/search                                                                     |
|    37 | 0.180 | 34.956 | 345.718 | 9.344 | 0.000 | 0.192 | 30.000 | 10.260 |     23.000 |     23.000 |      713.000 |     19.270 | POST   | /initialize                                                                           |
|   440 | 0.004 |  2.001 | 193.882 | 0.441 | 0.000 | 0.144 |  2.000 |  0.603 |     34.000 |  34075.000 |  6369514.000 |  14476.168 | POST   | /api/estate/nazotte                                                                   |
|    17 | 1.008 |  3.520 |  34.195 | 2.011 | 1.008 | 2.000 |  3.264 |  0.742 |      0.000 |      0.000 |        0.000 |      0.000 | POST   | /api/estate                                                                           |
|    20 | 0.004 |  3.392 |  33.412 | 1.671 | 0.004 | 1.908 |  3.344 |  0.959 |      0.000 |      0.000 |        0.000 |      0.000 | POST   | /api/chair                                                                            |
|  1518 | 0.004 |  0.512 |  15.380 | 0.010 | 0.000 | 0.004 |  0.112 |  0.024 |  13337.000 |  13426.000 | 20344106.000 |  13401.914 | GET    | /api/estate/low_priced                                                                |
|  1518 | 0.008 |  0.788 |  14.096 | 0.009 | 0.000 | 0.004 |  0.072 |  0.033 |  12139.000 |  12186.000 | 18456259.000 |  12158.273 | GET    | /api/chair/low_priced                                                                 |
t-Asai commented 4 years ago 
+-------+-------+-------+---------+-------+-------+-------+-------+--------+-----------+-----------+--------------+-----------+--------+-------------------------------+
| COUNT |  MIN  |  MAX  |   SUM   |  AVG  |  P1   |  P50  |  P99  | STDDEV | MIN(BODY) | MAX(BODY) |  SUM(BODY)   | AVG(BODY) | METHOD |              URI              |
+-------+-------+-------+---------+-------+-------+-------+-------+--------+-----------+-----------+--------------+-----------+--------+-------------------------------+
|   953 | 0.004 | 1.040 | 196.347 | 0.206 | 0.008 | 0.188 | 0.660 |  0.158 |     0.000 | 17325.000 | 12184859.000 | 12785.791 | GET    | /api/estate/search            |
|   894 | 0.020 | 1.724 | 167.962 | 0.188 | 0.032 | 0.140 | 0.756 |  0.162 |     0.000 | 15471.000 | 10089276.000 | 11285.544 | GET    | /api/chair/search             |
|   124 | 0.004 | 2.069 |  73.515 | 0.593 | 0.000 | 0.172 | 2.000 |  0.763 |     0.000 | 34109.000 |  1213355.000 |  9785.121 | POST   | /api/estate/nazotte           |
|     3 | 2.664 | 3.188 |   8.848 | 2.949 | 2.664 | 2.664 | 2.996 |  0.216 |     0.000 |     0.000 |        0.000 |     0.000 | POST   | /api/estate                   |
|     3 | 2.148 | 2.880 |   7.372 | 2.457 | 2.148 | 2.148 | 2.344 |  0.309 |     0.000 |     0.000 |        0.000 |     0.000 | POST   | /api/chair                    |
|   309 | 0.004 | 0.304 |   6.132 | 0.020 | 0.000 | 0.008 | 0.240 |  0.043 | 13337.000 | 13426.000 |  4147641.000 | 13422.786 | GET    | /api/estate/low_priced        |
|   309 | 0.004 | 0.280 |   5.428 | 0.018 | 0.000 | 0.008 | 0.160 |  0.034 | 12153.000 | 12186.000 |  3761811.000 | 12174.146 | GET    | /api/chair/low_priced         |
t-Asai commented 4 years ago 
+-------+--------+--------+---------+--------+--------+--------+--------+--------+-----------+-----------+--------------+-----------+--------+------------------------------------+
| COUNT |  MIN   |  MAX   |   SUM   |  AVG   |   P1   |  P50   |  P99   | STDDEV | MIN(BODY) | MAX(BODY) |  SUM(BODY)   | AVG(BODY) | METHOD |                URI                 |
+-------+--------+--------+---------+--------+--------+--------+--------+--------+-----------+-----------+--------------+-----------+--------+------------------------------------+
|  2830 |  0.004 |  1.900 | 384.553 |  0.136 |  0.004 |  0.044 |  0.688 |  0.169 |     0.000 | 21505.000 | 41249965.000 | 14575.959 | GET    | /api/estate/search                 |
|  1985 |  0.012 |  2.000 | 370.932 |  0.187 |  0.016 |  0.096 |  1.180 |  0.231 |     0.000 | 28461.000 | 24191289.000 | 12187.047 | GET    | /api/chair/search                  |
|   501 |  0.004 |  2.000 | 139.749 |  0.279 |  0.000 |  0.100 |  2.000 |  0.457 |     0.000 | 34169.000 |  8390006.000 | 16746.519 | POST   | /api/estate/nazotte                |
|  1109 |  0.004 |  0.820 |  19.932 |  0.018 |  0.000 |  0.004 |  0.328 |  0.059 | 12139.000 | 12186.000 | 13488652.000 | 12162.896 | GET    | /api/chair/low_priced              |
|     1 | 16.968 | 16.968 |  16.968 | 16.968 | 16.968 | 16.968 | 16.968 |  0.000 |    23.000 |    23.000 |       23.000 |    23.000 | POST   | /initialize                        |
|     6 |  0.956 |  3.504 |  16.484 |  2.747 |  0.956 |  2.872 |  3.468 |  0.861 |     0.000 |     0.000 |        0.000 |     0.000 | POST   | /api/chair                         |
|     6 |  1.004 |  3.252 |  16.016 |  2.669 |  1.004 |  2.872 |  3.108 |  0.764 |     0.000 |     0.000 |        0.000 |     0.000 | POST   | /api/estate                        |
|  1109 |  0.004 |  0.468 |  15.614 |  0.014 |  0.000 |  0.004 |  0.164 |  0.034 | 13337.000 | 13426.000 | 14845804.000 | 13386.658 | GET    | /api/estate/low_priced             |
t-Asai commented 4 years ago 
+-------+--------+--------+---------+--------+--------+--------+--------+--------+-----------+-----------+--------------+-----------+--------+-------------------------------+
| COUNT |  MIN   |  MAX   |   SUM   |  AVG   |   P1   |  P50   |  P99   | STDDEV | MIN(BODY) | MAX(BODY) |  SUM(BODY)   | AVG(BODY) | METHOD |              URI              |
+-------+--------+--------+---------+--------+--------+--------+--------+--------+-----------+-----------+--------------+-----------+--------+-------------------------------+
|  2761 |  0.004 |  2.000 | 389.183 |  0.141 |  0.004 |  0.048 |  0.860 |  0.190 |     0.000 | 19640.000 | 40115136.000 | 14529.205 | GET    | /api/estate/search            |
|  2087 |  0.012 |  1.400 | 349.469 |  0.167 |  0.020 |  0.096 |  0.880 |  0.179 |     0.000 | 17067.000 | 25712652.000 | 12320.389 | GET    | /api/chair/search             |
|   472 |  0.004 |  2.002 | 134.001 |  0.284 |  0.000 |  0.100 |  2.000 |  0.484 |     0.000 | 34550.000 |  7613914.000 | 16131.174 | POST   | /api/estate/nazotte           |
|     1 | 16.716 | 16.716 |  16.716 | 16.716 | 16.716 | 16.716 | 16.716 |  0.000 |    23.000 |    23.000 |       23.000 |    23.000 | POST   | /initialize                   |
|  1085 |  0.004 |  0.756 |  16.296 |  0.015 |  0.000 |  0.004 |  0.208 |  0.045 |     0.000 | 12186.000 | 13184992.000 | 12152.066 | GET    | /api/chair/low_priced         |
|     6 |  1.460 |  3.036 |  15.640 |  2.607 |  1.460 |  2.740 |  2.848 |  0.522 |     0.000 |     0.000 |        0.000 |     0.000 | POST   | /api/estate                   |
|     6 |  1.192 |  3.584 |  15.236 |  2.539 |  1.192 |  2.448 |  2.848 |  0.718 |     0.000 |     0.000 |        0.000 |     0.000 | POST   | /api/chair                    |
|  1085 |  0.004 |  0.592 |  14.408 |  0.013 |  0.000 |  0.004 |  0.180 |  0.038 |     0.000 | 13426.000 | 14523550.000 | 13385.760 | GET    | /api/estate/low_priced        |
t-Asai commented 4 years ago 
+-------+-------+-------+---------+-------+-------+-------+-------+--------+-----------+-----------+--------------+-----------+--------+-------------------------------+
| COUNT |  MIN  |  MAX  |   SUM   |  AVG  |  P1   |  P50  |  P99  | STDDEV | MIN(BODY) | MAX(BODY) |  SUM(BODY)   | AVG(BODY) | METHOD |              URI              |
+-------+-------+-------+---------+-------+-------+-------+-------+--------+-----------+-----------+--------------+-----------+--------+-------------------------------+
|  1240 | 0.014 | 2.001 | 428.035 | 0.345 | 0.032 | 0.236 | 1.800 |  0.342 |     0.000 | 15548.000 | 12373667.000 |  9978.764 | GET    | /api/chair/search             |
|  1752 | 0.004 | 0.956 | 286.339 | 0.163 | 0.000 | 0.128 | 0.632 |  0.169 | 16304.000 | 17241.000 | 22612589.000 | 12906.729 | GET    | /api/estate/search            |
|   430 | 0.001 | 2.000 | 131.189 | 0.305 | 0.000 | 0.128 | 1.712 |  0.407 |     0.000 | 33983.000 |  7231298.000 | 16816.972 | POST   | /api/estate/nazotte           |
|   732 | 0.004 | 2.000 |  47.708 | 0.065 | 0.000 | 0.012 | 0.904 |  0.168 | 12186.000 | 12186.000 |  8899815.000 | 12158.217 | GET    | /api/chair/low_priced         |
|     6 | 2.656 | 4.332 |  19.524 | 3.254 | 2.656 | 2.916 | 3.600 |  0.563 |     0.000 |     0.000 |        0.000 |     0.000 | POST   | /api/chair                    |
|     6 | 2.796 | 3.436 |  18.368 | 3.061 | 2.796 | 2.980 | 3.264 |  0.225 |     0.000 |     0.000 |        0.000 |     0.000 | POST   | /api/estate                   |
|   732 | 0.008 | 0.500 |  11.564 | 0.016 | 0.000 | 0.008 | 0.128 |  0.032 | 13337.000 | 13427.000 |  9799195.000 | 13386.878 | GET    | /api/estate/low_priced        |
t-Asai commented 4 years ago 
+-------+--------+--------+---------+--------+--------+--------+--------+--------+-----------+-----------+--------------+-----------+--------+-------------------------------+
| COUNT |  MIN   |  MAX   |   SUM   |  AVG   |   P1   |  P50   |  P99   | STDDEV | MIN(BODY) | MAX(BODY) |  SUM(BODY)   | AVG(BODY) | METHOD |              URI              |
+-------+--------+--------+---------+--------+--------+--------+--------+--------+-----------+-----------+--------------+-----------+--------+-------------------------------+
|  1207 |  0.012 |  2.002 | 412.832 |  0.342 |  0.020 |  0.120 |  2.000 |  0.485 |     0.000 | 18296.000 | 13555650.000 | 11230.862 | GET    | /api/chair/search             |
|  1232 |  0.004 |  2.000 | 127.779 |  0.104 |  0.000 |  0.008 |  1.832 |  0.304 |     0.000 | 12186.000 | 14528521.000 | 11792.631 | GET    | /api/chair/low_priced         |
|  4183 |  0.000 |  0.900 |  76.620 |  0.018 |  0.000 |  0.004 |  0.308 |  0.055 |    34.000 | 18791.000 | 66129217.000 | 15809.041 | GET    | /api/estate/search            |
|   411 |  0.004 |  1.172 |  51.344 |  0.125 |  0.000 |  0.084 |  0.812 |  0.165 |    34.000 | 34089.000 |  7397395.000 | 17998.528 | POST   | /api/estate/nazotte           |
|     7 |  0.936 |  4.994 |  19.515 |  2.788 |  0.936 |  2.233 |  3.980 |  1.339 |     0.000 |     0.000 |        0.000 |     0.000 | POST   | /api/chair                    |
t-Asai commented 4 years ago 
+-------+--------+--------+---------+--------+--------+--------+--------+--------+-----------+-----------+--------------+-----------+--------+-------------------------------+
| COUNT |  MIN   |  MAX   |   SUM   |  AVG   |   P1   |  P50   |  P99   | STDDEV | MIN(BODY) | MAX(BODY) |  SUM(BODY)   | AVG(BODY) | METHOD |              URI              |
+-------+--------+--------+---------+--------+--------+--------+--------+--------+-----------+-----------+--------------+-----------+--------+-------------------------------+
|  1260 |  0.106 |  2.000 | 438.562 |  0.348 |  0.000 |  0.252 |  1.396 |  0.319 |    33.000 | 27614.000 | 12661420.000 | 10048.746 | GET    | /api/chair/search             |
|  1753 |  0.115 |  1.200 | 305.779 |  0.174 |  0.000 |  0.132 |  0.760 |  0.191 |    34.000 | 18580.000 | 22469298.000 | 12817.626 | GET    | /api/estate/search            |
|   364 |  0.004 |  2.001 | 133.296 |  0.366 |  0.000 |  0.152 |  2.000 |  0.514 |    34.000 | 34296.000 |  6316604.000 | 17353.308 | POST   | /api/estate/nazotte           |
|   656 |  0.004 |  1.998 |  49.310 |  0.075 |  0.000 |  0.016 |  0.808 |  0.175 | 12153.000 | 12186.000 |  7963341.000 | 12139.239 | GET    | /api/chair/low_priced         |