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 | 1181003000 | 1181003000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 941 | 139738286000 | 305873000 | 57948000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 941 | 54123807000 | 186369000 | 19973000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 940 | 6682847000 | 55820000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 13797 | 6912709754000 | 380360629000 | 2201821000000 | 73837 | 451890 | 0 | 6698 | |
root | alter_table | 16 | 6393874635000 | 445603512000 | 2407000000 | 0 | 0 | 16 | 0 | |
root | drop_db | 29 | 5254578093000 | 1084056889000 | 18298000000 | 0 | 0 | 72 | 0 | |
root | create_table | 8 | 1837624136000 | 591202080000 | 3357000000 | 0 | 0 | 0 | 0 | |
root | show_keys | 562 | 1704314643000 | 85585347000 | 210817000000 | 617 | 8552 | 0 | 0 | |
root | show_variables | 671 | 619102943000 | 5597829000 | 58218000000 | 2327 | 384524 | 0 | 671 | |
root | show_fields | 582 | 528757629000 | 3374631000 | 233696000000 | 14262 | 73670 | 0 | 0 | |
root | show_table_status | 153 | 458279217000 | 230320763000 | 23089000000 | 267 | 1330 | 0 | 0 | |
root | insert | 8 | 301222931000 | 57978584000 | 1538000000 | 0 | 0 | 16 | 0 | |
root | create_db | 7 | 281189489000 | 57169102000 | 795000000 | 0 | 0 | 6 | 0 | |
root | show_tables | 474 | 251274756000 | 3858339000 | 150231000000 | 4515 | 15230 | 0 | 0 | |
root | show_create_table | 269 | 209545404000 | 144124546000 | 531000000 | 0 | 0 | 0 | 0 | |
root | set_option | 2875 | 134587554000 | 7398771000 | 0 | 0 | 0 | 0 | 0 | |
root | Init DB | 794 | 46097347000 | 232280000 | 5899000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 525 | 44213438000 | 661523000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_proc | 78 | 19135482000 | 6374616000 | 5114000000 | 0 | 0 | 0 | 0 | |
root | show_status | 3 | 14942781000 | 13670394000 | 357000000 | 1350 | 1350 | 0 | 3 | |
root | show_warnings | 239 | 9789347000 | 1355672000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_func | 66 | 8127855000 | 536392000 | 1685000000 | 0 | 0 | 0 | 0 | |
root | Quit | 1105 | 7301529000 | 194455000 | 0 | 0 | 0 | 0 | 0 | |
root | Execute | 20 | 4918675000 | 2777999000 | 3049000000 | 9 | 31 | 0 | 11 |
|