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.69 ms | 1.69 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1009 | 178.74 ms | 2.31 ms | 72.73 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1009 | 80.44 ms | 1.31 ms | 28.36 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1014 | 6.59 ms | 30.73 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 51789 | 21.84 s | 462.35 ms | 7.34 s | 122518 | 948244 | 0 | 10766 | |
root | show_fields | 1523 | 1.53 s | 11.29 ms | 603.59 ms | 62697 | 318697 | 0 | 0 | |
root | show_variables | 1457 | 1.32 s | 7.80 ms | 130.86 ms | 2008 | 836087 | 0 | 1457 | |
root | show_keys | 1620 | 1.27 s | 79.13 ms | 605.51 ms | 1422 | 16264 | 0 | 0 | |
root | show_tables | 320 | 229.80 ms | 12.53 ms | 123.90 ms | 6628 | 18655 | 0 | 0 | |
root | create_table | 1 | 211.41 ms | 211.41 ms | 2.75 ms | 0 | 0 | 0 | 0 | |
root | set_option | 3235 | 207.87 ms | 14.14 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 818 | 182.36 ms | 10.83 ms | 236.00 us | 0 | 0 | 0 | 0 | |
root | create_db | 3 | 134.76 ms | 55.83 ms | 2.26 ms | 0 | 0 | 3 | 0 | |
root | insert | 2 | 70.86 ms | 38.77 ms | 4.83 ms | 0 | 0 | 6 | 0 | |
root | show_grants | 738 | 65.34 ms | 8.30 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 965 | 45.37 ms | 1.11 ms | 2.29 ms | 0 | 0 | 0 | 0 | |
root | freturn | 14349 | 35.51 ms | 6.23 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 28 | 22.72 ms | 16.27 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 681 | 20.96 ms | 554.28 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 13243 | 16.78 ms | 1.92 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 17 | 16.57 ms | 15.96 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 29 | 10.11 ms | 2.65 ms | 6.72 ms | 4 | 32 | 0 | 0 | |
root | Quit | 1170 | 7.64 ms | 204.48 us | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 162 | 7.35 ms | 1.47 ms | 0 ps | 0 | 31 | 0 | 0 | |
root | show_slave_status | 17 | 5.68 ms | 3.48 ms | 0 ps | 0 | 0 | 0 | 0 |
|