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.04 ms | 1.04 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 2371 | 508.68 ms | 892.71 us | 209.12 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 2371 | 246.41 ms | 376.66 us | 85.08 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 2371 | 16.91 ms | 44.18 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 88678 | 42.75 s | 503.39 ms | 11.56 s | 340161 | 3213714 | 0 | 23830 | |
root | show_keys | 3175 | 3.60 s | 127.37 ms | 1.14 s | 3321 | 52508 | 0 | 0 | |
root | show_fields | 3646 | 3.42 s | 7.22 ms | 1.39 s | 133563 | 681757 | 0 | 0 | |
root | show_variables | 3144 | 2.68 s | 4.65 ms | 276.68 ms | 3690 | 1803522 | 0 | 3144 | |
root | show_tables | 1916 | 1.42 s | 3.83 ms | 779.64 ms | 34795 | 111736 | 0 | 0 | |
root | create_table | 9 | 780.83 ms | 200.18 ms | 9.65 ms | 0 | 0 | 0 | 0 | |
root | set_option | 8841 | 612.20 ms | 6.31 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 1760 | 356.36 ms | 2.16 ms | 7.43 ms | 0 | 0 | 0 | 0 | |
root | create_db | 6 | 307.67 ms | 67.26 ms | 3.48 ms | 0 | 0 | 6 | 0 | |
root | insert | 9 | 229.77 ms | 47.83 ms | 3.26 ms | 0 | 0 | 7 | 0 | |
root | show_table_status | 199 | 146.16 ms | 12.89 ms | 88.09 ms | 247 | 1281 | 0 | 0 | |
root | Init DB | 2715 | 143.94 ms | 2.05 ms | 5.46 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 1569 | 127.50 ms | 566.51 us | 0 ps | 0 | 0 | 0 | 0 | |
root | grant | 2 | 60.86 ms | 36.61 ms | 1.27 ms | 0 | 0 | 0 | 0 | |
root | create_user | 1 | 52.03 ms | 52.03 ms | 5.66 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 1440 | 43.79 ms | 183.89 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 28786 | 28.36 ms | 61.07 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_status | 1 | 27.94 ms | 27.94 ms | 132.00 us | 450 | 450 | 0 | 1 | |
root | Quit | 3544 | 24.60 ms | 240.28 us | 0 ps | 0 | 0 | 0 | 0 | |
root | alter_user | 1 | 16.93 ms | 16.93 ms | 217.00 us | 0 | 0 | 0 | 0 | |
root | show_binlogs | 198 | 16.20 ms | 1.97 ms | 0 ps | 0 | 0 | 0 | 0 |
|