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.15 ms | 1.15 ms | 0 ps | 1 | 1 | 0 | 0 | |
pma | show_tables | 877 | 217.80 ms | 5.94 ms | 77.37 ms | 0 | 0 | 0 | 0 | |
pma | Init DB | 877 | 91.68 ms | 342.18 us | 31.77 ms | 0 | 0 | 0 | 0 | |
pma | Quit | 875 | 7.09 ms | 123.67 us | 0 ps | 0 | 0 | 0 | 0 | |
root | select | 18986 | 16.34 s | 1.03 s | 2.86 s | 119527 | 740520 | 0 | 7196 | |
root | show_keys | 972 | 1.87 s | 191.79 ms | 452.68 ms | 751 | 9692 | 0 | 0 | |
root | show_variables | 891 | 948.08 ms | 76.00 ms | 84.50 ms | 1442 | 510636 | 0 | 891 | |
root | show_fields | 916 | 863.49 ms | 5.97 ms | 368.36 ms | 27552 | 140918 | 0 | 0 | |
root | show_table_status | 21 | 471.03 ms | 453.10 ms | 13.55 ms | 55 | 370 | 0 | 0 | |
root | set_option | 2792 | 228.47 ms | 9.22 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_tables | 368 | 216.24 ms | 2.98 ms | 126.61 ms | 3092 | 10860 | 0 | 0 | |
root | create_db | 2 | 123.94 ms | 86.91 ms | 4.98 ms | 0 | 0 | 2 | 0 | |
root | show_create_table | 428 | 98.86 ms | 9.98 ms | 158.00 us | 0 | 0 | 0 | 0 | |
root | Init DB | 910 | 66.58 ms | 1.46 ms | 6.60 ms | 0 | 0 | 0 | 0 | |
root | show_grants | 733 | 66.29 ms | 3.77 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | jump_if_not | 83654 | 57.55 ms | 1.98 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | drop_db | 1 | 57.25 ms | 57.25 ms | 1.17 ms | 0 | 0 | 0 | 0 | |
root | freturn | 17888 | 31.70 ms | 9.32 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_binlogs | 136 | 13.31 ms | 3.26 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_master_status | 68 | 11.08 ms | 7.24 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_warnings | 343 | 10.63 ms | 151.20 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 36 | 10.07 ms | 5.68 ms | 2.24 ms | 324 | 324 | 0 | 36 | |
root | Quit | 983 | 7.88 ms | 236.33 us | 0 ps | 0 | 0 | 0 | 0 | |
root | show_slave_status | 68 | 6.44 ms | 1.35 ms | 0 ps | 0 | 0 | 0 | 0 | |
root | show_status | 1 | 3.60 ms | 3.60 ms | 128.00 us | 450 | 450 | 0 | 1 |
|