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 | 2.98 ms | 2.98 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 771 | 182.05 ms | 660.81 us | 74.65 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 771 | 88.95 ms | 325.79 us | 30.22 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 770 | 5.87 ms | 29.98 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 13125 | 7.32 s | 493.49 ms | 1.68 s | 71319 | 504030 | 0 | 5950 | |
root | show_keys | 587 | 2.66 s | 92.14 ms | 234.95 ms | 759 | 9491 | 0 | 0 | |
root | show_fields | 687 | 628.75 ms | 4.30 ms | 283.36 ms | 17593 | 90791 | 0 | 0 | |
root | show_variables | 679 | 606.58 ms | 8.23 ms | 60.82 ms | 679 | 389410 | 0 | 679 | |
root | show_tables | 483 | 322.08 ms | 6.64 ms | 186.20 ms | 4669 | 22761 | 0 | 0 | |
root | set_option | 2336 | 219.87 ms | 7.63 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | create_table | 1 | 216.70 ms | 216.70 ms | 1.88 ms | 0 | 0 | 0 | 0 | |
root | show_table_status | 10 | 151.56 ms | 144.37 ms | 5.43 ms | 33 | 246 | 0 | 0 | |
root | show_create_table | 354 | 70.90 ms | 2.22 ms | 2.46 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 702 | 59.76 ms | 340.56 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Init DB | 775 | 52.26 ms | 454.20 us | 5.29 ms | 0 | 0 | 0 | 0 | |
root | create_db | 1 | 50.52 ms | 50.52 ms | 2.22 ms | 0 | 0 | 1 | 0 | |
root | show_binlogs | 115 | 12.21 ms | 4.17 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 261 | 8.15 ms | 141.55 us | 0 ps | 0 | 0 | 0 | 0 | |
root | Quit | 836 | 6.07 ms | 206.36 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 24 | 4.75 ms | 2.53 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 5235 | 4.24 ms | 310.67 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 24 | 3.97 ms | 1.04 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | freturn | 2192 | 3.57 ms | 1.77 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 7 | 1.27 ms | 342.43 us | 777.00 us | 63 | 63 | 0 | 7 | |
root | error | 16 | 891.60 us | 268.43 us | 0 ps | 0 | 0 | 0 | 0 |
|