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.69 ms | 4.69 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 972 | 224.82 ms | 622.75 us | 91.74 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 972 | 108.98 ms | 410.38 us | 37.88 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 973 | 6.58 ms | 40.22 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 77691 | 31.13 s | 814.81 ms | 9.76 s | 155645 | 1116877 | 0 | 14128 | |
root | show_keys | 2277 | 2.46 s | 84.75 ms | 780.93 ms | 1808 | 23966 | 0 | 0 | |
root | show_fields | 1963 | 1.73 s | 7.45 ms | 716.81 ms | 71695 | 365280 | 0 | 0 | |
root | show_variables | 1880 | 1.57 s | 30.18 ms | 166.89 ms | 3004 | 1079015 | 0 | 1880 | |
root | show_tables | 462 | 339.54 ms | 4.31 ms | 166.26 ms | 11854 | 29826 | 0 | 0 | |
root | set_option | 3530 | 269.68 ms | 5.68 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 1007 | 203.72 ms | 3.53 ms | 909.00 us | 0 | 0 | 0 | 0 | |
root | show_grants | 938 | 69.27 ms | 1.55 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 1233 | 57.69 ms | 438.42 us | 2.21 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 903 | 28.54 ms | 480.19 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 15937 | 22.05 ms | 3.92 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 104 | 16.96 ms | 2.38 ms | 2.05 ms | 0 | 0 | 0 | 0 | |
root | freturn | 8448 | 16.24 ms | 1.12 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 54 | 11.13 ms | 3.92 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 1380 | 10.25 ms | 242.63 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_func | 88 | 9.11 ms | 483.88 us | 1.59 ms | 0 | 0 | 0 | 0 | |
root | set | 164 | 7.25 ms | 861.04 us | 0 ps | 0 | 32 | 0 | 0 | |
root | Prepare | 3 | 3.19 ms | 2.81 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 5 | 2.84 ms | 2.05 ms | 2.58 ms | 45 | 45 | 0 | 5 | |
root | stmt | 7 | 2.75 ms | 899.66 us | 0 ps | 0 | 7 | 0 | 0 | |
root | Execute | 3 | 1.50 ms | 1.21 ms | 1.01 ms | 0 | 6 | 0 | 3 |
|