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 IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... | sys | * | 3 | 0 | 1 | 650699791000 | 628399297000 | 216899930000 | 511000000 | 26 | 9 | 18120 | 6040 | 0 | 0 | 17 | 2 | 820 | 2 | bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4... | 2025-07-02 03:31:36.958820 | 2025-07-02 03:31:37.495550 | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | sys | 2322 | 0 | 0 | 603610901000 | 1770587000 | 259953000 | 326365000000 | 2318 | 1 | 13920 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... | 2025-07-02 03:31:10.246987 | 2025-07-02 03:32:23.541407 | ||
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | mysql | * | 402 | 0 | 4 | 236825929000 | 3449704000 | 589119000 | 85438000000 | 3737 | 9 | 23718 | 59 | 0 | 0 | 903 | 0 | 6540 | 0 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | 2025-07-02 03:31:03.288109 | 2025-07-02 03:33:30.398458 | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | 146 | 0 | 0 | 228627236000 | 7283629000 | 1565939000 | 83279000000 | 7446 | 51 | 37960 | 260 | 0 | 0 | 146 | 0 | 7446 | 0 | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | 2025-07-02 03:31:03.134424 | 2025-07-02 03:33:30.363880 | ||
SHOW SESSION VARIABLES LIKE ? | mysql | * | 170 | 0 | 0 | 219378406000 | 14937264000 | 1290461000 | 19771000000 | 170 | 1 | 97580 | 574 | 0 | 0 | 170 | 0 | 0 | 0 | 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... | 2025-07-02 03:31:03.127124 | 2025-07-02 03:33:30.392159 | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | NULL | * | 191 | 0 | 0 | 206005374000 | 3575972000 | 1078562000 | 71045000000 | 1989 | 10 | 12600 | 66 | 0 | 0 | 444 | 0 | 3720 | 0 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | 2025-07-02 03:31:02.272548 | 2025-07-02 03:33:28.897062 | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | 353 | 0 | 0 | 184043001000 | 3762314000 | 521368000 | 102131000000 | 0 | 0 | 1059 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... | 2025-07-02 03:31:03.131489 | 2025-07-02 03:3 |