saza-ku
commented
1 year ago isucon1
alp
+-------+--------+--------------------+--------+--------+---------+--------+--------+
| COUNT | METHOD | URI | MIN | MAX | SUM | AVG | P99 |
+-------+--------+--------------------+--------+--------+---------+--------+--------+
| 61 | GET | / | 1.820 | 10.000 | 545.732 | 8.946 | 10.000 |
| 1 | GET | /posts | 10.000 | 10.000 | 10.000 | 10.000 | 10.000 |
| 1 | GET | /@zelma | 8.796 | 8.796 | 8.796 | 8.796 | 8.796 |
| 1 | GET | /@leila | 8.704 | 8.704 | 8.704 | 8.704 | 8.704 |
| 1 | GET | /@juliet | 6.800 | 6.800 | 6.800 | 6.800 | 6.800 |
| 1 | GET | /@mara | 6.752 | 6.752 | 6.752 | 6.752 | 6.752 |
| 1 | GET | /@ofelia | 5.856 | 5.856 | 5.856 | 5.856 | 5.856 |
| 1 | GET | /@brandie | 5.812 | 5.812 | 5.812 | 5.812 | 5.812 |
| 1 | GET | /@lucinda | 5.680 | 5.680 | 5.680 | 5.680 | 5.680 |
| 1 | GET | /@kaitlin | 5.412 | 5.412 | 5.412 | 5.412 | 5.412 |
| 1 | GET | /@dolly | 5.064 | 5.064 | 5.064 | 5.064 | 5.064 |
| 1 | GET | /@gayle | 5.036 | 5.036 | 5.036 | 5.036 | 5.036 |
| 1 | GET | /@annabelle | 5.032 | 5.032 | 5.032 | 5.032 | 5.032 |
| 1 | GET | /@belinda | 4.964 | 4.964 | 4.964 | 4.964 | 4.964 |
| 1 | GET | /@georgette | 3.988 | 3.988 | 3.988 | 3.988 | 3.988 |
| 58 | POST | /login | 0.012 | 0.376 | 2.600 | 0.045 | 0.376 |
| 1 | GET | /@kim | 2.272 | 2.272 | 2.272 | 2.272 | 2.272 |
| 1 | GET | /@karyn | 1.028 | 1.028 | 1.028 | 1.028 | 1.028 |
| 1 | GET | /posts/10002 | 0.664 | 0.664 | 0.664 | 0.664 | 0.664 |
| 1 | GET | /posts/8806 | 0.644 | 0.644 | 0.644 | 0.644 | 0.644 |
| 1 | GET | /posts/3316 | 0.540 | 0.540 | 0.540 | 0.540 | 0.540 |
| 1 | GET | /posts/7375 | 0.528 | 0.528 | 0.528 | 0.528 | 0.528 |
| 1 | GET | /posts/692 | 0.528 | 0.528 | 0.528 | 0.528 | 0.528 |
| 1 | GET | /posts/1910 | 0.524 | 0.524 | 0.524 | 0.524 | 0.524 |
| 1 | GET | /posts/3131 | 0.524 | 0.524 | 0.524 | 0.524 | 0.524 |
| 1 | GET | /posts/4029 | 0.524 | 0.524 | 0.524 | 0.524 | 0.524 |
| 1 | GET | /posts/5470 | 0.524 | 0.524 | 0.524 | 0.524 | 0.524 |
| 1 | GET | /posts/7610 | 0.524 | 0.524 | 0.524 | 0.524 | 0.524 |
| 1 | GET | /posts/1952 | 0.520 | 0.520 | 0.520 | 0.520 | 0.520 |
| 1 | GET | /posts/5973 | 0.520 | 0.520 | 0.520 | 0.520 | 0.520 |
| 1 | GET | /posts/2574 | 0.520 | 0.520 | 0.520 | 0.520 | 0.520 |
| 1 | GET | /posts/6175 | 0.520 | 0.520 | 0.520 | 0.520 | 0.520 |
| 1 | GET | /posts/627 | 0.520 | 0.520 | 0.520 | 0.520 | 0.520 |
| 1 | GET | /posts/6667 | 0.512 | 0.512 | 0.512 | 0.512 | 0.512 |
| 1 | GET | /posts/4660 | 0.512 | 0.512 | 0.512 | 0.512 | 0.512 |
| 1 | GET | /posts/4175 | 0.512 | 0.512 | 0.512 | 0.512 | 0.512 |
| 1 | GET | /posts/9419 | 0.512 | 0.512 | 0.512 | 0.512 | 0.512 |
| 1 | GET | /posts/5233 | 0.512 | 0.512 | 0.512 | 0.512 | 0.512 |
| 1 | GET | /posts/3090 | 0.508 | 0.508 | 0.508 | 0.508 | 0.508 |
| 1 | GET | /posts/2740 | 0.508 | 0.508 | 0.508 | 0.508 | 0.508 |
| 1 | GET | /posts/3505 | 0.508 | 0.508 | 0.508 | 0.508 | 0.508 |
| 1 | GET | /posts/917 | 0.508 | 0.508 | 0.508 | 0.508 | 0.508 |
| 1 | GET | /posts/8589 | 0.508 | 0.508 | 0.508 | 0.508 | 0.508 |
| 1 | GET | /posts/7282 | 0.508 | 0.508 | 0.508 | 0.508 | 0.508 |
| 1 | GET | /posts/8299 | 0.508 | 0.508 | 0.508 | 0.508 | 0.508 |
| 1 | GET | /posts/2518 | 0.508 | 0.508 | 0.508 | 0.508 | 0.508 |
| 1 | GET | /posts/5525 | 0.504 | 0.504 | 0.504 | 0.504 | 0.504 |
| 1 | GET | /posts/5016 | 0.504 | 0.504 | 0.504 | 0.504 | 0.504 |
| 1 | GET | /posts/591 | 0.504 | 0.504 | 0.504 | 0.504 | 0.504 |
| 1 | GET | /posts/8335 | 0.504 | 0.504 | 0.504 | 0.504 | 0.504 |
| 1 | GET | /posts/342 | 0.504 | 0.504 | 0.504 | 0.504 | 0.504 |
| 1 | GET | /posts/1266 | 0.504 | 0.504 | 0.504 | 0.504 | 0.504 |
| 1 | GET | /posts/9360 | 0.500 | 0.500 | 0.500 | 0.500 | 0.500 |
| 1 | GET | /posts/1909 | 0.500 | 0.500 | 0.500 | 0.500 | 0.500 |
| 1 | GET | /posts/6829 | 0.496 | 0.496 | 0.496 | 0.496 | 0.496 |
| 1 | GET | /posts/735 | 0.496 | 0.496 | 0.496 | 0.496 | 0.496 |
| 1 | GET | /posts/4437 | 0.496 | 0.496 | 0.496 | 0.496 | 0.496 |
| 1 | GET | /posts/1826 | 0.496 | 0.496 | 0.496 | 0.496 | 0.496 |
| 1 | GET | /posts/6188 | 0.496 | 0.496 | 0.496 | 0.496 | 0.496 |
| 1 | GET | /posts/9874 | 0.492 | 0.492 | 0.492 | 0.492 | 0.492 |
| 1 | GET | /posts/8219 | 0.492 | 0.492 | 0.492 | 0.492 | 0.492 |
| 1 | GET | /posts/7940 | 0.488 | 0.488 | 0.488 | 0.488 | 0.488 |
| 1 | GET | /posts/9395 | 0.488 | 0.488 | 0.488 | 0.488 | 0.488 |
| 1 | GET | /posts/9145 | 0.484 | 0.484 | 0.484 | 0.484 | 0.484 |
| 1 | GET | /posts/8991 | 0.476 | 0.476 | 0.476 | 0.476 | 0.476 |
| 1 | GET | /posts/5693 | 0.472 | 0.472 | 0.472 | 0.472 | 0.472 |
| 1 | GET | /posts/1518 | 0.468 | 0.468 | 0.468 | 0.468 | 0.468 |
| 1 | GET | /posts/8720 | 0.464 | 0.464 | 0.464 | 0.464 | 0.464 |
| 1 | GET | /posts/3273 | 0.464 | 0.464 | 0.464 | 0.464 | 0.464 |
| 1 | GET | /posts/8647 | 0.460 | 0.460 | 0.460 | 0.460 | 0.460 |
| 1 | GET | /posts/9384 | 0.460 | 0.460 | 0.460 | 0.460 | 0.460 |
| 1 | GET | /posts/3931 | 0.456 | 0.456 | 0.456 | 0.456 | 0.456 |
| 1 | GET | /posts/9093 | 0.456 | 0.456 | 0.456 | 0.456 | 0.456 |
| 1 | GET | /posts/9193 | 0.456 | 0.456 | 0.456 | 0.456 | 0.456 |
| 1 | GET | /posts/7416 | 0.448 | 0.448 | 0.448 | 0.448 | 0.448 |
| 1 | GET | /posts/9406 | 0.448 | 0.448 | 0.448 | 0.448 | 0.448 |
| 1 | GET | /posts/9904 | 0.444 | 0.444 | 0.444 | 0.444 | 0.444 |
| 1 | GET | /posts/6432 | 0.440 | 0.440 | 0.440 | 0.440 | 0.440 |
| 1 | GET | /posts/7010 | 0.436 | 0.436 | 0.436 | 0.436 | 0.436 |
| 1 | GET | /posts/9301 | 0.436 | 0.436 | 0.436 | 0.436 | 0.436 |
| 1 | GET | /posts/5446 | 0.436 | 0.436 | 0.436 | 0.436 | 0.436 |
| 1 | GET | /posts/9578 | 0.436 | 0.436 | 0.436 | 0.436 | 0.436 |
| 1 | GET | /posts/6654 | 0.436 | 0.436 | 0.436 | 0.436 | 0.436 |
| 1 | GET | /posts/1533 | 0.432 | 0.432 | 0.432 | 0.432 | 0.432 |
| 1 | GET | /posts/7527 | 0.432 | 0.432 | 0.432 | 0.432 | 0.432 |
| 1 | GET | /posts/6079 | 0.432 | 0.432 | 0.432 | 0.432 | 0.432 |
| 1 | GET | /posts/5950 | 0.428 | 0.428 | 0.428 | 0.428 | 0.428 |
| 1 | GET | /posts/2767 | 0.428 | 0.428 | 0.428 | 0.428 | 0.428 |
| 1 | GET | /posts/5681 | 0.428 | 0.428 | 0.428 | 0.428 | 0.428 |
| 1 | GET | /posts/9437 | 0.428 | 0.428 | 0.428 | 0.428 | 0.428 |
| 1 | GET | /posts/6943 | 0.428 | 0.428 | 0.428 | 0.428 | 0.428 |
| 1 | GET | /posts/8325 | 0.428 | 0.428 | 0.428 | 0.428 | 0.428 |
| 1 | GET | /posts/4406 | 0.428 | 0.428 | 0.428 | 0.428 | 0.428 |
| 1 | GET | /posts/4362 | 0.428 | 0.428 | 0.428 | 0.428 | 0.428 |
| 1 | GET | /posts/8687 | 0.428 | 0.428 | 0.428 | 0.428 | 0.428 |
| 1 | GET | /posts/1642 | 0.428 | 0.428 | 0.428 | 0.428 | 0.428 |
| 1 | GET | /posts/9672 | 0.424 | 0.424 | 0.424 | 0.424 | 0.424 |
| 1 | GET | /posts/5487 | 0.424 | 0.424 | 0.424 | 0.424 | 0.424 |
| 1 | GET | /posts/5572 | 0.420 | 0.420 | 0.420 | 0.420 | 0.420 |
| 1 | GET | /posts/2736 | 0.420 | 0.420 | 0.420 | 0.420 | 0.420 |
| 1 | GET | /posts/1802 | 0.420 | 0.420 | 0.420 | 0.420 | 0.420 |
| 1 | GET | /posts/8480 | 0.416 | 0.416 | 0.416 | 0.416 | 0.416 |
| 1 | GET | /posts/3930 | 0.416 | 0.416 | 0.416 | 0.416 | 0.416 |
| 1 | GET | /posts/9023 | 0.412 | 0.412 | 0.412 | 0.412 | 0.412 |
| 1 | GET | /posts/2543 | 0.412 | 0.412 | 0.412 | 0.412 | 0.412 |
| 1 | GET | /posts/661 | 0.412 | 0.412 | 0.412 | 0.412 | 0.412 |
| 1 | GET | /posts/4595 | 0.412 | 0.412 | 0.412 | 0.412 | 0.412 |
| 1 | GET | /posts/2044 | 0.408 | 0.408 | 0.408 | 0.408 | 0.408 |
| 1 | GET | /posts/595 | 0.408 | 0.408 | 0.408 | 0.408 | 0.408 |
| 1 | GET | /posts/19 | 0.396 | 0.396 | 0.396 | 0.396 | 0.396 |
| 1 | GET | /posts/2159 | 0.388 | 0.388 | 0.388 | 0.388 | 0.388 |
| 5 | GET | /image/9999.jpg | 0.000 | 0.352 | 0.356 | 0.071 | 0.352 |
| 4 | POST | /register | 0.020 | 0.228 | 0.352 | 0.088 | 0.228 |
| 1 | GET | /posts/6314 | 0.272 | 0.272 | 0.272 | 0.272 | 0.272 |
| 1 | GET | /posts/6107 | 0.168 | 0.168 | 0.168 | 0.168 | 0.168 |
| 1 | GET | /posts/1397 | 0.168 | 0.168 | 0.168 | 0.168 | 0.168 |
| 1 | GET | /posts/7851 | 0.168 | 0.168 | 0.168 | 0.168 | 0.168 |
| 1 | GET | /posts/1359 | 0.164 | 0.164 | 0.164 | 0.164 | 0.164 |
| 1 | GET | /posts/6935 | 0.164 | 0.164 | 0.164 | 0.164 | 0.164 |
| 1 | GET | /posts/5181 | 0.160 | 0.160 | 0.160 | 0.160 | 0.160 |
| 1 | GET | /posts/2266 | 0.160 | 0.160 | 0.160 | 0.160 | 0.160 |
| 1 | GET | /posts/4662 | 0.156 | 0.156 | 0.156 | 0.156 | 0.156 |
| 1 | GET | /posts/8187 | 0.140 | 0.140 | 0.140 | 0.140 | 0.140 |
| 3 | POST | / | 0.100 | 0.100 | 0.124 | 0.041 | 0.100 |
| 1 | GET | /posts/9415 | 0.088 | 0.088 | 0.088 | 0.088 | 0.088 |
| 1 | GET | /posts/9586 | 0.084 | 0.084 | 0.084 | 0.084 | 0.084 |
| 1 | GET | /posts/10001 | 0.080 | 0.080 | 0.080 | 0.080 | 0.080 |
| 26 | GET | /login | 0.000 | 0.008 | 0.040 | 0.002 | 0.008 |
| 2 | GET | /image/4362.gif | 0.012 | 0.020 | 0.032 | 0.016 | 0.020 |
| 2 | GET | /image/9874.jpg | 0.000 | 0.028 | 0.028 | 0.014 | 0.028 |
| 122 | GET | /js/main.js | 0.000 | 0.004 | 0.028 | 0.000 | 0.004 |
| 5 | GET | /image/10000.png | 0.004 | 0.012 | 0.028 | 0.006 | 0.012 |
| 2 | GET | /image/8991.jpg | 0.004 | 0.024 | 0.028 | 0.014 | 0.024 |
| 2 | GET | /image/8335.jpg | 0.004 | 0.016 | 0.020 | 0.010 | 0.016 |
| 122 | GET | /js/timeago.min.js | 0.000 | 0.004 | 0.020 | 0.000 | 0.004 |
| 5 | GET | /image/9995.jpg | 0.004 | 0.016 | 0.020 | 0.004 | 0.016 |
| 122 | GET | /css/style.css | 0.000 | 0.004 | 0.020 | 0.000 | 0.004 |
| 5 | GET | /image/9989.jpg | 0.004 | 0.004 | 0.016 | 0.003 | 0.004 |
| 5 | GET | /image/9987.jpg | 0.008 | 0.008 | 0.016 | 0.003 | 0.008 |
| 5 | GET | /image/9998.jpg | 0.004 | 0.012 | 0.016 | 0.003 | 0.012 |
| 2 | GET | /image/1642.jpg | 0.004 | 0.012 | 0.016 | 0.008 | 0.012 |
| 2 | GET | /image/5487.jpg | 0.000 | 0.012 | 0.012 | 0.006 | 0.012 |
| 2 | GET | /image/9672.jpg | 0.000 | 0.012 | 0.012 | 0.006 | 0.012 |
| 2 | GET | /image/692.jpg | 0.000 | 0.012 | 0.012 | 0.006 | 0.012 |
| 5 | GET | /image/9982.jpg | 0.004 | 0.004 | 0.012 | 0.002 | 0.004 |
| 2 | GET | /image/917.jpg | 0.004 | 0.008 | 0.012 | 0.006 | 0.008 |
| 2 | GET | /image/735.jpg | 0.000 | 0.012 | 0.012 | 0.006 | 0.012 |
| 2 | GET | /image/627.png | 0.004 | 0.008 | 0.012 | 0.006 | 0.008 |
| 2 | GET | /image/4406.jpg | 0.004 | 0.008 | 0.012 | 0.006 | 0.008 |
| 2 | GET | /image/4595.jpg | 0.004 | 0.008 | 0.012 | 0.006 | 0.008 |
| 2 | GET | /image/9406.jpg | 0.000 | 0.012 | 0.012 | 0.006 | 0.012 |
| 2 | GET | /image/3505.jpg | 0.004 | 0.004 | 0.008 | 0.004 | 0.004 |
| 2 | GET | /image/8480.jpg | 0.004 | 0.004 | 0.008 | 0.004 | 0.004 |
| 2 | GET | /image/5693.jpg | 0.000 | 0.008 | 0.008 | 0.004 | 0.008 |
| 2 | GET | /image/3273.jpg | 0.004 | 0.004 | 0.008 | 0.004 | 0.004 |
| 2 | GET | /image/2543.jpg | 0.004 | 0.004 | 0.008 | 0.004 | 0.004 |
| 1 | GET | /image/5523.jpg | 0.008 | 0.008 | 0.008 | 0.008 | 0.008 |
| 2 | GET | /image/9384.png | 0.004 | 0.004 | 0.008 | 0.004 | 0.004 |
| 1 | GET | /image/8360.jpg | 0.008 | 0.008 | 0.008 | 0.008 | 0.008 |
| 1 | GET | /image/4680.jpg | 0.008 | 0.008 | 0.008 | 0.008 | 0.008 |
| 2 | GET | /image/9301.jpg | 0.004 | 0.004 | 0.008 | 0.004 | 0.004 |
| 2 | GET | /image/7010.jpg | 0.000 | 0.008 | 0.008 | 0.004 | 0.008 |
| 1 | GET | /image/3063.jpg | 0.008 | 0.008 | 0.008 | 0.008 | 0.008 |
| 2 | GET | /image/8806.jpg | 0.004 | 0.004 | 0.008 | 0.004 | 0.004 |
| 2 | GET | /image/8299.jpg | 0.004 | 0.004 | 0.008 | 0.004 | 0.004 |
| 2 | GET | /image/3930.jpg | 0.000 | 0.008 | 0.008 | 0.004 | 0.008 |
| 2 | GET | /image/2574.jpg | 0.000 | 0.008 | 0.008 | 0.004 | 0.008 |
| 2 | GET | /image/4437.jpg | 0.004 | 0.004 | 0.008 | 0.004 | 0.004 |
| 2 | GET | /image/5233.jpg | 0.004 | 0.004 | 0.008 | 0.004 | 0.004 |
| 2 | GET | /image/19.jpg | 0.004 | 0.004 | 0.008 | 0.004 | 0.004 |
| 2 | GET | /image/2518.jpg | 0.004 | 0.004 | 0.008 | 0.004 | 0.004 |
| 2 | GET | /image/10002.png | 0.004 | 0.004 | 0.008 | 0.004 | 0.004 |
| 2 | GET | /image/1802.jpg | 0.004 | 0.004 | 0.008 | 0.004 | 0.004 |
| 2 | GET | /image/2736.jpg | 0.000 | 0.008 | 0.008 | 0.004 | 0.008 |
| 2 | GET | /image/5572.jpg | 0.000 | 0.008 | 0.008 | 0.004 | 0.008 |
| 2 | GET | /image/7375.jpg | 0.008 | 0.008 | 0.008 | 0.004 | 0.008 |
| 2 | GET | /image/1910.jpg | 0.004 | 0.004 | 0.008 | 0.004 | 0.004 |
| 2 | GET | /image/342.jpg | 0.004 | 0.004 | 0.008 | 0.004 | 0.004 |
| 2 | GET | /image/5446.jpg | 0.004 | 0.004 | 0.008 | 0.004 | 0.004 |
| 2 | GET | /image/1359.jpg | 0.004 | 0.004 | 0.008 | 0.004 | 0.004 |
| 2 | GET | /image/1533.jpg | 0.004 | 0.004 | 0.008 | 0.004 | 0.004 |
| 5 | GET | /image/9983.jpg | 0.000 | 0.008 | 0.008 | 0.002 | 0.008 |
| 5 | GET | /image/9993.jpg | 0.000 | 0.004 | 0.008 | 0.002 | 0.004 |
| 5 | GET | /image/9994.jpg | 0.000 | 0.008 | 0.008 | 0.002 | 0.008 |
| 122 | GET | /favicon.ico | 0.000 | 0.004 | 0.008 | 0.000 | 0.004 |
| 1 | POST | /comment | 0.008 | 0.008 | 0.008 | 0.008 | 0.008 |
| 1 | GET | /image/1888.jpg | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 |
| 2 | GET | /image/1266.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/2044.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/6175.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 5 | GET | /image/9996.jpg | 0.004 | 0.004 | 0.004 | 0.001 | 0.004 |
| 5 | GET | /image/9991.jpg | 0.000 | 0.004 | 0.004 | 0.001 | 0.004 |
| 5 | GET | /image/9990.jpg | 0.000 | 0.004 | 0.004 | 0.001 | 0.004 |
| 2 | GET | /image/2159.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 5 | GET | /image/9988.jpg | 0.000 | 0.004 | 0.004 | 0.001 | 0.004 |
| 5 | GET | /image/9985.jpg | 0.000 | 0.004 | 0.004 | 0.001 | 0.004 |
| 2 | GET | /image/6432.jpg | 0.004 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/9023.jpg | 0.004 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/9193.jpg | 0.004 | 0.004 | 0.004 | 0.002 | 0.004 |
| 1 | GET | /image/212.jpg | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 |
| 1 | GET | /image/408.jpg | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 |
| 2 | GET | /image/7416.jpg | 0.004 | 0.004 | 0.004 | 0.002 | 0.004 |
| 1 | GET | /image/3575.jpg | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 |
| 1 | GET | /image/3893.jpg | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 |
| 1 | GET | /image/4580.jpg | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 |
| 2 | GET | /image/1909.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/1826.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 1 | GET | /image/564.jpg | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 |
| 1 | GET | /image/290.jpg | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 |
| 1 | GET | /image/163.jpg | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 |
| 1 | GET | /image/6929.jpg | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 |
| 2 | GET | /image/1397.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 1 | GET | /image/7876.jpg | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 |
| 2 | GET | /image/2266.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/4662.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 1 | GET | /image/7312.jpg | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 |
| 2 | GET | /image/5181.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/6107.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 1 | GET | /image/5058.jpg | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 |
| 2 | GET | /image/6935.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 1 | GET | /image/4122.jpg | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 |
| 1 | GET | /image/3085.jpg | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 |
| 1 | GET | /image/2967.jpg | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 |
| 1 | GET | /image/2663.jpg | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 |
| 1 | GET | /image/1497.jpg | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 |
| 1 | GET | /image/1177.jpg | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 |
| 2 | GET | /image/8187.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 1 | GET | /image/2124.jpg | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 |
| 1 | GET | /image/2172.jpg | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 |
| 1 | GET | /image/2457.jpg | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 |
| 1 | GET | /image/2941.jpg | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 |
| 2 | GET | /image/3090.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/4175.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/6654.jpg | 0.004 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/8325.jpg | 0.004 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/9415.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/9093.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/5470.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 1 | GET | /image/1050.jpg | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 |
| 2 | GET | /image/7940.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/4029.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 1 | GET | /image/1980.jpg | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 |
| 2 | GET | /image/2740.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/3931.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/3316.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/6829.jpg | 0.004 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/5973.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/4660.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 1 | GET | /image/838.jpg | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 |
| 2 | GET | /image/1952.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/3131.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/8687.jpg | 0.004 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/1518.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/5016.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/5525.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/5681.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/2767.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/8219.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/9145.png | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/661.jpg | 0.000 | 0.004 | 0.004 | 0.002 | 0.004 |
| 2 | GET | /image/595.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 2 | GET | /image/6188.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 2 | GET | /image/5950.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 2 | GET | /image/9437.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 2 | GET | /image/9904.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 2 | GET | /image/7527.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 2 | GET | /image/6667.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 2 | GET | /image/6943.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 2 | GET | /image/8589.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 2 | GET | /image/7282.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 2 | GET | /image/9395.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 2 | GET | /image/9419.gif | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 1 | GET | /logout | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 2 | GET | /image/8647.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 2 | GET | /image/9578.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 2 | GET | /image/7851.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 1 | GET | /image/8404.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 1 | GET | /image/6012.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 1 | GET | /image/6405.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 2 | GET | /image/9360.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 1 | GET | /image/8068.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 1 | GET | /image/7566.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 4 | GET | /image/9980.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 5 | GET | /image/9981.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 2 | GET | /image/6314.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 5 | GET | /image/9986.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 2 | GET | /image/6079.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 2 | GET | /image/591.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 2 | GET | /image/8720.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 2 | GET | /image/7610.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 5 | GET | /image/9997.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 1 | GET | /admin/banned | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 6 | GET | /image/10001.jpg | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
+-------+--------+--------------------+--------+--------+---------+--------+--------+
slow query
Count: 1495 Time=0.37s (550s) Lock=0.00s (0s) Rows=2.8 (4176), isuconp[isuconp]@localhost
SELECT * FROM `comments` WHERE `post_id` = N ORDER BY `created_at` DESC LIMIT N
Count: 1594 Time=0.10s (167s) Lock=0.00s (0s) Rows=1.0 (1594), isuconp[isuconp]@localhost
SELECT COUNT(*) AS `count` FROM `comments` WHERE `post_id` = N
Count: 96 Time=0.34s (32s) Lock=0.00s (0s) Rows=10.4 (999), isuconp[isuconp]@localhost
SELECT * FROM `comments` WHERE `post_id` = N ORDER BY `created_at` DESC
Count: 61 Time=0.15s (8s) Lock=0.00s (0s) Rows=10001.7 (610103), isuconp[isuconp]@localhost
SELECT `id`, `user_id`, `body`, `mime`, `created_at` FROM `posts` ORDER BY `created_at` DESC
Count: 21104 Time=0.00s (4s) Lock=0.00s (0s) Rows=1.2 (24343), isuconp[isuconp]@localhost
#
Count: 6811 Time=0.00s (2s) Lock=0.00s (0s) Rows=1.0 (6811), isuconp[isuconp]@localhost
SELECT * FROM `users` WHERE `id` = N
Count: 14 Time=0.09s (1s) Lock=0.00s (0s) Rows=1.0 (14), isuconp[isuconp]@localhost
SELECT COUNT(*) AS count FROM `comments` WHERE `user_id` = N
Count: 399 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (399), isuconp[isuconp]@localhost
SELECT * FROM `posts` WHERE `id` = N
Count: 4 Time=0.11s (0s) Lock=0.00s (0s) Rows=1.0 (4), isuconp[isuconp]@localhost
SELECT COUNT(*) AS count FROM `comments` WHERE `post_id` IN (N, N, N, N, N, N, N, N, N, N)
Count: 15 Time=0.02s (0s) Lock=0.00s (0s) Rows=10.0 (150), isuconp[isuconp]@localhost
SELECT `id`, `user_id`, `body`, `mime`, `created_at` FROM `posts` WHERE `user_id` = N ORDER BY `created_at` DESC
explain
Reading from STDIN ...
# 2.3s user time, 20ms system time, 40.25M rss, 53.55M vsz
# Current date: Tue Sep 19 18:18:14 2023
# Hostname: private-isu
# Files: STDIN
# Overall: 32.70k total, 25 unique, 408.73 QPS, 9.69x concurrency ________
# Time range: 2023-09-19T09:16:54 to 2023-09-19T09:18:14
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 775s 1us 1s 24ms 148ms 87ms 63us
# Lock time 24ms 0 4ms 0 1us 21us 0
# Rows sent 629.77k 0 9.77k 19.72 0.99 418.92 0
# Rows examine 314.12M 0 97.68k 9.84k 97.04k 29.14k 0
# Query size 2.13M 17 910.84k 68.17 72.65 4.84k 31.70
# Profile
# Rank Query ID Response time Calls R/Call V/M Ite
# ==== ============================= ============== ===== ====== ===== ===
# 1 0x624863D30DAC59FA16849282... 553.0790 71.3% 1518 0.3643 0.07 SELECT comments
# 2 0x422390B42D4DD86C7539A5F4... 168.0127 21.7% 1624 0.1035 0.02 SELECT comments
# 3 0x100EC8B5C400F34381F9D7F7... 33.9783 4.4% 106 0.3206 0.02 SELECT comments
# 4 0x4858CF4D8CAA743E839C127C... 8.9898 1.2% 61 0.1474 0.04 SELECT posts
# MISC 0xMISC 11.2969 1.5% 29389 0.0004 0.0 <21 ITEMS>
# Query 1: 18.98 QPS, 6.91x concurrency, ID 0x624863D30DAC59FA16849282195BE09F at byte 6431697
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.07
# Time range: 2023-09-19T09:16:54 to 2023-09-19T09:18:14
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 4 1518
# Exec time 71 553s 59ms 1s 364ms 640ms 158ms 356ms
# Lock time 15 4ms 0 215us 2us 3us 6us 1us
# Rows sent 0 4.15k 0 3 2.80 2.90 0.73 2.90
# Rows examine 46 144.77M 97.66k 97.66k 97.66k 97.04k 0 97.04k
# Query size 5 121.70k 80 83 82.10 80.10 0.10 80.10
# String:
# Hosts localhost
# Users isuconp
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ########
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS LIKE 'comments'\G
# SHOW CREATE TABLE `comments`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM `comments` WHERE `post_id` = 10002 ORDER BY `created_at` DESC LIMIT 3\G
# *************************** 1. row ***************************
# id: 1
# select_type: SIMPLE
# table: comments
# partitions: NULL
# type: ALL
# possible_keys: NULL
# key: NULL
# key_len: NULL
# ref: NULL
# rows: 99289
# filtered: 10.00
# Extra: Using where; Using filesort
# Query 2: 20.30 QPS, 2.10x concurrency, ID 0x422390B42D4DD86C7539A5F45EB76A80 at byte 6406372
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.02
# Time range: 2023-09-19T09:16:54 to 2023-09-19T09:18:14
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 4 1624
# Exec time 21 168s 18ms 371ms 103ms 189ms 48ms 95ms
# Lock time 10 3ms 0 129us 1us 1us 3us 1us
# Rows sent 0 1.59k 1 1 1 1 0 1
# Rows examine 49 154.88M 97.66k 97.66k 97.66k 97.04k 0 97.04k
# Query size 4 103.22k 63 66 65.09 65.89 0.95 62.76
# String:
# Hosts localhost
# Users isuconp
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ############################################
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS LIKE 'comments'\G
# SHOW CREATE TABLE `comments`\G
# EXPLAIN
SELECT COUNT(*) AS `count` FROM `comments` WHERE `post_id` = 9983\G
# *************************** 1. row ***************************
# id: 1
# select_type: SIMPLE
# table: comments
# partitions: NULL
# type: ALL
# possible_keys: NULL
# key: NULL
# key_len: NULL
# ref: NULL
# rows: 99289
# filtered: 10.00
# Extra: Using where
# Query 3: 1.39 QPS, 0.45x concurrency, ID 0x100EC8B5C400F34381F9D7F7FA80A53D at byte 7806591
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.02
# Time range: 2023-09-19T09:16:57 to 2023-09-19T09:18:13
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 106
# Exec time 4 34s 61ms 497ms 321ms 393ms 85ms 339ms
# Lock time 1 245us 1us 14us 2us 2us 1us 1us
# Rows sent 0 1.06k 0 23 10.28 14.52 3.51 9.83
# Rows examine 3 10.11M 97.66k 97.68k 97.67k 97.04k 0.00 97.04k
# Query size 0 7.65k 72 75 73.92 72.65 0.33 72.65
# String:
# Hosts localhost
# Users isuconp
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms #
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS LIKE 'comments'\G
# SHOW CREATE TABLE `comments`\G
# EXPLAIN
SELECT * FROM `comments` WHERE `post_id` = 8806 ORDER BY `created_at` DESC\G
# *************************** 1. row ***************************
# id: 1
# select_type: SIMPLE
# table: comments
# partitions: NULL
# type: ALL
# possible_keys: NULL
# key: NULL
# key_len: NULL
# ref: NULL
# rows: 99289
# filtered: 10.00
# Extra: Using where; Using filesort
# Query 4: 0.82 QPS, 0.12x concurrency, ID 0x4858CF4D8CAA743E839C127C71B69E75 at byte 3001047
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.04
# Time range: 2023-09-19T09:16:54 to 2023-09-19T09:18:08
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 61
# Exec time 1 9s 18ms 500ms 147ms 230ms 81ms 148ms
# Lock time 1 401us 1us 271us 6us 3us 32us 1us
# Rows sent 94 595.80k 9.77k 9.77k 9.77k 9.33k 0 9.33k
# Rows examine 0 1.16M 19.53k 19.54k 19.53k 19.40k 0 19.40k
# Query size 0 5.48k 92 92 92 92 0 92
# String:
# Hosts localhost
# Users isuconp
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ####################
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS LIKE 'posts'\G
# SHOW CREATE TABLE `posts`\G
# EXPLAIN
SELECT `id`, `user_id`, `body`, `mime`, `created_at` FROM `posts` ORDER BY `created_at` DESC\G
# *************************** 1. row ***************************
# id: 1
# select_type: SIMPLE
# table: posts
# partitions: NULL
# type: ALL
# possible_keys: NULL
# key: NULL
# key_len: NULL
# ref: NULL
# rows: 9412
# filtered: 100.00
# Extra: Using filesort
netdata
http://localhost:19991/#menu_apps_submenu_cpu;after=1695115013925;before=1695115090947
初期スコア
96