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 | 3911 | 778.58 ms | 1.29 ms | 316.94 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 3911 | 368.03 ms | 560.41 us | 129.04 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 3909 | 25.93 ms | 49.88 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 125917 | 56.18 s | 1.00 s | 17.65 s | 386344 | 3100426 | 0 | 34403 | |
root | alter_table | 23 | 9.60 s | 580.77 ms | 31.77 ms | 0 | 0 | 56 | 0 | |
root | drop_db | 35 | 6.04 s | 949.05 ms | 34.31 ms | 0 | 0 | 83 | 0 | |
root | show_fields | 5921 | 5.95 s | 8.69 ms | 2.35 s | 231168 | 1178042 | 0 | 0 | |
root | show_variables | 5610 | 5.12 s | 15.57 ms | 498.18 ms | 5608 | 3219594 | 0 | 5610 | |
root | show_keys | 5400 | 4.98 s | 106.95 ms | 2.06 s | 6044 | 92875 | 0 | 0 | |
root | create_table | 21 | 3.96 s | 367.68 ms | 34.66 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 2363 | 1.58 s | 7.78 ms | 808.51 ms | 50133 | 151057 | 0 | 0 | |
root | set_option | 14378 | 901.81 ms | 9.09 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 16 | 712.71 ms | 72.33 ms | 4.86 ms | 0 | 0 | 14 | 0 | |
root | show_create_table | 2913 | 586.28 ms | 3.98 ms | 2.27 ms | 0 | 0 | 0 | 0 | |
root | insert | 19 | 531.98 ms | 59.18 ms | 5.53 ms | 0 | 0 | 86 | 0 | |
root | show_grants | 3306 | 269.84 ms | 1.12 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 4334 | 245.71 ms | 1.16 ms | 23.09 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 2568 | 84.47 ms | 1.23 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 78515 | 74.44 ms | 1.22 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 286 | 50.36 ms | 1.76 ms | 28.31 ms | 71 | 357 | 0 | 0 | |
root | Quit | 5782 | 40.49 ms | 698.21 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 13073 | 31.30 ms | 1.82 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 440 | 19.03 ms | 932.76 us | 0 ps | 0 | 120 | 0 | 0 | |
root | stmt | 70 | 16.01 ms | 2.16 ms | 0 ps | 0 | 70 | 0 | 0 |
|