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 | 5193 | 0 | 0 | 1334799619000 | 1440418000 | 257038000 | 723867000000 | 5185 | 1 | 31134 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... | 2025-07-08 10:31:03.775834 | 2025-07-08 10:37:37.926490 | ||
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... | sys | * | 12 | 0 | 1 | 980998738000 | 442793209000 | 81749894000 | 3166000000 | 104 | 9 | 73056 | 6088 | 0 | 0 | 68 | 8 | 3808 | 8 | bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4... | 2025-07-08 10:31:29.319064 | 2025-07-08 10:37:17.979441 | |
INSERT INTO `employees` VALUES (...) | harmash | 10 | 0 | 0 | 510144335000 | 228239811000 | 51014433000 | 2813000000 | 0 | 0 | 0 | 0 | 10 | 1 | 0 | 0 | 0 | 0 | aac57a1156478487fd4870bcb58e08f502c0aeb3cb0212cbee... | 2025-07-08 10:32:22.563030 | 2025-07-08 10:32:23.109266 | ||
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | mysql | * | 564 | 0 | 12 | 378480448000 | 3767281000 | 671064000 | 131529000000 | 5999 | 11 | 36607 | 65 | 0 | 0 | 1238 | 0 | 10136 | 0 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | 2025-07-08 10:31:02.210305 | 2025-07-08 10:39:21.626111 | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | NULL | * | 314 | 0 | 0 | 325974190000 | 7283113000 | 1038134000 | 109822000000 | 3439 | 11 | 22295 | 71 | 0 | 0 | 729 | 0 | 6452 | 0 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | 2025-07-08 10:31:01.871589 | 2025-07-08 10:39:08.134360 | |
SHOW SESSION VARIABLES LIKE ? | mysql |