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 | 797 | 181.06 ms | 1.91 ms | 72.44 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 797 | 87.32 ms | 410.96 us | 29.74 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 796 | 5.90 ms | 127.47 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 28295 | 13.31 s | 837.66 ms | 3.90 s | 73416 | 641377 | 0 | 6579 | |
root | show_keys | 875 | 1.36 s | 81.80 ms | 310.41 ms | 1035 | 10913 | 0 | 0 | |
root | show_fields | 1169 | 1.09 s | 7.18 ms | 459.58 ms | 40901 | 208980 | 0 | 0 | |
root | show_variables | 967 | 842.26 ms | 9.15 ms | 89.58 ms | 967 | 555037 | 0 | 967 | |
root | set_option | 2487 | 202.47 ms | 5.53 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 332 | 187.54 ms | 4.39 ms | 97.15 ms | 6720 | 32380 | 0 | 0 | |
root | show_create_table | 485 | 93.52 ms | 1.01 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 749 | 45.11 ms | 6.19 ms | 2.43 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 559 | 44.78 ms | 307.61 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 183 | 21.12 ms | 7.03 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 457 | 14.22 ms | 341.59 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 5787 | 10.00 ms | 538.54 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 6762 | 6.57 ms | 435.22 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 873 | 5.70 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 | stmt | 5 | 3.29 ms | 1.97 ms | 0 ps | 0 | 5 | 0 | 0 | |
root | show_storage_engines | 5 | 2.74 ms | 1.50 ms | 957.00 us | 45 | 45 | 0 | 5 | |
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 | show_slave_status | 3 | 1.52 ms | 918.12 us | 0 ps | 0 | 0 | 0 | 0 |
|