Do not scan index in right table if condition for left join evaluates to false using columns in left table
5 patchsets tracked - current t50701_23
v23t50701_23posted 5 days agotests failedappliesrecent 0dpg 20
base9e17d25e7 about 12 hours ago on master
applyapplied about 7 hours ago
rebaselast tried about 7 hours ago on 9e17d25e7
pushabout 7 hours ago -> 2620614b1branchdiff vs base
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| tests failed | 1 | 20 | 984 / 985 | 2m 57s / 5m 24s | docker run ... :t50701 | about 7 hours ago |
run 35504434424failed: test_plan_advice/001_replan_regress executed 985 - ccache 98 hit / 6524 miss - head 2620614b1 - digest sha256:f376ba7fae6d3e... - run 35504434424 | ||||||
| tests failed | 1 | 20 | 984 / 985 | 1m 47s / 4m 06s | docker run ... @sha256:f89c1f3... | 1 day ago |
run 35436711808failed: test_plan_advice/001_replan_regress executed 985 - ccache 98 hit / 6524 miss - head d96cedf5f - digest sha256:f89c1f35c5a2df... - run 35436711808 | ||||||
| tests failed | 1 | 20 | 984 / 985 | 2m 45s / 5m 26s | docker run ... @sha256:d197123... | 2 days ago |
run 35333310186failed: test_plan_advice/001_replan_regress executed 985 - ccache 98 hit / 6524 miss - head 50361c4b4 - digest sha256:d1971237932632... - run 35333310186 | ||||||
| tests failed | 1 | 20 | 984 / 985 | 2m 55s / 5m 10s | docker run ... @sha256:5035da6... | 3 days ago |
run 35208967035failed: test_plan_advice/001_replan_regress executed 985 - ccache 98 hit / 6524 miss - head 72f5cc654 - digest sha256:5035da648715cd... - run 35208967035 | ||||||
| tests failed | 1 | 20 | 984 / 985 | 2m 54s / 5m 27s | docker run ... @sha256:0740fcc... | 4 days ago |
run 35083018678failed: test_plan_advice/001_replan_regress executed 985 - ccache 98 hit / 6524 miss - head d5b2e8575 - digest sha256:0740fccf51172a... - run 35083018678 | ||||||
| tests failed | 1 | 20 | 985 / 986 | 2m 26s / 4m 24s | docker run ... @sha256:0b84dde... | 5 days ago |
run 34955636398failed: test_plan_advice/001_replan_regress executed 986 - ccache 98 hit / 6523 miss - head 9f413c12a - digest sha256:0b84dde91e9cfd... - run 34955636398 | ||||||
v21t50701_21posted Sep 12, 12:02successsupersededrecent 5dpg 20
basea23ab4862 6 days ago on master
applyapplied 6 days ago
rebaselast tried 6 days ago on a23ab4862
push6 days ago -> 2f993ade7branchdiff vs base
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 20 | 1023 / 1023 | 2m 46s / 5m 20s | docker run ... @sha256:13167d4... | 6 days ago |
run 34846376554executed 1023 - ccache 98 hit / 6523 miss - head 2f993ade7 - digest sha256:13167d45813bd7... - run 34846376554 | ||||||
| success | 1 | 20 | 1023 / 1023 | 2m 54s / 5m 12s | docker run ... @sha256:faca3ce... | Sep 13, 12:30 |
run 34756816032executed 1023 - ccache 98 hit / 6523 miss - head e0a8d9cd1 - digest sha256:faca3ce2630b3b... - run 34756816032 | ||||||
| success | 1 | 20 | 1023 / 1023 | 2m 58s / 5m 38s | docker run ... @sha256:cfa5d96... | Sep 12, 12:19 |
run 34692708547executed 1023 - ccache 98 hit / 6523 miss - head 6e202fdf7 - digest sha256:cfa5d9692113e5... - run 34692708547 | ||||||
v20t50701_20posted Sep 01, 09:16successsupersededrecent 13dpg 20
basef836b688f Sep 07, 02:50 on master
applyapplied Sep 07, 07:30
rebaselast tried Sep 12, 07:36 on 512d3e891
Applying: Gate the NestLoop inner side with outer-only join clauses Using index info to reconstruct a base tree... M contrib/postgres_fdw/expected/postgres_fdw.out M src/backend/optimizer/plan/createplan.c M src/test/regress/expected/join.out M src/test/regress/expected/subselect.out M src/test/regress/sql/join.sql Falling back to patching base and 3-way merge... Auto-merging src/test/regress/sql/join.sql Auto-merging src/test/regress/expected/subselect.out Auto-merging src/test/regress/expected/join.out Auto-merging src/backend/optimizer/plan/createplan.c CONFLICT (content): Merge conflict in src/backend/optimizer/plan/createplan.c Auto-merging contrib/postgres_fdw/expected/postgres_fdw.out Patch failed at 0001 Gate the NestLoop inner side with outer-only join clauses error: Failed to merge in the changes. hint: Use 'git am --show-current-patch=diff' to see the failed patch hint: When you have resolved this problem, run "git am --continue". hint: If you prefer to skip this patch, run "git am --skip" instead. hint: To restore the original branch and stop patching, run "git am --abort". hint: Disable this message with "git config advice.mergeConflict false"
conflicts on master: src/backend/optimizer/plan/createplan.c
pushSep 07, 07:30 -> cd5ea8b73branchdiff vs base
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 20 | 1024 / 1024 | 2m 58s / 5m 48s | docker run ... @sha256:ad9ea78... | Sep 07, 07:43 |
run 34095831263executed 1024 - ccache 98 hit / 6527 miss - head cd5ea8b73 - digest sha256:ad9ea78bf3b631... - run 34095831263 | ||||||
| success | 1 | 20 | 1024 / 1024 | 2m 55s / 5m 29s | docker run ... @sha256:f693562... | Sep 05, 09:38 |
run 33957908440executed 1024 - ccache 98 hit / 6527 miss - head e35f4dfb2 - digest sha256:f693562a2476bf... - run 33957908440 | ||||||
| success | 1 | 20 | 1024 / 1024 | 2m 51s / 5m 27s | docker run ... @sha256:6040972... | Sep 04, 09:38 |
run 33858167735executed 1024 - ccache 98 hit / 6527 miss - head 3b9bf2963 - digest sha256:6040972a1d6da1... - run 33858167735 | ||||||
| success | 1 | 20 | 1023 / 1023 | 2m 12s / 4m 32s | docker run ... @sha256:dbaf288... | Sep 03, 09:32 |
run 33738250346executed 1023 - ccache 98 hit / 6526 miss - head b37ada8fd - digest sha256:dbaf288255c9d2... - run 33738250346 | ||||||
| success | 1 | 20 | 1022 / 1022 | 2m 54s / 5m 30s | docker run ... @sha256:f29711b... | Sep 02, 09:31 |
run 33613415582executed 1022 - ccache 98 hit / 6526 miss - head 8ee530f41 - digest sha256:f29711bb7bc99b... - run 33613415582 | ||||||
| success | 1 | 20 | 1022 / 1022 | 2m 55s / 5m 39s | docker run ... @sha256:f10a80a... | Sep 01, 09:30 |
run 33491443940executed 1022 - ccache 98 hit / 6526 miss - head ece146bbc - digest sha256:f10a80ab3ef1d4... - run 33491443940 | ||||||
v19t50701_19posted Jul 28, 08:13successsupersededrecent 23dpg 20
base6e5d5680b Aug 28, 01:10 on master
applyapplied Aug 28, 05:56
rebaselast tried Sep 01, 06:36 on 8e483af55
Applying: Gate the NestLoop inner side with outer-only join clauses Using index info to reconstruct a base tree... M contrib/postgres_fdw/expected/postgres_fdw.out M src/backend/executor/nodeNestloop.c M src/backend/optimizer/plan/createplan.c M src/include/nodes/plannodes.h M src/test/regress/expected/join.out M src/test/regress/expected/subselect.out M src/test/regress/sql/join.sql Falling back to patching base and 3-way merge... Auto-merging src/test/regress/sql/join.sql Auto-merging src/test/regress/expected/subselect.out Auto-merging src/test/regress/expected/join.out CONFLICT (content): Merge conflict in src/test/regress/expected/join.out Auto-merging src/include/nodes/plannodes.h Auto-merging src/backend/optimizer/plan/createplan.c Auto-merging src/backend/executor/nodeNestloop.c Auto-merging contrib/postgres_fdw/expected/postgres_fdw.out Patch failed at 0001 Gate the NestLoop inner side with outer-only join clauses error: Failed to merge in the changes. hint: Use 'git am --show-current-patch=diff' to see the failed patch hint: When you have resolved this problem, run "git am --continue". hint: If you prefer to skip this patch, run "git am --skip" instead. hint: To restore the original branch and stop patching, run "git am --abort". hint: Disable this message with "git config advice.mergeConflict false"
conflicts on master: src/test/regress/expected/join.out
pushAug 28, 05:56 -> b2c500b20branchdiff vs base
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 20 | 1021 / 1021 | 2m 17s / 4m 10s | docker run ... @sha256:4f99b40... | Aug 28, 06:05 |
run 33146302282executed 1021 - ccache 98 hit / 6525 miss - head b2c500b20 - digest sha256:4f99b40cbd08a7... - run 33146302282 | ||||||
| success | 1 | 20 | 1021 / 1021 | 2m 54s / 5m 15s | docker run ... @sha256:0bd0384... | Aug 27, 06:03 |
run 33043936155executed 1021 - ccache 98 hit / 6525 miss - head 45bf4ce48 - digest sha256:0bd0384794ca44... - run 33043936155 | ||||||
| success | 1 | 20 | 1024 / 1024 | 2m 56s / 5m 42s | docker run ... @sha256:953635f... | Aug 26, 05:39 |
run 32934145713executed 1024 - ccache 98 hit / 6525 miss - head 2e03c1e59 - digest sha256:953635ff1fca55... - run 32934145713 | ||||||
| success | 1 | 20 | 1024 / 1024 | 1m 49s / 3m 59s | docker run ... @sha256:5596e59... | Aug 25, 05:28 |
run 32812369288executed 1024 - ccache 98 hit / 6525 miss - head c6ee9298e - digest sha256:5596e59a453ca7... - run 32812369288 | ||||||
| success | 1 | 20 | 1023 / 1023 | 2m 46s / 5m 14s | docker run ... @sha256:9fdb290... | Aug 24, 05:29 |
run 32693051461executed 1023 - ccache 98 hit / 6525 miss - head 3dd30b2bb - digest sha256:9fdb2906da4f23... - run 32693051461 | ||||||
| success | 1 | 20 | 1023 / 1023 | 2m 58s / 5m 22s | docker run ... @sha256:9b5bba2... | Aug 23, 05:32 |
run 32619956842executed 1023 - ccache 98 hit / 6525 miss - head 728456ed2 - digest sha256:9b5bba29c8e45f... - run 32619956842 | ||||||
| success | 1 | 20 | 1023 / 1023 | 3m 02s / 5m 39s | docker run ... @sha256:e83775a... | Aug 22, 05:30 |
run 32553875945executed 1023 - ccache 98 hit / 6525 miss - head 7ad551a23 - digest sha256:e83775a3699840... - run 32553875945 | ||||||
| success | 1 | 20 | 1023 / 1023 | 1m 52s / 4m 08s | docker run ... @sha256:264edc3... | Aug 21, 05:23 |
run 32449768127executed 1023 - ccache 98 hit / 6525 miss - head a351d44d6 - digest sha256:264edc3612a3e7... - run 32449768127 | ||||||
| success | 1 | 20 | 1023 / 1023 | 2m 14s / 4m 05s | docker run ... @sha256:77e644e... | Aug 20, 05:21 |
run 32334675383executed 1023 - ccache 98 hit / 6525 miss - head 54d873552 - digest sha256:77e644e71c76e8... - run 32334675383 | ||||||
| success | 1 | 20 | 1023 / 1023 | 2m 50s / 5m 30s | docker run ... @sha256:c47e23b... | Aug 19, 05:27 |
run 32218404332executed 1023 - ccache 98 hit / 6525 miss - head 79d209c1b - digest sha256:c47e23b2d68d06... - run 32218404332 | ||||||
| success | 1 | 20 | 1020 / 1020 | 2m 56s / 5m 37s | docker run ... @sha256:c838d4f... | Aug 18, 05:25 |
run 32101622830executed 1020 - ccache 98 hit / 6524 miss - head e8b65fccf - digest sha256:c838d4fd0c504e... - run 32101622830 | ||||||
| success | 1 | 20 | 1019 / 1019 | 2m 11s / 4m 24s | docker run ... @sha256:6c3d8b8... | Aug 17, 05:18 |
run 31996612906executed 1019 - ccache 98 hit / 6524 miss - head 8805e0cdd - digest sha256:6c3d8b87e3adc8... - run 31996612906 | ||||||
| success | 1 | 20 | 1019 / 1019 | 2m 48s / 5m 22s | docker run ... @sha256:f4f5963... | Aug 16, 05:09 |
run 31927839931executed 1019 - ccache 98 hit / 6524 miss - head af57c5b19 - digest sha256:f4f5963e731978... - run 31927839931 | ||||||
| success | 1 | 20 | 1019 / 1019 | 2m 14s / 4m 34s | docker run ... @sha256:d9306ab... | Aug 15, 05:06 |
run 31865662248executed 1019 - ccache 98 hit / 6524 miss - head f673b510e - digest sha256:d9306abad285ee... - run 31865662248 | ||||||
| success | 1 | 20 | 1019 / 1019 | 3m 01s / 5m 42s | docker run ... @sha256:9a4aa3e... | Aug 14, 05:12 |
run 31771329671executed 1019 - ccache 165 hit / 6457 miss - head 4f5b138eb - digest sha256:9a4aa3eed51092... - run 31771329671 | ||||||
| success | 1 | 20 | 1019 / 1019 | 2m 54s / 5m 10s | docker run ... @sha256:7beb6bd... | Aug 13, 05:08 |
run 31668408532executed 1019 - ccache 165 hit / 6457 miss - head c658bde31 - digest sha256:7beb6bd5ca2ea1... - run 31668408532 | ||||||
| success | 1 | 20 | 1019 / 1019 | 2m 52s / 5m 08s | docker run ... @sha256:47a1535... | Aug 12, 05:08 |
run 31564548845executed 1019 - ccache 165 hit / 6454 miss - head 80a6b2830 - digest sha256:47a1535d2e24d6... - run 31564548845 | ||||||
| success | 1 | 20 | 1019 / 1019 | 2m 14s / 4m 42s | docker run ... @sha256:b70369e... | Aug 11, 04:59 |
run 31459642156executed 1019 - ccache 165 hit / 6453 miss - head 03618bea8 - digest sha256:b70369e3621eb5... - run 31459642156 | ||||||
| success | 1 | 20 | 1019 / 1019 | 2m 54s / 5m 28s | docker run ... @sha256:9035184... | Aug 10, 05:06 |
run 31356559193executed 1019 - ccache 166 hit / 6452 miss - head 7fcce9c74 - digest sha256:9035184556bf7c... - run 31356559193 | ||||||
| success | 1 | 20 | 1019 / 1019 | 2m 44s / 4m 34s | docker run ... @sha256:5e16e8c... | Aug 08, 03:38 |
run 31237241352executed 1019 - ccache 166 hit / 6452 miss - head 97f3b3e51 - digest sha256:5e16e8c7426155... - run 31237241352 | ||||||
| success | 1 | 20 | 1018 / 1018 | 2m 49s / 4m 40s | docker run ... @sha256:1b56795... | Aug 07, 03:37 |
run 31144326946executed 1018 - ccache 166 hit / 6452 miss - head a42cb07cf - digest sha256:1b56795568280d... - run 31144326946 | ||||||
| success | 1 | 20 | 1018 / 1018 | 2m 57s / 5m 30s | docker run ... @sha256:f71e7ae... | Aug 05, 21:48 |
run 31049401198executed 1018 - ccache 166 hit / 6452 miss - head e5b520a24 - digest sha256:f71e7ae6365118... - run 31049401198 | ||||||
| success | 1 | 20 | 1018 / 1018 | 2m 53s / 5m 37s | docker run ... @sha256:416fff7... | Aug 04, 21:47 |
run 30953003590executed 1018 - ccache 166 hit / 6452 miss - head a6a6e3ee2 - digest sha256:416fff77097b09... - run 30953003590 | ||||||
| success | 1 | 20 | 1018 / 1018 | 2m 46s / 5m 26s | docker run ... @sha256:5df960a... | Aug 03, 21:45 |
run 30855261501executed 1018 - ccache 166 hit / 6452 miss - head 9127b3f34 - digest sha256:5df960a06bf96a... - run 30855261501 | ||||||
| success | 1 | 20 | 1017 / 1017 | 2m 53s / 5m 20s | docker run ... @sha256:f197f5d... | Aug 02, 21:44 |
run 30768175814executed 1017 - ccache 166 hit / 6452 miss - head f74713b2d - digest sha256:f197f5d3fe6a41... - run 30768175814 | ||||||
| success | 1 | 20 | 1017 / 1017 | 2m 57s / 5m 47s | docker run ... @sha256:df3cfba... | Aug 01, 21:44 |
run 30719381825executed 1017 - ccache 166 hit / 6452 miss - head 8409dc735 - digest sha256:df3cfba0631dcf... - run 30719381825 | ||||||
| success | 1 | 20 | 1017 / 1017 | 2m 11s / 4m 38s | docker run ... @sha256:b88317c... | Jul 31, 21:42 |
run 30666971356executed 1017 - ccache 166 hit / 6452 miss - head 09be88db5 - digest sha256:b88317c8eb70af... - run 30666971356 | ||||||
| tests failed | 1 | 20 | 1015 / 1016 | 2m 11s / 4m 39s | docker run ... @sha256:9a3a28c... | Jul 30, 21:41 |
run 30583747739failed: recovery/051_effective_wal_level executed 1016 - ccache 166 hit / 6452 miss - head 5fcc9043c - digest sha256:9a3a28c678f572... - run 30583747739 | ||||||
| success | 1 | 20 | 1016 / 1016 | 2m 55s / 5m 23s | docker run ... @sha256:14bbc04... | Jul 29, 21:41 |
run 30492656809executed 1016 - ccache 166 hit / 6452 miss - head 90afcac07 - digest sha256:14bbc04901c4d4... - run 30492656809 | ||||||
| success | 1 | 20 | 1015 / 1015 | 2m 59s / 5m 24s | docker run ... @sha256:727a9d3... | Jul 28, 21:41 |
run 30400836063executed 1015 - ccache 166 hit / 6452 miss - head 346a0b742 - digest sha256:727a9d36922a7a... - run 30400836063 | ||||||
v16t50701_16posted May 27, 10:11tests failedsupersededstale 4mopg 19
base5107398e6 May 14, 08:05 - 128 days / 1140 commits behind master (from history)
applyapplied Jul 26, 07:18
pushJul 26, 23:53 -> 077b1e361branchdiff vs base
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| tests failed | 1 | 19 | 963 / 964 | 2m 52s / 5m 13s | docker run ... @sha256:d662b01... | Jul 27, 00:03 |
run 30226203594failed: test_plan_advice/001_replan_regress executed 964 - ccache 145 hit / 6474 miss - head 077b1e361 - digest sha256:d662b01021802d... - run 30226203594 | ||||||