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 | 66.62 us | 66.62 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1720 | 421.12 ms | 825.85 us | 170.25 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1720 | 212.40 ms | 350.02 us | 71.51 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1725 | 12.28 ms | 35.70 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 34879 | 14.65 s | 486.56 ms | 4.36 s | 151644 | 1003610 | 0 | 14754 | |
root | show_keys | 1343 | 2.16 s | 138.63 ms | 468.02 ms | 2159 | 25917 | 0 | 0 | |
root | show_fields | 1775 | 1.63 s | 2.96 ms | 644.19 ms | 75154 | 382212 | 0 | 0 | |
root | show_variables | 1785 | 1.46 s | 7.64 ms | 161.36 ms | 1781 | 1023876 | 0 | 1785 | |
root | set_option | 5554 | 449.73 ms | 6.04 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 842 | 409.20 ms | 10.44 ms | 226.95 ms | 5184 | 17375 | 0 | 0 | |
root | create_db | 4 | 279.51 ms | 79.68 ms | 1.96 ms | 0 | 0 | 4 | 0 | |
root | create_table | 1 | 234.62 ms | 234.62 ms | 8.45 ms | 0 | 0 | 0 | 0 | |
root | show_create_table | 877 | 147.94 ms | 1.82 ms | 132.00 us | 0 | 0 | 0 | 0 | |
root | show_grants | 1669 | 132.44 ms | 926.69 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 1735 | 124.86 ms | 402.84 us | 19.06 ms | 0 | 0 | 0 | 0 | |
root | show_table_status | 293 | 51.87 ms | 2.24 ms | 31.22 ms | 2 | 56 | 0 | 0 | |
root | show_warnings | 791 | 22.98 ms | 153.35 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 1987 | 14.67 ms | 254.30 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Execute | 29 | 6.70 ms | 542.25 us | 2.25 ms | 9 | 49 | 0 | 20 | |
root | Prepare | 29 | 5.87 ms | 605.47 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 75 | 4.43 ms | 138.66 us | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 3 | 3.41 ms | 3.22 ms | 0 ps | 0 | 3 | 0 | 0 | |
root | jump_if_not | 3685 | 3.37 ms | 282.64 us | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 6 | 3.33 ms | 3.19 ms | 0 ps | 0 | 3 | 0 | 0 | |
root | show_slave_status | 38 | 3.29 ms | 189.47 us | 0 ps | 0 | 0 | 0 | 0 |
|