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.22 ms | 1.22 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 3584 | 694.40 ms | 785.56 us | 282.14 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 3584 | 325.58 ms | 390.60 us | 111.94 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 3582 | 22.09 ms | 107.93 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 237788 | 1.39 m | 707.47 ms | 30.96 s | 456838 | 3066135 | 0 | 48938 | |
root | show_fields | 7519 | 7.39 s | 6.12 ms | 2.77 s | 354852 | 1799113 | 0 | 0 | |
root | show_variables | 7437 | 6.21 s | 4.49 ms | 640.86 ms | 7989 | 4268754 | 0 | 7437 | |
root | show_keys | 7217 | 5.05 s | 86.77 ms | 2.49 s | 7635 | 83547 | 0 | 0 | |
root | show_create_table | 3857 | 776.63 ms | 5.95 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | set_option | 12080 | 694.80 ms | 5.12 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 943 | 651.27 ms | 5.40 ms | 322.25 ms | 25999 | 60347 | 0 | 0 | |
root | Init DB | 4188 | 185.47 ms | 2.13 ms | 2.84 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 1514 | 111.46 ms | 1.87 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 3680 | 107.34 ms | 821.74 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 4469 | 32.64 ms | 1.22 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 28065 | 22.48 ms | 301.94 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_status | 1 | 17.73 ms | 17.73 ms | 154.00 us | 450 | 450 | 0 | 1 | |
root | freturn | 12094 | 17.10 ms | 1.75 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 26 | 13.41 ms | 3.35 ms | 4.67 ms | 0 | 0 | 0 | 0 | |
root | stmt | 17 | 11.20 ms | 2.19 ms | 0 ps | 0 | 17 | 0 | 0 | |
root | show_binlogs | 75 | 10.22 ms | 1.91 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 4 | 7.70 ms | 5.47 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_func | 22 | 4.83 ms | 1.02 ms | 916.00 us | 0 | 0 | 0 | 0 | |
root | show_slave_status | 4 | 2.41 ms | 1.53 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 34 | 2.18 ms | 1.11 ms | 0 ps | 0 | 17 | 0 | 0 |
|