adriangbot commented on PR #25187: URL: https://github.com/apache/datafusion/pull/25187#issuecomment-6085097845
🤖 Benchmark completed (GKE) | [trigger](https://github.com/apache/datafusion/pull/25187#issuecomment-6084785277) **Instance:** `c4a-highmem-16` (12 vCPU / 65 GiB) Comparing 8aea24b85b1e16e0c0e13773935b130e67160853 (8aea24b85b1e16e0c0e13773935b130e67160853) to 31a333da6952047803dcd93b7a80e59ef056ce8e [diff](https://github.com/apache/datafusion/compare/31a333da6952047803dcd93b7a80e59ef056ce8e..8aea24b85b1e16e0c0e13773935b130e67160853) <details><summary>Run configuration</summary> ```yaml run benchmark in_list_rewrite env: BENCH_FILTER: "^in_list_rewrite/.*/list=3$" baseline: ref: "31a333da6952047803dcd93b7a80e59ef056ce8e" changed: ref: "8aea24b85b1e16e0c0e13773935b130e67160853" ``` </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> ``` group HEAD codex_in-list-short-rewrite ----- ---- --------------------------- in_list_rewrite/fixed_size_binary_1/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=3 7.74 26.0±0.39µs 300.9 MElem/sec 1.00 3.4±0.01µs 2.3 GElem/sec in_list_rewrite/fixed_size_binary_1/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=3 6.88 23.5±0.22µs 332.2 MElem/sec 1.00 3.4±0.01µs 2.2 GElem/sec in_list_rewrite/fixed_size_binary_1/balanced/batch=8192/nulls=0%/match=50%/in/list=3 21.42 71.9±1.29µs 108.7 MElem/sec 1.00 3.4±0.01µs 2.3 GElem/sec in_list_rewrite/fixed_size_binary_1/balanced/batch=8192/nulls=0%/match=50%/not_in/list=3 20.77 70.9±0.53µs 110.1 MElem/sec 1.00 3.4±0.01µs 2.2 GElem/sec in_list_rewrite/fixed_size_binary_1/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=3 21.02 72.4±0.21µs 107.9 MElem/sec 1.00 3.4±0.01µs 2.2 GElem/sec in_list_rewrite/fixed_size_binary_1/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=3 20.52 72.0±0.13µs 108.5 MElem/sec 1.00 3.5±0.01µs 2.2 GElem/sec in_list_rewrite/fixed_size_binary_1/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=3 11.28 3.3±0.09µs 18.5 MElem/sec 1.00 292.4±1.97ns 208.7 MElem/sec in_list_rewrite/fixed_size_binary_1/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=3 7.78 2.7±0.08µs 22.6 MElem/sec 1.00 346.7±3.97ns 176.0 MElem/sec in_list_rewrite/fixed_size_binary_1/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=3 21.56 48.7±0.15µs 160.5 MElem/sec 1.00 2.3±0.01µs 3.4 GElem/sec in_list_rewrite/fixed_size_binary_1/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=3 20.79 48.1±0.14µs 162.3 MElem/sec 1.00 2.3±0.01µs 3.3 GElem/sec in_list_rewrite/fixed_size_binary_1/miss/batch=8192/nulls=0%/match=0%/in/list=3 23.00 77.4±2.81µs 101.0 MElem/sec 1.00 3.4±0.04µs 2.3 GElem/sec in_list_rewrite/fixed_size_binary_1/miss/batch=8192/nulls=0%/match=0%/not_in/list=3 20.78 71.0±0.63µs 110.0 MElem/sec 1.00 3.4±0.01µs 2.2 GElem/sec in_list_rewrite/fixed_size_binary_1/single_row_hit/batch=1/nulls=0%/match=100%/in/list=3 2.32 647.9±20.04ns 1507.4 KElem/sec 1.00 279.6±1.22ns 3.4 MElem/sec in_list_rewrite/fixed_size_binary_1/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=3 1.91 635.7±18.26ns 1536.2 KElem/sec 1.00 333.5±2.62ns 2.9 MElem/sec in_list_rewrite/fixed_size_binary_1/single_row_miss/batch=1/nulls=0%/match=0%/in/list=3 6.46 1818.4±65.40ns 537.0 KElem/sec 1.00 281.3±1.50ns 3.4 MElem/sec in_list_rewrite/fixed_size_binary_1/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=3 6.56 2.2±0.06µs 447.7 KElem/sec 1.00 332.7±2.16ns 2.9 MElem/sec in_list_rewrite/fixed_size_binary_1/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3 7.97 26.7±0.60µs 292.7 MElem/sec 1.00 3.3±0.01µs 2.3 GElem/sec in_list_rewrite/fixed_size_binary_1/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=3 20.78 71.0±0.46µs 110.1 MElem/sec 1.00 3.4±0.01µs 2.2 GElem/sec in_list_rewrite/fixed_size_binary_16/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=3 1.64 16.0±0.14µs 488.4 MElem/sec 1.00 9.7±0.02µs 802.3 MElem/sec in_list_rewrite/fixed_size_binary_16/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=3 1.62 15.9±0.13µs 491.1 MElem/sec 1.00 9.8±0.02µs 797.5 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced/batch=8192/nulls=0%/match=50%/in/list=3 5.03 48.9±0.44µs 159.6 MElem/sec 1.00 9.7±0.01µs 803.6 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced/batch=8192/nulls=0%/match=50%/not_in/list=3 5.01 49.0±0.35µs 159.3 MElem/sec 1.00 9.8±0.03µs 797.7 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=3 5.01 49.3±0.12µs 158.6 MElem/sec 1.00 9.8±0.05µs 794.2 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=3 4.96 49.2±0.09µs 158.9 MElem/sec 1.00 9.9±0.02µs 788.2 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=3 9.12 3.1±0.09µs 19.5 MElem/sec 1.00 342.3±6.13ns 178.3 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=3 6.58 2.5±0.08µs 24.0 MElem/sec 1.00 386.7±1.57ns 157.8 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_unaligned/batch=8192/nulls=0%/match=50%/in/list=3 4.28 50.0±0.52µs 156.2 MElem/sec 1.00 11.7±0.04µs 668.9 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_unaligned/batch=8192/nulls=0%/match=50%/not_in/list=3 4.19 49.3±0.47µs 158.6 MElem/sec 1.00 11.8±0.09µs 664.3 MElem/sec in_list_rewrite/fixed_size_binary_16/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=3 4.46 33.5±0.19µs 233.5 MElem/sec 1.00 7.5±0.03µs 1041.3 MElem/sec in_list_rewrite/fixed_size_binary_16/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=3 4.35 33.0±0.12µs 236.9 MElem/sec 1.00 7.6±0.05µs 1029.5 MElem/sec in_list_rewrite/fixed_size_binary_16/miss/batch=8192/nulls=0%/match=0%/in/list=3 4.92 47.8±0.38µs 163.6 MElem/sec 1.00 9.7±0.02µs 804.3 MElem/sec in_list_rewrite/fixed_size_binary_16/miss/batch=8192/nulls=0%/match=0%/not_in/list=3 4.91 48.1±0.35µs 162.5 MElem/sec 1.00 9.8±0.02µs 797.0 MElem/sec in_list_rewrite/fixed_size_binary_16/single_row_hit/batch=1/nulls=0%/match=100%/in/list=3 2.35 644.2±19.73ns 1515.9 KElem/sec 1.00 274.3±1.04ns 3.5 MElem/sec in_list_rewrite/fixed_size_binary_16/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=3 1.98 631.4±16.82ns 1546.6 KElem/sec 1.00 318.4±1.44ns 3.0 MElem/sec in_list_rewrite/fixed_size_binary_16/single_row_miss/batch=1/nulls=0%/match=0%/in/list=3 6.69 1805.3±59.23ns 541.0 KElem/sec 1.00 269.7±1.36ns 3.5 MElem/sec in_list_rewrite/fixed_size_binary_16/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=3 6.84 2.2±0.06µs 447.7 KElem/sec 1.00 319.1±1.61ns 3.0 MElem/sec in_list_rewrite/fixed_size_binary_16/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3 1.96 19.1±0.15µs 409.7 MElem/sec 1.00 9.7±0.02µs 803.5 MElem/sec in_list_rewrite/fixed_size_binary_16/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=3 4.88 47.9±0.44µs 163.2 MElem/sec 1.00 9.8±0.04µs 797.1 MElem/sec in_list_rewrite/fixed_size_binary_2/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=3 5.89 20.8±0.14µs 376.4 MElem/sec 1.00 3.5±0.01µs 2.2 GElem/sec in_list_rewrite/fixed_size_binary_2/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=3 5.82 20.9±0.20µs 374.4 MElem/sec 1.00 3.6±0.01µs 2.1 GElem/sec in_list_rewrite/fixed_size_binary_2/balanced/batch=8192/nulls=0%/match=50%/in/list=3 23.59 83.0±0.45µs 94.2 MElem/sec 1.00 3.5±0.01µs 2.2 GElem/sec in_list_rewrite/fixed_size_binary_2/balanced/batch=8192/nulls=0%/match=50%/not_in/list=3 23.04 82.4±0.42µs 94.8 MElem/sec 1.00 3.6±0.01µs 2.1 GElem/sec in_list_rewrite/fixed_size_binary_2/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=3 24.26 87.6±0.16µs 89.2 MElem/sec 1.00 3.6±0.01µs 2.1 GElem/sec in_list_rewrite/fixed_size_binary_2/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=3 23.63 87.4±0.14µs 89.4 MElem/sec 1.00 3.7±0.01µs 2.1 GElem/sec in_list_rewrite/fixed_size_binary_2/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=3 10.91 3.3±0.10µs 18.6 MElem/sec 1.00 301.5±1.89ns 202.5 MElem/sec in_list_rewrite/fixed_size_binary_2/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=3 7.69 2.7±0.08µs 22.8 MElem/sec 1.00 348.5±2.20ns 175.1 MElem/sec in_list_rewrite/fixed_size_binary_2/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=3 28.86 62.2±0.27µs 125.6 MElem/sec 1.00 2.2±0.01µs 3.5 GElem/sec in_list_rewrite/fixed_size_binary_2/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=3 27.79 61.8±0.52µs 126.4 MElem/sec 1.00 2.2±0.01µs 3.4 GElem/sec in_list_rewrite/fixed_size_binary_2/miss/batch=8192/nulls=0%/match=0%/in/list=3 17.84 62.7±1.42µs 124.6 MElem/sec 1.00 3.5±0.01µs 2.2 GElem/sec in_list_rewrite/fixed_size_binary_2/miss/batch=8192/nulls=0%/match=0%/not_in/list=3 19.30 69.0±0.74µs 113.2 MElem/sec 1.00 3.6±0.01µs 2.1 GElem/sec in_list_rewrite/fixed_size_binary_2/single_row_hit/batch=1/nulls=0%/match=100%/in/list=3 2.27 650.7±19.72ns 1500.9 KElem/sec 1.00 286.2±1.26ns 3.3 MElem/sec in_list_rewrite/fixed_size_binary_2/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=3 1.88 636.3±18.07ns 1534.8 KElem/sec 1.00 338.1±1.44ns 2.8 MElem/sec in_list_rewrite/fixed_size_binary_2/single_row_miss/batch=1/nulls=0%/match=0%/in/list=3 6.39 1819.2±62.52ns 536.8 KElem/sec 1.00 284.9±1.27ns 3.3 MElem/sec in_list_rewrite/fixed_size_binary_2/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=3 6.52 2.2±0.07µs 443.2 KElem/sec 1.00 338.1±1.85ns 2.8 MElem/sec in_list_rewrite/fixed_size_binary_2/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3 6.86 24.1±0.29µs 323.8 MElem/sec 1.00 3.5±0.01µs 2.2 GElem/sec in_list_rewrite/fixed_size_binary_2/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=3 17.61 63.0±0.47µs 123.9 MElem/sec 1.00 3.6±0.01µs 2.1 GElem/sec in_list_rewrite/fixed_size_binary_4/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=3 5.69 18.0±0.15µs 432.8 MElem/sec 1.00 3.2±0.01µs 2.4 GElem/sec in_list_rewrite/fixed_size_binary_4/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=3 5.55 18.0±0.21µs 434.3 MElem/sec 1.00 3.2±0.01µs 2.4 GElem/sec in_list_rewrite/fixed_size_binary_4/balanced/batch=8192/nulls=0%/match=50%/in/list=3 17.32 55.0±0.43µs 142.0 MElem/sec 1.00 3.2±0.01µs 2.4 GElem/sec in_list_rewrite/fixed_size_binary_4/balanced/batch=8192/nulls=0%/match=50%/not_in/list=3 16.74 54.3±0.39µs 143.8 MElem/sec 1.00 3.2±0.01µs 2.4 GElem/sec in_list_rewrite/fixed_size_binary_4/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=3 16.94 55.7±0.18µs 140.2 MElem/sec 1.00 3.3±0.01µs 2.3 GElem/sec in_list_rewrite/fixed_size_binary_4/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=3 16.56 55.5±0.43µs 140.8 MElem/sec 1.00 3.3±0.01µs 2.3 GElem/sec in_list_rewrite/fixed_size_binary_4/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=3 10.15 3.2±0.09µs 19.1 MElem/sec 1.00 315.4±5.11ns 193.5 MElem/sec in_list_rewrite/fixed_size_binary_4/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=3 7.26 2.6±0.07µs 23.7 MElem/sec 1.00 354.5±3.94ns 172.2 MElem/sec in_list_rewrite/fixed_size_binary_4/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=3 17.70 37.6±0.10µs 207.8 MElem/sec 1.00 2.1±0.01µs 3.6 GElem/sec in_list_rewrite/fixed_size_binary_4/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=3 16.96 37.2±0.13µs 210.3 MElem/sec 1.00 2.2±0.00µs 3.5 GElem/sec in_list_rewrite/fixed_size_binary_4/miss/batch=8192/nulls=0%/match=0%/in/list=3 16.96 53.8±0.41µs 145.1 MElem/sec 1.00 3.2±0.01µs 2.4 GElem/sec in_list_rewrite/fixed_size_binary_4/miss/batch=8192/nulls=0%/match=0%/not_in/list=3 16.78 54.3±0.38µs 143.8 MElem/sec 1.00 3.2±0.01µs 2.4 GElem/sec in_list_rewrite/fixed_size_binary_4/single_row_hit/batch=1/nulls=0%/match=100%/in/list=3 2.25 645.5±18.92ns 1512.8 KElem/sec 1.00 286.4±2.38ns 3.3 MElem/sec in_list_rewrite/fixed_size_binary_4/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=3 1.88 635.0±17.79ns 1537.8 KElem/sec 1.00 337.5±2.05ns 2.8 MElem/sec in_list_rewrite/fixed_size_binary_4/single_row_miss/batch=1/nulls=0%/match=0%/in/list=3 6.35 1816.3±63.09ns 537.7 KElem/sec 1.00 285.8±2.24ns 3.3 MElem/sec in_list_rewrite/fixed_size_binary_4/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=3 6.47 2.2±0.06µs 447.2 KElem/sec 1.00 337.3±2.47ns 2.8 MElem/sec in_list_rewrite/fixed_size_binary_4/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3 6.60 21.0±0.22µs 372.3 MElem/sec 1.00 3.2±0.01µs 2.4 GElem/sec in_list_rewrite/fixed_size_binary_4/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=3 18.11 58.7±1.02µs 133.1 MElem/sec 1.00 3.2±0.01µs 2.4 GElem/sec in_list_rewrite/fixed_size_binary_8/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=3 4.11 15.4±0.13µs 506.3 MElem/sec 1.00 3.8±0.01µs 2.0 GElem/sec in_list_rewrite/fixed_size_binary_8/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=3 4.02 15.4±0.12µs 508.0 MElem/sec 1.00 3.8±0.01µs 2043.2 MElem/sec in_list_rewrite/fixed_size_binary_8/balanced/batch=8192/nulls=0%/match=50%/in/list=3 12.58 47.2±0.32µs 165.5 MElem/sec 1.00 3.8±0.01µs 2.0 GElem/sec in_list_rewrite/fixed_size_binary_8/balanced/batch=8192/nulls=0%/match=50%/not_in/list=3 12.12 46.5±0.35µs 167.9 MElem/sec 1.00 3.8±0.01µs 2034.8 MElem/sec in_list_rewrite/fixed_size_binary_8/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=3 12.37 47.9±0.13µs 163.1 MElem/sec 1.00 3.9±0.01µs 2017.5 MElem/sec in_list_rewrite/fixed_size_binary_8/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=3 12.10 47.7±0.22µs 163.8 MElem/sec 1.00 3.9±0.01µs 1982.2 MElem/sec in_list_rewrite/fixed_size_binary_8/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=3 10.49 3.1±0.08µs 19.5 MElem/sec 1.00 297.8±1.23ns 205.0 MElem/sec in_list_rewrite/fixed_size_binary_8/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=3 7.31 2.5±0.07µs 24.2 MElem/sec 1.00 345.6±1.48ns 176.6 MElem/sec in_list_rewrite/fixed_size_binary_8/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=3 14.49 32.6±0.22µs 239.7 MElem/sec 1.00 2.2±0.01µs 3.4 GElem/sec in_list_rewrite/fixed_size_binary_8/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=3 13.82 32.0±0.27µs 244.5 MElem/sec 1.00 2.3±0.01µs 3.3 GElem/sec in_list_rewrite/fixed_size_binary_8/miss/batch=8192/nulls=0%/match=0%/in/list=3 12.30 46.3±0.72µs 168.9 MElem/sec 1.00 3.8±0.02µs 2.0 GElem/sec in_list_rewrite/fixed_size_binary_8/miss/batch=8192/nulls=0%/match=0%/not_in/list=3 12.09 46.4±0.34µs 168.2 MElem/sec 1.00 3.8±0.02µs 2034.3 MElem/sec in_list_rewrite/fixed_size_binary_8/single_row_hit/batch=1/nulls=0%/match=100%/in/list=3 2.26 644.4±18.46ns 1515.6 KElem/sec 1.00 285.7±3.11ns 3.3 MElem/sec in_list_rewrite/fixed_size_binary_8/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=3 1.91 633.4±17.56ns 1541.8 KElem/sec 1.00 331.7±1.53ns 2.9 MElem/sec in_list_rewrite/fixed_size_binary_8/single_row_miss/batch=1/nulls=0%/match=0%/in/list=3 6.41 1805.8±58.79ns 540.8 KElem/sec 1.00 281.8±1.25ns 3.4 MElem/sec in_list_rewrite/fixed_size_binary_8/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=3 6.59 2.2±0.07µs 448.8 KElem/sec 1.00 330.3±1.75ns 2.9 MElem/sec in_list_rewrite/fixed_size_binary_8/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3 4.88 18.3±0.11µs 426.1 MElem/sec 1.00 3.8±0.01µs 2.0 GElem/sec in_list_rewrite/fixed_size_binary_8/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=3 12.18 46.7±0.39µs 167.2 MElem/sec 1.00 3.8±0.01µs 2036.5 MElem/sec in_list_rewrite/float32/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=3 1.65 5.0±0.31µs 1556.8 MElem/sec 1.00 3.0±0.01µs 2.5 GElem/sec in_list_rewrite/float32/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=3 1.50 4.7±0.03µs 1666.8 MElem/sec 1.00 3.1±0.01µs 2.4 GElem/sec in_list_rewrite/float32/balanced/batch=8192/nulls=0%/match=50%/in/list=3 4.94 15.0±0.05µs 519.9 MElem/sec 1.00 3.0±0.01µs 2.5 GElem/sec in_list_rewrite/float32/balanced/batch=8192/nulls=0%/match=50%/not_in/list=3 4.67 14.5±0.08µs 538.5 MElem/sec 1.00 3.1±0.01µs 2.5 GElem/sec in_list_rewrite/float32/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=3 5.08 15.9±0.05µs 492.5 MElem/sec 1.00 3.1±0.01µs 2.4 GElem/sec in_list_rewrite/float32/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=3 4.86 15.5±0.06µs 503.9 MElem/sec 1.00 3.2±0.01µs 2.4 GElem/sec in_list_rewrite/float32/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=3 12.39 2.3±0.01µs 26.7 MElem/sec 1.00 184.7±5.98ns 330.5 MElem/sec in_list_rewrite/float32/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=3 7.52 1714.9±7.43ns 35.6 MElem/sec 1.00 228.2±2.72ns 267.5 MElem/sec in_list_rewrite/float32/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=3 5.53 11.1±0.05µs 705.1 MElem/sec 1.00 2.0±0.01µs 3.8 GElem/sec in_list_rewrite/float32/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=3 5.08 10.5±0.04µs 745.0 MElem/sec 1.00 2.1±0.01µs 3.7 GElem/sec in_list_rewrite/float32/miss/batch=8192/nulls=0%/match=0%/in/list=3 4.56 13.9±0.09µs 562.5 MElem/sec 1.00 3.0±0.01µs 2.5 GElem/sec in_list_rewrite/float32/miss/batch=8192/nulls=0%/match=0%/not_in/list=3 4.61 14.4±0.05µs 542.7 MElem/sec 1.00 3.1±0.01µs 2.4 GElem/sec in_list_rewrite/float32/single_row_hit/batch=1/nulls=0%/match=100%/in/list=3 2.65 457.3±1.85ns 2.1 MElem/sec 1.00 172.8±1.81ns 5.5 MElem/sec in_list_rewrite/float32/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=3 2.04 441.4±3.82ns 2.2 MElem/sec 1.00 216.8±5.36ns 4.4 MElem/sec in_list_rewrite/float32/single_row_miss/batch=1/nulls=0%/match=0%/in/list=3 6.88 1197.7±8.12ns 815.4 KElem/sec 1.00 174.0±7.78ns 5.5 MElem/sec in_list_rewrite/float32/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=3 7.27 1573.7±11.42ns 620.5 KElem/sec 1.00 216.5±3.00ns 4.4 MElem/sec in_list_rewrite/float32/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3 2.22 6.8±0.03µs 1153.1 MElem/sec 1.00 3.1±0.01µs 2.5 GElem/sec in_list_rewrite/float32/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=3 4.64 14.5±0.04µs 540.2 MElem/sec 1.00 3.1±0.01µs 2.5 GElem/sec in_list_rewrite/float64/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=3 1.30 4.7±0.02µs 1650.8 MElem/sec 1.00 3.6±0.01µs 2.1 GElem/sec in_list_rewrite/float64/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=3 1.26 4.7±0.01µs 1665.6 MElem/sec 1.00 3.7±0.01µs 2.1 GElem/sec in_list_rewrite/float64/balanced/batch=8192/nulls=0%/match=50%/in/list=3 4.15 15.1±0.08µs 518.1 MElem/sec 1.00 3.6±0.01µs 2.1 GElem/sec in_list_rewrite/float64/balanced/batch=8192/nulls=0%/match=50%/not_in/list=3 3.89 14.4±0.05µs 541.9 MElem/sec 1.00 3.7±0.01µs 2.1 GElem/sec in_list_rewrite/float64/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=3 4.38 16.4±0.11µs 477.0 MElem/sec 1.00 3.7±0.01µs 2.0 GElem/sec in_list_rewrite/float64/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=3 4.16 15.8±0.17µs 493.6 MElem/sec 1.00 3.8±0.01µs 2.0 GElem/sec in_list_rewrite/float64/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=3 12.30 2.3±0.01µs 26.5 MElem/sec 1.00 187.7±6.64ns 325.3 MElem/sec in_list_rewrite/float64/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=3 7.65 1755.1±11.52ns 34.8 MElem/sec 1.00 229.5±3.71ns 265.9 MElem/sec in_list_rewrite/float64/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=3 5.36 11.4±0.17µs 685.1 MElem/sec 1.00 2.1±0.01µs 3.6 GElem/sec in_list_rewrite/float64/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=3 4.81 10.5±0.04µs 744.9 MElem/sec 1.00 2.2±0.01µs 3.5 GElem/sec in_list_rewrite/float64/miss/batch=8192/nulls=0%/match=0%/in/list=3 3.84 14.0±0.07µs 560.0 MElem/sec 1.00 3.6±0.02µs 2.1 GElem/sec in_list_rewrite/float64/miss/batch=8192/nulls=0%/match=0%/not_in/list=3 3.88 14.4±0.07µs 542.5 MElem/sec 1.00 3.7±0.01µs 2.1 GElem/sec in_list_rewrite/float64/single_row_hit/batch=1/nulls=0%/match=100%/in/list=3 2.72 466.7±3.84ns 2.0 MElem/sec 1.00 171.5±1.58ns 5.6 MElem/sec in_list_rewrite/float64/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=3 2.13 459.0±4.05ns 2.1 MElem/sec 1.00 215.6±6.50ns 4.4 MElem/sec in_list_rewrite/float64/single_row_miss/batch=1/nulls=0%/match=0%/in/list=3 6.72 1191.4±5.23ns 819.7 KElem/sec 1.00 177.3±7.66ns 5.4 MElem/sec in_list_rewrite/float64/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=3 7.48 1592.9±13.38ns 613.1 KElem/sec 1.00 213.0±3.92ns 4.5 MElem/sec in_list_rewrite/float64/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3 1.88 6.8±0.06µs 1145.9 MElem/sec 1.00 3.6±0.01µs 2.1 GElem/sec in_list_rewrite/float64/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=3 3.91 14.5±0.06µs 539.9 MElem/sec 1.00 3.7±0.01µs 2.1 GElem/sec in_list_rewrite/int32/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=3 1.00 1946.3±13.50ns 3.9 GElem/sec 1.57 3.0±0.03µs 2.5 GElem/sec in_list_rewrite/int32/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=3 1.00 1893.7±8.33ns 4.0 GElem/sec 1.65 3.1±0.03µs 2.4 GElem/sec in_list_rewrite/int32/balanced/batch=8192/nulls=0%/match=50%/in/list=3 2.17 6.6±0.05µs 1185.6 MElem/sec 1.00 3.0±0.01µs 2.5 GElem/sec in_list_rewrite/int32/balanced/batch=8192/nulls=0%/match=50%/not_in/list=3 1.92 6.0±0.03µs 1306.4 MElem/sec 1.00 3.1±0.01µs 2.5 GElem/sec in_list_rewrite/int32/miss/batch=8192/nulls=0%/match=0%/in/list=3 1.81 5.5±0.02µs 1417.7 MElem/sec 1.00 3.0±0.01µs 2.5 GElem/sec in_list_rewrite/int32/miss/batch=8192/nulls=0%/match=0%/not_in/list=3 1.91 5.9±0.02µs 1316.5 MElem/sec 1.00 3.1±0.01µs 2.5 GElem/sec in_list_rewrite/int32/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3 1.28 3.9±0.02µs 2005.0 MElem/sec 1.00 3.0±0.01µs 2.5 GElem/sec in_list_rewrite/int32/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=3 1.93 6.0±0.03µs 1300.0 MElem/sec 1.00 3.1±0.02µs 2.4 GElem/sec in_list_rewrite/int64/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=3 1.00 1855.4±4.68ns 4.1 GElem/sec 1.96 3.6±0.03µs 2.1 GElem/sec in_list_rewrite/int64/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=3 1.00 1819.7±7.01ns 4.2 GElem/sec 2.04 3.7±0.01µs 2.1 GElem/sec in_list_rewrite/int64/balanced/batch=8192/nulls=0%/match=50%/in/list=3 1.76 6.4±0.02µs 1226.1 MElem/sec 1.00 3.6±0.01µs 2.1 GElem/sec in_list_rewrite/int64/balanced/batch=8192/nulls=0%/match=50%/not_in/list=3 1.56 5.8±0.02µs 1352.6 MElem/sec 1.00 3.7±0.01µs 2.1 GElem/sec in_list_rewrite/int64/miss/batch=8192/nulls=0%/match=0%/in/list=3 1.48 5.4±0.03µs 1454.7 MElem/sec 1.00 3.6±0.02µs 2.1 GElem/sec in_list_rewrite/int64/miss/batch=8192/nulls=0%/match=0%/not_in/list=3 1.56 5.8±0.05µs 1350.8 MElem/sec 1.00 3.7±0.01µs 2.1 GElem/sec in_list_rewrite/int64/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3 1.06 3.9±0.03µs 2028.0 MElem/sec 1.00 3.6±0.01µs 2.1 GElem/sec in_list_rewrite/int64/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=3 1.58 5.9±0.07µs 1334.2 MElem/sec 1.00 3.7±0.02µs 2.1 GElem/sec in_list_rewrite/uint64/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=3 1.00 1855.4±5.76ns 4.1 GElem/sec 1.95 3.6±0.01µs 2.1 GElem/sec in_list_rewrite/uint64/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=3 1.00 1816.9±10.40ns 4.2 GElem/sec 2.04 3.7±0.08µs 2.1 GElem/sec in_list_rewrite/uint64/balanced/batch=8192/nulls=0%/match=50%/in/list=3 1.75 6.3±0.02µs 1231.5 MElem/sec 1.00 3.6±0.01µs 2.1 GElem/sec in_list_rewrite/uint64/balanced/batch=8192/nulls=0%/match=50%/not_in/list=3 1.56 5.7±0.02µs 1359.6 MElem/sec 1.00 3.7±0.01µs 2.1 GElem/sec in_list_rewrite/uint64/miss/batch=8192/nulls=0%/match=0%/in/list=3 1.46 5.3±0.03µs 1475.3 MElem/sec 1.00 3.6±0.01µs 2.1 GElem/sec in_list_rewrite/uint64/miss/batch=8192/nulls=0%/match=0%/not_in/list=3 1.56 5.8±0.04µs 1352.4 MElem/sec 1.00 3.7±0.01µs 2.1 GElem/sec in_list_rewrite/uint64/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3 1.06 3.8±0.02µs 2034.1 MElem/sec 1.00 3.6±0.01µs 2.1 GElem/sec in_list_rewrite/uint64/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=3 1.57 5.8±0.03µs 1343.2 MElem/sec 1.00 3.7±0.02µs 2.1 GElem/sec in_list_rewrite/utf8/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=3 1.00 17.8±0.13µs 438.9 MElem/sec 1.00 17.9±0.14µs 436.9 MElem/sec in_list_rewrite/utf8/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=3 1.01 18.0±0.14µs 433.8 MElem/sec 1.00 17.8±0.07µs 439.6 MElem/sec in_list_rewrite/utf8/balanced/batch=8192/nulls=0%/match=50%/in/list=3 1.00 54.4±0.48µs 143.7 MElem/sec 1.00 54.6±0.52µs 143.1 MElem/sec in_list_rewrite/utf8/balanced/batch=8192/nulls=0%/match=50%/not_in/list=3 1.00 54.3±0.46µs 143.9 MElem/sec 1.00 54.5±0.49µs 143.5 MElem/sec in_list_rewrite/utf8/miss/batch=8192/nulls=0%/match=0%/in/list=3 1.00 53.2±0.79µs 146.9 MElem/sec 1.00 53.2±0.45µs 147.0 MElem/sec in_list_rewrite/utf8/miss/batch=8192/nulls=0%/match=0%/not_in/list=3 1.00 54.1±0.44µs 144.5 MElem/sec 1.01 54.4±0.31µs 143.7 MElem/sec in_list_rewrite/utf8/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3 1.00 21.2±0.21µs 368.4 MElem/sec 1.00 21.2±0.21µs 367.8 MElem/sec in_list_rewrite/utf8/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=3 1.00 54.2±0.38µs 144.1 MElem/sec 1.00 54.4±0.39µs 143.7 MElem/sec in_list_rewrite/utf8view_inline/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=3 1.00 4.6±0.01µs 1693.6 MElem/sec 1.00 4.6±0.01µs 1692.0 MElem/sec in_list_rewrite/utf8view_inline/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=3 1.00 4.6±0.01µs 1707.0 MElem/sec 1.00 4.6±0.01µs 1711.8 MElem/sec in_list_rewrite/utf8view_inline/balanced/batch=8192/nulls=0%/match=50%/in/list=3 1.00 14.8±0.05µs 529.1 MElem/sec 1.00 14.7±0.03µs 530.7 MElem/sec in_list_rewrite/utf8view_inline/balanced/batch=8192/nulls=0%/match=50%/not_in/list=3 1.00 14.1±0.03µs 555.4 MElem/sec 1.00 14.0±0.04µs 556.9 MElem/sec in_list_rewrite/utf8view_inline/miss/batch=8192/nulls=0%/match=0%/in/list=3 1.00 13.7±0.04µs 572.2 MElem/sec 1.00 13.6±0.03µs 574.1 MElem/sec in_list_rewrite/utf8view_inline/miss/batch=8192/nulls=0%/match=0%/not_in/list=3 1.00 14.1±0.06µs 555.6 MElem/sec 1.00 14.0±0.03µs 557.0 MElem/sec in_list_rewrite/utf8view_inline/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3 1.01 7.1±0.05µs 1102.4 MElem/sec 1.00 7.0±0.02µs 1109.1 MElem/sec in_list_rewrite/utf8view_inline/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=3 1.00 14.2±0.04µs 551.5 MElem/sec 1.00 14.1±0.12µs 553.0 MElem/sec ``` </p> </details> <details><summary>Resource Usage</summary> **in_list_rewrite — base (merge-base)** | Metric | Value | |--------|-------| | Wall time | 475.1s | | Peak memory | 65.7 MiB | | Avg memory | 21.5 MiB | | CPU user | 596.4s | | CPU sys | 1.9s | | Peak spill | 0 B | **in_list_rewrite — branch** | Metric | Value | |--------|-------| | Wall time | 460.1s | | Peak memory | 66.1 MiB | | Avg memory | 20.8 MiB | | CPU user | 584.2s | | CPU sys | 1.9s | | 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]
