search

saza-ku / isucon13

0 stars 0 forks source link

11250411 #38

Open saza-ku opened 1 year ago

saza-ku commented 1 year ago

isucon1

alp

+-------+--------+------------------------------------------+-------+-------+-------+-------+-------+
| COUNT | METHOD |                   URI                    |  MIN  |  MAX  |  SUM  |  AVG  |  P99  |
+-------+--------+------------------------------------------+-------+-------+-------+-------+-------+
| 12    | GET    | /api/livestream/.+                       | 0.004 | 0.244 | 2.116 | 0.176 | 0.244 |
| 22    | POST   | /api/livestream/.+                       | 0.016 | 0.028 | 0.376 | 0.017 | 0.028 |
| 2     | POST   | /api/register                            | 0.036 | 0.036 | 0.072 | 0.036 | 0.036 |
| 2     | GET    | /api/user/.+/statistics                  | 0.028 | 0.036 | 0.064 | 0.032 | 0.036 |
| 2     | GET    | /api/livestream/.+/statistics            | 0.024 | 0.028 | 0.052 | 0.026 | 0.028 |
| 2     | POST   | /api/livestream/.+/livecomment           | 0.008 | 0.008 | 0.016 | 0.008 | 0.008 |
| 1     | GET    | /api/livestream                          | 0.016 | 0.016 | 0.016 | 0.016 | 0.016 |
| 2     | POST   | /api/livestream/.+/livecomment/.+/report | 0.004 | 0.008 | 0.012 | 0.006 | 0.008 |
| 3     | POST   | /api/livestream/.+/reaction              | 0.004 | 0.004 | 0.012 | 0.004 | 0.004 |
| 5     | POST   | /api/login                               | 0.000 | 0.004 | 0.008 | 0.002 | 0.004 |
| 3     | GET    | /api/tag                                 | 0.004 | 0.004 | 0.004 | 0.001 | 0.004 |
| 3     | GET    | /api/user/.+                             | 0.000 | 0.004 | 0.004 | 0.001 | 0.004 |
| 1     | GET    | /api/user/.+/icon                        | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 |
| 1     | GET    | /api/payment                             | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 2     | POST   | /api/livestream/.+/enter                 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 1     | DELETE | /api/livestream/.+/exit                  | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 1     | GET    | /api/user/.+/theme                       | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 1     | POST   | /api/icon                                | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 1     | GET    | /                                        | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
+-------+--------+------------------------------------------+-------+-------+-------+-------+-------+

slow query

explain

Reading from STDIN ...

# No events processed.

netdata

http://localhost:19991/#menu_services;after=1700885508362;before=1700885584411

pprof

go tool pprof -http=0.0.0.0:1080 http://isucon1/pprof/11250411