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 | 96.87 us | 96.87 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 1571 | 240.87 ms | 834.45 us | 97.72 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 1571 | 106.64 ms | 325.00 us | 38.04 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 1570 | 9.05 ms | 57.02 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 153951 | 56.58 s | 183.87 ms | 23.16 s | 273329 | 2272543 | 0 | 20049 | |
root | alter_table | 32 | 12.45 s | 586.15 ms | 5.00 ms | 0 | 0 | 3 | 0 | |
root | show_fields | 2840 | 2.87 s | 6.97 ms | 1.17 s | 102555 | 522673 | 0 | 0 | |
root | create_table | 13 | 2.65 s | 391.92 ms | 6.80 ms | 0 | 0 | 0 | 0 | |
root | show_keys | 3286 | 2.63 s | 72.12 ms | 1.28 s | 2637 | 33697 | 0 | 0 | |
root | show_variables | 2595 | 2.37 s | 5.20 ms | 218.36 ms | 2594 | 1489089 | 0 | 2595 | |
root | show_tables | 822 | 481.25 ms | 4.95 ms | 262.44 ms | 16465 | 44696 | 0 | 0 | |
root | show_create_table | 1450 | 435.89 ms | 29.99 ms | 1.33 ms | 0 | 0 | 0 | 0 | |
root | set_option | 5482 | 281.63 ms | 5.90 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_db | 3 | 129.70 ms | 56.23 ms | 3.00 ms | 0 | 0 | 3 | 0 | |
root | Init DB | 1907 | 86.72 ms | 1.93 ms | 3.16 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 988 | 77.60 ms | 897.59 us | 0 ps | 0 | 0 | 0 | 0 | |
root | insert | 2 | 61.54 ms | 36.89 ms | 709.00 us | 0 | 0 | 3 | 0 | |
root | show_binlogs | 49 | 43.13 ms | 27.83 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 31 | 42.63 ms | 20.81 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 1240 | 37.49 ms | 317.98 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 14708 | 29.80 ms | 3.44 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 27525 | 25.29 ms | 972.16 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 49 | 23.09 ms | 3.74 ms | 15.08 ms | 33 | 270 | 0 | 0 | |
root | show_create_proc | 78 | 16.41 ms | 3.02 ms | 4.02 ms | 0 | 0 | 0 | 0 | |
root | Quit | 2096 | 14.00 ms | 218.31 us | 0 ps | 0 | 0 | 0 | 0 |
|