feat: reuse partial aggregate hashes across repartition by Rachelint · Pull Request #23446 · apache/datafusion

Rachelint · 2026-07-10T12:09:31Z

Which issue does this PR close?

Closes #.

Rationale for this change

What changes are included in this PR?

Are these changes tested?

Are there any user-facing changes?

Rachelint · 2026-07-10T12:10:12Z

run benchmarks clickbench_partitioned

Rachelint · 2026-07-10T12:11:20Z

run benchmarks clickbench_partitioned

adriangbot · 2026-07-10T12:13:10Z

🤖 Benchmark running (GKE) | trigger
Instance: c4a-highmem-16 (12 vCPU / 65 GiB) | Linux bench-c4935112942-957-kv7hs 6.12.85+ #1 SMP Mon May 11 08:17:35 UTC 2026 aarch64 GNU/Linux

CPU Details (lscpu)

Architecture:                            aarch64
CPU op-mode(s):                          64-bit
Byte Order:                              Little Endian
CPU(s):                                  16
On-line CPU(s) list:                     0-15
Vendor ID:                               ARM
Model name:                              Neoverse-V2
Model:                                   1
Thread(s) per core:                      1
Core(s) per cluster:                     16
Socket(s):                               -
Cluster(s):                              1
Stepping:                                r0p1
BogoMIPS:                                2000.00
Flags:                                   fp asimd evtstrm aes pmull sha1 sha2 crc32 atomics fphp asimdhp cpuid asimdrdm jscvt fcma lrcpc dcpop sha3 sm3 sm4 asimddp sha512 sve asimdfhm dit uscat ilrcpc flagm sb paca pacg dcpodp sve2 sveaes svepmull svebitperm svesha3 svesm4 flagm2 frint svei8mm svebf16 i8mm bf16 dgh rng bti
L1d cache:                               1 MiB (16 instances)
L1i cache:                               1 MiB (16 instances)
L2 cache:                                32 MiB (16 instances)
L3 cache:                                80 MiB (1 instance)
NUMA node(s):                            1
NUMA node0 CPU(s):                       0-15
Vulnerability Gather data sampling:      Not affected
Vulnerability Indirect target selection: Not affected
Vulnerability Itlb multihit:             Not affected
Vulnerability L1tf:                      Not affected
Vulnerability Mds:                       Not affected
Vulnerability Meltdown:                  Not affected
Vulnerability Mmio stale data:           Not affected
Vulnerability Reg file data sampling:    Not affected
Vulnerability Retbleed:                  Not affected
Vulnerability Spec rstack overflow:      Not affected
Vulnerability Spec store bypass:         Mitigation; Speculative Store Bypass disabled via prctl
Vulnerability Spectre v1:                Mitigation; __user pointer sanitization
Vulnerability Spectre v2:                Mitigation; CSV2, BHB
Vulnerability Srbds:                     Not affected
Vulnerability Tsa:                       Not affected
Vulnerability Tsx async abort:           Not affected
Vulnerability Vmscape:                   Not affected

Comparing reuse-hash-through-hold-aggr (82bdb2b) to f34a676 (merge-base) diff using: clickbench_partitioned
Results will be posted here when complete

File an issue against this benchmark runner

adriangbot · 2026-07-10T12:14:15Z

🤖 Benchmark running (GKE) | trigger
Instance: c4a-highmem-16 (12 vCPU / 65 GiB) | Linux bench-c4935121013-958-wd2gp 6.12.85+ #1 SMP Mon May 11 08:17:35 UTC 2026 aarch64 GNU/Linux

CPU Details (lscpu)

Architecture:                            aarch64
CPU op-mode(s):                          64-bit
Byte Order:                              Little Endian
CPU(s):                                  16
On-line CPU(s) list:                     0-15
Vendor ID:                               ARM
Model name:                              Neoverse-V2
Model:                                   1
Thread(s) per core:                      1
Core(s) per cluster:                     16
Socket(s):                               -
Cluster(s):                              1
Stepping:                                r0p1
BogoMIPS:                                2000.00
Flags:                                   fp asimd evtstrm aes pmull sha1 sha2 crc32 atomics fphp asimdhp cpuid asimdrdm jscvt fcma lrcpc dcpop sha3 sm3 sm4 asimddp sha512 sve asimdfhm dit uscat ilrcpc flagm sb paca pacg dcpodp sve2 sveaes svepmull svebitperm svesha3 svesm4 flagm2 frint svei8mm svebf16 i8mm bf16 dgh rng bti
L1d cache:                               1 MiB (16 instances)
L1i cache:                               1 MiB (16 instances)
L2 cache:                                32 MiB (16 instances)
L3 cache:                                80 MiB (1 instance)
NUMA node(s):                            1
NUMA node0 CPU(s):                       0-15
Vulnerability Gather data sampling:      Not affected
Vulnerability Indirect target selection: Not affected
Vulnerability Itlb multihit:             Not affected
Vulnerability L1tf:                      Not affected
Vulnerability Mds:                       Not affected
Vulnerability Meltdown:                  Not affected
Vulnerability Mmio stale data:           Not affected
Vulnerability Reg file data sampling:    Not affected
Vulnerability Retbleed:                  Not affected
Vulnerability Spec rstack overflow:      Not affected
Vulnerability Spec store bypass:         Mitigation; Speculative Store Bypass disabled via prctl
Vulnerability Spectre v1:                Mitigation; __user pointer sanitization
Vulnerability Spectre v2:                Mitigation; CSV2, BHB
Vulnerability Srbds:                     Not affected
Vulnerability Tsa:                       Not affected
Vulnerability Tsx async abort:           Not affected
Vulnerability Vmscape:                   Not affected

Comparing reuse-hash-through-hold-aggr (82bdb2b) to f34a676 (merge-base) diff using: clickbench_partitioned
Results will be posted here when complete

File an issue against this benchmark runner

adriangbot · 2026-07-10T12:34:03Z

🤖 Benchmark completed (GKE) | trigger

Instance: c4a-highmem-16 (12 vCPU / 65 GiB)

CPU Details (lscpu)

Architecture:                            aarch64
CPU op-mode(s):                          64-bit
Byte Order:                              Little Endian
CPU(s):                                  16
On-line CPU(s) list:                     0-15
Vendor ID:                               ARM
Model name:                              Neoverse-V2
Model:                                   1
Thread(s) per core:                      1
Core(s) per cluster:                     16
Socket(s):                               -
Cluster(s):                              1
Stepping:                                r0p1
BogoMIPS:                                2000.00
Flags:                                   fp asimd evtstrm aes pmull sha1 sha2 crc32 atomics fphp asimdhp cpuid asimdrdm jscvt fcma lrcpc dcpop sha3 sm3 sm4 asimddp sha512 sve asimdfhm dit uscat ilrcpc flagm sb paca pacg dcpodp sve2 sveaes svepmull svebitperm svesha3 svesm4 flagm2 frint svei8mm svebf16 i8mm bf16 dgh rng bti
L1d cache:                               1 MiB (16 instances)
L1i cache:                               1 MiB (16 instances)
L2 cache:                                32 MiB (16 instances)
L3 cache:                                80 MiB (1 instance)
NUMA node(s):                            1
NUMA node0 CPU(s):                       0-15
Vulnerability Gather data sampling:      Not affected
Vulnerability Indirect target selection: Not affected
Vulnerability Itlb multihit:             Not affected
Vulnerability L1tf:                      Not affected
Vulnerability Mds:                       Not affected
Vulnerability Meltdown:                  Not affected
Vulnerability Mmio stale data:           Not affected
Vulnerability Reg file data sampling:    Not affected
Vulnerability Retbleed:                  Not affected
Vulnerability Spec rstack overflow:      Not affected
Vulnerability Spec store bypass:         Mitigation; Speculative Store Bypass disabled via prctl
Vulnerability Spectre v1:                Mitigation; __user pointer sanitization
Vulnerability Spectre v2:                Mitigation; CSV2, BHB
Vulnerability Srbds:                     Not affected
Vulnerability Tsa:                       Not affected
Vulnerability Tsx async abort:           Not affected
Vulnerability Vmscape:                   Not affected

Details

Comparing HEAD and reuse-hash-through-hold-aggr
--------------------
Benchmark clickbench_partitioned.json
--------------------
┏━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┓
┃ Query     ┃                                   HEAD ┃           reuse-hash-through-hold-aggr ┃        Change ┃
┡━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━┩
│ QQuery 0  │           1.33 / 4.27 ±5.71 / 15.68 ms │           1.51 / 4.52 ±5.86 / 16.25 ms │  1.06x slower │
│ QQuery 1  │         14.10 / 14.51 ±0.57 / 15.64 ms │         14.68 / 14.83 ±0.11 / 14.99 ms │     no change │
│ QQuery 2  │         37.08 / 37.73 ±0.54 / 38.65 ms │         38.04 / 38.63 ±0.41 / 39.32 ms │     no change │
│ QQuery 3  │         31.13 / 32.28 ±1.29 / 34.39 ms │         31.77 / 33.25 ±0.95 / 34.52 ms │     no change │
│ QQuery 4  │      227.46 / 235.56 ±8.78 / 247.71 ms │      267.18 / 269.99 ±3.17 / 275.85 ms │  1.15x slower │
│ QQuery 5  │      270.96 / 275.54 ±4.86 / 284.39 ms │      275.06 / 284.50 ±7.53 / 291.76 ms │     no change │
│ QQuery 6  │            1.27 / 1.42 ±0.23 / 1.88 ms │            1.28 / 1.43 ±0.24 / 1.91 ms │     no change │
│ QQuery 7  │         14.81 / 15.00 ±0.13 / 15.17 ms │         15.05 / 15.08 ±0.03 / 15.12 ms │     no change │
│ QQuery 8  │      323.15 / 327.08 ±2.82 / 330.37 ms │      336.23 / 339.40 ±1.61 / 340.59 ms │     no change │
│ QQuery 9  │      455.17 / 463.01 ±8.29 / 476.14 ms │      416.87 / 429.72 ±9.62 / 440.46 ms │ +1.08x faster │
│ QQuery 10 │         71.32 / 72.61 ±1.04 / 74.08 ms │         70.07 / 73.61 ±4.10 / 81.36 ms │     no change │
│ QQuery 11 │         84.67 / 85.01 ±0.20 / 85.22 ms │         81.59 / 82.32 ±0.76 / 83.73 ms │     no change │
│ QQuery 12 │      269.38 / 271.85 ±3.08 / 277.40 ms │      269.05 / 277.34 ±6.72 / 286.76 ms │     no change │
│ QQuery 13 │     368.10 / 379.56 ±10.85 / 397.61 ms │     371.39 / 392.02 ±20.27 / 426.38 ms │     no change │
│ QQuery 14 │     285.82 / 295.92 ±11.61 / 318.37 ms │      279.05 / 285.69 ±5.24 / 294.34 ms │     no change │
│ QQuery 15 │     272.73 / 314.52 ±25.47 / 352.47 ms │     318.51 / 347.36 ±24.76 / 379.93 ms │  1.10x slower │
│ QQuery 16 │      611.86 / 624.88 ±8.71 / 636.44 ms │     619.21 / 646.77 ±33.10 / 706.71 ms │     no change │
│ QQuery 17 │      620.36 / 637.45 ±9.12 / 646.90 ms │      621.42 / 626.93 ±5.74 / 637.85 ms │     no change │
│ QQuery 18 │   1295.80 / 1310.26 ±8.42 / 1318.80 ms │  1245.60 / 1264.35 ±16.37 / 1287.06 ms │     no change │
│ QQuery 19 │         28.94 / 29.39 ±0.41 / 29.89 ms │         28.97 / 29.64 ±0.74 / 30.73 ms │     no change │
│ QQuery 20 │     518.82 / 550.00 ±40.15 / 628.88 ms │     517.22 / 535.91 ±10.52 / 547.09 ms │     no change │
│ QQuery 21 │     516.29 / 537.30 ±15.89 / 555.97 ms │      517.53 / 524.66 ±6.57 / 537.01 ms │     no change │
│ QQuery 22 │   1059.35 / 1070.83 ±8.53 / 1081.43 ms │    986.43 / 999.32 ±10.55 / 1015.39 ms │ +1.07x faster │
│ QQuery 23 │  3115.86 / 3175.04 ±35.21 / 3213.68 ms │ 3071.79 / 3199.58 ±137.62 / 3393.58 ms │     no change │
│ QQuery 24 │         42.39 / 49.05 ±9.18 / 66.75 ms │        43.71 / 49.57 ±11.32 / 72.22 ms │     no change │
│ QQuery 25 │      115.74 / 119.33 ±2.87 / 123.03 ms │      119.49 / 126.46 ±6.35 / 136.24 ms │  1.06x slower │
│ QQuery 26 │         41.89 / 43.77 ±1.17 / 45.55 ms │         44.27 / 45.09 ±0.73 / 46.40 ms │     no change │
│ QQuery 27 │      668.75 / 676.91 ±7.49 / 690.79 ms │     675.27 / 689.39 ±13.34 / 710.41 ms │     no change │
│ QQuery 28 │  3050.86 / 3065.25 ±11.01 / 3084.19 ms │  3017.42 / 3060.28 ±38.20 / 3107.57 ms │     no change │
│ QQuery 29 │        43.06 / 49.97 ±13.56 / 77.09 ms │         41.58 / 44.69 ±5.97 / 56.64 ms │ +1.12x faster │
│ QQuery 30 │     304.22 / 319.23 ±15.78 / 347.03 ms │     319.65 / 336.27 ±10.64 / 348.85 ms │  1.05x slower │
│ QQuery 31 │      287.95 / 294.90 ±7.16 / 307.82 ms │     308.73 / 325.62 ±17.41 / 351.45 ms │  1.10x slower │
│ QQuery 32 │    963.54 / 998.41 ±34.38 / 1057.28 ms │  1075.73 / 1100.36 ±18.70 / 1121.98 ms │  1.10x slower │
│ QQuery 33 │  1463.89 / 1488.51 ±23.77 / 1533.33 ms │  1491.50 / 1574.26 ±98.02 / 1762.13 ms │  1.06x slower │
│ QQuery 34 │ 1465.98 / 1676.91 ±124.63 / 1786.89 ms │  1522.75 / 1569.32 ±46.39 / 1643.23 ms │ +1.07x faster │
│ QQuery 35 │     352.90 / 372.52 ±29.97 / 432.15 ms │     297.07 / 323.25 ±27.29 / 360.53 ms │ +1.15x faster │
│ QQuery 36 │         67.38 / 69.82 ±2.01 / 72.73 ms │         61.51 / 68.81 ±8.02 / 84.44 ms │     no change │
│ QQuery 37 │         36.18 / 44.77 ±6.68 / 52.47 ms │         35.64 / 36.66 ±0.90 / 37.69 ms │ +1.22x faster │
│ QQuery 38 │         42.93 / 47.71 ±3.42 / 51.31 ms │         43.21 / 48.46 ±5.89 / 58.82 ms │     no change │
│ QQuery 39 │     138.15 / 151.88 ±10.35 / 168.57 ms │      132.74 / 135.80 ±4.19 / 143.97 ms │ +1.12x faster │
│ QQuery 40 │         14.28 / 14.63 ±0.31 / 15.10 ms │         14.10 / 14.48 ±0.43 / 15.28 ms │     no change │
│ QQuery 41 │         13.92 / 18.42 ±5.14 / 26.89 ms │         13.84 / 15.84 ±3.36 / 22.53 ms │ +1.16x faster │
│ QQuery 42 │         13.35 / 16.51 ±3.44 / 22.02 ms │         13.97 / 15.52 ±2.68 / 20.87 ms │ +1.06x faster │
└───────────┴────────────────────────────────────────┴────────────────────────────────────────┴───────────────┘
┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┓
┃ Benchmark Summary                           ┃            ┃
┡━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━┩
│ Total Time (HEAD)                           │ 20279.51ms │
│ Total Time (reuse-hash-through-hold-aggr)   │ 20296.98ms │
│ Average Time (HEAD)                         │   471.62ms │
│ Average Time (reuse-hash-through-hold-aggr) │   472.02ms │
│ Queries Faster                              │          9 │
│ Queries Slower                              │          8 │
│ Queries with No Change                      │         26 │
│ Queries with Failure                        │          0 │
└─────────────────────────────────────────────┴────────────┘

Resource Usage

clickbench_partitioned — base (merge-base)

Metric	Value
Wall time	105.0s
Peak memory	12.2 GiB
Avg memory	4.5 GiB
CPU user	1040.0s
CPU sys	73.6s
Peak spill	0 B

clickbench_partitioned — branch

Metric	Value
Wall time	105.0s
Peak memory	12.4 GiB
Avg memory	4.7 GiB
CPU user	1054.6s
CPU sys	74.7s
Peak spill	0 B

File an issue against this benchmark runner

adriangbot · 2026-07-10T12:34:42Z

🤖 Benchmark completed (GKE) | trigger

Instance: c4a-highmem-16 (12 vCPU / 65 GiB)

CPU Details (lscpu)

Architecture:                            aarch64
CPU op-mode(s):                          64-bit
Byte Order:                              Little Endian
CPU(s):                                  16
On-line CPU(s) list:                     0-15
Vendor ID:                               ARM
Model name:                              Neoverse-V2
Model:                                   1
Thread(s) per core:                      1
Core(s) per cluster:                     16
Socket(s):                               -
Cluster(s):                              1
Stepping:                                r0p1
BogoMIPS:                                2000.00
Flags:                                   fp asimd evtstrm aes pmull sha1 sha2 crc32 atomics fphp asimdhp cpuid asimdrdm jscvt fcma lrcpc dcpop sha3 sm3 sm4 asimddp sha512 sve asimdfhm dit uscat ilrcpc flagm sb paca pacg dcpodp sve2 sveaes svepmull svebitperm svesha3 svesm4 flagm2 frint svei8mm svebf16 i8mm bf16 dgh rng bti
L1d cache:                               1 MiB (16 instances)
L1i cache:                               1 MiB (16 instances)
L2 cache:                                32 MiB (16 instances)
L3 cache:                                80 MiB (1 instance)
NUMA node(s):                            1
NUMA node0 CPU(s):                       0-15
Vulnerability Gather data sampling:      Not affected
Vulnerability Indirect target selection: Not affected
Vulnerability Itlb multihit:             Not affected
Vulnerability L1tf:                      Not affected
Vulnerability Mds:                       Not affected
Vulnerability Meltdown:                  Not affected
Vulnerability Mmio stale data:           Not affected
Vulnerability Reg file data sampling:    Not affected
Vulnerability Retbleed:                  Not affected
Vulnerability Spec rstack overflow:      Not affected
Vulnerability Spec store bypass:         Mitigation; Speculative Store Bypass disabled via prctl
Vulnerability Spectre v1:                Mitigation; __user pointer sanitization
Vulnerability Spectre v2:                Mitigation; CSV2, BHB
Vulnerability Srbds:                     Not affected
Vulnerability Tsa:                       Not affected
Vulnerability Tsx async abort:           Not affected
Vulnerability Vmscape:                   Not affected

Details

Comparing HEAD and reuse-hash-through-hold-aggr
--------------------
Benchmark clickbench_partitioned.json
--------------------
┏━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┓
┃ Query     ┃                                  HEAD ┃          reuse-hash-through-hold-aggr ┃        Change ┃
┡━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━┩
│ QQuery 0  │          1.55 / 4.66 ±5.84 / 16.34 ms │          1.35 / 4.37 ±5.85 / 16.07 ms │ +1.07x faster │
│ QQuery 1  │        13.42 / 13.58 ±0.10 / 13.70 ms │        13.69 / 14.04 ±0.35 / 14.61 ms │     no change │
│ QQuery 2  │        37.30 / 37.58 ±0.15 / 37.71 ms │        36.48 / 37.17 ±0.70 / 38.34 ms │     no change │
│ QQuery 3  │        32.57 / 33.16 ±0.71 / 34.52 ms │        32.32 / 33.24 ±0.60 / 34.01 ms │     no change │
│ QQuery 4  │     248.87 / 258.73 ±6.38 / 267.99 ms │    347.41 / 358.72 ±11.37 / 375.84 ms │  1.39x slower │
│ QQuery 5  │     312.69 / 325.15 ±8.23 / 334.82 ms │    295.92 / 312.59 ±13.93 / 333.67 ms │     no change │
│ QQuery 6  │           1.62 / 1.80 ±0.21 / 2.20 ms │           1.29 / 1.45 ±0.25 / 1.93 ms │ +1.24x faster │
│ QQuery 7  │        16.11 / 16.23 ±0.10 / 16.42 ms │        14.83 / 14.92 ±0.08 / 15.05 ms │ +1.09x faster │
│ QQuery 8  │     392.29 / 403.71 ±8.27 / 416.45 ms │     344.42 / 357.55 ±8.72 / 371.47 ms │ +1.13x faster │
│ QQuery 9  │    481.85 / 560.06 ±53.04 / 605.45 ms │    434.94 / 461.59 ±19.03 / 483.95 ms │ +1.21x faster │
│ QQuery 10 │        73.72 / 76.93 ±2.63 / 81.46 ms │        72.55 / 73.18 ±0.71 / 74.46 ms │     no change │
│ QQuery 11 │        84.60 / 86.14 ±1.38 / 88.17 ms │        83.94 / 86.27 ±2.29 / 89.90 ms │     no change │
│ QQuery 12 │     289.77 / 298.67 ±7.22 / 311.21 ms │     287.16 / 293.39 ±6.20 / 303.34 ms │     no change │
│ QQuery 13 │    378.75 / 400.78 ±13.90 / 420.14 ms │    401.36 / 445.08 ±26.50 / 471.09 ms │  1.11x slower │
│ QQuery 14 │     294.73 / 297.35 ±2.24 / 300.73 ms │    312.59 / 328.32 ±16.20 / 359.41 ms │  1.10x slower │
│ QQuery 15 │    290.76 / 307.76 ±13.16 / 326.22 ms │     376.43 / 390.19 ±8.24 / 398.24 ms │  1.27x slower │
│ QQuery 16 │     650.60 / 661.85 ±6.98 / 672.13 ms │    635.55 / 678.39 ±26.02 / 709.39 ms │     no change │
│ QQuery 17 │    673.03 / 702.44 ±16.93 / 724.01 ms │    640.27 / 675.20 ±21.22 / 703.24 ms │     no change │
│ QQuery 18 │ 1361.09 / 1396.23 ±26.39 / 1434.36 ms │ 1405.47 / 1442.89 ±47.72 / 1525.35 ms │     no change │
│ QQuery 19 │        29.44 / 29.79 ±0.20 / 30.01 ms │        29.10 / 31.03 ±2.48 / 35.74 ms │     no change │
│ QQuery 20 │    521.71 / 540.69 ±13.75 / 563.80 ms │     519.46 / 527.46 ±6.86 / 539.60 ms │     no change │
│ QQuery 21 │     529.43 / 539.43 ±8.47 / 552.01 ms │    527.18 / 547.58 ±13.63 / 567.81 ms │     no change │
│ QQuery 22 │ 1006.00 / 1019.95 ±11.11 / 1039.13 ms │ 1070.29 / 1085.78 ±11.80 / 1105.88 ms │  1.06x slower │
│ QQuery 23 │ 3218.47 / 3250.83 ±35.70 / 3317.11 ms │ 3225.26 / 3351.60 ±92.66 / 3484.31 ms │     no change │
│ QQuery 24 │        42.18 / 43.31 ±0.93 / 45.01 ms │        44.04 / 56.31 ±9.40 / 65.87 ms │  1.30x slower │
│ QQuery 25 │     111.78 / 118.32 ±8.79 / 135.52 ms │     115.92 / 126.14 ±7.81 / 140.10 ms │  1.07x slower │
│ QQuery 26 │        42.15 / 43.89 ±1.68 / 46.71 ms │        44.98 / 47.49 ±3.41 / 54.16 ms │  1.08x slower │
│ QQuery 27 │     672.48 / 687.14 ±9.94 / 700.83 ms │     692.08 / 698.87 ±8.20 / 712.78 ms │     no change │
│ QQuery 28 │ 3052.32 / 3154.91 ±57.33 / 3223.32 ms │ 3056.05 / 3098.91 ±36.68 / 3154.98 ms │     no change │
│ QQuery 29 │        41.71 / 42.22 ±0.38 / 42.71 ms │       42.00 / 56.56 ±17.44 / 89.80 ms │  1.34x slower │
│ QQuery 30 │    312.82 / 323.31 ±11.01 / 343.13 ms │     315.04 / 324.84 ±6.65 / 332.02 ms │     no change │
│ QQuery 31 │    299.78 / 322.40 ±17.09 / 348.50 ms │    311.66 / 334.77 ±21.97 / 367.98 ms │     no change │
│ QQuery 32 │  996.69 / 1060.11 ±42.77 / 1116.24 ms │ 1145.30 / 1176.00 ±35.10 / 1241.84 ms │  1.11x slower │
│ QQuery 33 │ 1547.45 / 1639.72 ±57.76 / 1720.67 ms │ 1521.40 / 1533.21 ±10.36 / 1551.72 ms │ +1.07x faster │
│ QQuery 34 │ 1528.00 / 1568.38 ±48.62 / 1662.00 ms │ 1643.23 / 1687.42 ±50.51 / 1781.83 ms │  1.08x slower │
│ QQuery 35 │    315.53 / 369.22 ±49.71 / 447.55 ms │    326.67 / 362.81 ±28.70 / 409.95 ms │     no change │
│ QQuery 36 │        72.22 / 78.25 ±4.58 / 85.99 ms │        67.64 / 72.25 ±6.07 / 84.11 ms │ +1.08x faster │
│ QQuery 37 │        37.38 / 40.50 ±3.24 / 45.22 ms │        37.09 / 37.34 ±0.21 / 37.69 ms │ +1.08x faster │
│ QQuery 38 │        41.91 / 44.52 ±2.48 / 48.29 ms │        40.49 / 43.99 ±3.10 / 48.51 ms │     no change │
│ QQuery 39 │    151.40 / 164.06 ±11.10 / 183.24 ms │     158.60 / 163.47 ±3.61 / 167.93 ms │     no change │
│ QQuery 40 │        15.04 / 15.83 ±0.57 / 16.55 ms │        15.53 / 16.20 ±0.72 / 17.29 ms │     no change │
│ QQuery 41 │        14.54 / 15.13 ±0.33 / 15.46 ms │        15.29 / 15.71 ±0.49 / 16.63 ms │     no change │
│ QQuery 42 │        14.51 / 20.53 ±6.90 / 29.67 ms │        14.77 / 14.98 ±0.21 / 15.35 ms │ +1.37x faster │
└───────────┴───────────────────────────────────────┴───────────────────────────────────────┴───────────────┘
┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┓
┃ Benchmark Summary                           ┃            ┃
┡━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━┩
│ Total Time (HEAD)                           │ 21015.25ms │
│ Total Time (reuse-hash-through-hold-aggr)   │ 21419.26ms │
│ Average Time (HEAD)                         │   488.73ms │
│ Average Time (reuse-hash-through-hold-aggr) │   498.12ms │
│ Queries Faster                              │          9 │
│ Queries Slower                              │         11 │
│ Queries with No Change                      │         23 │
│ Queries with Failure                        │          0 │
└─────────────────────────────────────────────┴────────────┘

Resource Usage

clickbench_partitioned — base (merge-base)

Metric	Value
Wall time	110.0s
Peak memory	12.5 GiB
Avg memory	4.4 GiB
CPU user	1076.7s
CPU sys	76.7s
Peak spill	0 B

clickbench_partitioned — branch

Metric	Value
Wall time	110.0s
Peak memory	12.5 GiB
Avg memory	4.6 GiB
CPU user	1111.7s
CPU sys	82.7s
Peak spill	0 B

File an issue against this benchmark runner

Rachelint · 2026-07-10T14:41:42Z

run benchmarks clickbench_partitioned

adriangbot · 2026-07-10T14:48:16Z

🤖 Benchmark running (GKE) | trigger
Instance: c4a-highmem-16 (12 vCPU / 65 GiB) | Linux bench-c4936468797-959-d22h8 6.12.85+ #1 SMP Mon May 11 08:17:35 UTC 2026 aarch64 GNU/Linux

CPU Details (lscpu)

Architecture:                            aarch64
CPU op-mode(s):                          64-bit
Byte Order:                              Little Endian
CPU(s):                                  16
On-line CPU(s) list:                     0-15
Vendor ID:                               ARM
Model name:                              Neoverse-V2
Model:                                   1
Thread(s) per core:                      1
Core(s) per cluster:                     16
Socket(s):                               -
Cluster(s):                              1
Stepping:                                r0p1
BogoMIPS:                                2000.00
Flags:                                   fp asimd evtstrm aes pmull sha1 sha2 crc32 atomics fphp asimdhp cpuid asimdrdm jscvt fcma lrcpc dcpop sha3 sm3 sm4 asimddp sha512 sve asimdfhm dit uscat ilrcpc flagm sb paca pacg dcpodp sve2 sveaes svepmull svebitperm svesha3 svesm4 flagm2 frint svei8mm svebf16 i8mm bf16 dgh rng bti
L1d cache:                               1 MiB (16 instances)
L1i cache:                               1 MiB (16 instances)
L2 cache:                                32 MiB (16 instances)
L3 cache:                                80 MiB (1 instance)
NUMA node(s):                            1
NUMA node0 CPU(s):                       0-15
Vulnerability Gather data sampling:      Not affected
Vulnerability Indirect target selection: Not affected
Vulnerability Itlb multihit:             Not affected
Vulnerability L1tf:                      Not affected
Vulnerability Mds:                       Not affected
Vulnerability Meltdown:                  Not affected
Vulnerability Mmio stale data:           Not affected
Vulnerability Reg file data sampling:    Not affected
Vulnerability Retbleed:                  Not affected
Vulnerability Spec rstack overflow:      Not affected
Vulnerability Spec store bypass:         Mitigation; Speculative Store Bypass disabled via prctl
Vulnerability Spectre v1:                Mitigation; __user pointer sanitization
Vulnerability Spectre v2:                Mitigation; CSV2, BHB
Vulnerability Srbds:                     Not affected
Vulnerability Tsa:                       Not affected
Vulnerability Tsx async abort:           Not affected
Vulnerability Vmscape:                   Not affected

Comparing reuse-hash-through-hold-aggr (82bdb2b) to f34a676 (merge-base) diff using: clickbench_partitioned
Results will be posted here when complete

File an issue against this benchmark runner

adriangbot · 2026-07-10T15:02:47Z

🤖 Benchmark completed (GKE) | trigger

Instance: c4a-highmem-16 (12 vCPU / 65 GiB)

CPU Details (lscpu)

Architecture:                            aarch64
CPU op-mode(s):                          64-bit
Byte Order:                              Little Endian
CPU(s):                                  16
On-line CPU(s) list:                     0-15
Vendor ID:                               ARM
Model name:                              Neoverse-V2
Model:                                   1
Thread(s) per core:                      1
Core(s) per cluster:                     16
Socket(s):                               -
Cluster(s):                              1
Stepping:                                r0p1
BogoMIPS:                                2000.00
Flags:                                   fp asimd evtstrm aes pmull sha1 sha2 crc32 atomics fphp asimdhp cpuid asimdrdm jscvt fcma lrcpc dcpop sha3 sm3 sm4 asimddp sha512 sve asimdfhm dit uscat ilrcpc flagm sb paca pacg dcpodp sve2 sveaes svepmull svebitperm svesha3 svesm4 flagm2 frint svei8mm svebf16 i8mm bf16 dgh rng bti
L1d cache:                               1 MiB (16 instances)
L1i cache:                               1 MiB (16 instances)
L2 cache:                                32 MiB (16 instances)
L3 cache:                                80 MiB (1 instance)
NUMA node(s):                            1
NUMA node0 CPU(s):                       0-15
Vulnerability Gather data sampling:      Not affected
Vulnerability Indirect target selection: Not affected
Vulnerability Itlb multihit:             Not affected
Vulnerability L1tf:                      Not affected
Vulnerability Mds:                       Not affected
Vulnerability Meltdown:                  Not affected
Vulnerability Mmio stale data:           Not affected
Vulnerability Reg file data sampling:    Not affected
Vulnerability Retbleed:                  Not affected
Vulnerability Spec rstack overflow:      Not affected
Vulnerability Spec store bypass:         Mitigation; Speculative Store Bypass disabled via prctl
Vulnerability Spectre v1:                Mitigation; __user pointer sanitization
Vulnerability Spectre v2:                Mitigation; CSV2, BHB
Vulnerability Srbds:                     Not affected
Vulnerability Tsa:                       Not affected
Vulnerability Tsx async abort:           Not affected
Vulnerability Vmscape:                   Not affected

Details

Comparing HEAD and reuse-hash-through-hold-aggr
--------------------
Benchmark clickbench_partitioned.json
--------------------
┏━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┓
┃ Query     ┃                                  HEAD ┃          reuse-hash-through-hold-aggr ┃        Change ┃
┡━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━┩
│ QQuery 0  │          1.23 / 3.94 ±5.37 / 14.68 ms │          1.21 / 3.92 ±5.35 / 14.62 ms │     no change │
│ QQuery 1  │        12.51 / 12.82 ±0.23 / 13.19 ms │        13.21 / 13.57 ±0.21 / 13.80 ms │  1.06x slower │
│ QQuery 2  │        36.83 / 37.34 ±0.57 / 38.43 ms │        36.24 / 36.60 ±0.33 / 37.00 ms │     no change │
│ QQuery 3  │        30.93 / 31.85 ±0.95 / 33.63 ms │        30.79 / 31.11 ±0.24 / 31.44 ms │     no change │
│ QQuery 4  │     221.36 / 222.84 ±2.29 / 227.37 ms │    265.32 / 278.63 ±22.41 / 323.40 ms │  1.25x slower │
│ QQuery 5  │     272.20 / 273.47 ±1.41 / 276.10 ms │     313.17 / 316.27 ±2.05 / 319.28 ms │  1.16x slower │
│ QQuery 6  │           1.27 / 1.42 ±0.23 / 1.88 ms │           1.28 / 1.53 ±0.40 / 2.33 ms │  1.08x slower │
│ QQuery 7  │        13.70 / 13.81 ±0.08 / 13.94 ms │        14.47 / 14.61 ±0.08 / 14.68 ms │  1.06x slower │
│ QQuery 8  │     317.64 / 320.36 ±2.54 / 324.98 ms │    338.99 / 375.78 ±23.15 / 398.14 ms │  1.17x slower │
│ QQuery 9  │     449.96 / 458.05 ±5.05 / 465.37 ms │     417.44 / 428.70 ±8.78 / 441.34 ms │ +1.07x faster │
│ QQuery 10 │        70.87 / 71.96 ±0.82 / 73.13 ms │        68.65 / 70.59 ±2.68 / 75.89 ms │     no change │
│ QQuery 11 │        83.44 / 84.31 ±0.68 / 85.18 ms │        79.93 / 83.68 ±6.57 / 96.79 ms │     no change │
│ QQuery 12 │     263.21 / 270.06 ±4.61 / 276.13 ms │     265.60 / 274.03 ±6.69 / 283.47 ms │     no change │
│ QQuery 13 │    353.76 / 381.69 ±21.06 / 412.91 ms │     368.70 / 375.13 ±6.01 / 385.39 ms │     no change │
│ QQuery 14 │     279.06 / 283.91 ±7.09 / 297.96 ms │     278.16 / 282.46 ±3.36 / 286.64 ms │     no change │
│ QQuery 15 │     268.19 / 273.11 ±2.55 / 275.18 ms │     309.33 / 320.41 ±8.10 / 331.09 ms │  1.17x slower │
│ QQuery 16 │     615.17 / 621.44 ±4.17 / 628.23 ms │    615.01 / 625.65 ±11.65 / 648.25 ms │     no change │
│ QQuery 17 │     611.55 / 618.98 ±5.24 / 623.59 ms │     615.67 / 626.18 ±7.04 / 635.46 ms │     no change │
│ QQuery 18 │ 1251.75 / 1277.98 ±18.33 / 1300.55 ms │ 1231.37 / 1253.87 ±13.75 / 1268.61 ms │     no change │
│ QQuery 19 │        27.65 / 29.90 ±3.94 / 37.77 ms │        27.87 / 28.30 ±0.43 / 29.07 ms │ +1.06x faster │
│ QQuery 20 │     514.96 / 521.69 ±6.09 / 531.85 ms │    516.81 / 531.73 ±18.40 / 566.39 ms │     no change │
│ QQuery 21 │    515.04 / 521.76 ±10.73 / 543.14 ms │     513.01 / 516.83 ±3.03 / 522.24 ms │     no change │
│ QQuery 22 │    983.18 / 991.08 ±6.76 / 1001.48 ms │     976.75 / 989.20 ±6.76 / 995.64 ms │     no change │
│ QQuery 23 │ 3103.28 / 3126.30 ±14.78 / 3143.25 ms │ 3022.12 / 3043.77 ±13.91 / 3063.95 ms │     no change │
│ QQuery 24 │        41.38 / 42.78 ±0.95 / 44.33 ms │        40.75 / 46.13 ±6.57 / 56.37 ms │  1.08x slower │
│ QQuery 25 │     113.11 / 114.12 ±1.02 / 116.00 ms │     111.62 / 115.91 ±4.38 / 122.70 ms │     no change │
│ QQuery 26 │        41.60 / 42.63 ±1.09 / 44.72 ms │        41.66 / 42.50 ±1.15 / 44.77 ms │     no change │
│ QQuery 27 │     668.72 / 678.85 ±9.34 / 694.75 ms │     669.36 / 680.50 ±8.06 / 692.04 ms │     no change │
│ QQuery 28 │ 2998.12 / 3016.99 ±11.30 / 3033.14 ms │  2990.85 / 2997.59 ±5.84 / 3007.88 ms │     no change │
│ QQuery 29 │       40.73 / 50.40 ±12.56 / 72.24 ms │       40.66 / 49.47 ±12.44 / 73.03 ms │     no change │
│ QQuery 30 │     302.06 / 307.28 ±3.60 / 312.87 ms │     307.44 / 311.50 ±4.07 / 318.78 ms │     no change │
│ QQuery 31 │    288.36 / 302.28 ±14.04 / 327.38 ms │    302.32 / 311.83 ±10.26 / 331.15 ms │     no change │
│ QQuery 32 │   956.87 / 982.30 ±23.49 / 1025.19 ms │ 1042.16 / 1060.99 ±12.04 / 1074.80 ms │  1.08x slower │
│ QQuery 33 │ 1454.97 / 1466.92 ±14.01 / 1493.83 ms │ 1481.37 / 1519.26 ±30.50 / 1569.91 ms │     no change │
│ QQuery 34 │ 1451.04 / 1469.50 ±14.01 / 1484.15 ms │ 1504.49 / 1529.12 ±23.25 / 1565.56 ms │     no change │
│ QQuery 35 │    268.52 / 309.93 ±44.75 / 376.33 ms │    295.44 / 332.08 ±42.77 / 405.41 ms │  1.07x slower │
│ QQuery 36 │        71.59 / 74.31 ±1.66 / 76.29 ms │        69.02 / 72.02 ±4.02 / 79.89 ms │     no change │
│ QQuery 37 │        35.54 / 40.09 ±7.40 / 54.79 ms │        35.06 / 35.76 ±0.56 / 36.40 ms │ +1.12x faster │
│ QQuery 38 │        39.98 / 41.37 ±1.34 / 43.75 ms │        43.78 / 46.70 ±2.21 / 49.51 ms │  1.13x slower │
│ QQuery 39 │     138.16 / 152.28 ±8.45 / 161.04 ms │     127.12 / 132.69 ±5.88 / 143.36 ms │ +1.15x faster │
│ QQuery 40 │        14.34 / 14.67 ±0.31 / 15.16 ms │        13.79 / 14.16 ±0.27 / 14.54 ms │     no change │
│ QQuery 41 │        13.54 / 13.94 ±0.30 / 14.31 ms │        13.43 / 14.31 ±1.29 / 16.89 ms │     no change │
│ QQuery 42 │        13.29 / 13.52 ±0.15 / 13.75 ms │        13.58 / 15.71 ±3.52 / 22.69 ms │  1.16x slower │
└───────────┴───────────────────────────────────────┴───────────────────────────────────────┴───────────────┘
┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┓
┃ Benchmark Summary                           ┃            ┃
┡━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━┩
│ Total Time (HEAD)                           │ 19584.21ms │
│ Total Time (reuse-hash-through-hold-aggr)   │ 19850.80ms │
│ Average Time (HEAD)                         │   455.45ms │
│ Average Time (reuse-hash-through-hold-aggr) │   461.65ms │
│ Queries Faster                              │          4 │
│ Queries Slower                              │         12 │
│ Queries with No Change                      │         27 │
│ Queries with Failure                        │          0 │
└─────────────────────────────────────────────┴────────────┘

Resource Usage

clickbench_partitioned — base (merge-base)

Metric	Value
Wall time	100.0s
Peak memory	12.9 GiB
Avg memory	4.7 GiB
CPU user	1012.0s
CPU sys	66.3s
Peak spill	0 B

clickbench_partitioned — branch

Metric	Value
Wall time	100.0s
Peak memory	12.6 GiB
Avg memory	4.5 GiB
CPU user	1037.3s
CPU sys	70.4s
Peak spill	0 B

File an issue against this benchmark runner

Rachelint · 2026-07-12T04:25:31Z

run benchmarks clickbench_partitioned

adriangbot · 2026-07-12T04:28:16Z

🤖 Benchmark running (GKE) | trigger
Instance: c4a-highmem-16 (12 vCPU / 65 GiB) | Linux bench-c4949927313-988-d758t 6.12.85+ #1 SMP Mon May 11 08:17:35 UTC 2026 aarch64 GNU/Linux

CPU Details (lscpu)

Architecture:                            aarch64
CPU op-mode(s):                          64-bit
Byte Order:                              Little Endian
CPU(s):                                  16
On-line CPU(s) list:                     0-15
Vendor ID:                               ARM
Model name:                              Neoverse-V2
Model:                                   1
Thread(s) per core:                      1
Core(s) per cluster:                     16
Socket(s):                               -
Cluster(s):                              1
Stepping:                                r0p1
BogoMIPS:                                2000.00
Flags:                                   fp asimd evtstrm aes pmull sha1 sha2 crc32 atomics fphp asimdhp cpuid asimdrdm jscvt fcma lrcpc dcpop sha3 sm3 sm4 asimddp sha512 sve asimdfhm dit uscat ilrcpc flagm sb paca pacg dcpodp sve2 sveaes svepmull svebitperm svesha3 svesm4 flagm2 frint svei8mm svebf16 i8mm bf16 dgh rng bti
L1d cache:                               1 MiB (16 instances)
L1i cache:                               1 MiB (16 instances)
L2 cache:                                32 MiB (16 instances)
L3 cache:                                80 MiB (1 instance)
NUMA node(s):                            1
NUMA node0 CPU(s):                       0-15
Vulnerability Gather data sampling:      Not affected
Vulnerability Indirect target selection: Not affected
Vulnerability Itlb multihit:             Not affected
Vulnerability L1tf:                      Not affected
Vulnerability Mds:                       Not affected
Vulnerability Meltdown:                  Not affected
Vulnerability Mmio stale data:           Not affected
Vulnerability Reg file data sampling:    Not affected
Vulnerability Retbleed:                  Not affected
Vulnerability Spec rstack overflow:      Not affected
Vulnerability Spec store bypass:         Mitigation; Speculative Store Bypass disabled via prctl
Vulnerability Spectre v1:                Mitigation; __user pointer sanitization
Vulnerability Spectre v2:                Mitigation; CSV2, BHB
Vulnerability Srbds:                     Not affected
Vulnerability Tsa:                       Not affected
Vulnerability Tsx async abort:           Not affected
Vulnerability Vmscape:                   Not affected

Comparing reuse-hash-through-hold-aggr (40383aa) to f34a676 (merge-base) diff using: clickbench_partitioned
Results will be posted here when complete

File an issue against this benchmark runner

adriangbot · 2026-07-12T04:47:07Z

Benchmark for this request failed.

Last 20 lines of output:

Click to expand

thread 'tokio-rt-worker' (21017) panicked at datafusion/physical-plan/src/aggregates/mod.rs:162:10:
input must include internal group hash column

thread 'tokio-rt-worker' (21017) panicked at datafusion/physical-plan/src/aggregates/mod.rs:162:10:
input must include internal group hash column

thread 'tokio-rt-worker' (21010) panicked at datafusion/physical-plan/src/aggregates/mod.rs:162:10:
input must include internal group hash column

thread 'tokio-rt-worker' (21017) panicked at datafusion/physical-plan/src/aggregates/mod.rs:162:10:
input must include internal group hash column

thread 'tokio-rt-worker' (21017) panicked at datafusion/physical-plan/src/aggregates/mod.rs:162:10:
input must include internal group hash column

thread 'tokio-rt-worker' (21010) panicked at datafusion/physical-plan/src/aggregates/mod.rs:162:10:
input must include internal group hash column

thread 'tokio-rt-worker' (21017) panicked at datafusion/physical-plan/src/aggregates/mod.rs:162:10:
input must include internal group hash column

File an issue against this benchmark runner

Rachelint · 2026-07-12T05:12:54Z

run benchmarks clickbench_partitioned

adriangbot · 2026-07-12T05:14:48Z

🤖 Benchmark running (GKE) | trigger
Instance: c4a-highmem-16 (12 vCPU / 65 GiB) | Linux bench-c4950053452-992-mqktc 6.12.85+ #1 SMP Mon May 11 08:17:35 UTC 2026 aarch64 GNU/Linux

CPU Details (lscpu)

Architecture:                            aarch64
CPU op-mode(s):                          64-bit
Byte Order:                              Little Endian
CPU(s):                                  16
On-line CPU(s) list:                     0-15
Vendor ID:                               ARM
Model name:                              Neoverse-V2
Model:                                   1
Thread(s) per core:                      1
Core(s) per cluster:                     16
Socket(s):                               -
Cluster(s):                              1
Stepping:                                r0p1
BogoMIPS:                                2000.00
Flags:                                   fp asimd evtstrm aes pmull sha1 sha2 crc32 atomics fphp asimdhp cpuid asimdrdm jscvt fcma lrcpc dcpop sha3 sm3 sm4 asimddp sha512 sve asimdfhm dit uscat ilrcpc flagm sb paca pacg dcpodp sve2 sveaes svepmull svebitperm svesha3 svesm4 flagm2 frint svei8mm svebf16 i8mm bf16 dgh rng bti
L1d cache:                               1 MiB (16 instances)
L1i cache:                               1 MiB (16 instances)
L2 cache:                                32 MiB (16 instances)
L3 cache:                                80 MiB (1 instance)
NUMA node(s):                            1
NUMA node0 CPU(s):                       0-15
Vulnerability Gather data sampling:      Not affected
Vulnerability Indirect target selection: Not affected
Vulnerability Itlb multihit:             Not affected
Vulnerability L1tf:                      Not affected
Vulnerability Mds:                       Not affected
Vulnerability Meltdown:                  Not affected
Vulnerability Mmio stale data:           Not affected
Vulnerability Reg file data sampling:    Not affected
Vulnerability Retbleed:                  Not affected
Vulnerability Spec rstack overflow:      Not affected
Vulnerability Spec store bypass:         Mitigation; Speculative Store Bypass disabled via prctl
Vulnerability Spectre v1:                Mitigation; __user pointer sanitization
Vulnerability Spectre v2:                Mitigation; CSV2, BHB
Vulnerability Srbds:                     Not affected
Vulnerability Tsa:                       Not affected
Vulnerability Tsx async abort:           Not affected
Vulnerability Vmscape:                   Not affected

Comparing reuse-hash-through-hold-aggr (0ecb6ec) to f34a676 (merge-base) diff using: clickbench_partitioned
Results will be posted here when complete

File an issue against this benchmark runner

adriangbot · 2026-07-12T05:33:21Z

🤖 Benchmark completed (GKE) | trigger

Instance: c4a-highmem-16 (12 vCPU / 65 GiB)

CPU Details (lscpu)

Architecture:                            aarch64
CPU op-mode(s):                          64-bit
Byte Order:                              Little Endian
CPU(s):                                  16
On-line CPU(s) list:                     0-15
Vendor ID:                               ARM
Model name:                              Neoverse-V2
Model:                                   1
Thread(s) per core:                      1
Core(s) per cluster:                     16
Socket(s):                               -
Cluster(s):                              1
Stepping:                                r0p1
BogoMIPS:                                2000.00
Flags:                                   fp asimd evtstrm aes pmull sha1 sha2 crc32 atomics fphp asimdhp cpuid asimdrdm jscvt fcma lrcpc dcpop sha3 sm3 sm4 asimddp sha512 sve asimdfhm dit uscat ilrcpc flagm sb paca pacg dcpodp sve2 sveaes svepmull svebitperm svesha3 svesm4 flagm2 frint svei8mm svebf16 i8mm bf16 dgh rng bti
L1d cache:                               1 MiB (16 instances)
L1i cache:                               1 MiB (16 instances)
L2 cache:                                32 MiB (16 instances)
L3 cache:                                80 MiB (1 instance)
NUMA node(s):                            1
NUMA node0 CPU(s):                       0-15
Vulnerability Gather data sampling:      Not affected
Vulnerability Indirect target selection: Not affected
Vulnerability Itlb multihit:             Not affected
Vulnerability L1tf:                      Not affected
Vulnerability Mds:                       Not affected
Vulnerability Meltdown:                  Not affected
Vulnerability Mmio stale data:           Not affected
Vulnerability Reg file data sampling:    Not affected
Vulnerability Retbleed:                  Not affected
Vulnerability Spec rstack overflow:      Not affected
Vulnerability Spec store bypass:         Mitigation; Speculative Store Bypass disabled via prctl
Vulnerability Spectre v1:                Mitigation; __user pointer sanitization
Vulnerability Spectre v2:                Mitigation; CSV2, BHB
Vulnerability Srbds:                     Not affected
Vulnerability Tsa:                       Not affected
Vulnerability Tsx async abort:           Not affected
Vulnerability Vmscape:                   Not affected

Details

Comparing HEAD and reuse-hash-through-hold-aggr
--------------------
Benchmark clickbench_partitioned.json
--------------------
┏━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┓
┃ Query     ┃                                  HEAD ┃          reuse-hash-through-hold-aggr ┃        Change ┃
┡━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━┩
│ QQuery 0  │          1.24 / 3.89 ±5.24 / 14.37 ms │          1.25 / 4.05 ±5.49 / 15.02 ms │     no change │
│ QQuery 1  │        12.79 / 13.07 ±0.17 / 13.26 ms │        12.66 / 12.96 ±0.15 / 13.08 ms │     no change │
│ QQuery 2  │        36.37 / 36.57 ±0.18 / 36.83 ms │        36.17 / 36.49 ±0.39 / 37.24 ms │     no change │
│ QQuery 3  │        30.73 / 31.49 ±0.76 / 32.49 ms │        31.02 / 31.54 ±0.47 / 32.41 ms │     no change │
│ QQuery 4  │     223.78 / 227.42 ±3.43 / 233.39 ms │     266.88 / 271.73 ±2.86 / 275.17 ms │  1.19x slower │
│ QQuery 5  │     271.20 / 274.12 ±2.06 / 276.76 ms │     265.56 / 267.18 ±1.64 / 269.97 ms │     no change │
│ QQuery 6  │           1.27 / 1.41 ±0.23 / 1.86 ms │           1.28 / 2.58 ±2.26 / 7.07 ms │  1.82x slower │
│ QQuery 7  │        14.35 / 14.43 ±0.05 / 14.49 ms │        14.05 / 14.20 ±0.10 / 14.35 ms │     no change │
│ QQuery 8  │     326.12 / 326.36 ±0.26 / 326.85 ms │     339.78 / 344.47 ±3.41 / 348.00 ms │  1.06x slower │
│ QQuery 9  │     453.73 / 456.74 ±2.26 / 458.72 ms │     421.50 / 424.90 ±3.65 / 431.68 ms │ +1.07x faster │
│ QQuery 10 │        71.19 / 75.15 ±6.14 / 87.37 ms │        70.87 / 71.52 ±0.64 / 72.74 ms │     no change │
│ QQuery 11 │        83.93 / 84.88 ±1.00 / 86.60 ms │        83.44 / 86.57 ±2.69 / 91.54 ms │     no change │
│ QQuery 12 │     266.04 / 270.65 ±4.61 / 278.62 ms │     256.86 / 262.72 ±4.43 / 268.88 ms │     no change │
│ QQuery 13 │     367.15 / 377.47 ±6.56 / 387.56 ms │     348.97 / 358.77 ±6.43 / 368.25 ms │     no change │
│ QQuery 14 │     283.05 / 287.65 ±3.90 / 294.55 ms │     273.77 / 277.24 ±4.09 / 284.79 ms │     no change │
│ QQuery 15 │     268.68 / 272.02 ±2.66 / 275.77 ms │     316.38 / 324.81 ±4.77 / 329.76 ms │  1.19x slower │
│ QQuery 16 │     618.95 / 625.92 ±5.68 / 634.79 ms │     597.77 / 605.57 ±7.95 / 619.81 ms │     no change │
│ QQuery 17 │     623.18 / 631.37 ±7.58 / 643.52 ms │    604.10 / 615.75 ±10.18 / 631.94 ms │     no change │
│ QQuery 18 │ 1274.19 / 1290.01 ±12.72 / 1309.69 ms │ 1195.09 / 1224.02 ±20.13 / 1255.59 ms │ +1.05x faster │
│ QQuery 19 │        28.23 / 31.11 ±4.98 / 41.04 ms │        27.84 / 30.74 ±4.84 / 40.37 ms │     no change │
│ QQuery 20 │    518.98 / 533.65 ±20.33 / 570.90 ms │     513.93 / 521.38 ±8.96 / 538.58 ms │     no change │
│ QQuery 21 │     510.62 / 518.16 ±4.68 / 524.74 ms │     517.26 / 524.25 ±6.39 / 534.35 ms │     no change │
│ QQuery 22 │     985.61 / 989.01 ±2.73 / 993.38 ms │     980.16 / 985.25 ±6.46 / 997.95 ms │     no change │
│ QQuery 23 │ 3060.62 / 3112.99 ±59.82 / 3222.18 ms │ 3076.06 / 3110.73 ±32.44 / 3164.08 ms │     no change │
│ QQuery 24 │        41.36 / 46.08 ±7.11 / 60.03 ms │        41.45 / 43.37 ±1.88 / 46.49 ms │ +1.06x faster │
│ QQuery 25 │     112.45 / 113.33 ±0.59 / 114.14 ms │     113.09 / 114.90 ±1.33 / 116.78 ms │     no change │
│ QQuery 26 │        41.75 / 43.37 ±1.54 / 45.96 ms │        41.49 / 45.37 ±6.30 / 57.94 ms │     no change │
│ QQuery 27 │     665.01 / 673.40 ±5.96 / 681.13 ms │     678.87 / 681.07 ±1.86 / 684.24 ms │     no change │
│ QQuery 28 │  3004.95 / 3021.46 ±8.92 / 3030.19 ms │ 3002.90 / 3017.94 ±16.87 / 3050.42 ms │     no change │
│ QQuery 29 │        41.21 / 44.19 ±4.89 / 53.89 ms │       40.94 / 52.86 ±11.33 / 71.38 ms │  1.20x slower │
│ QQuery 30 │     302.21 / 309.72 ±7.50 / 322.92 ms │     311.50 / 317.51 ±3.83 / 322.49 ms │     no change │
│ QQuery 31 │    282.12 / 294.19 ±12.39 / 316.93 ms │    300.71 / 315.08 ±18.94 / 352.38 ms │  1.07x slower │
│ QQuery 32 │    914.92 / 947.59 ±21.59 / 973.38 ms │  1018.22 / 1022.32 ±4.54 / 1030.71 ms │  1.08x slower │
│ QQuery 33 │ 1432.62 / 1464.07 ±25.37 / 1509.02 ms │  1348.85 / 1362.22 ±7.78 / 1369.97 ms │ +1.07x faster │
│ QQuery 34 │ 1478.63 / 1498.68 ±18.59 / 1527.56 ms │ 1369.84 / 1396.47 ±23.83 / 1437.35 ms │ +1.07x faster │
│ QQuery 35 │    277.87 / 302.31 ±33.03 / 366.33 ms │    306.29 / 321.74 ±13.34 / 344.16 ms │  1.06x slower │
│ QQuery 36 │        71.20 / 76.03 ±5.62 / 86.11 ms │        60.62 / 62.05 ±0.95 / 63.08 ms │ +1.23x faster │
│ QQuery 37 │        36.00 / 40.67 ±3.46 / 45.42 ms │        35.81 / 39.37 ±6.25 / 51.86 ms │     no change │
│ QQuery 38 │        40.52 / 44.56 ±2.83 / 49.07 ms │        40.35 / 44.42 ±4.43 / 52.58 ms │     no change │
│ QQuery 39 │     146.03 / 150.43 ±3.09 / 153.76 ms │     124.10 / 130.82 ±3.86 / 136.00 ms │ +1.15x faster │
│ QQuery 40 │        14.29 / 19.63 ±8.98 / 37.56 ms │        13.88 / 15.77 ±2.28 / 19.95 ms │ +1.24x faster │
│ QQuery 41 │        13.67 / 16.58 ±4.64 / 25.80 ms │        13.77 / 13.95 ±0.17 / 14.21 ms │ +1.19x faster │
│ QQuery 42 │        13.17 / 13.42 ±0.18 / 13.61 ms │        13.68 / 16.45 ±4.63 / 25.68 ms │  1.23x slower │
└───────────┴───────────────────────────────────────┴───────────────────────────────────────┴───────────────┘
┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┓
┃ Benchmark Summary                           ┃            ┃
┡━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━┩
│ Total Time (HEAD)                           │ 19605.26ms │
│ Total Time (reuse-hash-through-hold-aggr)   │ 19423.06ms │
│ Average Time (HEAD)                         │   455.94ms │
│ Average Time (reuse-hash-through-hold-aggr) │   451.70ms │
│ Queries Faster                              │          9 │
│ Queries Slower                              │          9 │
│ Queries with No Change                      │         25 │
│ Queries with Failure                        │          0 │
└─────────────────────────────────────────────┴────────────┘

Resource Usage

clickbench_partitioned — base (merge-base)

Metric	Value
Wall time	100.0s
Peak memory	11.0 GiB
Avg memory	4.3 GiB
CPU user	1013.6s
CPU sys	66.3s
Peak spill	0 B

clickbench_partitioned — branch

Metric	Value
Wall time	100.0s
Peak memory	12.3 GiB
Avg memory	4.5 GiB
CPU user	1019.6s
CPU sys	67.4s
Peak spill	0 B

File an issue against this benchmark runner

Rachelint · 2026-07-12T05:51:46Z

run benchmarks clickbench_partitioned

adriangbot · 2026-07-12T05:53:57Z

🤖 Benchmark running (GKE) | trigger
Instance: c4a-highmem-16 (12 vCPU / 65 GiB) | Linux bench-c4950141472-996-g6tvw 6.12.85+ #1 SMP Mon May 11 08:17:35 UTC 2026 aarch64 GNU/Linux

CPU Details (lscpu)

Architecture:                            aarch64
CPU op-mode(s):                          64-bit
Byte Order:                              Little Endian
CPU(s):                                  16
On-line CPU(s) list:                     0-15
Vendor ID:                               ARM
Model name:                              Neoverse-V2
Model:                                   1
Thread(s) per core:                      1
Core(s) per cluster:                     16
Socket(s):                               -
Cluster(s):                              1
Stepping:                                r0p1
BogoMIPS:                                2000.00
Flags:                                   fp asimd evtstrm aes pmull sha1 sha2 crc32 atomics fphp asimdhp cpuid asimdrdm jscvt fcma lrcpc dcpop sha3 sm3 sm4 asimddp sha512 sve asimdfhm dit uscat ilrcpc flagm sb paca pacg dcpodp sve2 sveaes svepmull svebitperm svesha3 svesm4 flagm2 frint svei8mm svebf16 i8mm bf16 dgh rng bti
L1d cache:                               1 MiB (16 instances)
L1i cache:                               1 MiB (16 instances)
L2 cache:                                32 MiB (16 instances)
L3 cache:                                80 MiB (1 instance)
NUMA node(s):                            1
NUMA node0 CPU(s):                       0-15
Vulnerability Gather data sampling:      Not affected
Vulnerability Indirect target selection: Not affected
Vulnerability Itlb multihit:             Not affected
Vulnerability L1tf:                      Not affected
Vulnerability Mds:                       Not affected
Vulnerability Meltdown:                  Not affected
Vulnerability Mmio stale data:           Not affected
Vulnerability Reg file data sampling:    Not affected
Vulnerability Retbleed:                  Not affected
Vulnerability Spec rstack overflow:      Not affected
Vulnerability Spec store bypass:         Mitigation; Speculative Store Bypass disabled via prctl
Vulnerability Spectre v1:                Mitigation; __user pointer sanitization
Vulnerability Spectre v2:                Mitigation; CSV2, BHB
Vulnerability Srbds:                     Not affected
Vulnerability Tsa:                       Not affected
Vulnerability Tsx async abort:           Not affected
Vulnerability Vmscape:                   Not affected

Comparing reuse-hash-through-hold-aggr (0ecb6ec) to f34a676 (merge-base) diff using: clickbench_partitioned
Results will be posted here when complete

File an issue against this benchmark runner

adriangbot · 2026-07-12T06:08:35Z

🤖 Benchmark completed (GKE) | trigger

Instance: c4a-highmem-16 (12 vCPU / 65 GiB)

CPU Details (lscpu)

Architecture:                            aarch64
CPU op-mode(s):                          64-bit
Byte Order:                              Little Endian
CPU(s):                                  16
On-line CPU(s) list:                     0-15
Vendor ID:                               ARM
Model name:                              Neoverse-V2
Model:                                   1
Thread(s) per core:                      1
Core(s) per cluster:                     16
Socket(s):                               -
Cluster(s):                              1
Stepping:                                r0p1
BogoMIPS:                                2000.00
Flags:                                   fp asimd evtstrm aes pmull sha1 sha2 crc32 atomics fphp asimdhp cpuid asimdrdm jscvt fcma lrcpc dcpop sha3 sm3 sm4 asimddp sha512 sve asimdfhm dit uscat ilrcpc flagm sb paca pacg dcpodp sve2 sveaes svepmull svebitperm svesha3 svesm4 flagm2 frint svei8mm svebf16 i8mm bf16 dgh rng bti
L1d cache:                               1 MiB (16 instances)
L1i cache:                               1 MiB (16 instances)
L2 cache:                                32 MiB (16 instances)
L3 cache:                                80 MiB (1 instance)
NUMA node(s):                            1
NUMA node0 CPU(s):                       0-15
Vulnerability Gather data sampling:      Not affected
Vulnerability Indirect target selection: Not affected
Vulnerability Itlb multihit:             Not affected
Vulnerability L1tf:                      Not affected
Vulnerability Mds:                       Not affected
Vulnerability Meltdown:                  Not affected
Vulnerability Mmio stale data:           Not affected
Vulnerability Reg file data sampling:    Not affected
Vulnerability Retbleed:                  Not affected
Vulnerability Spec rstack overflow:      Not affected
Vulnerability Spec store bypass:         Mitigation; Speculative Store Bypass disabled via prctl
Vulnerability Spectre v1:                Mitigation; __user pointer sanitization
Vulnerability Spectre v2:                Mitigation; CSV2, BHB
Vulnerability Srbds:                     Not affected
Vulnerability Tsa:                       Not affected
Vulnerability Tsx async abort:           Not affected
Vulnerability Vmscape:                   Not affected

Details

Comparing HEAD and reuse-hash-through-hold-aggr
--------------------
Benchmark clickbench_partitioned.json
--------------------
┏━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┓
┃ Query     ┃                                  HEAD ┃          reuse-hash-through-hold-aggr ┃        Change ┃
┡━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━┩
│ QQuery 0  │          1.26 / 4.13 ±5.59 / 15.31 ms │          1.25 / 4.18 ±5.70 / 15.58 ms │     no change │
│ QQuery 1  │        12.85 / 13.46 ±0.35 / 13.86 ms │        12.67 / 13.24 ±0.32 / 13.62 ms │     no change │
│ QQuery 2  │        36.69 / 37.47 ±0.40 / 37.84 ms │        36.67 / 36.98 ±0.32 / 37.55 ms │     no change │
│ QQuery 3  │        32.38 / 33.36 ±1.11 / 35.42 ms │        31.70 / 32.15 ±0.41 / 32.85 ms │     no change │
│ QQuery 4  │     244.61 / 247.48 ±1.71 / 249.49 ms │     294.00 / 298.49 ±3.34 / 304.06 ms │  1.21x slower │
│ QQuery 5  │     288.29 / 295.41 ±4.15 / 301.09 ms │     282.06 / 288.69 ±5.18 / 295.17 ms │     no change │
│ QQuery 6  │           1.35 / 1.51 ±0.25 / 2.01 ms │           1.29 / 1.46 ±0.24 / 1.92 ms │     no change │
│ QQuery 7  │        15.04 / 15.15 ±0.08 / 15.28 ms │        14.35 / 14.45 ±0.09 / 14.60 ms │     no change │
│ QQuery 8  │     356.48 / 361.25 ±6.02 / 373.02 ms │     368.27 / 376.17 ±5.35 / 384.32 ms │     no change │
│ QQuery 9  │    492.09 / 504.43 ±12.13 / 524.64 ms │    447.02 / 474.44 ±16.97 / 494.57 ms │ +1.06x faster │
│ QQuery 10 │        75.11 / 79.72 ±7.45 / 94.50 ms │        73.53 / 74.64 ±1.10 / 76.77 ms │ +1.07x faster │
│ QQuery 11 │        86.91 / 87.83 ±0.54 / 88.53 ms │        84.08 / 85.51 ±1.32 / 88.01 ms │     no change │
│ QQuery 12 │     286.89 / 295.14 ±7.94 / 306.75 ms │     279.08 / 286.04 ±5.65 / 294.05 ms │     no change │
│ QQuery 13 │    399.88 / 417.28 ±16.12 / 443.89 ms │     377.72 / 384.46 ±6.54 / 393.64 ms │ +1.09x faster │
│ QQuery 14 │    304.40 / 323.43 ±27.04 / 377.15 ms │     291.62 / 299.91 ±5.69 / 309.54 ms │ +1.08x faster │
│ QQuery 15 │     294.03 / 302.67 ±7.84 / 312.93 ms │     354.25 / 363.31 ±5.67 / 371.66 ms │  1.20x slower │
│ QQuery 16 │     652.28 / 665.15 ±8.03 / 676.77 ms │    645.58 / 667.29 ±14.50 / 686.62 ms │     no change │
│ QQuery 17 │     657.15 / 666.19 ±6.72 / 672.25 ms │     650.92 / 662.10 ±7.87 / 674.88 ms │     no change │
│ QQuery 18 │ 1343.61 / 1368.90 ±13.85 / 1385.06 ms │  1307.08 / 1316.81 ±7.25 / 1329.42 ms │     no change │
│ QQuery 19 │      29.24 / 47.82 ±30.80 / 108.82 ms │        28.67 / 29.57 ±0.67 / 30.58 ms │ +1.62x faster │
│ QQuery 20 │     521.79 / 530.16 ±7.12 / 539.65 ms │     522.84 / 529.67 ±5.85 / 537.71 ms │     no change │
│ QQuery 21 │     520.27 / 533.89 ±8.59 / 545.95 ms │     525.76 / 528.71 ±4.12 / 536.89 ms │     no change │
│ QQuery 22 │ 1021.36 / 1040.10 ±11.42 / 1056.09 ms │ 1018.49 / 1045.57 ±22.17 / 1078.49 ms │     no change │
│ QQuery 23 │ 3202.45 / 3232.86 ±25.09 / 3275.53 ms │ 3213.51 / 3246.44 ±20.56 / 3275.94 ms │     no change │
│ QQuery 24 │       42.37 / 50.40 ±14.99 / 80.36 ms │        42.60 / 46.60 ±6.89 / 60.37 ms │ +1.08x faster │
│ QQuery 25 │     114.90 / 117.99 ±2.97 / 122.60 ms │     114.59 / 117.41 ±2.01 / 119.98 ms │     no change │
│ QQuery 26 │        43.32 / 46.75 ±5.54 / 57.81 ms │        43.36 / 49.26 ±9.80 / 68.82 ms │  1.05x slower │
│ QQuery 27 │     687.81 / 691.49 ±4.51 / 699.37 ms │    687.43 / 697.81 ±10.84 / 714.52 ms │     no change │
│ QQuery 28 │ 3128.45 / 3146.90 ±16.02 / 3172.05 ms │ 3089.82 / 3106.62 ±18.51 / 3135.11 ms │     no change │
│ QQuery 29 │       42.13 / 53.59 ±13.96 / 75.25 ms │        41.88 / 45.49 ±3.33 / 50.99 ms │ +1.18x faster │
│ QQuery 30 │    319.51 / 329.63 ±13.60 / 356.57 ms │     335.89 / 339.40 ±4.08 / 347.38 ms │     no change │
│ QQuery 31 │     299.31 / 307.40 ±6.88 / 317.42 ms │     313.49 / 326.41 ±7.92 / 336.01 ms │  1.06x slower │
│ QQuery 32 │ 1025.25 / 1035.78 ±18.36 / 1072.44 ms │ 1099.27 / 1124.28 ±30.86 / 1183.76 ms │  1.09x slower │
│ QQuery 33 │ 1536.39 / 1584.62 ±28.71 / 1612.10 ms │ 1476.93 / 1496.37 ±30.51 / 1556.49 ms │ +1.06x faster │
│ QQuery 34 │ 1561.66 / 1606.01 ±29.57 / 1636.86 ms │ 1493.85 / 1509.93 ±16.81 / 1542.24 ms │ +1.06x faster │
│ QQuery 35 │    314.81 / 343.58 ±41.56 / 425.65 ms │    332.95 / 351.52 ±20.83 / 391.56 ms │     no change │
│ QQuery 36 │        71.45 / 75.96 ±3.45 / 81.16 ms │        61.33 / 67.81 ±4.91 / 73.45 ms │ +1.12x faster │
│ QQuery 37 │        37.87 / 42.15 ±5.82 / 53.15 ms │        35.58 / 36.64 ±0.73 / 37.49 ms │ +1.15x faster │
│ QQuery 38 │        41.05 / 43.43 ±2.68 / 47.48 ms │        42.21 / 47.68 ±3.58 / 52.44 ms │  1.10x slower │
│ QQuery 39 │     153.93 / 169.09 ±8.67 / 180.08 ms │     122.29 / 137.08 ±9.89 / 150.26 ms │ +1.23x faster │
│ QQuery 40 │        14.85 / 15.19 ±0.23 / 15.53 ms │        14.60 / 14.81 ±0.21 / 15.18 ms │     no change │
│ QQuery 41 │        14.75 / 14.88 ±0.15 / 15.13 ms │        14.44 / 14.61 ±0.17 / 14.93 ms │     no change │
│ QQuery 42 │        14.03 / 15.24 ±1.38 / 17.00 ms │        14.48 / 15.34 ±1.27 / 17.88 ms │     no change │
└───────────┴───────────────────────────────────────┴───────────────────────────────────────┴───────────────┘
┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┓
┃ Benchmark Summary                           ┃            ┃
┡━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━┩
│ Total Time (HEAD)                           │ 20794.86ms │
│ Total Time (reuse-hash-through-hold-aggr)   │ 20605.35ms │
│ Average Time (HEAD)                         │   483.60ms │
│ Average Time (reuse-hash-through-hold-aggr) │   479.19ms │
│ Queries Faster                              │         12 │
│ Queries Slower                              │          6 │
│ Queries with No Change                      │         25 │
│ Queries with Failure                        │          0 │
└─────────────────────────────────────────────┴────────────┘

Resource Usage

clickbench_partitioned — base (merge-base)

Metric	Value
Wall time	105.0s
Peak memory	11.1 GiB
Avg memory	4.7 GiB
CPU user	1068.1s
CPU sys	74.4s
Peak spill	0 B

clickbench_partitioned — branch

Metric	Value
Wall time	105.0s
Peak memory	11.8 GiB
Avg memory	4.5 GiB
CPU user	1072.2s
CPU sys	78.5s
Peak spill	0 B

File an issue against this benchmark runner

Rachelint · 2026-07-12T06:16:56Z

run benchmarks clickbench_partitioned

adriangbot · 2026-07-12T06:19:42Z

🤖 Benchmark running (GKE) | trigger
Instance: c4a-highmem-16 (12 vCPU / 65 GiB) | Linux bench-c4950203337-997-spgtx 6.12.85+ #1 SMP Mon May 11 08:17:35 UTC 2026 aarch64 GNU/Linux

CPU Details (lscpu)

Architecture:                            aarch64
CPU op-mode(s):                          64-bit
Byte Order:                              Little Endian
CPU(s):                                  16
On-line CPU(s) list:                     0-15
Vendor ID:                               ARM
Model name:                              Neoverse-V2
Model:                                   1
Thread(s) per core:                      1
Core(s) per cluster:                     16
Socket(s):                               -
Cluster(s):                              1
Stepping:                                r0p1
BogoMIPS:                                2000.00
Flags:                                   fp asimd evtstrm aes pmull sha1 sha2 crc32 atomics fphp asimdhp cpuid asimdrdm jscvt fcma lrcpc dcpop sha3 sm3 sm4 asimddp sha512 sve asimdfhm dit uscat ilrcpc flagm sb paca pacg dcpodp sve2 sveaes svepmull svebitperm svesha3 svesm4 flagm2 frint svei8mm svebf16 i8mm bf16 dgh rng bti
L1d cache:                               1 MiB (16 instances)
L1i cache:                               1 MiB (16 instances)
L2 cache:                                32 MiB (16 instances)
L3 cache:                                80 MiB (1 instance)
NUMA node(s):                            1
NUMA node0 CPU(s):                       0-15
Vulnerability Gather data sampling:      Not affected
Vulnerability Indirect target selection: Not affected
Vulnerability Itlb multihit:             Not affected
Vulnerability L1tf:                      Not affected
Vulnerability Mds:                       Not affected
Vulnerability Meltdown:                  Not affected
Vulnerability Mmio stale data:           Not affected
Vulnerability Reg file data sampling:    Not affected
Vulnerability Retbleed:                  Not affected
Vulnerability Spec rstack overflow:      Not affected
Vulnerability Spec store bypass:         Mitigation; Speculative Store Bypass disabled via prctl
Vulnerability Spectre v1:                Mitigation; __user pointer sanitization
Vulnerability Spectre v2:                Mitigation; CSV2, BHB
Vulnerability Srbds:                     Not affected
Vulnerability Tsa:                       Not affected
Vulnerability Tsx async abort:           Not affected
Vulnerability Vmscape:                   Not affected

Comparing reuse-hash-through-hold-aggr (0ecb6ec) to f34a676 (merge-base) diff using: clickbench_partitioned
Results will be posted here when complete

File an issue against this benchmark runner

adriangbot · 2026-07-12T06:33:48Z

🤖 Benchmark completed (GKE) | trigger

Instance: c4a-highmem-16 (12 vCPU / 65 GiB)

CPU Details (lscpu)

Architecture:                            aarch64
CPU op-mode(s):                          64-bit
Byte Order:                              Little Endian
CPU(s):                                  16
On-line CPU(s) list:                     0-15
Vendor ID:                               ARM
Model name:                              Neoverse-V2
Model:                                   1
Thread(s) per core:                      1
Core(s) per cluster:                     16
Socket(s):                               -
Cluster(s):                              1
Stepping:                                r0p1
BogoMIPS:                                2000.00
Flags:                                   fp asimd evtstrm aes pmull sha1 sha2 crc32 atomics fphp asimdhp cpuid asimdrdm jscvt fcma lrcpc dcpop sha3 sm3 sm4 asimddp sha512 sve asimdfhm dit uscat ilrcpc flagm sb paca pacg dcpodp sve2 sveaes svepmull svebitperm svesha3 svesm4 flagm2 frint svei8mm svebf16 i8mm bf16 dgh rng bti
L1d cache:                               1 MiB (16 instances)
L1i cache:                               1 MiB (16 instances)
L2 cache:                                32 MiB (16 instances)
L3 cache:                                80 MiB (1 instance)
NUMA node(s):                            1
NUMA node0 CPU(s):                       0-15
Vulnerability Gather data sampling:      Not affected
Vulnerability Indirect target selection: Not affected
Vulnerability Itlb multihit:             Not affected
Vulnerability L1tf:                      Not affected
Vulnerability Mds:                       Not affected
Vulnerability Meltdown:                  Not affected
Vulnerability Mmio stale data:           Not affected
Vulnerability Reg file data sampling:    Not affected
Vulnerability Retbleed:                  Not affected
Vulnerability Spec rstack overflow:      Not affected
Vulnerability Spec store bypass:         Mitigation; Speculative Store Bypass disabled via prctl
Vulnerability Spectre v1:                Mitigation; __user pointer sanitization
Vulnerability Spectre v2:                Mitigation; CSV2, BHB
Vulnerability Srbds:                     Not affected
Vulnerability Tsa:                       Not affected
Vulnerability Tsx async abort:           Not affected
Vulnerability Vmscape:                   Not affected

Details

Comparing HEAD and reuse-hash-through-hold-aggr
--------------------
Benchmark clickbench_partitioned.json
--------------------
┏━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┓
┃ Query     ┃                                  HEAD ┃          reuse-hash-through-hold-aggr ┃        Change ┃
┡━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━┩
│ QQuery 0  │          1.23 / 4.04 ±5.51 / 15.06 ms │          1.23 / 4.02 ±5.46 / 14.94 ms │     no change │
│ QQuery 1  │        12.78 / 12.98 ±0.11 / 13.09 ms │        12.51 / 12.77 ±0.15 / 12.92 ms │     no change │
│ QQuery 2  │        36.08 / 36.40 ±0.25 / 36.77 ms │        36.36 / 36.61 ±0.15 / 36.78 ms │     no change │
│ QQuery 3  │        31.04 / 31.64 ±0.73 / 32.91 ms │        30.68 / 31.14 ±0.39 / 31.69 ms │     no change │
│ QQuery 4  │     223.32 / 227.18 ±2.91 / 231.91 ms │     264.60 / 269.97 ±3.30 / 274.18 ms │  1.19x slower │
│ QQuery 5  │     272.26 / 273.33 ±0.82 / 274.66 ms │     264.31 / 266.48 ±1.52 / 267.76 ms │     no change │
│ QQuery 6  │           1.26 / 1.40 ±0.22 / 1.83 ms │           1.26 / 1.41 ±0.22 / 1.84 ms │     no change │
│ QQuery 7  │        13.72 / 13.81 ±0.06 / 13.90 ms │        13.99 / 16.92 ±5.56 / 28.04 ms │  1.23x slower │
│ QQuery 8  │     322.77 / 325.86 ±1.67 / 327.45 ms │     344.80 / 348.09 ±2.73 / 352.01 ms │  1.07x slower │
│ QQuery 9  │     446.96 / 461.78 ±8.40 / 472.74 ms │     424.18 / 435.38 ±9.22 / 448.86 ms │ +1.06x faster │
│ QQuery 10 │        70.03 / 72.12 ±2.14 / 75.95 ms │        70.83 / 73.85 ±5.43 / 84.68 ms │     no change │
│ QQuery 11 │        82.21 / 83.48 ±1.31 / 85.94 ms │        81.36 / 82.78 ±1.27 / 85.03 ms │     no change │
│ QQuery 12 │     268.11 / 271.50 ±3.40 / 277.46 ms │     258.28 / 262.17 ±3.56 / 268.38 ms │     no change │
│ QQuery 13 │     364.38 / 380.27 ±8.44 / 387.17 ms │     352.26 / 357.56 ±6.84 / 369.40 ms │ +1.06x faster │
│ QQuery 14 │     279.42 / 286.73 ±4.64 / 291.95 ms │     274.59 / 281.25 ±7.98 / 295.42 ms │     no change │
│ QQuery 15 │     275.49 / 280.07 ±5.18 / 289.89 ms │    317.77 / 328.61 ±10.48 / 347.08 ms │  1.17x slower │
│ QQuery 16 │     613.56 / 621.63 ±7.85 / 635.54 ms │    617.68 / 629.38 ±16.46 / 661.79 ms │     no change │
│ QQuery 17 │     622.48 / 626.85 ±2.52 / 629.04 ms │     615.42 / 624.38 ±7.85 / 639.01 ms │     no change │
│ QQuery 18 │ 1274.95 / 1287.37 ±12.05 / 1310.48 ms │ 1210.23 / 1230.84 ±14.73 / 1254.49 ms │     no change │
│ QQuery 19 │        27.83 / 28.35 ±0.36 / 28.94 ms │       27.77 / 38.62 ±19.50 / 77.55 ms │  1.36x slower │
│ QQuery 20 │    515.83 / 526.02 ±11.41 / 547.43 ms │    513.11 / 525.77 ±10.73 / 544.13 ms │     no change │
│ QQuery 21 │     521.59 / 522.81 ±0.98 / 524.35 ms │     517.80 / 524.52 ±7.40 / 538.90 ms │     no change │
│ QQuery 22 │     975.99 / 983.39 ±6.51 / 994.66 ms │     979.11 / 987.14 ±6.18 / 995.00 ms │     no change │
│ QQuery 23 │ 3092.13 / 3116.33 ±32.77 / 3180.78 ms │ 3059.24 / 3091.42 ±30.55 / 3142.79 ms │     no change │
│ QQuery 24 │        41.27 / 46.32 ±7.71 / 61.28 ms │       42.79 / 56.97 ±14.71 / 81.11 ms │  1.23x slower │
│ QQuery 25 │     111.81 / 114.91 ±5.01 / 124.90 ms │     114.24 / 118.16 ±5.79 / 129.63 ms │     no change │
│ QQuery 26 │        41.52 / 44.00 ±3.42 / 50.72 ms │        41.94 / 42.63 ±0.57 / 43.54 ms │     no change │
│ QQuery 27 │     663.20 / 674.19 ±8.65 / 686.62 ms │     680.42 / 692.10 ±6.77 / 699.00 ms │     no change │
│ QQuery 28 │ 2995.84 / 3032.98 ±24.25 / 3063.77 ms │ 3021.67 / 3036.37 ±13.71 / 3062.24 ms │     no change │
│ QQuery 29 │        40.81 / 41.21 ±0.32 / 41.62 ms │        40.94 / 44.24 ±5.51 / 55.24 ms │  1.07x slower │
│ QQuery 30 │    303.64 / 315.89 ±18.84 / 353.34 ms │    309.28 / 322.16 ±11.93 / 344.30 ms │     no change │
│ QQuery 31 │    280.57 / 291.30 ±10.20 / 310.02 ms │     293.67 / 303.06 ±6.58 / 311.18 ms │     no change │
│ QQuery 32 │   940.86 / 970.49 ±28.61 / 1025.26 ms │ 1039.10 / 1069.23 ±24.42 / 1111.63 ms │  1.10x slower │
│ QQuery 33 │ 1452.31 / 1480.45 ±14.97 / 1493.85 ms │ 1340.73 / 1364.97 ±20.96 / 1401.99 ms │ +1.08x faster │
│ QQuery 34 │ 1470.61 / 1498.36 ±15.24 / 1517.13 ms │ 1375.53 / 1422.73 ±71.90 / 1566.03 ms │ +1.05x faster │
│ QQuery 35 │    283.15 / 302.76 ±32.41 / 367.04 ms │    302.22 / 330.36 ±25.91 / 365.58 ms │  1.09x slower │
│ QQuery 36 │        66.80 / 73.52 ±5.15 / 78.86 ms │        58.55 / 63.49 ±6.38 / 75.90 ms │ +1.16x faster │
│ QQuery 37 │        36.85 / 38.78 ±2.30 / 43.16 ms │       35.59 / 42.40 ±10.48 / 63.06 ms │  1.09x slower │
│ QQuery 38 │        40.65 / 45.67 ±4.17 / 52.02 ms │        42.30 / 44.37 ±1.49 / 46.81 ms │     no change │
│ QQuery 39 │     146.40 / 152.46 ±8.20 / 168.28 ms │     122.30 / 129.85 ±4.69 / 135.80 ms │ +1.17x faster │
│ QQuery 40 │        14.13 / 15.54 ±1.85 / 19.07 ms │        13.79 / 16.57 ±2.91 / 20.95 ms │  1.07x slower │
│ QQuery 41 │        13.84 / 14.12 ±0.24 / 14.44 ms │        13.60 / 15.73 ±3.53 / 22.77 ms │  1.11x slower │
│ QQuery 42 │        12.83 / 14.00 ±2.03 / 18.05 ms │        13.60 / 16.75 ±5.67 / 28.08 ms │  1.20x slower │
└───────────┴───────────────────────────────────────┴───────────────────────────────────────┴───────────────┘
┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┓
┃ Benchmark Summary                           ┃            ┃
┡━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━┩
│ Total Time (HEAD)                           │ 19642.28ms │
│ Total Time (reuse-hash-through-hold-aggr)   │ 19593.21ms │
│ Average Time (HEAD)                         │   456.80ms │
│ Average Time (reuse-hash-through-hold-aggr) │   455.66ms │
│ Queries Faster                              │          6 │
│ Queries Slower                              │         13 │
│ Queries with No Change                      │         24 │
│ Queries with Failure                        │          0 │
└─────────────────────────────────────────────┴────────────┘

Resource Usage

clickbench_partitioned — base (merge-base)

Metric	Value
Wall time	100.0s
Peak memory	10.4 GiB
Avg memory	4.3 GiB
CPU user	1011.9s
CPU sys	69.4s
Peak spill	0 B

clickbench_partitioned — branch

Metric	Value
Wall time	100.0s
Peak memory	11.0 GiB
Avg memory	4.2 GiB
CPU user	1020.2s
CPU sys	71.0s
Peak spill	0 B

File an issue against this benchmark runner

Rachelint · 2026-07-12T08:29:20Z

run benchmarks clickbench_partitioned

adriangbot · 2026-07-12T08:32:05Z

🤖 Benchmark running (GKE) | trigger
Instance: c4a-highmem-16 (12 vCPU / 65 GiB) | Linux bench-c4950528394-998-5nmlx 6.12.85+ #1 SMP Mon May 11 08:17:35 UTC 2026 aarch64 GNU/Linux

CPU Details (lscpu)

Architecture:                            aarch64
CPU op-mode(s):                          64-bit
Byte Order:                              Little Endian
CPU(s):                                  16
On-line CPU(s) list:                     0-15
Vendor ID:                               ARM
Model name:                              Neoverse-V2
Model:                                   1
Thread(s) per core:                      1
Core(s) per cluster:                     16
Socket(s):                               -
Cluster(s):                              1
Stepping:                                r0p1
BogoMIPS:                                2000.00
Flags:                                   fp asimd evtstrm aes pmull sha1 sha2 crc32 atomics fphp asimdhp cpuid asimdrdm jscvt fcma lrcpc dcpop sha3 sm3 sm4 asimddp sha512 sve asimdfhm dit uscat ilrcpc flagm sb paca pacg dcpodp sve2 sveaes svepmull svebitperm svesha3 svesm4 flagm2 frint svei8mm svebf16 i8mm bf16 dgh rng bti
L1d cache:                               1 MiB (16 instances)
L1i cache:                               1 MiB (16 instances)
L2 cache:                                32 MiB (16 instances)
L3 cache:                                80 MiB (1 instance)
NUMA node(s):                            1
NUMA node0 CPU(s):                       0-15
Vulnerability Gather data sampling:      Not affected
Vulnerability Indirect target selection: Not affected
Vulnerability Itlb multihit:             Not affected
Vulnerability L1tf:                      Not affected
Vulnerability Mds:                       Not affected
Vulnerability Meltdown:                  Not affected
Vulnerability Mmio stale data:           Not affected
Vulnerability Reg file data sampling:    Not affected
Vulnerability Retbleed:                  Not affected
Vulnerability Spec rstack overflow:      Not affected
Vulnerability Spec store bypass:         Mitigation; Speculative Store Bypass disabled via prctl
Vulnerability Spectre v1:                Mitigation; __user pointer sanitization
Vulnerability Spectre v2:                Mitigation; CSV2, BHB
Vulnerability Srbds:                     Not affected
Vulnerability Tsa:                       Not affected
Vulnerability Tsx async abort:           Not affected
Vulnerability Vmscape:                   Not affected

Comparing reuse-hash-through-hold-aggr (0ecb6ec) to f34a676 (merge-base) diff using: clickbench_partitioned
Results will be posted here when complete

File an issue against this benchmark runner

adriangbot · 2026-07-12T08:46:36Z

🤖 Benchmark completed (GKE) | trigger

Instance: c4a-highmem-16 (12 vCPU / 65 GiB)

CPU Details (lscpu)

Architecture:                            aarch64
CPU op-mode(s):                          64-bit
Byte Order:                              Little Endian
CPU(s):                                  16
On-line CPU(s) list:                     0-15
Vendor ID:                               ARM
Model name:                              Neoverse-V2
Model:                                   1
Thread(s) per core:                      1
Core(s) per cluster:                     16
Socket(s):                               -
Cluster(s):                              1
Stepping:                                r0p1
BogoMIPS:                                2000.00
Flags:                                   fp asimd evtstrm aes pmull sha1 sha2 crc32 atomics fphp asimdhp cpuid asimdrdm jscvt fcma lrcpc dcpop sha3 sm3 sm4 asimddp sha512 sve asimdfhm dit uscat ilrcpc flagm sb paca pacg dcpodp sve2 sveaes svepmull svebitperm svesha3 svesm4 flagm2 frint svei8mm svebf16 i8mm bf16 dgh rng bti
L1d cache:                               1 MiB (16 instances)
L1i cache:                               1 MiB (16 instances)
L2 cache:                                32 MiB (16 instances)
L3 cache:                                80 MiB (1 instance)
NUMA node(s):                            1
NUMA node0 CPU(s):                       0-15
Vulnerability Gather data sampling:      Not affected
Vulnerability Indirect target selection: Not affected
Vulnerability Itlb multihit:             Not affected
Vulnerability L1tf:                      Not affected
Vulnerability Mds:                       Not affected
Vulnerability Meltdown:                  Not affected
Vulnerability Mmio stale data:           Not affected
Vulnerability Reg file data sampling:    Not affected
Vulnerability Retbleed:                  Not affected
Vulnerability Spec rstack overflow:      Not affected
Vulnerability Spec store bypass:         Mitigation; Speculative Store Bypass disabled via prctl
Vulnerability Spectre v1:                Mitigation; __user pointer sanitization
Vulnerability Spectre v2:                Mitigation; CSV2, BHB
Vulnerability Srbds:                     Not affected
Vulnerability Tsa:                       Not affected
Vulnerability Tsx async abort:           Not affected
Vulnerability Vmscape:                   Not affected

Details

Comparing HEAD and reuse-hash-through-hold-aggr
--------------------
Benchmark clickbench_partitioned.json
--------------------
┏━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┓
┃ Query     ┃                                  HEAD ┃          reuse-hash-through-hold-aggr ┃        Change ┃
┡━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━┩
│ QQuery 0  │          1.23 / 4.02 ±5.46 / 14.94 ms │          1.22 / 4.03 ±5.49 / 15.00 ms │     no change │
│ QQuery 1  │        12.83 / 13.27 ±0.26 / 13.61 ms │        12.52 / 12.92 ±0.23 / 13.17 ms │     no change │
│ QQuery 2  │        36.66 / 37.23 ±0.60 / 38.21 ms │        37.28 / 37.56 ±0.32 / 38.15 ms │     no change │
│ QQuery 3  │        31.11 / 31.84 ±0.85 / 33.36 ms │        31.39 / 31.66 ±0.23 / 32.05 ms │     no change │
│ QQuery 4  │     230.31 / 232.17 ±1.26 / 233.68 ms │     267.80 / 274.30 ±4.08 / 280.19 ms │  1.18x slower │
│ QQuery 5  │     276.98 / 281.24 ±4.30 / 288.21 ms │     266.94 / 271.35 ±3.39 / 277.39 ms │     no change │
│ QQuery 6  │           1.33 / 1.48 ±0.24 / 1.95 ms │           1.26 / 1.42 ±0.24 / 1.89 ms │     no change │
│ QQuery 7  │        14.70 / 14.91 ±0.14 / 15.09 ms │        13.99 / 14.14 ±0.16 / 14.44 ms │ +1.05x faster │
│ QQuery 8  │     330.75 / 333.55 ±2.74 / 337.08 ms │     346.00 / 351.03 ±2.54 / 352.65 ms │  1.05x slower │
│ QQuery 9  │     465.85 / 477.11 ±7.31 / 485.66 ms │    427.95 / 439.92 ±11.74 / 457.64 ms │ +1.08x faster │
│ QQuery 10 │        73.46 / 75.02 ±0.99 / 76.40 ms │        71.77 / 72.77 ±1.04 / 74.63 ms │     no change │
│ QQuery 11 │        86.11 / 87.88 ±0.96 / 88.90 ms │        82.05 / 82.65 ±0.63 / 83.83 ms │ +1.06x faster │
│ QQuery 12 │     276.22 / 281.58 ±4.74 / 289.21 ms │     263.02 / 267.84 ±5.80 / 278.84 ms │     no change │
│ QQuery 13 │    372.21 / 387.23 ±13.24 / 410.73 ms │     358.32 / 363.35 ±3.92 / 369.24 ms │ +1.07x faster │
│ QQuery 14 │     286.76 / 296.43 ±5.45 / 303.14 ms │     278.71 / 286.93 ±4.64 / 292.27 ms │     no change │
│ QQuery 15 │     276.39 / 278.51 ±2.14 / 281.45 ms │     328.70 / 335.35 ±6.07 / 344.61 ms │  1.20x slower │
│ QQuery 16 │    626.68 / 641.36 ±10.12 / 656.60 ms │    606.15 / 619.87 ±10.22 / 635.95 ms │     no change │
│ QQuery 17 │     633.64 / 641.13 ±6.89 / 652.18 ms │    620.11 / 632.44 ±15.44 / 662.09 ms │     no change │
│ QQuery 18 │ 1295.40 / 1313.70 ±21.04 / 1346.04 ms │ 1234.68 / 1275.06 ±32.22 / 1311.25 ms │     no change │
│ QQuery 19 │        28.22 / 31.61 ±5.74 / 43.06 ms │        28.03 / 30.91 ±4.89 / 40.67 ms │     no change │
│ QQuery 20 │    521.84 / 540.41 ±22.45 / 582.24 ms │     521.38 / 523.41 ±2.42 / 527.83 ms │     no change │
│ QQuery 21 │     517.26 / 520.40 ±3.75 / 527.17 ms │     517.19 / 521.10 ±3.06 / 526.00 ms │     no change │
│ QQuery 22 │  1000.57 / 1011.16 ±6.42 / 1017.12 ms │  992.58 / 1020.86 ±22.66 / 1050.55 ms │     no change │
│ QQuery 23 │ 3135.65 / 3155.43 ±16.93 / 3179.93 ms │ 3099.06 / 3148.24 ±33.19 / 3202.06 ms │     no change │
│ QQuery 24 │        41.78 / 46.87 ±8.45 / 63.68 ms │        41.72 / 42.91 ±1.29 / 45.30 ms │ +1.09x faster │
│ QQuery 25 │     114.04 / 118.44 ±5.15 / 125.25 ms │     112.53 / 114.09 ±1.68 / 117.25 ms │     no change │
│ QQuery 26 │        41.97 / 46.52 ±4.82 / 55.41 ms │        41.77 / 42.27 ±0.35 / 42.85 ms │ +1.10x faster │
│ QQuery 27 │     672.38 / 677.40 ±3.97 / 683.05 ms │    686.98 / 695.30 ±10.81 / 715.29 ms │     no change │
│ QQuery 28 │ 3055.15 / 3077.44 ±19.24 / 3105.64 ms │ 3022.98 / 3040.14 ±14.35 / 3065.91 ms │     no change │
│ QQuery 29 │       41.68 / 53.25 ±13.53 / 77.91 ms │        41.23 / 49.16 ±9.87 / 65.58 ms │ +1.08x faster │
│ QQuery 30 │    309.18 / 319.45 ±10.11 / 338.03 ms │     313.99 / 317.88 ±2.05 / 319.75 ms │     no change │
│ QQuery 31 │    286.25 / 304.38 ±11.54 / 317.97 ms │     300.78 / 306.36 ±3.91 / 311.26 ms │     no change │
│ QQuery 32 │  965.51 / 1035.63 ±35.49 / 1060.18 ms │ 1040.78 / 1081.38 ±58.14 / 1196.24 ms │     no change │
│ QQuery 33 │ 1475.75 / 1518.22 ±52.24 / 1618.22 ms │ 1386.54 / 1426.30 ±57.94 / 1540.80 ms │ +1.06x faster │
│ QQuery 34 │ 1487.36 / 1540.78 ±53.07 / 1640.32 ms │ 1384.71 / 1443.86 ±42.88 / 1517.76 ms │ +1.07x faster │
│ QQuery 35 │    288.02 / 330.31 ±64.19 / 457.60 ms │    310.28 / 332.85 ±32.81 / 397.27 ms │     no change │
│ QQuery 36 │        68.30 / 70.57 ±1.56 / 72.27 ms │        63.86 / 71.62 ±9.93 / 90.64 ms │     no change │
│ QQuery 37 │        36.26 / 40.17 ±7.03 / 54.22 ms │        35.56 / 37.11 ±2.35 / 41.77 ms │ +1.08x faster │
│ QQuery 38 │        40.19 / 47.15 ±5.21 / 53.47 ms │        41.88 / 42.69 ±0.48 / 43.35 ms │ +1.10x faster │
│ QQuery 39 │     132.61 / 146.31 ±8.10 / 156.34 ms │     127.56 / 133.63 ±5.39 / 142.47 ms │ +1.09x faster │
│ QQuery 40 │        15.35 / 24.98 ±9.38 / 40.70 ms │        14.26 / 15.30 ±1.90 / 19.08 ms │ +1.63x faster │
│ QQuery 41 │        14.31 / 14.92 ±0.54 / 15.73 ms │        14.01 / 14.37 ±0.34 / 14.81 ms │     no change │
│ QQuery 42 │        13.70 / 14.24 ±0.41 / 14.85 ms │        14.04 / 15.47 ±2.46 / 20.38 ms │  1.09x slower │
└───────────┴───────────────────────────────────────┴───────────────────────────────────────┴───────────────┘
┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┓
┃ Benchmark Summary                           ┃            ┃
┡━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━┩
│ Total Time (HEAD)                           │ 20115.69ms │
│ Total Time (reuse-hash-through-hold-aggr)   │ 19841.80ms │
│ Average Time (HEAD)                         │   467.81ms │
│ Average Time (reuse-hash-through-hold-aggr) │   461.44ms │
│ Queries Faster                              │         13 │
│ Queries Slower                              │          4 │
│ Queries with No Change                      │         26 │
│ Queries with Failure                        │          0 │
└─────────────────────────────────────────────┴────────────┘

Resource Usage

clickbench_partitioned — base (merge-base)

Metric	Value
Wall time	105.0s
Peak memory	10.9 GiB
Avg memory	4.5 GiB
CPU user	1025.7s
CPU sys	71.7s
Peak spill	0 B

clickbench_partitioned — branch

Metric	Value
Wall time	100.0s
Peak memory	12.6 GiB
Avg memory	4.6 GiB
CPU user	1029.4s
CPU sys	72.5s
Peak spill	0 B

File an issue against this benchmark runner

github-actions Bot added the physical-plan Changes to the physical-plan crate label Jul 10, 2026

Rachelint force-pushed the reuse-hash-through-hold-aggr branch 3 times, most recently from 5a8eb09 to 8f4f15f Compare July 12, 2026 04:06

github-actions Bot added the physical-expr Changes to the physical-expr crates label Jul 12, 2026

Rachelint force-pushed the reuse-hash-through-hold-aggr branch from 8f4f15f to 40383aa Compare July 12, 2026 04:18

Rachelint force-pushed the reuse-hash-through-hold-aggr branch from 40383aa to ca57124 Compare July 12, 2026 04:47

feat: reuse partial aggregate hashes across repartition

0ecb6ec

Rachelint force-pushed the reuse-hash-through-hold-aggr branch from ca57124 to 0ecb6ec Compare July 12, 2026 05:03

Rachelint mentioned this pull request Jul 20, 2026

Improve performance of high cardinality grouping by reusing hash values #11680

Open

Uh oh!

Conversation

Rachelint commented Jul 10, 2026

Which issue does this PR close?

Rationale for this change

What changes are included in this PR?

Are these changes tested?

Are there any user-facing changes?

Uh oh!

Rachelint commented Jul 10, 2026

Uh oh!

Rachelint commented Jul 10, 2026

Uh oh!

adriangbot commented Jul 10, 2026

Uh oh!

adriangbot commented Jul 10, 2026

Uh oh!

adriangbot commented Jul 10, 2026

Uh oh!

adriangbot commented Jul 10, 2026

Uh oh!

Rachelint commented Jul 10, 2026

Uh oh!

adriangbot commented Jul 10, 2026

Uh oh!

adriangbot commented Jul 10, 2026

Uh oh!

Rachelint commented Jul 12, 2026

Uh oh!

adriangbot commented Jul 12, 2026

Uh oh!

adriangbot commented Jul 12, 2026

Uh oh!

Rachelint commented Jul 12, 2026

Uh oh!

adriangbot commented Jul 12, 2026

Uh oh!

adriangbot commented Jul 12, 2026

Uh oh!

Rachelint commented Jul 12, 2026

Uh oh!

adriangbot commented Jul 12, 2026

Uh oh!

adriangbot commented Jul 12, 2026

Uh oh!

Rachelint commented Jul 12, 2026

Uh oh!

adriangbot commented Jul 12, 2026

Uh oh!

adriangbot commented Jul 12, 2026

Uh oh!

Rachelint commented Jul 12, 2026

Uh oh!

adriangbot commented Jul 12, 2026

Uh oh!

adriangbot commented Jul 12, 2026

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

2 participants