SELECT * FROM `x$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 | 4016267000 | 4016267000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 537 | 109020291000 | 764239000 | 45071000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 537 | 51640303000 | 402507000 | 17768000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 536 | 3699747000 | 36530000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 10785 | 4727860301000 | 542591558000 | 1274952000000 | 37229 | 254937 | 0 | 4995 | |
root | show_keys | 508 | 954326815000 | 131981716000 | 179012000000 | 707 | 7199 | 0 | 0 | |
root | show_fields | 749 | 765016427000 | 5650452000 | 300689000000 | 32740 | 166439 | 0 | 0 | |
root | show_variables | 650 | 575000877000 | 24675628000 | 57535000000 | 650 | 373100 | 0 | 650 | |
root | show_tables | 332 | 168526177000 | 2798580000 | 86983000000 | 6314 | 36296 | 0 | 0 | |
root | set_option | 1659 | 130954566000 | 10329956000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_table | 314 | 63109800000 | 2393828000 | 0 | 0 | 0 | 0 | 0 | |
root | show_grants | 498 | 39330615000 | 298288000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 528 | 28679869000 | 284067000 | 2369000000 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 126 | 9861167000 | 233867000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 309 | 8719276000 | 59656000 | 0 | 0 | 0 | 0 | 0 | |
root | Quit | 568 | 4533955000 | 196102000 | 0 | 0 | 0 | 0 | 0 | |
root | freturn | 787 | 3479520000 | 1284963000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 27 | 2717869000 | 124542000 | 1455000000 | 0 | 0 | 0 | 0 | |
root | Prepare | 1 | 2149496000 | 2149496000 | 0 | 0 | 0 | 0 | 0 | |
root | show_master_status | 1 | 1149259000 | 1149259000 | 0 | 0 | 0 | 0 | 0 | |
root | error | 12 | 747135000 | 265651000 | 0 | 0 | 0 | 0 | 0 | |
root | show_storage_engines | 2 | 548822000 | 397597000 | 404000000 | 18 | 18 | 0 | 2 | |
root | jump_if_not | 665 | 425051000 | 16235000 | 0 | 0 | 0 | 0 | 0 | |
root | Execute | 1 | 87221000 | 87221000 | 26000000 | 0 | 2 | 0 | 1 | |
root | show_slave_status | 1 | 80440000 | 80440000 | 0 | 0 | 0 | 0 | 0 |
|