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.07 ms | 1.07 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 4907 | 877.59 ms | 2.99 ms | 356.55 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 4907 | 397.77 ms | 1.17 ms | 139.03 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 4905 | 33.45 ms | 270.82 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 168457 | 1.01 m | 862.24 ms | 22.55 s | 472068 | 4029918 | 0 | 53154 | |
root | show_fields | 7509 | 7.99 s | 9.74 ms | 2.94 s | 383117 | 1940129 | 0 | 0 | |
root | show_variables | 7673 | 6.88 s | 341.18 ms | 677.64 ms | 7673 | 4403378 | 0 | 7673 | |
root | show_keys | 5983 | 4.65 s | 74.43 ms | 2.17 s | 8604 | 75887 | 0 | 0 | |
root | create_db | 9 | 1.29 s | 896.02 ms | 3.32 ms | 0 | 0 | 9 | 0 | |
root | show_tables | 1837 | 1.27 s | 4.91 ms | 751.26 ms | 24578 | 89172 | 0 | 0 | |
root | set_option | 15739 | 837.38 ms | 5.61 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 3788 | 771.36 ms | 1.09 ms | 147.00 us | 0 | 0 | 0 | 0 | |
root | create_table | 2 | 493.28 ms | 340.87 ms | 5.31 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 3053 | 233.90 ms | 629.88 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 4819 | 223.85 ms | 629.93 us | 3.96 ms | 0 | 0 | 0 | 0 | |
root | drop_db | 2 | 118.41 ms | 79.80 ms | 3.82 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 3680 | 106.83 ms | 534.72 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 133 | 98.69 ms | 7.51 ms | 63.52 ms | 0 | 231 | 0 | 0 | |
root | insert | 5 | 84.01 ms | 57.05 ms | 2.51 ms | 0 | 0 | 2 | 0 | |
root | Quit | 5621 | 43.51 ms | 591.40 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 21595 | 21.51 ms | 786.22 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 198 | 15.76 ms | 483.48 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 10861 | 15.51 ms | 1.99 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 15 | 9.06 ms | 2.15 ms | 0 ps | 0 | 15 | 0 | 0 | |
root | show_slave_status | 123 | 7.37 ms | 330.48 us | 0 ps | 0 | 0 | 0 | 0 |
|