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 | 1.04 ms | 1.04 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 3339 | 715.56 ms | 892.71 us | 294.52 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 3339 | 346.65 ms | 457.01 us | 120.06 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 3338 | 23.42 ms | 44.18 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 115622 | 1.02 m | 1.02 s | 14.95 s | 500012 | 4685951 | 0 | 34275 | |
root | show_fields | 5389 | 5.06 s | 7.22 ms | 2.06 s | 198361 | 1012548 | 0 | 0 | |
root | show_keys | 4717 | 4.64 s | 127.37 ms | 1.71 s | 4937 | 79997 | 0 | 0 | |
root | show_variables | 4654 | 3.95 s | 4.77 ms | 410.68 ms | 5197 | 2669863 | 0 | 4654 | |
root | show_tables | 2807 | 2.10 s | 3.83 ms | 1.14 s | 51798 | 164215 | 0 | 0 | |
root | set_option | 12812 | 864.55 ms | 6.31 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_table | 14 | 782.76 ms | 200.18 ms | 10.29 ms | 0 | 0 | 0 | 0 | |
root | show_create_table | 2663 | 538.73 ms | 4.21 ms | 13.10 ms | 0 | 0 | 0 | 0 | |
root | create_db | 7 | 364.78 ms | 67.26 ms | 3.59 ms | 0 | 0 | 7 | 0 | |
root | insert | 10 | 287.57 ms | 57.80 ms | 5.19 ms | 0 | 0 | 9 | 0 | |
root | show_table_status | 307 | 216.35 ms | 12.89 ms | 136.44 ms | 324 | 1706 | 0 | 0 | |
root | Init DB | 3907 | 202.98 ms | 2.05 ms | 6.88 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 2202 | 190.12 ms | 12.17 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | alter_user | 5 | 154.49 ms | 46.33 ms | 3.08 ms | 0 | 0 | 0 | 0 | |
root | show_warnings | 2149 | 66.45 ms | 236.89 us | 0 ps | 0 | 0 | 0 | 0 | |
root | grant | 2 | 60.86 ms | 36.61 ms | 1.27 ms | 0 | 0 | 0 | 0 | |
root | create_user | 1 | 52.03 ms | 52.03 ms | 5.66 ms | 0 | 0 | 0 | 0 | |
root | jump_if_not | 41956 | 39.67 ms | 939.49 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 5165 | 36.64 ms | 259.46 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_status | 1 | 27.94 ms | 27.94 ms | 132.00 us | 450 | 450 | 0 | 1 | |
root | show_binlogs | 235 | 19.78 ms | 1.97 ms | 0 ps | 0 | 0 | 0 | 0 |
|