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 | 3.40 ms | 3.40 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 258 | 56.66 ms | 827.94 us | 23.42 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 258 | 28.92 ms | 1.27 ms | 9.15 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 258 | 1.78 ms | 23.93 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 10304 | 5.78 s | 596.14 ms | 1.35 s | 28289 | 850719 | 0 | 2800 | |
root | show_keys | 338 | 830.62 ms | 65.65 ms | 125.86 ms | 353 | 5699 | 0 | 0 | |
root | show_fields | 343 | 327.75 ms | 3.10 ms | 131.28 ms | 13081 | 66722 | 0 | 0 | |
root | show_variables | 311 | 293.52 ms | 4.60 ms | 28.25 ms | 311 | 178451 | 0 | 311 | |
root | show_tables | 192 | 79.37 ms | 6.53 ms | 41.14 ms | 2527 | 7689 | 0 | 0 | |
root | set_option | 905 | 78.04 ms | 4.51 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 167 | 36.59 ms | 1.77 ms | 106.00 us | 0 | 0 | 0 | 0 | |
root | show_grants | 296 | 24.33 ms | 556.55 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 319 | 22.71 ms | 923.98 us | 4.64 ms | 0 | 0 | 0 | 0 | |
root | show_table_status | 27 | 22.09 ms | 15.36 ms | 3.54 ms | 69 | 311 | 0 | 0 | |
root | show_warnings | 141 | 4.46 ms | 120.14 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 16 | 3.68 ms | 2.77 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 357 | 2.24 ms | 183.78 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 3 | 780.26 us | 618.83 us | 599.00 us | 27 | 27 | 0 | 3 | |
root | error | 7 | 638.14 us | 415.88 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 514 | 482.41 us | 175.52 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 67 | 411.99 us | 332.38 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 1 | 49.84 us | 49.84 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 1 | 43.14 us | 43.14 us | 0 ps | 0 | 0 | 0 | 0 |
|