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.22 ms | 1.22 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 249 | 39.52 ms | 440.99 us | 16.30 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 249 | 16.00 ms | 307.99 us | 5.66 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 247 | 1.61 ms | 22.83 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 11550 | 4.93 s | 344.31 ms | 1.47 s | 25612 | 178231 | 0 | 3255 | |
root | show_keys | 475 | 681.10 ms | 72.73 ms | 170.84 ms | 514 | 5672 | 0 | 0 | |
root | show_fields | 499 | 521.72 ms | 5.45 ms | 194.20 ms | 23443 | 118870 | 0 | 0 | |
root | show_variables | 506 | 444.94 ms | 4.49 ms | 46.76 ms | 506 | 290444 | 0 | 506 | |
root | show_create_table | 261 | 55.13 ms | 2.82 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | set_option | 813 | 38.85 ms | 3.62 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 47 | 24.38 ms | 1.32 ms | 12.39 ms | 1305 | 3057 | 0 | 0 | |
root | show_grants | 197 | 16.53 ms | 1.87 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 282 | 11.97 ms | 165.42 us | 451.00 us | 0 | 0 | 0 | 0 | |
root | show_warnings | 251 | 7.40 ms | 80.81 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 5 | 2.20 ms | 1.91 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 291 | 1.85 ms | 147.02 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 50 | 646.86 us | 547.82 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 274 | 242.65 us | 6.72 us | 0 ps | 0 | 0 | 0 | 0 |
|