search

illmaticindustries / isucon13

0 stars 0 forks source link

1330 #25

Open tagty opened 11 months ago

tagty commented 11 months ago

6,676

+-------+--------+--------------------------------------------------+--------+--------+---------+--------+--------+
| COUNT | METHOD |                       URI                        |  MIN   |  MAX   |   SUM   |  AVG   |  P99   |
+-------+--------+--------------------------------------------------+--------+--------+---------+--------+--------+
| 3190  | GET    | /api/user/[0-9a-zA-Z]+/icon                      | 0.004  | 0.716  | 178.436 | 0.056  | 0.352  |
| 41    | POST   | /api/livestream/[0-9]+                           | 0.636  | 11.496 | 112.044 | 2.733  | 11.496 |
| 7     | GET    | /api/user/[0-9a-zA-Z]+/statistics                | 4.032  | 20.000 | 108.104 | 15.443 | 20.000 |
| 399   | GET    | /api/livestream/[0-9]+/livecomment               | 0.004  | 1.172  | 105.968 | 0.266  | 0.888  |
| 433   | GET    | /api/livestream/[0-9]+/reaction                  | 0.004  | 1.268  | 100.080 | 0.231  | 0.796  |
| 71    | GET    | /api/livestream/search                           | 0.160  | 2.624  | 66.668  | 0.939  | 2.624  |
| 293   | POST   | /api/register                                    | 0.004  | 1.016  | 58.232  | 0.199  | 0.596  |
| 395   | POST   | /api/livestream/[0-9]+/livecomment               | 0.008  | 0.608  | 47.380  | 0.120  | 0.492  |
| 157   | POST   | /api/livestream/reservation                      | 0.068  | 0.752  | 45.696  | 0.291  | 0.680  |
| 375   | POST   | /api/livestream/[0-9]+/reaction                  | 0.012  | 0.584  | 34.604  | 0.092  | 0.424  |
| 296   | POST   | /api/icon                                        | 0.012  | 0.652  | 28.576  | 0.097  | 0.408  |
| 3     | GET    | /api/livestream/[0-9]+                           | 0.008  | 11.756 | 23.468  | 7.823  | 11.756 |
| 298   | POST   | /api/login                                       | 0.004  | 0.736  | 15.424  | 0.052  | 0.336  |
| 1     | POST   | /api/initialize                                  | 12.652 | 12.652 | 12.652  | 12.652 | 12.652 |
| 137   | GET    | /api/tag                                         | 0.004  | 0.292  | 7.684   | 0.056  | 0.260  |
| 52    | POST   | /api/livestream/[0-9]+/livecomment/[0-9]+/report | 0.012  | 0.740  | 7.224   | 0.139  | 0.740  |
| 68    | GET    | /api/livestream                                  | 0.004  | 0.388  | 5.624   | 0.083  | 0.388  |
| 48    | GET    | /api/livestream/[0-9]+/ngwords                   | 0.008  | 0.572  | 4.828   | 0.101  | 0.572  |
| 62    | GET    | /api/livestream/[0-9]+/report                    | 0.004  | 0.272  | 3.364   | 0.054  | 0.272  |
| 38    | POST   | /api/livestream/[0-9]+/enter                     | 0.008  | 0.340  | 3.120   | 0.082  | 0.340  |
| 28    | DELETE | /api/livestream/[0-9]+/exit                      | 0.008  | 0.388  | 1.492   | 0.053  | 0.388  |
| 6     | GET    | /api/user/[0-9a-zA-Z]+/theme                     | 0.004  | 0.056  | 0.124   | 0.021  | 0.056  |
| 3     | GET    | /api/user/me                                     | 0.004  | 0.016  | 0.024   | 0.008  | 0.016  |
| 1     | GET    | /api/user/test                                   | 0.020  | 0.020  | 0.020   | 0.020  | 0.020  |
| 1     | GET    | /api/payment                                     | 0.012  | 0.012  | 0.012   | 0.012  | 0.012  |
+-------+--------+--------------------------------------------------+--------+--------+---------+--------+--------+
# Profile
# Rank Query ID                      Response time Calls R/Call V/M   Item
# ==== ============================= ============= ===== ====== ===== ====
#    1 0x42EF7D7D98FBCC9723BF896E... 75.1379 50.0% 21348 0.0035  0.00 SELECT records
#    2 0x3D83BC87F3B3A00D571FFC81... 49.4764 32.9% 14809 0.0033  0.00 SELECT records
#    3 0x22279D81D51006139E0C7640... 10.2794  6.8% 26642 0.0004  0.00 SELECT domains domainmetadata
#    4 0x8F7679D452333ED3C7D60D22...  7.6614  5.1% 64372 0.0001  0.00 ADMIN RESET STMT
#    5 0x859BBB7E9D760686137A9444...  2.8036  1.9%   291 0.0096  0.00 DELETE records
#    6 0xFFFCA4D67EA0A788813031B8...  2.1563  1.4%   292 0.0074  0.00 COMMIT
#    7 0x9AC623FA477E73A44D191D29...  1.8792  1.3%   582 0.0032  0.00 SELECT records
#    8 0xDA556F9115773A1A99AA0165...  0.3679  0.2%  1759 0.0002  0.00 ADMIN PREPARE
#    9 0x77FB9E134D073862D1E78FEE...  0.2912  0.2%  1571 0.0002  0.00 INSERT records
#   10 0xB9AC05A7AE6C4E30B5B45F6F...  0.1161  0.1%   587 0.0002  0.00 SET
# MISC 0xMISC                         0.1151  0.1%  2768 0.0000   0.0 <5 ITEMS>
# Profile
# Rank Query ID                     Response time Calls  R/Call V/M   Item
# ==== ============================ ============= ====== ====== ===== ====
#    1 0x84B457C910C4A79FC9EBECB... 51.4403 20.6%  19214 0.0027  0.01 SELECT icons
#    2 0xF1B8EF06D6CA63B24BFF433... 40.5888 16.3%   5138 0.0079  0.01 SELECT users livestreams livecomments
#    3 0xDB74D52D39A7090F224C4DE... 38.5054 15.5%   5141 0.0075  0.01 SELECT users livestreams reactions
#    4 0xDA556F9115773A1A99AA016... 20.7856  8.3% 231260 0.0001  0.00 ADMIN PREPARE
#    5 0x59F1B6DD8D9FEC059E55B3B... 17.2065  6.9%   1415 0.0122  0.00 SELECT reservation_slots
#    6 0x38BC86A45F31C6B1EE32467... 11.1543  4.5%  16032 0.0007  0.00 SELECT themes
#    7 0xFFFCA4D67EA0A788813031B...  9.7757  3.9%   3176 0.0031  0.01 COMMIT
#    8 0x64CC8A4E8E4B39020337559...  8.6721  3.5%    394 0.0220  0.00 SELECT ng_words
#    9 0x4ADE2DC90689F1C4891749A...  6.0221  2.4%  70001 0.0001  0.00 DELETE SELECT livecomments
#   10 0xDFFCC1D78939C4D781C7C58...  4.7315  1.9%   1000 0.0047  0.00 INSERT users
# MISC 0xMISC                       40.2670 16.2% 356203 0.0001   0.0 <73 ITEMS>
tagty commented 11 months ago

isupipe cpu.pdf