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 | 890.51 us | 890.51 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 4442 | 853.59 ms | 1.65 ms | 345.84 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 4442 | 397.69 ms | 411.21 us | 137.43 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 4441 | 28.94 ms | 67.81 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 199285 | 1.83 m | 994.74 ms | 26.44 s | 559859 | 7041877 | 0 | 57383 | |
root | show_fields | 9610 | 9.08 s | 8.53 ms | 3.67 s | 354778 | 1810300 | 0 | 0 | |
root | show_keys | 9699 | 7.87 s | 100.81 ms | 3.54 s | 9458 | 147897 | 0 | 0 | |
root | show_variables | 8880 | 7.56 s | 5.10 ms | 761.43 ms | 9012 | 5095902 | 0 | 8880 | |
root | alter_table | 8 | 3.27 s | 454.94 ms | 1.45 ms | 0 | 0 | 9 | 0 | |
root | show_tables | 4177 | 3.10 s | 5.43 ms | 1.60 s | 97826 | 281286 | 0 | 0 | |
root | create_table | 26 | 3.01 s | 244.34 ms | 7.24 ms | 0 | 0 | 0 | 0 | |
root | set_option | 18417 | 1.08 s | 8.33 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 4923 | 942.10 ms | 9.48 ms | 866.00 us | 0 | 0 | 0 | 0 | |
root | insert | 15 | 447.40 ms | 45.99 ms | 5.56 ms | 0 | 0 | 32 | 0 | |
root | Init DB | 6520 | 305.00 ms | 409.74 us | 7.68 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 3627 | 278.04 ms | 1.68 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 6 | 273.81 ms | 60.12 ms | 3.26 ms | 0 | 0 | 6 | 0 | |
root | show_warnings | 4175 | 128.12 ms | 389.58 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 7881 | 52.12 ms | 750.49 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 75441 | 50.62 ms | 494.31 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 21230 | 32.93 ms | 1.65 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 122 | 30.37 ms | 3.49 ms | 19.40 ms | 1 | 45 | 0 | 0 | |
root | drop_db | 1 | 19.58 ms | 19.58 ms | 48.00 us | 0 | 0 | 0 | 0 | |
root | show_binlogs | 95 | 12.31 ms | 2.37 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_func | 27 | 8.42 ms | 2.45 ms | 1.00 ms | 0 | 0 | 0 | 0 |
|