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 | 2.54 ms | 2.54 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1686 | 314.91 ms | 1.73 ms | 127.52 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1627 | 145.60 ms | 1.42 ms | 50.44 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1656 | 10.73 ms | 35.99 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 87352 | 34.88 s | 368.85 ms | 11.83 s | 224844 | 1614675 | 0 | 22659 | |
root | show_keys | 3257 | 4.03 s | 1.17 s | 1.22 s | 3103 | 53520 | 0 | 0 | |
root | show_fields | 3316 | 3.29 s | 6.07 ms | 1.31 s | 134512 | 685099 | 0 | 0 | |
root | show_variables | 3114 | 2.71 s | 6.34 ms | 268.08 ms | 3665 | 1786869 | 0 | 3114 | |
root | show_tables | 1781 | 1.24 s | 5.72 ms | 665.46 ms | 37223 | 107539 | 0 | 0 | |
root | set_option | 6899 | 421.61 ms | 5.20 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 1674 | 341.67 ms | 4.84 ms | 273.00 us | 0 | 0 | 0 | 0 | |
root | create_table | 1 | 307.38 ms | 307.38 ms | 3.45 ms | 0 | 0 | 0 | 0 | |
root | create_db | 4 | 160.01 ms | 70.49 ms | 1.96 ms | 0 | 0 | 3 | 0 | |
root | show_table_status | 97 | 115.98 ms | 73.74 ms | 28.98 ms | 15 | 155 | 0 | 0 | |
root | show_grants | 1354 | 109.48 ms | 1.34 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 2315 | 108.24 ms | 416.20 us | 4.00 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 1483 | 45.07 ms | 349.94 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 3004 | 19.44 ms | 219.83 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_status | 1 | 17.45 ms | 17.45 ms | 154.00 us | 450 | 450 | 0 | 1 | |
root | show_create_proc | 54 | 14.88 ms | 6.05 ms | 1.68 ms | 0 | 0 | 0 | 0 | |
root | show_create_func | 44 | 6.54 ms | 801.49 us | 1.06 ms | 0 | 0 | 0 | 0 | |
root | show_binlogs | 81 | 5.64 ms | 699.04 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 5462 | 4.37 ms | 602.16 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 926 | 3.60 ms | 2.06 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 48 | 3.21 ms | 182.92 us | 0 ps | 0 | 0 | 0 | 0 |
|