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 | 2.54 ms | 2.54 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 2935 | 530.42 ms | 1.73 ms | 215.07 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 2876 | 245.60 ms | 1.42 ms | 85.80 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 2905 | 18.54 ms | 39.88 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 154116 | 1.08 m | 368.85 ms | 20.86 s | 392722 | 2863266 | 0 | 39544 | |
root | show_keys | 5857 | 5.95 s | 1.17 s | 2.20 s | 5791 | 97611 | 0 | 0 | |
root | show_fields | 5955 | 5.93 s | 6.07 ms | 2.35 s | 238509 | 1215191 | 0 | 0 | |
root | show_variables | 5509 | 4.77 s | 8.06 ms | 481.71 ms | 6060 | 3161263 | 0 | 5509 | |
root | show_tables | 3041 | 2.12 s | 5.72 ms | 1.14 s | 64825 | 187955 | 0 | 0 | |
root | create_table | 5 | 1.12 s | 324.33 ms | 4.16 ms | 0 | 0 | 0 | 0 | |
root | set_option | 12139 | 690.42 ms | 5.20 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 3021 | 607.55 ms | 4.84 ms | 662.00 us | 0 | 0 | 0 | 0 | |
root | create_db | 7 | 203.72 ms | 70.49 ms | 2.62 ms | 0 | 0 | 4 | 0 | |
root | Init DB | 4123 | 188.95 ms | 416.20 us | 5.24 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 2345 | 184.91 ms | 1.34 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 137 | 136.80 ms | 73.74 ms | 42.88 ms | 20 | 222 | 0 | 0 | |
root | show_warnings | 2627 | 80.54 ms | 432.58 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 5248 | 33.65 ms | 219.83 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 81 | 21.12 ms | 6.05 ms | 1.68 ms | 0 | 0 | 0 | 0 | |
root | show_status | 1 | 17.45 ms | 17.45 ms | 154.00 us | 450 | 450 | 0 | 1 | |
root | jump_if_not | 14664 | 13.16 ms | 1.75 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_func | 67 | 12.31 ms | 2.85 ms | 3.45 ms | 0 | 0 | 0 | 0 | |
root | show_binlogs | 115 | 7.93 ms | 699.04 us | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 13 | 6.77 ms | 2.23 ms | 0 ps | 0 | 13 | 0 | 0 | |
root | freturn | 2443 | 5.94 ms | 2.06 ms | 0 ps | 0 | 0 | 0 | 0 |
|