EXPLAIN Verbose issue - custom_scan_tlist can directly refer CTE and Subquery

1 patchset tracked - current t72083_6

v6t72083_6posted Oct 09, 2023successappliesrecent 0dpg 20

based4c15309e about 4 hours ago on master

applyapplied about 2 hours ago

rebaselast tried about 2 hours ago on d4c15309e

pushabout 2 hours ago -> 517cb9280 branch diff vs base

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1040 / 1040	2m 58s / 5m 33s	`docker run ... :t72083`	about 2 hours ago
run 37434339489 executed 1040 - ccache 78 hit / 6544 miss - head 517cb9280 - digest sha256:f0783f9d3ffafe... - run 37434339489
success	1	20	1039 / 1039	2m 57s / 5m 34s	`docker run ... @sha256:eca3267...`	1 day ago
run 37281755123 executed 1039 - ccache 78 hit / 6544 miss - head 69c8aef8a - digest sha256:eca32671776735... - run 37281755123
success	1	20	1039 / 1039	2m 52s / 5m 14s	`docker run ... @sha256:4bf748d...`	2 days ago
run 37187848562 executed 1039 - ccache 78 hit / 6544 miss - head 96d1b1928 - digest sha256:4bf748db30586e... - run 37187848562
success	1	20	1039 / 1039	2m 55s / 5m 20s	`docker run ... @sha256:30747a2...`	3 days ago
run 37108546856 executed 1039 - ccache 78 hit / 6544 miss - head a27e9bf84 - digest sha256:30747a25c47b0e... - run 37108546856
success	1	20	1039 / 1039	2m 53s / 5m 18s	`docker run ... @sha256:1213ae5...`	4 days ago
run 36982019017 executed 1039 - ccache 78 hit / 6544 miss - head 53c3b9eb1 - digest sha256:1213ae577471fd... - run 36982019017
success	1	20	1039 / 1039	2m 48s / 5m 17s	`docker run ... @sha256:f99ff17...`	5 days ago
run 36834008815 executed 1039 - ccache 78 hit / 6544 miss - head 50e445208 - digest sha256:f99ff17772a664... - run 36834008815
success	1	20	1039 / 1039	2m 55s / 5m 13s	`docker run ... @sha256:efb817d...`	6 days ago
run 36685599662 executed 1039 - ccache 78 hit / 6544 miss - head 1bedece62 - digest sha256:efb817d91b47cf... - run 36685599662
success	1	20	1039 / 1039	2m 49s / 5m 17s	`docker run ... @sha256:0f78de7...`	Sep 29, 07:52
run 36538210216 executed 1039 - ccache 78 hit / 6544 miss - head 4ae8ce029 - digest sha256:0f78de7775073f... - run 36538210216
success	1	20	1039 / 1039	3m 02s / 5m 41s	`docker run ... @sha256:71e6203...`	Sep 28, 07:48
run 36392643510 executed 1039 - ccache 78 hit / 6544 miss - head e08dc8d2b - digest sha256:71e62032264c8c... - run 36392643510
success	1	20	1039 / 1039	2m 12s / 4m 35s	`docker run ... @sha256:50d2792...`	Sep 27, 05:17
run 36296333213 executed 1039 - ccache 78 hit / 6544 miss - head e1cf72b36 - digest sha256:50d2792b489142... - run 36296333213
success	1	20	1039 / 1039	2m 57s / 5m 31s	`docker run ... @sha256:7aaf330...`	Sep 26, 05:17
run 36219813264 executed 1039 - ccache 78 hit / 6544 miss - head accc6171d - digest sha256:7aaf33015391fb... - run 36219813264
success	1	20	1038 / 1038	1m 55s / 4m 23s	`docker run ... @sha256:18fd5f2...`	Sep 25, 05:14
run 36097122871 executed 1038 - ccache 78 hit / 6544 miss - head a8a5069f2 - digest sha256:18fd5f2a3769b8... - run 36097122871
success	1	20	1036 / 1036	2m 51s / 5m 24s	`docker run ... @sha256:bebd246...`	Sep 24, 05:12
run 35958149838 executed 1036 - ccache 98 hit / 6524 miss - head c7c5be72c - digest sha256:bebd2461c61d08... - run 35958149838
success	1	20	1036 / 1036	2m 55s / 5m 30s	`docker run ... @sha256:9ad513f...`	Sep 23, 05:10
run 35820544761 executed 1036 - ccache 98 hit / 6524 miss - head eb9d43122 - digest sha256:9ad513f1429c62... - run 35820544761
success	1	20	1036 / 1036	2m 44s / 4m 31s	`docker run ... @sha256:58c9ace...`	Sep 22, 05:07
run 35688872861 executed 1036 - ccache 98 hit / 6524 miss - head 9ba5dac0f - digest sha256:58c9ace083112c... - run 35688872861
success	1	20	1036 / 1036	2m 45s / 4m 54s	`docker run ... @sha256:c36cc3f...`	Sep 21, 05:06
run 35562712569 executed 1036 - ccache 98 hit / 6524 miss - head d40521ad3 - digest sha256:c36cc3ff71b05e... - run 35562712569
success	1	20	1036 / 1036	2m 55s / 5m 19s	`docker run ... @sha256:e8c4681...`	Sep 20, 05:05
run 35490308339 executed 1036 - ccache 98 hit / 6524 miss - head 5278015c3 - digest sha256:e8c468143f83fc... - run 35490308339
success	1	20	1036 / 1036	2m 53s / 5m 18s	`docker run ... @sha256:4ba09c2...`	Sep 19, 05:04
run 35422494344 executed 1036 - ccache 98 hit / 6524 miss - head 89e7ab792 - digest sha256:4ba09c261764a5... - run 35422494344
success	1	20	1036 / 1036	2m 55s / 5m 35s	`docker run ... @sha256:8285650...`	Sep 18, 05:02
run 35308568166 executed 1036 - ccache 98 hit / 6524 miss - head da387f76f - digest sha256:828565084e3241... - run 35308568166
success	1	20	1036 / 1036	2m 54s / 5m 28s	`docker run ... @sha256:f61a77d...`	Sep 17, 05:00
run 35183400865 executed 1036 - ccache 98 hit / 6524 miss - head 427951cc9 - digest sha256:f61a77dfcc5b59... - run 35183400865
success	1	20	1036 / 1036	2m 51s / 5m 16s	`docker run ... @sha256:6350167...`	Sep 16, 04:59
run 35057017122 executed 1036 - ccache 98 hit / 6524 miss - head 7ab6caa8f - digest sha256:63501678a15cb5... - run 35057017122
success	1	20	1036 / 1036	2m 09s / 4m 44s	`docker run ... @sha256:5e55b1d...`	Sep 15, 04:56
run 34930166786 executed 1036 - ccache 98 hit / 6523 miss - head 3f1a70a7f - digest sha256:5e55b1ddce9619... - run 34930166786
success	1	20	1023 / 1023	2m 54s / 5m 22s	`docker run ... @sha256:f10fc53...`	Sep 14, 04:56
run 34807237298 executed 1023 - ccache 98 hit / 6523 miss - head 66f4b5b29 - digest sha256:f10fc5317dd510... - run 34807237298
success	1	20	1023 / 1023	2m 57s / 5m 28s	`docker run ... @sha256:974b88b...`	Sep 13, 04:44
run 34737827316 executed 1023 - ccache 98 hit / 6523 miss - head 258ac8836 - digest sha256:974b88b7b41ee3... - run 34737827316
success	1	20	1023 / 1023	2m 54s / 5m 06s	`docker run ... @sha256:111a346...`	Sep 12, 04:28
run 34672413398 executed 1023 - ccache 98 hit / 6523 miss - head 0aad2088f - digest sha256:111a346bcf0737... - run 34672413398
success	1	20	1022 / 1022	2m 57s / 5m 20s	`docker run ... @sha256:41a4e98...`	Sep 11, 04:23
run 34561206827 executed 1022 - ccache 98 hit / 6523 miss - head c48c93a62 - digest sha256:41a4e98990a9d9... - run 34561206827
success	1	20	1021 / 1021	2m 59s / 5m 31s	`docker run ... @sha256:255b16a...`	Sep 10, 04:19
run 34435960939 executed 1021 - ccache 98 hit / 6523 miss - head 9819d4758 - digest sha256:255b16a2c00474... - run 34435960939
success	1	20	1020 / 1020	2m 44s / 5m 24s	`docker run ... @sha256:a6d4349...`	Sep 09, 04:16
run 34309614069 executed 1020 - ccache 98 hit / 6523 miss - head f208e15e8 - digest sha256:a6d43495fa1312... - run 34309614069
success	1	20	1020 / 1020	1m 48s / 4m 16s	`docker run ... @sha256:270f8c0...`	Sep 08, 04:10
run 34185451969 executed 1020 - ccache 98 hit / 6523 miss - head 3e1075b91 - digest sha256:270f8c015e34af... - run 34185451969
success	1	20	1024 / 1024	2m 54s / 5m 11s	`docker run ... @sha256:0310aa1...`	Sep 07, 04:08
run 34081379399 executed 1024 - ccache 98 hit / 6527 miss - head 716ee1e5c - digest sha256:0310aa1ffd09ce... - run 34081379399
success	1	20	1024 / 1024	2m 54s / 5m 10s	`docker run ... @sha256:61d1920...`	Sep 05, 05:58
run 33948087243 executed 1024 - ccache 98 hit / 6527 miss - head 3165b92f0 - digest sha256:61d19209f94816... - run 33948087243
success	1	20	1024 / 1024	2m 48s / 5m 09s	`docker run ... @sha256:26b5dac...`	Sep 04, 05:59
run 33841693148 executed 1024 - ccache 98 hit / 6527 miss - head 99eebbb99 - digest sha256:26b5dacdc85e48... - run 33841693148
success	1	20	1023 / 1023	2m 17s / 4m 07s	`docker run ... @sha256:127b2fc...`	Sep 03, 05:54
run 33720119661 executed 1023 - ccache 98 hit / 6526 miss - head 54eeaf069 - digest sha256:127b2fca9e4817... - run 33720119661
success	1	20	1022 / 1022	2m 50s / 5m 10s	`docker run ... @sha256:471724f...`	Sep 02, 05:53
run 33595802039 executed 1022 - ccache 98 hit / 6526 miss - head ada226bfc - digest sha256:471724f5424b45... - run 33595802039
success	1	20	1022 / 1022	2m 14s / 4m 16s	`docker run ... @sha256:de35e72...`	Sep 01, 05:50
run 33474550696 executed 1022 - ccache 98 hit / 6526 miss - head d250954ad - digest sha256:de35e7252a4729... - run 33474550696
success	1	20	1022 / 1022	2m 55s / 5m 43s	`docker run ... @sha256:44be8e0...`	Aug 31, 05:31
run 33360154341 executed 1022 - ccache 98 hit / 6526 miss - head f043ee5fd - digest sha256:44be8e04bc2a9a... - run 33360154341
success	1	20	1021 / 1021	2m 58s / 5m 42s	`docker run ... @sha256:8754cf6...`	Aug 30, 05:21
run 33294057396 executed 1021 - ccache 98 hit / 6525 miss - head f39b596e9 - digest sha256:8754cf60f16e11... - run 33294057396
success	1	20	1021 / 1021	2m 49s / 5m 25s	`docker run ... @sha256:6e1ba54...`	Aug 29, 05:17
run 33235412809 executed 1021 - ccache 98 hit / 6525 miss - head 37b01b6b5 - digest sha256:6e1ba543475b5a... - run 33235412809
success	1	20	1021 / 1021	2m 48s / 5m 30s	`docker run ... @sha256:cd546cb...`	Aug 28, 05:08
run 33143338125 executed 1021 - ccache 98 hit / 6525 miss - head 8204d7f7e - digest sha256:cd546cb76eaa98... - run 33143338125
success	1	20	1021 / 1021	2m 10s / 4m 36s	`docker run ... @sha256:70c77d5...`	Aug 27, 05:05
run 33040883863 executed 1021 - ccache 98 hit / 6525 miss - head 3b980bf8a - digest sha256:70c77d5b28f57c... - run 33040883863
success	1	20	1024 / 1024	2m 54s / 5m 17s	`docker run ... @sha256:ebd366f...`	Aug 26, 04:43
run 32930578526 executed 1024 - ccache 98 hit / 6525 miss - head c902f7747 - digest sha256:ebd366f5aa6bcf... - run 32930578526
success	1	20	1024 / 1024	2m 54s / 5m 18s	`docker run ... @sha256:6fb988e...`	Aug 25, 04:38
run 32808911057 executed 1024 - ccache 98 hit / 6525 miss - head 364de0b3a - digest sha256:6fb988e15313e7... - run 32808911057
success	1	20	1023 / 1023	2m 56s / 5m 36s	`docker run ... @sha256:50b44fe...`	Aug 24, 04:36
run 32689829176 executed 1023 - ccache 98 hit / 6525 miss - head 260cfdec0 - digest sha256:50b44fe438bb74... - run 32689829176
success	1	20	1023 / 1023	2m 42s / 4m 48s	`docker run ... @sha256:8b526b6...`	Aug 23, 04:32
run 32617720961 executed 1023 - ccache 98 hit / 6525 miss - head 0068c1934 - digest sha256:8b526b632a156f... - run 32617720961
success	1	20	1023 / 1023	2m 10s / 4m 31s	`docker run ... @sha256:86ef709...`	Aug 22, 04:31
run 32551491800 executed 1023 - ccache 98 hit / 6525 miss - head e5690fba2 - digest sha256:86ef709ea86f37... - run 32551491800
success	1	20	1023 / 1023	2m 54s / 5m 41s	`docker run ... @sha256:f9a3b00...`	Aug 21, 04:31
run 32446592809 executed 1023 - ccache 98 hit / 6525 miss - head 76afb4629 - digest sha256:f9a3b00b00ecd4... - run 32446592809
success	1	20	1023 / 1023	2m 12s / 4m 48s	`docker run ... @sha256:a33a7e9...`	Aug 20, 04:29
run 32331417059 executed 1023 - ccache 98 hit / 6525 miss - head 7629b44f9 - digest sha256:a33a7e9f2b046a... - run 32331417059
success	1	20	1023 / 1023	2m 10s / 4m 44s	`docker run ... @sha256:cc88208...`	Aug 19, 04:28
run 32215201059 executed 1023 - ccache 98 hit / 6525 miss - head 7b8592ca7 - digest sha256:cc88208c6c08b9... - run 32215201059
success	1	20	1020 / 1020	2m 56s / 5m 39s	`docker run ... @sha256:a26129c...`	Aug 18, 04:28
run 32098442092 executed 1020 - ccache 98 hit / 6524 miss - head 0cd33117e - digest sha256:a26129c4eee87a... - run 32098442092
success	1	20	1019 / 1019	2m 09s / 4m 42s	`docker run ... @sha256:7827fc5...`	Aug 17, 04:24
run 31993633762 executed 1019 - ccache 98 hit / 6524 miss - head 7c03144d5 - digest sha256:7827fc5b22736e... - run 31993633762
success	1	20	1019 / 1019	2m 40s / 4m 46s	`docker run ... @sha256:7bb71a7...`	Aug 16, 04:18
run 31925832397 executed 1019 - ccache 98 hit / 6524 miss - head d2bd0521d - digest sha256:7bb71a7ea471aa... - run 31925832397
success	1	20	1019 / 1019	1m 49s / 3m 54s	`docker run ... @sha256:de1e656...`	Aug 15, 04:15
run 31863510375 executed 1019 - ccache 98 hit / 6524 miss - head 37b0fe071 - digest sha256:de1e6560fb3d0f... - run 31863510375
success	1	20	1019 / 1019	2m 54s / 5m 14s	`docker run ... @sha256:3d60b6a...`	Aug 14, 04:16
run 31768686833 executed 1019 - ccache 165 hit / 6457 miss - head 6f2fb4ea1 - digest sha256:3d60b6a41fe507... - run 31768686833
success	1	20	1019 / 1019	2m 55s / 5m 35s	`docker run ... @sha256:711fe85...`	Aug 13, 04:15
run 31665748688 executed 1019 - ccache 165 hit / 6457 miss - head 5c0ab1040 - digest sha256:711fe85da825c5... - run 31665748688
success	1	20	1019 / 1019	1m 53s / 4m 07s	`docker run ... @sha256:c9d49ad...`	Aug 12, 04:11
run 31561912691 executed 1019 - ccache 165 hit / 6454 miss - head 70d0568a4 - digest sha256:c9d49ad1c04080... - run 31561912691
success	1	20	1019 / 1019	2m 56s / 5m 36s	`docker run ... @sha256:5a7b16f...`	Aug 11, 04:08
run 31456929098 executed 1019 - ccache 165 hit / 6453 miss - head 619195438 - digest sha256:5a7b16fe343ba1... - run 31456929098
success	1	20	1019 / 1019	2m 48s / 5m 17s	`docker run ... @sha256:41b0b88...`	Aug 10, 04:07
run 31353993572 executed 1019 - ccache 166 hit / 6452 miss - head 3b087b678 - digest sha256:41b0b888dd64fa... - run 31353993572
success	1	20	1019 / 1019	2m 44s / 4m 30s	`docker run ... @sha256:dc8e886...`	Aug 08, 02:49
run 31235153260 executed 1019 - ccache 166 hit / 6452 miss - head be8ed4431 - digest sha256:dc8e886a827c40... - run 31235153260
success	1	20	1018 / 1018	2m 54s / 5m 10s	`docker run ... @sha256:e6c3e4e...`	Aug 07, 02:47
run 31141350486 executed 1018 - ccache 166 hit / 6452 miss - head 47bd69278 - digest sha256:e6c3e4e77bf79a... - run 31141350486
success	1	20	1018 / 1018	2m 54s / 5m 21s	`docker run ... @sha256:09f2035...`	Aug 05, 20:52
run 31045049733 executed 1018 - ccache 166 hit / 6452 miss - head a44756d66 - digest sha256:09f2035ecb435e... - run 31045049733
success	1	20	1018 / 1018	2m 54s / 5m 25s	`docker run ... @sha256:8fcea18...`	Aug 04, 20:51
run 30948668936 executed 1018 - ccache 166 hit / 6452 miss - head afc15e7ca - digest sha256:8fcea183ae59ee... - run 30948668936
success	1	20	1018 / 1018	2m 55s / 5m 17s	`docker run ... @sha256:5a42edd...`	Aug 03, 20:47
run 30850825728 executed 1018 - ccache 166 hit / 6452 miss - head c7a9eee45 - digest sha256:5a42eddb28c1eb... - run 30850825728
success	1	20	1017 / 1017	2m 56s / 5m 15s	`docker run ... @sha256:82cb65a...`	Aug 02, 20:49
run 30765875607 executed 1017 - ccache 166 hit / 6452 miss - head 18fafe1aa - digest sha256:82cb65ac41913b... - run 30765875607
success	1	20	1017 / 1017	3m 00s / 5m 38s	`docker run ... @sha256:787c015...`	Aug 01, 20:46
run 30717184820 executed 1017 - ccache 166 hit / 6452 miss - head 0d492ce0a - digest sha256:787c015dbf7686... - run 30717184820
success	1	20	1017 / 1017	2m 49s / 5m 18s	`docker run ... @sha256:1090ce4...`	Jul 31, 20:48
run 30663167543 executed 1017 - ccache 166 hit / 6452 miss - head 40e6db80b - digest sha256:1090ce4314e429... - run 30663167543
tests failed	1	20	1015 / 1016	2m 56s / 5m 30s	`docker run ... @sha256:4f5085e...`	Jul 30, 20:44
run 30579304602 failed: recovery/051_effective_wal_level executed 1016 - ccache 166 hit / 6452 miss - head a856ec39a - digest sha256:4f5085e109c217... - run 30579304602
success	1	20	1016 / 1016	2m 42s / 4m 31s	`docker run ... @sha256:6851461...`	Jul 29, 20:37
run 30488502650 executed 1016 - ccache 166 hit / 6452 miss - head 7c317069c - digest sha256:6851461be58f69... - run 30488502650
success	1	20	1015 / 1015	2m 47s / 5m 15s	`docker run ... @sha256:c4f2874...`	Jul 28, 20:38
run 30396322347 executed 1015 - ccache 166 hit / 6452 miss - head 2abe642ad - digest sha256:c4f2874f4624b1... - run 30396322347
success	1	20	1013 / 1013	2m 57s / 5m 34s	`docker run ... @sha256:1dc2ecd...`	Jul 27, 13:11
run 30267649751 executed 1013 - ccache 166 hit / 6452 miss - head 160a78df9 - digest sha256:1dc2ecd08cdb60... - run 30267649751