search

txxxxc / isucon11-qualify

0 stars 0 forks source link

alp #1

Open txxxxc opened 4 months ago

txxxxc commented 4 months ago 
May 22 20:20
+-------+--------+------------------------------+-------+-------+-------+----------+
| COUNT | METHOD |             URI              |  MIN  |  AVG  |  MAX  |   SUM    |
+-------+--------+------------------------------+-------+-------+-------+----------+
| 48225 | POST   | ^/api/condition/[\w\d-]+$    | 0.004 | 0.048 | 0.132 | 2330.176 |
| 318   | POST   | /api/isu                     | 0.004 | 0.880 | 1.028 | 279.688  |
| 123   | GET    | /api/isu                     | 0.004 | 0.871 | 1.008 | 107.108  |
| 74    | GET    | ^/api/isu/[\w\d-]+/icon$     | 0.024 | 0.355 | 3.000 | 26.264   |
| 70    | POST   | /api/auth                    | 0.004 | 0.371 | 3.000 | 26.004   |
| 68    | GET    | ^/api/isu/[\w\d-]+$          | 0.004 | 0.320 | 3.000 | 21.792   |
| 38    | GET    | ^/api/condition/[\w\d-]+$    | 0.004 | 0.236 | 3.000 | 8.960    |
| 9     | GET    | /api/trend                   | 0.032 | 0.785 | 1.004 | 7.068    |
| 26    | GET    | ^/api/isu/[\w\d-]+/graph$    | 0.028 | 0.133 | 1.004 | 3.452    |
| 50    | GET    | /assets/favicon.d0f5f504.svg | 0.004 | 0.007 | 0.072 | 0.364    |
| 50    | GET    | /assets/index.23dac98b.js    | 0.004 | 0.007 | 0.080 | 0.348    |
| 50    | GET    | /assets/index.144d8ca8.css   | 0.004 | 0.006 | 0.076 | 0.316    |
| 50    | GET    | /assets/vendor.ee7444dd.js   | 0.004 | 0.006 | 0.080 | 0.296    |
| 1     | POST   | /initialize                  | 0.296 | 0.296 | 0.296 | 0.296    |
| 14    | GET    | /api/user/me                 | 0.012 | 0.017 | 0.084 | 0.232    |
| 28    | GET    | /                            | 0.004 | 0.008 | 0.064 | 0.220    |
| 50    | GET    | /assets/logo_white.svg       | 0.004 | 0.004 | 0.060 | 0.176    |
| 8     | POST   | /api/signout                 | 0.036 | 0.017 | 0.096 | 0.136    |
| 11    | GET    | /assets/logo_orange.svg      | 0.008 | 0.005 | 0.016 | 0.052    |
| 18    | GET    | ^/isu/[\w\d-]+/condition$    | 0.000 | 0.001 | 0.004 | 0.012    |
| 3     | GET    | /register                    | 0.004 | 0.004 | 0.004 | 0.012    |
| 6     | GET    | ^/isu/[\w\d-]+$              | 0.000 | 0.001 | 0.004 | 0.004    |
| 6     | GET    | ^/isu/[\w\d-]+/graph$        | 0.000 | 0.000 | 0.000 | 0.000    |
| 1     | GET    | /api/v1/timestamp            | 0.000 | 0.000 | 0.000 | 0.000    |
+-------+--------+------------------------------+-------+-------+-------+----------+
txxxxc commented 3 months ago 
+-------+--------+------------------------------+-------+-------+-------+----------+
| COUNT | METHOD |             URI              |  MIN  |  AVG  |  MAX  |   SUM    |
+-------+--------+------------------------------+-------+-------+-------+----------+
| 49356 | POST   | ^/api/condition/[\w\d-]+$$   | 0.008 | 0.039 | 0.152 | 1924.612 |
| 268   | GET    | ^/api/isu/[\w\d-]+$$         | 0.024 | 0.834 | 3.000 | 223.448  |
| 126   | GET    | /api/isu                     | 0.168 | 0.910 | 3.000 | 114.720  |
| 116   | POST   | /api/isu                     | 0.004 | 0.703 | 1.008 | 81.556   |
| 78    | GET    | ^/api/isu/[\w\d-]+/icon$$    | 0.028 | 0.364 | 3.000 | 28.424   |
| 73    | POST   | /api/auth                    | 0.004 | 0.344 | 3.000 | 25.104   |
| 9     | GET    | /api/trend                   | 0.040 | 0.789 | 1.004 | 7.104    |
| 39    | GET    | ^/api/condition/[\w\d-]+$$   | 0.032 | 0.134 | 1.004 | 5.216    |
| 26    | GET    | ^/api/isu/[\w\d-]+/graph$$   | 0.004 | 0.094 | 1.000 | 2.440    |
| 1     | POST   | /initialize                  | 0.264 | 0.264 | 0.264 | 0.264    |
| 15    | GET    | /api/user/me                 | 0.004 | 0.017 | 0.060 | 0.256    |
| 51    | GET    | /assets/index.23dac98b.js    | 0.004 | 0.004 | 0.056 | 0.224    |
| 51    | GET    | /assets/favicon.d0f5f504.svg | 0.004 | 0.004 | 0.056 | 0.216    |
| 51    | GET    | /assets/vendor.ee7444dd.js   | 0.004 | 0.004 | 0.056 | 0.212    |
| 29    | GET    | /                            | 0.020 | 0.007 | 0.064 | 0.212    |
| 51    | GET    | /assets/index.144d8ca8.css   | 0.004 | 0.004 | 0.048 | 0.188    |
| 51    | GET    | /assets/logo_white.svg       | 0.004 | 0.003 | 0.048 | 0.148    |
| 9     | POST   | /api/signout                 | 0.024 | 0.012 | 0.052 | 0.108    |
| 11    | GET    | /assets/logo_orange.svg      | 0.000 | 0.003 | 0.016 | 0.032    |
| 18    | GET    | ^/isu/[\w\d-]+/condition$$   | 0.004 | 0.001 | 0.004 | 0.020    |
| 6     | GET    | ^/isu/[\w\d-]+/graph$$       | 0.004 | 0.001 | 0.004 | 0.008    |
| 3     | GET    | /register                    | 0.000 | 0.000 | 0.000 | 0.000    |
| 6     | GET    | ^/isu/[\w\d-]+$$             | 0.000 | 0.000 | 0.000 | 0.000    |
+-------+--------+------------------------------+-------+-------+-------+----------+
txxxxc commented 3 months ago

nginxのファイルディスクリプタとmysqlのmaxconnをめっちゃ増やした後です

+-------+--------+------------------------------+-------+-------+--------+----------+
| COUNT | METHOD |             URI              |  MIN  |  AVG  |  MAX   |   SUM    |
+-------+--------+------------------------------+-------+-------+--------+----------+
| 10660 | POST   | ^/api/condition/[\w\d-]+$    | 1.803 | 0.157 | 60.312 | 1668.400 |
| 249   | POST   | /api/isu                     | 0.004 | 0.934 | 2.212  | 232.560  |
| 56    | POST   | /api/auth                    | 0.020 | 0.505 | 14.844 | 28.276   |
| 9     | GET    | /api/trend                   | 0.036 | 0.796 | 1.004  | 7.164    |
| 49    | GET    | ^/api/isu/[\w\d-]+/icon$     | 0.004 | 0.138 | 3.000  | 6.752    |
| 43    | GET    | ^/api/isu/[\w\d-]+$          | 3.000 | 0.141 | 3.000  | 6.056    |
| 14    | GET    | /api/isu                     | 3.004 | 0.242 | 3.004  | 3.388    |
| 24    | GET    | ^/api/isu/[\w\d-]+/graph$    | 1.008 | 0.078 | 1.008  | 1.868    |
| 35    | GET    | ^/api/condition/[\w\d-]+$    | 0.004 | 0.050 | 1.000  | 1.756    |
| 1     | POST   | /initialize                  | 0.416 | 0.416 | 0.416  | 0.416    |
| 49    | GET    | /assets/vendor.ee7444dd.js   | 0.012 | 0.005 | 0.048  | 0.252    |
| 49    | GET    | /assets/favicon.d0f5f504.svg | 0.012 | 0.004 | 0.032  | 0.216    |
| 49    | GET    | /assets/index.23dac98b.js    | 0.004 | 0.004 | 0.032  | 0.216    |
| 49    | GET    | /assets/index.144d8ca8.css   | 0.004 | 0.004 | 0.032  | 0.184    |
| 27    | GET    | /                            | 0.000 | 0.005 | 0.016  | 0.132    |
| 13    | GET    | /api/user/me                 | 0.000 | 0.009 | 0.044  | 0.112    |
| 49    | GET    | /assets/logo_white.svg       | 0.000 | 0.001 | 0.024  | 0.060    |
| 11    | GET    | /assets/logo_orange.svg      | 0.000 | 0.004 | 0.024  | 0.040    |
| 7     | POST   | /api/signout                 | 0.012 | 0.004 | 0.012  | 0.028    |
| 18    | GET    | ^/isu/[\w\d-]+/condition$    | 0.004 | 0.001 | 0.004  | 0.016    |
| 6     | GET    | ^/isu/[\w\d-]+$              | 0.000 | 0.001 | 0.004  | 0.008    |
| 6     | GET    | ^/isu/[\w\d-]+/graph$        | 0.000 | 0.001 | 0.004  | 0.008    |
| 3     | GET    | /register                    | 0.000 | 0.000 | 0.000  | 0.000    |
+-------+--------+------------------------------+-------+-------+--------+----------+
txxxxc commented 3 months ago

bulk insert後

+-------+--------+------------------------------+-------+-------+-------+----------+
| COUNT | METHOD |             URI              |  MIN  |  AVG  |  MAX  |   SUM    |
+-------+--------+------------------------------+-------+-------+-------+----------+
| 24473 | POST   | ^/api/condition/[\w\d-]+$    | 0.008 | 0.099 | 0.124 | 2433.376 |
| 303   | POST   | /api/isu                     | 0.004 | 0.890 | 1.012 | 269.664  |
| 124   | GET    | ^/api/isu/[\w\d-]+$          | 0.004 | 0.714 | 3.004 | 88.512   |
| 72    | GET    | /api/isu                     | 0.792 | 0.904 | 3.000 | 65.112   |
| 67    | GET    | ^/api/isu/[\w\d-]+/icon$     | 0.012 | 0.410 | 3.000 | 27.496   |
| 69    | POST   | /api/auth                    | 0.008 | 0.235 | 3.004 | 16.216   |
| 30    | GET    | ^/api/isu/[\w\d-]+/graph$    | 0.004 | 0.266 | 2.988 | 7.992    |
| 9     | GET    | /api/trend                   | 0.032 | 0.793 | 1.000 | 7.136    |
| 34    | GET    | ^/api/condition/[\w\d-]+$    | 0.012 | 0.103 | 1.000 | 3.496    |
| 1     | POST   | /initialize                  | 0.324 | 0.324 | 0.324 | 0.324    |
| 51    | GET    | /assets/index.23dac98b.js    | 0.004 | 0.004 | 0.024 | 0.220    |
| 51    | GET    | /assets/favicon.d0f5f504.svg | 0.004 | 0.004 | 0.024 | 0.212    |
| 51    | GET    | /assets/index.144d8ca8.css   | 0.004 | 0.004 | 0.020 | 0.196    |
| 51    | GET    | /assets/vendor.ee7444dd.js   | 0.004 | 0.004 | 0.028 | 0.184    |
| 29    | GET    | /                            | 0.008 | 0.005 | 0.020 | 0.156    |
| 15    | GET    | /api/user/me                 | 0.012 | 0.007 | 0.016 | 0.104    |
| 51    | GET    | /assets/logo_white.svg       | 0.012 | 0.001 | 0.012 | 0.064    |
| 9     | POST   | /api/signout                 | 0.004 | 0.004 | 0.024 | 0.040    |
| 6     | GET    | ^/isu/[\w\d-]+$              | 0.004 | 0.003 | 0.004 | 0.016    |
| 11    | GET    | /assets/logo_orange.svg      | 0.000 | 0.001 | 0.008 | 0.012    |
| 18    | GET    | ^/isu/[\w\d-]+/condition$    | 0.000 | 0.000 | 0.004 | 0.008    |
| 6     | GET    | ^/isu/[\w\d-]+/graph$        | 0.000 | 0.000 | 0.000 | 0.000    |
| 3     | GET    | /register                    | 0.000 | 0.000 | 0.000 | 0.000    |
+-------+--------+------------------------------+-------+-------+-------+----------+
txxxxc commented 3 months ago 
+-------+--------+------------------------------+-------+-------+-------+----------+
| COUNT | METHOD |             URI              |  MIN  |  AVG  |  MAX  |   SUM    |
+-------+--------+------------------------------+-------+-------+-------+----------+
| 42449 | POST   | ^/api/condition/[\w\d-]+$    | 0.012 | 0.068 | 0.172 | 2866.724 |
| 885   | GET    | ^/api/isu/[\w\d-]+/icon$     | 0.004 | 0.233 | 0.548 | 206.552  |
| 767   | GET    | ^/api/condition/[\w\d-]+$    | 0.004 | 0.231 | 0.696 | 177.084  |
| 371   | GET    | ^/api/isu/[\w\d-]+/graph$    | 0.056 | 0.254 | 0.708 | 94.216   |
| 149   | GET    | /api/isu                     | 0.060 | 0.387 | 1.004 | 57.704   |
| 47    | GET    | /api/trend                   | 0.032 | 0.962 | 1.024 | 45.216   |
| 202   | GET    | ^/api/isu/[\w\d-]+$          | 0.004 | 0.157 | 0.504 | 31.756   |
| 181   | POST   | /api/auth                    | 0.008 | 0.092 | 0.464 | 16.712   |
| 55    | POST   | /api/isu                     | 0.004 | 0.246 | 0.568 | 13.508   |
| 93    | GET    | /                            | 0.004 | 0.044 | 0.112 | 4.124    |
| 58    | GET    | /api/user/me                 | 0.004 | 0.070 | 0.312 | 4.052    |
| 98    | GET    | /assets/vendor.ee7444dd.js   | 0.004 | 0.038 | 0.116 | 3.772    |
| 35    | POST   | /api/signout                 | 0.004 | 0.105 | 0.360 | 3.676    |
| 98    | GET    | /assets/index.23dac98b.js    | 0.004 | 0.037 | 0.108 | 3.652    |
| 98    | GET    | /assets/favicon.d0f5f504.svg | 0.004 | 0.037 | 0.104 | 3.632    |
| 98    | GET    | /assets/index.144d8ca8.css   | 0.004 | 0.036 | 0.104 | 3.540    |
| 98    | GET    | /assets/logo_white.svg       | 0.004 | 0.031 | 0.124 | 3.076    |
| 49    | GET    | /assets/logo_orange.svg      | 0.012 | 0.044 | 0.116 | 2.160    |
| 1     | POST   | /initialize                  | 0.328 | 0.328 | 0.328 | 0.328    |
| 6     | GET    | ^/isu/[\w\d-]+/graph$        | 0.000 | 0.001 | 0.004 | 0.008    |
| 6     | GET    | ^/isu/[\w\d-]+$              | 0.000 | 0.001 | 0.004 | 0.004    |
| 18    | GET    | ^/isu/[\w\d-]+/condition$    | 0.000 | 0.000 | 0.004 | 0.004    |
| 3     | GET    | /register                    | 0.000 | 0.000 | 0.000 | 0.000    |
+-------+--------+------------------------------+-------+-------+-------+----------+

+-------+-----+-------+-----+------+-----+--------+------------------------------+-------+-------+----------+-------+-------+-------+-------+--------+-----------+------------+--------------+------------+
| COUNT | 1XX |  2XX  | 3XX | 4XX  | 5XX | METHOD |             URI              |  MIN  |  MAX  |   SUM    |  AVG  |  P90  |  P95  |  P99  | STDDEV | MIN(BODY) | MAX(BODY)  |  SUM(BODY)   | AVG(BODY)  |
+-------+-----+-------+-----+------+-----+--------+------------------------------+-------+-------+----------+-------+-------+-------+-------+--------+-----------+------------+--------------+------------+
| 42449 | 0   | 36978 | 0   | 5471 | 0   | POST   | ^/api/condition/[\w\d-]+$    | 0.012 | 0.172 | 2866.724 | 0.068 | 0.100 | 0.100 | 0.104 | 0.020  | 0.000     | 14.000     | 56.000       | 0.001      |
| 885   | 0   | 841   | 0   | 44   | 0   | GET    | ^/api/isu/[\w\d-]+/icon$     | 0.004 | 0.548 | 206.552  | 0.233 | 0.424 | 0.456 | 0.496 | 0.138  | 0.000     | 135259.000 | 21677871.000 | 24494.769  |
| 767   | 0   | 672   | 0   | 95   | 0   | GET    | ^/api/condition/[\w\d-]+$    | 0.004 | 0.696 | 177.084  | 0.231 | 0.428 | 0.480 | 0.572 | 0.142  | 0.000     | 7243.000   | 3867373.000  | 5042.207   |
| 371   | 0   | 305   | 0   | 66   | 0   | GET    | ^/api/isu/[\w\d-]+/graph$    | 0.056 | 0.708 | 94.216   | 0.254 | 0.488 | 0.568 | 0.656 | 0.167  | 0.000     | 6951.000   | 1284585.000  | 3462.493   |
| 149   | 0   | 125   | 0   | 24   | 0   | GET    | /api/isu                     | 0.060 | 1.004 | 57.704   | 0.387 | 0.804 | 1.000 | 1.000 | 0.283  | 0.000     | 4699.000   | 346983.000   | 2328.745   |
| 47    | 0   | 2     | 0   | 45   | 0   | GET    | /api/trend                   | 0.032 | 1.024 | 45.216   | 0.962 | 1.004 | 1.008 | 1.024 | 0.189  | 0.000     | 4495.000   | 8488.000     | 180.596    |
| 202   | 0   | 160   | 0   | 42   | 0   | GET    | ^/api/isu/[\w\d-]+$          | 0.004 | 0.504 | 31.756   | 0.157 | 0.332 | 0.400 | 0.476 | 0.125  | 0.000     | 151.000    | 22398.000    | 110.881    |
| 181   | 0   | 69    | 0   | 112  | 0   | POST   | /api/auth                    | 0.008 | 0.464 | 16.712   | 0.092 | 0.208 | 0.268 | 0.376 | 0.081  | 0.000     | 19.000     | 1288.000     | 7.116      |
| 55    | 0   | 51    | 0   | 4    | 0   | POST   | /api/isu                     | 0.004 | 0.568 | 13.508   | 0.246 | 0.452 | 0.484 | 0.568 | 0.147  | 15.000    | 151.000    | 7002.000     | 127.309    |
| 93    | 0   | 77    | 16  | 0    | 0   | GET    | /                            | 0.004 | 0.112 | 4.124    | 0.044 | 0.076 | 0.088 | 0.112 | 0.031  | 0.000     | 528.000    | 40656.000    | 437.161    |
| 58    | 0   | 27    | 0   | 31   | 0   | GET    | /api/user/me                 | 0.004 | 0.312 | 4.052    | 0.070 | 0.192 | 0.220 | 0.312 | 0.069  | 21.000    | 44.000     | 1648.000     | 28.414     |
| 98    | 0   | 50    | 48  | 0    | 0   | GET    | /assets/vendor.ee7444dd.js   | 0.004 | 0.116 | 3.772    | 0.038 | 0.088 | 0.096 | 0.116 | 0.038  | 0.000     | 743417.000 | 37170850.000 | 379294.388 |
| 35    | 0   | 19    | 0   | 16   | 0   | POST   | /api/signout                 | 0.004 | 0.360 | 3.676    | 0.105 | 0.216 | 0.312 | 0.360 | 0.091  | 21.000    | 21.000     | 336.000      | 9.600      |
| 98    | 0   | 50    | 48  | 0    | 0   | GET    | /assets/index.23dac98b.js    | 0.004 | 0.108 | 3.652    | 0.037 | 0.080 | 0.088 | 0.108 | 0.035  | 0.000     | 26667.000  | 1333350.000  | 13605.612  |
| 98    | 0   | 50    | 48  | 0    | 0   | GET    | /assets/favicon.d0f5f504.svg | 0.004 | 0.104 | 3.632    | 0.037 | 0.080 | 0.088 | 0.104 | 0.035  | 0.000     | 592.000    | 29600.000    | 302.041    |
| 98    | 0   | 50    | 48  | 0    | 0   | GET    | /assets/index.144d8ca8.css   | 0.004 | 0.104 | 3.540    | 0.036 | 0.080 | 0.084 | 0.104 | 0.034  | 0.000     | 19066.000  | 953300.000   | 9727.551   |
| 98    | 0   | 50    | 48  | 0    | 0   | GET    | /assets/logo_white.svg       | 0.004 | 0.124 | 3.076    | 0.031 | 0.068 | 0.080 | 0.124 | 0.033  | 0.000     | 3285.000   | 164250.000   | 1676.020   |
| 49    | 0   | 49    | 0   | 0    | 0   | GET    | /assets/logo_orange.svg      | 0.012 | 0.116 | 2.160    | 0.044 | 0.076 | 0.080 | 0.116 | 0.030  | 3288.000  | 3288.000   | 161112.000   | 3288.000   |
| 1     | 0   | 1     | 0   | 0    | 0   | POST   | /initialize                  | 0.328 | 0.328 | 0.328    | 0.328 | 0.328 | 0.328 | 0.328 | 0.000  | 23.000    | 23.000     | 23.000       | 23.000     |
| 6     | 0   | 6     | 0   | 0    | 0   | GET    | ^/isu/[\w\d-]+/graph$        | 0.000 | 0.004 | 0.008    | 0.001 | 0.004 | 0.004 | 0.004 | 0.002  | 528.000   | 528.000    | 3168.000     | 528.000    |
| 6     | 0   | 6     | 0   | 0    | 0   | GET    | ^/isu/[\w\d-]+$              | 0.000 | 0.004 | 0.004    | 0.001 | 0.004 | 0.004 | 0.004 | 0.001  | 528.000   | 528.000    | 3168.000     | 528.000    |
| 18    | 0   | 6     | 12  | 0    | 0   | GET    | ^/isu/[\w\d-]+/condition$    | 0.000 | 0.004 | 0.004    | 0.000 | 0.000 | 0.004 | 0.004 | 0.001  | 0.000     | 528.000    | 3168.000     | 176.000    |
| 3     | 0   | 1     | 2   | 0    | 0   | GET    | /register                    | 0.000 | 0.000 | 0.000    | 0.000 | 0.000 | 0.000 | 0.000 | 0.000  | 0.000     | 528.000    | 528.000      | 176.000    |
+-------+-----+-------+-----+------+-----+--------+------------------------------+-------+-------+----------+-------+-------+-------+-------+--------+-----------+------------+--------------+------------+
txxxxc commented 3 months ago

キャッシュ追加前

+-------+--------+------------------------------+-------+-------+-------+----------+
| COUNT | METHOD |             URI              |  MIN  |  AVG  |  MAX  |   SUM    |
+-------+--------+------------------------------+-------+-------+-------+----------+
| 42498 | POST   | ^/api/condition/[\w\d-]+$    | 0.004 | 0.067 | 0.168 | 2865.488 |
| 885   | GET    | ^/api/isu/[\w\d-]+/icon$     | 0.004 | 0.235 | 0.596 | 208.180  |
| 734   | GET    | ^/api/condition/[\w\d-]+$    | 0.004 | 0.240 | 0.684 | 175.836  |
| 379   | GET    | ^/api/isu/[\w\d-]+/graph$    | 0.004 | 0.244 | 0.720 | 92.428   |
| 150   | GET    | /api/isu                     | 0.032 | 0.411 | 1.004 | 61.580   |
| 52    | GET    | /api/trend                   | 0.040 | 0.945 | 1.004 | 49.156   |
| 203   | GET    | ^/api/isu/[\w\d-]+$          | 0.004 | 0.152 | 0.536 | 30.836   |
| 186   | POST   | /api/auth                    | 0.004 | 0.094 | 0.380 | 17.456   |
| 55    | POST   | /api/isu                     | 0.004 | 0.243 | 0.648 | 13.344   |
| 68    | GET    | /api/user/me                 | 0.004 | 0.084 | 0.292 | 5.704    |
| 103   | GET    | /                            | 0.004 | 0.049 | 0.116 | 5.024    |
| 40    | POST   | /api/signout                 | 0.004 | 0.107 | 0.316 | 4.264    |
| 1     | POST   | /initialize                  | 0.360 | 0.360 | 0.360 | 0.360    |
| 18    | GET    | ^/isu/[\w\d-]+/condition$    | 0.000 | 0.001 | 0.004 | 0.012    |
| 3     | GET    | /register                    | 0.000 | 0.003 | 0.004 | 0.008    |
| 6     | GET    | ^/isu/[\w\d-]+/graph$        | 0.000 | 0.001 | 0.004 | 0.004    |
| 6     | GET    | ^/isu/[\w\d-]+$              | 0.000 | 0.001 | 0.004 | 0.004    |
| 54    | GET    | /assets/logo_orange.svg      | 0.000 | 0.000 | 0.000 | 0.000    |
| 55    | GET    | /assets/logo_white.svg       | 0.000 | 0.000 | 0.000 | 0.000    |
| 55    | GET    | /assets/vendor.ee7444dd.js   | 0.000 | 0.000 | 0.000 | 0.000    |
| 55    | GET    | /assets/index.23dac98b.js    | 0.000 | 0.000 | 0.000 | 0.000    |
| 55    | GET    | /assets/favicon.d0f5f504.svg | 0.000 | 0.000 | 0.000 | 0.000    |
| 55    | GET    | /assets/index.144d8ca8.css   | 0.000 | 0.000 | 0.000 | 0.000    |
+-------+--------+------------------------------+-------+-------+-------+----------+
txxxxc commented 3 months ago

キャッシュ導入後

+-------+--------+------------------------------+-------+-------+-------+----------+
| COUNT | METHOD |             URI              |  MIN  |  AVG  |  MAX  |   SUM    |
+-------+--------+------------------------------+-------+-------+-------+----------+
| 43385 | POST   | ^/api/condition/[\w\d-]+$    | 0.004 | 0.066 | 0.152 | 2853.624 |
| 906   | GET    | ^/api/condition/[\w\d-]+$    | 0.004 | 0.225 | 0.712 | 204.164  |
| 410   | GET    | ^/api/isu/[\w\d-]+/graph$    | 0.004 | 0.247 | 0.892 | 101.328  |
| 170   | GET    | /api/isu                     | 0.040 | 0.402 | 1.044 | 68.344   |
| 235   | GET    | ^/api/isu/[\w\d-]+/icon$     | 0.004 | 0.229 | 0.596 | 53.924   |
| 51    | GET    | /api/trend                   | 0.036 | 0.965 | 1.028 | 49.220   |
| 221   | GET    | ^/api/isu/[\w\d-]+$          | 0.004 | 0.153 | 0.528 | 33.868   |
| 185   | POST   | /api/auth                    | 0.004 | 0.096 | 0.380 | 17.824   |
| 55    | POST   | /api/isu                     | 0.004 | 0.244 | 0.776 | 13.444   |
| 67    | GET    | /api/user/me                 | 0.004 | 0.080 | 0.376 | 5.380    |
| 40    | POST   | /api/signout                 | 0.008 | 0.114 | 0.344 | 4.556    |
| 102   | GET    | /                            | 0.008 | 0.043 | 0.092 | 4.404    |
| 1     | POST   | /initialize                  | 0.296 | 0.296 | 0.296 | 0.296    |
| 18    | GET    | ^/isu/[\w\d-]+/condition$    | 0.000 | 0.000 | 0.004 | 0.004    |
| 6     | GET    | ^/isu/[\w\d-]+$              | 0.000 | 0.001 | 0.004 | 0.004    |
| 54    | GET    | /assets/vendor.ee7444dd.js   | 0.000 | 0.000 | 0.000 | 0.000    |
| 6     | GET    | ^/isu/[\w\d-]+/graph$        | 0.000 | 0.000 | 0.000 | 0.000    |
| 53    | GET    | /assets/logo_orange.svg      | 0.000 | 0.000 | 0.000 | 0.000    |
| 54    | GET    | /assets/logo_white.svg       | 0.000 | 0.000 | 0.000 | 0.000    |
| 54    | GET    | /assets/index.23dac98b.js    | 0.000 | 0.000 | 0.000 | 0.000    |
| 54    | GET    | /assets/favicon.d0f5f504.svg | 0.000 | 0.000 | 0.000 | 0.000    |
| 3     | GET    | /register                    | 0.000 | 0.000 | 0.000 | 0.000    |
| 54    | GET    | /assets/index.144d8ca8.css   | 0.000 | 0.000 | 0.000 | 0.000    |
+-------+--------+------------------------------+-------+-------+-------+----------+
txxxxc commented 2 months ago

+-------+--------+-----------------------------------------------------------------------------------------------------+-------+-------+-------+----------+ | COUNT | METHOD | URI | MIN | AVG | MAX | SUM | +-------+--------+-----------------------------------------------------------------------------------------------------+-------+-------+-------+----------+ | 43823 | POST | ^/api/condition/[\w\d-]+$ | 0.004 | 0.065 | 0.164 | 2853.100 | | 947 | GET | ^/api/condition/[\w\d-]+$ | 0.004 | 0.219 | 0.636 | 207.572 | | 449 | GET | ^/api/isu/[\w\d-]+/graph$ | 0.004 | 0.233 | 0.736 | 104.456 | | 187 | GET | /api/isu | 0.008 | 0.369 | 1.000 | 69.012 | | 48 | GET | /api/trend | 0.036 | 0.937 | 1.008 | 44.984 | | 212 | GET | ^/api/isu/[\w\d-]+/icon$ | 0.004 | 0.160 | 0.664 | 34.012 | | 240 | GET | ^/api/isu/[\w\d-]+$ | 0.004 | 0.140 | 0.480 | 33.636 | | 194 | POST | /api/auth | 0.004 | 0.088 | 0.312 | 17.020 | | 55 | POST | /api/isu | 0.004 | 0.230 | 0.592 | 12.668 | | 60 | GET | /api/user/me | 0.008 | 0.066 | 0.288 | 3.972 | | 102 | GET | / | 0.000 | 0.038 | 0.088 | 3.916 | | 37 | POST | /api/signout | 0.004 | 0.102 | 0.272 | 3.756 | | 54 | GET | /assets/vendor.ee7444dd.js | 0.723 | 0.047 | 0.928 | 2.533 | | 1 | POST | /initialize | 0.344 | 0.344 | 0.344 | 0.344 | | 18 | GET | ^/isu/[\w\d-]+/condition$ | 0.000 | 0.000 | 0.004 | 0.008 | | 1 | GET | /ecp/Current/exporttool/microsoft.exchange.ediscovery.exporttool.application | 0.004 | 0.004 | 0.004 | 0.004 | | 6 | GET | ^/isu/[\w\d-]+/graph$ | 0.000 | 0.001 | 0.004 | 0.004 | | 3 | GET | /register | 0.004 | 0.001 | 0.004 | 0.004 | | 1 | POST | / | 0.000 | 0.000 | 0.000 | 0.000 | | 1 | GET | /v2/_catalog | 0.000 | 0.000 | 0.000 | 0.000 | | 51 | GET | /assets/index.144d8ca8.css | 0.000 | 0.000 | 0.000 | 0.000 | | 54 | GET | /assets/index.23dac98b.js | 0.000 | 0.000 | 0.000 | 0.000 | | 51 | GET | /assets/logo_white.svg | 0.000 | 0.000 | 0.000 | 0.000 | | 2 | GET | /.env | 0.000 | 0.000 | 0.000 | 0.000 | | 50 | GET | /assets/logo_orange.svg | 0.000 | 0.000 | 0.000 | 0.000 | | 1 | GET | /server | 0.000 | 0.000 | 0.000 | 0.000 | | 1 | GET | /.vscode/sftp.json | 0.000 | 0.000 | 0.000 | 0.000 | | 1 | GET | /about | 0.000 | 0.000 | 0.000 | 0.000 | | 1 | GET | /debug/default/view | 0.000 | 0.000 | 0.000 | 0.000 | | 51 | GET | /assets/favicon.d0f5f504.svg | 0.000 | 0.000 | 0.000 | 0.000 | | 6 | GET | ^/isu/[\w\d-]+$ | 0.000 | 0.000 | 0.000 | 0.000 | | 1 | GET | /server-status | 0.000 | 0.000 | 0.000 | 0.000 | | 1 | GET | /login.action | 0.000 | 0.000 | 0.000 | 0.000 | | 1 | GET | /_all_dbs | 0.000 | 0.000 | 0.000 | 0.000 | | 1 | GET | /.DSStore | 0.000 | 0.000 | 0.000 | 0.000 | | 1 | GET | /.git/config | 0.000 | 0.000 | 0.000 | 0.000 | | 1 | GET | /s/938313e22323e2939313e24353//;/META-INF/maven/com.atlassian.jira/jira-webapp-dist/pom.properties | 0.000 | 0.000 | 0.000 | 0.000 | | 1 | GET | /config.json | 0.000 | 0.000 | 0.000 | 0.000 | | 1 | GET | /telescope/requests | 0.000 | 0.000 | 0.000 | 0.000 | +-------+--------+-----------------------------------------------------------------------------------------------------+-------+-------+-------+----------+

txxxxc commented 2 months ago 
+-------+--------+------------------------------+-------+-------+-------+----------+
| COUNT | METHOD |             URI              |  MIN  |  AVG  |  MAX  |   SUM    |
+-------+--------+------------------------------+-------+-------+-------+----------+
| 42046 | POST   | ^/api/condition/[\w\d-]+$    | 0.004 | 0.068 | 0.144 | 2863.496 |
| 877   | GET    | ^/api/condition/[\w\d-]+$    | 0.004 | 0.231 | 0.696 | 202.892  |
| 405   | GET    | ^/api/isu/[\w\d-]+/graph$    | 0.004 | 0.245 | 0.776 | 99.392   |
| 176   | GET    | /api/isu                     | 0.004 | 0.375 | 1.000 | 66.032   |
| 266   | GET    | ^/api/isu/[\w\d-]+/icon$     | 0.004 | 0.230 | 0.652 | 61.224   |
| 55    | GET    | /api/trend                   | 0.032 | 0.953 | 1.012 | 52.400   |
| 229   | GET    | ^/api/isu/[\w\d-]+$          | 0.028 | 0.158 | 0.492 | 36.164   |
| 200   | POST   | /api/auth                    | 0.004 | 0.093 | 0.392 | 18.584   |
| 55    | POST   | /api/isu                     | 0.004 | 0.223 | 0.604 | 12.276   |
| 75    | GET    | /api/user/me                 | 0.008 | 0.093 | 0.320 | 6.944    |
| 110   | GET    | /                            | 0.004 | 0.047 | 0.156 | 5.208    |
| 44    | POST   | /api/signout                 | 0.048 | 0.090 | 0.272 | 3.948    |
| 1     | POST   | /initialize                  | 0.308 | 0.308 | 0.308 | 0.308    |
| 18    | GET    | ^/isu/[\w\d-]+/condition$    | 0.000 | 0.001 | 0.004 | 0.016    |
| 6     | GET    | ^/isu/[\w\d-]+/graph$        | 0.000 | 0.001 | 0.004 | 0.008    |
| 3     | GET    | /register                    | 0.000 | 0.001 | 0.004 | 0.004    |
| 6     | GET    | ^/isu/[\w\d-]+$              | 0.000 | 0.001 | 0.004 | 0.004    |
| 58    | GET    | /assets/favicon.d0f5f504.svg | 0.000 | 0.000 | 0.000 | 0.000    |
| 58    | GET    | /assets/index.144d8ca8.css   | 0.000 | 0.000 | 0.000 | 0.000    |
| 58    | GET    | /assets/index.23dac98b.js    | 0.000 | 0.000 | 0.000 | 0.000    |
| 58    | GET    | /assets/logo_white.svg       | 0.000 | 0.000 | 0.000 | 0.000    |
| 57    | GET    | /assets/logo_orange.svg      | 0.000 | 0.000 | 0.000 | 0.000    |
| 58    | GET    | /assets/vendor.ee7444dd.js   | 0.000 | 0.000 | 0.000 | 0.000    |
+-------+--------+------------------------------+-------+-------+-------+----------+
txxxxc commented 2 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)  |
+-------+-----+-------+-----+------+-----+--------+------------------------------+-------+-------+----------+-------+-------+-------+-------+--------+------------+------------+--------------+------------+
| 41701 | 0   | 36131 | 0   | 5570 | 0   | POST   | ^/api/condition/[\w\d-]+$    | 0.004 | 0.156 | 2835.652 | 0.068 | 0.100 | 0.100 | 0.104 | 0.022  | 0.000      | 14.000     | 70.000       | 0.002      |
| 832   | 0   | 731   | 0   | 101  | 0   | GET    | ^/api/condition/[\w\d-]+$    | 0.004 | 0.692 | 196.180  | 0.236 | 0.456 | 0.532 | 0.616 | 0.152  | 0.000      | 7483.000   | 4206056.000  | 5055.356   |
| 403   | 0   | 331   | 0   | 72   | 0   | GET    | ^/api/isu/[\w\d-]+/graph$    | 0.004 | 0.764 | 100.352  | 0.249 | 0.496 | 0.560 | 0.696 | 0.171  | 0.000      | 6875.000   | 1376249.000  | 3415.010   |
| 165   | 0   | 136   | 0   | 29   | 0   | GET    | /api/isu                     | 0.004 | 1.004 | 73.904   | 0.448 | 0.956 | 1.000 | 1.004 | 0.306  | 0.000      | 4654.000   | 392252.000   | 2377.285   |
| 243   | 0   | 201   | 0   | 42   | 0   | GET    | ^/api/isu/[\w\d-]+/icon$     | 0.004 | 0.720 | 56.020   | 0.231 | 0.516 | 0.532 | 0.604 | 0.175  | 14.000     | 135259.000 | 5282733.000  | 21739.642  |
| 52    | 0   | 3     | 0   | 49   | 0   | GET    | /api/trend                   | 0.036 | 1.004 | 49.644   | 0.955 | 1.004 | 1.004 | 1.004 | 0.190  | 0.000      | 4495.000   | 12481.000    | 240.019    |
| 214   | 0   | 172   | 0   | 42   | 0   | GET    | ^/api/isu/[\w\d-]+$          | 0.004 | 0.500 | 34.980   | 0.163 | 0.348 | 0.400 | 0.476 | 0.125  | 14.000     | 151.000    | 24508.000    | 114.523    |
| 197   | 0   | 75    | 0   | 122  | 0   | POST   | /api/auth                    | 0.000 | 0.472 | 17.488   | 0.089 | 0.216 | 0.264 | 0.352 | 0.079  | 0.000      | 19.000     | 1380.000     | 7.005      |
| 55    | 0   | 51    | 0   | 4    | 0   | POST   | /api/isu                     | 0.004 | 0.556 | 12.948   | 0.235 | 0.460 | 0.476 | 0.556 | 0.145  | 15.000     | 151.000    | 7125.000     | 129.545    |
| 68    | 0   | 32    | 0   | 36   | 0   | GET    | /api/user/me                 | 0.004 | 0.300 | 5.720    | 0.084 | 0.204 | 0.256 | 0.300 | 0.077  | 21.000     | 43.000     | 1986.000     | 29.206     |
| 103   | 0   | 87    | 16  | 0    | 0   | GET    | /                            | 0.020 | 0.132 | 4.840    | 0.047 | 0.080 | 0.096 | 0.128 | 0.033  | 0.000      | 528.000    | 45936.000    | 445.981    |
| 40    | 0   | 24    | 0   | 16   | 0   | POST   | /api/signout                 | 0.008 | 0.332 | 4.324    | 0.108 | 0.196 | 0.236 | 0.332 | 0.075  | 21.000     | 21.000     | 336.000      | 8.400      |
| 1     | 0   | 1     | 0   | 0    | 0   | POST   | /initialize                  | 0.496 | 0.496 | 0.496    | 0.496 | 0.496 | 0.496 | 0.496 | 0.000  | 23.000     | 23.000     | 23.000       | 23.000     |
| 18    | 0   | 6     | 12  | 0    | 0   | GET    | ^/isu/[\w\d-]+/condition$    | 0.000 | 0.004 | 0.004    | 0.000 | 0.000 | 0.004 | 0.004 | 0.001  | 0.000      | 528.000    | 3168.000     | 176.000    |
| 3     | 0   | 1     | 2   | 0    | 0   | GET    | /register                    | 0.000 | 0.004 | 0.004    | 0.001 | 0.004 | 0.004 | 0.004 | 0.002  | 0.000      | 528.000    | 528.000      | 176.000    |
| 55    | 0   | 55    | 0   | 0    | 0   | GET    | /assets/vendor.ee7444dd.js   | 0.000 | 0.000 | 0.000    | 0.000 | 0.000 | 0.000 | 0.000 | 0.000  | 743417.000 | 743417.000 | 40887935.000 | 743417.000 |
| 6     | 0   | 6     | 0   | 0    | 0   | GET    | ^/isu/[\w\d-]+/graph$        | 0.000 | 0.000 | 0.000    | 0.000 | 0.000 | 0.000 | 0.000 | 0.000  | 528.000    | 528.000    | 3168.000     | 528.000    |
| 6     | 0   | 6     | 0   | 0    | 0   | GET    | ^/isu/[\w\d-]+$              | 0.000 | 0.000 | 0.000    | 0.000 | 0.000 | 0.000 | 0.000 | 0.000  | 528.000    | 528.000    | 3168.000     | 528.000    |
| 54    | 0   | 54    | 0   | 0    | 0   | GET    | /assets/logo_orange.svg      | 0.000 | 0.000 | 0.000    | 0.000 | 0.000 | 0.000 | 0.000 | 0.000  | 3288.000   | 3288.000   | 177552.000   | 3288.000   |
| 55    | 0   | 55    | 0   | 0    | 0   | GET    | /assets/logo_white.svg       | 0.000 | 0.000 | 0.000    | 0.000 | 0.000 | 0.000 | 0.000 | 0.000  | 3285.000   | 3285.000   | 180675.000   | 3285.000   |
| 55    | 0   | 55    | 0   | 0    | 0   | GET    | /assets/index.23dac98b.js    | 0.000 | 0.000 | 0.000    | 0.000 | 0.000 | 0.000 | 0.000 | 0.000  | 26667.000  | 26667.000  | 1466685.000  | 26667.000  |
| 55    | 0   | 55    | 0   | 0    | 0   | GET    | /assets/favicon.d0f5f504.svg | 0.000 | 0.000 | 0.000    | 0.000 | 0.000 | 0.000 | 0.000 | 0.000  | 592.000    | 592.000    | 32560.000    | 592.000    |
| 55    | 0   | 55    | 0   | 0    | 0   | GET    | /assets/index.144d8ca8.css   | 0.000 | 0.000 | 0.000    | 0.000 | 0.000 | 0.000 | 0.000 | 0.000  | 19066.000  | 19066.000  | 1048630.000  | 19066.000  |
+-------+-----+-------+-----+------+-----+--------+------------------------------+-------+-------+----------+-------+-------+-------+-------+--------+------------+------------+--------------+------------+
txxxxc commented 2 months ago

一旦アクセス制限やってみます

txxxxc commented 2 months ago 
cat logs/nginx/access.log | alp json --sort sum -r -m '^/api/isu/[\w\d-]+$,^/api/isu/[\w\d-]+/icon$,^/api/isu/[\w\d-]+/graph$,^/api/condition/[\w\d-]+$,^/isu/[\w\d-]+/icon$,^/isu/[\w\d-]+/graph$,^/isu/[\w\d-]+$,^/isu/[\w\d-]+/condition$' -o count,method,uri,min,avg,max,sum
+-------+--------+------------------------------+-------+-------+-------+---------+
| COUNT | METHOD |             URI              |  MIN  |  AVG  |  MAX  |   SUM   |
+-------+--------+------------------------------+-------+-------+-------+---------+
| 75623 | POST   | ^/api/condition/[\w\d-]+$    | 0.001 | 0.004 | 0.130 | 336.886 |
| 300   | GET    | /api/trend                   | 0.029 | 0.974 | 1.026 | 292.250 |
| 4754  | GET    | ^/api/condition/[\w\d-]+$    | 0.001 | 0.034 | 0.276 | 160.904 |
| 1443  | GET    | /api/isu                     | 0.042 | 0.106 | 0.409 | 152.459 |
| 1391  | GET    | ^/api/isu/[\w\d-]+/graph$    | 0.014 | 0.042 | 0.221 | 58.671  |
| 2015  | GET    | ^/api/isu/[\w\d-]+/icon$     | 0.003 | 0.026 | 0.108 | 52.997  |
| 1557  | GET    | ^/api/isu/[\w\d-]+$          | 0.001 | 0.021 | 0.095 | 32.167  |
| 1028  | POST   | /api/auth                    | 0.001 | 0.006 | 0.038 | 5.785   |
| 55    | POST   | /api/isu                     | 0.003 | 0.073 | 0.098 | 4.016   |
| 618   | GET    | /api/user/me                 | 0.013 | 0.006 | 0.055 | 3.483   |
| 342   | POST   | /api/signout                 | 0.001 | 0.008 | 0.044 | 2.785   |
| 653   | GET    | /                            | 0.001 | 0.001 | 0.024 | 0.873   |
| 1     | POST   | /initialize                  | 0.139 | 0.139 | 0.139 | 0.139   |
| 303   | GET    | /assets/vendor.ee7444dd.js   | 0.000 | 0.000 | 0.014 | 0.123   |
| 303   | GET    | /assets/favicon.d0f5f504.svg | 0.000 | 0.000 | 0.006 | 0.030   |
| 30    | GET    | ^/isu/[\w\d-]+/condition$    | 0.000 | 0.000 | 0.001 | 0.013   |
| 303   | GET    | /assets/index.144d8ca8.css   | 0.000 | 0.000 | 0.005 | 0.013   |
| 303   | GET    | /assets/index.23dac98b.js    | 0.000 | 0.000 | 0.004 | 0.011   |
| 10    | GET    | ^/isu/[\w\d-]+/graph$        | 0.000 | 0.001 | 0.001 | 0.007   |
| 10    | GET    | ^/isu/[\w\d-]+$              | 0.000 | 0.000 | 0.001 | 0.004   |
| 3     | GET    | /register                    | 0.000 | 0.000 | 0.001 | 0.001   |
| 302   | GET    | /assets/logo_orange.svg      | 0.000 | 0.000 | 0.000 | 0.000   |
| 303   | GET    | /assets/logo_white.svg       | 0.000 | 0.000 | 0.000 | 0.000   |
+-------+--------+------------------------------+-------+-------+-------+---------+
txxxxc commented 2 months ago 
+-------+--------+------------------------------+-------+-------+-------+---------+
| COUNT | METHOD |             URI              |  MIN  |  AVG  |  MAX  |   SUM   |
+-------+--------+------------------------------+-------+-------+-------+---------+
| 415   | GET    | /api/trend                   | 0.018 | 0.940 | 1.008 | 389.945 |
| 75917 | POST   | ^/api/condition/[\w\d-]+$    | 0.003 | 0.003 | 0.176 | 258.243 |
| 1949  | GET    | /api/isu                     | 0.065 | 0.085 | 0.307 | 165.916 |
| 5546  | GET    | ^/api/condition/[\w\d-]+$    | 0.005 | 0.027 | 0.173 | 147.160 |
| 2803  | GET    | ^/api/isu/[\w\d-]+/icon$     | 0.012 | 0.021 | 0.085 | 59.357  |
| 1609  | GET    | ^/api/isu/[\w\d-]+/graph$    | 0.011 | 0.032 | 0.143 | 52.075  |
| 2078  | GET    | ^/api/isu/[\w\d-]+$          | 0.001 | 0.016 | 0.089 | 34.056  |
| 1230  | POST   | /api/auth                    | 0.001 | 0.004 | 0.049 | 5.404   |
| 55    | POST   | /api/isu                     | 0.003 | 0.070 | 0.131 | 3.866   |
| 854   | GET    | /api/user/me                 | 0.010 | 0.004 | 0.038 | 3.780   |
| 464   | POST   | /api/signout                 | 0.004 | 0.007 | 0.028 | 3.083   |
| 890   | GET    | /                            | 0.001 | 0.001 | 0.009 | 0.785   |
| 417   | GET    | /assets/vendor.ee7444dd.js   | 0.000 | 0.000 | 0.012 | 0.145   |
| 1     | POST   | /initialize                  | 0.110 | 0.110 | 0.110 | 0.110   |
| 417   | GET    | /assets/favicon.d0f5f504.svg | 0.000 | 0.000 | 0.008 | 0.025   |
| 417   | GET    | /assets/index.23dac98b.js    | 0.000 | 0.000 | 0.007 | 0.022   |
| 30    | GET    | ^/isu/[\w\d-]+/condition$    | 0.001 | 0.001 | 0.001 | 0.019   |
| 10    | GET    | ^/isu/[\w\d-]+$              | 0.001 | 0.001 | 0.001 | 0.008   |
| 10    | GET    | ^/isu/[\w\d-]+/graph$        | 0.000 | 0.001 | 0.001 | 0.006   |
| 3     | GET    | /register                    | 0.001 | 0.001 | 0.001 | 0.002   |
| 417   | GET    | /assets/index.144d8ca8.css   | 0.000 | 0.000 | 0.000 | 0.000   |
| 417   | GET    | /assets/logo_white.svg       | 0.000 | 0.000 | 0.000 | 0.000   |
| 416   | GET    | /assets/logo_orange.svg      | 0.000 | 0.000 | 0.000 | 0.000   |
+-------+--------+------------------------------+-------+-------+-------+---------+
txxxxc commented 2 months ago 

+-------+--------+------------------------------+-------+-------+-------+---------+
| COUNT | METHOD |             URI              |  MIN  |  AVG  |  MAX  |   SUM   |
+-------+--------+------------------------------+-------+-------+-------+---------+
| 665   | GET    | /api/trend                   | 0.030 | 0.627 | 1.023 | 416.706 |
| 80494 | POST   | ^/api/condition/[\w\d-]+$    | 0.001 | 0.004 | 0.186 | 349.830 |
| 2012  | GET    | /api/isu                     | 0.001 | 0.091 | 0.467 | 183.446 |
| 5723  | GET    | ^/api/condition/[\w\d-]+$    | 0.004 | 0.031 | 0.201 | 180.024 |
| 1877  | GET    | ^/api/isu/[\w\d-]+/graph$    | 0.001 | 0.039 | 0.220 | 73.480  |
| 2288  | GET    | ^/api/isu/[\w\d-]+/icon$     | 0.001 | 0.023 | 0.180 | 53.328  |
| 2108  | GET    | ^/api/isu/[\w\d-]+$          | 0.001 | 0.020 | 0.198 | 41.569  |
| 1144  | POST   | /api/auth                    | 0.001 | 0.005 | 0.195 | 6.158   |
| 60    | POST   | /api/isu                     | 0.002 | 0.075 | 0.282 | 4.516   |
| 806   | GET    | /api/user/me                 | 0.016 | 0.005 | 0.197 | 4.218   |
| 436   | POST   | /api/signout                 | 0.003 | 0.008 | 0.040 | 3.540   |
| 1114  | GET    | /                            | 0.002 | 0.001 | 0.025 | 1.012   |
| 403   | GET    | /assets/vendor.ee7444dd.js   | 0.000 | 0.000 | 0.030 | 0.199   |
| 1     | POST   | /initialize                  | 0.082 | 0.082 | 0.082 | 0.082   |
| 403   | GET    | /assets/favicon.d0f5f504.svg | 0.000 | 0.000 | 0.030 | 0.065   |
| 403   | GET    | /assets/index.23dac98b.js    | 0.000 | 0.000 | 0.010 | 0.016   |
| 403   | GET    | /assets/index.144d8ca8.css   | 0.000 | 0.000 | 0.010 | 0.014   |
| 18    | GET    | ^/isu/[\w\d-]+/condition$    | 0.000 | 0.000 | 0.001 | 0.008   |
| 3     | GET    | /register                    | 0.001 | 0.001 | 0.001 | 0.003   |
| 6     | GET    | ^/isu/[\w\d-]+$              | 0.000 | 0.000 | 0.001 | 0.002   |
| 6     | GET    | ^/isu/[\w\d-]+/graph$        | 0.001 | 0.000 | 0.001 | 0.002   |
| 402   | GET    | /assets/logo_orange.svg      | 0.000 | 0.000 | 0.000 | 0.000   |
| 403   | GET    | /assets/logo_white.svg       | 0.000 | 0.000 | 0.000 | 0.000   |
+-------+--------+------------------------------+-------+-------+-------+---------+
txxxxc commented 2 months ago 
+-------+--------+------------------------------+-------+-------+-------+---------+
| COUNT | METHOD |             URI              |  MIN  |  AVG  |  MAX  |   SUM   |
+-------+--------+------------------------------+-------+-------+-------+---------+
| 949   | GET    | /api/trend                   | 0.023 | 0.756 | 1.003 | 717.729 |
| 87988 | POST   | ^/api/condition/[\w\d-]+$    | 0.002 | 0.005 | 0.127 | 418.423 |
| 6554  | GET    | ^/api/condition/[\w\d-]+$    | 0.014 | 0.038 | 0.197 | 250.883 |
| 2145  | GET    | ^/api/isu/[\w\d-]+/graph$    | 0.001 | 0.049 | 0.169 | 104.372 |
| 2665  | GET    | /api/isu                     | 0.011 | 0.037 | 0.142 | 98.919  |
| 3029  | GET    | ^/api/isu/[\w\d-]+/icon$     | 0.006 | 0.026 | 0.148 | 79.624  |
| 2743  | GET    | ^/api/isu/[\w\d-]+$          | 0.001 | 0.024 | 0.132 | 65.320  |
| 1222  | POST   | /api/auth                    | 0.001 | 0.006 | 0.073 | 7.893   |
| 73    | POST   | /api/isu                     | 0.003 | 0.090 | 0.216 | 6.580   |
| 1023  | GET    | /api/user/me                 | 0.005 | 0.006 | 0.076 | 6.340   |
| 542   | POST   | /api/signout                 | 0.009 | 0.010 | 0.084 | 5.400   |
| 1506  | GET    | /                            | 0.001 | 0.001 | 0.022 | 1.204   |
| 520   | GET    | /assets/vendor.ee7444dd.js   | 0.000 | 0.000 | 0.013 | 0.183   |
| 1     | POST   | /initialize                  | 0.091 | 0.091 | 0.091 | 0.091   |
| 520   | GET    | /assets/favicon.d0f5f504.svg | 0.000 | 0.000 | 0.010 | 0.027   |
| 18    | GET    | ^/isu/[\w\d-]+/condition$    | 0.000 | 0.000 | 0.001 | 0.008   |
| 520   | GET    | /assets/index.23dac98b.js    | 0.000 | 0.000 | 0.002 | 0.006   |
| 520   | GET    | /assets/index.144d8ca8.css   | 0.000 | 0.000 | 0.004 | 0.004   |
| 6     | GET    | ^/isu/[\w\d-]+$              | 0.000 | 0.001 | 0.001 | 0.003   |
| 6     | GET    | ^/isu/[\w\d-]+/graph$        | 0.000 | 0.001 | 0.001 | 0.003   |
| 3     | GET    | /register                    | 0.001 | 0.001 | 0.001 | 0.002   |
| 519   | GET    | /assets/logo_orange.svg      | 0.000 | 0.000 | 0.000 | 0.000   |
| 520   | GET    | /assets/logo_white.svg       | 0.000 | 0.000 | 0.000 | 0.000   |
+-------+--------+------------------------------+-------+-------+-------+---------+