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 | 1.04 ms | 1.04 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 2130 | 460.33 ms | 614.78 us | 189.51 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 2130 | 223.93 ms | 376.66 us | 77.32 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 2130 | 15.27 ms | 34.24 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 67448 | 33.54 s | 503.39 ms | 8.67 s | 298702 | 2932052 | 0 | 20819 | |
root | show_keys | 2701 | 3.24 s | 127.37 ms | 969.55 ms | 2884 | 45144 | 0 | 0 | |
root | show_fields | 3151 | 2.94 s | 7.22 ms | 1.20 s | 115815 | 591104 | 0 | 0 | |
root | show_variables | 2724 | 2.34 s | 4.65 ms | 241.18 ms | 2719 | 1562526 | 0 | 2724 | |
root | show_tables | 1694 | 1.26 s | 3.83 ms | 694.47 ms | 29261 | 95006 | 0 | 0 | |
root | create_table | 9 | 780.83 ms | 200.18 ms | 9.65 ms | 0 | 0 | 0 | 0 | |
root | set_option | 7829 | 551.48 ms | 6.31 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 1526 | 308.54 ms | 2.16 ms | 7.43 ms | 0 | 0 | 0 | 0 | |
root | create_db | 6 | 307.67 ms | 67.26 ms | 3.48 ms | 0 | 0 | 6 | 0 | |
root | insert | 9 | 229.77 ms | 47.83 ms | 3.26 ms | 0 | 0 | 7 | 0 | |
root | show_table_status | 196 | 144.17 ms | 12.89 ms | 86.70 ms | 247 | 1275 | 0 | 0 | |
root | Init DB | 2393 | 128.48 ms | 2.05 ms | 5.14 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 1426 | 115.80 ms | 566.51 us | 0 ps | 0 | 0 | 0 | 0 | |
root | grant | 2 | 60.86 ms | 36.61 ms | 1.27 ms | 0 | 0 | 0 | 0 | |
root | create_user | 1 | 52.03 ms | 52.03 ms | 5.66 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 1239 | 37.80 ms | 183.89 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 3110 | 21.34 ms | 240.28 us | 0 ps | 0 | 0 | 0 | 0 | |
root | alter_user | 1 | 16.93 ms | 16.93 ms | 217.00 us | 0 | 0 | 0 | 0 | |
root | jump_if_not | 19164 | 14.59 ms | 21.48 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 170 | 14.08 ms | 1.97 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 68 | 8.80 ms | 637.73 us | 4.20 ms | 612 | 612 | 0 | 68 |
|