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.23 ms | 1.23 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1016 | 182.04 ms | 1.46 ms | 74.90 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1002 | 81.19 ms | 470.33 us | 28.43 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1007 | 6.30 ms | 108.56 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 43280 | 16.01 s | 117.09 ms | 6.02 s | 104406 | 1080904 | 0 | 13399 | |
root | show_fields | 2010 | 2.11 s | 5.18 ms | 769.12 ms | 98911 | 501977 | 0 | 0 | |
root | show_variables | 1909 | 1.72 s | 6.84 ms | 169.73 ms | 3034 | 1095703 | 0 | 1909 | |
root | show_keys | 1588 | 1.59 s | 69.96 ms | 577.17 ms | 2101 | 32135 | 0 | 0 | |
root | show_tables | 677 | 433.61 ms | 5.61 ms | 214.47 ms | 15478 | 46939 | 0 | 0 | |
root | set_option | 3942 | 220.78 ms | 5.05 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 1014 | 208.34 ms | 4.22 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 1343 | 72.79 ms | 1.97 ms | 9.06 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 844 | 66.46 ms | 1.56 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 925 | 27.99 ms | 215.59 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 201 | 25.43 ms | 937.15 us | 13.64 ms | 0 | 0 | 0 | 0 | |
root | Quit | 1611 | 10.41 ms | 301.59 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 8513 | 7.21 ms | 228.82 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 1425 | 3.99 ms | 742.76 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Prepare | 32 | 3.91 ms | 1.09 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlog_events | 1 | 3.42 ms | 3.42 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 32 | 3.11 ms | 228.95 us | 953.00 us | 0 | 64 | 0 | 32 | |
root | show_storage_engines | 2 | 2.09 ms | 2.02 ms | 1.99 ms | 18 | 18 | 0 | 2 | |
root | show_binlogs | 32 | 2.03 ms | 170.33 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_func | 3 | 1.05 ms | 567.74 us | 343.00 us | 0 | 0 | 0 | 0 | |
root | stmt | 6 | 976.61 us | 650.72 us | 0 ps | 0 | 6 | 0 | 0 |
|