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.18 ms | 1.18 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1998 | 489.85 ms | 32.67 ms | 212.08 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1998 | 187.32 ms | 534.80 us | 64.68 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1997 | 11.71 ms | 38.17 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 262980 | 1.60 m | 1.06 s | 37.01 s | 412347 | 2822480 | 0 | 27333 | |
root | show_keys | 5153 | 4.94 s | 118.81 ms | 1.85 s | 3883 | 49174 | 0 | 0 | |
root | show_fields | 4272 | 3.89 s | 4.81 ms | 1.62 s | 151406 | 771633 | 0 | 0 | |
root | show_variables | 3894 | 3.30 s | 10.16 ms | 335.21 ms | 3890 | 2234736 | 0 | 3894 | |
root | show_tables | 986 | 709.85 ms | 4.97 ms | 358.47 ms | 25831 | 65564 | 0 | 0 | |
root | set_option | 7309 | 454.09 ms | 11.74 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 2127 | 443.97 ms | 3.89 ms | 501.00 us | 0 | 0 | 0 | 0 | |
root | Init DB | 2534 | 110.00 ms | 363.69 us | 2.05 ms | 0 | 0 | 0 | 0 | |
root | create_db | 2 | 102.38 ms | 60.59 ms | 1.68 ms | 0 | 0 | 2 | 0 | |
root | show_table_status | 21 | 88.28 ms | 77.18 ms | 8.91 ms | 33 | 244 | 0 | 0 | |
root | show_grants | 1163 | 86.59 ms | 966.97 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 1903 | 58.68 ms | 236.23 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 62325 | 58.07 ms | 3.36 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 24443 | 29.62 ms | 1.12 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 2868 | 18.54 ms | 241.42 us | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 29 | 11.59 ms | 2.11 ms | 0 ps | 0 | 29 | 0 | 0 | |
root | show_create_proc | 52 | 10.86 ms | 1.50 ms | 2.53 ms | 0 | 0 | 0 | 0 | |
root | show_binlogs | 48 | 9.76 ms | 2.21 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_func | 44 | 8.40 ms | 2.16 ms | 866.00 us | 0 | 0 | 0 | 0 | |
root | Prepare | 4 | 3.95 ms | 3.41 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 8 | 3.93 ms | 2.77 ms | 0 ps | 0 | 0 | 0 | 0 |
|