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 | 105.43 us | 105.43 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 3149 | 597.27 ms | 1.99 ms | 243.79 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 3149 | 277.06 ms | 480.32 us | 96.30 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 3147 | 19.66 ms | 228.17 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 152688 | 53.43 s | 479.79 ms | 21.27 s | 284111 | 1992754 | 0 | 23717 | |
root | drop_db | 32 | 6.11 s | 1.16 s | 11.18 ms | 0 | 0 | 78 | 0 | |
root | create_table | 26 | 4.33 s | 275.96 ms | 13.94 ms | 0 | 0 | 0 | 0 | |
root | show_variables | 3316 | 3.04 s | 8.74 ms | 286.30 ms | 3316 | 1902985 | 0 | 3316 | |
root | show_keys | 3466 | 2.90 s | 101.52 ms | 1.23 s | 2265 | 28330 | 0 | 0 | |
root | show_fields | 2814 | 2.61 s | 5.28 ms | 1.08 s | 101467 | 516746 | 0 | 0 | |
root | show_tables | 956 | 1.83 s | 1.04 s | 1.59 s | 13111 | 35282 | 0 | 0 | |
root | create_db | 16 | 750.39 ms | 61.28 ms | 10.06 ms | 0 | 0 | 16 | 0 | |
root | insert | 24 | 664.43 ms | 63.12 ms | 8.32 ms | 0 | 0 | 116 | 0 | |
root | set_option | 10022 | 593.80 ms | 5.47 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 1436 | 316.82 ms | 2.60 ms | 196.00 us | 0 | 0 | 0 | 0 | |
root | Init DB | 2298 | 133.36 ms | 751.41 us | 16.49 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 1111 | 88.88 ms | 795.16 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 159 | 46.04 ms | 8.08 ms | 25.38 ms | 34 | 301 | 0 | 0 | |
root | show_warnings | 1390 | 45.35 ms | 391.62 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 39897 | 38.53 ms | 1.44 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 3584 | 24.05 ms | 242.23 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 18066 | 22.82 ms | 2.27 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 86 | 13.30 ms | 4.67 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 26 | 12.31 ms | 3.72 ms | 0 ps | 0 | 26 | 0 | 0 | |
root | show_master_status | 61 | 5.85 ms | 2.44 ms | 0 ps | 0 | 0 | 0 | 0 |
|