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 | 1713 | 356.16 ms | 1.91 ms | 143.90 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1713 | 168.39 ms | 410.96 us | 57.79 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1713 | 11.23 ms | 127.47 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 129654 | 47.07 s | 837.66 ms | 17.88 s | 234148 | 1958184 | 0 | 17138 | |
root | show_keys | 2815 | 3.00 s | 87.76 ms | 1.01 s | 2832 | 28113 | 0 | 0 | |
root | show_fields | 2986 | 2.83 s | 7.18 ms | 1.14 s | 112778 | 574345 | 0 | 0 | |
root | show_variables | 2669 | 2.29 s | 9.15 ms | 233.07 ms | 2669 | 1531901 | 0 | 2669 | |
root | set_option | 5550 | 374.48 ms | 5.53 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 574 | 353.12 ms | 4.39 ms | 180.16 ms | 13072 | 49604 | 0 | 0 | |
root | show_create_table | 1404 | 287.83 ms | 3.04 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 1806 | 90.15 ms | 6.19 ms | 2.85 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 880 | 68.89 ms | 307.61 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 1295 | 40.06 ms | 1.27 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 32890 | 29.06 ms | 485.97 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 20825 | 28.95 ms | 1.17 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 205 | 22.59 ms | 7.03 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 21 | 17.58 ms | 2.35 ms | 0 ps | 0 | 21 | 0 | 0 | |
root | Quit | 1997 | 13.56 ms | 221.00 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 13 | 4.88 ms | 2.07 ms | 3.80 ms | 0 | 69 | 0 | 0 | |
root | show_storage_engines | 11 | 3.29 ms | 1.50 ms | 1.21 ms | 99 | 99 | 0 | 11 | |
root | Prepare | 10 | 3.27 ms | 1.44 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 10 | 3.16 ms | 1.18 ms | 1.48 ms | 9 | 11 | 0 | 1 | |
root | show_master_status | 8 | 2.91 ms | 959.34 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 8 | 2.57 ms | 918.12 us | 0 ps | 0 | 0 | 0 | 0 |
|