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.94 ms | 1.94 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1230 | 296.40 ms | 829.70 us | 119.40 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1230 | 144.74 ms | 400.69 us | 48.94 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1228 | 7.83 ms | 31.35 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 22835 | 15.03 s | 290.54 ms | 3.03 s | 126513 | 2684922 | 0 | 10882 | |
root | show_keys | 1415 | 3.53 s | 106.27 ms | 564.89 ms | 1829 | 21368 | 0 | 0 | |
root | show_fields | 1441 | 1.31 s | 3.99 ms | 603.39 ms | 36035 | 185970 | 0 | 0 | |
root | show_table_status | 61 | 958.80 ms | 528.62 ms | 45.40 ms | 1631 | 10275 | 0 | 0 | |
root | show_variables | 1060 | 920.56 ms | 4.87 ms | 93.24 ms | 1029 | 605857 | 0 | 1060 | |
root | show_tables | 560 | 399.42 ms | 9.17 ms | 207.35 ms | 13699 | 73834 | 0 | 0 | |
root | set_option | 3834 | 332.73 ms | 11.12 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 701 | 147.02 ms | 14.08 ms | 1.83 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 1171 | 96.18 ms | 346.07 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 1272 | 75.78 ms | 2.17 ms | 3.49 ms | 0 | 0 | 0 | 0 | |
root | drop_db | 1 | 23.50 ms | 23.50 ms | 1.06 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 400 | 12.94 ms | 990.20 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 10849 | 10.69 ms | 1.33 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 96 | 10.28 ms | 448.78 us | 4.88 ms | 864 | 864 | 0 | 96 | |
root | Quit | 1324 | 10.09 ms | 281.57 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 80 | 7.21 ms | 2.47 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 3597 | 6.01 ms | 2.46 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 35 | 5.53 ms | 401.32 us | 1.68 ms | 0 | 70 | 0 | 35 | |
root | Prepare | 35 | 5.22 ms | 546.12 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 2 | 2.35 ms | 2.32 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 7 | 1.59 ms | 746.12 us | 0 ps | 0 | 7 | 0 | 0 |
|