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.37 ms | 3.37 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 632 | 153.18 ms | 669.73 us | 61.18 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 632 | 76.18 ms | 320.32 us | 25.70 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 631 | 4.26 ms | 116.04 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 29539 | 15.09 s | 521.00 ms | 4.57 s | 81926 | 750428 | 0 | 5081 | |
root | show_keys | 1340 | 1.80 s | 99.69 ms | 492.22 ms | 527 | 8801 | 0 | 0 | |
root | show_fields | 1004 | 880.02 ms | 26.92 ms | 414.50 ms | 20399 | 105345 | 0 | 0 | |
root | show_variables | 798 | 709.26 ms | 17.47 ms | 73.05 ms | 798 | 457065 | 0 | 798 | |
root | set_option | 1645 | 163.88 ms | 5.95 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 448 | 116.56 ms | 7.61 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 136499 | 97.07 ms | 2.20 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 117 | 67.78 ms | 3.08 ms | 35.08 ms | 1726 | 6709 | 0 | 0 | |
root | freturn | 38144 | 64.98 ms | 11.45 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_grants | 611 | 51.50 ms | 3.19 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 712 | 42.63 ms | 847.90 us | 2.44 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 331 | 10.19 ms | 150.93 us | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 14 | 9.58 ms | 2.26 ms | 0 ps | 0 | 14 | 0 | 0 | |
root | show_storage_engines | 48 | 6.78 ms | 1.98 ms | 4.05 ms | 432 | 432 | 0 | 48 | |
root | show_binlogs | 36 | 6.30 ms | 1.82 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 4 | 5.47 ms | 4.90 ms | 1.53 ms | 33 | 230 | 0 | 0 | |
root | Quit | 701 | 4.94 ms | 264.85 us | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 28 | 2.44 ms | 1.56 ms | 0 ps | 0 | 14 | 0 | 0 | |
root | error | 5 | 1.09 ms | 968.43 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 5 | 749.83 us | 476.22 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 5 | 747.42 us | 368.98 us | 0 ps | 0 | 0 | 0 | 0 |
|