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 | 1990 | 488.16 ms | 32.67 ms | 211.38 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1990 | 186.50 ms | 534.80 us | 64.40 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1988 | 11.66 ms | 38.17 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 262485 | 1.59 m | 1.06 s | 36.94 s | 411293 | 2810097 | 0 | 27233 | |
root | show_keys | 5120 | 4.92 s | 118.81 ms | 1.83 s | 3879 | 49050 | 0 | 0 | |
root | show_fields | 4253 | 3.87 s | 4.81 ms | 1.62 s | 151009 | 769589 | 0 | 0 | |
root | show_variables | 3876 | 3.28 s | 10.16 ms | 333.72 ms | 3872 | 2224404 | 0 | 3876 | |
root | show_tables | 978 | 700.82 ms | 4.97 ms | 353.53 ms | 25694 | 65272 | 0 | 0 | |
root | set_option | 7276 | 451.65 ms | 11.74 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 2117 | 441.23 ms | 3.89 ms | 501.00 us | 0 | 0 | 0 | 0 | |
root | Init DB | 2521 | 109.21 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 | 1157 | 86.10 ms | 966.97 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 1894 | 58.35 ms | 236.23 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 61761 | 57.78 ms | 3.36 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 24366 | 29.54 ms | 1.12 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 2855 | 18.46 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 |
|