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.18 ms | 1.18 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 2223 | 537.68 ms | 32.67 ms | 231.58 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 2223 | 210.43 ms | 534.80 us | 72.69 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 2222 | 13.05 ms | 38.17 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 291217 | 1.75 m | 1.06 s | 40.83 s | 456980 | 3193636 | 0 | 30991 | |
root | show_keys | 5755 | 5.29 s | 118.81 ms | 2.06 s | 4298 | 54878 | 0 | 0 | |
root | show_fields | 4750 | 4.31 s | 4.81 ms | 1.80 s | 168172 | 857125 | 0 | 0 | |
root | show_variables | 4328 | 3.66 s | 10.16 ms | 372.26 ms | 4324 | 2483831 | 0 | 4328 | |
root | show_tables | 1103 | 800.52 ms | 4.97 ms | 404.39 ms | 28967 | 73455 | 0 | 0 | |
root | set_option | 8134 | 510.02 ms | 11.74 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_table | 2370 | 493.62 ms | 3.89 ms | 501.00 us | 0 | 0 | 0 | 0 | |
root | Init DB | 2833 | 122.67 ms | 363.69 us | 2.16 ms | 0 | 0 | 0 | 0 | |
root | create_db | 2 | 102.38 ms | 60.59 ms | 1.68 ms | 0 | 0 | 2 | 0 | |
root | show_grants | 1284 | 95.14 ms | 966.97 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_table_status | 21 | 88.28 ms | 77.18 ms | 8.91 ms | 33 | 244 | 0 | 0 | |
root | show_warnings | 2114 | 65.10 ms | 236.23 us | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 69221 | 62.91 ms | 3.36 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 27675 | 33.71 ms | 1.12 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 3194 | 20.71 ms | 241.42 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 104 | 14.19 ms | 1.50 ms | 2.53 ms | 0 | 0 | 0 | 0 | |
root | stmt | 33 | 11.94 ms | 2.11 ms | 0 ps | 0 | 33 | 0 | 0 | |
root | show_create_func | 88 | 11.32 ms | 2.16 ms | 866.00 us | 0 | 0 | 0 | 0 | |
root | show_binlogs | 53 | 10.05 ms | 2.21 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 29 | 4.00 ms | 834.85 us | 2.31 ms | 261 | 261 | 0 | 29 | |
root | Prepare | 4 | 3.95 ms | 3.41 ms | 0 ps | 0 | 0 | 0 | 0 |
|