adriangbot commented on PR #25715: URL: https://github.com/apache/datafusion/pull/25715#issuecomment-5820416293
π€ Benchmark completed (GKE) | [trigger](https://github.com/apache/datafusion/pull/25715#issuecomment-5820226337) **Instance:** `c4a-highmem-16` (12 vCPU / 65 GiB) Comparing optional-filter-adaptive-default (32d0a7b5c2fb2bcd43ab96836ec510d004b9932f) to 95bb0a0 (merge-base) [diff](https://github.com/apache/datafusion/compare/95bb0a0dfa48ca20d017faa55b2fc96ee2f300fe..32d0a7b5c2fb2bcd43ab96836ec510d004b9932f) <details><summary>Run configuration</summary> ```yaml run benchmark tpcds changed: env: DATAFUSION_EXECUTION_PARQUET_PUSHDOWN_FILTERS: "true" ``` </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 optional-filter-adaptive-default -------------------- Benchmark tpcds_sf1.json -------------------- βββββββββββββ³βββββββββββββ³βββββββββββββββββββββββββββββββββββ³βββββββββββββββββ β Query β HEAD β optional-filter-adaptive-default β Change β β‘βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ© β QQuery 1 β 5.48 ms β 5.17 ms β +1.06x faster β β QQuery 2 β 80.52 ms β 45.27 ms β +1.78x faster β β QQuery 3 β 29.12 ms β 26.98 ms β +1.08x faster β β QQuery 4 β 434.79 ms β 340.04 ms β +1.28x faster β β QQuery 5 β 51.16 ms β 47.72 ms β +1.07x faster β β QQuery 6 β 35.95 ms β 30.65 ms β +1.17x faster β β QQuery 7 β 75.16 ms β 82.69 ms β 1.10x slower β β QQuery 8 β 36.23 ms β 14.68 ms β +2.47x faster β β QQuery 9 β 52.13 ms β 110.64 ms β 2.12x slower β β QQuery 10 β 62.51 ms β 71.99 ms β 1.15x slower β β QQuery 11 β 265.09 ms β 202.45 ms β +1.31x faster β β QQuery 12 β 28.61 ms β 28.16 ms β no change β β QQuery 13 β 118.69 ms β 115.00 ms β no change β β QQuery 14 β 395.13 ms β 392.33 ms β no change β β QQuery 15 β 54.37 ms β 20.75 ms β +2.62x faster β β QQuery 16 β 6.40 ms β 5.91 ms β +1.08x faster β β QQuery 17 β 78.71 ms β 86.78 ms β 1.10x slower β β QQuery 18 β 103.10 ms β 115.85 ms β 1.12x slower β β QQuery 19 β 41.66 ms β 39.40 ms β +1.06x faster β β QQuery 20 β 35.34 ms β 30.69 ms β +1.15x faster β β QQuery 21 β 17.03 ms β 18.80 ms β 1.10x slower β β QQuery 22 β 62.59 ms β 62.30 ms β no change β β QQuery 23 β 307.05 ms β 351.28 ms β 1.14x slower β β QQuery 24 β 190.24 ms β 162.39 ms β +1.17x faster β β QQuery 25 β 106.01 ms β 93.95 ms β +1.13x faster β β QQuery 26 β 46.94 ms β 64.07 ms β 1.36x slower β β QQuery 27 β 5.97 ms β 6.02 ms β no change β β QQuery 28 β 59.70 ms β 73.63 ms β 1.23x slower β β QQuery 29 β 92.93 ms β 100.51 ms β 1.08x slower β β QQuery 30 β 32.38 ms β 32.91 ms β no change β β QQuery 31 β 107.89 ms β 120.47 ms β 1.12x slower β β QQuery 32 β 19.65 ms β 21.22 ms β 1.08x slower β β QQuery 33 β 37.24 ms β 39.05 ms β no change β β QQuery 34 β 10.05 ms β 10.34 ms β no change β β QQuery 35 β 70.90 ms β 82.42 ms β 1.16x slower β β QQuery 36 β 5.78 ms β 5.59 ms β no change β β QQuery 37 β 6.74 ms β 6.95 ms β no change β β QQuery 38 β 59.94 ms β 76.33 ms β 1.27x slower β β QQuery 39 β 72.85 ms β 68.87 ms β +1.06x faster β β QQuery 40 β 23.66 ms β 19.83 ms β +1.19x faster β β QQuery 41 β 11.14 ms β 12.03 ms β 1.08x slower β β QQuery 42 β 23.69 ms β 23.63 ms β no change β β QQuery 43 β 5.22 ms β 4.80 ms β +1.09x faster β β QQuery 44 β 9.09 ms β 8.99 ms β no change β β QQuery 45 β 36.37 ms β 24.87 ms β +1.46x faster β β QQuery 46 β 11.36 ms β 12.21 ms β 1.07x slower β β QQuery 47 β 218.95 ms β 218.78 ms β no change β β QQuery 48 β 96.22 ms β 122.99 ms β 1.28x slower β β QQuery 49 β 68.96 ms β 86.98 ms β 1.26x slower β β QQuery 50 β 57.71 ms β 69.12 ms β 1.20x slower β β QQuery 51 β 92.25 ms β 100.84 ms β 1.09x slower β β QQuery 52 β 23.85 ms β 24.50 ms β no change β β QQuery 53 β 28.64 ms β 30.34 ms β 1.06x slower β β QQuery 54 β 53.49 ms β 28.36 ms β +1.89x faster β β QQuery 55 β 23.49 ms β 23.26 ms β no change β β QQuery 56 β 38.02 ms β 34.62 ms β +1.10x faster β β QQuery 57 β 166.71 ms β 134.36 ms β +1.24x faster β β QQuery 58 β 109.11 ms β 64.11 ms β +1.70x faster β β QQuery 59 β 116.93 ms β 80.46 ms β +1.45x faster β β QQuery 60 β 38.87 ms β 38.30 ms β no change β β QQuery 61 β 11.36 ms β 11.13 ms β no change β β QQuery 62 β 44.89 ms β 38.34 ms β +1.17x faster β β QQuery 63 β 29.29 ms β 30.78 ms β 1.05x slower β β QQuery 64 β 357.48 ms β 310.89 ms β +1.15x faster β β QQuery 65 β 131.09 ms β 157.78 ms β 1.20x slower β β QQuery 66 β 76.38 ms β 64.30 ms β +1.19x faster β β QQuery 67 β 238.42 ms β 250.96 ms β 1.05x slower β β QQuery 68 β 11.63 ms β 11.76 ms β no change β β QQuery 69 β 56.18 ms β 69.24 ms β 1.23x slower β β QQuery 70 β 102.40 ms β 113.63 ms β 1.11x slower β β QQuery 71 β 35.05 ms β 31.83 ms β +1.10x faster β β QQuery 72 β 1745.97 ms β 104.13 ms β +16.77x faster β β QQuery 73 β 9.89 ms β 9.93 ms β no change β β QQuery 74 β 156.98 ms β 132.43 ms β +1.19x faster β β QQuery 75 β 141.28 ms β 157.22 ms β 1.11x slower β β QQuery 76 β 34.46 ms β 40.52 ms β 1.18x slower β β QQuery 77 β 60.58 ms β 60.78 ms β no change β β QQuery 78 β 162.40 ms β 116.89 ms β +1.39x faster β β QQuery 79 β 66.16 ms β 68.64 ms β no change β β QQuery 80 β 95.40 ms β 75.26 ms β +1.27x faster β β QQuery 81 β 26.34 ms β 26.71 ms β no change β β QQuery 82 β 16.36 ms β 31.11 ms β 1.90x slower β β QQuery 83 β 32.88 ms β 28.75 ms β +1.14x faster β β QQuery 84 β 29.26 ms β 29.75 ms β no change β β QQuery 85 β 104.18 ms β 122.43 ms β 1.18x slower β β QQuery 86 β 24.97 ms β 30.24 ms β 1.21x slower β β QQuery 87 β 61.08 ms β 76.56 ms β 1.25x slower β β QQuery 88 β 60.82 ms β 65.90 ms β 1.08x slower β β QQuery 89 β 35.16 ms β 42.70 ms β 1.21x slower β β QQuery 90 β 16.48 ms β 17.70 ms β 1.07x slower β β QQuery 91 β 44.62 ms β 46.26 ms β no change β β QQuery 92 β 28.64 ms β 28.62 ms β no change β β QQuery 93 β 49.19 ms β 47.69 ms β no change β β QQuery 94 β 37.91 ms β 35.29 ms β +1.07x faster β β QQuery 95 β 77.73 ms β 64.21 ms β +1.21x faster β β QQuery 96 β 23.56 ms β 25.69 ms β 1.09x slower β β QQuery 97 β 50.63 ms β 53.20 ms β 1.05x slower β β QQuery 98 β 42.42 ms β 38.05 ms β +1.11x faster β β QQuery 99 β 65.91 ms β 53.87 ms β +1.22x faster β βββββββββββββ΄βββββββββββββ΄βββββββββββββββββββββββββββββββββββ΄βββββββββββββββββ βββββββββββββββββββββββββββββββββββββββββββββββββββ³ββββββββββββ β Benchmark Summary β β β‘ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ© β Total Time (HEAD) β 8951.22ms β β Total Time (optional-filter-adaptive-default) β 7094.81ms β β Average Time (HEAD) β 90.42ms β β Average Time (optional-filter-adaptive-default) β 71.66ms β β Queries Faster β 36 β β Queries Slower β 37 β β Queries with No Change β 26 β β Queries with Failure β 0 β βββββββββββββββββββββββββββββββββββββββββββββββββββ΄ββββββββββββ Distribution per query (min / mean Β±stddev / max): Comparing HEAD and optional-filter-adaptive-default -------------------- Benchmark tpcds_sf1.json -------------------- βββββββββββββ³ββββββββββββββββββββββββββββββββββββββββ³βββββββββββββββββββββββββββββββββββββ³βββββββββββββββββ β Query β HEAD β optional-filter-adaptive-default β Change β β‘ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ© β QQuery 1 β 5.48 / 6.00 Β±0.87 / 7.73 ms β 5.17 / 5.72 Β±1.00 / 7.72 ms β no change β β QQuery 2 β 80.52 / 81.48 Β±0.82 / 82.50 ms β 45.27 / 45.84 Β±0.36 / 46.36 ms β +1.78x faster β β QQuery 3 β 29.12 / 29.22 Β±0.11 / 29.42 ms β 26.98 / 27.19 Β±0.17 / 27.47 ms β +1.07x faster β β QQuery 4 β 434.79 / 437.50 Β±2.19 / 440.54 ms β 340.04 / 344.23 Β±3.56 / 349.71 ms β +1.27x faster β β QQuery 5 β 51.16 / 51.48 Β±0.18 / 51.65 ms β 47.72 / 48.26 Β±0.60 / 49.36 ms β +1.07x faster β β QQuery 6 β 35.95 / 36.49 Β±0.37 / 36.91 ms β 30.65 / 30.94 Β±0.18 / 31.14 ms β +1.18x faster β β QQuery 7 β 75.16 / 75.54 Β±0.27 / 75.97 ms β 82.69 / 83.25 Β±0.60 / 84.39 ms β 1.10x slower β β QQuery 8 β 36.23 / 36.52 Β±0.26 / 37.00 ms β 14.68 / 16.40 Β±3.00 / 22.40 ms β +2.23x faster β β QQuery 9 β 52.13 / 53.10 Β±0.83 / 54.15 ms β 110.64 / 115.70 Β±2.87 / 119.38 ms β 2.18x slower β β QQuery 10 β 62.51 / 62.88 Β±0.23 / 63.22 ms β 71.99 / 72.26 Β±0.22 / 72.64 ms β 1.15x slower β β QQuery 11 β 265.09 / 267.96 Β±2.55 / 272.67 ms β 202.45 / 203.63 Β±1.11 / 205.70 ms β +1.32x faster β β QQuery 12 β 28.61 / 28.98 Β±0.37 / 29.56 ms β 28.16 / 31.17 Β±3.71 / 38.32 ms β 1.08x slower β β QQuery 13 β 118.69 / 119.74 Β±0.95 / 121.38 ms β 115.00 / 119.29 Β±3.64 / 124.48 ms β no change β β QQuery 14 β 395.13 / 399.37 Β±3.47 / 403.62 ms β 392.33 / 395.86 Β±2.28 / 398.41 ms β no change β β QQuery 15 β 54.37 / 54.86 Β±0.29 / 55.21 ms β 20.75 / 21.19 Β±0.30 / 21.53 ms β +2.59x faster β β QQuery 16 β 6.40 / 6.56 Β±0.16 / 6.82 ms β 5.91 / 6.03 Β±0.20 / 6.42 ms β +1.09x faster β β QQuery 17 β 78.71 / 79.34 Β±0.66 / 80.55 ms β 86.78 / 92.45 Β±9.24 / 110.86 ms β 1.17x slower β β QQuery 18 β 103.10 / 104.16 Β±0.68 / 105.01 ms β 115.85 / 118.83 Β±1.58 / 120.56 ms β 1.14x slower β β QQuery 19 β 41.66 / 42.08 Β±0.30 / 42.38 ms β 39.40 / 41.08 Β±1.66 / 43.22 ms β no change β β QQuery 20 β 35.34 / 36.17 Β±0.69 / 37.44 ms β 30.69 / 32.39 Β±1.32 / 34.14 ms β +1.12x faster β β QQuery 21 β 17.03 / 17.29 Β±0.23 / 17.58 ms β 18.80 / 19.09 Β±0.17 / 19.31 ms β 1.10x slower β β QQuery 22 β 62.59 / 63.67 Β±0.89 / 64.72 ms β 62.30 / 62.47 Β±0.13 / 62.64 ms β no change β β QQuery 23 β 307.05 / 310.26 Β±1.75 / 312.28 ms β 351.28 / 357.81 Β±7.17 / 371.17 ms β 1.15x slower β β QQuery 24 β 190.24 / 193.20 Β±3.98 / 200.93 ms β 162.39 / 170.91 Β±11.66 / 193.72 ms β +1.13x faster β β QQuery 25 β 106.01 / 107.80 Β±1.21 / 109.66 ms β 93.95 / 94.77 Β±0.81 / 96.21 ms β +1.14x faster β β QQuery 26 β 46.94 / 47.34 Β±0.32 / 47.71 ms β 64.07 / 67.12 Β±3.86 / 73.47 ms β 1.42x slower β β QQuery 27 β 5.97 / 6.08 Β±0.12 / 6.24 ms β 6.02 / 6.27 Β±0.14 / 6.42 ms β no change β β QQuery 28 β 59.70 / 61.15 Β±1.33 / 63.61 ms β 73.63 / 75.02 Β±1.61 / 77.80 ms β 1.23x slower β β QQuery 29 β 92.93 / 95.21 Β±1.82 / 97.71 ms β 100.51 / 101.27 Β±0.80 / 102.82 ms β 1.06x slower β β QQuery 30 β 32.38 / 32.90 Β±0.54 / 33.82 ms β 32.91 / 37.49 Β±7.65 / 52.77 ms β 1.14x slower β β QQuery 31 β 107.89 / 108.20 Β±0.32 / 108.77 ms β 120.47 / 122.83 Β±2.06 / 125.74 ms β 1.14x slower β β QQuery 32 β 19.65 / 19.96 Β±0.24 / 20.38 ms β 21.22 / 21.56 Β±0.21 / 21.79 ms β 1.08x slower β β QQuery 33 β 37.24 / 39.30 Β±2.79 / 44.73 ms β 39.05 / 40.35 Β±0.89 / 41.36 ms β no change β β QQuery 34 β 10.05 / 10.38 Β±0.23 / 10.73 ms β 10.34 / 11.02 Β±0.62 / 12.06 ms β 1.06x slower β β QQuery 35 β 70.90 / 71.41 Β±0.27 / 71.63 ms β 82.42 / 82.82 Β±0.26 / 83.16 ms β 1.16x slower β β QQuery 36 β 5.78 / 5.95 Β±0.21 / 6.36 ms β 5.59 / 5.75 Β±0.24 / 6.22 ms β no change β β QQuery 37 β 6.74 / 7.34 Β±0.94 / 9.22 ms β 6.95 / 7.10 Β±0.13 / 7.32 ms β no change β β QQuery 38 β 59.94 / 60.63 Β±0.59 / 61.58 ms β 76.33 / 77.13 Β±1.41 / 79.94 ms β 1.27x slower β β QQuery 39 β 72.85 / 75.58 Β±3.23 / 81.84 ms β 68.87 / 70.57 Β±2.63 / 75.77 ms β +1.07x faster β β QQuery 40 β 23.66 / 24.09 Β±0.49 / 25.02 ms β 19.83 / 20.17 Β±0.25 / 20.54 ms β +1.19x faster β β QQuery 41 β 11.14 / 11.40 Β±0.20 / 11.65 ms β 12.03 / 12.17 Β±0.12 / 12.38 ms β 1.07x slower β β QQuery 42 β 23.69 / 23.87 Β±0.14 / 24.10 ms β 23.63 / 24.01 Β±0.39 / 24.69 ms β no change β β QQuery 43 β 5.22 / 5.97 Β±1.28 / 8.51 ms β 4.80 / 4.91 Β±0.18 / 5.28 ms β +1.21x faster β β QQuery 44 β 9.09 / 9.32 Β±0.19 / 9.65 ms β 8.99 / 9.14 Β±0.16 / 9.45 ms β no change β β QQuery 45 β 36.37 / 38.24 Β±1.12 / 39.59 ms β 24.87 / 25.07 Β±0.22 / 25.38 ms β +1.53x faster β β QQuery 46 β 11.36 / 11.74 Β±0.43 / 12.55 ms β 12.21 / 12.45 Β±0.27 / 12.95 ms β 1.06x slower β β QQuery 47 β 218.95 / 221.21 Β±2.72 / 226.48 ms β 218.78 / 220.85 Β±1.66 / 223.80 ms β no change β β QQuery 48 β 96.22 / 96.93 Β±0.73 / 98.26 ms β 122.99 / 128.05 Β±6.71 / 141.05 ms β 1.32x slower β β QQuery 49 β 68.96 / 69.49 Β±0.31 / 69.86 ms β 86.98 / 91.27 Β±7.89 / 107.04 ms β 1.31x slower β β QQuery 50 β 57.71 / 59.69 Β±2.90 / 65.35 ms β 69.12 / 69.63 Β±0.58 / 70.68 ms β 1.17x slower β β QQuery 51 β 92.25 / 93.98 Β±0.90 / 94.67 ms β 100.84 / 102.36 Β±1.21 / 104.18 ms β 1.09x slower β β QQuery 52 β 23.85 / 24.09 Β±0.26 / 24.50 ms β 24.50 / 27.60 Β±5.42 / 38.43 ms β 1.15x slower β β QQuery 53 β 28.64 / 28.78 Β±0.14 / 28.96 ms β 30.34 / 30.73 Β±0.26 / 31.02 ms β 1.07x slower β β QQuery 54 β 53.49 / 55.73 Β±3.77 / 63.26 ms β 28.36 / 30.43 Β±1.45 / 32.52 ms β +1.83x faster β β QQuery 55 β 23.49 / 23.98 Β±0.43 / 24.66 ms β 23.26 / 23.51 Β±0.27 / 23.98 ms β no change β β QQuery 56 β 38.02 / 38.81 Β±0.47 / 39.45 ms β 34.62 / 34.84 Β±0.14 / 35.03 ms β +1.11x faster β β QQuery 57 β 166.71 / 169.53 Β±2.67 / 173.76 ms β 134.36 / 137.22 Β±3.77 / 144.64 ms β +1.24x faster β β QQuery 58 β 109.11 / 110.76 Β±1.05 / 112.39 ms β 64.11 / 64.84 Β±0.61 / 65.67 ms β +1.71x faster β β QQuery 59 β 116.93 / 117.55 Β±0.37 / 118.00 ms β 80.46 / 82.77 Β±2.71 / 86.85 ms β +1.42x faster β β QQuery 60 β 38.87 / 39.60 Β±0.72 / 40.85 ms β 38.30 / 39.01 Β±0.52 / 39.82 ms β no change β β QQuery 61 β 11.36 / 11.61 Β±0.26 / 12.07 ms β 11.13 / 11.32 Β±0.19 / 11.59 ms β no change β β QQuery 62 β 44.89 / 45.44 Β±0.63 / 46.67 ms β 38.34 / 38.64 Β±0.22 / 38.92 ms β +1.18x faster β β QQuery 63 β 29.29 / 30.77 Β±2.46 / 35.65 ms β 30.78 / 30.88 Β±0.11 / 31.10 ms β no change β β QQuery 64 β 357.48 / 361.07 Β±4.60 / 370.09 ms β 310.89 / 321.55 Β±8.60 / 332.73 ms β +1.12x faster β β QQuery 65 β 131.09 / 133.08 Β±1.19 / 134.73 ms β 157.78 / 161.77 Β±3.69 / 167.93 ms β 1.22x slower β β QQuery 66 β 76.38 / 77.05 Β±0.40 / 77.60 ms β 64.30 / 64.61 Β±0.40 / 65.36 ms β +1.19x faster β β QQuery 67 β 238.42 / 241.70 Β±3.31 / 247.63 ms β 250.96 / 255.67 Β±4.63 / 262.56 ms β 1.06x slower β β QQuery 68 β 11.63 / 11.89 Β±0.25 / 12.38 ms β 11.76 / 11.99 Β±0.27 / 12.49 ms β no change β β QQuery 69 β 56.18 / 57.35 Β±1.84 / 61.01 ms β 69.24 / 74.24 Β±7.01 / 87.73 ms β 1.29x slower β β QQuery 70 β 102.40 / 103.69 Β±0.81 / 104.82 ms β 113.63 / 115.84 Β±1.55 / 118.40 ms β 1.12x slower β β QQuery 71 β 35.05 / 36.14 Β±1.60 / 39.27 ms β 31.83 / 32.30 Β±0.46 / 33.02 ms β +1.12x faster β β QQuery 72 β 1745.97 / 1844.49 Β±62.30 / 1917.99 ms β 104.13 / 108.34 Β±6.57 / 121.41 ms β +17.03x faster β β QQuery 73 β 9.89 / 10.39 Β±0.40 / 11.02 ms β 9.93 / 10.21 Β±0.18 / 10.44 ms β no change β β QQuery 74 β 156.98 / 158.80 Β±1.45 / 160.48 ms β 132.43 / 135.48 Β±4.74 / 144.88 ms β +1.17x faster β β QQuery 75 β 141.28 / 143.09 Β±1.55 / 145.49 ms β 157.22 / 158.83 Β±2.01 / 162.74 ms β 1.11x slower β β QQuery 76 β 34.46 / 37.21 Β±4.97 / 47.14 ms β 40.52 / 42.41 Β±2.44 / 47.12 ms β 1.14x slower β β QQuery 77 β 60.58 / 61.04 Β±0.27 / 61.32 ms β 60.78 / 61.48 Β±0.51 / 62.36 ms β no change β β QQuery 78 β 162.40 / 165.80 Β±1.80 / 167.68 ms β 116.89 / 119.88 Β±3.35 / 126.24 ms β +1.38x faster β β QQuery 79 β 66.16 / 66.82 Β±0.38 / 67.33 ms β 68.64 / 69.44 Β±0.59 / 70.32 ms β no change β β QQuery 80 β 95.40 / 98.42 Β±4.35 / 106.99 ms β 75.26 / 76.60 Β±1.16 / 78.76 ms β +1.28x faster β β QQuery 81 β 26.34 / 26.60 Β±0.24 / 27.05 ms β 26.71 / 26.92 Β±0.13 / 27.12 ms β no change β β QQuery 82 β 16.36 / 16.46 Β±0.10 / 16.64 ms β 31.11 / 35.32 Β±4.58 / 42.47 ms β 2.15x slower β β QQuery 83 β 32.88 / 33.13 Β±0.25 / 33.54 ms β 28.75 / 29.29 Β±0.31 / 29.62 ms β +1.13x faster β β QQuery 84 β 29.26 / 30.29 Β±1.37 / 32.89 ms β 29.75 / 29.90 Β±0.13 / 30.07 ms β no change β β QQuery 85 β 104.18 / 106.62 Β±2.61 / 111.42 ms β 122.43 / 124.03 Β±1.92 / 127.71 ms β 1.16x slower β β QQuery 86 β 24.97 / 25.45 Β±0.32 / 25.83 ms β 30.24 / 34.36 Β±4.78 / 40.27 ms β 1.35x slower β β QQuery 87 β 61.08 / 62.21 Β±0.93 / 63.69 ms β 76.56 / 78.23 Β±2.02 / 82.04 ms β 1.26x slower β β QQuery 88 β 60.82 / 61.12 Β±0.17 / 61.31 ms β 65.90 / 67.87 Β±1.71 / 71.05 ms β 1.11x slower β β QQuery 89 β 35.16 / 36.67 Β±2.79 / 42.25 ms β 42.70 / 45.62 Β±4.53 / 54.62 ms β 1.24x slower β β QQuery 90 β 16.48 / 16.66 Β±0.17 / 16.93 ms β 17.70 / 17.94 Β±0.23 / 18.33 ms β 1.08x slower β β QQuery 91 β 44.62 / 44.79 Β±0.12 / 44.94 ms β 46.26 / 47.73 Β±1.53 / 50.65 ms β 1.07x slower β β QQuery 92 β 28.64 / 29.02 Β±0.28 / 29.35 ms β 28.62 / 29.80 Β±1.08 / 31.50 ms β no change β β QQuery 93 β 49.19 / 50.05 Β±0.58 / 50.74 ms β 47.69 / 48.60 Β±0.64 / 49.45 ms β no change β β QQuery 94 β 37.91 / 38.94 Β±0.70 / 40.06 ms β 35.29 / 37.22 Β±3.07 / 43.33 ms β no change β β QQuery 95 β 77.73 / 80.08 Β±1.76 / 83.03 ms β 64.21 / 66.78 Β±2.86 / 72.33 ms β +1.20x faster β β QQuery 96 β 23.56 / 23.71 Β±0.13 / 23.91 ms β 25.69 / 25.96 Β±0.22 / 26.22 ms β 1.10x slower β β QQuery 97 β 50.63 / 52.04 Β±1.71 / 55.35 ms β 53.20 / 53.85 Β±0.87 / 55.54 ms β no change β β QQuery 98 β 42.42 / 43.29 Β±0.61 / 44.10 ms β 38.05 / 39.85 Β±1.71 / 42.28 ms β +1.09x faster β β QQuery 99 β 65.91 / 67.83 Β±2.85 / 73.46 ms β 53.87 / 57.67 Β±4.38 / 65.94 ms β +1.18x faster β βββββββββββββ΄ββββββββββββββββββββββββββββββββββββββββ΄βββββββββββββββββββββββββββββββββββββ΄βββββββββββββββββ βββββββββββββββββββββββββββββββββββββββββββββββββββ³ββββββββββββ β Benchmark Summary β β β‘ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ© β Total Time (HEAD) β 9158.64ms β β Total Time (optional-filter-adaptive-default) β 7272.51ms β β Average Time (HEAD) β 92.51ms β β Average Time (optional-filter-adaptive-default) β 73.46ms β β Queries Faster β 33 β β Queries Slower β 40 β β Queries with No Change β 26 β β Queries with Failure β 0 β βββββββββββββββββββββββββββββββββββββββββββββββββββ΄ββββββββββββ ``` </p> </details> <details><summary>Resource Usage</summary> **tpcds β base (merge-base)** | Metric | Value | |--------|-------| | Wall time | 50.0s | | Peak memory | 2.2 GiB | | Avg memory | 1.4 GiB | | CPU user | 196.8s | | CPU sys | 5.2s | | Peak spill | 0 B | **tpcds β branch** | Metric | Value | |--------|-------| | Wall time | 40.0s | | Peak memory | 1.7 GiB | | Avg memory | 1.1 GiB | | CPU user | 105.5s | | CPU sys | 5.5s | | 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
