adriangbot commented on PR #25187: URL: https://github.com/apache/datafusion/pull/25187#issuecomment-5994900250
🤖 Benchmark completed (GKE) | [trigger](https://github.com/apache/datafusion/pull/25187#issuecomment-5994636126) **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=2/" 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=2/chain 1.09 25.5±1.72µs 306.5 MElem/sec 1.00 23.3±0.52µs 335.2 MElem/sec in_list_rewrite/fixed_size_binary_1/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=2/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_1/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=2/chain 1.01 23.6±0.32µs 331.3 MElem/sec 1.00 23.4±0.64µs 334.0 MElem/sec in_list_rewrite/fixed_size_binary_1/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=2/in_list 1.00 2.3±0.01µs 3.4 GElem/sec 1.00 2.3±0.01µs 3.3 GElem/sec in_list_rewrite/fixed_size_binary_1/balanced/batch=8192/nulls=0%/match=50%/in/list=2/chain 1.01 47.7±0.52µs 163.9 MElem/sec 1.00 47.1±1.22µs 165.9 MElem/sec in_list_rewrite/fixed_size_binary_1/balanced/batch=8192/nulls=0%/match=50%/in/list=2/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_1/balanced/batch=8192/nulls=0%/match=50%/not_in/list=2/chain 1.03 48.7±2.44µs 160.5 MElem/sec 1.00 47.0±1.13µs 166.1 MElem/sec in_list_rewrite/fixed_size_binary_1/balanced/batch=8192/nulls=0%/match=50%/not_in/list=2/in_list 1.00 2.3±0.01µs 3.4 GElem/sec 1.00 2.3±0.01µs 3.3 GElem/sec in_list_rewrite/fixed_size_binary_1/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=2/chain 1.01 47.9±0.13µs 163.2 MElem/sec 1.00 47.4±0.29µs 164.8 MElem/sec in_list_rewrite/fixed_size_binary_1/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=2/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_1/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=2/chain 1.01 47.8±0.14µs 163.5 MElem/sec 1.00 47.3±0.20µs 165.0 MElem/sec in_list_rewrite/fixed_size_binary_1/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=2/in_list 1.00 2.4±0.01µs 3.2 GElem/sec 1.00 2.4±0.01µs 3.2 GElem/sec in_list_rewrite/fixed_size_binary_1/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=2/chain 1.02 1978.8±53.78ns 30.8 MElem/sec 1.00 1944.1±46.57ns 31.4 MElem/sec in_list_rewrite/fixed_size_binary_1/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=2/in_list 1.00 291.6±2.19ns 209.3 MElem/sec 1.00 291.8±1.57ns 209.2 MElem/sec in_list_rewrite/fixed_size_binary_1/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=2/chain 1.00 1969.6±47.49ns 31.0 MElem/sec 1.01 1998.7±461.51ns 30.5 MElem/sec in_list_rewrite/fixed_size_binary_1/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=2/in_list 1.01 347.2±3.54ns 175.8 MElem/sec 1.00 344.9±2.48ns 177.0 MElem/sec in_list_rewrite/fixed_size_binary_1/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=2/chain 1.13 27.9±0.47µs 279.7 MElem/sec 1.00 24.7±0.07µs 315.9 MElem/sec in_list_rewrite/fixed_size_binary_1/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=2/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_1/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=2/chain 1.01 25.0±0.12µs 312.4 MElem/sec 1.00 24.7±0.09µs 315.7 MElem/sec in_list_rewrite/fixed_size_binary_1/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=2/in_list 1.00 2.2±0.01µs 3.5 GElem/sec 1.00 2.2±0.01µs 3.5 GElem/sec in_list_rewrite/fixed_size_binary_1/miss/batch=8192/nulls=0%/match=0%/in/list=2/chain 1.01 47.3±1.70µs 165.3 MElem/sec 1.00 46.6±1.00µs 167.7 MElem/sec in_list_rewrite/fixed_size_binary_1/miss/batch=8192/nulls=0%/match=0%/in/list=2/in_list 1.00 2.2±0.01µs 3.5 GElem/sec 1.01 2.2±0.01µs 3.4 GElem/sec in_list_rewrite/fixed_size_binary_1/miss/batch=8192/nulls=0%/match=0%/not_in/list=2/chain 1.02 47.4±3.27µs 164.8 MElem/sec 1.00 46.6±0.97µs 167.7 MElem/sec in_list_rewrite/fixed_size_binary_1/miss/batch=8192/nulls=0%/match=0%/not_in/list=2/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_1/single_row_hit/batch=1/nulls=0%/match=100%/in/list=2/chain 1.01 619.3±17.78ns 1577.0 KElem/sec 1.00 614.9±22.21ns 1588.2 KElem/sec in_list_rewrite/fixed_size_binary_1/single_row_hit/batch=1/nulls=0%/match=100%/in/list=2/in_list 1.00 279.9±2.13ns 3.4 MElem/sec 1.00 279.7±1.37ns 3.4 MElem/sec in_list_rewrite/fixed_size_binary_1/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=2/chain 1.02 628.0±17.93ns 1555.1 KElem/sec 1.00 615.9±23.09ns 1585.6 KElem/sec in_list_rewrite/fixed_size_binary_1/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=2/in_list 1.00 336.9±1.93ns 2.8 MElem/sec 1.01 338.8±3.23ns 2.8 MElem/sec in_list_rewrite/fixed_size_binary_1/single_row_miss/batch=1/nulls=0%/match=0%/in/list=2/chain 1.00 1215.4±37.11ns 803.5 KElem/sec 1.00 1216.7±265.74ns 802.7 KElem/sec in_list_rewrite/fixed_size_binary_1/single_row_miss/batch=1/nulls=0%/match=0%/in/list=2/in_list 1.00 280.0±2.18ns 3.4 MElem/sec 1.01 283.1±1.81ns 3.4 MElem/sec in_list_rewrite/fixed_size_binary_1/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=2/chain 1.00 1225.4±40.31ns 796.9 KElem/sec 1.01 1236.9±295.15ns 789.5 KElem/sec in_list_rewrite/fixed_size_binary_1/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=2/in_list 1.01 338.3±2.37ns 2.8 MElem/sec 1.00 333.7±2.13ns 2.9 MElem/sec in_list_rewrite/fixed_size_binary_1/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=2/chain 1.01 25.1±0.33µs 311.0 MElem/sec 1.00 24.9±0.36µs 314.3 MElem/sec in_list_rewrite/fixed_size_binary_1/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=2/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_1/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=2/chain 1.02 25.2±0.44µs 310.5 MElem/sec 1.00 24.7±0.29µs 316.0 MElem/sec in_list_rewrite/fixed_size_binary_1/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=2/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_16/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=2/chain 1.00 15.7±0.13µs 496.3 MElem/sec 1.00 15.7±0.16µs 497.0 MElem/sec in_list_rewrite/fixed_size_binary_16/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=2/in_list 1.00 7.4±0.02µs 1050.5 MElem/sec 1.00 7.4±0.02µs 1052.2 MElem/sec in_list_rewrite/fixed_size_binary_16/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=2/chain 1.00 15.7±0.12µs 496.3 MElem/sec 1.01 16.0±0.15µs 489.1 MElem/sec in_list_rewrite/fixed_size_binary_16/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=2/in_list 1.00 7.5±0.02µs 1040.8 MElem/sec 1.00 7.5±0.02µs 1041.1 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced/batch=8192/nulls=0%/match=50%/in/list=2/chain 1.00 31.9±0.26µs 244.9 MElem/sec 1.00 31.9±0.36µs 244.6 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced/batch=8192/nulls=0%/match=50%/in/list=2/in_list 1.00 7.4±0.02µs 1050.9 MElem/sec 1.00 7.4±0.02µs 1051.0 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced/batch=8192/nulls=0%/match=50%/not_in/list=2/chain 1.00 31.9±0.27µs 244.5 MElem/sec 1.00 32.0±0.30µs 244.3 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced/batch=8192/nulls=0%/match=50%/not_in/list=2/in_list 1.00 7.5±0.04µs 1040.0 MElem/sec 1.00 7.5±0.05µs 1039.2 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=2/chain 1.00 32.2±0.06µs 242.5 MElem/sec 1.00 32.2±0.14µs 242.7 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=2/in_list 1.00 7.6±0.03µs 1034.1 MElem/sec 1.00 7.6±0.02µs 1033.5 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=2/chain 1.00 32.2±0.17µs 242.8 MElem/sec 1.00 32.2±0.17µs 242.9 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=2/in_list 1.00 7.6±0.03µs 1024.1 MElem/sec 1.00 7.6±0.01µs 1023.9 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=2/chain 1.00 1847.5±65.37ns 33.0 MElem/sec 1.00 1846.6±64.85ns 33.1 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=2/in_list 1.02 322.6±3.74ns 189.2 MElem/sec 1.00 315.3±2.53ns 193.6 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=2/chain 1.00 1849.8±69.76ns 33.0 MElem/sec 1.01 1865.4±67.18ns 32.7 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=2/in_list 1.00 370.2±3.19ns 164.9 MElem/sec 1.01 373.1±1.93ns 163.6 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_unaligned/batch=8192/nulls=0%/match=50%/in/list=2/chain 1.00 32.9±0.66µs 237.5 MElem/sec 1.00 32.9±0.34µs 237.5 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_unaligned/batch=8192/nulls=0%/match=50%/in/list=2/in_list 1.00 9.4±0.03µs 834.8 MElem/sec 1.00 9.4±0.02µs 832.7 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_unaligned/batch=8192/nulls=0%/match=50%/not_in/list=2/chain 1.00 32.7±0.38µs 238.9 MElem/sec 1.00 32.7±0.28µs 239.0 MElem/sec in_list_rewrite/fixed_size_binary_16/balanced_unaligned/batch=8192/nulls=0%/match=50%/not_in/list=2/in_list 1.00 9.4±0.03µs 829.4 MElem/sec 1.00 9.4±0.04µs 829.0 MElem/sec in_list_rewrite/fixed_size_binary_16/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=2/chain 1.00 17.2±0.05µs 453.2 MElem/sec 1.00 17.2±0.11µs 453.6 MElem/sec in_list_rewrite/fixed_size_binary_16/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=2/in_list 1.00 4.4±0.03µs 1792.8 MElem/sec 1.00 4.4±0.01µs 1795.1 MElem/sec in_list_rewrite/fixed_size_binary_16/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=2/chain 1.00 17.2±0.10µs 453.8 MElem/sec 1.00 17.2±0.07µs 454.4 MElem/sec in_list_rewrite/fixed_size_binary_16/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=2/in_list 1.00 4.4±0.02µs 1765.5 MElem/sec 1.00 4.4±0.02µs 1764.7 MElem/sec in_list_rewrite/fixed_size_binary_16/miss/batch=8192/nulls=0%/match=0%/in/list=2/chain 1.02 31.9±0.50µs 245.2 MElem/sec 1.00 31.4±0.27µs 248.9 MElem/sec in_list_rewrite/fixed_size_binary_16/miss/batch=8192/nulls=0%/match=0%/in/list=2/in_list 1.00 7.4±0.02µs 1050.8 MElem/sec 1.00 7.4±0.02µs 1051.0 MElem/sec in_list_rewrite/fixed_size_binary_16/miss/batch=8192/nulls=0%/match=0%/not_in/list=2/chain 1.00 31.4±0.26µs 248.6 MElem/sec 1.00 31.4±0.26µs 248.8 MElem/sec in_list_rewrite/fixed_size_binary_16/miss/batch=8192/nulls=0%/match=0%/not_in/list=2/in_list 1.00 7.5±0.02µs 1040.6 MElem/sec 1.00 7.5±0.02µs 1040.5 MElem/sec in_list_rewrite/fixed_size_binary_16/single_row_hit/batch=1/nulls=0%/match=100%/in/list=2/chain 1.01 615.9±25.67ns 1585.7 KElem/sec 1.00 610.2±19.54ns 1600.4 KElem/sec in_list_rewrite/fixed_size_binary_16/single_row_hit/batch=1/nulls=0%/match=100%/in/list=2/in_list 1.00 271.6±2.29ns 3.5 MElem/sec 1.03 278.8±1.28ns 3.4 MElem/sec in_list_rewrite/fixed_size_binary_16/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=2/chain 1.01 616.6±23.54ns 1583.8 KElem/sec 1.00 608.7±19.53ns 1604.4 KElem/sec in_list_rewrite/fixed_size_binary_16/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=2/in_list 1.01 321.7±1.83ns 3.0 MElem/sec 1.00 318.8±2.71ns 3.0 MElem/sec in_list_rewrite/fixed_size_binary_16/single_row_miss/batch=1/nulls=0%/match=0%/in/list=2/chain 1.02 1213.2±58.58ns 805.0 KElem/sec 1.00 1194.2±47.87ns 817.8 KElem/sec in_list_rewrite/fixed_size_binary_16/single_row_miss/batch=1/nulls=0%/match=0%/in/list=2/in_list 1.00 273.1±2.17ns 3.5 MElem/sec 1.01 276.9±2.06ns 3.4 MElem/sec in_list_rewrite/fixed_size_binary_16/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=2/chain 1.03 1238.7±65.61ns 788.4 KElem/sec 1.00 1197.0±45.52ns 815.9 KElem/sec in_list_rewrite/fixed_size_binary_16/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=2/in_list 1.00 320.5±1.32ns 3.0 MElem/sec 1.00 319.5±2.37ns 3.0 MElem/sec in_list_rewrite/fixed_size_binary_16/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=2/chain 1.00 17.2±0.15µs 453.5 MElem/sec 1.00 17.2±0.05µs 453.7 MElem/sec in_list_rewrite/fixed_size_binary_16/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=2/in_list 1.00 7.4±0.03µs 1056.1 MElem/sec 1.01 7.4±0.02µs 1050.6 MElem/sec in_list_rewrite/fixed_size_binary_16/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=2/chain 1.02 17.6±0.12µs 444.0 MElem/sec 1.00 17.2±0.06µs 453.9 MElem/sec in_list_rewrite/fixed_size_binary_16/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=2/in_list 1.00 7.5±0.03µs 1044.0 MElem/sec 1.00 7.5±0.03µs 1040.6 MElem/sec in_list_rewrite/fixed_size_binary_2/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=2/chain 1.01 20.8±0.21µs 375.7 MElem/sec 1.00 20.5±0.14µs 380.4 MElem/sec in_list_rewrite/fixed_size_binary_2/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=2/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_2/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=2/chain 1.01 20.8±0.18µs 375.6 MElem/sec 1.00 20.6±0.18µs 380.1 MElem/sec in_list_rewrite/fixed_size_binary_2/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=2/in_list 1.00 2.2±0.01µs 3.5 GElem/sec 1.00 2.2±0.01µs 3.5 GElem/sec in_list_rewrite/fixed_size_binary_2/balanced/batch=8192/nulls=0%/match=50%/in/list=2/chain 1.01 61.0±0.79µs 128.1 MElem/sec 1.00 60.5±0.55µs 129.2 MElem/sec in_list_rewrite/fixed_size_binary_2/balanced/batch=8192/nulls=0%/match=50%/in/list=2/in_list 1.00 2.1±0.01µs 3.6 GElem/sec 1.00 2.1±0.00µs 3.6 GElem/sec in_list_rewrite/fixed_size_binary_2/balanced/batch=8192/nulls=0%/match=50%/not_in/list=2/chain 1.01 60.7±0.88µs 128.7 MElem/sec 1.00 60.2±0.71µs 129.7 MElem/sec in_list_rewrite/fixed_size_binary_2/balanced/batch=8192/nulls=0%/match=50%/not_in/list=2/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_2/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=2/chain 1.01 65.0±0.30µs 120.2 MElem/sec 1.00 64.6±0.36µs 120.9 MElem/sec in_list_rewrite/fixed_size_binary_2/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=2/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/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=2/chain 1.01 65.0±0.56µs 120.1 MElem/sec 1.00 64.6±0.30µs 120.9 MElem/sec in_list_rewrite/fixed_size_binary_2/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=2/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_2/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=2/chain 1.00 1966.6±56.05ns 31.0 MElem/sec 1.00 1964.4±63.57ns 31.1 MElem/sec in_list_rewrite/fixed_size_binary_2/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=2/in_list 1.01 296.5±1.50ns 205.9 MElem/sec 1.00 294.7±1.03ns 207.1 MElem/sec in_list_rewrite/fixed_size_binary_2/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=2/chain 1.00 1964.6±59.95ns 31.1 MElem/sec 1.00 1963.4±70.66ns 31.1 MElem/sec in_list_rewrite/fixed_size_binary_2/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=2/in_list 1.00 346.8±1.81ns 176.0 MElem/sec 1.03 356.0±5.31ns 171.5 MElem/sec in_list_rewrite/fixed_size_binary_2/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=2/chain 1.01 40.1±0.25µs 194.9 MElem/sec 1.00 39.6±0.31µs 197.4 MElem/sec in_list_rewrite/fixed_size_binary_2/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=2/in_list 1.00 1969.8±9.12ns 3.9 GElem/sec 1.00 1961.2±5.61ns 3.9 GElem/sec in_list_rewrite/fixed_size_binary_2/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=2/chain 1.02 40.0±0.26µs 195.3 MElem/sec 1.00 39.4±0.20µs 198.3 MElem/sec in_list_rewrite/fixed_size_binary_2/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=2/in_list 1.00 2.0±0.01µs 3.8 GElem/sec 1.00 2.0±0.01µs 3.8 GElem/sec in_list_rewrite/fixed_size_binary_2/miss/batch=8192/nulls=0%/match=0%/in/list=2/chain 1.01 41.6±0.37µs 187.9 MElem/sec 1.00 41.2±0.32µs 189.8 MElem/sec in_list_rewrite/fixed_size_binary_2/miss/batch=8192/nulls=0%/match=0%/in/list=2/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_2/miss/batch=8192/nulls=0%/match=0%/not_in/list=2/chain 1.07 44.1±1.78µs 177.0 MElem/sec 1.00 41.2±0.29µs 189.7 MElem/sec in_list_rewrite/fixed_size_binary_2/miss/batch=8192/nulls=0%/match=0%/not_in/list=2/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/fixed_size_binary_2/single_row_hit/batch=1/nulls=0%/match=100%/in/list=2/chain 1.01 617.7±19.80ns 1580.9 KElem/sec 1.00 611.0±20.77ns 1598.4 KElem/sec in_list_rewrite/fixed_size_binary_2/single_row_hit/batch=1/nulls=0%/match=100%/in/list=2/in_list 1.00 287.4±2.07ns 3.3 MElem/sec 1.00 287.2±1.34ns 3.3 MElem/sec in_list_rewrite/fixed_size_binary_2/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=2/chain 1.00 611.4±17.71ns 1597.3 KElem/sec 1.01 617.8±21.78ns 1580.7 KElem/sec in_list_rewrite/fixed_size_binary_2/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=2/in_list 1.00 340.9±2.13ns 2.8 MElem/sec 1.00 339.4±1.89ns 2.8 MElem/sec in_list_rewrite/fixed_size_binary_2/single_row_miss/batch=1/nulls=0%/match=0%/in/list=2/chain 1.00 1228.2±45.04ns 795.1 KElem/sec 1.00 1224.5±47.86ns 797.5 KElem/sec in_list_rewrite/fixed_size_binary_2/single_row_miss/batch=1/nulls=0%/match=0%/in/list=2/in_list 1.00 287.8±1.68ns 3.3 MElem/sec 1.00 287.5±5.57ns 3.3 MElem/sec in_list_rewrite/fixed_size_binary_2/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=2/chain 1.00 1181.5±39.14ns 826.6 KElem/sec 1.02 1206.8±46.18ns 809.2 KElem/sec in_list_rewrite/fixed_size_binary_2/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=2/in_list 1.01 342.8±2.14ns 2.8 MElem/sec 1.00 338.5±1.84ns 2.8 MElem/sec in_list_rewrite/fixed_size_binary_2/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=2/chain 1.01 22.7±0.33µs 343.9 MElem/sec 1.00 22.5±0.28µs 347.3 MElem/sec in_list_rewrite/fixed_size_binary_2/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=2/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_2/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=2/chain 1.01 22.6±0.31µs 345.2 MElem/sec 1.00 22.4±0.36µs 349.1 MElem/sec in_list_rewrite/fixed_size_binary_2/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=2/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/fixed_size_binary_4/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=2/chain 1.04 18.6±0.80µs 419.9 MElem/sec 1.00 17.9±0.14µs 436.1 MElem/sec in_list_rewrite/fixed_size_binary_4/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=2/in_list 1.01 2.1±0.01µs 3.7 GElem/sec 1.00 2.1±0.01µs 3.7 GElem/sec in_list_rewrite/fixed_size_binary_4/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=2/chain 1.04 18.6±0.37µs 419.9 MElem/sec 1.00 17.9±0.16µs 435.8 MElem/sec in_list_rewrite/fixed_size_binary_4/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=2/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/balanced/batch=8192/nulls=0%/match=50%/in/list=2/chain 1.00 36.6±0.39µs 213.6 MElem/sec 1.01 37.0±0.91µs 211.1 MElem/sec in_list_rewrite/fixed_size_binary_4/balanced/batch=8192/nulls=0%/match=50%/in/list=2/in_list 1.01 2.1±0.01µs 3.7 GElem/sec 1.00 2.1±0.00µs 3.7 GElem/sec in_list_rewrite/fixed_size_binary_4/balanced/batch=8192/nulls=0%/match=50%/not_in/list=2/chain 1.06 38.6±0.76µs 202.3 MElem/sec 1.00 36.4±0.50µs 214.8 MElem/sec in_list_rewrite/fixed_size_binary_4/balanced/batch=8192/nulls=0%/match=50%/not_in/list=2/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/fixed_size_binary_4/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=2/chain 1.00 36.8±0.14µs 212.3 MElem/sec 1.00 36.7±0.13µs 213.1 MElem/sec in_list_rewrite/fixed_size_binary_4/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=2/in_list 1.00 2.2±0.01µs 3.5 GElem/sec 1.00 2.2±0.01µs 3.5 GElem/sec in_list_rewrite/fixed_size_binary_4/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=2/chain 1.00 36.7±0.15µs 212.7 MElem/sec 1.00 36.7±0.21µs 213.1 MElem/sec in_list_rewrite/fixed_size_binary_4/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=2/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_4/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=2/chain 1.00 1877.2±54.11ns 32.5 MElem/sec 1.00 1872.6±62.89ns 32.6 MElem/sec in_list_rewrite/fixed_size_binary_4/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=2/in_list 1.01 302.7±1.64ns 201.6 MElem/sec 1.00 299.3±1.29ns 203.9 MElem/sec in_list_rewrite/fixed_size_binary_4/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=2/chain 1.00 1869.1±50.36ns 32.7 MElem/sec 1.02 1901.2±62.66ns 32.1 MElem/sec in_list_rewrite/fixed_size_binary_4/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=2/in_list 1.01 353.8±2.73ns 172.5 MElem/sec 1.00 351.0±3.42ns 173.9 MElem/sec in_list_rewrite/fixed_size_binary_4/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=2/chain 1.01 19.5±0.10µs 400.4 MElem/sec 1.00 19.4±0.04µs 403.0 MElem/sec in_list_rewrite/fixed_size_binary_4/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=2/in_list 1.01 1710.9±8.83ns 4.5 GElem/sec 1.00 1693.1±5.01ns 4.5 GElem/sec in_list_rewrite/fixed_size_binary_4/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=2/chain 1.07 20.8±0.10µs 375.9 MElem/sec 1.00 19.3±0.05µs 403.7 MElem/sec in_list_rewrite/fixed_size_binary_4/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=2/in_list 1.02 1787.7±8.40ns 4.3 GElem/sec 1.00 1750.6±5.15ns 4.4 GElem/sec in_list_rewrite/fixed_size_binary_4/miss/batch=8192/nulls=0%/match=0%/in/list=2/chain 1.01 36.0±0.31µs 217.3 MElem/sec 1.00 35.8±0.30µs 218.4 MElem/sec in_list_rewrite/fixed_size_binary_4/miss/batch=8192/nulls=0%/match=0%/in/list=2/in_list 1.00 2.1±0.01µs 3.7 GElem/sec 1.00 2.1±0.01µs 3.7 GElem/sec in_list_rewrite/fixed_size_binary_4/miss/batch=8192/nulls=0%/match=0%/not_in/list=2/chain 1.00 36.1±0.39µs 216.6 MElem/sec 1.01 36.5±0.85µs 213.8 MElem/sec in_list_rewrite/fixed_size_binary_4/miss/batch=8192/nulls=0%/match=0%/not_in/list=2/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/single_row_hit/batch=1/nulls=0%/match=100%/in/list=2/chain 1.00 618.5±22.75ns 1579.0 KElem/sec 1.00 617.5±21.85ns 1581.4 KElem/sec in_list_rewrite/fixed_size_binary_4/single_row_hit/batch=1/nulls=0%/match=100%/in/list=2/in_list 1.01 288.2±1.90ns 3.3 MElem/sec 1.00 284.1±2.29ns 3.4 MElem/sec in_list_rewrite/fixed_size_binary_4/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=2/chain 1.01 615.8±22.31ns 1585.9 KElem/sec 1.00 612.2±18.63ns 1595.2 KElem/sec in_list_rewrite/fixed_size_binary_4/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=2/in_list 1.01 339.5±2.02ns 2.8 MElem/sec 1.00 336.4±1.84ns 2.8 MElem/sec in_list_rewrite/fixed_size_binary_4/single_row_miss/batch=1/nulls=0%/match=0%/in/list=2/chain 1.00 1194.3±42.22ns 817.7 KElem/sec 1.01 1203.0±45.21ns 811.7 KElem/sec in_list_rewrite/fixed_size_binary_4/single_row_miss/batch=1/nulls=0%/match=0%/in/list=2/in_list 1.02 289.7±2.45ns 3.3 MElem/sec 1.00 283.6±2.35ns 3.4 MElem/sec in_list_rewrite/fixed_size_binary_4/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=2/chain 1.00 1191.1±41.05ns 819.9 KElem/sec 1.01 1207.0±45.57ns 809.1 KElem/sec in_list_rewrite/fixed_size_binary_4/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=2/in_list 1.01 339.0±2.23ns 2.8 MElem/sec 1.00 335.0±2.12ns 2.8 MElem/sec in_list_rewrite/fixed_size_binary_4/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=2/chain 1.01 19.7±0.30µs 396.9 MElem/sec 1.00 19.5±0.25µs 401.0 MElem/sec in_list_rewrite/fixed_size_binary_4/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=2/in_list 1.01 2.1±0.01µs 3.7 GElem/sec 1.00 2.1±0.01µs 3.7 GElem/sec in_list_rewrite/fixed_size_binary_4/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=2/chain 1.00 19.5±0.25µs 401.4 MElem/sec 1.00 19.4±0.25µs 402.8 MElem/sec in_list_rewrite/fixed_size_binary_4/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=2/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_8/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=2/chain 1.00 15.4±0.14µs 507.4 MElem/sec 1.00 15.3±0.12µs 509.1 MElem/sec in_list_rewrite/fixed_size_binary_8/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=2/in_list 1.00 2.2±0.01µs 3.5 GElem/sec 1.00 2.2±0.01µs 3.5 GElem/sec in_list_rewrite/fixed_size_binary_8/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=2/chain 1.00 15.4±0.13µs 506.7 MElem/sec 1.00 15.4±0.14µs 508.5 MElem/sec in_list_rewrite/fixed_size_binary_8/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=2/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_8/balanced/batch=8192/nulls=0%/match=50%/in/list=2/chain 1.01 31.5±0.28µs 248.0 MElem/sec 1.00 31.1±0.26µs 250.8 MElem/sec in_list_rewrite/fixed_size_binary_8/balanced/batch=8192/nulls=0%/match=50%/in/list=2/in_list 1.00 2.2±0.01µs 3.5 GElem/sec 1.00 2.2±0.01µs 3.5 GElem/sec in_list_rewrite/fixed_size_binary_8/balanced/batch=8192/nulls=0%/match=50%/not_in/list=2/chain 1.00 31.5±0.30µs 248.0 MElem/sec 1.08 34.0±0.33µs 230.1 MElem/sec in_list_rewrite/fixed_size_binary_8/balanced/batch=8192/nulls=0%/match=50%/not_in/list=2/in_list 1.00 2.3±0.02µs 3.3 GElem/sec 1.00 2.3±0.01µs 3.4 GElem/sec in_list_rewrite/fixed_size_binary_8/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=2/chain 1.01 31.6±0.19µs 247.1 MElem/sec 1.00 31.4±0.09µs 248.5 MElem/sec in_list_rewrite/fixed_size_binary_8/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=2/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/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=2/chain 1.02 32.0±0.48µs 244.1 MElem/sec 1.00 31.5±0.21µs 247.8 MElem/sec in_list_rewrite/fixed_size_binary_8/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=2/in_list 1.00 2.4±0.01µs 3.2 GElem/sec 1.00 2.4±0.01µs 3.2 GElem/sec in_list_rewrite/fixed_size_binary_8/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=2/chain 1.00 1840.1±66.71ns 33.2 MElem/sec 1.02 1880.5±406.55ns 32.5 MElem/sec in_list_rewrite/fixed_size_binary_8/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=2/in_list 1.01 295.7±3.62ns 206.4 MElem/sec 1.00 293.9±1.78ns 207.7 MElem/sec in_list_rewrite/fixed_size_binary_8/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=2/chain 1.00 1841.6±67.03ns 33.1 MElem/sec 1.02 1886.9±379.19ns 32.3 MElem/sec in_list_rewrite/fixed_size_binary_8/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=2/in_list 1.02 352.7±5.29ns 173.1 MElem/sec 1.00 346.3±4.14ns 176.2 MElem/sec in_list_rewrite/fixed_size_binary_8/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=2/chain 1.00 16.9±0.05µs 462.9 MElem/sec 1.00 16.8±0.09µs 464.8 MElem/sec in_list_rewrite/fixed_size_binary_8/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=2/in_list 1.00 1640.8±4.61ns 4.6 GElem/sec 1.00 1635.3±5.79ns 4.7 GElem/sec in_list_rewrite/fixed_size_binary_8/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=2/chain 1.00 16.8±0.08µs 464.7 MElem/sec 1.00 16.8±0.12µs 465.1 MElem/sec in_list_rewrite/fixed_size_binary_8/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=2/in_list 1.02 1719.8±5.43ns 4.4 GElem/sec 1.00 1691.2±6.45ns 4.5 GElem/sec in_list_rewrite/fixed_size_binary_8/miss/batch=8192/nulls=0%/match=0%/in/list=2/chain 1.01 31.0±0.29µs 252.1 MElem/sec 1.00 30.7±0.27µs 254.5 MElem/sec in_list_rewrite/fixed_size_binary_8/miss/batch=8192/nulls=0%/match=0%/in/list=2/in_list 1.01 2.2±0.01µs 3.4 GElem/sec 1.00 2.2±0.01µs 3.5 GElem/sec in_list_rewrite/fixed_size_binary_8/miss/batch=8192/nulls=0%/match=0%/not_in/list=2/chain 1.01 31.0±0.29µs 252.1 MElem/sec 1.00 30.7±0.28µs 254.9 MElem/sec in_list_rewrite/fixed_size_binary_8/miss/batch=8192/nulls=0%/match=0%/not_in/list=2/in_list 1.01 2.3±0.01µs 3.3 GElem/sec 1.00 2.3±0.01µs 3.4 GElem/sec in_list_rewrite/fixed_size_binary_8/single_row_hit/batch=1/nulls=0%/match=100%/in/list=2/chain 1.01 613.5±21.70ns 1591.8 KElem/sec 1.00 610.2±21.13ns 1600.5 KElem/sec in_list_rewrite/fixed_size_binary_8/single_row_hit/batch=1/nulls=0%/match=100%/in/list=2/in_list 1.01 284.9±1.97ns 3.3 MElem/sec 1.00 283.4±3.59ns 3.4 MElem/sec in_list_rewrite/fixed_size_binary_8/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=2/chain 1.00 613.8±20.31ns 1591.0 KElem/sec 1.00 615.0±20.85ns 1588.0 KElem/sec in_list_rewrite/fixed_size_binary_8/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=2/in_list 1.01 338.2±3.25ns 2.8 MElem/sec 1.00 336.4±1.66ns 2.8 MElem/sec in_list_rewrite/fixed_size_binary_8/single_row_miss/batch=1/nulls=0%/match=0%/in/list=2/chain 1.00 1198.3±50.61ns 814.9 KElem/sec 1.00 1196.3±43.48ns 816.3 KElem/sec in_list_rewrite/fixed_size_binary_8/single_row_miss/batch=1/nulls=0%/match=0%/in/list=2/in_list 1.00 285.2±1.95ns 3.3 MElem/sec 1.00 284.1±1.56ns 3.4 MElem/sec in_list_rewrite/fixed_size_binary_8/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=2/chain 1.00 1200.0±48.53ns 813.8 KElem/sec 1.00 1203.7±46.02ns 811.3 KElem/sec in_list_rewrite/fixed_size_binary_8/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=2/in_list 1.02 343.9±2.56ns 2.8 MElem/sec 1.00 338.0±2.64ns 2.8 MElem/sec in_list_rewrite/fixed_size_binary_8/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=2/chain 1.00 16.9±0.30µs 461.8 MElem/sec 1.00 16.9±0.18µs 463.0 MElem/sec in_list_rewrite/fixed_size_binary_8/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=2/in_list 1.00 2.2±0.01µs 3.5 GElem/sec 1.00 2.2±0.01µs 3.5 GElem/sec in_list_rewrite/fixed_size_binary_8/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=2/chain 1.00 16.8±0.27µs 464.6 MElem/sec 1.00 16.8±0.17µs 465.7 MElem/sec in_list_rewrite/fixed_size_binary_8/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=2/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/float32/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=2/chain 1.00 4.6±0.01µs 1685.2 MElem/sec 1.00 4.6±0.02µs 1684.8 MElem/sec in_list_rewrite/float32/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=2/in_list 1.00 1954.3±5.57ns 3.9 GElem/sec 1.01 1965.5±75.91ns 3.9 GElem/sec in_list_rewrite/float32/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=2/chain 1.11 5.1±0.22µs 1517.5 MElem/sec 1.00 4.6±0.03µs 1682.4 MElem/sec in_list_rewrite/float32/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=2/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/balanced/batch=8192/nulls=0%/match=50%/in/list=2/chain 1.00 9.9±0.28µs 789.8 MElem/sec 1.00 9.9±0.32µs 787.7 MElem/sec in_list_rewrite/float32/balanced/batch=8192/nulls=0%/match=50%/in/list=2/in_list 1.00 1954.1±6.02ns 3.9 GElem/sec 1.01 1967.4±6.39ns 3.9 GElem/sec in_list_rewrite/float32/balanced/batch=8192/nulls=0%/match=50%/not_in/list=2/chain 1.00 9.7±0.05µs 806.1 MElem/sec 1.00 9.7±0.05µs 808.2 MElem/sec in_list_rewrite/float32/balanced/batch=8192/nulls=0%/match=50%/not_in/list=2/in_list 1.00 2.0±0.01µs 3.8 GElem/sec 1.00 2.0±0.01µs 3.8 GElem/sec in_list_rewrite/float32/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=2/chain 1.00 10.1±0.05µs 772.7 MElem/sec 1.00 10.1±0.04µs 772.1 MElem/sec in_list_rewrite/float32/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=2/in_list 1.00 2.0±0.01µs 3.7 GElem/sec 1.00 2.0±0.01µs 3.7 GElem/sec in_list_rewrite/float32/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=2/chain 1.00 10.1±0.06µs 775.4 MElem/sec 1.02 10.3±0.29µs 762.0 MElem/sec in_list_rewrite/float32/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=2/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/float32/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=2/chain 1.01 1247.4±6.41ns 48.9 MElem/sec 1.00 1232.7±8.65ns 49.5 MElem/sec in_list_rewrite/float32/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=2/in_list 1.06 190.5±7.42ns 320.4 MElem/sec 1.00 179.4±5.53ns 340.1 MElem/sec in_list_rewrite/float32/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=2/chain 1.02 1260.8±8.22ns 48.4 MElem/sec 1.00 1239.6±12.38ns 49.2 MElem/sec in_list_rewrite/float32/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=2/in_list 1.00 222.0±2.63ns 274.9 MElem/sec 1.01 224.2±2.76ns 272.3 MElem/sec in_list_rewrite/float32/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=2/chain 1.00 9.0±0.04µs 863.9 MElem/sec 1.01 9.1±0.02µs 857.3 MElem/sec in_list_rewrite/float32/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=2/in_list 1.00 1586.3±7.74ns 4.8 GElem/sec 1.00 1579.4±8.50ns 4.8 GElem/sec in_list_rewrite/float32/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=2/chain 1.00 9.0±0.03µs 867.1 MElem/sec 1.01 9.1±0.04µs 862.8 MElem/sec in_list_rewrite/float32/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=2/in_list 1.01 1652.2±3.89ns 4.6 GElem/sec 1.00 1641.8±9.77ns 4.6 GElem/sec in_list_rewrite/float32/miss/batch=8192/nulls=0%/match=0%/in/list=2/chain 1.03 9.5±0.38µs 823.2 MElem/sec 1.00 9.2±0.03µs 846.9 MElem/sec in_list_rewrite/float32/miss/batch=8192/nulls=0%/match=0%/in/list=2/in_list 1.00 1956.3±9.46ns 3.9 GElem/sec 1.00 1957.4±6.05ns 3.9 GElem/sec in_list_rewrite/float32/miss/batch=8192/nulls=0%/match=0%/not_in/list=2/chain 1.00 9.2±0.04µs 846.2 MElem/sec 1.09 10.1±0.69µs 773.7 MElem/sec in_list_rewrite/float32/miss/batch=8192/nulls=0%/match=0%/not_in/list=2/in_list 1.00 2.0±0.00µs 3.8 GElem/sec 1.01 2.0±0.01µs 3.8 GElem/sec in_list_rewrite/float32/single_row_hit/batch=1/nulls=0%/match=100%/in/list=2/chain 1.01 421.5±3.19ns 2.3 MElem/sec 1.00 418.4±2.57ns 2.3 MElem/sec in_list_rewrite/float32/single_row_hit/batch=1/nulls=0%/match=100%/in/list=2/in_list 1.00 173.6±1.55ns 5.5 MElem/sec 1.02 177.8±4.53ns 5.4 MElem/sec in_list_rewrite/float32/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=2/chain 1.00 418.6±5.51ns 2.3 MElem/sec 1.00 419.0±2.47ns 2.3 MElem/sec in_list_rewrite/float32/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=2/in_list 1.00 214.9±2.38ns 4.4 MElem/sec 1.00 215.7±1.64ns 4.4 MElem/sec in_list_rewrite/float32/single_row_miss/batch=1/nulls=0%/match=0%/in/list=2/chain 1.01 794.0±4.91ns 1229.9 KElem/sec 1.00 783.8±7.64ns 1245.9 KElem/sec in_list_rewrite/float32/single_row_miss/batch=1/nulls=0%/match=0%/in/list=2/in_list 1.00 172.7±1.93ns 5.5 MElem/sec 1.01 173.6±2.20ns 5.5 MElem/sec in_list_rewrite/float32/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=2/chain 1.00 777.2±4.14ns 1256.5 KElem/sec 1.00 776.1±5.31ns 1258.3 KElem/sec in_list_rewrite/float32/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=2/in_list 1.02 224.2±6.55ns 4.3 MElem/sec 1.00 218.7±3.84ns 4.4 MElem/sec in_list_rewrite/float32/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=2/chain 1.00 5.7±0.04µs 1367.4 MElem/sec 1.00 5.7±0.03µs 1371.2 MElem/sec in_list_rewrite/float32/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=2/in_list 1.00 1957.8±22.78ns 3.9 GElem/sec 1.00 1958.2±4.59ns 3.9 GElem/sec in_list_rewrite/float32/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=2/chain 1.00 5.6±0.04µs 1396.0 MElem/sec 1.00 5.6±0.06µs 1391.2 MElem/sec in_list_rewrite/float32/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=2/in_list 1.00 2.0±0.00µs 3.8 GElem/sec 1.00 2.0±0.01µs 3.8 GElem/sec in_list_rewrite/float64/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=2/chain 1.00 4.6±0.03µs 1691.2 MElem/sec 1.01 4.6±0.03µs 1682.4 MElem/sec in_list_rewrite/float64/all_first_hit/batch=8192/nulls=0%/match=100%/in/list=2/in_list 1.00 2.1±0.01µs 3.7 GElem/sec 1.00 2.1±0.01µs 3.7 GElem/sec in_list_rewrite/float64/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=2/chain 1.00 4.6±0.04µs 1698.8 MElem/sec 1.00 4.6±0.03µs 1696.9 MElem/sec in_list_rewrite/float64/all_first_hit/batch=8192/nulls=0%/match=100%/not_in/list=2/in_list 1.00 2.2±0.01µs 3.5 GElem/sec 1.00 2.2±0.01µs 3.5 GElem/sec in_list_rewrite/float64/balanced/batch=8192/nulls=0%/match=50%/in/list=2/chain 1.00 9.7±0.05µs 808.9 MElem/sec 1.00 9.6±0.05µs 811.2 MElem/sec in_list_rewrite/float64/balanced/batch=8192/nulls=0%/match=50%/in/list=2/in_list 1.00 2.1±0.01µs 3.7 GElem/sec 1.00 2.1±0.01µs 3.7 GElem/sec in_list_rewrite/float64/balanced/batch=8192/nulls=0%/match=50%/not_in/list=2/chain 1.00 9.6±0.03µs 814.2 MElem/sec 1.02 9.8±0.15µs 800.0 MElem/sec in_list_rewrite/float64/balanced/batch=8192/nulls=0%/match=50%/not_in/list=2/in_list 1.01 2.2±0.01µs 3.5 GElem/sec 1.00 2.1±0.01µs 3.6 GElem/sec in_list_rewrite/float64/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=2/chain 1.00 10.0±0.05µs 780.8 MElem/sec 1.00 10.0±0.05µs 777.4 MElem/sec in_list_rewrite/float64/balanced_nullable/batch=8192/nulls=20%/match=50%/in/list=2/in_list 1.00 2.2±0.01µs 3.5 GElem/sec 1.00 2.2±0.01µs 3.5 GElem/sec in_list_rewrite/float64/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=2/chain 1.00 10.0±0.05µs 779.8 MElem/sec 1.00 10.0±0.09µs 778.4 MElem/sec in_list_rewrite/float64/balanced_nullable/batch=8192/nulls=20%/match=50%/not_in/list=2/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/float64/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=2/chain 1.00 1233.8±9.74ns 49.5 MElem/sec 1.00 1229.5±5.67ns 49.6 MElem/sec in_list_rewrite/float64/balanced_small_batch/batch=64/nulls=0%/match=50%/in/list=2/in_list 1.00 177.4±2.14ns 344.0 MElem/sec 1.01 179.4±5.02ns 340.2 MElem/sec in_list_rewrite/float64/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=2/chain 1.01 1249.2±7.99ns 48.9 MElem/sec 1.00 1239.0±8.51ns 49.3 MElem/sec in_list_rewrite/float64/balanced_small_batch/batch=64/nulls=0%/match=50%/not_in/list=2/in_list 1.00 222.2±2.04ns 274.7 MElem/sec 1.03 228.5±4.67ns 267.1 MElem/sec in_list_rewrite/float64/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=2/chain 1.00 9.1±0.06µs 855.8 MElem/sec 1.00 9.1±0.05µs 854.8 MElem/sec in_list_rewrite/float64/list_null_balanced/batch=8192/nulls=0%/match=50%/in/list=2/in_list 1.00 1514.0±7.69ns 5.0 GElem/sec 1.00 1519.8±8.42ns 5.0 GElem/sec in_list_rewrite/float64/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=2/chain 1.01 9.1±0.09µs 854.1 MElem/sec 1.00 9.1±0.04µs 861.4 MElem/sec in_list_rewrite/float64/list_null_balanced/batch=8192/nulls=0%/match=50%/not_in/list=2/in_list 1.00 1578.4±8.62ns 4.8 GElem/sec 1.00 1572.4±15.13ns 4.9 GElem/sec in_list_rewrite/float64/miss/batch=8192/nulls=0%/match=0%/in/list=2/chain 1.00 9.1±0.07µs 856.2 MElem/sec 1.00 9.2±0.04µs 853.0 MElem/sec in_list_rewrite/float64/miss/batch=8192/nulls=0%/match=0%/in/list=2/in_list 1.00 2.1±0.01µs 3.7 GElem/sec 1.00 2.1±0.01µs 3.7 GElem/sec in_list_rewrite/float64/miss/batch=8192/nulls=0%/match=0%/not_in/list=2/chain 1.00 9.2±0.07µs 852.8 MElem/sec 1.00 9.1±0.03µs 854.2 MElem/sec in_list_rewrite/float64/miss/batch=8192/nulls=0%/match=0%/not_in/list=2/in_list 1.00 2.2±0.02µs 3.5 GElem/sec 1.00 2.1±0.01µs 3.6 GElem/sec in_list_rewrite/float64/single_row_hit/batch=1/nulls=0%/match=100%/in/list=2/chain 1.00 420.2±2.31ns 2.3 MElem/sec 1.00 418.8±2.27ns 2.3 MElem/sec in_list_rewrite/float64/single_row_hit/batch=1/nulls=0%/match=100%/in/list=2/in_list 1.05 185.5±1.35ns 5.1 MElem/sec 1.00 176.5±5.38ns 5.4 MElem/sec in_list_rewrite/float64/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=2/chain 1.01 423.5±2.39ns 2.3 MElem/sec 1.00 418.1±4.77ns 2.3 MElem/sec in_list_rewrite/float64/single_row_hit/batch=1/nulls=0%/match=100%/not_in/list=2/in_list 1.00 214.1±2.35ns 4.5 MElem/sec 1.01 216.6±2.19ns 4.4 MElem/sec in_list_rewrite/float64/single_row_miss/batch=1/nulls=0%/match=0%/in/list=2/chain 1.00 770.2±5.15ns 1267.9 KElem/sec 1.00 771.6±6.90ns 1265.7 KElem/sec in_list_rewrite/float64/single_row_miss/batch=1/nulls=0%/match=0%/in/list=2/in_list 1.00 172.0±1.60ns 5.5 MElem/sec 1.00 172.5±2.23ns 5.5 MElem/sec in_list_rewrite/float64/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=2/chain 1.00 774.8±5.95ns 1260.4 KElem/sec 1.00 775.4±4.25ns 1259.4 KElem/sec in_list_rewrite/float64/single_row_miss/batch=1/nulls=0%/match=0%/not_in/list=2/in_list 1.00 211.7±2.45ns 4.5 MElem/sec 1.04 220.9±5.83ns 4.3 MElem/sec in_list_rewrite/float64/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=2/chain 1.01 5.7±0.16µs 1364.1 MElem/sec 1.00 5.7±0.03µs 1375.5 MElem/sec in_list_rewrite/float64/skewed_hit/batch=8192/nulls=0%/match=99%/in/list=2/in_list 1.00 2.1±0.02µs 3.7 GElem/sec 1.00 2.1±0.01µs 3.7 GElem/sec in_list_rewrite/float64/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=2/chain 1.00 5.6±0.06µs 1400.9 MElem/sec 1.01 5.6±0.06µs 1392.8 MElem/sec in_list_rewrite/float64/skewed_hit/batch=8192/nulls=0%/match=99%/not_in/list=2/in_list 1.01 2.2±0.01µs 3.5 GElem/sec 1.00 2.1±0.01µs 3.6 GElem/sec ``` </p> </details> <details><summary>Resource Usage</summary> **in_list_rewrite — base (merge-base)** | Metric | Value | |--------|-------| | Wall time | 390.1s | | Peak memory | 65.8 MiB | | Avg memory | 38.1 MiB | | CPU user | 898.4s | | CPU sys | 3.0s | | Peak spill | 0 B | **in_list_rewrite — branch** | Metric | Value | |--------|-------| | Wall time | 420.1s | | Peak memory | 65.2 MiB | | Avg memory | 35.5 MiB | | CPU user | 898.2s | | 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]
