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 | 3.37 ms | 3.37 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 542 | 130.56 ms | 669.73 us | 51.98 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 542 | 64.45 ms | 320.32 us | 21.85 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 540 | 3.69 ms | 116.04 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 21614 | 12.19 s | 521.00 ms | 3.49 s | 67451 | 564468 | 0 | 4405 | |
root | show_keys | 1172 | 1.63 s | 99.69 ms | 426.48 ms | 488 | 7902 | 0 | 0 | |
root | show_fields | 887 | 771.19 ms | 26.92 ms | 362.39 ms | 18332 | 94629 | 0 | 0 | |
root | show_variables | 715 | 639.82 ms | 17.47 ms | 66.08 ms | 715 | 409528 | 0 | 715 | |
root | set_option | 1419 | 140.52 ms | 5.93 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 393 | 98.75 ms | 7.61 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 104 | 61.03 ms | 3.08 ms | 31.53 ms | 1546 | 5928 | 0 | 0 | |
root | show_grants | 535 | 45.32 ms | 3.19 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 624 | 37.17 ms | 847.90 us | 2.25 ms | 0 | 0 | 0 | 0 | |
root | freturn | 9725 | 31.55 ms | 11.45 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 12746 | 12.33 ms | 2.20 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 298 | 9.20 ms | 150.93 us | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 4 | 6.07 ms | 2.26 ms | 0 ps | 0 | 4 | 0 | 0 | |
root | show_binlogs | 32 | 6.06 ms | 1.82 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 42 | 6.06 ms | 1.98 ms | 3.72 ms | 378 | 378 | 0 | 42 | |
root | show_table_status | 4 | 5.47 ms | 4.90 ms | 1.53 ms | 33 | 230 | 0 | 0 | |
root | Quit | 606 | 4.39 ms | 264.85 us | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 8 | 1.82 ms | 1.56 ms | 0 ps | 0 | 4 | 0 | 0 | |
root | error | 4 | 1.07 ms | 968.43 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 4 | 591.24 us | 476.22 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 4 | 562.20 us | 368.98 us | 0 ps | 0 | 0 | 0 | 0 |
|