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 | 817.36 us | 817.36 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1035 | 272.72 ms | 4.41 ms | 97.73 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1035 | 108.51 ms | 378.00 us | 36.80 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1035 | 7.67 ms | 126.52 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 81325 | 31.37 s | 347.78 ms | 11.67 s | 151858 | 1152478 | 0 | 10464 | |
root | show_fields | 1376 | 1.37 s | 17.70 ms | 541.69 ms | 51982 | 264722 | 0 | 0 | |
root | show_variables | 1349 | 1.22 s | 15.90 ms | 137.70 ms | 1349 | 773864 | 0 | 1349 | |
root | show_keys | 1417 | 965.83 ms | 36.06 ms | 533.45 ms | 1318 | 16673 | 0 | 0 | |
root | show_tables | 602 | 386.41 ms | 4.40 ms | 225.44 ms | 6702 | 18189 | 0 | 0 | |
root | create_table | 1 | 299.88 ms | 299.88 ms | 1.44 ms | 0 | 0 | 0 | 0 | |
root | set_option | 3451 | 267.44 ms | 5.73 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 686 | 158.00 ms | 3.17 ms | 515.00 us | 0 | 0 | 0 | 0 | |
root | insert | 2 | 95.44 ms | 52.51 ms | 7.06 ms | 0 | 0 | 2 | 0 | |
root | create_db | 2 | 90.79 ms | 51.39 ms | 261.00 us | 0 | 0 | 2 | 0 | |
root | Init DB | 1131 | 90.70 ms | 15.00 ms | 6.13 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 776 | 63.41 ms | 340.15 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 70 | 32.79 ms | 4.78 ms | 23.05 ms | 0 | 44 | 0 | 0 | |
root | freturn | 8792 | 23.59 ms | 9.92 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 618 | 19.64 ms | 160.55 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 55 | 17.35 ms | 5.79 ms | 5.05 ms | 0 | 0 | 0 | 0 | |
root | stmt | 9 | 16.95 ms | 13.78 ms | 0 ps | 0 | 9 | 0 | 0 | |
root | show_binlogs | 33 | 15.96 ms | 3.29 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_func | 48 | 15.65 ms | 9.35 ms | 4.25 ms | 0 | 0 | 0 | 0 | |
root | jump_if_not | 13422 | 15.58 ms | 1.54 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 18 | 14.28 ms | 13.70 ms | 0 ps | 0 | 9 | 0 | 0 |
|