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 | 1827 | 388.57 ms | 614.78 us | 159.97 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1827 | 188.18 ms | 349.06 us | 64.78 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1827 | 13.07 ms | 34.24 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 56464 | 28.05 s | 503.39 ms | 7.23 s | 205823 | 2640714 | 0 | 17889 | |
root | show_keys | 2327 | 2.90 s | 127.37 ms | 821.65 ms | 2477 | 38178 | 0 | 0 | |
root | show_fields | 2660 | 2.49 s | 7.22 ms | 996.77 ms | 100789 | 513955 | 0 | 0 | |
root | show_variables | 2380 | 2.05 s | 4.65 ms | 211.05 ms | 2377 | 1365280 | 0 | 2380 | |
root | show_tables | 1451 | 1.07 s | 3.83 ms | 589.66 ms | 25835 | 83831 | 0 | 0 | |
root | create_table | 8 | 780.56 ms | 200.18 ms | 9.54 ms | 0 | 0 | 0 | 0 | |
root | set_option | 6661 | 470.44 ms | 6.31 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 6 | 307.67 ms | 67.26 ms | 3.48 ms | 0 | 0 | 6 | 0 | |
root | show_create_table | 1249 | 233.95 ms | 2.16 ms | 1.32 ms | 0 | 0 | 0 | 0 | |
root | insert | 9 | 229.77 ms | 47.83 ms | 3.26 ms | 0 | 0 | 7 | 0 | |
root | Init DB | 2067 | 111.00 ms | 2.05 ms | 4.94 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 1222 | 98.74 ms | 500.97 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 108 | 72.15 ms | 12.89 ms | 38.59 ms | 137 | 656 | 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 | 1084 | 32.76 ms | 153.00 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 2686 | 18.16 ms | 222.29 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 | jump_if_not | 18619 | 14.25 ms | 21.48 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 154 | 13.00 ms | 1.97 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 3105 | 7.40 ms | 1.21 ms | 0 ps | 0 | 0 | 0 | 0 |
|