Improve Hash/Merge Join estimate accuracy when all predicates are Hash/Merge clauses
4 patchsets tracked - current t51892_5
v5t51892_5posted Sep 28, 10:51successappliesrecent 0dpg 20
basefded90eec 1 day ago on master
applyapplied about 23 hours ago
rebaselast tried about 23 hours ago on fded90eec
pushabout 23 hours ago -> f4ded11e8branchdiff vs base
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 20 | 1049 / 1049 | 2m 57s / 5m 45s | docker run ... :t51892 | about 23 hours ago |
run 39685032364executed 1049 - ccache 78 hit / 6544 miss - head f4ded11e8 - digest sha256:5e5f4b1715dc37... - run 39685032364 | ||||||
| success | 1 | 20 | 1049 / 1049 | 3m 03s / 5m 43s | docker run ... @sha256:a048bda... | 2 days ago |
run 39506576012executed 1049 - ccache 78 hit / 6544 miss - head cfd706615 - digest sha256:a048bda076812c... - run 39506576012 | ||||||
| success | 1 | 20 | 1049 / 1049 | 2m 58s / 5m 24s | docker run ... @sha256:db60c34... | 3 days ago |
run 39333224449executed 1049 - ccache 78 hit / 6544 miss - head abe36bad4 - digest sha256:db60c34af85e25... - run 39333224449 | ||||||
| success | 1 | 20 | 1049 / 1049 | 2m 51s / 5m 10s | docker run ... @sha256:ebba2d0... | 4 days ago |
run 39171111392executed 1049 - ccache 78 hit / 6544 miss - head 6dd53904f - digest sha256:ebba2d0c1cc502... - run 39171111392 | ||||||
| success | 1 | 20 | 1049 / 1049 | 2m 42s / 4m 50s | docker run ... @sha256:1b63ba8... | 5 days ago |
run 39043414233executed 1049 - ccache 78 hit / 6544 miss - head c0f127af5 - digest sha256:1b63ba8918aba5... - run 39043414233 | ||||||
| success | 1 | 20 | 1049 / 1049 | 3m 01s / 5m 22s | docker run ... @sha256:1fe07e2... | 6 days ago |
run 38920706882executed 1049 - ccache 78 hit / 6544 miss - head 245981474 - digest sha256:1fe07e25cd7548... - run 38920706882 | ||||||
| success | 1 | 20 | 1049 / 1049 | 1m 54s / 4m 07s | docker run ... @sha256:d0b4de4... | Oct 15, 15:09 |
run 38756572496executed 1049 - ccache 78 hit / 6544 miss - head 3038b2810 - digest sha256:d0b4de4beefb2d... - run 38756572496 | ||||||
| success | 1 | 20 | 1045 / 1045 | 2m 53s / 4m 58s | docker run ... @sha256:6329fad... | Oct 14, 15:06 |
run 38584987024executed 1045 - ccache 78 hit / 6544 miss - head 11e0907b5 - digest sha256:6329fad01fc7dd... - run 38584987024 | ||||||
| success | 1 | 20 | 1044 / 1044 | 2m 57s / 5m 46s | docker run ... @sha256:6f8db3d... | Oct 13, 14:57 |
run 38416173216executed 1044 - ccache 78 hit / 6544 miss - head 185e75685 - digest sha256:6f8db3d6889237... - run 38416173216 | ||||||
| success | 1 | 20 | 1044 / 1044 | 1m 51s / 4m 22s | docker run ... @sha256:4cb598b... | Oct 12, 14:47 |
run 38264432508executed 1044 - ccache 78 hit / 6544 miss - head 2dfa595ef - digest sha256:4cb598b08ce9c2... - run 38264432508 | ||||||
| success | 1 | 20 | 1044 / 1044 | 2m 52s / 5m 12s | - | Oct 11, 11:11 |
run 38134040540executed 1044 - ccache 78 hit / 6544 miss - head 396304f4d - run 38134040540 | ||||||
| success | 1 | 20 | 1042 / 1042 | 1m 56s / 4m 38s | docker run ... @sha256:aa3e0fd... | Oct 08, 11:08 |
run 37767132716executed 1042 - ccache 78 hit / 6544 miss - head bc92cb92f - digest sha256:aa3e0fdbfdaa41... - run 37767132716 | ||||||
| success | 1 | 20 | 1042 / 1042 | 2m 54s / 5m 39s | docker run ... @sha256:3e00e38... | Oct 07, 11:10 |
run 37611014496executed 1042 - ccache 78 hit / 6544 miss - head ee1b26b60 - digest sha256:3e00e38128a213... - run 37611014496 | ||||||
| success | 1 | 20 | 1040 / 1040 | 2m 55s / 5m 18s | docker run ... @sha256:8aee00c... | Oct 06, 11:08 |
run 37453237912executed 1040 - ccache 78 hit / 6544 miss - head fe820a407 - digest sha256:8aee00c1f2499c... - run 37453237912 | ||||||
| success | 1 | 20 | 1039 / 1039 | 1m 53s / 4m 11s | docker run ... @sha256:a432a3f... | Oct 05, 11:05 |
run 37299859194executed 1039 - ccache 78 hit / 6544 miss - head 911d103e5 - digest sha256:a432a3f91ded1b... - run 37299859194 | ||||||
| success | 1 | 20 | 1039 / 1039 | 1m 48s / 4m 17s | docker run ... @sha256:c9931aa... | Oct 04, 11:04 |
run 37197028292executed 1039 - ccache 78 hit / 6544 miss - head 3d41c4ba3 - digest sha256:c9931aaa2746f3... - run 37197028292 | ||||||
| success | 1 | 20 | 1039 / 1039 | 1m 51s / 4m 17s | docker run ... @sha256:7ab485a... | Oct 03, 11:04 |
run 37118004399executed 1039 - ccache 78 hit / 6544 miss - head 52ff3e973 - digest sha256:7ab485a766b679... - run 37118004399 | ||||||
| success | 1 | 20 | 1039 / 1039 | 2m 50s / 4m 55s | docker run ... @sha256:27d911e... | Oct 02, 11:05 |
run 36998176673executed 1039 - ccache 78 hit / 6544 miss - head 3e932caa0 - digest sha256:27d911e7fa1190... - run 36998176673 | ||||||
| success | 1 | 20 | 1039 / 1039 | 2m 10s / 4m 48s | docker run ... @sha256:bfb911e... | Oct 01, 11:04 |
run 36852098378executed 1039 - ccache 78 hit / 6544 miss - head 4cf03b641 - digest sha256:bfb911e267dfbc... - run 36852098378 | ||||||
| success | 1 | 20 | 1039 / 1039 | 2m 47s / 4m 26s | docker run ... @sha256:d9693a9... | Sep 30, 11:04 |
run 36705278012executed 1039 - ccache 78 hit / 6544 miss - head 61315bca9 - digest sha256:d9693a955868d4... - run 36705278012 | ||||||
| success | 1 | 20 | 1039 / 1039 | 2m 35s / 4m 46s | docker run ... @sha256:08485e8... | Sep 29, 11:03 |
run 36558341858executed 1039 - ccache 78 hit / 6544 miss - head d2eafefc1 - digest sha256:08485e8dfd14a8... - run 36558341858 | ||||||
| success | 1 | 20 | 1039 / 1039 | 2m 53s / 5m 36s | docker run ... @sha256:cdc7321... | Sep 28, 11:03 |
run 36412300019executed 1039 - ccache 78 hit / 6544 miss - head 2ac920377 - digest sha256:cdc7321033e926... - run 36412300019 | ||||||
v3t51892_3posted Sep 09, 14:22successsupersededrecent 24dpg 20
base5e5929040 Sep 27, 21:55 on master
applyapplied Sep 28, 02:24
rebaselast tried Sep 28, 02:24 on 5e5929040
pushSep 28, 02:24 -> a898a7c13branchdiff vs base
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 20 | 1039 / 1039 | 2m 10s / 4m 46s | docker run ... @sha256:73c9f91... | Sep 28, 02:34 |
run 36369726044executed 1039 - ccache 78 hit / 6544 miss - head a898a7c13 - digest sha256:73c9f91793e243... - run 36369726044 | ||||||
| success | 1 | 20 | 1039 / 1039 | 2m 56s / 5m 29s | docker run ... @sha256:c62f694... | Sep 26, 21:51 |
run 36273714829executed 1039 - ccache 78 hit / 6544 miss - head dfaa1a302 - digest sha256:c62f69473f53c0... - run 36273714829 | ||||||
| success | 1 | 20 | 1039 / 1039 | 2m 53s / 5m 23s | docker run ... @sha256:1e2b73c... | Sep 25, 21:45 |
run 36192285428executed 1039 - ccache 78 hit / 6544 miss - head 66bb4b26a - digest sha256:1e2b73c2a745fe... - run 36192285428 | ||||||
| success | 1 | 20 | 1038 / 1038 | 2m 54s / 5m 36s | docker run ... @sha256:b48a3c6... | Sep 24, 21:44 |
run 36062188341executed 1038 - ccache 78 hit / 6544 miss - head e6766ec35 - digest sha256:b48a3c61367947... - run 36062188341 | ||||||
| success | 1 | 20 | 1036 / 1036 | 2m 20s / 4m 30s | docker run ... @sha256:467e682... | Sep 23, 21:41 |
run 35923090441executed 1036 - ccache 98 hit / 6524 miss - head 7ff195bc9 - digest sha256:467e6827e2ea06... - run 35923090441 | ||||||
| success | 1 | 20 | 1036 / 1036 | 2m 54s / 5m 13s | docker run ... @sha256:67d18b2... | Sep 22, 21:43 |
run 35787128052executed 1036 - ccache 98 hit / 6524 miss - head 0c8ab2a41 - digest sha256:67d18b2bfbc07f... - run 35787128052 | ||||||
| success | 1 | 20 | 1036 / 1036 | 2m 44s / 4m 42s | docker run ... @sha256:cc095e0... | Sep 21, 21:26 |
run 35656181009executed 1036 - ccache 98 hit / 6524 miss - head 82150007e - digest sha256:cc095e0e3f61be... - run 35656181009 | ||||||
| success | 1 | 20 | 1036 / 1036 | 2m 09s / 4m 46s | docker run ... @sha256:af7eb05... | Sep 20, 15:53 |
run 35520501778executed 1036 - ccache 98 hit / 6524 miss - head 9af1a2f76 - digest sha256:af7eb05bc0b379... - run 35520501778 | ||||||
| success | 1 | 20 | 1036 / 1036 | 2m 24s / 4m 26s | docker run ... @sha256:7b52672... | Sep 19, 15:51 |
run 35452614680executed 1036 - ccache 98 hit / 6524 miss - head d6ec1d2d4 - digest sha256:7b5267285f026f... - run 35452614680 | ||||||
| success | 1 | 20 | 1036 / 1036 | 2m 12s / 4m 53s | docker run ... @sha256:963fd06... | Sep 18, 15:50 |
run 35363850738executed 1036 - ccache 98 hit / 6524 miss - head 7ee92f3e9 - digest sha256:963fd0654ac60b... - run 35363850738 | ||||||
| success | 1 | 20 | 1036 / 1036 | 2m 53s / 5m 21s | docker run ... @sha256:f6cb0d3... | Sep 17, 15:49 |
run 35241391270executed 1036 - ccache 98 hit / 6524 miss - head aa864d45b - digest sha256:f6cb0d32e5e8e3... - run 35241391270 | ||||||
| success | 1 | 20 | 1036 / 1036 | 1m 54s / 4m 20s | docker run ... @sha256:52a6330... | Sep 16, 15:37 |
run 35115407713executed 1036 - ccache 98 hit / 6524 miss - head 94b6d1a1d - digest sha256:52a633005edbe7... - run 35115407713 | ||||||
| success | 1 | 20 | 1036 / 1036 | 2m 51s / 5m 20s | docker run ... @sha256:fcf65c6... | Sep 15, 15:37 |
run 34988455243executed 1036 - ccache 98 hit / 6524 miss - head f3dd6a337 - digest sha256:fcf65c69d9e15e... - run 34988455243 | ||||||
| success | 1 | 20 | 1036 / 1036 | 2m 47s / 4m 52s | docker run ... @sha256:5139775... | Sep 14, 15:36 |
run 34862092029executed 1036 - ccache 98 hit / 6523 miss - head 7c11200bd - digest sha256:5139775af6b688... - run 34862092029 | ||||||
| success | 1 | 20 | 1023 / 1023 | 3m 03s / 5m 39s | docker run ... @sha256:f2cde4e... | Sep 13, 14:56 |
run 34763555755executed 1023 - ccache 98 hit / 6523 miss - head 81463dcd4 - digest sha256:f2cde4ed840ba4... - run 34763555755 | ||||||
| success | 1 | 20 | 1023 / 1023 | 2m 52s / 5m 04s | docker run ... @sha256:5ff2c6a... | Sep 12, 14:36 |
run 34699301621executed 1023 - ccache 98 hit / 6523 miss - head f98338771 - digest sha256:5ff2c6a1d45cff... - run 34699301621 | ||||||
| success | 1 | 20 | 1022 / 1022 | 2m 09s / 4m 46s | docker run ... @sha256:038b3a6... | Sep 11, 14:35 |
run 34610081516executed 1022 - ccache 98 hit / 6523 miss - head 46de5ef34 - digest sha256:038b3a6b0dfb32... - run 34610081516 | ||||||
| success | 1 | 20 | 1022 / 1022 | 2m 55s / 5m 26s | docker run ... @sha256:a2da554... | Sep 10, 14:35 |
run 34488875843executed 1022 - ccache 98 hit / 6523 miss - head 24873db82 - digest sha256:a2da5543d53b41... - run 34488875843 | ||||||
| success | 1 | 20 | 1020 / 1020 | 2m 53s / 5m 33s | docker run ... @sha256:6ac1136... | Sep 09, 14:35 |
run 34363320333executed 1020 - ccache 98 hit / 6523 miss - head a4dbebb72 - digest sha256:6ac1136e236edb... - run 34363320333 | ||||||
v2t51892_2posted Sep 07, 17:39successsupersededstale 44dpg 20
basedc33cca18 Sep 08, 14:03 on master
applyapplied Sep 08, 17:41
rebaselast tried Sep 08, 17:41 on dc33cca18
pushSep 08, 17:42 -> e5a05cd61branchdiff vs base
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 20 | 1020 / 1020 | 2m 52s / 5m 20s | docker run ... @sha256:ed322a0... | Sep 08, 17:52 |
run 34258678267executed 1020 - ccache 98 hit / 6523 miss - head e5a05cd61 - digest sha256:ed322a059526f2... - run 34258678267 | ||||||
| success | 1 | 20 | 1024 / 1024 | 2m 53s / 5m 29s | docker run ... @sha256:c886e0f... | Sep 07, 17:51 |
run 34148610337executed 1024 - ccache 98 hit / 6527 miss - head bab8dd153 - digest sha256:c886e0fc88f16f... - run 34148610337 | ||||||
v1t51892_1posted Jul 10, 2025successsupersededancient 1ypg 19
base55a780e94 Jul 08, 2025 - 471 days / 4043 commits behind master (from history)
applyapplied Jul 26, 07:20
pushJul 27, 08:16 -> 783d1c63cbranchdiff vs base
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 19 | 900 / 900 | 2m 30s / 3m 49s | docker run ... @sha256:989af19... | Jul 27, 08:31 |
run 30249250138executed 900 - ccache 96 hit / 6452 miss - head 783d1c63c - digest sha256:989af19db3955d... - run 30249250138 | ||||||