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 | 106.21 us | 106.21 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 3749 | 681.41 ms | 2.46 ms | 279.35 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 3749 | 310.42 ms | 401.88 us | 108.63 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 3748 | 23.25 ms | 119.61 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 280786 | 1.60 m | 1.23 s | 38.63 s | 513012 | 4142487 | 0 | 46397 | |
root | show_fields | 6995 | 7.17 s | 7.73 ms | 2.66 s | 338490 | 1715504 | 0 | 0 | |
root | show_variables | 6929 | 5.87 s | 8.60 ms | 591.38 ms | 6929 | 3976952 | 0 | 6929 | |
root | show_keys | 6510 | 4.61 s | 85.63 ms | 2.31 s | 7195 | 75325 | 0 | 0 | |
root | show_create_table | 3532 | 756.96 ms | 8.62 ms | 149.00 us | 0 | 0 | 0 | 0 | |
root | show_tables | 1051 | 708.98 ms | 3.97 ms | 389.27 ms | 21962 | 56958 | 0 | 0 | |
root | set_option | 12094 | 645.55 ms | 5.71 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_table | 1 | 214.17 ms | 214.17 ms | 1.47 ms | 0 | 0 | 0 | 0 | |
root | Init DB | 4079 | 180.70 ms | 492.44 us | 2.26 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 1557 | 114.64 ms | 574.37 us | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 2 | 111.49 ms | 62.44 ms | 2.68 ms | 0 | 0 | 2 | 0 | |
root | show_warnings | 3400 | 97.26 ms | 175.62 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 60448 | 50.67 ms | 2.40 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 43 | 32.51 ms | 2.32 ms | 22.60 ms | 1 | 82 | 0 | 0 | |
root | show_create_proc | 133 | 31.75 ms | 8.38 ms | 5.47 ms | 0 | 0 | 0 | 0 | |
root | Quit | 4410 | 28.15 ms | 243.48 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 21629 | 24.98 ms | 2.97 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 52 | 18.32 ms | 2.04 ms | 0 ps | 0 | 52 | 0 | 0 | |
root | show_binlogs | 118 | 14.07 ms | 2.81 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_func | 114 | 11.06 ms | 581.64 us | 895.00 us | 0 | 0 | 0 | 0 | |
root | set | 104 | 4.71 ms | 1.50 ms | 0 ps | 0 | 52 | 0 | 0 |
|