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 | 3192 | 647.97 ms | 1.19 ms | 263.93 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 3192 | 307.18 ms | 560.41 us | 107.14 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 3191 | 21.37 ms | 49.88 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 96573 | 43.89 s | 1.00 s | 13.55 s | 315521 | 2588235 | 0 | 27390 | |
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 | 4598 | 4.64 s | 8.18 ms | 1.82 s | 181036 | 922422 | 0 | 0 | |
root | show_keys | 4100 | 4.10 s | 106.95 ms | 1.56 s | 4708 | 71704 | 0 | 0 | |
root | show_variables | 4430 | 4.05 s | 4.66 ms | 395.79 ms | 4428 | 2542379 | 0 | 4430 | |
root | create_table | 19 | 3.66 s | 367.68 ms | 34.44 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 1808 | 1.19 s | 7.78 ms | 609.99 ms | 37020 | 113887 | 0 | 0 | |
root | set_option | 11522 | 746.20 ms | 9.09 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 13 | 593.40 ms | 72.33 ms | 4.64 ms | 0 | 0 | 11 | 0 | |
root | insert | 18 | 507.86 ms | 59.18 ms | 5.33 ms | 0 | 0 | 72 | 0 | |
root | show_create_table | 2258 | 445.87 ms | 3.83 ms | 2.06 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 2613 | 213.30 ms | 862.54 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 3425 | 201.09 ms | 1.16 ms | 20.14 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 2010 | 66.98 ms | 1.23 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 54673 | 54.21 ms | 1.22 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 231 | 41.31 ms | 1.76 ms | 22.87 ms | 71 | 349 | 0 | 0 | |
root | Quit | 4568 | 32.03 ms | 698.21 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 9057 | 22.93 ms | 1.82 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 412 | 18.20 ms | 932.76 us | 0 ps | 0 | 106 | 0 | 0 | |
root | stmt | 56 | 11.92 ms | 2.16 ms | 0 ps | 0 | 56 | 0 | 0 |
|