Closed soudai closed 3 years ago
# cat /var/log/nginx/access.log | ./alp --sum -r
+-------+--------+-------------------------------+-----+-----+-----+-----+-----+-------+--------+--------+--------+-------+-------+-------+--------+------------+------------+------------+------------+
| COUNT | METHOD | URI | 1XX | 2XX | 3XX | 4XX | 5XX | MIN | MAX | SUM | AVG | P1 | P50 | P99 | STDDEV | MIN(BODY) | MAX(BODY) | SUM(BODY) | AVG(BODY) |
+-------+--------+-------------------------------+-----+-----+-----+-----+-----+-------+--------+--------+--------+-------+-------+-------+--------+------------+------------+------------+------------+
| 2 | GET | /api/train/search | 0 | 1 | 0 | 1 | 0 | 4.997 | 53.290 | 58.287 | 29.143 | 4.997 | 4.997 | 4.997 | 24.146 | 4091.000 | 4091.000 | 4091.000 | 2045.500 |
| 1 | GET | /api/train/seats | 0 | 1 | 0 | 0 | 0 | 0.256 | 0.256 | 0.256 | 0.256 | 0.256 | 0.256 | 0.256 | 0.000 | 6440.000 | 6440.000 | 6440.000 | 6440.000 |
| 1 | POST | /initialize | 0 | 1 | 0 | 0 | 0 | 0.152 | 0.152 | 0.152 | 0.152 | 0.152 | 0.152 | 0.152 | 0.000 | 42.000 | 42.000 | 42.000 | 42.000 |
| 3 | POST | /api/auth/signup | 0 | 3 | 0 | 0 | 0 | 0.028 | 0.040 | 0.100 | 0.033 | 0.028 | 0.028 | 0.032 | 0.005 | 52.000 | 52.000 | 156.000 | 52.000 |
| 4 | POST | /api/auth/login | 0 | 3 | 0 | 1 | 0 | 0.004 | 0.032 | 0.060 | 0.015 | 0.004 | 0.012 | 0.012 | 0.010 | 43.000 | 51.000 | 180.000 | 45.000 |
| 1 | GET | /js/chunk-vendors.2b84179f.js | 0 | 1 | 0 | 0 | 0 | 0.003 | 0.003 | 0.003 | 0.003 | 0.003 | 0.003 | 0.003 | 0.000 | 438711.000 | 438711.000 | 438711.000 | 438711.000 |
| 2 | GET | /api/stations | 0 | 2 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 8304.000 | 8317.000 | 16621.000 | 8310.500 |
| 1 | GET | /js/app.764be8dc.js | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 55412.000 | 55412.000 | 55412.000 | 55412.000 |
| 1 | GET | /css/app.dfe4b820.css | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 13950.000 | 13950.000 | 13950.000 | 13950.000 |
| 1 | GET | /favicon.ico | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 4286.000 | 4286.000 | 4286.000 | 4286.000 |
| 1 | GET | /img/logo.b0efca9a.svg | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 2505.000 | 2505.000 | 2505.000 | 2505.000 |
| 1 | GET | /index.html | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 414.000 | 414.000 | 414.000 | 414.000 |
+-------+--------+-------------------------------+-----+-----+-----+-----+-----+-------+--------+--------+--------+-------+-------+-------+--------+------------+------------+------------+------------+
Ruby実装に切り替えた。
# cat /var/log/nginx/access.log | ./alp --sum -r
+-------+--------+-------------------------------+-----+-----+-----+-----+-----+-------+-------+-------+-------+-------+-------+-------+--------+------------+------------+------------+------------+
| COUNT | METHOD | URI | 1XX | 2XX | 3XX | 4XX | 5XX | MIN | MAX | SUM | AVG | P1 | P50 | P99 | STDDEV | MIN(BODY) | MAX(BODY) | SUM(BODY) | AVG(BODY) |
+-------+--------+-------------------------------+-----+-----+-----+-----+-----+-------+-------+-------+-------+-------+-------+-------+--------+------------+------------+------------+------------+
| 1 | GET | /api/train/search | 0 | 0 | 0 | 1 | 0 | 4.998 | 4.998 | 4.998 | 4.998 | 4.998 | 4.998 | 4.998 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 1 | GET | /api/train/seats | 0 | 1 | 0 | 0 | 0 | 0.204 | 0.204 | 0.204 | 0.204 | 0.204 | 0.204 | 0.204 | 0.000 | 6421.000 | 6421.000 | 6421.000 | 6421.000 |
| 3 | POST | /api/auth/login | 0 | 3 | 0 | 0 | 0 | 0.048 | 0.048 | 0.144 | 0.048 | 0.048 | 0.048 | 0.048 | 0.000 | 43.000 | 43.000 | 129.000 | 43.000 |
| 1 | POST | /initialize | 0 | 1 | 0 | 0 | 0 | 0.088 | 0.088 | 0.088 | 0.088 | 0.088 | 0.088 | 0.088 | 0.000 | 39.000 | 39.000 | 39.000 | 39.000 |
| 3 | POST | /api/auth/signup | 0 | 3 | 0 | 0 | 0 | 0.016 | 0.020 | 0.052 | 0.017 | 0.016 | 0.016 | 0.016 | 0.002 | 52.000 | 52.000 | 156.000 | 52.000 |
| 1 | GET | /api/stations | 0 | 1 | 0 | 0 | 0 | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 | 0.000 | 8303.000 | 8303.000 | 8303.000 | 8303.000 |
| 1 | GET | /js/chunk-vendors.2b84179f.js | 0 | 1 | 0 | 0 | 0 | 0.003 | 0.003 | 0.003 | 0.003 | 0.003 | 0.003 | 0.003 | 0.000 | 438711.000 | 438711.000 | 438711.000 | 438711.000 |
| 1 | GET | /css/app.dfe4b820.css | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 13950.000 | 13950.000 | 13950.000 | 13950.000 |
| 1 | GET | /favicon.ico | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 4286.000 | 4286.000 | 4286.000 | 4286.000 |
| 1 | GET | /img/logo.b0efca9a.svg | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 2505.000 | 2505.000 | 2505.000 | 2505.000 |
| 1 | GET | /index.html | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 414.000 | 414.000 | 414.000 | 414.000 |
| 1 | GET | /js/app.764be8dc.js | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 55412.000 | 55412.000 | 55412.000 | 55412.000 |
+-------+--------+-------------------------------+-----+-----+-----+-----+-----+-------+-------+-------+-------+-------+-------+-------+--------+------------+------------+------------+------------+
MySQLにインデックスを追加した
k# cat /var/log/nginx/access.log | ./alp --aggregates="/api/user/reservations/.*" --sum -r
+-------+--------+-------------------------------+-----+-----+-----+-----+-----+-------+-------+--------+-------+-------+-------+-------+--------+-----------+------------+------------+------------+
| COUNT | METHOD | URI | 1XX | 2XX | 3XX | 4XX | 5XX | MIN | MAX | SUM | AVG | P1 | P50 | P99 | STDDEV | MIN(BODY) | MAX(BODY) | SUM(BODY) | AVG(BODY) |
+-------+--------+-------------------------------+-----+-----+-----+-----+-----+-------+-------+--------+-------+-------+-------+-------+--------+-----------+------------+------------+------------+
| 79 | POST | /api/train/reserve | 0 | 46 | 0 | 33 | 0 | 0.040 | 2.956 | 67.360 | 0.853 | 0.092 | 1.388 | 0.158 | 0.704 | 50.000 | 174.000 | 4497.000 | 56.924 |
| 22 | GET | /api/train/search | 0 | 17 | 0 | 5 | 0 | 0.256 | 5.001 | 58.331 | 2.651 | 0.336 | 3.196 | 2.996 | 1.683 | 4091.000 | 4144.000 | 63820.000 | 2900.909 |
| 43 | GET | /api/train/seats | 0 | 43 | 0 | 0 | 0 | 0.124 | 1.361 | 22.129 | 0.515 | 0.240 | 0.212 | 1.361 | 0.372 | 6360.000 | 7653.000 | 280007.000 | 6511.791 |
| 6 | POST | /api/user/reservations/.* | 0 | 3 | 0 | 3 | 0 | 0.000 | 1.528 | 3.568 | 0.595 | 1.020 | 0.004 | 0.000 | 0.617 | 47.000 | 48.000 | 285.000 | 47.500 |
| 9 | POST | /api/train/reservation/commit | 0 | 9 | 0 | 0 | 0 | 0.012 | 0.356 | 0.528 | 0.059 | 0.076 | 0.356 | 0.012 | 0.107 | 14.000 | 14.000 | 126.000 | 14.000 |
| 65 | GET | /api/user/reservations/.* | 0 | 62 | 0 | 3 | 0 | 0.004 | 0.016 | 0.484 | 0.007 | 0.008 | 0.008 | 0.004 | 0.003 | 51.000 | 407.000 | 24989.000 | 384.446 |
| 30 | POST | /api/auth/signup | 0 | 30 | 0 | 0 | 0 | 0.004 | 0.016 | 0.212 | 0.007 | 0.008 | 0.008 | 0.004 | 0.003 | 52.000 | 52.000 | 1560.000 | 52.000 |
| 20 | GET | /api/user/reservations | 0 | 20 | 0 | 0 | 0 | 0.004 | 0.012 | 0.168 | 0.008 | 0.008 | 0.012 | 0.008 | 0.003 | 2.000 | 409.000 | 6446.000 | 322.300 |
| 31 | POST | /api/auth/login | 0 | 30 | 0 | 1 | 0 | 0.008 | 0.008 | 0.096 | 0.003 | 0.000 | 0.004 | 0.000 | 0.002 | 43.000 | 51.000 | 1341.000 | 43.258 |
| 1 | POST | /initialize | 0 | 1 | 0 | 0 | 0 | 0.088 | 0.088 | 0.088 | 0.088 | 0.088 | 0.088 | 0.088 | 0.000 | 39.000 | 39.000 | 39.000 | 39.000 |
| 18 | GET | /api/stations | 0 | 18 | 0 | 0 | 0 | 0.000 | 0.008 | 0.048 | 0.003 | 0.008 | 0.004 | 0.000 | 0.003 | 8303.000 | 8303.000 | 149454.000 | 8303.000 |
| 2 | GET | /js/chunk-vendors.2b84179f.js | 0 | 1 | 1 | 0 | 0 | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 | 0.004 | 0.004 | 0.002 | 0.000 | 438711.000 | 438711.000 | 219355.500 |
| 1 | GET | /api/auth | 0 | 0 | 0 | 1 | 0 | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 | 0.000 | 40.000 | 40.000 | 40.000 | 40.000 |
| 8 | POST | /api/auth/logout | 0 | 8 | 0 | 0 | 0 | 0.000 | 0.004 | 0.004 | 0.001 | 0.000 | 0.000 | 0.000 | 0.001 | 41.000 | 41.000 | 328.000 | 41.000 |
| 2 | GET | /js/app.764be8dc.js | 0 | 1 | 1 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 55412.000 | 55412.000 | 27706.000 |
| 2 | GET | /img/logo.b0efca9a.svg | 0 | 1 | 1 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 2505.000 | 2505.000 | 1252.500 |
| 2 | GET | /favicon.ico | 0 | 1 | 1 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 4286.000 | 4286.000 | 2143.000 |
| 1 | GET | /css/app.dfe4b820.css | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 13950.000 | 13950.000 | 13950.000 | 13950.000 |
| 1 | GET | /reservation | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 402.000 | 402.000 | 402.000 | 402.000 |
| 1 | GET | /index.html | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 414.000 | 414.000 | 414.000 | 414.000 |
| 1 | GET | /api/settings | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 56.000 | 56.000 | 56.000 | 56.000 |
+-------+--------+-------------------------------+-----+-----+-----+-----+-----+-------+-------+--------+-------+-------+-------+-------+--------+-----------+------------+------------+------------+
アスタでまとめたやつ
/api/user/reservations/29
180で失敗した時
# cat /var/log/nginx/access.log.20191005_125823 | ./alp --aggregates="/api/user/reservations/.*" --sum -r
+-------+--------+-------------------------------+-----+-----+-----+-----+-----+-------+-------+---------+-------+-------+-------+-------+--------+------------+------------+-------------+------------+
| COUNT | METHOD | URI | 1XX | 2XX | 3XX | 4XX | 5XX | MIN | MAX | SUM | AVG | P1 | P50 | P99 | STDDEV | MIN(BODY) | MAX(BODY) | SUM(BODY) | AVG(BODY) |
+-------+--------+-------------------------------+-----+-----+-----+-----+-----+-------+-------+---------+-------+-------+-------+-------+--------+------------+------------+-------------+------------+
| 200 | POST | /api/train/reserve | 0 | 82 | 0 | 109 | 9 | 0.004 | 5.081 | 198.563 | 0.993 | 0.008 | 0.076 | 2.759 | 1.603 | 0.000 | 174.000 | 13047.000 | 65.235 |
| 123 | GET | /api/train/search | 0 | 118 | 0 | 5 | 0 | 0.004 | 5.002 | 162.985 | 1.325 | 0.332 | 0.952 | 2.016 | 0.941 | 4070.000 | 4186.000 | 439008.000 | 3569.171 |
| 59 | GET | /api/train/seats | 0 | 58 | 0 | 1 | 0 | 0.052 | 4.993 | 42.410 | 0.719 | 0.076 | 0.828 | 4.993 | 1.006 | 6378.000 | 9865.000 | 393613.000 | 6671.407 |
| 54 | POST | /api/train/reservation/commit | 0 | 54 | 0 | 0 | 0 | 0.012 | 2.500 | 18.360 | 0.340 | 0.136 | 0.080 | 2.500 | 0.520 | 14.000 | 14.000 | 756.000 | 14.000 |
| 13 | POST | /api/user/reservations/.* | 0 | 6 | 0 | 7 | 0 | 0.000 | 5.000 | 18.036 | 1.387 | 1.016 | 2.212 | 0.004 | 1.684 | 48.000 | 48.000 | 570.000 | 43.846 |
| 133 | POST | /api/auth/signup | 0 | 133 | 0 | 0 | 0 | 0.004 | 1.192 | 9.612 | 0.072 | 0.020 | 0.004 | 0.368 | 0.183 | 52.000 | 52.000 | 6916.000 | 52.000 |
| 198 | GET | /api/stations | 0 | 198 | 0 | 0 | 0 | 0.004 | 1.476 | 3.296 | 0.017 | 0.004 | 0.000 | 0.008 | 0.106 | 8303.000 | 8303.000 | 1643994.000 | 8303.000 |
| 133 | POST | /api/auth/login | 0 | 132 | 0 | 1 | 0 | 0.004 | 0.112 | 1.504 | 0.011 | 0.000 | 0.004 | 0.020 | 0.022 | 43.000 | 51.000 | 5727.000 | 43.060 |
| 155 | GET | /api/user/reservations/.* | 0 | 149 | 0 | 6 | 0 | 0.004 | 0.128 | 1.456 | 0.009 | 0.004 | 0.016 | 0.008 | 0.012 | 51.000 | 680.000 | 79234.000 | 511.187 |
| 74 | GET | /api/user/reservations | 0 | 74 | 0 | 0 | 0 | 0.004 | 0.032 | 0.744 | 0.010 | 0.004 | 0.024 | 0.008 | 0.007 | 2.000 | 682.000 | 37009.000 | 500.122 |
| 1 | POST | /initialize | 0 | 1 | 0 | 0 | 0 | 0.076 | 0.076 | 0.076 | 0.076 | 0.076 | 0.076 | 0.076 | 0.000 | 40.000 | 40.000 | 40.000 | 40.000 |
| 18 | POST | /api/auth/logout | 0 | 18 | 0 | 0 | 0 | 0.000 | 0.004 | 0.028 | 0.002 | 0.000 | 0.004 | 0.004 | 0.002 | 41.000 | 41.000 | 738.000 | 41.000 |
| 1 | GET | /js/chunk-vendors.2b84179f.js | 0 | 1 | 0 | 0 | 0 | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 | 0.000 | 438711.000 | 438711.000 | 438711.000 | 438711.000 |
| 1 | GET | /js/app.764be8dc.js | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 55412.000 | 55412.000 | 55412.000 | 55412.000 |
| 1 | GET | /index.html | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 414.000 | 414.000 | 414.000 | 414.000 |
| 1 | GET | /img/logo.b0efca9a.svg | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 2505.000 | 2505.000 | 2505.000 | 2505.000 |
| 1 | GET | /favicon.ico | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 4286.000 | 4286.000 | 4286.000 | 4286.000 |
| 1 | GET | /css/app.dfe4b820.css | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 13950.000 | 13950.000 | 13950.000 | 13950.000 |
+-------+--------+-------------------------------+-----+-----+-----+-----+-----+-------+-------+---------+-------+-------+-------+-------+--------+------------+------------+-------------+------------+
90のとき
k# cat /var/log/nginx/access.log | ./alp --aggregates="/api/user/reservations/.*" --sum -r
+-------+--------+-------------------------------+-----+-----+-----+-----+-----+-------+-------+--------+-------+-------+-------+-------+--------+------------+------------+-------------+------------+
| COUNT | METHOD | URI | 1XX | 2XX | 3XX | 4XX | 5XX | MIN | MAX | SUM | AVG | P1 | P50 | P99 | STDDEV | MIN(BODY) | MAX(BODY) | SUM(BODY) | AVG(BODY) |
+-------+--------+-------------------------------+-----+-----+-----+-----+-----+-------+-------+--------+-------+-------+-------+-------+--------+------------+------------+-------------+------------+
| 406 | POST | /api/train/reserve | 0 | 147 | 0 | 258 | 1 | 0.004 | 2.028 | 95.367 | 0.235 | 0.008 | 0.064 | 0.036 | 0.419 | 0.000 | 174.000 | 33030.000 | 81.355 |
| 145 | GET | /api/train/search | 0 | 144 | 0 | 1 | 0 | 0.208 | 0.984 | 91.179 | 0.629 | 0.248 | 0.872 | 0.240 | 0.206 | 57.000 | 4206.000 | 576792.000 | 3977.876 |
| 151 | GET | /api/train/seats | 0 | 150 | 0 | 0 | 1 | 0.052 | 3.752 | 56.197 | 0.372 | 0.088 | 0.120 | 0.056 | 0.706 | 68.000 | 9425.000 | 1046432.000 | 6930.013 |
| 46 | POST | /api/user/reservations/.* | 0 | 24 | 0 | 22 | 0 | 0.000 | 3.704 | 33.164 | 0.721 | 1.016 | 0.004 | 1.012 | 0.833 | 47.000 | 48.000 | 2184.000 | 47.478 |
| 68 | POST | /api/train/reservation/commit | 0 | 68 | 0 | 0 | 0 | 0.008 | 1.196 | 3.720 | 0.055 | 0.020 | 0.008 | 0.016 | 0.190 | 14.000 | 14.000 | 952.000 | 14.000 |
| 308 | GET | /api/user/reservations/.* | 0 | 284 | 0 | 24 | 0 | 0.004 | 0.100 | 2.184 | 0.007 | 0.004 | 0.004 | 0.004 | 0.007 | 51.000 | 412.000 | 115287.000 | 374.308 |
| 214 | POST | /api/auth/signup | 0 | 214 | 0 | 0 | 0 | 0.004 | 0.024 | 1.336 | 0.006 | 0.012 | 0.008 | 0.004 | 0.004 | 52.000 | 52.000 | 11128.000 | 52.000 |
| 161 | GET | /api/user/reservations | 0 | 161 | 0 | 0 | 0 | 0.004 | 0.024 | 0.968 | 0.006 | 0.004 | 0.008 | 0.004 | 0.004 | 2.000 | 413.000 | 55371.000 | 343.919 |
| 216 | POST | /api/auth/login | 0 | 214 | 0 | 2 | 0 | 0.000 | 0.224 | 0.820 | 0.004 | 0.008 | 0.004 | 0.000 | 0.015 | 43.000 | 51.000 | 9304.000 | 43.074 |
| 117 | GET | /api/stations | 0 | 117 | 0 | 0 | 0 | 0.004 | 0.012 | 0.400 | 0.003 | 0.008 | 0.000 | 0.000 | 0.003 | 8303.000 | 8303.000 | 971451.000 | 8303.000 |
| 68 | POST | /api/auth/logout | 0 | 68 | 0 | 0 | 0 | 0.004 | 0.008 | 0.092 | 0.001 | 0.000 | 0.000 | 0.000 | 0.002 | 41.000 | 41.000 | 2788.000 | 41.000 |
| 1 | POST | /initialize | 0 | 1 | 0 | 0 | 0 | 0.072 | 0.072 | 0.072 | 0.072 | 0.072 | 0.072 | 0.072 | 0.000 | 39.000 | 39.000 | 39.000 | 39.000 |
| 1 | GET | /js/chunk-vendors.2b84179f.js | 0 | 1 | 0 | 0 | 0 | 0.003 | 0.003 | 0.003 | 0.003 | 0.003 | 0.003 | 0.003 | 0.000 | 438711.000 | 438711.000 | 438711.000 | 438711.000 |
| 1 | GET | /index.html | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 414.000 | 414.000 | 414.000 | 414.000 |
| 1 | GET | /img/logo.b0efca9a.svg | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 2505.000 | 2505.000 | 2505.000 | 2505.000 |
| 1 | GET | /favicon.ico | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 4286.000 | 4286.000 | 4286.000 | 4286.000 |
| 1 | GET | /css/app.dfe4b820.css | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 13950.000 | 13950.000 | 13950.000 | 13950.000 |
| 1 | GET | /js/app.764be8dc.js | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 55412.000 | 55412.000 | 55412.000 | 55412.000 |
+-------+--------+-------------------------------+-----+-----+-----+-----+-----+-------+-------+--------+-------+-------+-------+-------+--------+------------+------------+-------------+------------+
# cat /var/log/nginx/access.log | ./alp --aggregates="/api/user/reservations/.*" --sum -r
root@team067-c:~/work# cat /var/log/nginx/access.log | ./alp --aggregates="/api/user/reservations/.*" --sum -r
+-------+--------+-------------------------------+-----+-----+-----+-----+-----+-------+-------+---------+-------+-------+-------+-------+--------+------------+------------+-------------+------------+
| COUNT | METHOD | URI | 1XX | 2XX | 3XX | 4XX | 5XX | MIN | MAX | SUM | AVG | P1 | P50 | P99 | STDDEV | MIN(BODY) | MAX(BODY) | SUM(BODY) | AVG(BODY) |
+-------+--------+-------------------------------+-----+-----+-----+-----+-----+-------+-------+---------+-------+-------+-------+-------+--------+------------+------------+-------------+------------+
| 67 | POST | /api/user/reservations/.* | 0 | 60 | 0 | 7 | 0 | 0.671 | 4.000 | 203.267 | 3.034 | 1.016 | 2.985 | 2.666 | 1.167 | 0.000 | 48.000 | 3012.000 | 44.955 |
| 341 | GET | /api/train/search | 0 | 161 | 0 | 1 | 179 | 0.004 | 0.376 | 33.492 | 0.098 | 0.136 | 0.152 | 0.004 | 0.111 | 57.000 | 4219.000 | 663986.000 | 1947.173 |
| 273 | POST | /api/train/reserve | 0 | 169 | 0 | 103 | 1 | 0.032 | 0.280 | 12.269 | 0.045 | 0.004 | 0.040 | 0.032 | 0.045 | 47.000 | 174.000 | 20385.000 | 74.670 |
| 70 | GET | /api/train/seats | 0 | 70 | 0 | 0 | 0 | 0.036 | 0.260 | 5.856 | 0.084 | 0.120 | 0.176 | 0.048 | 0.049 | 6358.000 | 9865.000 | 479699.000 | 6852.843 |
| 120 | POST | /api/train/reservation/commit | 0 | 120 | 0 | 0 | 0 | 0.008 | 0.100 | 1.676 | 0.014 | 0.020 | 0.012 | 0.008 | 0.013 | 14.000 | 14.000 | 1680.000 | 14.000 |
| 250 | POST | /api/auth/signup | 0 | 250 | 0 | 0 | 0 | 0.004 | 0.024 | 1.292 | 0.005 | 0.012 | 0.004 | 0.004 | 0.003 | 52.000 | 52.000 | 13000.000 | 52.000 |
| 368 | GET | /api/user/reservations/.* | 0 | 308 | 0 | 60 | 0 | 0.004 | 0.012 | 1.164 | 0.003 | 0.004 | 0.004 | 0.000 | 0.002 | 51.000 | 680.000 | 183594.000 | 498.897 |
| 199 | GET | /api/user/reservations | 0 | 199 | 0 | 0 | 0 | 0.004 | 0.020 | 1.148 | 0.006 | 0.004 | 0.000 | 0.004 | 0.004 | 2.000 | 6049.000 | 329465.000 | 1655.603 |
| 492 | GET | /api/stations | 0 | 492 | 0 | 0 | 0 | 0.000 | 0.008 | 1.124 | 0.002 | 0.004 | 0.004 | 0.004 | 0.002 | 8303.000 | 8303.000 | 4085076.000 | 8303.000 |
| 251 | POST | /api/auth/login | 0 | 250 | 0 | 1 | 0 | 0.004 | 0.008 | 0.640 | 0.003 | 0.004 | 0.000 | 0.004 | 0.002 | 43.000 | 51.000 | 10801.000 | 43.032 |
| 1 | POST | /initialize | 0 | 1 | 0 | 0 | 0 | 0.072 | 0.072 | 0.072 | 0.072 | 0.072 | 0.072 | 0.072 | 0.000 | 40.000 | 40.000 | 40.000 | 40.000 |
| 22 | POST | /api/auth/logout | 0 | 22 | 0 | 0 | 0 | 0.000 | 0.004 | 0.016 | 0.001 | 0.000 | 0.000 | 0.000 | 0.002 | 41.000 | 41.000 | 902.000 | 41.000 |
| 1 | GET | /js/chunk-vendors.2b84179f.js | 0 | 1 | 0 | 0 | 0 | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 | 0.000 | 438711.000 | 438711.000 | 438711.000 | 438711.000 |
| 1 | GET | /js/app.764be8dc.js | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 55412.000 | 55412.000 | 55412.000 | 55412.000 |
| 1 | GET | /index.html | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 414.000 | 414.000 | 414.000 | 414.000 |
| 1 | GET | /img/logo.b0efca9a.svg | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 2505.000 | 2505.000 | 2505.000 | 2505.000 |
| 1 | GET | /favicon.ico | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 4286.000 | 4286.000 | 4286.000 | 4286.000 |
| 1 | GET | /css/app.dfe4b820.css | 0 | 1 | 0 | 0 | 0 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 13950.000 | 13950.000 | 13950.000 | 13950.000 |
+-------+--------+-------------------------------+-----+-----+-----+-----+-----+-------+-------+---------+-------+-------+-------+-------+--------+------------+------------+-------------+------------+
やること
# wget https://github.com/tkuchiki/alp/releases/download/v0.4.0/alp_linux_amd64.zip
sudo install ./alp /usr/local/bin
cat /var/log/h2o/access.log | ./alp --aggregates="/api/users/.*","/api/events/.*" --sum -r
h2o
nginx