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.18 ms | 1.18 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 790 | 246.18 ms | 32.67 ms | 113.01 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 790 | 71.28 ms | 493.82 us | 24.57 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 788 | 4.48 ms | 30.93 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 125599 | 48.48 s | 1.06 s | 18.30 s | 183414 | 1251399 | 0 | 10510 | |
root | show_keys | 1980 | 2.10 s | 77.20 ms | 729.06 ms | 1383 | 18072 | 0 | 0 | |
root | show_fields | 1615 | 1.50 s | 4.66 ms | 629.67 ms | 56606 | 288530 | 0 | 0 | |
root | show_variables | 1507 | 1.32 s | 10.16 ms | 127.30 ms | 1506 | 864871 | 0 | 1507 | |
root | show_tables | 365 | 259.21 ms | 4.97 ms | 131.07 ms | 9219 | 23620 | 0 | 0 | |
root | show_create_table | 812 | 184.98 ms | 3.89 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | set_option | 2860 | 183.45 ms | 11.74 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 2 | 102.38 ms | 60.59 ms | 1.68 ms | 0 | 0 | 2 | 0 | |
root | Init DB | 983 | 42.21 ms | 337.77 us | 1.05 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 497 | 37.48 ms | 966.97 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 29471 | 32.68 ms | 3.36 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 733 | 22.35 ms | 183.55 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 13511 | 17.82 ms | 1.02 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 15 | 8.46 ms | 2.06 ms | 6.40 ms | 0 | 12 | 0 | 0 | |
root | show_binlogs | 18 | 7.96 ms | 2.21 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 1112 | 7.57 ms | 237.07 us | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 16 | 5.43 ms | 2.05 ms | 0 ps | 0 | 16 | 0 | 0 | |
root | show_master_status | 7 | 3.81 ms | 2.77 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 15 | 2.66 ms | 834.85 us | 1.67 ms | 135 | 135 | 0 | 15 | |
root | set | 32 | 2.21 ms | 778.85 us | 0 ps | 0 | 16 | 0 | 0 | |
root | show_slave_status | 7 | 1.38 ms | 897.10 us | 0 ps | 0 | 0 | 0 | 0 |
|