SELECT * FROM `user_summary_by_statement_type`
|
user | statement | total | total_latency | max_latency | lock_latency | rows_sent | rows_examined | rows_affected | full_scans | |
---|---|---|---|---|---|---|---|---|---|---|
background | select | 1 | 943.16 us | 943.16 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 2766 | 547.96 ms | 1.12 ms | 223.76 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 2766 | 260.23 ms | 1.23 ms | 90.32 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 2763 | 18.93 ms | 76.70 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 157249 | 1.08 m | 460.31 ms | 20.93 s | 440478 | 2691970 | 0 | 38259 | |
root | show_fields | 5944 | 5.75 s | 5.02 ms | 2.24 s | 237866 | 1211634 | 0 | 0 | |
root | show_keys | 5563 | 4.83 s | 113.92 ms | 2.03 s | 5747 | 92279 | 0 | 0 | |
root | show_variables | 5305 | 4.48 s | 6.07 ms | 464.15 ms | 5303 | 3044377 | 0 | 5305 | |
root | alter_table | 11 | 3.52 s | 446.64 ms | 4.32 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 2565 | 1.81 s | 16.62 ms | 895.97 ms | 58777 | 173989 | 0 | 0 | |
root | create_table | 5 | 780.10 ms | 225.97 ms | 4.46 ms | 0 | 0 | 0 | 0 | |
root | set_option | 11499 | 723.75 ms | 7.10 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 3002 | 636.19 ms | 9.40 ms | 8.98 ms | 0 | 0 | 0 | 0 | |
root | create_db | 11 | 333.01 ms | 86.75 ms | 3.06 ms | 0 | 0 | 6 | 0 | |
root | Init DB | 3811 | 194.40 ms | 392.58 us | 13.66 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 2042 | 159.76 ms | 1.12 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 229 | 86.47 ms | 3.14 ms | 55.63 ms | 185 | 749 | 0 | 0 | |
root | show_warnings | 2578 | 78.00 ms | 296.75 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 37082 | 33.54 ms | 1.78 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 4937 | 33.28 ms | 236.22 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 6163 | 14.17 ms | 817.12 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 67 | 7.84 ms | 937.77 us | 4.07 ms | 603 | 603 | 0 | 67 | |
root | show_binlogs | 89 | 6.47 ms | 605.30 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Prepare | 5 | 6.07 ms | 5.57 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 10 | 5.23 ms | 2.26 ms | 0 ps | 0 | 10 | 0 | 0 |
|