search

sunakan / isunarabe13-suburi

0 stars 0 forks source link

分析-29(69448~71202→70091~71812) #37

Open sunakan opened 2 weeks ago

sunakan commented 2 weeks ago

e2faf0d2df9fe9c0114b20c12ff6c447180f1872

sunakan commented 2 weeks ago 
+-------+--------+-----+-----+-----+-----+-----+
| COUNT | METHOD | URI | MIN | AVG | MAX | SUM |
+-------+--------+-----+-----+-----+-----+-----+
+-------+--------+-----+-----+-----+-----+-----+
+-------+--------+---------------------------------+--------+--------+--------+--------+
| COUNT | METHOD |               URI               |  MIN   |  AVG   |  MAX   |  SUM   |
+-------+--------+---------------------------------+--------+--------+--------+--------+
| 5146  | POST   | /api/livestream/\d+/livecomment | 0.004  | 0.010  | 0.128  | 50.159 |
| 3835  | POST   | /api/livestream/\d+/reaction    | 0.004  | 0.009  | 0.144  | 34.021 |
| 587   | POST   | /api/livestream/reservation     | 0.020  | 0.038  | 0.180  | 22.168 |
| 1387  | POST   | /api/register                   | 0.004  | 0.015  | 0.112  | 21.000 |
| 1     | POST   | /api/initialize                 | 14.172 | 14.172 | 14.172 | 14.172 |
| 4193  | GET    | /api/livestream/\d+/livecomment | 0.000  | 0.003  | 0.064  | 12.500 |
| 41551 | GET    | /api/user/\w+/icon              | 0.000  | 0.000  | 0.048  | 12.120 |
| 4224  | GET    | /api/livestream/\d+/reaction    | 0.004  | 0.003  | 0.020  | 11.848 |
| 1121  | POST   | /api/livestream/\d+/moderate    | 0.004  | 0.010  | 0.144  | 10.828 |
| 1807  | GET    | /api/livestream/search          | 0.004  | 0.004  | 0.076  | 8.064  |
| 1435  | POST   | /api/icon                       | 0.004  | 0.003  | 0.048  | 4.828  |
| 2339  | GET    | /api/livestream/\d+/report      | 0.000  | 0.002  | 0.056  | 4.632  |
| 1393  | POST   | /api/login                      | 0.000  | 0.003  | 0.032  | 4.185  |
| 2059  | GET    | /api/livestream                 | 0.000  | 0.002  | 0.048  | 3.624  |
| 365   | DELETE | /api/livestream/\d+/exit        | 0.004  | 0.008  | 0.024  | 3.004  |
| 40    | GET    | /api/user/\w+/statistics        | 0.032  | 0.074  | 0.112  | 2.960  |
| 373   | POST   | /api/livestream/\d+/enter       | 0.004  | 0.008  | 0.032  | 2.937  |
| 1718  | GET    | /api/livestream/\d+/ngwords     | 0.000  | 0.001  | 0.012  | 2.104  |
| 25    | GET    | /api/livestream/\d+/statistics  | 0.040  | 0.076  | 0.108  | 1.912  |
| 600   | GET    | /api/tag                        | 0.004  | 0.002  | 0.012  | 0.992  |
| 40    | GET    | /api/user/\w+/theme             | 0.004  | 0.002  | 0.008  | 0.064  |
| 38    | GET    | /api/user/\w+/livestream        | 0.000  | 0.001  | 0.004  | 0.040  |
| 3     | GET    | /api/user/me                    | 0.000  | 0.001  | 0.004  | 0.004  |
| 1     | GET    | /api/user/test                  | 0.000  | 0.000  | 0.000  | 0.000  |
| 1     | GET    | /api/livestream/\d+             | 0.000  | 0.000  | 0.000  | 0.000  |
| 1     | GET    | /api/payment                    | 0.000  | 0.000  | 0.000  | 0.000  |
+-------+--------+---------------------------------+--------+--------+--------+--------+
+-------+--------+-----+-----+-----+-----+-----+
| COUNT | METHOD | URI | MIN | AVG | MAX | SUM |
+-------+--------+-----+-----+-----+-----+-----+
+-------+--------+-----+-----+-----+-----+-----+
sunakan commented 2 weeks ago 
# Profile
# Rank Query ID                            Response time Calls R/Call V/M
# ==== =================================== ============= ===== ====== ====
#    1 0xF3A502CCF34F7DA288CC1B75AD5AFA37  34.9415 24.0%  5086 0.0069  0.00 INSERT livecomments
#    2 0x5AEB6E4A781A3854CF642125E293FEE0  26.2830 18.1%  3835 0.0069  0.00 INSERT reactions
#    3 0xD2A0864774622BA36F6557496405CF75  14.2656  9.8%  2385 0.0060  0.00 INSERT themes
#    4 0x64052B1C32B30DF53AB3292208B783B4   9.5214  6.5%  1386 0.0069  0.00 INSERT users
#    5 0x0C655718656DD9DDA39A0D11554A0C64   7.8646  5.4%  1121 0.0070  0.00 INSERT ng_words
#    6 0xDFFCC1D78939C4D781C7C58349101F50   5.4639  3.8%  1000 0.0055  0.00 INSERT users
#    7 0xA3401CA3ABCC04C3AB221DB8AD5CBF26   4.2809  2.9%   584 0.0073  0.00 UPDATE reservation_slots
#    8 0x80E10371CE74ED05E09C79C72C73F8E1   4.1740  2.9%   585 0.0071  0.02 INSERT livestreams
#    9 0xCE40BCB2C3669FF89FABA8DF3AB845A1   4.1151  2.8%   585 0.0070  0.00 SELECT reservation_slots
#   10 0x5D469B53C536D19CD15E40763ACC23C7   4.0019  2.7%   579 0.0069  0.01 INSERT livestream_tags
# MISC 0xMISC                              30.6559 21.1% 66716 0.0005   0.0 <57 ITEMS>