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.61 ms | 2.61 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 396 | 71.63 ms | 585.00 us | 29.18 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 396 | 31.92 ms | 514.86 us | 11.09 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 395 | 2.47 ms | 46.30 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 6761 | 3.93 s | 373.25 ms | 885.90 ms | 26439 | 181962 | 0 | 3489 | |
root | show_keys | 350 | 539.80 ms | 73.08 ms | 128.96 ms | 505 | 4462 | 0 | 0 | |
root | show_fields | 424 | 459.30 ms | 6.92 ms | 168.63 ms | 21464 | 108700 | 0 | 0 | |
root | show_variables | 480 | 458.33 ms | 5.84 ms | 48.32 ms | 4979 | 275394 | 0 | 480 | |
root | set_option | 1235 | 82.73 ms | 7.02 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 216 | 51.93 ms | 4.72 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 96 | 30.30 ms | 2.16 ms | 16.02 ms | 683 | 2124 | 0 | 0 | |
root | Init DB | 353 | 25.55 ms | 1.13 ms | 4.42 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 184 | 13.81 ms | 253.17 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 211 | 6.18 ms | 79.35 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 47 | 5.68 ms | 361.87 us | 3.17 ms | 0 | 0 | 0 | 0 | |
root | Quit | 425 | 2.76 ms | 173.41 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Prepare | 10 | 1.85 ms | 1.09 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 1348 | 1.62 ms | 527.37 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 2 | 1.58 ms | 1.53 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 10 | 1.57 ms | 656.63 us | 601.00 us | 9 | 11 | 0 | 1 | |
root | show_binlogs | 5 | 1.56 ms | 1.26 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 573 | 1.47 ms | 712.62 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 2 | 1.18 ms | 1.15 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | error | 19 | 1.06 ms | 325.71 us | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 1 | 1.00 ms | 1.00 ms | 0 ps | 0 | 1 | 0 | 0 |
|