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.09 ms | 1.09 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1175 | 262.91 ms | 862.59 us | 107.19 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1175 | 128.58 ms | 602.71 us | 43.60 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1175 | 7.92 ms | 185.51 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 28828 | 11.12 s | 270.68 ms | 3.61 s | 104378 | 918603 | 0 | 11440 | |
root | alter_table | 16 | 5.97 s | 538.13 ms | 3.46 ms | 0 | 0 | 1 | 0 | |
root | create_table | 11 | 2.22 s | 317.24 ms | 6.12 ms | 0 | 0 | 0 | 0 | |
root | show_keys | 1184 | 1.80 s | 142.71 ms | 414.02 ms | 1637 | 23909 | 0 | 0 | |
root | show_variables | 1680 | 1.49 s | 7.50 ms | 151.91 ms | 1674 | 963669 | 0 | 1680 | |
root | show_fields | 1559 | 1.49 s | 4.49 ms | 583.12 ms | 66761 | 339787 | 0 | 0 | |
root | show_tables | 612 | 418.03 ms | 4.44 ms | 232.64 ms | 8479 | 26194 | 0 | 0 | |
root | set_option | 3937 | 309.29 ms | 7.22 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 809 | 150.18 ms | 5.47 ms | 965.00 us | 0 | 0 | 0 | 0 | |
root | create_db | 2 | 118.46 ms | 72.96 ms | 2.52 ms | 0 | 0 | 2 | 0 | |
root | show_grants | 1090 | 86.35 ms | 1.14 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 1307 | 78.81 ms | 631.55 us | 7.01 ms | 0 | 0 | 0 | 0 | |
root | insert | 1 | 51.44 ms | 51.44 ms | 3.32 ms | 0 | 0 | 1 | 0 | |
root | show_table_status | 109 | 26.61 ms | 3.17 ms | 13.88 ms | 72 | 388 | 0 | 0 | |
root | show_warnings | 735 | 24.12 ms | 191.90 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 1444 | 10.37 ms | 616.44 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 53 | 3.76 ms | 444.56 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 19 | 3.62 ms | 1.99 ms | 2.73 ms | 171 | 171 | 0 | 19 | |
root | Prepare | 17 | 3.27 ms | 1.21 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 17 | 2.00 ms | 324.40 us | 575.00 us | 0 | 34 | 0 | 17 | |
root | show_slave_status | 16 | 1.99 ms | 781.60 us | 0 ps | 0 | 0 | 0 | 0 |
|