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 | 3.57 ms | 3.57 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 291 | 54.38 ms | 588.03 us | 22.15 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 291 | 26.40 ms | 858.67 us | 9.02 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 290 | 2.32 ms | 406.44 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 4504 | 3.95 s | 534.86 ms | 682.60 ms | 30292 | 223564 | 0 | 2051 | |
root | show_keys | 200 | 1.55 s | 148.06 ms | 83.56 ms | 218 | 2984 | 0 | 0 | |
root | show_table_status | 35 | 948.93 ms | 242.80 ms | 12.39 ms | 157 | 748 | 0 | 0 | |
root | show_fields | 190 | 182.73 ms | 3.19 ms | 87.54 ms | 3486 | 18229 | 0 | 0 | |
root | show_variables | 149 | 173.51 ms | 4.64 ms | 14.01 ms | 149 | 85211 | 0 | 149 | |
root | show_tables | 188 | 132.72 ms | 4.20 ms | 75.02 ms | 2020 | 6835 | 0 | 0 | |
root | create_db | 2 | 129.18 ms | 74.63 ms | 834.00 us | 0 | 0 | 2 | 0 | |
root | set_option | 981 | 105.94 ms | 26.46 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 80 | 40.18 ms | 3.28 ms | 2.03 ms | 0 | 0 | 0 | 0 | |
root | Init DB | 244 | 17.19 ms | 317.43 us | 2.57 ms | 0 | 0 | 0 | 0 | |
root | show_create_proc | 26 | 14.89 ms | 6.18 ms | 2.14 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 117 | 9.60 ms | 307.45 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_func | 22 | 6.64 ms | 1.97 ms | 2.76 ms | 0 | 0 | 0 | 0 | |
root | freturn | 603 | 4.17 ms | 1.49 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 39 | 3.05 ms | 1.86 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Prepare | 4 | 2.87 ms | 2.42 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 16 | 2.72 ms | 702.99 us | 1.36 ms | 144 | 144 | 0 | 16 | |
root | jump_if_not | 1549 | 2.72 ms | 713.42 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 362 | 2.55 ms | 134.70 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 20 | 1.55 ms | 361.82 us | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 1 | 857.70 us | 857.70 us | 0 ps | 0 | 1 | 0 | 0 |
|