search

txxxxc / isucon11-qualify

0 stars 0 forks source link

ボトルネック探す2 #27

Open txxxxc opened 3 months ago

txxxxc commented 3 months ago

alp

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 3 months ago

さすがに/api/trendが遅すぎるので改善するか