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.38 ms | 1.38 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 451 | 74.75 ms | 6.44 ms | 27.92 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 451 | 28.78 ms | 281.40 us | 10.16 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 446 | 2.52 ms | 41.24 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 35696 | 21.23 s | 1.01 s | 7.87 s | 65911 | 473877 | 0 | 5649 | |
root | show_keys | 916 | 1.93 s | 571.04 ms | 415.07 ms | 608 | 8187 | 0 | 0 | |
root | show_variables | 720 | 892.98 ms | 71.09 ms | 68.56 ms | 8032 | 412776 | 0 | 720 | |
root | show_fields | 749 | 866.50 ms | 9.33 ms | 358.20 ms | 26209 | 133595 | 0 | 0 | |
root | show_tables | 234 | 117.01 ms | 2.53 ms | 57.87 ms | 5129 | 13082 | 0 | 0 | |
root | set_option | 1595 | 101.07 ms | 9.77 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 371 | 99.95 ms | 3.46 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_grants | 339 | 32.10 ms | 1.61 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 533 | 28.74 ms | 335.59 us | 3.05 ms | 0 | 0 | 0 | 0 | |
root | show_binlogs | 33 | 18.23 ms | 12.32 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 52 | 17.56 ms | 4.53 ms | 3.43 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 339 | 14.38 ms | 1.45 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_status | 7 | 9.93 ms | 5.10 ms | 1.13 ms | 3150 | 3150 | 0 | 7 | |
root | stmt | 4 | 9.51 ms | 7.29 ms | 0 ps | 0 | 4 | 0 | 0 | |
root | set | 8 | 9.36 ms | 7.24 ms | 0 ps | 0 | 4 | 0 | 0 | |
root | jump_if_not | 7543 | 9.17 ms | 492.64 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_func | 44 | 8.55 ms | 1.03 ms | 1.34 ms | 0 | 0 | 0 | 0 | |
root | Quit | 620 | 4.10 ms | 216.42 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 2662 | 3.69 ms | 621.24 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 24 | 3.08 ms | 168.83 us | 1.66 ms | 0 | 0 | 0 | 0 | |
root | show_binlog_events | 1 | 2.64 ms | 2.64 ms | 0 ps | 0 | 0 | 0 | 0 |
|