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 | 2.54 ms | 2.54 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 3784 | 689.42 ms | 1.73 ms | 280.21 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 3725 | 321.41 ms | 1.42 ms | 112.20 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 3753 | 23.69 ms | 52.99 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 196260 | 1.42 m | 381.64 ms | 26.64 s | 499533 | 3653999 | 0 | 50626 | |
root | show_fields | 7791 | 7.73 s | 6.07 ms | 3.08 s | 309605 | 1577697 | 0 | 0 | |
root | show_keys | 7646 | 7.39 s | 1.17 s | 2.88 s | 7614 | 127033 | 0 | 0 | |
root | show_variables | 7195 | 6.20 s | 8.06 ms | 625.93 ms | 7737 | 4128544 | 0 | 7195 | |
root | drop_db | 30 | 5.42 s | 1.15 s | 22.71 ms | 0 | 0 | 73 | 0 | |
root | show_tables | 3756 | 2.65 s | 7.19 ms | 1.41 s | 82799 | 238658 | 0 | 0 | |
root | create_table | 6 | 1.12 s | 324.33 ms | 4.16 ms | 0 | 0 | 0 | 0 | |
root | set_option | 15633 | 889.97 ms | 5.20 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 3950 | 795.52 ms | 4.84 ms | 662.00 us | 0 | 0 | 0 | 0 | |
root | Init DB | 5343 | 247.38 ms | 421.58 us | 7.37 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 3000 | 237.78 ms | 1.34 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 7 | 203.72 ms | 70.49 ms | 2.62 ms | 0 | 0 | 4 | 0 | |
root | show_table_status | 182 | 149.74 ms | 73.74 ms | 49.85 ms | 36 | 314 | 0 | 0 | |
root | show_warnings | 3416 | 104.68 ms | 432.58 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 6722 | 44.07 ms | 1.04 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 135 | 27.29 ms | 6.05 ms | 1.68 ms | 0 | 0 | 0 | 0 | |
root | jump_if_not | 21568 | 18.05 ms | 1.75 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_status | 1 | 17.45 ms | 17.45 ms | 154.00 us | 450 | 450 | 0 | 1 | |
root | show_create_func | 111 | 15.98 ms | 2.85 ms | 3.45 ms | 0 | 0 | 0 | 0 | |
root | stmt | 18 | 10.30 ms | 2.23 ms | 0 ps | 0 | 18 | 0 | 0 | |
root | show_binlogs | 144 | 9.71 ms | 699.04 us | 0 ps | 0 | 0 | 0 | 0 |
|