euglena1215
commented
5 years ago 還元率を1にしてみた
Top 20 Sort By Count
Count Total Mean Stddev Min P50.0 P90.0 P95.0 P99.0 Max 2xx 3xx 4xx 5xx Request
1080 653.417 0.605016 0.491188 0.000 0.500 0.886 2.013 2.523 4.223 1059 0 14 7 POST /login HTTP/1.1
1059 387.786 0.366181 0.353857 0.001 0.313 0.659 0.801 2.115 3.756 1055 0 4 0 GET /settings HTTP/1.1
623 1025.227 1.645629 1.017160 0.002 1.917 2.617 2.944 3.426 5.779 20 0 459 144 POST /buy HTTP/1.1
70 274.492 3.921314 3.048188 0.012 4.520 7.808 9.286 10.006 10.006 62 0 8 0 GET /users/transactions.json HTTP/1.1
39 14.709 0.377154 0.408998 0.002 0.177 0.925 1.341 1.403 1.403 32 0 6 1 POST /sell HTTP/1.1
22 38.658 1.757182 1.185385 0.001 2.137 3.005 3.431 3.780 3.780 18 0 4 0 POST /ship HTTP/1.1
20 20.540 1.027000 1.038134 0.001 0.825 2.879 3.257 3.257 3.257 11 0 9 0 POST /ship_done HTTP/1.1
14 5.998 0.428429 0.238906 0.017 0.483 0.695 0.852 0.852 0.852 14 0 0 0 GET /new_items/40.json HTTP/1.1
11 6.292 0.572000 0.584886 0.006 0.405 0.891 2.117 2.117 2.117 11 0 0 0 POST /bump HTTP/1.1
9 2.676 0.297333 0.291644 0.007 0.236 0.861 0.861 0.861 0.861 9 0 0 0 GET /new_items/30.json HTTP/1.1
9 5.942 0.660222 0.524868 0.007 0.579 1.734 1.734 1.734 1.734 9 0 0 0 GET /new_items/1.json HTTP/1.1
9 1.527 0.169667 0.240875 0.000 0.043 0.776 0.776 0.776 0.776 8 0 0 1 GET /new_items.json HTTP/1.1
9 15.716 1.746222 1.389098 0.013 1.783 3.619 3.619 3.619 3.619 9 0 0 0 POST /complete HTTP/1.1
9 0.039 0.004333 0.004876 0.002 0.003 0.018 0.018 0.018 0.018 9 0 0 0 GET /items/50001.json HTTP/1.1
8 4.648 0.581000 0.418998 0.016 0.669 1.522 1.522 1.522 1.522 8 0 0 0 GET /items/50004.json HTTP/1.1
8 0.017 0.002125 0.000331 0.002 0.002 0.003 0.003 0.003 0.003 8 0 0 0 GET /items/50003.json HTTP/1.1
6 0.976 0.162667 0.224666 0.016 0.049 0.643 0.643 0.643 0.643 6 0 0 0 GET /new_items/50.json HTTP/1.1
6 2.107 0.351167 0.220066 0.046 0.453 0.607 0.607 0.607 0.607 6 0 0 0 GET /new_items/10.json HTTP/1.1
6 7.745 1.290833 0.634431 0.384 1.645 2.221 2.221 2.221 2.221 6 0 0 0 GET /items/50013.json HTTP/1.1
5 2.802 0.560400 0.371156 0.022 0.557 1.086 1.086 1.086 1.086 5 0 0 0 GET /items/50009.json HTTP/1.1
Top 20 Sort By Total
Count Total Mean Stddev Min P50.0 P90.0 P95.0 P99.0 Max 2xx 3xx 4xx 5xx Request
623 1025.227 1.645629 1.017160 0.002 1.917 2.617 2.944 3.426 5.779 20 0 459 144 POST /buy HTTP/1.1
1080 653.417 0.605016 0.491188 0.000 0.500 0.886 2.013 2.523 4.223 1059 0 14 7 POST /login HTTP/1.1
1059 387.786 0.366181 0.353857 0.001 0.313 0.659 0.801 2.115 3.756 1055 0 4 0 GET /settings HTTP/1.1
70 274.492 3.921314 3.048188 0.012 4.520 7.808 9.286 10.006 10.006 62 0 8 0 GET /users/transactions.json HTTP/1.1
22 38.658 1.757182 1.185385 0.001 2.137 3.005 3.431 3.780 3.780 18 0 4 0 POST /ship HTTP/1.1
20 20.540 1.027000 1.038134 0.001 0.825 2.879 3.257 3.257 3.257 11 0 9 0 POST /ship_done HTTP/1.1
9 15.716 1.746222 1.389098 0.013 1.783 3.619 3.619 3.619 3.619 9 0 0 0 POST /complete HTTP/1.1
39 14.709 0.377154 0.408998 0.002 0.177 0.925 1.341 1.403 1.403 32 0 6 1 POST /sell HTTP/1.1
1 8.774 8.774000 0.000000 8.774 8.774 8.774 8.774 8.774 8.774 1 0 0 0 GET /users/transactions.json?created_at=1565599932&item_id=24730 HTTP/1.1
1 8.524 8.524000 0.000000 8.524 8.524 8.524 8.524 8.524 8.524 1 0 0 0 GET /users/transactions.json?created_at=1565595317&item_id=20108 HTTP/1.1
1 8.037 8.037000 0.000000 8.037 8.037 8.037 8.037 8.037 8.037 1 0 0 0 GET /users/transactions.json?created_at=1565609591&item_id=34383 HTTP/1.1
1 7.857 7.857000 0.000000 7.857 7.857 7.857 7.857 7.857 7.857 1 0 0 0 POST /initialize HTTP/1.1
6 7.745 1.290833 0.634431 0.384 1.645 2.221 2.221 2.221 2.221 6 0 0 0 GET /items/50013.json HTTP/1.1
1 7.530 7.530000 0.000000 7.530 7.530 7.530 7.530 7.530 7.530 1 0 0 0 GET /users/transactions.json?created_at=1565622294&item_id=47089 HTTP/1.1
1 7.398 7.398000 0.000000 7.398 7.398 7.398 7.398 7.398 7.398 1 0 0 0 GET /users/transactions.json?created_at=1565617291&item_id=42081 HTTP/1.1
1 6.734 6.734000 0.000000 6.734 6.734 6.734 6.734 6.734 6.734 1 0 0 0 GET /users/transactions.json?created_at=1565605272&item_id=30063 HTTP/1.1
1 6.708 6.708000 0.000000 6.708 6.708 6.708 6.708 6.708 6.708 1 0 0 0 GET /users/transactions.json?created_at=1565591096&item_id=15889 HTTP/1.1
1 6.446 6.446000 0.000000 6.446 6.446 6.446 6.446 6.446 6.446 1 0 0 0 GET /users/transactions.json?created_at=1565604975&item_id=29767 HTTP/1.1
11 6.292 0.572000 0.584886 0.006 0.405 0.891 2.117 2.117 2.117 11 0 0 0 POST /bump HTTP/1.1
1 6.292 6.292000 0.000000 6.292 6.292 6.292 6.292 6.292 6.292 1 0 0 0 GET /users/transactions.json?created_at=1565613779&item_id=38573 HTTP/1.1
Top 20 Sort By Mean
Count Total Mean Stddev Min P50.0 P90.0 P95.0 P99.0 Max 2xx 3xx 4xx 5xx Request
1 8.774 8.774000 0.000000 8.774 8.774 8.774 8.774 8.774 8.774 1 0 0 0 GET /users/transactions.json?created_at=1565599932&item_id=24730 HTTP/1.1
1 8.524 8.524000 0.000000 8.524 8.524 8.524 8.524 8.524 8.524 1 0 0 0 GET /users/transactions.json?created_at=1565595317&item_id=20108 HTTP/1.1
1 8.037 8.037000 0.000000 8.037 8.037 8.037 8.037 8.037 8.037 1 0 0 0 GET /users/transactions.json?created_at=1565609591&item_id=34383 HTTP/1.1
1 7.857 7.857000 0.000000 7.857 7.857 7.857 7.857 7.857 7.857 1 0 0 0 POST /initialize HTTP/1.1
1 7.530 7.530000 0.000000 7.530 7.530 7.530 7.530 7.530 7.530 1 0 0 0 GET /users/transactions.json?created_at=1565622294&item_id=47089 HTTP/1.1
1 7.398 7.398000 0.000000 7.398 7.398 7.398 7.398 7.398 7.398 1 0 0 0 GET /users/transactions.json?created_at=1565617291&item_id=42081 HTTP/1.1
1 6.734 6.734000 0.000000 6.734 6.734 6.734 6.734 6.734 6.734 1 0 0 0 GET /users/transactions.json?created_at=1565605272&item_id=30063 HTTP/1.1
1 6.708 6.708000 0.000000 6.708 6.708 6.708 6.708 6.708 6.708 1 0 0 0 GET /users/transactions.json?created_at=1565591096&item_id=15889 HTTP/1.1
1 6.446 6.446000 0.000000 6.446 6.446 6.446 6.446 6.446 6.446 1 0 0 0 GET /users/transactions.json?created_at=1565604975&item_id=29767 HTTP/1.1
1 6.292 6.292000 0.000000 6.292 6.292 6.292 6.292 6.292 6.292 1 0 0 0 GET /users/transactions.json?created_at=1565613779&item_id=38573 HTTP/1.1
1 5.837 5.837000 0.000000 5.837 5.837 5.837 5.837 5.837 5.837 1 0 0 0 GET /users/transactions.json?created_at=1565608976&item_id=33770 HTTP/1.1
1 5.759 5.759000 0.000000 5.759 5.759 5.759 5.759 5.759 5.759 1 0 0 0 GET /users/transactions.json?created_at=1565608590&item_id=33380 HTTP/1.1
1 5.705 5.705000 0.000000 5.705 5.705 5.705 5.705 5.705 5.705 1 0 0 0 GET /users/transactions.json?created_at=1565612927&item_id=37721 HTTP/1.1
1 5.575 5.575000 0.000000 5.575 5.575 5.575 5.575 5.575 5.575 1 0 0 0 GET /users/transactions.json?created_at=1565595984&item_id=20782 HTTP/1.1
1 5.528 5.528000 0.000000 5.528 5.528 5.528 5.528 5.528 5.528 1 0 0 0 GET /users/transactions.json?created_at=1565617067&item_id=41865 HTTP/1.1
1 5.528 5.528000 0.000000 5.528 5.528 5.528 5.528 5.528 5.528 1 0 0 0 GET /users/transactions.json?created_at=1565586868&item_id=11659 HTTP/1.1
1 5.462 5.462000 0.000000 5.462 5.462 5.462 5.462 5.462 5.462 1 0 0 0 GET /users/transactions.json?created_at=1565591972&item_id=16762 HTTP/1.1
1 5.296 5.296000 0.000000 5.296 5.296 5.296 5.296 5.296 5.296 1 0 0 0 GET /users/transactions.json?created_at=1565617298&item_id=42092 HTTP/1.1
1 5.232 5.232000 0.000000 5.232 5.232 5.232 5.232 5.232 5.232 1 0 0 0 GET /users/transactions.json?created_at=1565617809&item_id=42600 HTTP/1.1
1 5.168 5.168000 0.000000 5.168 5.168 5.168 5.168 5.168 5.168 1 0 0 0 GET /users/transactions.json?created_at=1565612812&item_id=37605 HTTP/1.1
Top 20 Sort By Standard Deviation
Count Total Mean Stddev Min P50.0 P90.0 P95.0 P99.0 Max 2xx 3xx 4xx 5xx Request
70 274.492 3.921314 3.048188 0.012 4.520 7.808 9.286 10.006 10.006 62 0 8 0 GET /users/transactions.json HTTP/1.1
9 15.716 1.746222 1.389098 0.013 1.783 3.619 3.619 3.619 3.619 9 0 0 0 POST /complete HTTP/1.1
22 38.658 1.757182 1.185385 0.001 2.137 3.005 3.431 3.780 3.780 18 0 4 0 POST /ship HTTP/1.1
20 20.540 1.027000 1.038134 0.001 0.825 2.879 3.257 3.257 3.257 11 0 9 0 POST /ship_done HTTP/1.1
2 2.142 1.071000 1.032000 0.039 2.103 2.103 2.103 2.103 2.103 2 0 0 0 GET /users/1864.json HTTP/1.1
623 1025.227 1.645629 1.017160 0.002 1.917 2.617 2.944 3.426 5.779 20 0 459 144 POST /buy HTTP/1.1
2 3.452 1.726000 0.912000 0.814 2.638 2.638 2.638 2.638 2.638 2 0 0 0 GET /new_items/30.json?created_at=1565624826&item_id=49623 HTTP/1.1
2 1.819 0.909500 0.897500 0.012 1.807 1.807 1.807 1.807 1.807 2 0 0 0 GET /new_items/50.json?created_at=1565623793&item_id=48583 HTTP/1.1
3 3.280 1.093333 0.882774 0.279 0.681 2.320 2.320 2.320 2.320 3 0 0 0 GET /items/50007.json HTTP/1.1
3 3.339 1.113000 0.860565 0.498 0.511 2.330 2.330 2.330 2.330 3 0 0 0 GET /items/50021.json HTTP/1.1
5 4.475 0.895000 0.759499 0.112 0.676 2.339 2.339 2.339 2.339 5 0 0 0 GET /items/50015.json HTTP/1.1
2 2.000 1.000000 0.737000 0.263 1.737 1.737 1.737 1.737 1.737 2 0 0 0 GET /items/48041.json HTTP/1.1
2 2.713 1.356500 0.717500 0.639 2.074 2.074 2.074 2.074 2.074 2 0 0 0 GET /new_items/30.json?created_at=1565623773&item_id=48565 HTTP/1.1
2 2.301 1.150500 0.674500 0.476 1.825 1.825 1.825 1.825 1.825 2 0 0 0 GET /new_items/50.json?created_at=1565622906&item_id=47703 HTTP/1.1
4 2.134 0.533500 0.671255 0.111 0.193 1.695 1.695 1.695 1.695 4 0 0 0 GET /new_items/20.json?created_at=1565623395&item_id=48193 HTTP/1.1
6 7.745 1.290833 0.634431 0.384 1.645 2.221 2.221 2.221 2.221 6 0 0 0 GET /items/50013.json HTTP/1.1
11 6.292 0.572000 0.584886 0.006 0.405 0.891 2.117 2.117 2.117 11 0 0 0 POST /bump HTTP/1.1
9 5.942 0.660222 0.524868 0.007 0.579 1.734 1.734 1.734 1.734 9 0 0 0 GET /new_items/1.json HTTP/1.1
2 1.034 0.517000 0.502000 0.015 1.019 1.019 1.019 1.019 1.019 2 0 0 0 GET /users/3487.json HTTP/1.1
1080 653.417 0.605016 0.491188 0.000 0.500 0.886 2.013 2.523 4.223 1059 0 14 7 POST /login HTTP/1.1
Top 20 Sort By Maximum(100 Percentile)
Count Total Mean Stddev Min P50.0 P90.0 P95.0 P99.0 Max 2xx 3xx 4xx 5xx Request
70 274.492 3.921314 3.048188 0.012 4.520 7.808 9.286 10.006 10.006 62 0 8 0 GET /users/transactions.json HTTP/1.1
1 8.774 8.774000 0.000000 8.774 8.774 8.774 8.774 8.774 8.774 1 0 0 0 GET /users/transactions.json?created_at=1565599932&item_id=24730 HTTP/1.1
1 8.524 8.524000 0.000000 8.524 8.524 8.524 8.524 8.524 8.524 1 0 0 0 GET /users/transactions.json?created_at=1565595317&item_id=20108 HTTP/1.1
1 8.037 8.037000 0.000000 8.037 8.037 8.037 8.037 8.037 8.037 1 0 0 0 GET /users/transactions.json?created_at=1565609591&item_id=34383 HTTP/1.1
1 7.857 7.857000 0.000000 7.857 7.857 7.857 7.857 7.857 7.857 1 0 0 0 POST /initialize HTTP/1.1
1 7.530 7.530000 0.000000 7.530 7.530 7.530 7.530 7.530 7.530 1 0 0 0 GET /users/transactions.json?created_at=1565622294&item_id=47089 HTTP/1.1
1 7.398 7.398000 0.000000 7.398 7.398 7.398 7.398 7.398 7.398 1 0 0 0 GET /users/transactions.json?created_at=1565617291&item_id=42081 HTTP/1.1
1 6.734 6.734000 0.000000 6.734 6.734 6.734 6.734 6.734 6.734 1 0 0 0 GET /users/transactions.json?created_at=1565605272&item_id=30063 HTTP/1.1
1 6.708 6.708000 0.000000 6.708 6.708 6.708 6.708 6.708 6.708 1 0 0 0 GET /users/transactions.json?created_at=1565591096&item_id=15889 HTTP/1.1
1 6.446 6.446000 0.000000 6.446 6.446 6.446 6.446 6.446 6.446 1 0 0 0 GET /users/transactions.json?created_at=1565604975&item_id=29767 HTTP/1.1
1 6.292 6.292000 0.000000 6.292 6.292 6.292 6.292 6.292 6.292 1 0 0 0 GET /users/transactions.json?created_at=1565613779&item_id=38573 HTTP/1.1
1 5.837 5.837000 0.000000 5.837 5.837 5.837 5.837 5.837 5.837 1 0 0 0 GET /users/transactions.json?created_at=1565608976&item_id=33770 HTTP/1.1
623 1025.227 1.645629 1.017160 0.002 1.917 2.617 2.944 3.426 5.779 20 0 459 144 POST /buy HTTP/1.1
1 5.759 5.759000 0.000000 5.759 5.759 5.759 5.759 5.759 5.759 1 0 0 0 GET /users/transactions.json?created_at=1565608590&item_id=33380 HTTP/1.1
1 5.705 5.705000 0.000000 5.705 5.705 5.705 5.705 5.705 5.705 1 0 0 0 GET /users/transactions.json?created_at=1565612927&item_id=37721 HTTP/1.1
1 5.575 5.575000 0.000000 5.575 5.575 5.575 5.575 5.575 5.575 1 0 0 0 GET /users/transactions.json?created_at=1565595984&item_id=20782 HTTP/1.1
1 5.528 5.528000 0.000000 5.528 5.528 5.528 5.528 5.528 5.528 1 0 0 0 GET /users/transactions.json?created_at=1565586868&item_id=11659 HTTP/1.1
1 5.528 5.528000 0.000000 5.528 5.528 5.528 5.528 5.528 5.528 1 0 0 0 GET /users/transactions.json?created_at=1565617067&item_id=41865 HTTP/1.1
1 5.462 5.462000 0.000000 5.462 5.462 5.462 5.462 5.462 5.462 1 0 0 0 GET /users/transactions.json?created_at=1565591972&item_id=16762 HTTP/1.1
1 5.296 5.296000 0.000000 5.296 5.296 5.296 5.296 5.296 5.296 1 0 0 0 GET /users/transactions.json?created_at=1565617298&item_id=42092 HTTP/1.1
TOP 37 Slow Requests
1 10.006 GET /users/transactions.json HTTP/1.1
2 9.987 GET /users/transactions.json HTTP/1.1
3 9.424 GET /users/transactions.json HTTP/1.1
4 9.286 GET /users/transactions.json HTTP/1.1
5 8.983 GET /users/transactions.json HTTP/1.1
6 8.774 GET /users/transactions.json?created_at=1565599932&item_id=24730 HTTP/1.1
7 8.524 GET /users/transactions.json?created_at=1565595317&item_id=20108 HTTP/1.1
8 8.201 GET /users/transactions.json HTTP/1.1
9 8.037 GET /users/transactions.json?created_at=1565609591&item_id=34383 HTTP/1.1
10 7.857 POST /initialize HTTP/1.1
11 7.808 GET /users/transactions.json HTTP/1.1
12 7.658 GET /users/transactions.json HTTP/1.1
13 7.556 GET /users/transactions.json HTTP/1.1
14 7.530 GET /users/transactions.json?created_at=1565622294&item_id=47089 HTTP/1.1
15 7.398 GET /users/transactions.json?created_at=1565617291&item_id=42081 HTTP/1.1
16 7.104 GET /users/transactions.json HTTP/1.1
17 7.079 GET /users/transactions.json HTTP/1.1
18 7.069 GET /users/transactions.json HTTP/1.1
19 6.922 GET /users/transactions.json HTTP/1.1
20 6.791 GET /users/transactions.json HTTP/1.1
21 6.734 GET /users/transactions.json?created_at=1565605272&item_id=30063 HTTP/1.1
22 6.708 GET /users/transactions.json?created_at=1565591096&item_id=15889 HTTP/1.1
23 6.649 GET /users/transactions.json HTTP/1.1
24 6.560 GET /users/transactions.json HTTP/1.1
25 6.514 GET /users/transactions.json HTTP/1.1
26 6.446 GET /users/transactions.json?created_at=1565604975&item_id=29767 HTTP/1.1
27 6.292 GET /users/transactions.json?created_at=1565613779&item_id=38573 HTTP/1.1
28 6.211 GET /users/transactions.json HTTP/1.1
29 6.144 GET /users/transactions.json HTTP/1.1
30 6.066 GET /users/transactions.json HTTP/1.1
31 5.959 GET /users/transactions.json HTTP/1.1
32 5.853 GET /users/transactions.json HTTP/1.1
33 5.837 GET /users/transactions.json?created_at=1565608976&item_id=33770 HTTP/1.1
34 5.779 POST /buy HTTP/1.1
35 5.759 GET /users/transactions.json?created_at=1565608590&item_id=33380 HTTP/1.1
36 5.705 GET /users/transactions.json?created_at=1565612927&item_id=37721 HTTP/1.1
37 5.626 POST /buy HTTP/1.1
SELECT * FROMusersWHEREid= ? FOR UPDATEの FOR UPDATEを消した。userはstatus持ってないのでFOR UPDATEいらなさそう