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 | 1191431000 | 1191431000 | 0 | 1 | 1 | 0 | 0 | |
pma | show_tables | 3750 | 733678082000 | 2604589000 | 300645000000 | 0 | 0 | 0 | 0 | |
pma | Init DB | 3750 | 340300054000 | 3544089000 | 118558000000 | 0 | 0 | 0 | 0 | |
pma | Quit | 3749 | 31622775000 | 6983353000 | 0 | 0 | 0 | 0 | 0 | |
root | select | 169492 | 95139087843000 | 1002952477000 | 22401510000000 | 507335 | 4734656 | 0 | 46436 | |
root | show_keys | 8702 | 7942695600000 | 442734558000 | 3668770000000 | 9223 | 152344 | 0 | 0 | |
root | show_fields | 8005 | 7473749543000 | 19594881000 | 3064287000000 | 278508 | 1424000 | 0 | 0 | |
root | show_variables | 6744 | 5777342498000 | 17985160000 | 589888000000 | 7866 | 3869544 | 0 | 6744 | |
root | show_tables | 4093 | 3008945983000 | 6791837000 | 1593972000000 | 82597 | 243140 | 0 | 0 | |
root | set_option | 15866 | 951641089000 | 6695753000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_table | 3922 | 808530806000 | 16005103000 | 953000000 | 0 | 0 | 0 | 0 | |
root | create_table | 4 | 553182654000 | 200143637000 | 15021000000 | 0 | 0 | 0 | 0 | |
root | jump_if_not | 663088 | 426171574000 | 1246044000 | 0 | 0 | 0 | 0 | 0 | |
root | create_db | 9 | 422536708000 | 67073503000 | 5483000000 | 0 | 0 | 9 | 0 | |
root | Init DB | 5544 | 265691091000 | 347986000 | 7437000000 | 0 | 0 | 0 | 0 | |
root | show_grants | 3193 | 247214801000 | 1283441000 | 0 | 0 | 0 | 0 | 0 | |
root | show_table_status | 116 | 221893172000 | 139737787000 | 55749000000 | 109 | 951 | 0 | 0 | |
root | freturn | 154979 | 144844903000 | 852367000 | 0 | 0 | 0 | 0 | 0 | |
root | show_warnings | 3207 | 99762373000 | 228793000 | 0 | 0 | 0 | 0 | 0 | |
root | insert | 3 | 93704203000 | 39017249000 | 548000000 | 0 | 0 | 3 | 0 | |
root | Quit | 6888 | 44813896000 | 229245000 | 0 | 0 | 0 | 0 | 0 | |
root | show_binlogs | 70 | 11920975000 | 4679129000 | 0 | 0 | 0 | 0 | 0 | |
root | show_create_proc | 27 | 11764313000 | 3633462000 | 4371000000 | 0 | 0 | 0 | 0 | |
root | Prepare | 7 | 10327570000 | 2764399000 | 0 | 0 | 0 | 0 | 0 | |
root | show_master_status | 91 | 8585527000 | 4651577000 | 0 | 0 | 0 | 0 | 0 |
|