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.45 ms | 3.45 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 964 | 211.90 ms | 1.91 ms | 85.00 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 964 | 101.98 ms | 410.96 us | 34.81 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 962 | 6.93 ms | 127.47 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 46306 | 19.56 s | 837.66 ms | 6.42 s | 102063 | 862613 | 0 | 8537 | |
root | show_keys | 1236 | 1.69 s | 81.80 ms | 438.49 ms | 1360 | 13969 | 0 | 0 | |
root | show_fields | 1498 | 1.40 s | 7.18 ms | 584.38 ms | 53462 | 272877 | 0 | 0 | |
root | show_variables | 1271 | 1.10 s | 9.15 ms | 114.98 ms | 1271 | 729512 | 0 | 1271 | |
root | set_option | 3030 | 231.04 ms | 5.53 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 361 | 203.80 ms | 4.39 ms | 105.47 ms | 7357 | 34077 | 0 | 0 | |
root | show_create_table | 652 | 129.76 ms | 2.17 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 944 | 53.29 ms | 6.19 ms | 2.52 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 612 | 48.52 ms | 307.61 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 188 | 21.45 ms | 7.03 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 607 | 18.74 ms | 341.59 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 8345 | 13.29 ms | 538.54 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 11450 | 12.27 ms | 485.97 us | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 10 | 7.95 ms | 2.35 ms | 0 ps | 0 | 10 | 0 | 0 | |
root | Quit | 1067 | 7.16 ms | 221.00 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 10 | 3.64 ms | 2.07 ms | 2.88 ms | 0 | 67 | 0 | 0 | |
root | show_storage_engines | 6 | 2.82 ms | 1.50 ms | 993.00 us | 54 | 54 | 0 | 6 | |
root | Execute | 9 | 2.31 ms | 1.18 ms | 1.00 ms | 9 | 9 | 0 | 0 | |
root | Prepare | 9 | 2.23 ms | 1.44 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 3 | 1.97 ms | 959.34 us | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 20 | 1.53 ms | 722.27 us | 0 ps | 0 | 10 | 0 | 0 |
|