BUG #15383: Join Filter cost estimation problem in 10.5
1 patchset tracked - current t39345_18
v18t39345_18posted Apr 24, 2020tests failedneeds rebaserecent 26dpg 20
base53a981ed5 Aug 24, 10:43 on master
applyapplied Aug 24, 11:42
rebaselast tried about 4 hours ago on 9e17d25e7
Applied patch to 'src/backend/optimizer/path/costsize.c' with conflicts. U src/backend/optimizer/path/costsize.c
conflicts on master: src/backend/optimizer/path/costsize.c
pushAug 24, 11:43 -> d67e395e0branchdiff vs base
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| tests failed | 1 | 20 | 840 / 861 | 2m 53s / 5m 04s | docker run ... :t39345 | Aug 24, 11:53 |
run 32723280891failed: pg_plan_advice/gather, pg_plan_advice/semijoin, regress/opr_sanity, regress/create_index, regress/create_view, regress/updatable_views, regress/subselect, regress/join, regress/merge, regress/collate.icu.utf8, regress/generated_virtual, regress/select_views, regress/equivclass, regress/plpgsql, regress/partition_join, regress/partition_aggregate, regress/predicate, regress/eager_aggregate, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 861 - ccache 98 hit / 6518 miss - head d67e395e0 - digest sha256:2f0424d6d006f3... - run 32723280891 | ||||||
| tests failed | 1 | 20 | 837 / 858 | 2m 53s / 5m 17s | docker run ... @sha256:c3b2027... | Aug 23, 11:52 |
run 32637294173failed: pg_plan_advice/gather, pg_plan_advice/semijoin, regress/opr_sanity, regress/create_index, regress/create_view, regress/updatable_views, regress/subselect, regress/join, regress/merge, regress/collate.icu.utf8, regress/generated_virtual, regress/select_views, regress/equivclass, regress/plpgsql, regress/partition_join, regress/partition_aggregate, regress/predicate, regress/eager_aggregate, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 858 - ccache 98 hit / 6525 miss - head 4b6acd313 - digest sha256:c3b2027f75954d... - run 32637294173 | ||||||
| tests failed | 1 | 20 | 833 / 854 | 2m 47s / 5m 00s | docker run ... @sha256:0f19d03... | Aug 22, 11:51 |
run 32570959133failed: pg_plan_advice/gather, pg_plan_advice/semijoin, regress/opr_sanity, regress/create_index, regress/create_view, regress/updatable_views, regress/subselect, regress/join, regress/merge, regress/collate.icu.utf8, regress/generated_virtual, regress/select_views, regress/equivclass, regress/plpgsql, regress/partition_join, regress/partition_aggregate, regress/predicate, regress/eager_aggregate, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 854 - ccache 98 hit / 6525 miss - head bea3ab035 - digest sha256:0f19d03fc9c14a... - run 32570959133 | ||||||
| tests failed | 1 | 20 | 837 / 858 | 1m 56s / 3m 56s | docker run ... @sha256:dcf6ec8... | Aug 21, 11:48 |
run 32478216980failed: pg_plan_advice/gather, pg_plan_advice/semijoin, regress/opr_sanity, regress/create_index, regress/create_view, regress/updatable_views, regress/subselect, regress/join, regress/merge, regress/collate.icu.utf8, regress/generated_virtual, regress/select_views, regress/equivclass, regress/plpgsql, regress/partition_join, regress/partition_aggregate, regress/predicate, regress/eager_aggregate, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 858 - ccache 98 hit / 6525 miss - head 778f24e16 - digest sha256:dcf6ec81735a6d... - run 32478216980 | ||||||
| tests failed | 1 | 20 | 830 / 851 | 2m 55s / 5m 10s | docker run ... @sha256:c538634... | Aug 20, 11:47 |
run 32364688670failed: pg_plan_advice/gather, pg_plan_advice/semijoin, regress/opr_sanity, regress/create_index, regress/create_view, regress/updatable_views, regress/subselect, regress/join, regress/merge, regress/collate.icu.utf8, regress/generated_virtual, regress/select_views, regress/equivclass, regress/plpgsql, regress/partition_join, regress/partition_aggregate, regress/predicate, regress/eager_aggregate, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 851 - ccache 98 hit / 6525 miss - head 0bc21a010 - digest sha256:c538634c0393b8... - run 32364688670 | ||||||
| tests failed | 1 | 20 | 830 / 851 | 2m 49s / 5m 06s | docker run ... @sha256:13178e1... | Aug 19, 11:50 |
run 32248367050failed: pg_plan_advice/gather, pg_plan_advice/semijoin, regress/opr_sanity, regress/create_index, regress/create_view, regress/updatable_views, regress/subselect, regress/join, regress/merge, regress/collate.icu.utf8, regress/generated_virtual, regress/select_views, regress/equivclass, regress/plpgsql, regress/partition_join, regress/partition_aggregate, regress/predicate, regress/eager_aggregate, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 851 - ccache 98 hit / 6518 miss - head 873d6df9b - digest sha256:13178e13a3e690... - run 32248367050 | ||||||
| tests failed | 1 | 20 | 830 / 851 | 1m 49s / 3m 42s | docker run ... @sha256:3484199... | Aug 18, 11:34 |
run 32131575265failed: pg_plan_advice/gather, pg_plan_advice/semijoin, regress/opr_sanity, regress/create_index, regress/create_view, regress/updatable_views, regress/subselect, regress/join, regress/merge, regress/collate.icu.utf8, regress/generated_virtual, regress/select_views, regress/equivclass, regress/plpgsql, regress/partition_join, regress/partition_aggregate, regress/predicate, regress/eager_aggregate, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 851 - ccache 98 hit / 6524 miss - head 245c2d2bf - digest sha256:3484199a3ec69c... - run 32131575265 | ||||||
| tests failed | 1 | 20 | 827 / 848 | 2m 54s / 5m 11s | docker run ... @sha256:725b641... | Aug 17, 11:33 |
run 32024636559failed: pg_plan_advice/gather, pg_plan_advice/semijoin, regress/opr_sanity, regress/create_index, regress/create_view, regress/updatable_views, regress/subselect, regress/join, regress/merge, regress/collate.icu.utf8, regress/generated_virtual, regress/select_views, regress/equivclass, regress/plpgsql, regress/partition_join, regress/partition_aggregate, regress/predicate, regress/eager_aggregate, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 848 - ccache 98 hit / 6524 miss - head 4ae4ad082 - digest sha256:725b6414fc5715... - run 32024636559 | ||||||
| tests failed | 1 | 20 | 830 / 851 | 2m 55s / 5m 02s | docker run ... @sha256:3fae191... | Aug 16, 11:31 |
run 31944085663failed: pg_plan_advice/gather, pg_plan_advice/semijoin, regress/opr_sanity, regress/create_index, regress/create_view, regress/updatable_views, regress/subselect, regress/join, regress/merge, regress/collate.icu.utf8, regress/generated_virtual, regress/select_views, regress/equivclass, regress/plpgsql, regress/partition_join, regress/partition_aggregate, regress/predicate, regress/eager_aggregate, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 851 - ccache 98 hit / 6524 miss - head 970af4b8c - digest sha256:3fae1912957e98... - run 31944085663 | ||||||
| tests failed | 1 | 20 | 827 / 848 | 2m 51s / 5m 06s | docker run ... @sha256:ad05719... | Aug 15, 11:29 |
run 31881724732failed: pg_plan_advice/gather, pg_plan_advice/semijoin, regress/opr_sanity, regress/create_index, regress/create_view, regress/updatable_views, regress/subselect, regress/join, regress/merge, regress/collate.icu.utf8, regress/generated_virtual, regress/select_views, regress/equivclass, regress/plpgsql, regress/partition_join, regress/partition_aggregate, regress/predicate, regress/eager_aggregate, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 848 - ccache 98 hit / 6524 miss - head fa187c3d1 - digest sha256:ad05719a494cad... - run 31881724732 | ||||||
| tests failed | 1 | 20 | 828 / 849 | 2m 50s / 5m 14s | docker run ... @sha256:29477d3... | Aug 14, 11:29 |
run 31795607881failed: pg_plan_advice/gather, pg_plan_advice/semijoin, regress/opr_sanity, regress/create_index, regress/create_view, regress/updatable_views, regress/subselect, regress/join, regress/merge, regress/collate.icu.utf8, regress/generated_virtual, regress/select_views, regress/equivclass, regress/plpgsql, regress/partition_join, regress/partition_aggregate, regress/predicate, regress/eager_aggregate, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 849 - ccache 165 hit / 6457 miss - head 54f13a2d5 - digest sha256:29477d369da750... - run 31795607881 | ||||||
| tests failed | 1 | 20 | 830 / 851 | 2m 48s / 4m 57s | docker run ... @sha256:5f683c1... | Aug 13, 11:27 |
run 31694706110failed: pg_plan_advice/gather, pg_plan_advice/semijoin, regress/opr_sanity, regress/create_index, regress/create_view, regress/updatable_views, regress/subselect, regress/join, regress/merge, regress/collate.icu.utf8, regress/generated_virtual, regress/select_views, regress/equivclass, regress/plpgsql, regress/partition_join, regress/partition_aggregate, regress/predicate, regress/eager_aggregate, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 851 - ccache 165 hit / 6457 miss - head 8975009d3 - digest sha256:5f683c19277599... - run 31694706110 | ||||||
| tests failed | 1 | 20 | 827 / 848 | 2m 46s / 5m 00s | docker run ... @sha256:2653a2d... | Aug 12, 11:26 |
run 31590991220failed: pg_plan_advice/gather, pg_plan_advice/semijoin, regress/opr_sanity, regress/create_index, regress/create_view, regress/updatable_views, regress/subselect, regress/join, regress/merge, regress/collate.icu.utf8, regress/generated_virtual, regress/select_views, regress/equivclass, regress/plpgsql, regress/partition_join, regress/partition_aggregate, regress/predicate, regress/eager_aggregate, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 848 - ccache 165 hit / 6457 miss - head 854ea8d0d - digest sha256:2653a2d60729b2... - run 31590991220 | ||||||
| tests failed | 1 | 20 | 836 / 857 | 2m 49s / 5m 08s | docker run ... @sha256:5fc2309... | Aug 11, 11:24 |
run 31485630871failed: pg_plan_advice/gather, pg_plan_advice/semijoin, regress/opr_sanity, regress/create_index, regress/create_view, regress/updatable_views, regress/subselect, regress/join, regress/merge, regress/collate.icu.utf8, regress/generated_virtual, regress/select_views, regress/equivclass, regress/plpgsql, regress/partition_join, regress/partition_aggregate, regress/predicate, regress/eager_aggregate, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 857 - ccache 165 hit / 6453 miss - head f646b2cb5 - digest sha256:5fc23097d1fa18... - run 31485630871 | ||||||
| tests failed | 1 | 20 | 827 / 848 | 2m 55s / 5m 04s | docker run ... @sha256:d5451ef... | Aug 10, 11:17 |
run 31381729174failed: pg_plan_advice/gather, pg_plan_advice/semijoin, regress/opr_sanity, regress/create_index, regress/create_view, regress/updatable_views, regress/subselect, regress/join, regress/merge, regress/collate.icu.utf8, regress/generated_virtual, regress/select_views, regress/equivclass, regress/plpgsql, regress/partition_join, regress/partition_aggregate, regress/predicate, regress/eager_aggregate, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 848 - ccache 166 hit / 6452 miss - head c09f009f3 - digest sha256:d5451efc28b844... - run 31381729174 | ||||||
| tests failed | 1 | 20 | 827 / 848 | 2m 54s / 5m 03s | docker run ... @sha256:01e2407... | Aug 08, 13:30 |
run 31259258692failed: pg_plan_advice/gather, pg_plan_advice/semijoin, regress/opr_sanity, regress/create_index, regress/create_view, regress/updatable_views, regress/subselect, regress/join, regress/merge, regress/collate.icu.utf8, regress/generated_virtual, regress/select_views, regress/equivclass, regress/plpgsql, regress/partition_join, regress/partition_aggregate, regress/predicate, regress/eager_aggregate, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 848 - ccache 166 hit / 6452 miss - head 64b6c4e2a - digest sha256:01e24074ee7de5... - run 31259258692 | ||||||
| tests failed | 1 | 20 | 830 / 851 | 2m 55s / 5m 14s | docker run ... @sha256:8b4209f... | Aug 07, 13:28 |
run 31181921579failed: pg_plan_advice/gather, pg_plan_advice/semijoin, regress/opr_sanity, regress/create_index, regress/create_view, regress/updatable_views, regress/subselect, regress/join, regress/merge, regress/collate.icu.utf8, regress/generated_virtual, regress/select_views, regress/equivclass, regress/plpgsql, regress/partition_join, regress/partition_aggregate, regress/predicate, regress/eager_aggregate, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 851 - ccache 166 hit / 6452 miss - head 9e8f47637 - digest sha256:8b4209f2870b56... - run 31181921579 | ||||||
| tests failed | 1 | 20 | 826 / 847 | 2m 52s / 5m 07s | docker run ... @sha256:e698155... | Aug 06, 13:27 |
run 31105124090failed: pg_plan_advice/gather, pg_plan_advice/semijoin, regress/opr_sanity, regress/create_index, regress/create_view, regress/updatable_views, regress/subselect, regress/join, regress/merge, regress/collate.icu.utf8, regress/generated_virtual, regress/select_views, regress/equivclass, regress/plpgsql, regress/partition_join, regress/partition_aggregate, regress/predicate, regress/eager_aggregate, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 847 - ccache 166 hit / 6452 miss - head 5fe85685e - digest sha256:e698155e3887d8... - run 31105124090 | ||||||
| tests failed | 1 | 20 | 832 / 853 | 2m 53s / 5m 06s | docker run ... @sha256:aefbac6... | Aug 05, 13:24 |
run 31009114870failed: pg_plan_advice/gather, pg_plan_advice/semijoin, regress/opr_sanity, regress/create_index, regress/create_view, regress/updatable_views, regress/subselect, regress/join, regress/merge, regress/collate.icu.utf8, regress/generated_virtual, regress/select_views, regress/equivclass, regress/plpgsql, regress/partition_join, regress/partition_aggregate, regress/predicate, regress/eager_aggregate, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 853 - ccache 166 hit / 6452 miss - head d8c0fed0a - digest sha256:aefbac63ebf51d... - run 31009114870 | ||||||
| tests failed | 1 | 20 | 825 / 846 | 2m 49s / 4m 45s | docker run ... @sha256:62c40b9... | Aug 04, 13:24 |
run 30912600239failed: pg_plan_advice/gather, pg_plan_advice/semijoin, regress/opr_sanity, regress/create_index, regress/create_view, regress/updatable_views, regress/subselect, regress/join, regress/merge, regress/collate.icu.utf8, regress/generated_virtual, regress/select_views, regress/equivclass, regress/plpgsql, regress/partition_join, regress/partition_aggregate, regress/predicate, regress/eager_aggregate, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 846 - ccache 166 hit / 6445 miss - head a9263a820 - digest sha256:62c40b911f43ab... - run 30912600239 | ||||||
| tests failed | 1 | 20 | 831 / 852 | 2m 51s / 4m 59s | docker run ... @sha256:0773176... | Aug 03, 13:24 |
run 30816785911failed: pg_plan_advice/gather, pg_plan_advice/semijoin, regress/opr_sanity, regress/create_index, regress/create_view, regress/updatable_views, regress/subselect, regress/join, regress/merge, regress/collate.icu.utf8, regress/generated_virtual, regress/select_views, regress/equivclass, regress/plpgsql, regress/partition_join, regress/partition_aggregate, regress/predicate, regress/eager_aggregate, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 852 - ccache 166 hit / 6452 miss - head e97bc8f85 - digest sha256:0773176602a0fa... - run 30816785911 | ||||||
| tests failed | 1 | 20 | 825 / 846 | 2m 54s / 5m 01s | docker run ... @sha256:f6022f8... | Aug 02, 13:19 |
run 30749326708failed: pg_plan_advice/gather, pg_plan_advice/semijoin, regress/opr_sanity, regress/create_index, regress/create_view, regress/updatable_views, regress/subselect, regress/join, regress/merge, regress/collate.icu.utf8, regress/generated_virtual, regress/select_views, regress/equivclass, regress/plpgsql, regress/partition_join, regress/partition_aggregate, regress/predicate, regress/eager_aggregate, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 846 - ccache 166 hit / 6452 miss - head 616287d08 - digest sha256:f6022f88225edc... - run 30749326708 | ||||||
| tests failed | 1 | 20 | 827 / 848 | 3m 00s / 5m 10s | docker run ... @sha256:dbc0179... | Aug 01, 13:19 |
run 30701132762failed: pg_plan_advice/gather, pg_plan_advice/semijoin, regress/opr_sanity, regress/create_index, regress/create_view, regress/updatable_views, regress/subselect, regress/join, regress/merge, regress/collate.icu.utf8, regress/generated_virtual, regress/select_views, regress/equivclass, regress/plpgsql, regress/partition_join, regress/partition_aggregate, regress/predicate, regress/eager_aggregate, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 848 - ccache 166 hit / 6452 miss - head 22cac0e5d - digest sha256:dbc017941004cb... - run 30701132762 | ||||||
| tests failed | 1 | 20 | 824 / 845 | 3m 00s / 5m 05s | docker run ... @sha256:f43414e... | Jul 31, 13:19 |
run 30633274879failed: pg_plan_advice/gather, pg_plan_advice/semijoin, regress/opr_sanity, regress/create_index, regress/create_view, regress/updatable_views, regress/subselect, regress/join, regress/merge, regress/collate.icu.utf8, regress/generated_virtual, regress/select_views, regress/equivclass, regress/plpgsql, regress/partition_join, regress/partition_aggregate, regress/predicate, regress/eager_aggregate, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 845 - ccache 166 hit / 6452 miss - head 71dd760c3 - digest sha256:f43414e88f1457... - run 30633274879 | ||||||
| tests failed | 1 | 20 | 827 / 848 | 2m 55s / 4m 59s | docker run ... @sha256:eb1df54... | Jul 30, 13:18 |
run 30545479515failed: pg_plan_advice/gather, pg_plan_advice/semijoin, regress/opr_sanity, regress/create_index, regress/create_view, regress/updatable_views, regress/subselect, regress/join, regress/merge, regress/collate.icu.utf8, regress/generated_virtual, regress/select_views, regress/equivclass, regress/plpgsql, regress/partition_join, regress/partition_aggregate, regress/predicate, regress/eager_aggregate, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 848 - ccache 166 hit / 6452 miss - head 7d6236427 - digest sha256:eb1df5490b8d17... - run 30545479515 | ||||||
| tests failed | 1 | 20 | 822 / 843 | 2m 53s / 4m 53s | docker run ... @sha256:a79df9f... | Jul 29, 13:15 |
run 30454419480failed: pg_plan_advice/gather, pg_plan_advice/semijoin, regress/opr_sanity, regress/create_index, regress/create_view, regress/updatable_views, regress/subselect, regress/join, regress/merge, regress/collate.icu.utf8, regress/generated_virtual, regress/select_views, regress/equivclass, regress/plpgsql, regress/partition_join, regress/partition_aggregate, regress/predicate, regress/eager_aggregate, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 843 - ccache 166 hit / 6445 miss - head d1fbe1ad1 - digest sha256:a79df9fd65a19c... - run 30454419480 | ||||||
| tests failed | 1 | 20 | 825 / 846 | 2m 59s / 5m 12s | docker run ... @sha256:91b8ef7... | Jul 28, 13:17 |
run 30361792068failed: pg_plan_advice/gather, pg_plan_advice/semijoin, regress/opr_sanity, regress/create_index, regress/create_view, regress/updatable_views, regress/subselect, regress/join, regress/merge, regress/collate.icu.utf8, regress/generated_virtual, regress/select_views, regress/equivclass, regress/plpgsql, regress/partition_join, regress/partition_aggregate, regress/predicate, regress/eager_aggregate, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 846 - ccache 166 hit / 6452 miss - head 5dbb8318b - digest sha256:91b8ef76c156cb... - run 30361792068 | ||||||
| tests failed | 1 | 20 | 829 / 850 | 2m 22s / 4m 05s | docker run ... @sha256:212ff09... | Jul 27, 19:07 |
run 30295903638failed: pg_plan_advice/gather, pg_plan_advice/semijoin, regress/opr_sanity, regress/create_index, regress/create_view, regress/updatable_views, regress/subselect, regress/join, regress/merge, regress/collate.icu.utf8, regress/generated_virtual, regress/select_views, regress/equivclass, regress/plpgsql, regress/partition_join, regress/partition_aggregate, regress/predicate, regress/eager_aggregate, test_plan_advice/001_replan_regress, pg_upgrade/002_pg_upgrade, recovery/027_stream_regress executed 850 - ccache 166 hit / 6452 miss - head 0ba05a553 - digest sha256:212ff099146c33... - run 30295903638 | ||||||