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.30 ms | 1.30 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 693 | 147.11 ms | 2.52 ms | 58.61 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 693 | 67.73 ms | 447.15 us | 23.47 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 695 | 5.55 ms | 106.08 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 10256 | 7.14 s | 638.06 ms | 1.50 s | 75914 | 473654 | 0 | 4834 | |
root | show_keys | 189 | 613.53 ms | 120.62 ms | 70.91 ms | 263 | 3224 | 0 | 0 | |
root | show_variables | 433 | 436.06 ms | 8.50 ms | 41.41 ms | 433 | 248395 | 0 | 433 | |
root | create_db | 5 | 251.08 ms | 62.68 ms | 1.68 ms | 0 | 0 | 5 | 0 | |
root | show_fields | 244 | 246.55 ms | 2.85 ms | 97.75 ms | 10063 | 51194 | 0 | 0 | |
root | show_tables | 468 | 241.74 ms | 4.21 ms | 136.22 ms | 3126 | 8602 | 0 | 0 | |
root | create_table | 2 | 217.39 ms | 216.83 ms | 1.70 ms | 0 | 0 | 0 | 0 | |
root | set_option | 2278 | 185.44 ms | 6.18 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 587 | 53.21 ms | 432.79 us | 10.16 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 444 | 41.28 ms | 341.52 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 119 | 26.63 ms | 2.55 ms | 157.00 us | 0 | 0 | 0 | 0 | |
root | show_table_status | 66 | 24.29 ms | 2.47 ms | 16.03 ms | 0 | 32 | 0 | 0 | |
root | show_binlogs | 96 | 9.99 ms | 3.72 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 11314 | 7.28 ms | 1.11 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 837 | 7.07 ms | 205.58 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 3334 | 5.26 ms | 428.33 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 132 | 4.53 ms | 185.19 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 39 | 3.81 ms | 810.62 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 39 | 3.49 ms | 1.49 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlog_events | 1 | 2.56 ms | 2.56 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | error | 20 | 2.44 ms | 1.31 ms | 0 ps | 0 | 0 | 0 | 0 |
|