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.13 ms | 1.13 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 473 | 106.28 ms | 628.90 us | 43.42 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 473 | 52.60 ms | 335.81 us | 17.92 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 472 | 3.05 ms | 24.57 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 13667 | 6.94 s | 296.02 ms | 1.82 s | 54826 | 1285703 | 0 | 4297 | |
root | show_keys | 490 | 1.83 s | 90.22 ms | 183.33 ms | 873 | 10903 | 0 | 0 | |
root | show_fields | 657 | 612.68 ms | 8.72 ms | 258.11 ms | 21913 | 112288 | 0 | 0 | |
root | show_variables | 576 | 515.12 ms | 5.12 ms | 52.68 ms | 565 | 329784 | 0 | 576 | |
root | show_table_status | 11 | 451.00 ms | 302.61 ms | 5.77 ms | 190 | 1119 | 0 | 0 | |
root | show_tables | 271 | 224.06 ms | 5.62 ms | 122.82 ms | 4807 | 23217 | 0 | 0 | |
root | set_option | 1551 | 138.16 ms | 19.47 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 328 | 63.84 ms | 5.71 ms | 125.00 us | 0 | 0 | 0 | 0 | |
root | show_grants | 492 | 38.24 ms | 335.04 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 539 | 29.28 ms | 639.91 us | 1.16 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 239 | 7.08 ms | 184.06 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 26 | 5.37 ms | 1.95 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 3 | 5.04 ms | 4.71 ms | 2.02 ms | 0 | 0 | 0 | 0 | |
root | Quit | 560 | 3.62 ms | 216.88 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 28 | 2.71 ms | 297.26 us | 1.27 ms | 252 | 252 | 0 | 28 | |
root | show_create_func | 3 | 2.66 ms | 2.27 ms | 1.64 ms | 0 | 0 | 0 | 0 | |
root | Prepare | 11 | 1.91 ms | 364.60 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 11 | 1.76 ms | 358.97 us | 522.00 us | 1 | 23 | 0 | 11 | |
root | error | 4 | 703.47 us | 623.11 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 5 | 490.73 us | 191.23 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 5 | 400.60 us | 154.23 us | 0 ps | 0 | 0 | 0 | 0 |
|