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 | 867.56 us | 867.56 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 340 | 74.66 ms | 602.51 us | 30.18 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 340 | 36.33 ms | 293.56 us | 12.25 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 339 | 2.40 ms | 37.86 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 10833 | 6.37 s | 973.48 ms | 1.64 s | 36339 | 255802 | 0 | 2247 | |
root | show_keys | 316 | 1.46 s | 302.39 ms | 122.78 ms | 381 | 4053 | 0 | 0 | |
root | show_fields | 458 | 456.50 ms | 5.30 ms | 210.41 ms | 10770 | 55974 | 0 | 0 | |
root | show_variables | 263 | 279.66 ms | 28.44 ms | 26.21 ms | 263 | 150647 | 0 | 263 | |
root | show_tables | 174 | 109.12 ms | 2.97 ms | 60.35 ms | 3098 | 16031 | 0 | 0 | |
root | set_option | 1080 | 104.30 ms | 6.15 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 137 | 27.44 ms | 2.07 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_grants | 274 | 25.14 ms | 878.19 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 331 | 19.51 ms | 336.23 us | 1.52 ms | 0 | 0 | 0 | 0 | |
root | show_binlogs | 112 | 11.46 ms | 3.16 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 112 | 3.41 ms | 129.28 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 2 | 3.34 ms | 2.54 ms | 3.07 ms | 0 | 2 | 0 | 0 | |
root | Quit | 379 | 3.02 ms | 217.04 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 990 | 1.90 ms | 275.18 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 17 | 1.52 ms | 137.74 us | 744.00 us | 153 | 153 | 0 | 17 | |
root | jump_if_not | 2000 | 1.04 ms | 7.46 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 3 | 962.66 us | 562.95 us | 0 ps | 0 | 0 | 0 | 0 | |
root | error | 1 | 629.33 us | 629.33 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 3 | 550.26 us | 268.27 us | 0 ps | 0 | 0 | 0 | 0 |
|