adriangbot commented on PR #25187: URL: https://github.com/apache/datafusion/pull/25187#issuecomment-6063671000
🤖 Benchmark completed (GKE) | [trigger](https://github.com/apache/datafusion/pull/25187#issuecomment-6063391335) **Instance:** `c4a-highmem-16` (12 vCPU / 65 GiB) Comparing 61e15e2249467a07ecc592fdcb5d932beabac1d9 (61e15e2249467a07ecc592fdcb5d932beabac1d9) to 0c427448bb90240023770c81ecbbe1e3bb9129d6 [diff](https://github.com/apache/datafusion/compare/0c427448bb90240023770c81ecbbe1e3bb9129d6..61e15e2249467a07ecc592fdcb5d932beabac1d9) <details><summary>Run configuration</summary> ```yaml run benchmark in_list_rewrite env: BENCH_FILTER: "^in_list_rewrite/.*/list=3$" baseline: ref: "0c427448bb90240023770c81ecbbe1e3bb9129d6" changed: ref: "61e15e2249467a07ecc592fdcb5d932beabac1d9" ``` </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.05 23.6±0.21µs 330.4 MElem/sec 1.00 3.4±0.02µ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.91 23.6±0.18µs 330.3 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.37 71.7±0.98µs 108.9 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.98 71.8±1.06µs 108.8 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.08 72.8±1.30µs 107.3 MElem/sec 1.00 3.5±0.02µ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.61 72.4±0.19µs 108.0 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.21 3.3±0.12µs 18.5 MElem/sec 1.00 294.9±1.49ns 207.0 MElem/sec in_list_rewrite/fixed_size_binary_1/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=3 9.70 3.3±0.13µs 18.4 MElem/sec 1.00 342.7±2.11ns 178.1 MElem/sec in_list_rewrite/fixed_size_binary_1/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=3 21.40 48.7±0.15µs 160.3 MElem/sec 1.00 2.3±0.00µs 3.3 GElem/sec in_list_rewrite/fixed_size_binary_1/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=3 20.93 48.8±0.25µs 160.2 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 21.07 70.7±0.57µs 110.5 MElem/sec 1.00 3.4±0.01µs 2.3 GElem/sec in_list_rewrite/fixed_size_binary_1/miss/batch=8192/nulls=0%/match=0%/not_in/list=3 20.74 70.8±0.76µs 110.3 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.39 676.9±27.95ns 1442.7 KElem/sec 1.00 282.8±2.09ns 3.4 MElem/sec in_list_rewrite/fixed_size_binary_1/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=3 2.04 679.4±27.50ns 1437.4 KElem/sec 1.00 333.8±1.21ns 2.9 MElem/sec in_list_rewrite/fixed_size_binary_1/single_row_miss/batch=1/nulls=0%/match=0%/in/list=3 6.75 1902.0±84.22ns 513.4 KElem/sec 1.00 281.6±1.34ns 3.4 MElem/sec in_list_rewrite/fixed_size_binary_1/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=3 5.66 1898.5±81.85ns 514.4 KElem/sec 1.00 335.6±1.68ns 2.8 MElem/sec in_list_rewrite/fixed_size_binary_1/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3 7.98 26.8±0.51µs 291.5 MElem/sec 1.00 3.4±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 8.04 27.5±1.02µs 284.5 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 15.9±0.14µs 490.4 MElem/sec 1.00 9.7±0.04µs 802.7 MElem/sec in_list_rewrite/fixed_size_binary_16/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=3 1.63 16.0±0.18µs 489.5 MElem/sec 1.00 9.8±0.02µs 797.0 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced/batch=8192/nulls=0%/match=50%/in/list=3 5.01 48.7±0.47µs 160.5 MElem/sec 1.00 9.7±0.02µs 803.2 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced/batch=8192/nulls=0%/match=50%/not_in/list=3 4.97 48.7±0.53µs 160.4 MElem/sec 1.00 9.8±0.02µs 797.2 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=3 5.00 49.2±0.10µs 158.6 MElem/sec 1.00 9.9±0.07µs 792.7 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=3 4.97 49.2±0.17µs 158.9 MElem/sec 1.00 9.9±0.01µs 789.3 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=3 9.28 3.1±0.10µs 19.4 MElem/sec 1.00 338.9±3.64ns 180.1 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=3 8.23 3.2±0.11µs 19.2 MElem/sec 1.00 386.0±1.77ns 158.1 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_unaligned/batch=8192/nulls=0%/match=50%/in/list=3 4.32 50.0±0.73µs 156.3 MElem/sec 1.00 11.6±0.02µs 675.2 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_unaligned/batch=8192/nulls=0%/match=50%/not_in/list=3 4.28 49.9±1.25µs 156.5 MElem/sec 1.00 11.7±0.03µs 669.1 MElem/sec in_list_rewrite/fixed_size_binary_16/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=3 4.52 33.7±0.11µs 231.6 MElem/sec 1.00 7.5±0.01µs 1046.2 MElem/sec in_list_rewrite/fixed_size_binary_16/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=3 4.41 33.3±0.14µs 234.3 MElem/sec 1.00 7.6±0.02µs 1034.4 MElem/sec in_list_rewrite/fixed_size_binary_16/miss/batch=8192/nulls=0%/match=0%/in/list=3 4.90 47.7±0.52µs 163.9 MElem/sec 1.00 9.7±0.02µs 803.5 MElem/sec in_list_rewrite/fixed_size_binary_16/miss/batch=8192/nulls=0%/match=0%/not_in/list=3 4.96 48.6±0.69µs 160.8 MElem/sec 1.00 9.8±0.05µs 797.5 MElem/sec in_list_rewrite/fixed_size_binary_16/single_row_hit/batch=1/nulls=0%/match=100%/in/list=3 2.52 685.4±48.40ns 1424.7 KElem/sec 1.00 271.5±1.24ns 3.5 MElem/sec in_list_rewrite/fixed_size_binary_16/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=3 2.12 679.5±26.35ns 1437.1 KElem/sec 1.00 320.7±2.05ns 3.0 MElem/sec in_list_rewrite/fixed_size_binary_16/single_row_miss/batch=1/nulls=0%/match=0%/in/list=3 6.98 1896.4±74.84ns 515.0 KElem/sec 1.00 271.8±1.86ns 3.5 MElem/sec in_list_rewrite/fixed_size_binary_16/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=3 5.97 1906.0±77.88ns 512.4 KElem/sec 1.00 319.4±1.98ns 3.0 MElem/sec in_list_rewrite/fixed_size_binary_16/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3 1.94 18.9±0.18µs 413.2 MElem/sec 1.00 9.7±0.02µs 803.1 MElem/sec in_list_rewrite/fixed_size_binary_16/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=3 1.90 18.7±0.07µs 417.8 MElem/sec 1.00 9.8±0.10µs 795.5 MElem/sec in_list_rewrite/fixed_size_binary_2/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=3 5.93 20.9±0.23µs 374.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 6.12 21.9±0.18µs 356.7 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.60 83.0±0.70µs 94.1 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.20 83.0±0.78µs 94.1 MElem/sec 1.00 3.6±0.02µs 2.1 GElem/sec in_list_rewrite/fixed_size_binary_2/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=3 24.32 88.0±0.67µs 88.8 MElem/sec 1.00 3.6±0.02µ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.89 87.7±0.26µs 89.1 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.78 3.3±0.14µs 18.5 MElem/sec 1.00 306.9±1.41ns 198.9 MElem/sec in_list_rewrite/fixed_size_binary_2/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=3 9.39 3.3±0.12µs 18.5 MElem/sec 1.00 351.6±1.31ns 173.6 MElem/sec in_list_rewrite/fixed_size_binary_2/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=3 28.81 62.4±0.23µs 125.2 MElem/sec 1.00 2.2±0.00µ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 28.06 62.3±0.25µs 125.4 MElem/sec 1.00 2.2±0.00µs 3.4 GElem/sec in_list_rewrite/fixed_size_binary_2/miss/batch=8192/nulls=0%/match=0%/in/list=3 17.68 62.3±0.92µs 125.3 MElem/sec 1.00 3.5±0.02µs 2.2 GElem/sec in_list_rewrite/fixed_size_binary_2/miss/batch=8192/nulls=0%/match=0%/not_in/list=3 18.10 64.7±1.57µs 120.7 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.39 688.2±30.29ns 1419.0 KElem/sec 1.00 288.4±3.30ns 3.3 MElem/sec in_list_rewrite/fixed_size_binary_2/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=3 2.05 688.8±98.51ns 1417.9 KElem/sec 1.00 335.3±1.57ns 2.8 MElem/sec in_list_rewrite/fixed_size_binary_2/single_row_miss/batch=1/nulls=0%/match=0%/in/list=3 6.61 1901.1±77.38ns 513.7 KElem/sec 1.00 287.7±1.79ns 3.3 MElem/sec in_list_rewrite/fixed_size_binary_2/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=3 5.60 1903.5±80.95ns 513.0 KElem/sec 1.00 339.7±1.44ns 2.8 MElem/sec in_list_rewrite/fixed_size_binary_2/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3 6.90 24.3±0.42µs 321.4 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 6.76 24.2±0.64µs 323.0 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.72 18.1±0.16µs 431.2 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.90 19.1±0.20µs 408.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.39 55.2±0.67µs 141.5 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 17.07 55.3±0.74µs 141.4 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 17.53 57.3±1.36µs 136.3 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.71 55.8±0.50µs 139.9 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.36 3.2±0.12µs 19.1 MElem/sec 1.00 309.3±5.75ns 197.3 MElem/sec in_list_rewrite/fixed_size_binary_4/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=3 9.01 3.2±0.12µs 19.1 MElem/sec 1.00 354.7±5.12ns 172.1 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.13µs 207.8 MElem/sec 1.00 2.1±0.00µ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 17.32 37.7±0.12µs 207.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 17.05 54.2±0.58µs 144.3 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.73 54.1±0.55µs 144.3 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.39 683.1±31.68ns 1429.5 KElem/sec 1.00 286.1±1.66ns 3.3 MElem/sec in_list_rewrite/fixed_size_binary_4/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=3 2.03 685.2±27.63ns 1425.2 KElem/sec 1.00 337.3±1.51ns 2.8 MElem/sec in_list_rewrite/fixed_size_binary_4/single_row_miss/batch=1/nulls=0%/match=0%/in/list=3 6.63 1908.5±82.47ns 511.7 KElem/sec 1.00 288.1±2.99ns 3.3 MElem/sec in_list_rewrite/fixed_size_binary_4/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=3 5.66 1907.5±78.82ns 512.0 KElem/sec 1.00 337.2±1.78ns 2.8 MElem/sec in_list_rewrite/fixed_size_binary_4/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3 6.70 21.3±0.76µs 367.4 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 6.54 21.1±0.73µs 370.0 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.13 15.5±0.15µs 502.7 MElem/sec 1.00 3.8±0.02µ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.05 15.5±0.16µs 502.7 MElem/sec 1.00 3.8±0.01µs 2035.0 MElem/sec in_list_rewrite/fixed_size_binary_8/balanced/batch=8192/nulls=0%/match=50%/in/list=3 12.63 47.5±0.50µs 164.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.38 47.5±0.64µs 164.5 MElem/sec 1.00 3.8±0.01µs 2036.5 MElem/sec in_list_rewrite/fixed_size_binary_8/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=3 12.40 48.2±0.11µs 162.2 MElem/sec 1.00 3.9±0.01µs 2011.6 MElem/sec in_list_rewrite/fixed_size_binary_8/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=3 12.22 48.0±0.22µs 162.8 MElem/sec 1.00 3.9±0.01µs 1989.1 MElem/sec in_list_rewrite/fixed_size_binary_8/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=3 10.30 3.2±0.12µs 19.4 MElem/sec 1.00 306.2±5.09ns 199.4 MElem/sec in_list_rewrite/fixed_size_binary_8/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=3 9.11 3.1±0.11µs 19.4 MElem/sec 1.00 345.5±1.24ns 176.6 MElem/sec in_list_rewrite/fixed_size_binary_8/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=3 14.43 32.4±0.11µs 240.8 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 14.09 32.5±0.06µs 240.4 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.69 47.8±1.55µs 163.4 MElem/sec 1.00 3.8±0.12µs 2.0 GElem/sec in_list_rewrite/fixed_size_binary_8/miss/batch=8192/nulls=0%/match=0%/not_in/list=3 12.12 46.4±0.66µs 168.3 MElem/sec 1.00 3.8±0.01µs 2040.6 MElem/sec in_list_rewrite/fixed_size_binary_8/single_row_hit/batch=1/nulls=0%/match=100%/in/list=3 2.38 689.2±26.89ns 1417.0 KElem/sec 1.00 289.4±3.30ns 3.3 MElem/sec in_list_rewrite/fixed_size_binary_8/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=3 2.06 680.5±26.77ns 1435.2 KElem/sec 1.00 331.0±1.51ns 2.9 MElem/sec in_list_rewrite/fixed_size_binary_8/single_row_miss/batch=1/nulls=0%/match=0%/in/list=3 6.74 1909.3±77.62ns 511.5 KElem/sec 1.00 283.3±1.35ns 3.4 MElem/sec in_list_rewrite/fixed_size_binary_8/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=3 5.75 1906.5±89.73ns 512.2 KElem/sec 1.00 331.3±1.55ns 2.9 MElem/sec in_list_rewrite/fixed_size_binary_8/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3 4.95 18.7±0.59µs 418.8 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 4.81 18.5±0.57µs 423.2 MElem/sec 1.00 3.8±0.01µs 2036.6 MElem/sec in_list_rewrite/float32/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=3 1.56 4.8±0.07µs 1644.3 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.51 4.7±0.03µs 1662.4 MElem/sec 1.00 3.1±0.02µs 2.5 GElem/sec in_list_rewrite/float32/balanced/batch=8192/nulls=0%/match=50%/in/list=3 4.94 15.0±0.11µs 520.0 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.83 15.0±0.09µs 520.9 MElem/sec 1.00 3.1±0.02µs 2.5 GElem/sec in_list_rewrite/float32/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=3 5.06 15.9±0.13µs 492.8 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.93 15.7±0.12µs 497.5 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.32 2.2±0.02µs 27.3 MElem/sec 1.00 181.7±2.03ns 336.0 MElem/sec in_list_rewrite/float32/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=3 9.69 2.2±0.01µs 27.6 MElem/sec 1.00 228.3±1.14ns 267.4 MElem/sec in_list_rewrite/float32/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=3 5.62 11.3±0.33µs 691.8 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.31 11.0±0.04µs 711.1 MElem/sec 1.00 2.1±0.00µs 3.7 GElem/sec in_list_rewrite/float32/miss/batch=8192/nulls=0%/match=0%/in/list=3 4.57 13.9±0.07µs 561.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.48 13.9±0.09µs 562.1 MElem/sec 1.00 3.1±0.01µs 2.5 GElem/sec in_list_rewrite/float32/single_row_hit/batch=1/nulls=0%/match=100%/in/list=3 2.70 464.6±8.16ns 2.1 MElem/sec 1.00 172.1±1.13ns 5.5 MElem/sec in_list_rewrite/float32/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=3 2.18 461.9±8.73ns 2.1 MElem/sec 1.00 211.6±1.62ns 4.5 MElem/sec in_list_rewrite/float32/single_row_miss/batch=1/nulls=0%/match=0%/in/list=3 7.14 1217.7±10.92ns 802.0 KElem/sec 1.00 170.5±1.79ns 5.6 MElem/sec in_list_rewrite/float32/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=3 5.76 1223.8±10.02ns 798.0 KElem/sec 1.00 212.4±1.94ns 4.5 MElem/sec in_list_rewrite/float32/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3 2.24 6.8±0.07µs 1147.9 MElem/sec 1.00 3.0±0.01µs 2.5 GElem/sec in_list_rewrite/float32/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=3 2.14 6.7±0.08µs 1174.4 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.31 4.7±0.09µs 1647.9 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.02µs 1666.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.11 14.9±0.06µs 524.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 4.04 14.9±0.13µs 523.2 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.21 15.8±0.15µs 495.9 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.12 15.7±0.07µs 498.7 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.06 2.2±0.02µs 28.1 MElem/sec 1.00 180.0±1.94ns 339.2 MElem/sec in_list_rewrite/float64/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=3 9.86 2.2±0.01µs 27.7 MElem/sec 1.00 223.4±0.63ns 273.2 MElem/sec in_list_rewrite/float64/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=3 5.20 11.0±0.06µs 707.6 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 5.04 11.0±0.05µs 711.1 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.92 14.3±0.56µs 547.5 MElem/sec 1.00 3.6±0.01µs 2.1 GElem/sec in_list_rewrite/float64/miss/batch=8192/nulls=0%/match=0%/not_in/list=3 3.76 13.9±0.10µs 561.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.66 452.7±5.31ns 2.1 MElem/sec 1.00 170.1±2.13ns 5.6 MElem/sec in_list_rewrite/float64/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=3 2.17 447.3±5.25ns 2.1 MElem/sec 1.00 206.1±1.08ns 4.6 MElem/sec in_list_rewrite/float64/single_row_miss/batch=1/nulls=0%/match=0%/in/list=3 6.68 1157.9±5.19ns 843.4 KElem/sec 1.00 173.4±5.75ns 5.5 MElem/sec in_list_rewrite/float64/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=3 5.31 1148.5±7.69ns 850.3 KElem/sec 1.00 216.1±7.28ns 4.4 MElem/sec in_list_rewrite/float64/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3 1.88 6.8±0.48µs 1143.8 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 1.79 6.6±0.06µs 1177.8 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 1928.4±12.92ns 4.0 GElem/sec 1.58 3.0±0.01µs 2.5 GElem/sec in_list_rewrite/int32/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=3 1.00 1930.0±10.32ns 4.0 GElem/sec 1.61 3.1±0.01µs 2.5 GElem/sec in_list_rewrite/int32/balanced/batch=8192/nulls=0%/match=50%/in/list=3 2.11 6.4±0.02µs 1212.1 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 2.07 6.4±0.02µs 1213.1 MElem/sec 1.00 3.1±0.01µs 2.4 GElem/sec in_list_rewrite/int32/miss/batch=8192/nulls=0%/match=0%/in/list=3 1.80 5.5±0.01µs 1425.6 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.76 5.5±0.02µs 1424.0 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.27 3.9±0.03µs 2019.6 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.20 3.7±0.03µs 2.0 GElem/sec 1.00 3.1±0.01µs 2.5 GElem/sec in_list_rewrite/int64/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=3 1.00 1857.8±8.13ns 4.1 GElem/sec 1.96 3.6±0.01µs 2.1 GElem/sec in_list_rewrite/int64/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=3 1.00 1862.6±11.55ns 4.1 GElem/sec 1.99 3.7±0.01µs 2.1 GElem/sec in_list_rewrite/int64/balanced/batch=8192/nulls=0%/match=50%/in/list=3 1.74 6.3±0.02µs 1238.6 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.71 6.3±0.02µs 1236.1 MElem/sec 1.00 3.7±0.03µs 2.1 GElem/sec in_list_rewrite/int64/miss/batch=8192/nulls=0%/match=0%/in/list=3 1.45 5.3±0.02µs 1480.1 MElem/sec 1.00 3.6±0.04µs 2.1 GElem/sec in_list_rewrite/int64/miss/batch=8192/nulls=0%/match=0%/not_in/list=3 1.43 5.3±0.01µs 1475.9 MElem/sec 1.00 3.7±0.02µs 2.1 GElem/sec in_list_rewrite/int64/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3 1.07 3.9±0.04µs 2005.9 MElem/sec 1.00 3.6±0.02µs 2.1 GElem/sec in_list_rewrite/int64/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=3 1.00 3.7±0.04µs 2.1 GElem/sec 1.00 3.7±0.01µs 2.1 GElem/sec in_list_rewrite/uint64/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=3 1.00 1851.0±6.26ns 4.1 GElem/sec 1.96 3.6±0.02µs 2.1 GElem/sec in_list_rewrite/uint64/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=3 1.00 1850.1±9.93ns 4.1 GElem/sec 2.00 3.7±0.01µs 2.1 GElem/sec in_list_rewrite/uint64/balanced/batch=8192/nulls=0%/match=50%/in/list=3 1.74 6.3±0.02µs 1236.8 MElem/sec 1.00 3.6±0.02µs 2.1 GElem/sec in_list_rewrite/uint64/balanced/batch=8192/nulls=0%/match=50%/not_in/list=3 1.69 6.3±0.04µs 1240.9 MElem/sec 1.00 3.7±0.05µs 2.1 GElem/sec in_list_rewrite/uint64/miss/batch=8192/nulls=0%/match=0%/in/list=3 1.47 5.3±0.02µs 1463.0 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.44 5.3±0.02µs 1464.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.07 3.9±0.04µs 2013.3 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.00 3.7±0.04µs 2.1 GElem/sec 1.00 3.7±0.01µ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.16µs 439.1 MElem/sec 1.00 17.8±0.23µs 440.0 MElem/sec in_list_rewrite/utf8/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=3 1.00 17.8±0.23µs 439.6 MElem/sec 1.00 17.8±0.14µs 440.0 MElem/sec in_list_rewrite/utf8/balanced/batch=8192/nulls=0%/match=50%/in/list=3 1.00 54.2±0.43µs 144.0 MElem/sec 1.00 54.1±0.38µs 144.5 MElem/sec in_list_rewrite/utf8/balanced/batch=8192/nulls=0%/match=50%/not_in/list=3 1.00 54.3±0.53µs 143.9 MElem/sec 1.00 54.1±0.84µs 144.4 MElem/sec in_list_rewrite/utf8/miss/batch=8192/nulls=0%/match=0%/in/list=3 1.01 53.2±0.44µs 146.7 MElem/sec 1.00 53.0±0.72µs 147.5 MElem/sec in_list_rewrite/utf8/miss/batch=8192/nulls=0%/match=0%/not_in/list=3 1.00 53.1±0.42µs 147.2 MElem/sec 1.00 53.2±0.43µs 146.8 MElem/sec in_list_rewrite/utf8/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3 1.00 21.3±0.33µs 367.3 MElem/sec 1.00 21.2±0.28µs 368.3 MElem/sec in_list_rewrite/utf8/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=3 1.00 21.1±0.29µs 370.6 MElem/sec 1.00 21.0±0.19µs 371.8 MElem/sec in_list_rewrite/utf8view_inline/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=3 1.00 4.6±0.02µs 1682.9 MElem/sec 1.00 4.6±0.01µs 1686.7 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 1688.2 MElem/sec 1.00 4.6±0.01µs 1689.7 MElem/sec in_list_rewrite/utf8view_inline/balanced/batch=8192/nulls=0%/match=50%/in/list=3 1.00 14.7±0.03µs 530.7 MElem/sec 1.00 14.7±0.04µs 532.0 MElem/sec in_list_rewrite/utf8view_inline/balanced/batch=8192/nulls=0%/match=50%/not_in/list=3 1.00 14.7±0.04µs 530.8 MElem/sec 1.00 14.7±0.03µs 531.0 MElem/sec in_list_rewrite/utf8view_inline/miss/batch=8192/nulls=0%/match=0%/in/list=3 1.00 13.7±0.03µs 571.1 MElem/sec 1.00 13.6±0.03µs 572.7 MElem/sec in_list_rewrite/utf8view_inline/miss/batch=8192/nulls=0%/match=0%/not_in/list=3 1.00 13.7±0.04µs 571.4 MElem/sec 1.00 13.6±0.04µs 573.4 MElem/sec in_list_rewrite/utf8view_inline/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3 1.00 6.9±0.02µs 1125.1 MElem/sec 1.01 7.0±0.04µs 1118.5 MElem/sec in_list_rewrite/utf8view_inline/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=3 1.00 6.8±0.02µs 1152.9 MElem/sec 1.02 6.9±0.05µs 1133.6 MElem/sec ``` </p> </details> <details><summary>Resource Usage</summary> **in_list_rewrite — base (merge-base)** | Metric | Value | |--------|-------| | Wall time | 370.1s | | Peak memory | 63.5 MiB | | Avg memory | 26.6 MiB | | CPU user | 593.7s | | CPU sys | 1.9s | | Peak spill | 0 B | **in_list_rewrite — branch** | Metric | Value | |--------|-------| | Wall time | 350.1s | | Peak memory | 64.2 MiB | | Avg memory | 26.2 MiB | | CPU user | 584.8s | | 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]
