adriangbot commented on PR #25187: URL: https://github.com/apache/datafusion/pull/25187#issuecomment-5994911165
🤖 Benchmark completed (GKE) | [trigger](https://github.com/apache/datafusion/pull/25187#issuecomment-5994637740) **Instance:** `c4a-highmem-16` (12 vCPU / 65 GiB) Comparing 73d1e2609476d47af3c4d410d148722c4842736f (73d1e2609476d47af3c4d410d148722c4842736f) to 3787a2b324288c743fb764bdb7b893d794b58b8c [diff](https://github.com/apache/datafusion/compare/3787a2b324288c743fb764bdb7b893d794b58b8c..73d1e2609476d47af3c4d410d148722c4842736f) <details><summary>Run configuration</summary> ```yaml run benchmark in_list_rewrite env: BENCH_FILTER: "^in_list_rewrite/(float32|float64|fixed_size_binary_(1|2|4|8|16))/.*/list=3/" baseline: ref: "3787a2b324288c743fb764bdb7b893d794b58b8c" changed: ref: "73d1e2609476d47af3c4d410d148722c4842736f" ``` </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/chain 1.01 23.6±0.20µs 331.3 MElem/sec 1.00 23.4±0.15µs 334.5 MElem/sec in_list_rewrite/fixed_size_binary_1/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=3/in_list 1.00 3.4±0.01µs 2.3 GElem/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/chain 1.01 23.6±0.40µs 330.7 MElem/sec 1.00 23.4±0.16µs 334.2 MElem/sec in_list_rewrite/fixed_size_binary_1/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=3/in_list 1.00 3.4±0.02µs 2.2 GElem/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/chain 1.01 71.6±0.57µs 109.2 MElem/sec 1.00 70.9±0.57µs 110.2 MElem/sec in_list_rewrite/fixed_size_binary_1/balanced/batch=8192/nulls=0%/match=50%/in/list=3/in_list 1.00 3.4±0.01µs 2.3 GElem/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/chain 1.03 75.2±3.11µs 104.0 MElem/sec 1.00 72.9±4.63µs 107.2 MElem/sec in_list_rewrite/fixed_size_binary_1/balanced/batch=8192/nulls=0%/match=50%/not_in/list=3/in_list 1.00 3.4±0.01µs 2.2 GElem/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/chain 1.01 72.3±0.19µs 108.1 MElem/sec 1.00 71.6±0.14µs 109.1 MElem/sec in_list_rewrite/fixed_size_binary_1/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=3/in_list 1.00 3.4±0.01µs 2.2 GElem/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/chain 1.00 72.3±0.51µs 108.1 MElem/sec 1.05 75.8±2.92µs 103.1 MElem/sec in_list_rewrite/fixed_size_binary_1/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=3/in_list 1.00 3.5±0.01µs 2.2 GElem/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/chain 1.00 3.3±0.07µs 18.6 MElem/sec 1.00 3.3±0.07µs 18.6 MElem/sec in_list_rewrite/fixed_size_binary_1/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=3/in_list 1.00 295.6±1.34ns 206.5 MElem/sec 1.01 299.9±2.18ns 203.5 MElem/sec in_list_rewrite/fixed_size_binary_1/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=3/chain 1.00 3.2±0.08µs 18.8 MElem/sec 1.00 3.3±0.08µs 18.8 MElem/sec in_list_rewrite/fixed_size_binary_1/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=3/in_list 1.00 341.6±4.16ns 178.7 MElem/sec 1.02 347.5±3.52ns 175.6 MElem/sec in_list_rewrite/fixed_size_binary_1/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=3/chain 1.02 49.6±1.59µs 157.5 MElem/sec 1.00 48.7±0.21µs 160.3 MElem/sec in_list_rewrite/fixed_size_binary_1/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=3/in_list 1.00 2.3±0.01µs 3.4 GElem/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/chain 1.01 49.1±0.08µs 159.0 MElem/sec 1.00 48.6±0.28µs 160.7 MElem/sec in_list_rewrite/fixed_size_binary_1/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=3/in_list 1.00 2.3±0.01µs 3.3 GElem/sec 1.01 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/chain 1.01 70.5±0.57µs 110.8 MElem/sec 1.00 69.8±0.44µs 111.8 MElem/sec in_list_rewrite/fixed_size_binary_1/miss/batch=8192/nulls=0%/match=0%/in/list=3/in_list 1.00 3.4±0.02µs 2.3 GElem/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/chain 1.00 70.5±0.67µs 110.8 MElem/sec 1.06 74.7±0.61µs 104.6 MElem/sec in_list_rewrite/fixed_size_binary_1/miss/batch=8192/nulls=0%/match=0%/not_in/list=3/in_list 1.00 3.4±0.02µs 2.2 GElem/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/chain 1.00 646.5±16.16ns 1510.5 KElem/sec 1.01 655.1±23.54ns 1490.8 KElem/sec in_list_rewrite/fixed_size_binary_1/single_row_hit/batch=1/nulls=0%/match=100%/in/list=3/in_list 1.00 280.3±2.04ns 3.4 MElem/sec 1.01 283.4±3.74ns 3.4 MElem/sec in_list_rewrite/fixed_size_binary_1/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=3/chain 1.00 653.3±18.18ns 1494.7 KElem/sec 1.00 653.7±28.60ns 1493.8 KElem/sec in_list_rewrite/fixed_size_binary_1/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=3/in_list 1.00 333.2±3.66ns 2.9 MElem/sec 1.01 336.4±2.56ns 2.8 MElem/sec in_list_rewrite/fixed_size_binary_1/single_row_miss/batch=1/nulls=0%/match=0%/in/list=3/chain 1.00 1794.9±49.38ns 544.1 KElem/sec 1.00 1786.3±48.06ns 546.7 KElem/sec in_list_rewrite/fixed_size_binary_1/single_row_miss/batch=1/nulls=0%/match=0%/in/list=3/in_list 1.00 279.8±1.83ns 3.4 MElem/sec 1.01 283.0±2.60ns 3.4 MElem/sec in_list_rewrite/fixed_size_binary_1/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=3/chain 1.00 1808.5±63.18ns 540.0 KElem/sec 1.02 1841.2±88.53ns 530.4 KElem/sec in_list_rewrite/fixed_size_binary_1/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=3/in_list 1.00 330.9±1.76ns 2.9 MElem/sec 1.02 336.6±2.95ns 2.8 MElem/sec in_list_rewrite/fixed_size_binary_1/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3/chain 1.01 26.6±0.39µs 293.9 MElem/sec 1.00 26.4±0.37µs 295.6 MElem/sec in_list_rewrite/fixed_size_binary_1/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3/in_list 1.00 3.4±0.01µs 2.3 GElem/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/chain 1.01 26.4±0.35µs 295.9 MElem/sec 1.00 26.3±0.37µs 297.4 MElem/sec in_list_rewrite/fixed_size_binary_1/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=3/in_list 1.00 3.4±0.01µs 2.2 GElem/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/chain 1.01 15.9±0.13µs 489.9 MElem/sec 1.00 15.8±0.27µs 493.8 MElem/sec in_list_rewrite/fixed_size_binary_16/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=3/in_list 1.00 9.7±0.03µs 802.9 MElem/sec 1.00 9.7±0.02µs 803.0 MElem/sec in_list_rewrite/fixed_size_binary_16/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=3/chain 1.00 15.8±0.13µs 494.0 MElem/sec 1.00 15.8±0.17µs 494.0 MElem/sec in_list_rewrite/fixed_size_binary_16/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=3/in_list 1.00 9.8±0.02µs 797.4 MElem/sec 1.00 9.8±0.04µs 795.5 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced/batch=8192/nulls=0%/match=50%/in/list=3/chain 1.00 48.2±0.39µs 161.9 MElem/sec 1.00 48.4±0.47µs 161.5 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced/batch=8192/nulls=0%/match=50%/in/list=3/in_list 1.00 9.7±0.06µs 802.4 MElem/sec 1.00 9.7±0.03µs 802.5 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced/batch=8192/nulls=0%/match=50%/not_in/list=3/chain 1.01 48.7±0.43µs 160.3 MElem/sec 1.00 48.4±0.47µs 161.6 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced/batch=8192/nulls=0%/match=50%/not_in/list=3/in_list 1.00 9.8±0.03µs 797.1 MElem/sec 1.00 9.8±0.03µs 795.3 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=3/chain 1.00 48.9±0.10µs 159.9 MElem/sec 1.00 49.0±0.30µs 159.6 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=3/in_list 1.00 9.8±0.02µs 794.1 MElem/sec 1.00 9.9±0.03µs 792.1 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=3/chain 1.00 49.0±0.44µs 159.4 MElem/sec 1.00 49.0±0.20µs 159.6 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=3/in_list 1.00 9.9±0.02µs 787.3 MElem/sec 1.00 9.9±0.02µs 787.6 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=3/chain 1.00 3.1±0.12µs 19.5 MElem/sec 1.00 3.1±0.14µs 19.4 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=3/in_list 1.00 335.1±3.61ns 182.2 MElem/sec 1.02 342.1±2.98ns 178.4 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=3/chain 1.00 3.1±0.11µs 19.6 MElem/sec 1.00 3.1±0.13µs 19.5 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=3/in_list 1.00 386.7±2.45ns 157.8 MElem/sec 1.01 389.1±3.12ns 156.9 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_unaligned/batch=8192/nulls=0%/match=50%/in/list=3/chain 1.00 49.6±0.91µs 157.6 MElem/sec 1.01 50.0±0.66µs 156.2 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_unaligned/batch=8192/nulls=0%/match=50%/in/list=3/in_list 1.00 11.7±0.06µs 669.3 MElem/sec 1.00 11.7±0.02µs 668.8 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_unaligned/batch=8192/nulls=0%/match=50%/not_in/list=3/chain 1.00 50.1±0.51µs 156.0 MElem/sec 1.00 50.2±0.96µs 155.7 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_unaligned/batch=8192/nulls=0%/match=50%/not_in/list=3/in_list 1.00 11.8±0.06µs 664.1 MElem/sec 1.00 11.8±0.06µs 663.9 MElem/sec in_list_rewrite/fixed_size_binary_16/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=3/chain 1.00 33.6±0.15µs 232.6 MElem/sec 1.01 33.8±0.08µs 231.1 MElem/sec in_list_rewrite/fixed_size_binary_16/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=3/in_list 1.00 7.5±0.02µs 1045.0 MElem/sec 1.01 7.5±0.03µs 1037.2 MElem/sec in_list_rewrite/fixed_size_binary_16/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=3/chain 1.00 33.5±0.16µs 233.1 MElem/sec 1.01 33.7±0.13µs 231.5 MElem/sec in_list_rewrite/fixed_size_binary_16/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=3/in_list 1.00 7.5±0.01µs 1035.3 MElem/sec 1.01 7.6±0.03µs 1028.6 MElem/sec in_list_rewrite/fixed_size_binary_16/miss/batch=8192/nulls=0%/match=0%/in/list=3/chain 1.00 47.1±0.38µs 165.8 MElem/sec 1.02 48.1±0.45µs 162.4 MElem/sec in_list_rewrite/fixed_size_binary_16/miss/batch=8192/nulls=0%/match=0%/in/list=3/in_list 1.00 9.7±0.03µs 804.0 MElem/sec 1.00 9.7±0.02µs 802.6 MElem/sec in_list_rewrite/fixed_size_binary_16/miss/batch=8192/nulls=0%/match=0%/not_in/list=3/chain 1.00 47.2±0.59µs 165.6 MElem/sec 1.00 47.3±0.69µs 165.2 MElem/sec in_list_rewrite/fixed_size_binary_16/miss/batch=8192/nulls=0%/match=0%/not_in/list=3/in_list 1.00 9.8±0.04µs 795.7 MElem/sec 1.00 9.8±0.02µs 796.1 MElem/sec in_list_rewrite/fixed_size_binary_16/single_row_hit/batch=1/nulls=0%/match=100%/in/list=3/chain 1.00 650.1±22.79ns 1502.1 KElem/sec 1.02 662.1±29.38ns 1474.9 KElem/sec in_list_rewrite/fixed_size_binary_16/single_row_hit/batch=1/nulls=0%/match=100%/in/list=3/in_list 1.00 268.9±2.58ns 3.5 MElem/sec 1.04 279.8±2.04ns 3.4 MElem/sec in_list_rewrite/fixed_size_binary_16/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=3/chain 1.00 651.5±23.77ns 1499.1 KElem/sec 1.01 660.4±29.39ns 1478.6 KElem/sec in_list_rewrite/fixed_size_binary_16/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=3/in_list 1.00 318.8±1.98ns 3.0 MElem/sec 1.03 326.8±1.80ns 2.9 MElem/sec in_list_rewrite/fixed_size_binary_16/single_row_miss/batch=1/nulls=0%/match=0%/in/list=3/chain 1.00 1824.9±81.99ns 535.1 KElem/sec 1.00 1826.5±93.78ns 534.7 KElem/sec in_list_rewrite/fixed_size_binary_16/single_row_miss/batch=1/nulls=0%/match=0%/in/list=3/in_list 1.00 268.9±1.58ns 3.5 MElem/sec 1.02 273.1±2.38ns 3.5 MElem/sec in_list_rewrite/fixed_size_binary_16/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=3/chain 1.00 1825.7±81.53ns 534.9 KElem/sec 1.02 1859.0±115.47ns 525.3 KElem/sec in_list_rewrite/fixed_size_binary_16/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=3/in_list 1.00 319.8±1.84ns 3.0 MElem/sec 1.04 332.1±4.83ns 2.9 MElem/sec in_list_rewrite/fixed_size_binary_16/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3/chain 1.00 18.7±0.09µs 416.9 MElem/sec 1.00 18.8±0.19µs 415.3 MElem/sec in_list_rewrite/fixed_size_binary_16/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3/in_list 1.00 9.7±0.02µs 803.4 MElem/sec 1.00 9.7±0.03µs 802.9 MElem/sec in_list_rewrite/fixed_size_binary_16/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=3/chain 1.00 18.5±0.05µs 421.5 MElem/sec 1.01 18.7±0.06µs 418.8 MElem/sec in_list_rewrite/fixed_size_binary_16/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=3/in_list 1.00 9.8±0.02µs 796.9 MElem/sec 1.00 9.8±0.03µs 795.5 MElem/sec in_list_rewrite/fixed_size_binary_2/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=3/chain 1.01 20.8±0.13µs 375.7 MElem/sec 1.00 20.6±0.14µs 379.0 MElem/sec in_list_rewrite/fixed_size_binary_2/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=3/in_list 1.00 3.5±0.01µs 2.2 GElem/sec 1.00 3.5±0.02µ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/chain 1.01 20.8±0.20µs 375.6 MElem/sec 1.00 20.7±0.29µs 377.8 MElem/sec in_list_rewrite/fixed_size_binary_2/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=3/in_list 1.00 3.6±0.01µs 2.1 GElem/sec 1.00 3.6±0.03µs 2.1 GElem/sec in_list_rewrite/fixed_size_binary_2/balanced/batch=8192/nulls=0%/match=50%/in/list=3/chain 1.01 83.0±0.68µs 94.1 MElem/sec 1.00 82.3±2.06µs 95.0 MElem/sec in_list_rewrite/fixed_size_binary_2/balanced/batch=8192/nulls=0%/match=50%/in/list=3/in_list 1.00 3.5±0.02µs 2.2 GElem/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/chain 1.01 82.9±0.45µs 94.3 MElem/sec 1.00 82.2±2.35µs 95.0 MElem/sec in_list_rewrite/fixed_size_binary_2/balanced/batch=8192/nulls=0%/match=50%/not_in/list=3/in_list 1.00 3.6±0.01µs 2.1 GElem/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/chain 1.01 87.7±0.38µs 89.1 MElem/sec 1.00 86.7±0.41µs 90.1 MElem/sec in_list_rewrite/fixed_size_binary_2/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=3/in_list 1.00 3.6±0.01µs 2.1 GElem/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/chain 1.01 87.6±0.25µs 89.2 MElem/sec 1.00 86.4±0.25µs 90.5 MElem/sec in_list_rewrite/fixed_size_binary_2/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=3/in_list 1.00 3.7±0.01µs 2.1 GElem/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/chain 1.00 3.3±0.10µs 18.7 MElem/sec 1.00 3.3±0.11µs 18.7 MElem/sec in_list_rewrite/fixed_size_binary_2/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=3/in_list 1.00 303.9±3.87ns 200.9 MElem/sec 1.00 304.6±3.38ns 200.3 MElem/sec in_list_rewrite/fixed_size_binary_2/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=3/chain 1.01 3.3±0.10µs 18.6 MElem/sec 1.00 3.3±0.11µs 18.7 MElem/sec in_list_rewrite/fixed_size_binary_2/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=3/in_list 1.00 349.1±1.61ns 174.8 MElem/sec 1.00 350.4±3.45ns 174.2 MElem/sec in_list_rewrite/fixed_size_binary_2/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=3/chain 1.01 62.7±0.42µs 124.7 MElem/sec 1.00 61.9±0.26µs 126.3 MElem/sec in_list_rewrite/fixed_size_binary_2/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=3/in_list 1.00 2.2±0.01µs 3.5 GElem/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/chain 1.02 62.8±0.42µs 124.4 MElem/sec 1.00 61.8±0.31µs 126.4 MElem/sec in_list_rewrite/fixed_size_binary_2/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=3/in_list 1.00 2.2±0.01µs 3.4 GElem/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/chain 1.00 62.2±0.42µs 125.5 MElem/sec 1.11 69.1±2.40µs 113.0 MElem/sec in_list_rewrite/fixed_size_binary_2/miss/batch=8192/nulls=0%/match=0%/in/list=3/in_list 1.00 3.5±0.02µs 2.2 GElem/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/chain 1.00 62.3±0.57µs 125.4 MElem/sec 1.00 62.3±2.59µs 125.4 MElem/sec in_list_rewrite/fixed_size_binary_2/miss/batch=8192/nulls=0%/match=0%/not_in/list=3/in_list 1.00 3.6±0.02µs 2.1 GElem/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/chain 1.00 647.9±18.19ns 1507.3 KElem/sec 1.00 645.0±19.81ns 1514.0 KElem/sec in_list_rewrite/fixed_size_binary_2/single_row_hit/batch=1/nulls=0%/match=100%/in/list=3/in_list 1.01 289.8±3.26ns 3.3 MElem/sec 1.00 288.1±2.57ns 3.3 MElem/sec in_list_rewrite/fixed_size_binary_2/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=3/chain 1.00 645.6±18.66ns 1512.6 KElem/sec 1.00 647.7±19.20ns 1507.8 KElem/sec in_list_rewrite/fixed_size_binary_2/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=3/in_list 1.00 341.2±3.86ns 2.8 MElem/sec 1.00 339.9±2.41ns 2.8 MElem/sec in_list_rewrite/fixed_size_binary_2/single_row_miss/batch=1/nulls=0%/match=0%/in/list=3/chain 1.00 1826.7±65.64ns 534.6 KElem/sec 1.00 1821.8±75.97ns 536.0 KElem/sec in_list_rewrite/fixed_size_binary_2/single_row_miss/batch=1/nulls=0%/match=0%/in/list=3/in_list 1.00 285.3±1.18ns 3.3 MElem/sec 1.01 287.6±2.59ns 3.3 MElem/sec in_list_rewrite/fixed_size_binary_2/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=3/chain 1.00 1829.0±63.06ns 533.9 KElem/sec 1.00 1836.5±75.72ns 531.8 KElem/sec in_list_rewrite/fixed_size_binary_2/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=3/in_list 1.00 338.3±3.00ns 2.8 MElem/sec 1.01 342.1±2.81ns 2.8 MElem/sec in_list_rewrite/fixed_size_binary_2/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3/chain 1.01 24.2±0.32µs 323.1 MElem/sec 1.00 24.1±0.40µs 324.8 MElem/sec in_list_rewrite/fixed_size_binary_2/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3/in_list 1.00 3.5±0.02µs 2.2 GElem/sec 1.00 3.5±0.02µs 2.2 GElem/sec in_list_rewrite/fixed_size_binary_2/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=3/chain 1.00 24.0±0.34µs 324.9 MElem/sec 1.00 23.9±0.41µs 326.3 MElem/sec in_list_rewrite/fixed_size_binary_2/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=3/in_list 1.00 3.6±0.01µs 2.1 GElem/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/chain 1.00 18.0±0.20µs 432.8 MElem/sec 1.00 18.0±0.12µs 433.9 MElem/sec in_list_rewrite/fixed_size_binary_4/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=3/in_list 1.00 3.2±0.01µs 2.4 GElem/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/chain 1.00 18.0±0.18µs 433.2 MElem/sec 1.00 18.0±0.13µs 433.4 MElem/sec in_list_rewrite/fixed_size_binary_4/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=3/in_list 1.00 3.2±0.02µs 2.4 GElem/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/chain 1.00 55.1±0.40µs 141.9 MElem/sec 1.00 54.9±0.45µs 142.3 MElem/sec in_list_rewrite/fixed_size_binary_4/balanced/batch=8192/nulls=0%/match=50%/in/list=3/in_list 1.00 3.2±0.01µs 2.4 GElem/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/chain 1.00 55.1±0.44µs 141.8 MElem/sec 1.02 56.3±0.82µs 138.8 MElem/sec in_list_rewrite/fixed_size_binary_4/balanced/batch=8192/nulls=0%/match=50%/not_in/list=3/in_list 1.00 3.2±0.01µs 2.4 GElem/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/chain 1.01 55.9±0.58µs 139.8 MElem/sec 1.00 55.6±0.20µs 140.6 MElem/sec in_list_rewrite/fixed_size_binary_4/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=3/in_list 1.00 3.3±0.02µs 2.3 GElem/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/chain 1.01 55.7±0.13µs 140.2 MElem/sec 1.00 55.4±0.16µs 140.9 MElem/sec in_list_rewrite/fixed_size_binary_4/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=3/in_list 1.00 3.3±0.01µs 2.3 GElem/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/chain 1.00 3.2±0.12µs 19.4 MElem/sec 1.01 3.2±0.10µs 19.1 MElem/sec in_list_rewrite/fixed_size_binary_4/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=3/in_list 1.00 300.3±2.38ns 203.3 MElem/sec 1.02 306.4±2.05ns 199.2 MElem/sec in_list_rewrite/fixed_size_binary_4/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=3/chain 1.00 3.2±0.09µs 19.4 MElem/sec 1.01 3.2±0.09µs 19.2 MElem/sec in_list_rewrite/fixed_size_binary_4/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=3/in_list 1.00 347.0±1.70ns 175.9 MElem/sec 1.02 355.6±2.05ns 171.6 MElem/sec in_list_rewrite/fixed_size_binary_4/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=3/chain 1.00 38.0±0.14µs 205.5 MElem/sec 1.00 37.9±0.07µs 206.2 MElem/sec in_list_rewrite/fixed_size_binary_4/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=3/in_list 1.00 2.1±0.01µs 3.6 GElem/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/chain 1.05 39.8±0.22µs 196.3 MElem/sec 1.00 37.9±0.10µs 206.3 MElem/sec in_list_rewrite/fixed_size_binary_4/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=3/in_list 1.00 2.2±0.00µs 3.5 GElem/sec 1.00 2.2±0.01µs 3.5 GElem/sec in_list_rewrite/fixed_size_binary_4/miss/batch=8192/nulls=0%/match=0%/in/list=3/chain 1.00 53.9±0.42µs 144.9 MElem/sec 1.00 53.8±0.45µs 145.3 MElem/sec in_list_rewrite/fixed_size_binary_4/miss/batch=8192/nulls=0%/match=0%/in/list=3/in_list 1.00 3.2±0.01µs 2.4 GElem/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/chain 1.02 55.0±1.51µs 142.0 MElem/sec 1.00 54.0±0.85µs 144.6 MElem/sec in_list_rewrite/fixed_size_binary_4/miss/batch=8192/nulls=0%/match=0%/not_in/list=3/in_list 1.00 3.2±0.01µs 2.4 GElem/sec 1.00 3.2±0.00µs 2.4 GElem/sec in_list_rewrite/fixed_size_binary_4/single_row_hit/batch=1/nulls=0%/match=100%/in/list=3/chain 1.00 646.5±22.35ns 1510.5 KElem/sec 1.02 661.3±19.32ns 1476.8 KElem/sec in_list_rewrite/fixed_size_binary_4/single_row_hit/batch=1/nulls=0%/match=100%/in/list=3/in_list 1.00 282.8±2.55ns 3.4 MElem/sec 1.02 288.3±2.14ns 3.3 MElem/sec in_list_rewrite/fixed_size_binary_4/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=3/chain 1.00 645.7±17.94ns 1512.3 KElem/sec 1.02 655.5±19.32ns 1489.8 KElem/sec in_list_rewrite/fixed_size_binary_4/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=3/in_list 1.00 340.6±1.78ns 2.8 MElem/sec 1.01 343.8±3.44ns 2.8 MElem/sec in_list_rewrite/fixed_size_binary_4/single_row_miss/batch=1/nulls=0%/match=0%/in/list=3/chain 1.02 1866.4±416.25ns 523.2 KElem/sec 1.00 1835.1±63.17ns 532.1 KElem/sec in_list_rewrite/fixed_size_binary_4/single_row_miss/batch=1/nulls=0%/match=0%/in/list=3/in_list 1.00 288.7±1.81ns 3.3 MElem/sec 1.00 288.6±1.85ns 3.3 MElem/sec in_list_rewrite/fixed_size_binary_4/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=3/chain 1.00 1824.0±75.10ns 535.4 KElem/sec 1.01 1851.3±66.95ns 527.5 KElem/sec in_list_rewrite/fixed_size_binary_4/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=3/in_list 1.00 340.5±3.37ns 2.8 MElem/sec 1.00 340.4±2.16ns 2.8 MElem/sec in_list_rewrite/fixed_size_binary_4/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3/chain 1.00 21.0±0.36µs 371.4 MElem/sec 1.01 21.3±0.74µs 367.3 MElem/sec in_list_rewrite/fixed_size_binary_4/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3/in_list 1.00 3.2±0.01µs 2.4 GElem/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/chain 1.00 20.8±0.26µs 375.2 MElem/sec 1.01 21.1±0.52µs 370.2 MElem/sec in_list_rewrite/fixed_size_binary_4/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=3/in_list 1.00 3.2±0.01µs 2.4 GElem/sec 1.00 3.2±0.02µs 2.4 GElem/sec in_list_rewrite/fixed_size_binary_8/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=3/chain 1.01 15.5±0.13µs 502.9 MElem/sec 1.00 15.4±0.14µs 505.9 MElem/sec in_list_rewrite/fixed_size_binary_8/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=3/in_list 1.00 3.8±0.02µs 2.0 GElem/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/chain 1.00 15.4±0.12µs 505.7 MElem/sec 1.00 15.4±0.12µs 506.5 MElem/sec in_list_rewrite/fixed_size_binary_8/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=3/in_list 1.00 3.8±0.01µs 2039.0 MElem/sec 1.00 3.8±0.01µs 2038.2 MElem/sec in_list_rewrite/fixed_size_binary_8/balanced/batch=8192/nulls=0%/match=50%/in/list=3/chain 1.00 47.3±0.37µs 165.2 MElem/sec 1.00 47.2±0.40µs 165.5 MElem/sec in_list_rewrite/fixed_size_binary_8/balanced/batch=8192/nulls=0%/match=50%/in/list=3/in_list 1.00 3.8±0.01µs 2.0 GElem/sec 1.00 3.8±0.03µs 2.0 GElem/sec in_list_rewrite/fixed_size_binary_8/balanced/batch=8192/nulls=0%/match=50%/not_in/list=3/chain 1.00 47.3±0.42µs 165.3 MElem/sec 1.00 47.2±0.42µs 165.6 MElem/sec in_list_rewrite/fixed_size_binary_8/balanced/batch=8192/nulls=0%/match=50%/not_in/list=3/in_list 1.00 3.8±0.01µs 2040.0 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/chain 1.00 47.9±0.11µs 163.0 MElem/sec 1.00 47.9±0.46µs 162.9 MElem/sec in_list_rewrite/fixed_size_binary_8/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=3/in_list 1.00 3.9±0.01µs 2014.3 MElem/sec 1.00 3.9±0.01µs 2013.6 MElem/sec in_list_rewrite/fixed_size_binary_8/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=3/chain 1.00 47.9±0.10µs 163.1 MElem/sec 1.00 47.8±0.12µs 163.5 MElem/sec in_list_rewrite/fixed_size_binary_8/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=3/in_list 1.00 3.9±0.01µs 1987.6 MElem/sec 1.00 3.9±0.01µs 1984.2 MElem/sec in_list_rewrite/fixed_size_binary_8/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=3/chain 1.00 3.1±0.10µs 19.6 MElem/sec 1.00 3.1±0.11µs 19.7 MElem/sec in_list_rewrite/fixed_size_binary_8/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=3/in_list 1.00 303.8±2.44ns 200.9 MElem/sec 1.00 303.7±3.67ns 200.9 MElem/sec in_list_rewrite/fixed_size_binary_8/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=3/chain 1.00 3.1±0.10µs 19.7 MElem/sec 1.01 3.1±0.11µs 19.5 MElem/sec in_list_rewrite/fixed_size_binary_8/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=3/in_list 1.00 346.1±2.51ns 176.3 MElem/sec 1.01 348.3±2.33ns 175.2 MElem/sec in_list_rewrite/fixed_size_binary_8/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=3/chain 1.00 32.9±0.20µs 237.6 MElem/sec 1.00 32.7±0.11µs 238.6 MElem/sec in_list_rewrite/fixed_size_binary_8/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=3/in_list 1.00 2.2±0.01µs 3.4 GElem/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/chain 1.00 32.7±0.19µs 238.6 MElem/sec 1.00 32.8±0.09µs 238.3 MElem/sec in_list_rewrite/fixed_size_binary_8/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=3/in_list 1.00 2.3±0.01µs 3.3 GElem/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/chain 1.00 46.3±0.37µs 168.7 MElem/sec 1.00 46.1±0.39µs 169.4 MElem/sec in_list_rewrite/fixed_size_binary_8/miss/batch=8192/nulls=0%/match=0%/in/list=3/in_list 1.00 3.8±0.02µs 2.0 GElem/sec 1.00 3.8±0.01µs 2.0 GElem/sec in_list_rewrite/fixed_size_binary_8/miss/batch=8192/nulls=0%/match=0%/not_in/list=3/chain 1.00 46.2±0.37µs 169.2 MElem/sec 1.00 46.1±0.44µs 169.4 MElem/sec in_list_rewrite/fixed_size_binary_8/miss/batch=8192/nulls=0%/match=0%/not_in/list=3/in_list 1.00 3.8±0.01µs 2039.0 MElem/sec 1.00 3.8±0.02µs 2035.6 MElem/sec in_list_rewrite/fixed_size_binary_8/single_row_hit/batch=1/nulls=0%/match=100%/in/list=3/chain 1.00 651.2±20.50ns 1499.7 KElem/sec 1.00 652.6±22.37ns 1496.3 KElem/sec in_list_rewrite/fixed_size_binary_8/single_row_hit/batch=1/nulls=0%/match=100%/in/list=3/in_list 1.01 288.0±0.93ns 3.3 MElem/sec 1.00 284.8±2.27ns 3.3 MElem/sec in_list_rewrite/fixed_size_binary_8/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=3/chain 1.00 648.7±21.60ns 1505.5 KElem/sec 1.01 657.0±23.89ns 1486.4 KElem/sec in_list_rewrite/fixed_size_binary_8/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=3/in_list 1.01 337.0±1.69ns 2.8 MElem/sec 1.00 334.4±2.57ns 2.9 MElem/sec in_list_rewrite/fixed_size_binary_8/single_row_miss/batch=1/nulls=0%/match=0%/in/list=3/chain 1.00 1814.3±65.38ns 538.3 KElem/sec 1.01 1837.1±76.00ns 531.6 KElem/sec in_list_rewrite/fixed_size_binary_8/single_row_miss/batch=1/nulls=0%/match=0%/in/list=3/in_list 1.00 280.9±1.40ns 3.4 MElem/sec 1.02 285.2±2.90ns 3.3 MElem/sec in_list_rewrite/fixed_size_binary_8/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=3/chain 1.00 1813.8±74.31ns 538.4 KElem/sec 1.01 1824.3±73.76ns 535.3 KElem/sec in_list_rewrite/fixed_size_binary_8/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=3/in_list 1.00 330.7±1.26ns 2.9 MElem/sec 1.01 333.1±2.87ns 2.9 MElem/sec in_list_rewrite/fixed_size_binary_8/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3/chain 1.00 18.4±0.20µs 425.2 MElem/sec 1.00 18.5±0.27µs 423.3 MElem/sec in_list_rewrite/fixed_size_binary_8/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3/in_list 1.00 3.8±0.01µs 2.0 GElem/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/chain 1.00 18.2±0.21µs 430.2 MElem/sec 1.01 18.4±0.39µs 425.2 MElem/sec in_list_rewrite/fixed_size_binary_8/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=3/in_list 1.00 3.8±0.01µs 2038.4 MElem/sec 1.01 3.9±0.05µs 2026.5 MElem/sec in_list_rewrite/float32/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=3/chain 1.00 4.7±0.02µs 1655.2 MElem/sec 1.00 4.7±0.01µs 1651.2 MElem/sec in_list_rewrite/float32/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=3/in_list 1.00 3.0±0.01µs 2.5 GElem/sec 1.00 3.1±0.01µs 2.5 GElem/sec in_list_rewrite/float32/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=3/chain 1.00 4.7±0.01µs 1663.7 MElem/sec 1.01 4.7±0.07µs 1652.0 MElem/sec in_list_rewrite/float32/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=3/in_list 1.00 3.1±0.02µs 2.5 GElem/sec 1.00 3.1±0.07µs 2.4 GElem/sec in_list_rewrite/float32/balanced/batch=8192/nulls=0%/match=50%/in/list=3/chain 1.01 15.0±0.10µs 520.2 MElem/sec 1.00 14.8±0.10µs 526.2 MElem/sec in_list_rewrite/float32/balanced/batch=8192/nulls=0%/match=50%/in/list=3/in_list 1.00 3.1±0.01µs 2.5 GElem/sec 1.00 3.1±0.01µs 2.5 GElem/sec in_list_rewrite/float32/balanced/batch=8192/nulls=0%/match=50%/not_in/list=3/chain 1.00 15.0±0.18µs 519.8 MElem/sec 1.01 15.1±0.31µs 516.4 MElem/sec in_list_rewrite/float32/balanced/batch=8192/nulls=0%/match=50%/not_in/list=3/in_list 1.00 3.1±0.01µs 2.4 GElem/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/chain 1.00 15.7±0.12µs 496.6 MElem/sec 1.00 15.7±0.07µs 496.9 MElem/sec in_list_rewrite/float32/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=3/in_list 1.00 3.1±0.01µs 2.4 GElem/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/chain 1.00 15.6±0.05µs 500.0 MElem/sec 1.00 15.7±0.13µs 498.9 MElem/sec in_list_rewrite/float32/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=3/in_list 1.00 3.2±0.01µs 2.4 GElem/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/chain 1.00 2.2±0.01µs 27.6 MElem/sec 1.00 2.2±0.42µs 27.5 MElem/sec in_list_rewrite/float32/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=3/in_list 1.00 182.2±2.09ns 335.1 MElem/sec 1.03 187.9±4.75ns 324.9 MElem/sec in_list_rewrite/float32/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=3/chain 1.01 2.2±0.01µs 27.7 MElem/sec 1.00 2.2±0.02µs 28.1 MElem/sec in_list_rewrite/float32/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=3/in_list 1.00 228.7±2.96ns 266.9 MElem/sec 1.03 236.1±4.37ns 258.5 MElem/sec in_list_rewrite/float32/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=3/chain 1.00 14.4±0.05µs 544.0 MElem/sec 1.00 14.3±0.07µs 544.8 MElem/sec in_list_rewrite/float32/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=3/in_list 1.00 2.0±0.01µs 3.8 GElem/sec 1.00 2.0±0.00µs 3.8 GElem/sec in_list_rewrite/float32/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=3/chain 1.00 14.3±0.06µs 545.2 MElem/sec 1.00 14.3±0.06µs 546.7 MElem/sec in_list_rewrite/float32/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=3/in_list 1.00 2.1±0.01µs 3.7 GElem/sec 1.00 2.1±0.02µs 3.7 GElem/sec in_list_rewrite/float32/miss/batch=8192/nulls=0%/match=0%/in/list=3/chain 1.07 15.2±0.18µs 515.3 MElem/sec 1.00 14.1±0.33µs 553.9 MElem/sec in_list_rewrite/float32/miss/batch=8192/nulls=0%/match=0%/in/list=3/in_list 1.00 3.1±0.01µs 2.5 GElem/sec 1.00 3.1±0.02µs 2.5 GElem/sec in_list_rewrite/float32/miss/batch=8192/nulls=0%/match=0%/not_in/list=3/chain 1.01 14.0±0.09µs 558.9 MElem/sec 1.00 13.9±0.09µs 563.5 MElem/sec in_list_rewrite/float32/miss/batch=8192/nulls=0%/match=0%/not_in/list=3/in_list 1.00 3.1±0.01µs 2.4 GElem/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/chain 1.00 450.1±1.87ns 2.1 MElem/sec 1.01 456.1±6.53ns 2.1 MElem/sec in_list_rewrite/float32/single_row_hit/batch=1/nulls=0%/match=100%/in/list=3/in_list 1.00 172.9±1.49ns 5.5 MElem/sec 1.06 182.5±3.97ns 5.2 MElem/sec in_list_rewrite/float32/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=3/chain 1.00 452.7±3.77ns 2.1 MElem/sec 1.00 451.1±4.06ns 2.1 MElem/sec in_list_rewrite/float32/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=3/in_list 1.00 214.9±2.94ns 4.4 MElem/sec 1.04 224.4±3.97ns 4.2 MElem/sec in_list_rewrite/float32/single_row_miss/batch=1/nulls=0%/match=0%/in/list=3/chain 1.02 1196.1±11.99ns 816.5 KElem/sec 1.00 1178.1±6.43ns 829.0 KElem/sec in_list_rewrite/float32/single_row_miss/batch=1/nulls=0%/match=0%/in/list=3/in_list 1.00 173.5±1.67ns 5.5 MElem/sec 1.04 179.6±4.04ns 5.3 MElem/sec in_list_rewrite/float32/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=3/chain 1.03 1210.0±7.96ns 807.1 KElem/sec 1.00 1179.0±6.75ns 828.3 KElem/sec in_list_rewrite/float32/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=3/in_list 1.00 217.2±2.37ns 4.4 MElem/sec 1.03 224.5±4.11ns 4.2 MElem/sec in_list_rewrite/float32/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3/chain 1.00 6.8±0.02µs 1152.0 MElem/sec 1.00 6.8±0.07µs 1153.4 MElem/sec in_list_rewrite/float32/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3/in_list 1.00 3.0±0.01µs 2.5 GElem/sec 1.00 3.1±0.02µs 2.5 GElem/sec in_list_rewrite/float32/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=3/chain 1.00 6.6±0.03µs 1182.1 MElem/sec 1.00 6.6±0.03µs 1183.2 MElem/sec in_list_rewrite/float32/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=3/in_list 1.00 3.1±0.01µs 2.5 GElem/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/chain 1.00 4.7±0.01µs 1678.8 MElem/sec 1.01 4.7±0.02µs 1669.4 MElem/sec in_list_rewrite/float64/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=3/in_list 1.00 3.6±0.01µs 2.1 GElem/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/chain 1.01 4.7±0.19µs 1651.3 MElem/sec 1.00 4.7±0.01µs 1673.7 MElem/sec in_list_rewrite/float64/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=3/in_list 1.00 3.7±0.01µs 2.1 GElem/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/chain 1.00 14.8±0.05µs 527.7 MElem/sec 1.00 14.8±0.04µs 527.9 MElem/sec in_list_rewrite/float64/balanced/batch=8192/nulls=0%/match=50%/in/list=3/in_list 1.00 3.6±0.01µs 2.1 GElem/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/chain 1.00 15.0±0.17µs 522.2 MElem/sec 1.00 15.0±0.28µs 520.5 MElem/sec in_list_rewrite/float64/balanced/batch=8192/nulls=0%/match=50%/not_in/list=3/in_list 1.00 3.7±0.02µs 2.1 GElem/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/chain 1.00 15.6±0.05µs 499.6 MElem/sec 1.00 15.7±0.09µs 497.7 MElem/sec in_list_rewrite/float64/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=3/in_list 1.00 3.7±0.01µs 2.0 GElem/sec 1.00 3.7±0.02µs 2.0 GElem/sec in_list_rewrite/float64/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=3/chain 1.00 15.5±0.04µs 503.3 MElem/sec 1.00 15.6±0.07µs 501.0 MElem/sec in_list_rewrite/float64/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=3/in_list 1.00 3.8±0.01µs 2.0 GElem/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/chain 1.00 2.2±0.01µs 28.0 MElem/sec 1.00 2.2±0.01µs 27.9 MElem/sec in_list_rewrite/float64/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=3/in_list 1.00 181.0±1.61ns 337.2 MElem/sec 1.04 188.2±4.76ns 324.3 MElem/sec in_list_rewrite/float64/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=3/chain 1.01 2.2±0.01µs 27.5 MElem/sec 1.00 2.2±0.01µs 27.9 MElem/sec in_list_rewrite/float64/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=3/in_list 1.00 226.3±3.91ns 269.7 MElem/sec 1.03 232.4±5.07ns 262.6 MElem/sec in_list_rewrite/float64/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=3/chain 1.00 14.3±0.07µs 547.9 MElem/sec 1.00 14.3±0.11µs 546.9 MElem/sec in_list_rewrite/float64/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=3/in_list 1.01 2.1±0.01µs 3.6 GElem/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/chain 1.00 14.3±0.08µs 547.2 MElem/sec 1.01 14.4±0.11µs 542.6 MElem/sec in_list_rewrite/float64/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=3/in_list 1.01 2.2±0.01µs 3.5 GElem/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/chain 1.00 13.8±0.04µs 566.8 MElem/sec 1.00 13.7±0.05µs 568.8 MElem/sec in_list_rewrite/float64/miss/batch=8192/nulls=0%/match=0%/in/list=3/in_list 1.00 3.6±0.02µs 2.1 GElem/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/chain 1.00 13.7±0.03µs 568.7 MElem/sec 1.00 13.8±0.06µs 567.8 MElem/sec in_list_rewrite/float64/miss/batch=8192/nulls=0%/match=0%/not_in/list=3/in_list 1.00 3.7±0.01µs 2.1 GElem/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/chain 1.00 459.6±3.10ns 2.1 MElem/sec 1.00 457.7±6.73ns 2.1 MElem/sec in_list_rewrite/float64/single_row_hit/batch=1/nulls=0%/match=100%/in/list=3/in_list 1.00 172.0±2.89ns 5.5 MElem/sec 1.06 181.7±3.02ns 5.2 MElem/sec in_list_rewrite/float64/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=3/chain 1.00 456.8±3.60ns 2.1 MElem/sec 1.01 463.3±2.70ns 2.1 MElem/sec in_list_rewrite/float64/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=3/in_list 1.00 216.4±7.40ns 4.4 MElem/sec 1.01 218.8±3.14ns 4.4 MElem/sec in_list_rewrite/float64/single_row_miss/batch=1/nulls=0%/match=0%/in/list=3/chain 1.02 1169.7±11.10ns 834.9 KElem/sec 1.00 1144.1±8.03ns 853.6 KElem/sec in_list_rewrite/float64/single_row_miss/batch=1/nulls=0%/match=0%/in/list=3/in_list 1.00 173.5±6.33ns 5.5 MElem/sec 1.03 178.2±4.15ns 5.4 MElem/sec in_list_rewrite/float64/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=3/chain 1.02 1175.9±7.33ns 830.5 KElem/sec 1.00 1152.3±7.37ns 847.5 KElem/sec in_list_rewrite/float64/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=3/in_list 1.00 212.1±5.66ns 4.5 MElem/sec 1.02 215.4±4.72ns 4.4 MElem/sec in_list_rewrite/float64/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3/chain 1.00 6.7±0.02µs 1158.1 MElem/sec 1.01 6.8±0.02µs 1147.8 MElem/sec in_list_rewrite/float64/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=3/in_list 1.00 3.6±0.01µs 2.1 GElem/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/chain 1.00 6.6±0.03µs 1186.5 MElem/sec 1.00 6.6±0.02µs 1181.9 MElem/sec in_list_rewrite/float64/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=3/in_list 1.00 3.7±0.01µs 2.1 GElem/sec 1.00 3.7±0.03µs 2.1 GElem/sec ``` </p> </details> <details><summary>Resource Usage</summary> **in_list_rewrite — base (merge-base)** | Metric | Value | |--------|-------| | Wall time | 400.1s | | Peak memory | 66.5 MiB | | Avg memory | 37.9 MiB | | CPU user | 901.1s | | CPU sys | 3.0s | | Peak spill | 0 B | **in_list_rewrite — branch** | Metric | Value | |--------|-------| | Wall time | 390.1s | | Peak memory | 64.2 MiB | | Avg memory | 37.3 MiB | | CPU user | 902.6s | | CPU sys | 3.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: [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]
