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 | 145.86 us | 145.86 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 651 | 127.23 ms | 2.80 ms | 49.13 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 651 | 55.99 ms | 490.12 us | 19.93 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 651 | 4.12 ms | 76.96 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 55447 | 22.57 s | 1.30 s | 8.14 s | 96076 | 633726 | 0 | 5345 | |
root | show_keys | 731 | 1.21 s | 130.49 ms | 277.62 ms | 566 | 6170 | 0 | 0 | |
root | show_variables | 823 | 950.90 ms | 102.53 ms | 117.59 ms | 823 | 472276 | 0 | 823 | |
root | show_fields | 652 | 664.45 ms | 7.56 ms | 266.48 ms | 24589 | 125097 | 0 | 0 | |
root | create_db | 6 | 248.29 ms | 47.04 ms | 3.86 ms | 0 | 0 | 6 | 0 | |
root | create_table | 3 | 247.14 ms | 157.33 ms | 3.14 ms | 0 | 0 | 0 | 0 | |
root | insert | 8 | 226.20 ms | 43.11 ms | 12.22 ms | 0 | 0 | 3338 | 0 | |
root | set_option | 2101 | 131.94 ms | 4.84 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 189 | 97.54 ms | 4.44 ms | 53.21 ms | 2305 | 6156 | 0 | 0 | |
root | show_table_status | 56 | 80.82 ms | 67.87 ms | 8.98 ms | 33 | 246 | 0 | 0 | |
root | show_create_table | 326 | 80.29 ms | 4.37 ms | 142.00 us | 0 | 0 | 0 | 0 | |
root | show_binlogs | 25 | 59.04 ms | 57.07 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 557 | 32.82 ms | 323.82 us | 4.26 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 272 | 22.39 ms | 644.81 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 22296 | 21.67 ms | 3.03 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 9961 | 14.93 ms | 820.75 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 351 | 11.76 ms | 300.57 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 11 | 9.26 ms | 7.41 ms | 8.35 ms | 99 | 99 | 0 | 11 | |
root | error | 31 | 6.64 ms | 5.20 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 730 | 5.79 ms | 239.54 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 17 | 2.50 ms | 1.51 ms | 0 ps | 0 | 0 | 0 | 0 |
|