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.10 ms | 3.10 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 474 | 106.43 ms | 737.60 us | 42.70 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 474 | 51.54 ms | 316.64 us | 18.10 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 473 | 3.17 ms | 27.22 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 15571 | 11.92 s | 1.09 s | 2.24 s | 46490 | 361709 | 0 | 4252 | |
root | show_keys | 635 | 1.56 s | 515.50 ms | 240.46 ms | 462 | 6678 | 0 | 0 | |
root | show_variables | 578 | 776.90 ms | 170.80 ms | 53.46 ms | 578 | 331730 | 0 | 578 | |
root | show_fields | 565 | 538.58 ms | 9.36 ms | 226.77 ms | 19317 | 98559 | 0 | 0 | |
root | create_table | 2 | 502.32 ms | 275.45 ms | 8.66 ms | 0 | 0 | 0 | 0 | |
root | show_create_table | 282 | 132.59 ms | 43.57 ms | 232.00 us | 0 | 0 | 0 | 0 | |
root | set_option | 1580 | 125.39 ms | 5.56 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 157 | 112.66 ms | 4.17 ms | 56.46 ms | 3540 | 8985 | 0 | 0 | |
root | create_db | 2 | 109.31 ms | 58.41 ms | 2.46 ms | 0 | 0 | 2 | 0 | |
root | show_warnings | 261 | 36.34 ms | 28.00 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_grants | 302 | 23.00 ms | 310.45 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 24 | 20.71 ms | 14.96 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 396 | 20.21 ms | 313.49 us | 1.10 ms | 0 | 0 | 0 | 0 | |
root | freturn | 746 | 11.06 ms | 9.08 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 26 | 10.37 ms | 3.87 ms | 1.56 ms | 0 | 0 | 0 | 0 | |
root | show_table_status | 5 | 5.35 ms | 2.53 ms | 4.39 ms | 0 | 73 | 0 | 0 | |
root | Quit | 579 | 4.88 ms | 1.36 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_func | 22 | 3.70 ms | 553.82 us | 1.02 ms | 0 | 0 | 0 | 0 | |
root | show_master_status | 11 | 2.83 ms | 2.08 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 11 | 2.39 ms | 1.34 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 1 | 1.24 ms | 1.24 ms | 0 ps | 0 | 1 | 0 | 0 |
|