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 | 992.95 us | 992.95 us | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 916 | 217.79 ms | 1.62 ms | 87.37 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 916 | 107.08 ms | 566.08 us | 36.25 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 915 | 6.30 ms | 38.10 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 32913 | 14.26 s | 673.92 ms | 4.30 s | 98654 | 896214 | 0 | 10398 | |
root | show_keys | 1261 | 2.06 s | 86.92 ms | 479.50 ms | 1228 | 20772 | 0 | 0 | |
root | drop_db | 4 | 1.90 s | 1.35 s | 4.37 ms | 0 | 0 | 29 | 0 | |
root | show_fields | 1312 | 1.29 s | 5.78 ms | 519.31 ms | 48341 | 246871 | 0 | 0 | |
root | show_variables | 1220 | 1.08 s | 4.53 ms | 111.42 ms | 1214 | 699671 | 0 | 1220 | |
root | show_tables | 677 | 500.33 ms | 3.75 ms | 264.80 ms | 11474 | 34381 | 0 | 0 | |
root | show_table_status | 127 | 418.38 ms | 356.49 ms | 19.90 ms | 313 | 1378 | 0 | 0 | |
root | set_option | 3166 | 266.70 ms | 6.21 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_table | 1 | 173.37 ms | 173.37 ms | 3.03 ms | 0 | 0 | 0 | 0 | |
root | show_create_table | 653 | 146.95 ms | 11.21 ms | 1.64 ms | 0 | 0 | 0 | 0 | |
root | insert | 1 | 103.39 ms | 103.39 ms | 1.07 ms | 0 | 0 | 1 | 0 | |
root | show_grants | 975 | 79.35 ms | 579.91 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 1091 | 70.43 ms | 447.91 us | 8.84 ms | 0 | 0 | 0 | 0 | |
root | create_db | 1 | 44.62 ms | 44.62 ms | 72.00 us | 0 | 0 | 1 | 0 | |
root | show_warnings | 551 | 18.85 ms | 1.37 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_proc | 28 | 10.11 ms | 2.78 ms | 1.37 ms | 0 | 0 | 0 | 0 | |
root | Quit | 1296 | 8.14 ms | 192.06 us | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 626 | 5.00 ms | 3.87 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | error | 64 | 4.36 ms | 1.92 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_create_func | 22 | 3.81 ms | 623.37 us | 866.00 us | 0 | 0 | 0 | 0 | |
root | Prepare | 17 | 3.71 ms | 1.27 ms | 0 ps | 0 | 0 | 0 | 0 |
|