Aggregate leads to superfluous projection from the scan

1 patchset tracked - current t46210_2

v2t46210_2posted Jul 08, 2022successappliesrecent 0dpg 20

base9e17d25e7 about 12 hours ago on master

applyapplied about 6 hours ago

rebaselast tried about 6 hours ago on 9e17d25e7

pushabout 6 hours ago -> f522d25cb branch diff vs base

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1036 / 1036	2m 52s / 5m 14s	`docker run ... :t46210`	about 6 hours ago
run 35507298883 executed 1036 - ccache 98 hit / 6524 miss - head f522d25cb - digest sha256:550f6d47f1f33a... - run 35507298883
success	1	20	1036 / 1036	2m 08s / 4m 41s	`docker run ... @sha256:fa0e7fe...`	1 day ago
run 35439538389 executed 1036 - ccache 98 hit / 6524 miss - head 4bfaff11c - digest sha256:fa0e7fea4eb296... - run 35439538389
success	1	20	1036 / 1036	2m 53s / 5m 22s	`docker run ... @sha256:5f8dd1e...`	2 days ago
run 35338482757 executed 1036 - ccache 98 hit / 6524 miss - head 1c16d9515 - digest sha256:5f8dd1e13b7dd1... - run 35338482757
success	1	20	1036 / 1036	2m 55s / 5m 23s	`docker run ... @sha256:aa94b7a...`	3 days ago
run 35214405435 executed 1036 - ccache 98 hit / 6524 miss - head a3b4694a3 - digest sha256:aa94b7af4ab37d... - run 35214405435
success	1	20	1036 / 1036	2m 54s / 5m 09s	`docker run ... @sha256:f53bdac...`	4 days ago
run 35088498427 executed 1036 - ccache 98 hit / 6524 miss - head 89169808e - digest sha256:f53bdac975d418... - run 35088498427
success	1	20	1036 / 1036	2m 53s / 5m 30s	`docker run ... @sha256:03704e2...`	5 days ago
run 34960738059 executed 1036 - ccache 98 hit / 6523 miss - head 98fcdc5de - digest sha256:03704e209ebd6d... - run 34960738059
success	1	20	1023 / 1023	2m 14s / 4m 29s	`docker run ... @sha256:2ae193b...`	6 days ago
run 34835298417 executed 1023 - ccache 98 hit / 6523 miss - head 3100e2c98 - digest sha256:2ae193be051228... - run 34835298417
success	1	20	1023 / 1023	2m 48s / 5m 08s	`docker run ... @sha256:c3d839c...`	Sep 13, 10:24
run 34751325606 executed 1023 - ccache 98 hit / 6523 miss - head ae9e55650 - digest sha256:c3d839c464b280... - run 34751325606
success	1	20	1023 / 1023	2m 13s / 4m 02s	`docker run ... @sha256:9b04b58...`	Sep 12, 10:18
run 34687669263 executed 1023 - ccache 98 hit / 6523 miss - head 4e9e17ae6 - digest sha256:9b04b58a609600... - run 34687669263
success	1	20	1022 / 1022	2m 17s / 4m 39s	`docker run ... @sha256:a69729b...`	Sep 11, 10:17
run 34587685290 executed 1022 - ccache 98 hit / 6523 miss - head 931c470fa - digest sha256:a69729bc2e28b1... - run 34587685290
success	1	20	1022 / 1022	2m 47s / 5m 03s	`docker run ... @sha256:b3c4d4f...`	Sep 10, 10:16
run 34464287016 executed 1022 - ccache 98 hit / 6523 miss - head 2538697e8 - digest sha256:b3c4d4f68c7da3... - run 34464287016
success	1	20	1020 / 1020	1m 58s / 4m 18s	`docker run ... @sha256:9f4d73e...`	Sep 09, 10:13
run 34338242905 executed 1020 - ccache 98 hit / 6523 miss - head 41b6a669f - digest sha256:9f4d73e4f97775... - run 34338242905
success	1	20	1020 / 1020	1m 53s / 4m 00s	`docker run ... @sha256:5801507...`	Sep 08, 10:09
run 34213147642 executed 1020 - ccache 98 hit / 6523 miss - head 30732097e - digest sha256:58015078bfc190... - run 34213147642
success	1	20	1024 / 1024	2m 56s / 5m 24s	`docker run ... @sha256:fa2e9eb...`	Sep 07, 10:09
run 34108969303 executed 1024 - ccache 98 hit / 6527 miss - head b3742f09f - digest sha256:fa2e9eb39606ed... - run 34108969303
success	1	20	1024 / 1024	2m 54s / 5m 41s	`docker run ... @sha256:7a5340a...`	Sep 05, 12:01
run 33964373602 executed 1024 - ccache 98 hit / 6527 miss - head 81dd65865 - digest sha256:7a5340a8fcc7cc... - run 33964373602
success	1	20	1024 / 1024	2m 53s / 5m 22s	`docker run ... @sha256:0ebc6ff...`	Sep 04, 11:59
run 33869710645 executed 1024 - ccache 98 hit / 6527 miss - head 313e71137 - digest sha256:0ebc6fff1fd670... - run 33869710645
success	1	20	1023 / 1023	2m 47s / 5m 28s	`docker run ... @sha256:92cbd85...`	Sep 03, 11:57
run 33751517769 executed 1023 - ccache 98 hit / 6526 miss - head ca18c1763 - digest sha256:92cbd856436966... - run 33751517769
success	1	20	1022 / 1022	2m 58s / 5m 46s	`docker run ... @sha256:b0cd8eb...`	Sep 02, 11:55
run 33626081547 executed 1022 - ccache 98 hit / 6526 miss - head 3369209b5 - digest sha256:b0cd8ebb392a26... - run 33626081547
success	1	20	1022 / 1022	2m 45s / 5m 10s	`docker run ... @sha256:3258560...`	Sep 01, 11:53
run 33503784502 executed 1022 - ccache 98 hit / 6526 miss - head c164f65c0 - digest sha256:3258560dd6c555... - run 33503784502
success	1	20	1022 / 1022	2m 59s / 5m 44s	`docker run ... @sha256:36f1889...`	Aug 31, 11:40
run 33387215019 executed 1022 - ccache 98 hit / 6526 miss - head 8d48933ed - digest sha256:36f1889256b297... - run 33387215019
success	1	20	1021 / 1021	2m 57s / 5m 30s	`docker run ... @sha256:19d368a...`	Aug 30, 11:38
run 33308979070 executed 1021 - ccache 98 hit / 6525 miss - head d10513539 - digest sha256:19d368a98a39b9... - run 33308979070
success	1	20	1021 / 1021	2m 46s / 5m 26s	`docker run ... @sha256:8fb36af...`	Aug 29, 11:37
run 33250124896 executed 1021 - ccache 98 hit / 6525 miss - head 0c6a80322 - digest sha256:8fb36af68d5265... - run 33250124896
success	1	20	1021 / 1021	2m 52s / 5m 11s	`docker run ... @sha256:8e73429...`	Aug 28, 11:36
run 33167103410 executed 1021 - ccache 98 hit / 6525 miss - head 053a98963 - digest sha256:8e734298cc4ade... - run 33167103410
success	1	20	1021 / 1021	2m 57s / 5m 29s	`docker run ... @sha256:bc3e8fe...`	Aug 27, 11:34
run 33067182603 executed 1021 - ccache 98 hit / 6525 miss - head 21d011e4b - digest sha256:bc3e8fe5de5ecd... - run 33067182603
success	1	20	1024 / 1024	2m 53s / 5m 09s	`docker run ... @sha256:68eb30b...`	Aug 26, 11:28
run 32962416341 executed 1024 - ccache 98 hit / 6525 miss - head 2b46c5d3e - digest sha256:68eb30bf4c17d0... - run 32962416341
success	1	20	1024 / 1024	2m 56s / 5m 38s	`docker run ... @sha256:0ca1026...`	Aug 25, 11:19
run 32840251834 executed 1024 - ccache 98 hit / 6525 miss - head 01781446f - digest sha256:0ca102663edba0... - run 32840251834
success	1	20	1023 / 1023	2m 54s / 5m 17s	`docker run ... @sha256:ce31937...`	Aug 24, 11:06
run 32719191174 executed 1023 - ccache 98 hit / 6525 miss - head 1280c9e1a - digest sha256:ce319378e21c65... - run 32719191174
success	1	20	1023 / 1023	2m 58s / 5m 40s	`docker run ... @sha256:cd7ab70...`	Aug 23, 11:04
run 32634957861 executed 1023 - ccache 98 hit / 6525 miss - head e58932011 - digest sha256:cd7ab702278273... - run 32634957861
success	1	20	1023 / 1023	3m 00s / 5m 21s	`docker run ... @sha256:ecd742e...`	Aug 22, 11:02
run 32568695242 executed 1023 - ccache 98 hit / 6525 miss - head 73aa9e0ab - digest sha256:ecd742e8fad62e... - run 32568695242
success	1	20	1023 / 1023	2m 55s / 5m 25s	`docker run ... @sha256:de777b5...`	Aug 21, 11:01
run 32474420228 executed 1023 - ccache 98 hit / 6525 miss - head ce33bf3e0 - digest sha256:de777b5b266472... - run 32474420228
success	1	20	1023 / 1023	2m 17s / 4m 22s	`docker run ... @sha256:2ca7e48...`	Aug 20, 10:58
run 32360770103 executed 1023 - ccache 98 hit / 6525 miss - head 972ac88c4 - digest sha256:2ca7e48b81a487... - run 32360770103
success	1	20	1023 / 1023	2m 56s / 5m 35s	`docker run ... @sha256:494b026...`	Aug 19, 11:07
run 32244339527 executed 1023 - ccache 98 hit / 6525 miss - head fc888f60c - digest sha256:494b026ba7523b... - run 32244339527
success	1	20	1021 / 1021	2m 57s / 5m 36s	`docker run ... @sha256:c1be884...`	Aug 18, 10:55
run 32128040598 executed 1021 - ccache 98 hit / 6524 miss - head 98913cd78 - digest sha256:c1be884c8ac05e... - run 32128040598
success	1	20	1019 / 1019	2m 14s / 4m 48s	`docker run ... @sha256:ce08984...`	Aug 17, 10:52
run 32021262242 executed 1019 - ccache 98 hit / 6524 miss - head 072d87f68 - digest sha256:ce08984962c1c8... - run 32021262242
success	1	20	1019 / 1019	2m 55s / 5m 20s	`docker run ... @sha256:de40df0...`	Aug 16, 10:51
run 31942239730 executed 1019 - ccache 98 hit / 6524 miss - head 52955d0b1 - digest sha256:de40df062fc727... - run 31942239730
success	1	20	1019 / 1019	2m 54s / 5m 16s	`docker run ... @sha256:7c9042c...`	Aug 15, 10:50
run 31879999074 executed 1019 - ccache 98 hit / 6524 miss - head de7d4f978 - digest sha256:7c9042cabeaa48... - run 31879999074
success	1	20	1019 / 1019	2m 58s / 5m 36s	`docker run ... @sha256:e2586d2...`	Aug 14, 10:49
run 31792925354 executed 1019 - ccache 165 hit / 6457 miss - head f657ee5f0 - digest sha256:e2586d2b4e6061... - run 31792925354
success	1	20	1019 / 1019	2m 54s / 5m 24s	`docker run ... @sha256:18d9339...`	Aug 13, 10:48
run 31691784160 executed 1019 - ccache 165 hit / 6457 miss - head 8bd214d3c - digest sha256:18d933919d85d2... - run 31691784160
success	1	20	1019 / 1019	2m 54s / 5m 18s	`docker run ... @sha256:be177e9...`	Aug 12, 10:46
run 31587857668 executed 1019 - ccache 165 hit / 6457 miss - head d3fead0e6 - digest sha256:be177e958c8caa... - run 31587857668
success	1	20	1019 / 1019	2m 49s / 5m 20s	`docker run ... @sha256:3a553c5...`	Aug 11, 10:45
run 31482565518 executed 1019 - ccache 165 hit / 6453 miss - head 6269fadb4 - digest sha256:3a553c5c567ff2... - run 31482565518
success	1	20	1019 / 1019	2m 50s / 5m 22s	`docker run ... @sha256:10ea3dc...`	Aug 10, 10:32
run 31378803348 executed 1019 - ccache 166 hit / 6452 miss - head c1c70f9cc - digest sha256:10ea3dcc6b792d... - run 31378803348
success	1	20	1019 / 1019	2m 39s / 4m 36s	`docker run ... @sha256:dc1adfa...`	Aug 08, 12:48
run 31257666194 executed 1019 - ccache 166 hit / 6452 miss - head 9473e91df - digest sha256:dc1adfa573c7a6... - run 31257666194
success	1	20	1019 / 1019	2m 14s / 4m 20s	`docker run ... @sha256:25c4500...`	Aug 07, 12:46
run 31178940980 executed 1019 - ccache 166 hit / 6452 miss - head 27f2216ec - digest sha256:25c4500e24736d... - run 31178940980
success	1	20	1018 / 1018	2m 47s / 5m 25s	`docker run ... @sha256:b294623...`	Aug 06, 12:48
run 31102103494 executed 1018 - ccache 166 hit / 6452 miss - head 320ab3265 - digest sha256:b2946237aeb9e6... - run 31102103494
success	1	20	1018 / 1018	2m 55s / 5m 24s	`docker run ... @sha256:392c7b3...`	Aug 05, 12:47
run 31006218446 executed 1018 - ccache 166 hit / 6452 miss - head 066305ddd - digest sha256:392c7b32fb7599... - run 31006218446
success	1	20	1018 / 1018	2m 49s / 5m 15s	`docker run ... @sha256:152141a...`	Aug 04, 12:39
run 30909205985 executed 1018 - ccache 166 hit / 6452 miss - head 45f945011 - digest sha256:152141a697b29a... - run 30909205985
success	1	20	1017 / 1017	2m 47s / 5m 22s	`docker run ... @sha256:c5ae1c1...`	Aug 03, 12:38
run 30813641806 executed 1017 - ccache 166 hit / 6452 miss - head cfdbb5e3a - digest sha256:c5ae1c1493e2a5... - run 30813641806
success	1	20	1017 / 1017	2m 13s / 4m 34s	`docker run ... @sha256:232039c...`	Aug 02, 12:34
run 30747762360 executed 1017 - ccache 166 hit / 6452 miss - head 5dc4e6e4f - digest sha256:232039c3400a66... - run 30747762360
success	1	20	1017 / 1017	2m 56s / 5m 09s	`docker run ... @sha256:bf7d859...`	Aug 01, 12:35
run 30699611062 executed 1017 - ccache 166 hit / 6452 miss - head b935fa6d6 - digest sha256:bf7d8597b87610... - run 30699611062
success	1	20	1016 / 1016	2m 46s / 5m 33s	-	Jul 31, 12:40
run 30630381704 executed 1016 - ccache 166 hit / 6452 miss - head 6a57e00d6 - run 30630381704
success	1	20	1016 / 1016	2m 56s / 5m 40s	`docker run ... @sha256:1211e7c...`	Jul 30, 12:32
run 30542182092 executed 1016 - ccache 166 hit / 6452 miss - head 5d099a83d - digest sha256:1211e7c7e0a486... - run 30542182092
success	1	20	1015 / 1015	2m 57s / 5m 23s	`docker run ... @sha256:19dd5e3...`	Jul 29, 12:31
run 30451151783 executed 1015 - ccache 166 hit / 6452 miss - head 267614e09 - digest sha256:19dd5e37929e8b... - run 30451151783
success	1	20	1014 / 1014	2m 54s / 5m 22s	`docker run ... @sha256:e128e64...`	Jul 28, 12:30
run 30358401307 executed 1014 - ccache 166 hit / 6452 miss - head f6249846f - digest sha256:e128e64fa40787... - run 30358401307
success	1	20	1013 / 1013	2m 52s / 5m 22s	`docker run ... @sha256:fcbec8c...`	Jul 27, 14:31
run 30273924767 executed 1013 - ccache 166 hit / 6452 miss - head 79b156f78 - digest sha256:fcbec8c1c9d89b... - run 30273924767