SELECT * FROM `x$statements_with_sorting`
|
query | db | exec_count | total_latency | sort_merge_passes | avg_sort_merges | sorts_using_scans | sort_using_range | rows_sorted | avg_rows_sorted | first_seen | last_seen | digest | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SELECT `a` . `actor_id` AS `actor_id` , `a` . `fir... | sakila | 10 | 1963522795000 | 0 | 0 | 7 | 0 | 1400 | 140 | 2024-06-24 15:18:02.561130 | 2024-06-24 15:26:46.574440 | 91c1850ed235cf0a034cf8492d2dec30e38a40c16f4dc5a7c6... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | NULL | 1315 | 939872538000 | 0 | 0 | 770 | 0 | 25644 | 20 | 2024-06-24 15:15:55.234627 | 2024-06-24 15:27:00.503565 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | 408 | 758857191000 | 0 | 0 | 204 | 0 | 780 | 2 | 2024-06-24 15:15:55.545852 | 2024-06-24 15:27:00.069527 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | performance_schema | 738 | 647879295000 | 0 | 0 | 580 | 0 | 30981 | 42 | 2024-06-24 15:15:55.169317 | 2024-06-24 15:27:09.244668 | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | performance_schema | 1474 | 638056826000 | 0 | 0 | 580 | 0 | 19774 | 13 | 2024-06-24 15:15:55.222060 | 2024-06-24 15:27:09.365200 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | mysql | 1343 | 616763562000 | 0 | 0 | 544 | 0 | 18464 | 14 | 2024-06-24 15:15:55.142388 | 2024-06-24 15:27:00.379676 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | 316 | 539718928000 | 0 | 0 | 216 | 0 | 418 | 1 | 2024-06-24 15:15:55.433661 | 2024-06-24 15:26:59.997939 | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | 521 | 438250097000 | 0 | 0 | 371 | 0 | 16972 | 33 | 2024-06-24 15:15:55.395593 | 2024-06-24 15:27:00.008489 | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | performance_schema | 757 | 437842074000 | 0 | 0 | 291 | 0 | 291 | 0 | 2024-06-24 15:15:55.180423 | 2024-06-24 15:27:09.377151 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | NULL | 485 | 418250830000 | 0 | 0 | 354 | 0 | 6440 | 13 | 2024-06-24 15:15:55.300037 | 2024-06-24 15:27:06.904851 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | sakila | 73 | 346790221000 | 0 | 0 | 29 | 0 | 117 | 2 | 2024-06-24 15:16:05.358733 | 2024-06-24 15:26:54.996612 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | sakila | 40 | 341886979000 | 0 | 0 | 30 | 0 | 59 | 1 | 2024-06-24 15:16:05.427989 | 2024-06-24 15:26:54.969584 | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | information_schema | 774 | 270385982000 | 0 | 0 | 176 | 0 | 5872 | 8 | 2024-06-24 15:15:55.687053 | 2024-06-24 15:26:59.250656 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | klo | 295 | 258442583000 | 0 | 0 | 158 | 0 | 502 | 2 | 2024-06-24 15:18:28.107161 | 2024-06-24 15:27:07.950156 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | klo | 543 | 246375912000 | 0 | 0 | 214 | 0 | 7686 | 14 | 2024-06-24 15:18:30.623328 | 2024-06-24 15:27:07.937892 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | performance_schema | 448 | 223465216000 | 0 | 0 | 290 | 0 | 847 | 2 | 2024-06-24 15:15:55.170920 | 2024-06-24 15:27:09.235853 | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | information_schema | 280 | 204230449000 | 0 | 0 | 163 | 0 | 2560 | 9 | 2024-06-24 15:15:55.602442 | 2024-06-24 15:26:59.221258 | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | А.С.Ю. | 128 | 201123123000 | 0 | 0 | 84 | 0 | 253 | 2 | 2024-06-24 15:16:23.483305 | 2024-06-24 15:25:01.723221 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | klo | 237 | 180882249000 | 0 | 0 | 157 | 0 | 613 | 3 | 2024-06-24 15:21:09.546620 | 2024-06-24 15:27:08.506757 | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | А.С.Ю. | 52 | 177678412000 | 0 | 0 | 49 | 0 | 69 | 1 | 2024-06-24 15:16:48.427455 | 2024-06-24 15:25:01.720869 | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | |
SELECT `rtn` . `name` AS `SPECIFIC_NAME` , `cat` .... | NULL | 200 | 176503143000 | 0 | 0 | 176 | 0 | 246 | 1 | 2024-06-24 15:16:23.771358 | 2024-06-24 15:24:47.442065 | 7631a5a7c833f09d7cda4f7029a221c376e319d404c83e678f... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | dbcnp | 158 | 148579280000 | 0 | 0 | 95 | 0 | 176 | 1 | 2024-06-24 15:20:16.803107 | 2024-06-24 15:27:06.941392 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | dbcnp | 321 | 142072194000 | 0 | 0 | 124 | 0 | 4464 | 14 | 2024-06-24 15:20:23.098689 | 2024-06-24 15:27:06.929099 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | Estudiantes | 230 | 140842667000 | 0 | 0 | 47 | 0 | 67 | 0 | 2024-06-24 15:17:53.706526 | 2024-06-24 15:26:40.167758 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | Estudiantes | 291 | 88968664000 | 0 | 0 | 62 | 0 | 2220 | 8 | 2024-06-24 15:17:53.757359 | 2024-06-24 15:26:40.155527 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... |
|
Warning in ./src/Table/Table.php#291
Backtrace
Warning in ./src/Table/Table.php#291
Backtrace