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 | 3.81 ms | 3.81 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 2493 | 522.10 ms | 1.19 ms | 212.30 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 2493 | 248.91 ms | 540.58 us | 86.37 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 2490 | 16.96 ms | 49.88 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 77495 | 33.93 s | 530.66 ms | 10.95 s | 260546 | 2117345 | 0 | 20437 | |
root | alter_table | 23 | 9.60 s | 580.77 ms | 31.77 ms | 0 | 0 | 56 | 0 | |
root | show_fields | 3313 | 3.33 s | 5.78 ms | 1.30 s | 129813 | 661451 | 0 | 0 | |
root | show_keys | 2898 | 3.21 s | 106.95 ms | 1.10 s | 3375 | 50879 | 0 | 0 | |
root | show_variables | 3247 | 3.01 s | 4.66 ms | 291.68 ms | 3245 | 1863442 | 0 | 3247 | |
root | create_table | 16 | 2.97 s | 246.69 ms | 32.73 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 1280 | 811.76 ms | 7.78 ms | 415.79 ms | 24759 | 76765 | 0 | 0 | |
root | set_option | 8772 | 595.62 ms | 9.09 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 9 | 454.35 ms | 63.59 ms | 4.50 ms | 0 | 0 | 9 | 0 | |
root | insert | 15 | 413.22 ms | 59.18 ms | 4.22 ms | 0 | 0 | 65 | 0 | |
root | show_create_table | 1626 | 320.29 ms | 3.34 ms | 2.02 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 1942 | 159.19 ms | 862.54 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 2502 | 151.73 ms | 729.41 us | 16.18 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 1459 | 50.29 ms | 1.23 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 45173 | 47.01 ms | 1.22 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 172 | 33.23 ms | 1.76 ms | 18.30 ms | 71 | 343 | 0 | 0 | |
root | Quit | 3416 | 24.05 ms | 698.21 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 7470 | 20.10 ms | 1.82 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 388 | 17.44 ms | 932.76 us | 0 ps | 0 | 94 | 0 | 0 | |
root | show_binlogs | 129 | 9.46 ms | 693.03 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 49 | 7.16 ms | 478.68 us | 3.28 ms | 441 | 441 | 0 | 49 |
|