You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@datafusion.apache.org by "kosiew (via GitHub)" <gi...@apache.org> on 2026/08/10 09:41:17 UTC

[PR] DRAFT investigate benchmark 21566 [datafusion]

kosiew opened a new pull request, #24214:
URL: https://github.com/apache/datafusion/pull/24214

   ## Investigate benchmark difference between
   v1 - https://github.com/apache/datafusion/pull/21566#issuecomment-5018685664 - benchmark showed improvement
   v2 - https://github.com/apache/datafusion/pull/21566#issuecomment-5214735328 - benchmark largely unchanged
   
   comparing v1 β†’ v2, the big story is **substantially better memory usage**, while the branch’s previous runtime advantage mostly disappears.
   
   | Metric      |  v1 Base | v1 Branch | v2 Base | v2 Branch | v2 Branch vs Base |
   | ----------- | -------: | --------: | ------: | --------: | ----------------: |
   | Wall time   |    90.0s |     85.0s |   85.0s |     85.0s |            **0%** |
   | Peak memory | 11.5 GiB |  11.9 GiB | 9.6 GiB |  10.4 GiB |      **+8.3% πŸ”΄** |
   | Avg memory  |  4.8 GiB |   4.6 GiB | 4.3 GiB |   4.6 GiB |      **+7.0% πŸ”΄** |
   | CPU user    |   902.2s |    853.8s |  848.2s |    846.0s |         **-0.3%** |
   | CPU sys     |    63.3s |     60.2s |   58.8s |     58.9s |               ~0% |
   | Peak spill  |      0 B |       0 B |     0 B |       0 B |                 β€” |
   
   The interesting **v1 β†’ v2 branch changes** are: wall time stays **85s**, peak memory drops **11.9 β†’ 10.4 GiB (-12.6%)**, CPU user drops **853.8 β†’ 846.0s (-0.9%)**, and CPU sys drops **60.2 β†’ 58.9s (-2.2%)**. Average memory is unchanged at **4.6 GiB**.
   
   So overall, **v2 is more resource-efficient than v1, especially on peak memory**. However, relative to its own v2 base, the branch now has essentially **no runtime/CPU advantage and consumes more memory** (+0.8 GiB peak, +0.3 GiB average).
   
   One caveat: the **v2 base itself improved quite a lot versus v1 base**, so the loss of the branch's relative advantage isn't because the branch got slowerβ€”the baseline caught up.
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [PR] DRAFT investigate benchmark 21566 [datafusion]

Posted by "kosiew (via GitHub)" <gi...@apache.org>.
kosiew commented on PR #24214:
URL: https://github.com/apache/datafusion/pull/24214#issuecomment-5263718481

   @kumarUjjawal 
   Thanks for the suggestion.
   
   I am trying to confirm 
   v1 Base (`main` earlier commit)
   vs 
   v2 Base (`main` later commit).
   
   Context:
   [v1 branch (earlier)](https://github.com/apache/datafusion/pull/21566#issuecomment-5018685664) - changes showed benchmark improvement
   [v2 Branch](https://github.com/apache/datafusion/pull/21566#issuecomment-5214735328) - changes did not show expected improvement
   
   My hypothesis - the benchmark difference is due to `main` changes, observed from the v1, v2 Base memory and timings.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [PR] DRAFT investigate benchmark 21566 [datafusion]

Posted by "kosiew (via GitHub)" <gi...@apache.org>.
kosiew closed pull request #24214: DRAFT investigate benchmark 21566
URL: https://github.com/apache/datafusion/pull/24214


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [PR] DRAFT investigate benchmark 21566 [datafusion]

Posted by "adriangbot (via GitHub)" <gi...@apache.org>.
adriangbot commented on PR #24214:
URL: https://github.com/apache/datafusion/pull/24214#issuecomment-5264579291

   Benchmark for [this request](https://github.com/apache/datafusion/pull/24214#issuecomment-5264552913) failed.
   
   <details><summary>Run configuration</summary>
   
   ```yaml
   run benchmark clickbench_partitioned
   ```
   
   </details>
   
   Last 20 lines of output:
   <details><summary>Click to expand</summary>
   
   ```
    * [new tag]             48.0.0-rc1           -> 48.0.0-rc1
    * [new tag]             48.0.0-rc2           -> 48.0.0-rc2
    * [new tag]             5.0.0                -> 5.0.0
    * [new tag]             5.0.0-rc1            -> 5.0.0-rc1
    * [new tag]             5.0.0-rc3            -> 5.0.0-rc3
    * [new tag]             6.0.0                -> 6.0.0
    * [new tag]             6.0.0-rc0            -> 6.0.0-rc0
    * [new tag]             7.0.0                -> 7.0.0
    * [new tag]             7.0.0-rc2            -> 7.0.0-rc2
    * [new tag]             8.0.0                -> 8.0.0
    * [new tag]             8.0.0-rc1            -> 8.0.0-rc1
    * [new tag]             8.0.0-rc2            -> 8.0.0-rc2
    * [new tag]             9.0.0                -> 9.0.0
    * [new tag]             9.0.0-rc1            -> 9.0.0-rc1
    * [new tag]             ballista-0.5.0       -> ballista-0.5.0
    * [new tag]             ballista-0.6.0       -> ballista-0.6.0
    * [new tag]             ballista-0.7.0       -> ballista-0.7.0
    * [new tag]             python-0.3.0         -> python-0.3.0
    * [new tag]             python-0.4.0         -> python-0.4.0
   Switched to branch 'benchmark-21566'
   ```
   
   </details>
   
   ---
   [File an issue](https://github.com/adriangb/datafusion-benchmarking/issues) against this benchmark runner


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [PR] DRAFT investigate benchmark 21566 [datafusion]

Posted by "kosiew (via GitHub)" <gi...@apache.org>.
kosiew commented on PR #24214:
URL: https://github.com/apache/datafusion/pull/24214#issuecomment-5264552913

   run benchmark clickbench_pushdown clickbench_partitioned


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [PR] DRAFT investigate benchmark 21566 [datafusion]

Posted by "adriangbot (via GitHub)" <gi...@apache.org>.
adriangbot commented on PR #24214:
URL: https://github.com/apache/datafusion/pull/24214#issuecomment-5275131065

   πŸ€– Benchmark completed (GKE) | [trigger](https://github.com/apache/datafusion/pull/24214#issuecomment-5274969444)
   
   **Instance:** `c4a-highmem-16` (12 vCPU / 65 GiB)
   
   Comparing benchmark-21566 (0532fff11a2b2bf9aeda454f0f888232fd957f32) to c08832d (merge-base) [diff](https://github.com/apache/datafusion/compare/c08832d481cea2dcea98e43393e3dd640d421064..0532fff11a2b2bf9aeda454f0f888232fd957f32)
   
   <details><summary>Run configuration</summary>
   
   ```yaml
   run benchmark clickbench_partitioned
   ```
   
   </details>
   
   <details><summary>CPU Details (lscpu)</summary>
   
   ```
   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>
   
   <details><summary>Details</summary>
   <p>
   
   ```
   Comparing HEAD and benchmark-21566
   --------------------
   Benchmark clickbench_partitioned.json
   --------------------
   ┏━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┓
   ┃ Query     ┃       HEAD ┃ benchmark-21566 ┃        Change ┃
   ┑━━━━━━━━━━━╇━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━┩
   β”‚ QQuery 0  β”‚    1.26 ms β”‚         1.24 ms β”‚     no change β”‚
   β”‚ QQuery 1  β”‚   11.94 ms β”‚        12.52 ms β”‚     no change β”‚
   β”‚ QQuery 2  β”‚   36.30 ms β”‚        35.86 ms β”‚     no change β”‚
   β”‚ QQuery 3  β”‚   30.49 ms β”‚        31.17 ms β”‚     no change β”‚
   β”‚ QQuery 4  β”‚  222.18 ms β”‚       231.62 ms β”‚     no change β”‚
   β”‚ QQuery 5  β”‚  275.59 ms β”‚       273.65 ms β”‚     no change β”‚
   β”‚ QQuery 6  β”‚    1.27 ms β”‚         1.25 ms β”‚     no change β”‚
   β”‚ QQuery 7  β”‚   13.64 ms β”‚        13.66 ms β”‚     no change β”‚
   β”‚ QQuery 8  β”‚  331.72 ms β”‚       333.32 ms β”‚     no change β”‚
   β”‚ QQuery 9  β”‚  459.91 ms β”‚       473.87 ms β”‚     no change β”‚
   β”‚ QQuery 10 β”‚   69.87 ms β”‚        70.02 ms β”‚     no change β”‚
   β”‚ QQuery 11 β”‚   81.83 ms β”‚        80.43 ms β”‚     no change β”‚
   β”‚ QQuery 12 β”‚  272.54 ms β”‚       275.51 ms β”‚     no change β”‚
   β”‚ QQuery 13 β”‚  367.81 ms β”‚       382.42 ms β”‚     no change β”‚
   β”‚ QQuery 14 β”‚  285.80 ms β”‚       287.95 ms β”‚     no change β”‚
   β”‚ QQuery 15 β”‚  278.45 ms β”‚       281.56 ms β”‚     no change β”‚
   β”‚ QQuery 16 β”‚  619.98 ms β”‚       621.95 ms β”‚     no change β”‚
   β”‚ QQuery 17 β”‚  621.41 ms β”‚       624.44 ms β”‚     no change β”‚
   β”‚ QQuery 18 β”‚ 1278.19 ms β”‚      1284.78 ms β”‚     no change β”‚
   β”‚ QQuery 19 β”‚   27.38 ms β”‚        28.48 ms β”‚     no change β”‚
   β”‚ QQuery 20 β”‚  517.26 ms β”‚       515.04 ms β”‚     no change β”‚
   β”‚ QQuery 21 β”‚  511.88 ms β”‚       515.63 ms β”‚     no change β”‚
   β”‚ QQuery 22 β”‚  984.51 ms β”‚       989.72 ms β”‚     no change β”‚
   β”‚ QQuery 23 β”‚ 3072.47 ms β”‚      3072.48 ms β”‚     no change β”‚
   β”‚ QQuery 24 β”‚   41.92 ms β”‚        41.52 ms β”‚     no change β”‚
   β”‚ QQuery 25 β”‚  110.90 ms β”‚       110.65 ms β”‚     no change β”‚
   β”‚ QQuery 26 β”‚   41.68 ms β”‚        41.69 ms β”‚     no change β”‚
   β”‚ QQuery 27 β”‚  512.34 ms β”‚       511.93 ms β”‚     no change β”‚
   β”‚ QQuery 28 β”‚ 2909.19 ms β”‚      2915.78 ms β”‚     no change β”‚
   β”‚ QQuery 29 β”‚   41.64 ms β”‚        41.25 ms β”‚     no change β”‚
   β”‚ QQuery 30 β”‚  308.93 ms β”‚       308.19 ms β”‚     no change β”‚
   β”‚ QQuery 31 β”‚  286.74 ms β”‚       289.02 ms β”‚     no change β”‚
   β”‚ QQuery 32 β”‚  941.17 ms β”‚       954.63 ms β”‚     no change β”‚
   β”‚ QQuery 33 β”‚ 1489.64 ms β”‚      1491.13 ms β”‚     no change β”‚
   β”‚ QQuery 34 β”‚ 1539.63 ms β”‚      1500.51 ms β”‚     no change β”‚
   β”‚ QQuery 35 β”‚  292.34 ms β”‚       289.95 ms β”‚     no change β”‚
   β”‚ QQuery 36 β”‚   70.03 ms β”‚        64.27 ms β”‚ +1.09x faster β”‚
   β”‚ QQuery 37 β”‚   36.23 ms β”‚        36.60 ms β”‚     no change β”‚
   β”‚ QQuery 38 β”‚   40.90 ms β”‚        40.89 ms β”‚     no change β”‚
   β”‚ QQuery 39 β”‚  140.93 ms β”‚       150.15 ms β”‚  1.07x slower β”‚
   β”‚ QQuery 40 β”‚   14.44 ms β”‚        14.69 ms β”‚     no change β”‚
   β”‚ QQuery 41 β”‚   14.33 ms β”‚        14.30 ms β”‚     no change β”‚
   β”‚ QQuery 42 β”‚   13.73 ms β”‚        13.32 ms β”‚     no change β”‚
   β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜
   ┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┓
   ┃ Benchmark Summary              ┃            ┃
   ┑━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━┩
   β”‚ Total Time (HEAD)              β”‚ 19220.39ms β”‚
   β”‚ Total Time (benchmark-21566)   β”‚ 19269.01ms β”‚
   β”‚ Average Time (HEAD)            β”‚   446.99ms β”‚
   β”‚ Average Time (benchmark-21566) β”‚   448.12ms β”‚
   β”‚ Queries Faster                 β”‚          1 β”‚
   β”‚ Queries Slower                 β”‚          1 β”‚
   β”‚ Queries with No Change         β”‚         41 β”‚
   β”‚ Queries with Failure           β”‚          0 β”‚
   β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜
   
   Distribution per query (min / mean Β±stddev / max):
   
   Comparing HEAD and benchmark-21566
   --------------------
   Benchmark clickbench_partitioned.json
   --------------------
   ┏━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┓
   ┃ Query     ┃                                  HEAD ┃                       benchmark-21566 ┃        Change ┃
   ┑━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━┩
   β”‚ QQuery 0  β”‚          1.26 / 3.97 Β±5.34 / 14.66 ms β”‚          1.24 / 4.10 Β±5.56 / 15.21 ms β”‚     no change β”‚
   β”‚ QQuery 1  β”‚        11.94 / 12.22 Β±0.17 / 12.41 ms β”‚        12.52 / 12.90 Β±0.20 / 13.06 ms β”‚  1.06x slower β”‚
   β”‚ QQuery 2  β”‚        36.30 / 36.45 Β±0.18 / 36.77 ms β”‚        35.86 / 36.08 Β±0.20 / 36.41 ms β”‚     no change β”‚
   β”‚ QQuery 3  β”‚        30.49 / 31.20 Β±0.60 / 32.27 ms β”‚        31.17 / 31.49 Β±0.26 / 31.91 ms β”‚     no change β”‚
   β”‚ QQuery 4  β”‚     222.18 / 228.83 Β±4.19 / 233.89 ms β”‚     231.62 / 235.44 Β±2.32 / 237.68 ms β”‚     no change β”‚
   β”‚ QQuery 5  β”‚     275.59 / 277.30 Β±1.45 / 279.52 ms β”‚     273.65 / 278.59 Β±3.80 / 284.05 ms β”‚     no change β”‚
   β”‚ QQuery 6  β”‚           1.27 / 1.42 Β±0.22 / 1.86 ms β”‚           1.25 / 1.41 Β±0.20 / 1.80 ms β”‚     no change β”‚
   β”‚ QQuery 7  β”‚        13.64 / 14.03 Β±0.33 / 14.51 ms β”‚        13.66 / 13.74 Β±0.09 / 13.89 ms β”‚     no change β”‚
   β”‚ QQuery 8  β”‚     331.72 / 334.20 Β±2.29 / 338.24 ms β”‚     333.32 / 335.87 Β±2.10 / 338.68 ms β”‚     no change β”‚
   β”‚ QQuery 9  β”‚     459.91 / 467.66 Β±5.40 / 476.06 ms β”‚     473.87 / 477.02 Β±4.79 / 486.49 ms β”‚     no change β”‚
   β”‚ QQuery 10 β”‚        69.87 / 72.29 Β±3.67 / 79.60 ms β”‚        70.02 / 70.89 Β±0.66 / 71.61 ms β”‚     no change β”‚
   β”‚ QQuery 11 β”‚        81.83 / 83.81 Β±2.40 / 88.49 ms β”‚        80.43 / 81.81 Β±1.07 / 82.93 ms β”‚     no change β”‚
   β”‚ QQuery 12 β”‚     272.54 / 278.60 Β±4.29 / 284.63 ms β”‚     275.51 / 280.74 Β±3.95 / 286.40 ms β”‚     no change β”‚
   β”‚ QQuery 13 β”‚    367.81 / 378.97 Β±12.90 / 401.98 ms β”‚    382.42 / 392.24 Β±13.19 / 418.14 ms β”‚     no change β”‚
   β”‚ QQuery 14 β”‚     285.80 / 291.71 Β±5.50 / 301.98 ms β”‚     287.95 / 293.68 Β±5.75 / 304.13 ms β”‚     no change β”‚
   β”‚ QQuery 15 β”‚     278.45 / 284.08 Β±3.77 / 289.69 ms β”‚     281.56 / 288.74 Β±4.79 / 295.86 ms β”‚     no change β”‚
   β”‚ QQuery 16 β”‚     619.98 / 624.01 Β±3.32 / 628.59 ms β”‚    621.95 / 644.42 Β±19.73 / 678.02 ms β”‚     no change β”‚
   β”‚ QQuery 17 β”‚     621.41 / 630.45 Β±7.12 / 642.04 ms β”‚    624.44 / 641.15 Β±14.72 / 668.49 ms β”‚     no change β”‚
   β”‚ QQuery 18 β”‚ 1278.19 / 1301.20 Β±26.90 / 1335.77 ms β”‚ 1284.78 / 1313.88 Β±16.78 / 1331.70 ms β”‚     no change β”‚
   β”‚ QQuery 19 β”‚        27.38 / 27.61 Β±0.14 / 27.80 ms β”‚      28.48 / 49.59 Β±36.27 / 121.61 ms β”‚  1.80x slower β”‚
   β”‚ QQuery 20 β”‚     517.26 / 526.08 Β±9.44 / 538.18 ms β”‚     515.04 / 521.64 Β±7.54 / 535.22 ms β”‚     no change β”‚
   β”‚ QQuery 21 β”‚     511.88 / 515.96 Β±4.19 / 521.69 ms β”‚     515.63 / 521.64 Β±5.37 / 531.41 ms β”‚     no change β”‚
   β”‚ QQuery 22 β”‚    984.51 / 995.16 Β±7.57 / 1006.30 ms β”‚  989.72 / 1017.09 Β±16.02 / 1031.00 ms β”‚     no change β”‚
   β”‚ QQuery 23 β”‚ 3072.47 / 3110.26 Β±26.95 / 3153.31 ms β”‚ 3072.48 / 3138.94 Β±47.28 / 3183.48 ms β”‚     no change β”‚
   β”‚ QQuery 24 β”‚        41.92 / 46.48 Β±5.12 / 53.49 ms β”‚        41.52 / 44.55 Β±3.63 / 51.43 ms β”‚     no change β”‚
   β”‚ QQuery 25 β”‚     110.90 / 111.80 Β±0.89 / 113.32 ms β”‚     110.65 / 111.41 Β±0.77 / 112.81 ms β”‚     no change β”‚
   β”‚ QQuery 26 β”‚        41.68 / 44.89 Β±3.18 / 50.17 ms β”‚        41.69 / 44.38 Β±2.58 / 47.97 ms β”‚     no change β”‚
   β”‚ QQuery 27 β”‚     512.34 / 522.65 Β±8.02 / 532.36 ms β”‚    511.93 / 525.90 Β±13.59 / 551.21 ms β”‚     no change β”‚
   β”‚ QQuery 28 β”‚ 2909.19 / 2928.25 Β±16.42 / 2951.98 ms β”‚ 2915.78 / 2936.06 Β±22.64 / 2977.14 ms β”‚     no change β”‚
   β”‚ QQuery 29 β”‚        41.64 / 42.01 Β±0.35 / 42.65 ms β”‚        41.25 / 41.53 Β±0.19 / 41.72 ms β”‚     no change β”‚
   β”‚ QQuery 30 β”‚    308.93 / 317.56 Β±11.59 / 340.52 ms β”‚     308.19 / 314.34 Β±9.86 / 333.90 ms β”‚     no change β”‚
   β”‚ QQuery 31 β”‚    286.74 / 297.55 Β±10.20 / 314.99 ms β”‚    289.02 / 302.03 Β±17.54 / 335.74 ms β”‚     no change β”‚
   β”‚ QQuery 32 β”‚    941.17 / 953.78 Β±11.75 / 968.85 ms β”‚     954.63 / 967.38 Β±8.09 / 976.47 ms β”‚     no change β”‚
   β”‚ QQuery 33 β”‚ 1489.64 / 1510.95 Β±14.52 / 1527.61 ms β”‚ 1491.13 / 1514.41 Β±19.51 / 1547.12 ms β”‚     no change β”‚
   β”‚ QQuery 34 β”‚ 1539.63 / 1553.03 Β±11.75 / 1574.01 ms β”‚ 1500.51 / 1541.69 Β±31.86 / 1589.78 ms β”‚     no change β”‚
   β”‚ QQuery 35 β”‚    292.34 / 313.40 Β±19.21 / 345.43 ms β”‚    289.95 / 313.11 Β±23.68 / 353.53 ms β”‚     no change β”‚
   β”‚ QQuery 36 β”‚        70.03 / 76.14 Β±5.23 / 84.71 ms β”‚        64.27 / 76.41 Β±8.16 / 88.19 ms β”‚     no change β”‚
   β”‚ QQuery 37 β”‚        36.23 / 39.41 Β±4.93 / 49.12 ms β”‚        36.60 / 39.79 Β±3.51 / 44.70 ms β”‚     no change β”‚
   β”‚ QQuery 38 β”‚        40.90 / 45.49 Β±4.31 / 51.65 ms β”‚        40.89 / 44.09 Β±2.57 / 48.02 ms β”‚     no change β”‚
   β”‚ QQuery 39 β”‚     140.93 / 155.23 Β±8.01 / 164.50 ms β”‚     150.15 / 159.05 Β±8.29 / 174.40 ms β”‚     no change β”‚
   β”‚ QQuery 40 β”‚        14.44 / 14.87 Β±0.38 / 15.35 ms β”‚        14.69 / 15.15 Β±0.47 / 16.06 ms β”‚     no change β”‚
   β”‚ QQuery 41 β”‚        14.33 / 16.38 Β±3.67 / 23.70 ms β”‚        14.30 / 16.14 Β±3.19 / 22.51 ms β”‚     no change β”‚
   β”‚ QQuery 42 β”‚        13.73 / 14.90 Β±1.79 / 18.46 ms β”‚        13.32 / 13.64 Β±0.17 / 13.79 ms β”‚ +1.09x faster β”‚
   β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜
   ┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┓
   ┃ Benchmark Summary              ┃            ┃
   ┑━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━┩
   β”‚ Total Time (HEAD)              β”‚ 19532.21ms β”‚
   β”‚ Total Time (benchmark-21566)   β”‚ 19704.16ms β”‚
   β”‚ Average Time (HEAD)            β”‚   454.24ms β”‚
   β”‚ Average Time (benchmark-21566) β”‚   458.24ms β”‚
   β”‚ Queries Faster                 β”‚          1 β”‚
   β”‚ Queries Slower                 β”‚          2 β”‚
   β”‚ Queries with No Change         β”‚         40 β”‚
   β”‚ Queries with Failure           β”‚          0 β”‚
   β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜
   ```
   
   </p>
   </details>
   
   <details><summary>Resource Usage</summary>
   
   **clickbench_partitioned β€” base (merge-base)**
   | Metric | Value |
   |--------|-------|
   | Wall time | 100.0s |
   | Peak memory | 11.4 GiB |
   | Avg memory | 4.0 GiB |
   | CPU user | 1002.9s |
   | CPU sys | 67.8s |
   | Peak spill | 0 B |
   
   **clickbench_partitioned β€” branch**
   | Metric | Value |
   |--------|-------|
   | Wall time | 100.0s |
   | Peak memory | 11.1 GiB |
   | Avg memory | 4.3 GiB |
   | CPU user | 1008.8s |
   | CPU sys | 71.0s |
   | Peak spill | 0 B |
   
   </details>
   
   
   ---
   [File an issue](https://github.com/adriangb/datafusion-benchmarking/issues) against this benchmark runner


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [PR] DRAFT investigate benchmark 21566 [datafusion]

Posted by "adriangbot (via GitHub)" <gi...@apache.org>.
adriangbot commented on PR #24214:
URL: https://github.com/apache/datafusion/pull/24214#issuecomment-5238526652

   Benchmark for [this request](https://github.com/apache/datafusion/pull/24214#issuecomment-5238501451) failed.
   
   <details><summary>Run configuration</summary>
   
   ```yaml
   run benchmark clickbench_pushdown
   ```
   
   </details>
   
   Last 20 lines of output:
   <details><summary>Click to expand</summary>
   
   ```
    * [new tag]             48.0.0-rc1           -> 48.0.0-rc1
    * [new tag]             48.0.0-rc2           -> 48.0.0-rc2
    * [new tag]             5.0.0                -> 5.0.0
    * [new tag]             5.0.0-rc1            -> 5.0.0-rc1
    * [new tag]             5.0.0-rc3            -> 5.0.0-rc3
    * [new tag]             6.0.0                -> 6.0.0
    * [new tag]             6.0.0-rc0            -> 6.0.0-rc0
    * [new tag]             7.0.0                -> 7.0.0
    * [new tag]             7.0.0-rc2            -> 7.0.0-rc2
    * [new tag]             8.0.0                -> 8.0.0
    * [new tag]             8.0.0-rc1            -> 8.0.0-rc1
    * [new tag]             8.0.0-rc2            -> 8.0.0-rc2
    * [new tag]             9.0.0                -> 9.0.0
    * [new tag]             9.0.0-rc1            -> 9.0.0-rc1
    * [new tag]             ballista-0.5.0       -> ballista-0.5.0
    * [new tag]             ballista-0.6.0       -> ballista-0.6.0
    * [new tag]             ballista-0.7.0       -> ballista-0.7.0
    * [new tag]             python-0.3.0         -> python-0.3.0
    * [new tag]             python-0.4.0         -> python-0.4.0
   Switched to branch 'benchmark-21566'
   ```
   
   </details>
   
   ---
   [File an issue](https://github.com/adriangb/datafusion-benchmarking/issues) against this benchmark runner


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [PR] DRAFT investigate benchmark 21566 [datafusion]

Posted by "codecov-commenter (via GitHub)" <gi...@apache.org>.
codecov-commenter commented on PR #24214:
URL: https://github.com/apache/datafusion/pull/24214#issuecomment-5239044993

   ## [Codecov](https://app.codecov.io/gh/apache/datafusion/pull/24214?dropdown=coverage&src=pr&el=h1&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache) Report
   :white_check_mark: All modified and coverable lines are covered by tests.
   :warning: Please [upload](https://docs.codecov.com/docs/codecov-uploader) report for BASE (`main@95398f0`). [Learn more](https://docs.codecov.io/docs/error-reference?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache#section-missing-base-commit) about missing BASE report.
   
   <details><summary>Additional details and impacted files</summary>
   
   
   
   ```diff
   @@           Coverage Diff           @@
   ##             main   #24214   +/-   ##
   =======================================
     Coverage        ?   81.05%           
   =======================================
     Files           ?     1106           
     Lines           ?   382268           
     Branches        ?   382268           
   =======================================
     Hits            ?   309857           
     Misses          ?    54114           
     Partials        ?    18297           
   ```
   </details>
   
   [:umbrella: View full report in Codecov by Harness](https://app.codecov.io/gh/apache/datafusion/pull/24214?dropdown=coverage&src=pr&el=continue&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache).   
   :loudspeaker: Have feedback on the report? [Share it here](https://about.codecov.io/codecov-pr-comment-feedback/?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=apache).
   <details><summary> :rocket: New features to boost your workflow: </summary>
   
   - :snowflake: [Test Analytics](https://docs.codecov.com/docs/test-analytics): Detect flaky tests, report on failures, and find test suite problems.
   - :package: [JS Bundle Analysis](https://docs.codecov.com/docs/javascript-bundle-analysis): Save yourself from yourself by tracking and limiting bundle sizes in JS merges.
   </details>


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [PR] DRAFT investigate benchmark 21566 [datafusion]

Posted by "adriangbot (via GitHub)" <gi...@apache.org>.
adriangbot commented on PR #24214:
URL: https://github.com/apache/datafusion/pull/24214#issuecomment-5275029468

   πŸ€– Benchmark running (GKE) | [trigger](https://github.com/apache/datafusion/pull/24214#issuecomment-5274969444)
   **Instance:** `c4a-highmem-16` (12 vCPU / 65 GiB) | `Linux bench-c5274969444-1572-bnqv7 6.12.85+ #1 SMP Wed Jun 17 20:31:55 UTC 2026 aarch64 GNU/Linux`
   <details><summary>CPU Details (lscpu)</summary>
   
   ```
   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 benchmark-21566 (0532fff11a2b2bf9aeda454f0f888232fd957f32) to c08832d (merge-base) [diff](https://github.com/apache/datafusion/compare/c08832d481cea2dcea98e43393e3dd640d421064..0532fff11a2b2bf9aeda454f0f888232fd957f32)
   
   <details><summary>Run configuration</summary>
   
   ```yaml
   run benchmark clickbench_partitioned
   ```
   
   </details>
   
   Results will be posted here when complete
   
   ---
   [File an issue](https://github.com/adriangb/datafusion-benchmarking/issues) against this benchmark runner


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [PR] DRAFT investigate benchmark 21566 [datafusion]

Posted by "kosiew (via GitHub)" <gi...@apache.org>.
kosiew commented on PR #24214:
URL: https://github.com/apache/datafusion/pull/24214#issuecomment-5238501451

   run benchmark clickbench_pushdown


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [PR] DRAFT investigate benchmark 21566 [datafusion]

Posted by "adriangbot (via GitHub)" <gi...@apache.org>.
adriangbot commented on PR #24214:
URL: https://github.com/apache/datafusion/pull/24214#issuecomment-5238993783

   Benchmark for [this request](https://github.com/apache/datafusion/pull/24214#issuecomment-5238971872) failed.
   
   <details><summary>Run configuration</summary>
   
   ```yaml
   run benchmark clickbench_pushdown
   ```
   
   </details>
   
   Last 20 lines of output:
   <details><summary>Click to expand</summary>
   
   ```
    * [new tag]             48.0.0-rc1           -> 48.0.0-rc1
    * [new tag]             48.0.0-rc2           -> 48.0.0-rc2
    * [new tag]             5.0.0                -> 5.0.0
    * [new tag]             5.0.0-rc1            -> 5.0.0-rc1
    * [new tag]             5.0.0-rc3            -> 5.0.0-rc3
    * [new tag]             6.0.0                -> 6.0.0
    * [new tag]             6.0.0-rc0            -> 6.0.0-rc0
    * [new tag]             7.0.0                -> 7.0.0
    * [new tag]             7.0.0-rc2            -> 7.0.0-rc2
    * [new tag]             8.0.0                -> 8.0.0
    * [new tag]             8.0.0-rc1            -> 8.0.0-rc1
    * [new tag]             8.0.0-rc2            -> 8.0.0-rc2
    * [new tag]             9.0.0                -> 9.0.0
    * [new tag]             9.0.0-rc1            -> 9.0.0-rc1
    * [new tag]             ballista-0.5.0       -> ballista-0.5.0
    * [new tag]             ballista-0.6.0       -> ballista-0.6.0
    * [new tag]             ballista-0.7.0       -> ballista-0.7.0
    * [new tag]             python-0.3.0         -> python-0.3.0
    * [new tag]             python-0.4.0         -> python-0.4.0
   Switched to branch 'benchmark-21566'
   ```
   
   </details>
   
   ---
   [File an issue](https://github.com/adriangb/datafusion-benchmarking/issues) against this benchmark runner


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [PR] DRAFT investigate benchmark 21566 [datafusion]

Posted by "kosiew (via GitHub)" <gi...@apache.org>.
kosiew commented on PR #24214:
URL: https://github.com/apache/datafusion/pull/24214#issuecomment-5264626678

   
   run benchmark clickbench_pushdown clickbench_partitioned
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [PR] DRAFT investigate benchmark 21566 [datafusion]

Posted by "adriangbot (via GitHub)" <gi...@apache.org>.
adriangbot commented on PR #24214:
URL: https://github.com/apache/datafusion/pull/24214#issuecomment-5275128289

   πŸ€– Benchmark completed (GKE) | [trigger](https://github.com/apache/datafusion/pull/24214#issuecomment-5274969444)
   
   **Instance:** `c4a-highmem-16` (12 vCPU / 65 GiB)
   
   Comparing benchmark-21566 (0532fff11a2b2bf9aeda454f0f888232fd957f32) to c08832d (merge-base) [diff](https://github.com/apache/datafusion/compare/c08832d481cea2dcea98e43393e3dd640d421064..0532fff11a2b2bf9aeda454f0f888232fd957f32)
   
   <details><summary>Run configuration</summary>
   
   ```yaml
   run benchmark clickbench_pushdown
   ```
   
   </details>
   
   <details><summary>CPU Details (lscpu)</summary>
   
   ```
   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>
   
   <details><summary>Details</summary>
   <p>
   
   ```
   Comparing HEAD and benchmark-21566
   --------------------
   Benchmark clickbench_pushdown.json
   --------------------
   ┏━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┓
   ┃ Query     ┃       HEAD ┃ benchmark-21566 ┃        Change ┃
   ┑━━━━━━━━━━━╇━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━┩
   β”‚ QQuery 0  β”‚    1.27 ms β”‚         1.24 ms β”‚     no change β”‚
   β”‚ QQuery 1  β”‚   12.51 ms β”‚        12.94 ms β”‚     no change β”‚
   β”‚ QQuery 2  β”‚   37.81 ms β”‚        35.65 ms β”‚ +1.06x faster β”‚
   β”‚ QQuery 3  β”‚   31.08 ms β”‚        30.82 ms β”‚     no change β”‚
   β”‚ QQuery 4  β”‚  224.86 ms β”‚       222.78 ms β”‚     no change β”‚
   β”‚ QQuery 5  β”‚  272.19 ms β”‚       269.29 ms β”‚     no change β”‚
   β”‚ QQuery 6  β”‚    1.31 ms β”‚         1.27 ms β”‚     no change β”‚
   β”‚ QQuery 7  β”‚   15.92 ms β”‚        16.26 ms β”‚     no change β”‚
   β”‚ QQuery 8  β”‚  322.42 ms β”‚       321.01 ms β”‚     no change β”‚
   β”‚ QQuery 9  β”‚  455.84 ms β”‚       451.12 ms β”‚     no change β”‚
   β”‚ QQuery 10 β”‚   92.85 ms β”‚        93.72 ms β”‚     no change β”‚
   β”‚ QQuery 11 β”‚  103.22 ms β”‚       105.49 ms β”‚     no change β”‚
   β”‚ QQuery 12 β”‚  297.64 ms β”‚       299.13 ms β”‚     no change β”‚
   β”‚ QQuery 13 β”‚  408.86 ms β”‚       413.57 ms β”‚     no change β”‚
   β”‚ QQuery 14 β”‚  310.61 ms β”‚       312.29 ms β”‚     no change β”‚
   β”‚ QQuery 15 β”‚  272.24 ms β”‚       267.44 ms β”‚     no change β”‚
   β”‚ QQuery 16 β”‚  610.90 ms β”‚       604.73 ms β”‚     no change β”‚
   β”‚ QQuery 17 β”‚  607.22 ms β”‚       618.96 ms β”‚     no change β”‚
   β”‚ QQuery 18 β”‚ 1252.41 ms β”‚      1235.72 ms β”‚     no change β”‚
   β”‚ QQuery 19 β”‚   29.27 ms β”‚        29.36 ms β”‚     no change β”‚
   β”‚ QQuery 20 β”‚  522.88 ms β”‚       514.90 ms β”‚     no change β”‚
   β”‚ QQuery 21 β”‚  564.23 ms β”‚       565.08 ms β”‚     no change β”‚
   β”‚ QQuery 22 β”‚  914.75 ms β”‚       929.32 ms β”‚     no change β”‚
   β”‚ QQuery 23 β”‚  114.70 ms β”‚       114.90 ms β”‚     no change β”‚
   β”‚ QQuery 24 β”‚   36.80 ms β”‚        37.69 ms β”‚     no change β”‚
   β”‚ QQuery 25 β”‚  139.17 ms β”‚       144.23 ms β”‚     no change β”‚
   β”‚ QQuery 26 β”‚   49.47 ms β”‚        49.84 ms β”‚     no change β”‚
   β”‚ QQuery 27 β”‚  562.79 ms β”‚       559.77 ms β”‚     no change β”‚
   β”‚ QQuery 28 β”‚ 2921.81 ms β”‚      2933.41 ms β”‚     no change β”‚
   β”‚ QQuery 29 β”‚   41.10 ms β”‚        40.54 ms β”‚     no change β”‚
   β”‚ QQuery 30 β”‚  313.82 ms β”‚       306.91 ms β”‚     no change β”‚
   β”‚ QQuery 31 β”‚  289.88 ms β”‚       290.85 ms β”‚     no change β”‚
   β”‚ QQuery 32 β”‚  908.41 ms β”‚       940.40 ms β”‚     no change β”‚
   β”‚ QQuery 33 β”‚ 1436.68 ms β”‚      1442.73 ms β”‚     no change β”‚
   β”‚ QQuery 34 β”‚ 1468.02 ms β”‚      1442.99 ms β”‚     no change β”‚
   β”‚ QQuery 35 β”‚  283.64 ms β”‚       279.40 ms β”‚     no change β”‚
   β”‚ QQuery 36 β”‚   67.42 ms β”‚        65.46 ms β”‚     no change β”‚
   β”‚ QQuery 37 β”‚   37.93 ms β”‚        36.09 ms β”‚     no change β”‚
   β”‚ QQuery 38 β”‚   34.41 ms β”‚        34.64 ms β”‚     no change β”‚
   β”‚ QQuery 39 β”‚  137.55 ms β”‚       140.23 ms β”‚     no change β”‚
   β”‚ QQuery 40 β”‚   17.39 ms β”‚        18.41 ms β”‚  1.06x slower β”‚
   β”‚ QQuery 41 β”‚   16.59 ms β”‚        16.90 ms β”‚     no change β”‚
   β”‚ QQuery 42 β”‚   14.27 ms β”‚        14.48 ms β”‚     no change β”‚
   β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜
   ┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┓
   ┃ Benchmark Summary              ┃            ┃
   ┑━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━┩
   β”‚ Total Time (HEAD)              β”‚ 16254.16ms β”‚
   β”‚ Total Time (benchmark-21566)   β”‚ 16261.95ms β”‚
   β”‚ Average Time (HEAD)            β”‚   378.00ms β”‚
   β”‚ Average Time (benchmark-21566) β”‚   378.18ms β”‚
   β”‚ Queries Faster                 β”‚          1 β”‚
   β”‚ Queries Slower                 β”‚          1 β”‚
   β”‚ Queries with No Change         β”‚         41 β”‚
   β”‚ Queries with Failure           β”‚          0 β”‚
   β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜
   
   Distribution per query (min / mean Β±stddev / max):
   
   Comparing HEAD and benchmark-21566
   --------------------
   Benchmark clickbench_pushdown.json
   --------------------
   ┏━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┓
   ┃ Query     ┃                                  HEAD ┃                       benchmark-21566 ┃        Change ┃
   ┑━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━┩
   β”‚ QQuery 0  β”‚          1.27 / 3.99 Β±5.38 / 14.76 ms β”‚          1.24 / 3.91 Β±5.27 / 14.44 ms β”‚     no change β”‚
   β”‚ QQuery 1  β”‚        12.51 / 12.63 Β±0.09 / 12.78 ms β”‚        12.94 / 13.08 Β±0.12 / 13.28 ms β”‚     no change β”‚
   β”‚ QQuery 2  β”‚        37.81 / 37.94 Β±0.12 / 38.14 ms β”‚        35.65 / 36.08 Β±0.23 / 36.24 ms β”‚     no change β”‚
   β”‚ QQuery 3  β”‚        31.08 / 31.78 Β±0.58 / 32.49 ms β”‚        30.82 / 30.95 Β±0.11 / 31.14 ms β”‚     no change β”‚
   β”‚ QQuery 4  β”‚     224.86 / 227.69 Β±1.74 / 229.93 ms β”‚     222.78 / 227.69 Β±5.24 / 236.95 ms β”‚     no change β”‚
   β”‚ QQuery 5  β”‚     272.19 / 274.24 Β±2.28 / 278.47 ms β”‚     269.29 / 272.56 Β±1.65 / 273.76 ms β”‚     no change β”‚
   β”‚ QQuery 6  β”‚           1.31 / 1.45 Β±0.21 / 1.86 ms β”‚           1.27 / 1.40 Β±0.21 / 1.81 ms β”‚     no change β”‚
   β”‚ QQuery 7  β”‚        15.92 / 16.17 Β±0.15 / 16.36 ms β”‚        16.26 / 16.48 Β±0.14 / 16.62 ms β”‚     no change β”‚
   β”‚ QQuery 8  β”‚     322.42 / 328.05 Β±4.69 / 335.26 ms β”‚     321.01 / 324.94 Β±3.32 / 329.29 ms β”‚     no change β”‚
   β”‚ QQuery 9  β”‚    455.84 / 465.09 Β±10.40 / 483.80 ms β”‚    451.12 / 463.63 Β±10.31 / 481.45 ms β”‚     no change β”‚
   β”‚ QQuery 10 β”‚        92.85 / 93.53 Β±0.68 / 94.57 ms β”‚       93.72 / 97.63 Β±6.02 / 109.58 ms β”‚     no change β”‚
   β”‚ QQuery 11 β”‚     103.22 / 104.76 Β±1.14 / 106.12 ms β”‚     105.49 / 106.97 Β±1.72 / 110.15 ms β”‚     no change β”‚
   β”‚ QQuery 12 β”‚     297.64 / 302.32 Β±3.91 / 307.01 ms β”‚     299.13 / 306.04 Β±4.48 / 312.79 ms β”‚     no change β”‚
   β”‚ QQuery 13 β”‚     408.86 / 419.14 Β±6.88 / 428.60 ms β”‚    413.57 / 424.08 Β±11.66 / 446.18 ms β”‚     no change β”‚
   β”‚ QQuery 14 β”‚    310.61 / 325.77 Β±23.93 / 373.12 ms β”‚    312.29 / 327.51 Β±23.30 / 373.78 ms β”‚     no change β”‚
   β”‚ QQuery 15 β”‚     272.24 / 279.66 Β±8.12 / 294.45 ms β”‚     267.44 / 279.88 Β±9.91 / 295.80 ms β”‚     no change β”‚
   β”‚ QQuery 16 β”‚    610.90 / 624.62 Β±12.84 / 647.19 ms β”‚     604.73 / 615.58 Β±6.48 / 622.68 ms β”‚     no change β”‚
   β”‚ QQuery 17 β”‚    607.22 / 623.45 Β±11.13 / 640.82 ms β”‚     618.96 / 626.87 Β±9.01 / 643.43 ms β”‚     no change β”‚
   β”‚ QQuery 18 β”‚ 1252.41 / 1277.74 Β±16.11 / 1297.99 ms β”‚ 1235.72 / 1265.16 Β±25.30 / 1299.67 ms β”‚     no change β”‚
   β”‚ QQuery 19 β”‚        29.27 / 29.88 Β±0.54 / 30.72 ms β”‚        29.36 / 31.00 Β±2.62 / 36.21 ms β”‚     no change β”‚
   β”‚ QQuery 20 β”‚     522.88 / 528.37 Β±5.94 / 539.50 ms β”‚     514.90 / 519.73 Β±3.67 / 524.97 ms β”‚     no change β”‚
   β”‚ QQuery 21 β”‚    564.23 / 577.35 Β±11.20 / 594.31 ms β”‚    565.08 / 578.58 Β±11.11 / 597.05 ms β”‚     no change β”‚
   β”‚ QQuery 22 β”‚    914.75 / 934.06 Β±13.82 / 953.16 ms β”‚    929.32 / 943.23 Β±12.72 / 965.55 ms β”‚     no change β”‚
   β”‚ QQuery 23 β”‚     114.70 / 117.50 Β±2.29 / 120.86 ms β”‚    114.90 / 126.60 Β±18.61 / 163.61 ms β”‚  1.08x slower β”‚
   β”‚ QQuery 24 β”‚        36.80 / 40.53 Β±5.05 / 50.32 ms β”‚        37.69 / 40.16 Β±3.33 / 46.66 ms β”‚     no change β”‚
   β”‚ QQuery 25 β”‚     139.17 / 141.97 Β±2.42 / 146.23 ms β”‚     144.23 / 146.59 Β±1.32 / 148.27 ms β”‚     no change β”‚
   β”‚ QQuery 26 β”‚        49.47 / 55.16 Β±5.83 / 64.43 ms β”‚        49.84 / 56.04 Β±7.25 / 69.47 ms β”‚     no change β”‚
   β”‚ QQuery 27 β”‚     562.79 / 570.79 Β±7.26 / 583.89 ms β”‚    559.77 / 587.01 Β±14.99 / 600.69 ms β”‚     no change β”‚
   β”‚ QQuery 28 β”‚ 2921.81 / 2941.60 Β±10.11 / 2949.57 ms β”‚ 2933.41 / 2961.40 Β±17.17 / 2984.66 ms β”‚     no change β”‚
   β”‚ QQuery 29 β”‚        41.10 / 41.66 Β±0.40 / 42.23 ms β”‚      40.54 / 69.24 Β±20.78 / 102.41 ms β”‚  1.66x slower β”‚
   β”‚ QQuery 30 β”‚     313.82 / 318.69 Β±4.57 / 326.52 ms β”‚     306.91 / 314.65 Β±8.65 / 329.78 ms β”‚     no change β”‚
   β”‚ QQuery 31 β”‚     289.88 / 299.45 Β±7.42 / 310.43 ms β”‚    290.85 / 304.07 Β±11.18 / 318.56 ms β”‚     no change β”‚
   β”‚ QQuery 32 β”‚   908.41 / 952.18 Β±30.17 / 1002.72 ms β”‚    940.40 / 952.39 Β±10.59 / 968.51 ms β”‚     no change β”‚
   β”‚ QQuery 33 β”‚ 1436.68 / 1470.05 Β±21.86 / 1503.99 ms β”‚ 1442.73 / 1478.97 Β±25.11 / 1519.64 ms β”‚     no change β”‚
   β”‚ QQuery 34 β”‚ 1468.02 / 1537.63 Β±63.06 / 1648.80 ms β”‚ 1442.99 / 1490.90 Β±26.07 / 1516.42 ms β”‚     no change β”‚
   β”‚ QQuery 35 β”‚    283.64 / 315.11 Β±35.58 / 366.44 ms β”‚    279.40 / 298.67 Β±20.30 / 326.72 ms β”‚ +1.06x faster β”‚
   β”‚ QQuery 36 β”‚        67.42 / 70.58 Β±4.09 / 78.47 ms β”‚        65.46 / 73.35 Β±7.46 / 85.10 ms β”‚     no change β”‚
   β”‚ QQuery 37 β”‚        37.93 / 45.59 Β±5.31 / 53.48 ms β”‚        36.09 / 36.58 Β±0.41 / 37.33 ms β”‚ +1.25x faster β”‚
   β”‚ QQuery 38 β”‚        34.41 / 36.64 Β±1.46 / 37.87 ms β”‚        34.64 / 38.05 Β±2.57 / 42.51 ms β”‚     no change β”‚
   β”‚ QQuery 39 β”‚     137.55 / 144.75 Β±7.13 / 157.27 ms β”‚     140.23 / 145.83 Β±4.30 / 153.54 ms β”‚     no change β”‚
   β”‚ QQuery 40 β”‚        17.39 / 20.71 Β±4.37 / 28.87 ms β”‚        18.41 / 18.69 Β±0.34 / 19.31 ms β”‚ +1.11x faster β”‚
   β”‚ QQuery 41 β”‚        16.59 / 18.72 Β±3.90 / 26.51 ms β”‚        16.90 / 19.44 Β±3.74 / 26.80 ms β”‚     no change β”‚
   β”‚ QQuery 42 β”‚        14.27 / 14.42 Β±0.11 / 14.54 ms β”‚        14.48 / 17.16 Β±4.58 / 26.30 ms β”‚  1.19x slower β”‚
   β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜
   ┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┓
   ┃ Benchmark Summary              ┃            ┃
   ┑━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━┩
   β”‚ Total Time (HEAD)              β”‚ 16673.41ms β”‚
   β”‚ Total Time (benchmark-21566)   β”‚ 16688.79ms β”‚
   β”‚ Average Time (HEAD)            β”‚   387.75ms β”‚
   β”‚ Average Time (benchmark-21566) β”‚   388.11ms β”‚
   β”‚ Queries Faster                 β”‚          3 β”‚
   β”‚ Queries Slower                 β”‚          3 β”‚
   β”‚ Queries with No Change         β”‚         37 β”‚
   β”‚ Queries with Failure           β”‚          0 β”‚
   β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜
   ```
   
   </p>
   </details>
   
   <details><summary>Resource Usage</summary>
   
   **clickbench_pushdown β€” base (merge-base)**
   | Metric | Value |
   |--------|-------|
   | Wall time | 85.0s |
   | Peak memory | 11.5 GiB |
   | Avg memory | 4.8 GiB |
   | CPU user | 845.6s |
   | CPU sys | 60.8s |
   | Peak spill | 0 B |
   
   **clickbench_pushdown β€” branch**
   | Metric | Value |
   |--------|-------|
   | Wall time | 85.0s |
   | Peak memory | 11.4 GiB |
   | Avg memory | 4.6 GiB |
   | CPU user | 844.9s |
   | CPU sys | 62.2s |
   | Peak spill | 0 B |
   
   </details>
   
   
   ---
   [File an issue](https://github.com/adriangb/datafusion-benchmarking/issues) against this benchmark runner


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [PR] DRAFT investigate benchmark 21566 [datafusion]

Posted by "adriangbot (via GitHub)" <gi...@apache.org>.
adriangbot commented on PR #24214:
URL: https://github.com/apache/datafusion/pull/24214#issuecomment-5264569067

   Benchmark for [this request](https://github.com/apache/datafusion/pull/24214#issuecomment-5264552913) failed.
   
   <details><summary>Run configuration</summary>
   
   ```yaml
   run benchmark clickbench_pushdown
   ```
   
   </details>
   
   Last 20 lines of output:
   <details><summary>Click to expand</summary>
   
   ```
    * [new tag]             48.0.0-rc1           -> 48.0.0-rc1
    * [new tag]             48.0.0-rc2           -> 48.0.0-rc2
    * [new tag]             5.0.0                -> 5.0.0
    * [new tag]             5.0.0-rc1            -> 5.0.0-rc1
    * [new tag]             5.0.0-rc3            -> 5.0.0-rc3
    * [new tag]             6.0.0                -> 6.0.0
    * [new tag]             6.0.0-rc0            -> 6.0.0-rc0
    * [new tag]             7.0.0                -> 7.0.0
    * [new tag]             7.0.0-rc2            -> 7.0.0-rc2
    * [new tag]             8.0.0                -> 8.0.0
    * [new tag]             8.0.0-rc1            -> 8.0.0-rc1
    * [new tag]             8.0.0-rc2            -> 8.0.0-rc2
    * [new tag]             9.0.0                -> 9.0.0
    * [new tag]             9.0.0-rc1            -> 9.0.0-rc1
    * [new tag]             ballista-0.5.0       -> ballista-0.5.0
    * [new tag]             ballista-0.6.0       -> ballista-0.6.0
    * [new tag]             ballista-0.7.0       -> ballista-0.7.0
    * [new tag]             python-0.3.0         -> python-0.3.0
    * [new tag]             python-0.4.0         -> python-0.4.0
   Switched to branch 'benchmark-21566'
   ```
   
   </details>
   
   ---
   [File an issue](https://github.com/adriangb/datafusion-benchmarking/issues) against this benchmark runner


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [PR] DRAFT investigate benchmark 21566 [datafusion]

Posted by "adriangbot (via GitHub)" <gi...@apache.org>.
adriangbot commented on PR #24214:
URL: https://github.com/apache/datafusion/pull/24214#issuecomment-5264853671

   πŸ€– Benchmark completed (GKE) | [trigger](https://github.com/apache/datafusion/pull/24214#issuecomment-5264626678)
   
   **Instance:** `c4a-highmem-16` (12 vCPU / 65 GiB)
   
   Comparing benchmark-21566 (9ecb48a8a78d32a88764613a8ccdb145fb0fe596) to c08832d (merge-base) [diff](https://github.com/apache/datafusion/compare/c08832d481cea2dcea98e43393e3dd640d421064..9ecb48a8a78d32a88764613a8ccdb145fb0fe596)
   
   <details><summary>Run configuration</summary>
   
   ```yaml
   run benchmark clickbench_partitioned
   ```
   
   </details>
   
   <details><summary>CPU Details (lscpu)</summary>
   
   ```
   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>
   
   <details><summary>Details</summary>
   <p>
   
   ```
   Comparing HEAD and benchmark-21566
   --------------------
   Benchmark clickbench_partitioned.json
   --------------------
   ┏━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┓
   ┃ Query     ┃       HEAD ┃ benchmark-21566 ┃        Change ┃
   ┑━━━━━━━━━━━╇━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━┩
   β”‚ QQuery 0  β”‚    1.28 ms β”‚         1.24 ms β”‚     no change β”‚
   β”‚ QQuery 1  β”‚   12.14 ms β”‚        12.97 ms β”‚  1.07x slower β”‚
   β”‚ QQuery 2  β”‚   36.72 ms β”‚        37.61 ms β”‚     no change β”‚
   β”‚ QQuery 3  β”‚   31.40 ms β”‚        31.22 ms β”‚     no change β”‚
   β”‚ QQuery 4  β”‚  235.86 ms β”‚       228.77 ms β”‚     no change β”‚
   β”‚ QQuery 5  β”‚  283.08 ms β”‚       278.33 ms β”‚     no change β”‚
   β”‚ QQuery 6  β”‚    1.35 ms β”‚         1.26 ms β”‚ +1.07x faster β”‚
   β”‚ QQuery 7  β”‚   13.98 ms β”‚        14.04 ms β”‚     no change β”‚
   β”‚ QQuery 8  β”‚  343.10 ms β”‚       335.54 ms β”‚     no change β”‚
   β”‚ QQuery 9  β”‚  454.14 ms β”‚       466.60 ms β”‚     no change β”‚
   β”‚ QQuery 10 β”‚   71.78 ms β”‚        70.20 ms β”‚     no change β”‚
   β”‚ QQuery 11 β”‚   83.35 ms β”‚        81.67 ms β”‚     no change β”‚
   β”‚ QQuery 12 β”‚  277.98 ms β”‚       271.53 ms β”‚     no change β”‚
   β”‚ QQuery 13 β”‚  372.38 ms β”‚       375.68 ms β”‚     no change β”‚
   β”‚ QQuery 14 β”‚  292.23 ms β”‚       288.07 ms β”‚     no change β”‚
   β”‚ QQuery 15 β”‚  282.01 ms β”‚       279.48 ms β”‚     no change β”‚
   β”‚ QQuery 16 β”‚  629.59 ms β”‚       624.31 ms β”‚     no change β”‚
   β”‚ QQuery 17 β”‚  638.49 ms β”‚       633.23 ms β”‚     no change β”‚
   β”‚ QQuery 18 β”‚ 1303.73 ms β”‚      1285.32 ms β”‚     no change β”‚
   β”‚ QQuery 19 β”‚   28.31 ms β”‚        28.61 ms β”‚     no change β”‚
   β”‚ QQuery 20 β”‚  523.33 ms β”‚       517.58 ms β”‚     no change β”‚
   β”‚ QQuery 21 β”‚  521.98 ms β”‚       514.21 ms β”‚     no change β”‚
   β”‚ QQuery 22 β”‚ 1013.06 ms β”‚       997.79 ms β”‚     no change β”‚
   β”‚ QQuery 23 β”‚ 3171.66 ms β”‚      3116.62 ms β”‚     no change β”‚
   β”‚ QQuery 24 β”‚   42.03 ms β”‚        41.39 ms β”‚     no change β”‚
   β”‚ QQuery 25 β”‚  113.35 ms β”‚       112.53 ms β”‚     no change β”‚
   β”‚ QQuery 26 β”‚   42.09 ms β”‚        41.71 ms β”‚     no change β”‚
   β”‚ QQuery 27 β”‚  519.45 ms β”‚       518.72 ms β”‚     no change β”‚
   β”‚ QQuery 28 β”‚ 2935.72 ms β”‚      2916.77 ms β”‚     no change β”‚
   β”‚ QQuery 29 β”‚   42.02 ms β”‚        41.53 ms β”‚     no change β”‚
   β”‚ QQuery 30 β”‚  317.17 ms β”‚       305.83 ms β”‚     no change β”‚
   β”‚ QQuery 31 β”‚  294.32 ms β”‚       286.47 ms β”‚     no change β”‚
   β”‚ QQuery 32 β”‚ 1008.33 ms β”‚       966.12 ms β”‚     no change β”‚
   β”‚ QQuery 33 β”‚ 1527.03 ms β”‚      1497.01 ms β”‚     no change β”‚
   β”‚ QQuery 34 β”‚ 1531.71 ms β”‚      1534.99 ms β”‚     no change β”‚
   β”‚ QQuery 35 β”‚  298.09 ms β”‚       286.77 ms β”‚     no change β”‚
   β”‚ QQuery 36 β”‚   69.14 ms β”‚        68.13 ms β”‚     no change β”‚
   β”‚ QQuery 37 β”‚   37.23 ms β”‚        36.00 ms β”‚     no change β”‚
   β”‚ QQuery 38 β”‚   41.65 ms β”‚        42.76 ms β”‚     no change β”‚
   β”‚ QQuery 39 β”‚  137.13 ms β”‚       140.12 ms β”‚     no change β”‚
   β”‚ QQuery 40 β”‚   14.95 ms β”‚        14.61 ms β”‚     no change β”‚
   β”‚ QQuery 41 β”‚   14.53 ms β”‚        14.27 ms β”‚     no change β”‚
   β”‚ QQuery 42 β”‚   14.13 ms β”‚        13.68 ms β”‚     no change β”‚
   β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜
   ┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┓
   ┃ Benchmark Summary              ┃            ┃
   ┑━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━┩
   β”‚ Total Time (HEAD)              β”‚ 19622.99ms β”‚
   β”‚ Total Time (benchmark-21566)   β”‚ 19371.30ms β”‚
   β”‚ Average Time (HEAD)            β”‚   456.35ms β”‚
   β”‚ Average Time (benchmark-21566) β”‚   450.50ms β”‚
   β”‚ Queries Faster                 β”‚          1 β”‚
   β”‚ Queries Slower                 β”‚          1 β”‚
   β”‚ Queries with No Change         β”‚         41 β”‚
   β”‚ Queries with Failure           β”‚          0 β”‚
   β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜
   
   Distribution per query (min / mean Β±stddev / max):
   
   Comparing HEAD and benchmark-21566
   --------------------
   Benchmark clickbench_partitioned.json
   --------------------
   ┏━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┓
   ┃ Query     ┃                                  HEAD ┃                       benchmark-21566 ┃        Change ┃
   ┑━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━┩
   β”‚ QQuery 0  β”‚          1.28 / 4.12 Β±5.53 / 15.18 ms β”‚          1.24 / 4.08 Β±5.51 / 15.10 ms β”‚     no change β”‚
   β”‚ QQuery 1  β”‚        12.14 / 12.73 Β±0.34 / 13.19 ms β”‚        12.97 / 13.16 Β±0.15 / 13.37 ms β”‚     no change β”‚
   β”‚ QQuery 2  β”‚        36.72 / 37.27 Β±0.46 / 37.84 ms β”‚        37.61 / 37.93 Β±0.27 / 38.41 ms β”‚     no change β”‚
   β”‚ QQuery 3  β”‚        31.40 / 31.94 Β±0.50 / 32.61 ms β”‚        31.22 / 31.40 Β±0.14 / 31.59 ms β”‚     no change β”‚
   β”‚ QQuery 4  β”‚     235.86 / 242.22 Β±5.53 / 251.53 ms β”‚     228.77 / 234.88 Β±3.49 / 238.49 ms β”‚     no change β”‚
   β”‚ QQuery 5  β”‚     283.08 / 285.49 Β±1.45 / 287.34 ms β”‚     278.33 / 281.50 Β±3.24 / 286.98 ms β”‚     no change β”‚
   β”‚ QQuery 6  β”‚           1.35 / 1.50 Β±0.22 / 1.92 ms β”‚           1.26 / 1.42 Β±0.24 / 1.88 ms β”‚ +1.05x faster β”‚
   β”‚ QQuery 7  β”‚        13.98 / 14.16 Β±0.23 / 14.61 ms β”‚        14.04 / 14.29 Β±0.18 / 14.60 ms β”‚     no change β”‚
   β”‚ QQuery 8  β”‚     343.10 / 345.64 Β±1.94 / 347.92 ms β”‚     335.54 / 338.91 Β±4.08 / 346.73 ms β”‚     no change β”‚
   β”‚ QQuery 9  β”‚    454.14 / 479.01 Β±13.11 / 489.56 ms β”‚     466.60 / 478.50 Β±7.29 / 485.42 ms β”‚     no change β”‚
   β”‚ QQuery 10 β”‚        71.78 / 72.74 Β±0.80 / 73.72 ms β”‚        70.20 / 75.70 Β±7.48 / 89.76 ms β”‚     no change β”‚
   β”‚ QQuery 11 β”‚        83.35 / 84.20 Β±0.62 / 85.06 ms β”‚        81.67 / 83.08 Β±1.78 / 86.43 ms β”‚     no change β”‚
   β”‚ QQuery 12 β”‚     277.98 / 284.08 Β±4.65 / 290.73 ms β”‚     271.53 / 277.56 Β±6.62 / 290.20 ms β”‚     no change β”‚
   β”‚ QQuery 13 β”‚     372.38 / 382.11 Β±6.44 / 391.18 ms β”‚     375.68 / 387.07 Β±6.77 / 396.12 ms β”‚     no change β”‚
   β”‚ QQuery 14 β”‚     292.23 / 297.25 Β±4.19 / 304.95 ms β”‚     288.07 / 295.89 Β±8.01 / 309.93 ms β”‚     no change β”‚
   β”‚ QQuery 15 β”‚    282.01 / 295.98 Β±23.73 / 343.31 ms β”‚     279.48 / 284.34 Β±4.92 / 293.00 ms β”‚     no change β”‚
   β”‚ QQuery 16 β”‚     629.59 / 640.63 Β±8.72 / 655.20 ms β”‚    624.31 / 639.27 Β±11.61 / 658.26 ms β”‚     no change β”‚
   β”‚ QQuery 17 β”‚    638.49 / 657.19 Β±28.04 / 712.87 ms β”‚     633.23 / 648.12 Β±9.94 / 661.84 ms β”‚     no change β”‚
   β”‚ QQuery 18 β”‚ 1303.73 / 1327.70 Β±17.63 / 1352.07 ms β”‚ 1285.32 / 1317.47 Β±33.24 / 1374.30 ms β”‚     no change β”‚
   β”‚ QQuery 19 β”‚       28.31 / 36.51 Β±16.17 / 68.84 ms β”‚        28.61 / 29.96 Β±2.32 / 34.58 ms β”‚ +1.22x faster β”‚
   β”‚ QQuery 20 β”‚     523.33 / 532.76 Β±8.22 / 547.58 ms β”‚    517.58 / 529.59 Β±16.65 / 562.38 ms β”‚     no change β”‚
   β”‚ QQuery 21 β”‚     521.98 / 526.01 Β±2.47 / 528.51 ms β”‚     514.21 / 523.45 Β±5.47 / 530.58 ms β”‚     no change β”‚
   β”‚ QQuery 22 β”‚  1013.06 / 1020.64 Β±8.33 / 1036.74 ms β”‚  997.79 / 1034.97 Β±19.29 / 1053.77 ms β”‚     no change β”‚
   β”‚ QQuery 23 β”‚ 3171.66 / 3188.12 Β±12.10 / 3202.73 ms β”‚ 3116.62 / 3160.97 Β±28.16 / 3196.63 ms β”‚     no change β”‚
   β”‚ QQuery 24 β”‚        42.03 / 42.22 Β±0.18 / 42.53 ms β”‚        41.39 / 42.19 Β±0.79 / 43.62 ms β”‚     no change β”‚
   β”‚ QQuery 25 β”‚     113.35 / 115.19 Β±1.89 / 118.78 ms β”‚     112.53 / 120.67 Β±8.22 / 131.57 ms β”‚     no change β”‚
   β”‚ QQuery 26 β”‚        42.09 / 44.63 Β±2.78 / 49.92 ms β”‚        41.71 / 43.19 Β±0.86 / 44.39 ms β”‚     no change β”‚
   β”‚ QQuery 27 β”‚     519.45 / 530.03 Β±5.97 / 535.02 ms β”‚     518.72 / 525.62 Β±7.35 / 539.81 ms β”‚     no change β”‚
   β”‚ QQuery 28 β”‚ 2935.72 / 2959.07 Β±25.53 / 3006.91 ms β”‚ 2916.77 / 2934.32 Β±10.58 / 2949.64 ms β”‚     no change β”‚
   β”‚ QQuery 29 β”‚        42.02 / 42.23 Β±0.19 / 42.53 ms β”‚        41.53 / 43.40 Β±2.77 / 48.88 ms β”‚     no change β”‚
   β”‚ QQuery 30 β”‚     317.17 / 320.30 Β±5.25 / 330.76 ms β”‚    305.83 / 317.90 Β±14.35 / 346.05 ms β”‚     no change β”‚
   β”‚ QQuery 31 β”‚     294.32 / 301.42 Β±6.21 / 310.03 ms β”‚    286.47 / 300.23 Β±11.94 / 321.77 ms β”‚     no change β”‚
   β”‚ QQuery 32 β”‚ 1008.33 / 1021.93 Β±10.46 / 1039.87 ms β”‚   966.12 / 986.72 Β±17.73 / 1008.61 ms β”‚     no change β”‚
   β”‚ QQuery 33 β”‚  1527.03 / 1536.48 Β±6.19 / 1546.40 ms β”‚ 1497.01 / 1527.94 Β±22.92 / 1559.78 ms β”‚     no change β”‚
   β”‚ QQuery 34 β”‚ 1531.71 / 1578.03 Β±31.81 / 1623.47 ms β”‚ 1534.99 / 1596.93 Β±59.81 / 1705.94 ms β”‚     no change β”‚
   β”‚ QQuery 35 β”‚    298.09 / 311.19 Β±16.94 / 343.20 ms β”‚    286.77 / 326.57 Β±59.23 / 442.88 ms β”‚     no change β”‚
   β”‚ QQuery 36 β”‚        69.14 / 72.12 Β±3.05 / 77.43 ms β”‚       68.13 / 79.78 Β±11.84 / 99.55 ms β”‚  1.11x slower β”‚
   β”‚ QQuery 37 β”‚        37.23 / 44.45 Β±4.78 / 52.13 ms β”‚        36.00 / 36.98 Β±0.86 / 38.07 ms β”‚ +1.20x faster β”‚
   β”‚ QQuery 38 β”‚        41.65 / 43.78 Β±1.28 / 45.15 ms β”‚        42.76 / 44.97 Β±2.48 / 49.52 ms β”‚     no change β”‚
   β”‚ QQuery 39 β”‚    137.13 / 158.55 Β±16.82 / 179.26 ms β”‚     140.12 / 150.39 Β±7.83 / 162.09 ms β”‚ +1.05x faster β”‚
   β”‚ QQuery 40 β”‚        14.95 / 15.15 Β±0.17 / 15.38 ms β”‚        14.61 / 15.06 Β±0.57 / 16.18 ms β”‚     no change β”‚
   β”‚ QQuery 41 β”‚        14.53 / 14.65 Β±0.08 / 14.74 ms β”‚        14.27 / 14.43 Β±0.12 / 14.64 ms β”‚     no change β”‚
   β”‚ QQuery 42 β”‚        14.13 / 14.22 Β±0.06 / 14.32 ms β”‚        13.68 / 15.51 Β±3.14 / 21.77 ms β”‚  1.09x slower β”‚
   β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜
   ┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┓
   ┃ Benchmark Summary              ┃            ┃
   ┑━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━┩
   β”‚ Total Time (HEAD)              β”‚ 19965.62ms β”‚
   β”‚ Total Time (benchmark-21566)   β”‚ 19846.31ms β”‚
   β”‚ Average Time (HEAD)            β”‚   464.32ms β”‚
   β”‚ Average Time (benchmark-21566) β”‚   461.54ms β”‚
   β”‚ Queries Faster                 β”‚          4 β”‚
   β”‚ Queries Slower                 β”‚          2 β”‚
   β”‚ Queries with No Change         β”‚         37 β”‚
   β”‚ Queries with Failure           β”‚          0 β”‚
   β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜
   ```
   
   </p>
   </details>
   
   <details><summary>Resource Usage</summary>
   
   **clickbench_partitioned β€” base (merge-base)**
   | Metric | Value |
   |--------|-------|
   | Wall time | 105.0s |
   | Peak memory | 12.0 GiB |
   | Avg memory | 4.7 GiB |
   | CPU user | 1023.0s |
   | CPU sys | 72.7s |
   | Peak spill | 0 B |
   
   **clickbench_partitioned β€” branch**
   | Metric | Value |
   |--------|-------|
   | Wall time | 100.0s |
   | Peak memory | 11.3 GiB |
   | Avg memory | 4.6 GiB |
   | CPU user | 1013.1s |
   | CPU sys | 72.7s |
   | Peak spill | 0 B |
   
   </details>
   
   
   ---
   [File an issue](https://github.com/adriangb/datafusion-benchmarking/issues) against this benchmark runner


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [PR] DRAFT investigate benchmark 21566 [datafusion]

Posted by "kosiew (via GitHub)" <gi...@apache.org>.
kosiew commented on PR #24214:
URL: https://github.com/apache/datafusion/pull/24214#issuecomment-5238971872

   
   run benchmark clickbench_pushdown
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [PR] DRAFT investigate benchmark 21566 [datafusion]

Posted by "kosiew (via GitHub)" <gi...@apache.org>.
kosiew commented on PR #24214:
URL: https://github.com/apache/datafusion/pull/24214#issuecomment-5274969444

   run benchmark clickbench_pushdown clickbench_partitioned
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [PR] DRAFT investigate benchmark 21566 [datafusion]

Posted by "adriangbot (via GitHub)" <gi...@apache.org>.
adriangbot commented on PR #24214:
URL: https://github.com/apache/datafusion/pull/24214#issuecomment-5264683062

   πŸ€– Benchmark running (GKE) | [trigger](https://github.com/apache/datafusion/pull/24214#issuecomment-5264626678)
   **Instance:** `c4a-highmem-16` (12 vCPU / 65 GiB) | `Linux bench-c5264626678-1565-ccjmb 6.12.85+ #1 SMP Wed Jun 17 20:31:55 UTC 2026 aarch64 GNU/Linux`
   <details><summary>CPU Details (lscpu)</summary>
   
   ```
   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 benchmark-21566 (9ecb48a8a78d32a88764613a8ccdb145fb0fe596) to c08832d (merge-base) [diff](https://github.com/apache/datafusion/compare/c08832d481cea2dcea98e43393e3dd640d421064..9ecb48a8a78d32a88764613a8ccdb145fb0fe596)
   
   <details><summary>Run configuration</summary>
   
   ```yaml
   run benchmark clickbench_partitioned
   ```
   
   </details>
   
   Results will be posted here when complete
   
   ---
   [File an issue](https://github.com/adriangb/datafusion-benchmarking/issues) against this benchmark runner


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [PR] DRAFT investigate benchmark 21566 [datafusion]

Posted by "adriangbot (via GitHub)" <gi...@apache.org>.
adriangbot commented on PR #24214:
URL: https://github.com/apache/datafusion/pull/24214#issuecomment-5264840315

   πŸ€– Benchmark completed (GKE) | [trigger](https://github.com/apache/datafusion/pull/24214#issuecomment-5264626678)
   
   **Instance:** `c4a-highmem-16` (12 vCPU / 65 GiB)
   
   Comparing benchmark-21566 (9ecb48a8a78d32a88764613a8ccdb145fb0fe596) to c08832d (merge-base) [diff](https://github.com/apache/datafusion/compare/c08832d481cea2dcea98e43393e3dd640d421064..9ecb48a8a78d32a88764613a8ccdb145fb0fe596)
   
   <details><summary>Run configuration</summary>
   
   ```yaml
   run benchmark clickbench_pushdown
   ```
   
   </details>
   
   <details><summary>CPU Details (lscpu)</summary>
   
   ```
   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>
   
   <details><summary>Details</summary>
   <p>
   
   ```
   Comparing HEAD and benchmark-21566
   --------------------
   Benchmark clickbench_pushdown.json
   --------------------
   ┏━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┓
   ┃ Query     ┃       HEAD ┃ benchmark-21566 ┃       Change ┃
   ┑━━━━━━━━━━━╇━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━┩
   β”‚ QQuery 0  β”‚    1.29 ms β”‚         1.22 ms β”‚    no change β”‚
   β”‚ QQuery 1  β”‚   12.68 ms β”‚        12.98 ms β”‚    no change β”‚
   β”‚ QQuery 2  β”‚   37.52 ms β”‚        37.01 ms β”‚    no change β”‚
   β”‚ QQuery 3  β”‚   31.06 ms β”‚        30.94 ms β”‚    no change β”‚
   β”‚ QQuery 4  β”‚  228.27 ms β”‚       226.36 ms β”‚    no change β”‚
   β”‚ QQuery 5  β”‚  277.37 ms β”‚       271.61 ms β”‚    no change β”‚
   β”‚ QQuery 6  β”‚    1.31 ms β”‚         1.25 ms β”‚    no change β”‚
   β”‚ QQuery 7  β”‚   16.55 ms β”‚        16.47 ms β”‚    no change β”‚
   β”‚ QQuery 8  β”‚  332.55 ms β”‚       324.07 ms β”‚    no change β”‚
   β”‚ QQuery 9  β”‚  454.05 ms β”‚       447.49 ms β”‚    no change β”‚
   β”‚ QQuery 10 β”‚   94.18 ms β”‚        93.71 ms β”‚    no change β”‚
   β”‚ QQuery 11 β”‚  104.33 ms β”‚       105.44 ms β”‚    no change β”‚
   β”‚ QQuery 12 β”‚  298.58 ms β”‚       298.89 ms β”‚    no change β”‚
   β”‚ QQuery 13 β”‚  402.81 ms β”‚       414.27 ms β”‚    no change β”‚
   β”‚ QQuery 14 β”‚  316.16 ms β”‚       318.66 ms β”‚    no change β”‚
   β”‚ QQuery 15 β”‚  273.18 ms β”‚       270.65 ms β”‚    no change β”‚
   β”‚ QQuery 16 β”‚  612.83 ms β”‚       613.45 ms β”‚    no change β”‚
   β”‚ QQuery 17 β”‚  621.65 ms β”‚       630.95 ms β”‚    no change β”‚
   β”‚ QQuery 18 β”‚ 1250.10 ms β”‚      1257.98 ms β”‚    no change β”‚
   β”‚ QQuery 19 β”‚   28.78 ms β”‚        29.67 ms β”‚    no change β”‚
   β”‚ QQuery 20 β”‚  517.61 ms β”‚       517.40 ms β”‚    no change β”‚
   β”‚ QQuery 21 β”‚  560.39 ms β”‚       567.80 ms β”‚    no change β”‚
   β”‚ QQuery 22 β”‚  911.90 ms β”‚       919.20 ms β”‚    no change β”‚
   β”‚ QQuery 23 β”‚  114.35 ms β”‚       110.70 ms β”‚    no change β”‚
   β”‚ QQuery 24 β”‚   37.27 ms β”‚        37.71 ms β”‚    no change β”‚
   β”‚ QQuery 25 β”‚  139.40 ms β”‚       146.40 ms β”‚ 1.05x slower β”‚
   β”‚ QQuery 26 β”‚   48.72 ms β”‚        50.26 ms β”‚    no change β”‚
   β”‚ QQuery 27 β”‚  562.39 ms β”‚       558.21 ms β”‚    no change β”‚
   β”‚ QQuery 28 β”‚ 2931.93 ms β”‚      2931.35 ms β”‚    no change β”‚
   β”‚ QQuery 29 β”‚   42.30 ms β”‚        41.29 ms β”‚    no change β”‚
   β”‚ QQuery 30 β”‚  311.50 ms β”‚       312.05 ms β”‚    no change β”‚
   β”‚ QQuery 31 β”‚  287.49 ms β”‚       287.35 ms β”‚    no change β”‚
   β”‚ QQuery 32 β”‚  933.88 ms β”‚       969.22 ms β”‚    no change β”‚
   β”‚ QQuery 33 β”‚ 1471.58 ms β”‚      1460.54 ms β”‚    no change β”‚
   β”‚ QQuery 34 β”‚ 1466.59 ms β”‚      1468.24 ms β”‚    no change β”‚
   β”‚ QQuery 35 β”‚  279.60 ms β”‚       287.87 ms β”‚    no change β”‚
   β”‚ QQuery 36 β”‚   66.35 ms β”‚        67.38 ms β”‚    no change β”‚
   β”‚ QQuery 37 β”‚   36.45 ms β”‚        36.46 ms β”‚    no change β”‚
   β”‚ QQuery 38 β”‚   34.54 ms β”‚        39.25 ms β”‚ 1.14x slower β”‚
   β”‚ QQuery 39 β”‚  129.93 ms β”‚       134.85 ms β”‚    no change β”‚
   β”‚ QQuery 40 β”‚   18.05 ms β”‚        18.24 ms β”‚    no change β”‚
   β”‚ QQuery 41 β”‚   16.75 ms β”‚        17.26 ms β”‚    no change β”‚
   β”‚ QQuery 42 β”‚   14.54 ms β”‚        14.64 ms β”‚    no change β”‚
   β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜
   ┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┓
   ┃ Benchmark Summary              ┃            ┃
   ┑━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━┩
   β”‚ Total Time (HEAD)              β”‚ 16328.79ms β”‚
   β”‚ Total Time (benchmark-21566)   β”‚ 16396.73ms β”‚
   β”‚ Average Time (HEAD)            β”‚   379.74ms β”‚
   β”‚ Average Time (benchmark-21566) β”‚   381.32ms β”‚
   β”‚ Queries Faster                 β”‚          0 β”‚
   β”‚ Queries Slower                 β”‚          2 β”‚
   β”‚ Queries with No Change         β”‚         41 β”‚
   β”‚ Queries with Failure           β”‚          0 β”‚
   β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜
   
   Distribution per query (min / mean Β±stddev / max):
   
   Comparing HEAD and benchmark-21566
   --------------------
   Benchmark clickbench_pushdown.json
   --------------------
   ┏━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┓
   ┃ Query     ┃                                  HEAD ┃                       benchmark-21566 ┃        Change ┃
   ┑━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━┩
   β”‚ QQuery 0  β”‚          1.29 / 4.00 Β±5.33 / 14.66 ms β”‚          1.22 / 3.95 Β±5.35 / 14.65 ms β”‚     no change β”‚
   β”‚ QQuery 1  β”‚        12.68 / 12.90 Β±0.25 / 13.35 ms β”‚        12.98 / 13.21 Β±0.18 / 13.48 ms β”‚     no change β”‚
   β”‚ QQuery 2  β”‚        37.52 / 37.93 Β±0.27 / 38.25 ms β”‚        37.01 / 37.24 Β±0.19 / 37.48 ms β”‚     no change β”‚
   β”‚ QQuery 3  β”‚        31.06 / 31.51 Β±0.58 / 32.66 ms β”‚        30.94 / 31.54 Β±0.50 / 32.47 ms β”‚     no change β”‚
   β”‚ QQuery 4  β”‚     228.27 / 233.32 Β±4.37 / 241.06 ms β”‚     226.36 / 229.61 Β±2.66 / 233.74 ms β”‚     no change β”‚
   β”‚ QQuery 5  β”‚     277.37 / 281.02 Β±2.53 / 284.15 ms β”‚     271.61 / 274.88 Β±4.11 / 282.95 ms β”‚     no change β”‚
   β”‚ QQuery 6  β”‚           1.31 / 1.46 Β±0.23 / 1.92 ms β”‚           1.25 / 1.40 Β±0.21 / 1.81 ms β”‚     no change β”‚
   β”‚ QQuery 7  β”‚        16.55 / 16.65 Β±0.07 / 16.74 ms β”‚        16.47 / 16.59 Β±0.10 / 16.70 ms β”‚     no change β”‚
   β”‚ QQuery 8  β”‚     332.55 / 335.95 Β±1.95 / 338.31 ms β”‚     324.07 / 328.82 Β±3.29 / 332.86 ms β”‚     no change β”‚
   β”‚ QQuery 9  β”‚    454.05 / 469.55 Β±14.70 / 497.54 ms β”‚    447.49 / 465.78 Β±12.70 / 486.12 ms β”‚     no change β”‚
   β”‚ QQuery 10 β”‚        94.18 / 95.21 Β±1.00 / 96.47 ms β”‚       93.71 / 97.07 Β±3.95 / 104.79 ms β”‚     no change β”‚
   β”‚ QQuery 11 β”‚     104.33 / 105.31 Β±0.58 / 106.10 ms β”‚     105.44 / 106.63 Β±1.07 / 108.38 ms β”‚     no change β”‚
   β”‚ QQuery 12 β”‚     298.58 / 303.06 Β±3.86 / 307.59 ms β”‚     298.89 / 306.84 Β±5.73 / 315.79 ms β”‚     no change β”‚
   β”‚ QQuery 13 β”‚    402.81 / 421.12 Β±16.92 / 444.54 ms β”‚     414.27 / 422.83 Β±8.83 / 437.43 ms β”‚     no change β”‚
   β”‚ QQuery 14 β”‚     316.16 / 318.16 Β±1.52 / 319.89 ms β”‚     318.66 / 324.39 Β±7.50 / 338.89 ms β”‚     no change β”‚
   β”‚ QQuery 15 β”‚     273.18 / 279.61 Β±6.92 / 292.95 ms β”‚    270.65 / 289.63 Β±10.01 / 299.23 ms β”‚     no change β”‚
   β”‚ QQuery 16 β”‚     612.83 / 618.33 Β±3.96 / 623.55 ms β”‚     613.45 / 620.75 Β±5.85 / 630.88 ms β”‚     no change β”‚
   β”‚ QQuery 17 β”‚    621.65 / 634.53 Β±11.19 / 654.95 ms β”‚     630.95 / 639.17 Β±6.81 / 651.40 ms β”‚     no change β”‚
   β”‚ QQuery 18 β”‚ 1250.10 / 1276.03 Β±17.95 / 1299.82 ms β”‚ 1257.98 / 1280.99 Β±20.08 / 1304.32 ms β”‚     no change β”‚
   β”‚ QQuery 19 β”‚       28.78 / 41.56 Β±14.79 / 61.26 ms β”‚        29.67 / 34.83 Β±9.77 / 54.36 ms β”‚ +1.19x faster β”‚
   β”‚ QQuery 20 β”‚     517.61 / 528.72 Β±5.62 / 532.79 ms β”‚     517.40 / 524.34 Β±6.49 / 534.30 ms β”‚     no change β”‚
   β”‚ QQuery 21 β”‚     560.39 / 569.70 Β±9.16 / 582.66 ms β”‚     567.80 / 579.66 Β±9.88 / 595.79 ms β”‚     no change β”‚
   β”‚ QQuery 22 β”‚     911.90 / 917.64 Β±4.18 / 923.12 ms β”‚     919.20 / 929.73 Β±7.19 / 939.83 ms β”‚     no change β”‚
   β”‚ QQuery 23 β”‚     114.35 / 123.43 Β±9.59 / 141.48 ms β”‚    110.70 / 121.10 Β±10.29 / 139.30 ms β”‚     no change β”‚
   β”‚ QQuery 24 β”‚        37.27 / 37.60 Β±0.25 / 37.92 ms β”‚        37.71 / 39.20 Β±1.54 / 42.12 ms β”‚     no change β”‚
   β”‚ QQuery 25 β”‚     139.40 / 148.62 Β±8.64 / 160.99 ms β”‚     146.40 / 151.13 Β±3.96 / 156.97 ms β”‚     no change β”‚
   β”‚ QQuery 26 β”‚        48.72 / 52.11 Β±5.29 / 62.63 ms β”‚        50.26 / 51.55 Β±1.39 / 53.94 ms β”‚     no change β”‚
   β”‚ QQuery 27 β”‚    562.39 / 576.79 Β±11.68 / 595.00 ms β”‚     558.21 / 572.25 Β±7.81 / 580.59 ms β”‚     no change β”‚
   β”‚ QQuery 28 β”‚ 2931.93 / 2947.59 Β±14.74 / 2965.06 ms β”‚ 2931.35 / 2957.08 Β±26.84 / 3008.58 ms β”‚     no change β”‚
   β”‚ QQuery 29 β”‚       42.30 / 50.83 Β±11.07 / 70.24 ms β”‚       41.29 / 56.97 Β±18.17 / 84.32 ms β”‚  1.12x slower β”‚
   β”‚ QQuery 30 β”‚     311.50 / 318.69 Β±4.03 / 322.31 ms β”‚     312.05 / 319.18 Β±6.04 / 329.24 ms β”‚     no change β”‚
   β”‚ QQuery 31 β”‚    287.49 / 302.00 Β±18.07 / 334.88 ms β”‚     287.35 / 296.14 Β±6.35 / 303.67 ms β”‚     no change β”‚
   β”‚ QQuery 32 β”‚    933.88 / 955.34 Β±16.90 / 978.54 ms β”‚   969.22 / 988.96 Β±13.78 / 1009.80 ms β”‚     no change β”‚
   β”‚ QQuery 33 β”‚ 1471.58 / 1481.23 Β±11.11 / 1502.76 ms β”‚ 1460.54 / 1496.23 Β±23.62 / 1532.09 ms β”‚     no change β”‚
   β”‚ QQuery 34 β”‚ 1466.59 / 1488.77 Β±17.34 / 1517.28 ms β”‚ 1468.24 / 1497.19 Β±16.01 / 1517.53 ms β”‚     no change β”‚
   β”‚ QQuery 35 β”‚    279.60 / 313.70 Β±30.35 / 366.07 ms β”‚     287.87 / 296.84 Β±4.95 / 302.60 ms β”‚ +1.06x faster β”‚
   β”‚ QQuery 36 β”‚        66.35 / 70.11 Β±2.55 / 74.24 ms β”‚        67.38 / 72.88 Β±4.01 / 77.98 ms β”‚     no change β”‚
   β”‚ QQuery 37 β”‚        36.45 / 40.03 Β±3.85 / 46.25 ms β”‚        36.46 / 39.42 Β±2.50 / 42.46 ms β”‚     no change β”‚
   β”‚ QQuery 38 β”‚        34.54 / 36.77 Β±1.75 / 38.73 ms β”‚        39.25 / 47.48 Β±7.62 / 60.61 ms β”‚  1.29x slower β”‚
   β”‚ QQuery 39 β”‚    129.93 / 146.06 Β±12.33 / 167.95 ms β”‚     134.85 / 144.01 Β±7.13 / 154.66 ms β”‚     no change β”‚
   β”‚ QQuery 40 β”‚        18.05 / 18.17 Β±0.10 / 18.34 ms β”‚        18.24 / 21.02 Β±3.76 / 28.36 ms β”‚  1.16x slower β”‚
   β”‚ QQuery 41 β”‚        16.75 / 17.04 Β±0.30 / 17.59 ms β”‚        17.26 / 21.60 Β±8.37 / 38.33 ms β”‚  1.27x slower β”‚
   β”‚ QQuery 42 β”‚        14.54 / 14.62 Β±0.09 / 14.78 ms β”‚        14.64 / 16.66 Β±3.88 / 24.42 ms β”‚  1.14x slower β”‚
   β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜
   ┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┓
   ┃ Benchmark Summary              ┃            ┃
   ┑━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━┩
   β”‚ Total Time (HEAD)              β”‚ 16672.78ms β”‚
   β”‚ Total Time (benchmark-21566)   β”‚ 16766.76ms β”‚
   β”‚ Average Time (HEAD)            β”‚   387.74ms β”‚
   β”‚ Average Time (benchmark-21566) β”‚   389.92ms β”‚
   β”‚ Queries Faster                 β”‚          2 β”‚
   β”‚ Queries Slower                 β”‚          5 β”‚
   β”‚ Queries with No Change         β”‚         36 β”‚
   β”‚ Queries with Failure           β”‚          0 β”‚
   β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜
   ```
   
   </p>
   </details>
   
   <details><summary>Resource Usage</summary>
   
   **clickbench_pushdown β€” base (merge-base)**
   | Metric | Value |
   |--------|-------|
   | Wall time | 85.0s |
   | Peak memory | 10.1 GiB |
   | Avg memory | 4.7 GiB |
   | CPU user | 852.8s |
   | CPU sys | 57.1s |
   | Peak spill | 0 B |
   
   **clickbench_pushdown β€” branch**
   | Metric | Value |
   |--------|-------|
   | Wall time | 85.0s |
   | Peak memory | 11.4 GiB |
   | Avg memory | 4.9 GiB |
   | CPU user | 854.7s |
   | CPU sys | 61.8s |
   | Peak spill | 0 B |
   
   </details>
   
   
   ---
   [File an issue](https://github.com/adriangb/datafusion-benchmarking/issues) against this benchmark runner


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [PR] DRAFT investigate benchmark 21566 [datafusion]

Posted by "kumarUjjawal (via GitHub)" <gi...@apache.org>.
kumarUjjawal commented on PR #24214:
URL: https://github.com/apache/datafusion/pull/24214#issuecomment-5240898914

   Hi @kosiew I think you will merge main to the pr branch and then rerun the bench.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [PR] DRAFT investigate benchmark 21566 [datafusion]

Posted by "adriangbot (via GitHub)" <gi...@apache.org>.
adriangbot commented on PR #24214:
URL: https://github.com/apache/datafusion/pull/24214#issuecomment-5264654432

   πŸ€– Benchmark running (GKE) | [trigger](https://github.com/apache/datafusion/pull/24214#issuecomment-5264626678)
   **Instance:** `c4a-highmem-16` (12 vCPU / 65 GiB) | `Linux bench-c5264626678-1564-hnfnk 6.12.85+ #1 SMP Wed Jun 17 20:31:55 UTC 2026 aarch64 GNU/Linux`
   <details><summary>CPU Details (lscpu)</summary>
   
   ```
   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 benchmark-21566 (9ecb48a8a78d32a88764613a8ccdb145fb0fe596) to c08832d (merge-base) [diff](https://github.com/apache/datafusion/compare/c08832d481cea2dcea98e43393e3dd640d421064..9ecb48a8a78d32a88764613a8ccdb145fb0fe596)
   
   <details><summary>Run configuration</summary>
   
   ```yaml
   run benchmark clickbench_pushdown
   ```
   
   </details>
   
   Results will be posted here when complete
   
   ---
   [File an issue](https://github.com/adriangb/datafusion-benchmarking/issues) against this benchmark runner


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [PR] DRAFT investigate benchmark 21566 [datafusion]

Posted by "adriangbot (via GitHub)" <gi...@apache.org>.
adriangbot commented on PR #24214:
URL: https://github.com/apache/datafusion/pull/24214#issuecomment-5274985335

   πŸ€– Benchmark running (GKE) | [trigger](https://github.com/apache/datafusion/pull/24214#issuecomment-5274969444)
   **Instance:** `c4a-highmem-16` (12 vCPU / 65 GiB) | `Linux bench-c5274969444-1571-pwdk6 6.12.85+ #1 SMP Wed Jun 17 20:31:55 UTC 2026 aarch64 GNU/Linux`
   <details><summary>CPU Details (lscpu)</summary>
   
   ```
   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 benchmark-21566 (0532fff11a2b2bf9aeda454f0f888232fd957f32) to c08832d (merge-base) [diff](https://github.com/apache/datafusion/compare/c08832d481cea2dcea98e43393e3dd640d421064..0532fff11a2b2bf9aeda454f0f888232fd957f32)
   
   <details><summary>Run configuration</summary>
   
   ```yaml
   run benchmark clickbench_pushdown
   ```
   
   </details>
   
   Results will be posted here when complete
   
   ---
   [File an issue](https://github.com/adriangb/datafusion-benchmarking/issues) against this benchmark runner


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [PR] DRAFT investigate benchmark 21566 [datafusion]

Posted by "kosiew (via GitHub)" <gi...@apache.org>.
kosiew commented on PR #24214:
URL: https://github.com/apache/datafusion/pull/24214#issuecomment-5275762820

   0532fff11a - investigate benchmark (2 hours ago)
   00b25b89c1 - Revert to 67947b6b90: Add any_value aggregate function (#23043) (2 hours ago)
   
   branch is now similar to https://github.com/apache/datafusion/pull/21566#issuecomment-5018607417
   
   but branch vs base - [no perf change](https://github.com/apache/datafusion/pull/24214#issuecomment-5275128289)
   ie [my hypothesis about base caused perf benchmark change is not correct](https://github.com/apache/datafusion/pull/24214#issuecomment-5263718481).
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org