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 | 4.22 ms | 4.22 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 544 | 97.66 ms | 1.19 ms | 39.54 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 544 | 41.70 ms | 288.66 us | 14.56 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 538 | 3.43 ms | 22.69 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 11361 | 6.91 s | 995.46 ms | 1.57 s | 40001 | 354388 | 0 | 4332 | |
root | show_fields | 742 | 777.39 ms | 32.76 ms | 282.51 ms | 33142 | 168372 | 0 | 0 | |
root | show_keys | 493 | 637.19 ms | 76.14 ms | 180.85 ms | 757 | 5961 | 0 | 0 | |
root | show_variables | 630 | 561.97 ms | 7.92 ms | 57.90 ms | 630 | 361599 | 0 | 630 | |
root | show_tables | 272 | 179.91 ms | 2.83 ms | 93.25 ms | 5962 | 31917 | 0 | 0 | |
root | set_option | 1670 | 133.44 ms | 30.86 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 305 | 82.68 ms | 16.10 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 1 | 44.27 ms | 44.27 ms | 3.86 ms | 0 | 0 | 1 | 0 | |
root | show_grants | 317 | 24.79 ms | 510.64 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 479 | 23.66 ms | 1.19 ms | 994.00 us | 0 | 0 | 0 | 0 | |
root | show_binlogs | 119 | 10.41 ms | 654.78 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 295 | 9.11 ms | 557.62 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 2005 | 7.02 ms | 1.98 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 570 | 4.04 ms | 166.06 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 2 | 3.00 ms | 2.86 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 1362 | 2.55 ms | 959.74 us | 0 ps | 0 | 0 | 0 | 0 | |
root | error | 7 | 2.36 ms | 1.94 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 6 | 1.69 ms | 1.15 ms | 1.37 ms | 0 | 0 | 0 | 0 | |
root | show_master_status | 2 | 1.06 ms | 1.00 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 1 | 789.74 us | 789.74 us | 0 ps | 0 | 1 | 0 | 0 | |
root | set | 2 | 757.67 us | 756.26 us | 0 ps | 0 | 1 | 0 | 0 |
|