Cost overestimation of foreign JOIN

back to CI dashboard

1 patchset tracked - current t43319_1

v1t43319_1posted Nov 30, 2020tests failedappliesrecent 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 -> e0878c86ebranchdiff vs base
ResultAttPGTestsBuild / testImageWhen
tests failed120987 / 9882m 53s / 5m 23sdocker run ... :t43319about 5 hours ago
run 35508804392
failed: postgres_fdw/postgres_fdw
executed 988 - ccache 98 hit / 6524 miss - head e0878c86e - digest sha256:1f84577a1a9b21... - run 35508804392
tests failed120987 / 9882m 54s / 5m 27sdocker run ... @sha256:3d31cd4...1 day ago
run 35440982827
failed: postgres_fdw/postgres_fdw
executed 988 - ccache 98 hit / 6524 miss - head 20e1df654 - digest sha256:3d31cd4e698005... - run 35440982827
tests failed120987 / 9882m 52s / 5m 08sdocker run ... @sha256:6826d79...2 days ago
run 35341130790
failed: postgres_fdw/postgres_fdw
executed 988 - ccache 98 hit / 6524 miss - head 6cb0baf73 - digest sha256:6826d794826df4... - run 35341130790
tests failed120987 / 9882m 54s / 5m 35sdocker run ... @sha256:a35baeb...3 days ago
run 35217088418
failed: postgres_fdw/postgres_fdw
executed 988 - ccache 98 hit / 6524 miss - head 4939983d6 - digest sha256:a35baeba504fd7... - run 35217088418
tests failed120987 / 9882m 53s / 5m 27sdocker run ... @sha256:53f5f7f...4 days ago
run 35091227016
failed: postgres_fdw/postgres_fdw
executed 988 - ccache 98 hit / 6524 miss - head f47660e36 - digest sha256:53f5f7fb0f237c... - run 35091227016
tests failed120890 / 8912m 48s / 4m 26sdocker run ... @sha256:fc95e83...5 days ago
run 34963674923
failed: postgres_fdw/postgres_fdw
executed 891 - ccache 98 hit / 6516 miss - head cf0534bf8 - digest sha256:fc95e832992d71... - run 34963674923
tests failed120974 / 9752m 55s / 5m 27s-6 days ago
run 34838115603
failed: postgres_fdw/postgres_fdw
executed 975 - ccache 98 hit / 6523 miss - head b0608fdb6 - run 34838115603
tests failed120978 / 9792m 53s / 5m 29sdocker run ... @sha256:372264f...Sep 13, 10:57
run 34752751015
failed: postgres_fdw/postgres_fdw
executed 979 - ccache 98 hit / 6523 miss - head a77eafb47 - digest sha256:372264f88f925e... - run 34752751015
tests failed120974 / 9752m 56s / 5m 30sdocker run ... @sha256:a35bd8a...Sep 12, 10:49
run 34688906849
failed: postgres_fdw/postgres_fdw
executed 975 - ccache 98 hit / 6523 miss - head 6e9330302 - digest sha256:a35bd8ad19b8bc... - run 34688906849
tests failed120976 / 9772m 54s / 5m 26sdocker run ... @sha256:90d5688...Sep 11, 10:51
run 34589947746
failed: postgres_fdw/postgres_fdw
executed 977 - ccache 98 hit / 6523 miss - head 110fd8686 - digest sha256:90d56881855c46... - run 34589947746
tests failed120973 / 9743m 04s / 5m 32sdocker run ... @sha256:3baca5b...Sep 10, 10:48
run 34466632216
failed: postgres_fdw/postgres_fdw
executed 974 - ccache 98 hit / 6523 miss - head 688b67f8a - digest sha256:3baca5bdc93be5... - run 34466632216
tests failed120970 / 9712m 56s / 5m 19sdocker run ... @sha256:36af5f1...Sep 09, 10:48
run 34340647314
failed: postgres_fdw/postgres_fdw
executed 971 - ccache 98 hit / 6516 miss - head 59e32c66c - digest sha256:36af5f19382b0d... - run 34340647314
tests failed120974 / 9752m 55s / 5m 34sdocker run ... @sha256:85f5199...Sep 08, 10:43
run 34215795999
failed: postgres_fdw/postgres_fdw
executed 975 - ccache 98 hit / 6523 miss - head 37fac669c - digest sha256:85f51995188438... - run 34215795999
tests failed120975 / 9762m 51s / 5m 08sdocker run ... @sha256:fa9d2de...Sep 07, 10:37
run 34111408719
failed: postgres_fdw/postgres_fdw
executed 976 - ccache 98 hit / 6527 miss - head 0a9d3cf60 - digest sha256:fa9d2ded8817fe... - run 34111408719
tests failed120975 / 9762m 55s / 5m 21sdocker run ... @sha256:a39b4c7...Sep 05, 12:28
run 33965605869
failed: postgres_fdw/postgres_fdw
executed 976 - ccache 98 hit / 6527 miss - head 604b34254 - digest sha256:a39b4c752bf7c2... - run 33965605869
tests failed120978 / 9792m 54s / 5m 31sdocker run ... @sha256:7c820ba...Sep 04, 12:30
run 33871783635
failed: postgres_fdw/postgres_fdw
executed 979 - ccache 98 hit / 6527 miss - head 0f67821b8 - digest sha256:7c820bac14fa65... - run 33871783635
tests failed120974 / 9752m 47s / 5m 24sdocker run ... @sha256:15da9ba...Sep 03, 12:24
run 33753872109
failed: postgres_fdw/postgres_fdw
executed 975 - ccache 98 hit / 6526 miss - head 4d256124a - digest sha256:15da9baedff92a... - run 33753872109
tests failed120973 / 9742m 48s / 4m 52sdocker run ... @sha256:8cf1c71...Sep 02, 12:21
run 33628512373
failed: postgres_fdw/postgres_fdw
executed 974 - ccache 98 hit / 6526 miss - head 782ab8c0c - digest sha256:8cf1c716e46a63... - run 33628512373
tests failed120973 / 9742m 57s / 5m 30sdocker run ... @sha256:a0417cd...Sep 01, 12:20
run 33505995465
failed: postgres_fdw/postgres_fdw
executed 974 - ccache 98 hit / 6526 miss - head 783008199 - digest sha256:a0417cd237c462... - run 33505995465
tests failed120973 / 9741m 56s / 4m 30sdocker run ... @sha256:0b3256a...Aug 31, 12:09
run 33389558298
failed: postgres_fdw/postgres_fdw
executed 974 - ccache 98 hit / 6526 miss - head 2b55b910e - digest sha256:0b3256a07d704c... - run 33389558298
tests failed120972 / 9732m 56s / 5m 15sdocker run ... @sha256:4a1285f...Aug 30, 12:08
run 33310218550
failed: postgres_fdw/postgres_fdw
executed 973 - ccache 98 hit / 6525 miss - head ab2925df9 - digest sha256:4a1285f78ab319... - run 33310218550
tests failed120975 / 9762m 17s / 4m 24sdocker run ... @sha256:801c10c...Aug 29, 12:05
run 33251261799
failed: postgres_fdw/postgres_fdw
executed 976 - ccache 98 hit / 6525 miss - head 010ba2f4d - digest sha256:801c10cbdffa95... - run 33251261799
tests failed120971 / 9722m 57s / 5m 15sdocker run ... @sha256:9c50022...Aug 28, 12:04
run 33168925157
failed: postgres_fdw/postgres_fdw
executed 972 - ccache 98 hit / 6518 miss - head 7f741bf26 - digest sha256:9c50022d8c5722... - run 33168925157
tests failed120971 / 9722m 55s / 5m 08sdocker run ... @sha256:f5976d7...Aug 27, 12:02
run 33069288928
failed: postgres_fdw/postgres_fdw
executed 972 - ccache 98 hit / 6518 miss - head 1181c9104 - digest sha256:f5976d7d547307... - run 33069288928
tests failed120975 / 9762m 54s / 5m 31sdocker run ... @sha256:9546036...Aug 26, 11:53
run 32964689338
failed: postgres_fdw/postgres_fdw
executed 976 - ccache 98 hit / 6525 miss - head 84e1b93cb - digest sha256:954603646468d0... - run 32964689338
tests failed120975 / 9762m 15s / 4m 48sdocker run ... @sha256:b6d118f...Aug 25, 11:42
run 32842735208
failed: postgres_fdw/postgres_fdw
executed 976 - ccache 98 hit / 6525 miss - head 50674c5c6 - digest sha256:b6d118f8a10eda... - run 32842735208
tests failed120977 / 9782m 47s / 5m 25sdocker run ... @sha256:402152e...Aug 24, 11:37
run 32721919660
failed: postgres_fdw/postgres_fdw
executed 978 - ccache 98 hit / 6525 miss - head 313ac8555 - digest sha256:402152e214e4ad... - run 32721919660
tests failed120974 / 9752m 55s / 5m 28sdocker run ... @sha256:6ae1047...Aug 23, 11:36
run 32636511566
failed: postgres_fdw/postgres_fdw
executed 975 - ccache 98 hit / 6525 miss - head e8ff12703 - digest sha256:6ae10470324af2... - run 32636511566
tests failed120973 / 9742m 53s / 5m 21sdocker run ... @sha256:6372716...Aug 22, 11:35
run 32570201852
failed: postgres_fdw/postgres_fdw
executed 974 - ccache 98 hit / 6518 miss - head de85fff0a - digest sha256:63727164ad6afb... - run 32570201852
tests failed120974 / 9752m 47s / 5m 06sdocker run ... @sha256:6033358...Aug 21, 11:34
run 32477034303
failed: postgres_fdw/postgres_fdw
executed 975 - ccache 98 hit / 6525 miss - head a5dbaa98e - digest sha256:6033358f494bbc... - run 32477034303
tests failed120978 / 9792m 56s / 5m 35sdocker run ... @sha256:63048ef...Aug 20, 11:33
run 32363454422
failed: postgres_fdw/postgres_fdw
executed 979 - ccache 98 hit / 6525 miss - head 3882ebd0f - digest sha256:63048ef740fd5c... - run 32363454422
tests failed120974 / 9751m 53s / 4m 05sdocker run ... @sha256:c1da584...Aug 19, 11:33
run 32247112677
failed: postgres_fdw/postgres_fdw
executed 975 - ccache 98 hit / 6525 miss - head 93bfee7f4 - digest sha256:c1da584f76852f... - run 32247112677
tests failed120972 / 9732m 59s / 5m 24sdocker run ... @sha256:795c704...Aug 18, 11:19
run 32130181871
failed: postgres_fdw/postgres_fdw
executed 973 - ccache 98 hit / 6524 miss - head 65dca2b57 - digest sha256:795c7049b37b00... - run 32130181871
tests failed120970 / 9712m 58s / 5m 34sdocker run ... @sha256:13564e7...Aug 17, 11:16
run 32023139347
failed: postgres_fdw/postgres_fdw
executed 971 - ccache 98 hit / 6524 miss - head 2f825ffca - digest sha256:13564e75191495... - run 32023139347
tests failed120970 / 9712m 47s / 5m 00sdocker run ... @sha256:26fe0af...Aug 16, 11:15
run 31943296363
failed: postgres_fdw/postgres_fdw
executed 971 - ccache 98 hit / 6524 miss - head 3ed227e4d - digest sha256:26fe0af9677677... - run 31943296363
tests failed120970 / 9712m 53s / 5m 15sdocker run ... @sha256:ca7b842...Aug 15, 11:16
run 31881052688
failed: postgres_fdw/postgres_fdw
executed 971 - ccache 98 hit / 6524 miss - head 092b8b078 - digest sha256:ca7b842a85b071... - run 31881052688
tests failed120970 / 9712m 52s / 5m 28sdocker run ... @sha256:93d763d...Aug 14, 11:15
run 31794594628
failed: postgres_fdw/postgres_fdw
executed 971 - ccache 165 hit / 6457 miss - head 0fcfa95cc - digest sha256:93d763d6901cf2... - run 31794594628
tests failed120973 / 9742m 52s / 5m 30sdocker run ... @sha256:2c5d15e...Aug 13, 11:13
run 31693636145
failed: postgres_fdw/postgres_fdw
executed 974 - ccache 165 hit / 6457 miss - head 2649acb7c - digest sha256:2c5d15e735b49f... - run 31693636145
tests failed120970 / 9712m 55s / 5m 32sdocker run ... @sha256:9018560...Aug 12, 11:11
run 31589794910
failed: postgres_fdw/postgres_fdw
executed 971 - ccache 165 hit / 6457 miss - head 70b371edc - digest sha256:90185605e3a119... - run 31589794910
tests failed120970 / 9712m 47s / 5m 17sdocker run ... @sha256:090e7be...Aug 11, 11:11
run 31484494493
failed: postgres_fdw/postgres_fdw
executed 971 - ccache 165 hit / 6453 miss - head 743996280 - digest sha256:090e7be6f312d5... - run 31484494493
tests failed120970 / 9711m 55s / 3m 59sdocker run ... @sha256:fa96557...Aug 10, 10:58
run 31380744982
failed: postgres_fdw/postgres_fdw
executed 971 - ccache 166 hit / 6452 miss - head 8bf9075c9 - digest sha256:fa96557dc90aec... - run 31380744982
tests failed120970 / 9712m 57s / 5m 31sdocker run ... @sha256:a5fc6d1...Aug 08, 13:17
run 31258740658
failed: postgres_fdw/postgres_fdw
executed 971 - ccache 166 hit / 6452 miss - head cc94776a5 - digest sha256:a5fc6d1028aa54... - run 31258740658
tests failed120969 / 9702m 48s / 4m 56sdocker run ... @sha256:5b37fc8...Aug 07, 13:13
run 31180832379
failed: postgres_fdw/postgres_fdw
executed 970 - ccache 166 hit / 6445 miss - head 309d77f2c - digest sha256:5b37fc845cbbba... - run 31180832379
tests failed120969 / 9702m 58s / 5m 32sdocker run ... @sha256:f13d9e7...Aug 06, 13:13
run 31104019237
failed: postgres_fdw/postgres_fdw
executed 970 - ccache 166 hit / 6452 miss - head 1779b0a9f - digest sha256:f13d9e745f12b0... - run 31104019237
tests failed120972 / 9732m 59s / 5m 36sdocker run ... @sha256:a4568c6...Aug 05, 13:11
run 31008008777
failed: postgres_fdw/postgres_fdw
executed 973 - ccache 166 hit / 6452 miss - head d4ffb2f77 - digest sha256:a4568c6b68b2ac... - run 31008008777
tests failed120969 / 9702m 50s / 5m 12sdocker run ... @sha256:9d02aa9...Aug 04, 13:05
run 30911112746
failed: postgres_fdw/postgres_fdw
executed 970 - ccache 166 hit / 6452 miss - head 39ea05d57 - digest sha256:9d02aa956bbb14... - run 30911112746
tests failed120968 / 9692m 48s / 5m 01sdocker run ... @sha256:9016913...Aug 03, 13:04
run 30815385192
failed: postgres_fdw/postgres_fdw
executed 969 - ccache 166 hit / 6452 miss - head 3ed7151d8 - digest sha256:9016913c38c63d... - run 30815385192
tests failed120972 / 9732m 54s / 5m 30sdocker run ... @sha256:bbc11d6...Aug 02, 13:01
run 30748647312
failed: postgres_fdw/postgres_fdw
executed 973 - ccache 166 hit / 6452 miss - head 528496ec9 - digest sha256:bbc11d638905f9... - run 30748647312
tests failed120971 / 9722m 58s / 5m 26sdocker run ... @sha256:cfab447...Aug 01, 13:02
run 30700473386
failed: postgres_fdw/postgres_fdw
executed 972 - ccache 166 hit / 6452 miss - head b5ebea08e - digest sha256:cfab447e62c542... - run 30700473386
tests failed120967 / 9682m 54s / 5m 31sdocker run ... @sha256:5e62637...Jul 31, 13:03
run 30631981892
failed: postgres_fdw/postgres_fdw
executed 968 - ccache 166 hit / 6452 miss - head 46f144ad6 - digest sha256:5e626378208016... - run 30631981892
tests failed120966 / 9671m 53s / 4m 00sdocker run ... @sha256:5cfba8f...Jul 30, 12:56
run 30543929398
failed: postgres_fdw/postgres_fdw
executed 967 - ccache 166 hit / 6445 miss - head e27b2e69a - digest sha256:5cfba8fe26cd84... - run 30543929398
tests failed120966 / 9672m 09s / 4m 32sdocker run ... @sha256:8c772c5...Jul 29, 12:57
run 30452891610
failed: postgres_fdw/postgres_fdw
executed 967 - ccache 166 hit / 6452 miss - head 577df41a3 - digest sha256:8c772c583ea668... - run 30452891610
tests failed120965 / 9662m 58s / 5m 17sdocker run ... @sha256:834e1d7...Jul 28, 13:01
run 30360095131
failed: postgres_fdw/postgres_fdw
executed 966 - ccache 166 hit / 6452 miss - head 5eaff46ca - digest sha256:834e1d711073f7... - run 30360095131
tests failed120964 / 9652m 56s / 5m 16sdocker run ... @sha256:44a30c0...Jul 27, 18:06
run 30291284405
failed: postgres_fdw/postgres_fdw
executed 965 - ccache 166 hit / 6452 miss - head bfac36c6a - digest sha256:44a30c0b263574... - run 30291284405