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 | 82.46 us | 82.46 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 135 | 39.63 ms | 828.79 us | 15.28 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 135 | 17.70 ms | 291.34 us | 6.05 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 134 | 965.24 us | 24.38 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 2342 | 1.21 s | 170.67 ms | 298.15 ms | 11425 | 79025 | 0 | 1233 | |
root | show_keys | 116 | 571.07 ms | 85.91 ms | 43.97 ms | 175 | 1627 | 0 | 0 | |
root | show_variables | 152 | 150.29 ms | 5.84 ms | 15.64 ms | 152 | 87122 | 0 | 152 | |
root | show_fields | 144 | 140.52 ms | 3.98 ms | 53.08 ms | 5896 | 29983 | 0 | 0 | |
root | show_tables | 96 | 66.46 ms | 5.08 ms | 39.97 ms | 276 | 1257 | 0 | 0 | |
root | set_option | 423 | 45.93 ms | 5.67 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 76 | 14.71 ms | 1.16 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_grants | 138 | 11.27 ms | 285.64 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 153 | 11.00 ms | 832.10 us | 1.07 ms | 0 | 0 | 0 | 0 | |
root | show_table_status | 4 | 3.99 ms | 1.66 ms | 2.88 ms | 0 | 8 | 0 | 0 | |
root | show_storage_engines | 1 | 2.68 ms | 2.68 ms | 373.00 us | 9 | 9 | 0 | 1 | |
root | show_warnings | 64 | 1.79 ms | 70.12 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 226 | 1.02 ms | 809.21 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 146 | 1.02 ms | 177.60 us | 0 ps | 0 | 0 | 0 | 0 | |
root | stmt | 1 | 815.69 us | 815.69 us | 0 ps | 0 | 1 | 0 | 0 | |
root | freturn | 44 | 787.45 us | 433.32 us | 0 ps | 0 | 0 | 0 | 0 | |
root | set | 2 | 772.08 us | 770.71 us | 0 ps | 0 | 1 | 0 | 0 | |
root | show_binlogs | 5 | 686.56 us | 448.88 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 5 | 612.92 us | 218.44 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 5 | 450.47 us | 145.45 us | 0 ps | 0 | 0 | 0 | 0 | |
root | error | 3 | 98.60 us | 33.55 us | 0 ps | 0 | 0 | 0 | 0 |
|