SELECT * FROM `x$statement_analysis`
|
query | db | full_scan | exec_count | err_count | warn_count | total_latency | max_latency | avg_latency | lock_latency | rows_sent | rows_sent_avg | rows_examined | rows_examined_avg | rows_affected | rows_affected_avg | tmp_tables | tmp_disk_tables | rows_sorted | sort_merge_passes | digest | first_seen | last_seen | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | sys | 3829 | 0 | 0 | 1060107258000 | 4330372000 | 276862000 | 585773000000 | 3821 | 1 | 22950 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... | 2025-07-11 06:00:52.170885 | 2025-07-11 06:06:40.835785 | ||
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | mysql | * | 1029 | 0 | 0 | 635955907000 | 4827144000 | 618032000 | 222906000000 | 9236 |