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 | 4.56 ms | 4.56 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 3074 | 596.39 ms | 2.09 ms | 242.13 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 3074 | 285.81 ms | 1.33 ms | 98.16 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 3081 | 20.00 ms | 95.22 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 142407 | 56.16 s | 794.64 ms | 19.62 s | 334523 | 2907784 | 0 | 31231 | |
root | drop_db | 31 | 5.85 s | 1.04 s | 25.94 ms | 0 | 0 | 80 | 0 | |
root | alter_table | 14 | 5.59 s | 568.71 ms | 2.53 ms | 0 | 0 | 25 | 0 | |
root | show_fields | 5069 | 4.98 s | 6.21 ms | 1.96 s | 201593 | 1026916 | 0 | 0 | |
root | show_variables | 5050 | 4.43 s | 7.86 ms | 442.75 ms | 5592 | 2897860 | 0 | 5050 | |
root | show_keys | 4899 | 4.02 s | 112.83 ms | 1.82 s | 4803 | 78217 | 0 | 0 | |
root | create_table | 14 | 3.14 s | 447.50 ms | 9.48 ms | 0 | 0 | 0 | 0 | |
root | show_create_table | 2552 | 1.81 s | 998.46 ms | 999.35 ms | 0 | 0 | 0 | 0 | |
root | show_tables | 2293 | 1.61 s | 4.69 ms | 839.60 ms | 51849 | 147782 | 0 | 0 | |
root | create_db | 14 | 819.29 ms | 168.07 ms | 3.68 ms | 0 | 0 | 14 | 0 | |
root | set_option | 11851 | 717.84 ms | 7.84 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 3669 | 196.08 ms | 429.51 us | 15.82 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 2008 | 159.45 ms | 1.02 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | insert | 5 | 120.18 ms | 34.89 ms | 1.78 ms | 0 | 0 | 25 | 0 | |
root | show_warnings | 2325 | 73.34 ms | 1.20 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 382 | 72.88 ms | 3.04 ms | 44.53 ms | 4 | 92 | 0 | 0 | |
root | show_binlogs | 125 | 66.92 ms | 56.16 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 4922 | 40.78 ms | 3.83 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 39575 | 31.72 ms | 1.76 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_status | 1 | 25.31 ms | 25.31 ms | 460.00 us | 450 | 450 | 0 | 1 | |
root | freturn | 8868 | 14.26 ms | 2.30 ms | 0 ps | 0 | 0 | 0 | 0 |
|