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 | 446.27 us | 446.27 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 359 | 77.51 ms | 574.84 us | 31.47 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 359 | 38.26 ms | 336.24 us | 12.89 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 358 | 2.62 ms | 38.87 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 6734 | 3.05 s | 54.87 ms | 950.42 ms | 28345 | 277272 | 0 | 3160 | |
root | show_keys | 276 | 752.32 ms | 83.16 ms | 98.13 ms | 337 | 4266 | 0 | 0 | |
root | show_fields | 325 | 323.14 ms | 6.61 ms | 129.99 ms | 12353 | 62964 | 0 | 0 | |
root | show_variables | 331 | 321.45 ms | 6.71 ms | 31.51 ms | 331 | 189973 | 0 | 331 | |
root | set_option | 1195 | 106.01 ms | 5.56 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 200 | 66.62 ms | 3.44 ms | 32.75 ms | 1541 | 4315 | 0 | 0 | |
root | show_grants | 369 | 33.78 ms | 334.62 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 347 | 30.68 ms | 412.65 us | 6.73 ms | 0 | 0 | 0 | 0 | |
root | show_create_table | 158 | 28.95 ms | 1.70 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | error | 9 | 17.37 ms | 16.50 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 99 | 11.08 ms | 276.87 us | 5.87 ms | 0 | 0 | 0 | 0 | |
root | Prepare | 11 | 5.55 ms | 3.53 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 151 | 4.61 ms | 84.72 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 438 | 3.24 ms | 154.93 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 27 | 2.75 ms | 1.08 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 11 | 2.05 ms | 562.21 us | 598.00 us | 0 | 22 | 0 | 11 | |
root | show_storage_engines | 1 | 753.54 us | 753.54 us | 53.00 us | 9 | 9 | 0 | 1 | |
root | show_master_status | 1 | 481.19 us | 481.19 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Close stmt | 11 | 138.96 us | 33.31 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 1 | 44.78 us | 44.78 us | 0 ps | 0 | 0 | 0 | 0 |
|