rluvaton commented on PR #18152:
URL: https://github.com/apache/datafusion/pull/18152#issuecomment-3456607505
# Benchmark results:
<details>
<summary>Env</summary>
Neofetch:
```
ubuntu@ip-:~/datafusion/datafusion/physical-expr$ neofetch --off
ubuntu@ip-
-----------------------
OS: Ubuntu 24.04.3 LTS x86_64
Host: c5.metal 1.0
Kernel: 6.14.0-1011-aws
Uptime: 2 hours
Packages: 820 (dpkg), 4 (snap)
Shell: bash 5.2.21
Terminal: /dev/pts/0
CPU: Intel Xeon Platinum 8275CL (96) @ 3.900GHz
Memory: 1637MiB / 193026MiB
```
**cpufetch:**
```
ubuntu@ip-:~/datafusion/datafusion/physical-expr$ cpufetch
Name: Intel Xeon Platinum 8275CL
Microarchitecture: Cascade Lake
Technology: 14nm
Max Frequency: 3.900 GHz
Sockets: 2
Cores: 24 cores (48 threads)
Cores (Total): 48 cores (96 threads)
AVX: AVX,AVX2,AVX512
FMA: FMA3
L1i Size: 32KB (1.5MB Total)
L1d Size: 32KB (1.5MB Total)
L2 Size: 1MB (48MB Total)
L3 Size: 35.75MB (71.5MB Total)
Peak Performance: 11.98 TFLOP/s
```
</details>
Compare:
**`main`:**
- Branch: main
- Commit: https://github.com/apache/datafusion/commit/bea4b68fc
- Upstream: upstream/main
**`optimization`:**
- Branch: case_reduce_filtering
- Commit: https://github.com/pepijnve/datafusion/commit/7a4a24b51
- Upstream: origin/case_reduce_filtering
<details>
<summary>Results</summary>
```
$ cargo bench --bench case_when -- --load-baseline optimization --baseline
main
case_when 8192x3: CASE WHEN c1 <= 500 THEN 1 ELSE 0 END
time: [53.611 µs 53.695 µs 53.777 µs]
change: [+3.2855% +3.5627% +3.8167%] (p = 0.00 <
0.05)
Performance has regressed.
Found 1 outliers among 100 measurements (1.00%)
1 (1.00%) high severe
case_when 8192x3: CASE WHEN c1 <= 500 THEN c2 ELSE c3 END
time: [22.324 µs 22.361 µs 22.403 µs]
change: [+5.6317% +6.1119% +6.6143%] (p = 0.00 <
0.05)
Performance has regressed.
Found 2 outliers among 100 measurements (2.00%)
1 (1.00%) high mild
1 (1.00%) high severe
case_when 8192x3: CASE WHEN c1 <= 500 THEN c2 [ELSE NULL] END
time: [6.3978 µs 6.4011 µs 6.4048 µs]
change: [+1.1985% +1.4094% +1.6072%] (p = 0.00 <
0.05)
Performance has regressed.
Found 14 outliers among 100 measurements (14.00%)
6 (6.00%) high mild
8 (8.00%) high severe
case_when 8192x3: CASE c1 WHEN 1 THEN c2 WHEN 2 THEN c3 END
time: [27.901 µs 27.931 µs 27.963 µs]
change: [-6.3486% -6.0872% -5.7951%] (p = 0.00 <
0.05)
Performance has improved.
Found 3 outliers among 100 measurements (3.00%)
1 (1.00%) high mild
2 (2.00%) high severe
case_when 8192x3: CASE WHEN c1 == 0 THEN 0 WHEN c1 == 1 THEN 1 ... WHEN c1
== n THEN n ELSE n + 1 END
time: [65.275 ms 65.306 ms 65.340 ms]
change: [-72.797% -72.776% -72.756%] (p = 0.00 <
0.05)
Performance has improved.
Found 7 outliers among 100 measurements (7.00%)
6 (6.00%) high mild
1 (1.00%) high severe
case_when 8192x3: CASE WHEN c1 < 0 THEN 0 WHEN c1 < 1000 THEN 1 ... WHEN c1
< n * 1000 THEN n ELSE n + 1 END
time: [197.77 µs 198.13 µs 198.50 µs]
change: [-47.790% -47.693% -47.600%] (p = 0.00 <
0.05)
Performance has improved.
Found 4 outliers among 100 measurements (4.00%)
3 (3.00%) high mild
1 (1.00%) high severe
case_when 8192x3: CASE c1 WHEN 0 THEN 0 WHEN 1 THEN 1 ... WHEN n THEN n ELSE
n + 1 END
time: [69.361 ms 69.398 ms 69.437 ms]
change: [-68.445% -68.423% -68.400%] (p = 0.00 <
0.05)
Performance has improved.
Found 6 outliers among 100 measurements (6.00%)
4 (4.00%) high mild
2 (2.00%) high severe
case_when 8192x3: CASE c2 WHEN 0 THEN 0 WHEN 1000 THEN 1 ... WHEN n * 1000
THEN n ELSE n + 1 END
time: [182.58 µs 182.85 µs 183.10 µs]
change: [-47.380% -47.300% -47.221%] (p = 0.00 <
0.05)
Performance has improved.
Found 2 outliers among 100 measurements (2.00%)
1 (1.00%) high mild
1 (1.00%) high severe
case_when 8192x50: CASE WHEN c1 <= 500 THEN 1 ELSE 0 END
time: [53.946 µs 54.011 µs 54.080 µs]
change: [+4.2469% +4.4854% +4.7280%] (p = 0.00 <
0.05)
Performance has regressed.
Found 9 outliers among 100 measurements (9.00%)
1 (1.00%) low mild
6 (6.00%) high mild
2 (2.00%) high severe
case_when 8192x50: CASE WHEN c1 <= 500 THEN c2 ELSE c3 END
time: [191.48 µs 191.59 µs 191.70 µs]
change: [+1.2698% +1.4108% +1.5473%] (p = 0.00 <
0.05)
Performance has regressed.
Found 18 outliers among 100 measurements (18.00%)
1 (1.00%) low severe
3 (3.00%) low mild
4 (4.00%) high mild
10 (10.00%) high severe
case_when 8192x50: CASE WHEN c1 <= 500 THEN c2 [ELSE NULL] END
time: [6.2858 µs 6.2887 µs 6.2919 µs]
change: [-4.3230% -4.1166% -3.9167%] (p = 0.00 <
0.05)
Performance has improved.
Found 14 outliers among 100 measurements (14.00%)
8 (8.00%) high mild
6 (6.00%) high severe
case_when 8192x50: CASE c1 WHEN 1 THEN c2 WHEN 2 THEN c3 END
time: [195.80 µs 196.00 µs 196.21 µs]
change: [-2.9970% -2.8401% -2.6754%] (p = 0.00 <
0.05)
Performance has improved.
Found 9 outliers among 100 measurements (9.00%)
1 (1.00%) low severe
1 (1.00%) low mild
3 (3.00%) high mild
4 (4.00%) high severe
case_when 8192x50: CASE WHEN c1 == 0 THEN 0 WHEN c1 == 1 THEN 1 ... WHEN c1
== n THEN n ELSE n + 1 END
time: [713.30 ms 713.69 ms 714.09 ms]
change: [-50.040% -50.007% -49.977%] (p = 0.00 <
0.05)
Performance has improved.
Found 2 outliers among 100 measurements (2.00%)
2 (2.00%) high mild
case_when 8192x50: CASE WHEN c1 < 0 THEN 0 WHEN c1 < 1000 THEN 1 ... WHEN c1
< n * 1000 THEN n ELSE n + 1 END
time: [1.3047 ms 1.3053 ms 1.3060 ms]
change: [-27.957% -27.896% -27.829%] (p = 0.00 <
0.05)
Performance has improved.
Found 6 outliers among 100 measurements (6.00%)
3 (3.00%) high mild
3 (3.00%) high severe
case_when 8192x50: CASE c1 WHEN 0 THEN 0 WHEN 1 THEN 1 ... WHEN n THEN n
ELSE n + 1 END
time: [734.99 ms 735.27 ms 735.57 ms]
change: [-47.345% -47.319% -47.294%] (p = 0.00 <
0.05)
Performance has improved.
Found 2 outliers among 100 measurements (2.00%)
2 (2.00%) high mild
case_when 8192x50: CASE c2 WHEN 0 THEN 0 WHEN 1000 THEN 1 ... WHEN n * 1000
THEN n ELSE n + 1 END
time: [1.3060 ms 1.3066 ms 1.3073 ms]
change: [-26.799% -26.738% -26.674%] (p = 0.00 <
0.05)
Performance has improved.
Found 10 outliers among 100 measurements (10.00%)
3 (3.00%) low mild
3 (3.00%) high mild
4 (4.00%) high severe
case_when 8192x100: CASE WHEN c1 <= 500 THEN 1 ELSE 0 END
time: [54.655 µs 54.745 µs 54.844 µs]
change: [+4.2756% +4.5483% +4.8346%] (p = 0.00 <
0.05)
Performance has regressed.
Found 3 outliers among 100 measurements (3.00%)
2 (2.00%) high mild
1 (1.00%) high severe
case_when 8192x100: CASE WHEN c1 <= 500 THEN c2 ELSE c3 END
time: [375.32 µs 375.49 µs 375.67 µs]
change: [+0.8718% +0.9941% +1.1125%] (p = 0.00 <
0.05)
Change within noise threshold.
Found 12 outliers among 100 measurements (12.00%)
1 (1.00%) low mild
4 (4.00%) high mild
7 (7.00%) high severe
case_when 8192x100: CASE WHEN c1 <= 500 THEN c2 [ELSE NULL] END
time: [6.5703 µs 6.5732 µs 6.5766 µs]
change: [+0.8111% +1.0421% +1.2975%] (p = 0.00 <
0.05)
Change within noise threshold.
Found 5 outliers among 100 measurements (5.00%)
2 (2.00%) high mild
3 (3.00%) high severe
case_when 8192x100: CASE c1 WHEN 1 THEN c2 WHEN 2 THEN c3 END
time: [377.61 µs 377.72 µs 377.85 µs]
change: [-1.7167% -1.5865% -1.4691%] (p = 0.00 <
0.05)
Performance has improved.
Found 15 outliers among 100 measurements (15.00%)
6 (6.00%) high mild
9 (9.00%) high severe
case_when 8192x100: CASE WHEN c1 == 0 THEN 0 WHEN c1 == 1 THEN 1 ... WHEN c1
== n THEN n ELSE n + 1 END
time: [1.5675 s 1.5681 s 1.5687 s]
change: [-40.673% -40.646% -40.618%] (p = 0.00 <
0.05)
Performance has improved.
Found 5 outliers among 100 measurements (5.00%)
4 (4.00%) low mild
1 (1.00%) high mild
case_when 8192x100: CASE WHEN c1 < 0 THEN 0 WHEN c1 < 1000 THEN 1 ... WHEN
c1 < n * 1000 THEN n ELSE n + 1 END
time: [2.4750 ms 2.4770 ms 2.4799 ms]
change: [-25.593% -25.514% -25.419%] (p = 0.00 <
0.05)
Performance has improved.
Found 12 outliers among 100 measurements (12.00%)
5 (5.00%) high mild
7 (7.00%) high severe
case_when 8192x100: CASE c1 WHEN 0 THEN 0 WHEN 1 THEN 1 ... WHEN n THEN n
ELSE n + 1 END
time: [1.5862 s 1.5866 s 1.5870 s]
change: [-39.594% -39.575% -39.555%] (p = 0.00 <
0.05)
Performance has improved.
Found 3 outliers among 100 measurements (3.00%)
3 (3.00%) high mild
case_when 8192x100: CASE c2 WHEN 0 THEN 0 WHEN 1000 THEN 1 ... WHEN n * 1000
THEN n ELSE n + 1 END
time: [2.4907 ms 2.4917 ms 2.4928 ms]
change: [-24.824% -24.783% -24.738%] (p = 0.00 <
0.05)
Performance has improved.
Found 13 outliers among 100 measurements (13.00%)
2 (2.00%) high mild
11 (11.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0
time: [320.04 µs 320.21 µs 320.40 µs]
change: [-45.423% -45.330% -45.242%] (p = 0.00 <
0.05)
Performance has improved.
Found 5 outliers among 100 measurements (5.00%)
1 (1.00%) low mild
1 (1.00%) high mild
3 (3.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0
time: [537.79 µs 538.01 µs 538.25 µs]
change: [-33.598% -33.556% -33.509%] (p = 0.00 <
0.05)
Performance has improved.
Found 12 outliers among 100 measurements (12.00%)
6 (6.00%) high mild
6 (6.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0
time: [184.73 µs 184.79 µs 184.85 µs]
change: [-46.289% -46.177% -46.064%] (p = 0.00 <
0.05)
Performance has improved.
Found 10 outliers among 100 measurements (10.00%)
4 (4.00%) high mild
6 (6.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0
time: [220.32 µs 220.41 µs 220.51 µs]
change: [-50.624% -50.545% -50.454%] (p = 0.00 <
0.05)
Performance has improved.
Found 17 outliers among 100 measurements (17.00%)
2 (2.00%) low mild
9 (9.00%) high mild
6 (6.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0
time: [447.02 µs 447.26 µs 447.53 µs]
change: [-44.879% -44.812% -44.721%] (p = 0.00 <
0.05)
Performance has improved.
Found 5 outliers among 100 measurements (5.00%)
3 (3.00%) high mild
2 (2.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0
time: [834.96 µs 835.28 µs 835.62 µs]
change: [-40.626% -40.542% -40.457%] (p = 0.00 <
0.05)
Performance has improved.
Found 5 outliers among 100 measurements (5.00%)
2 (2.00%) high mild
3 (3.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0
time: [184.39 µs 184.47 µs 184.56 µs]
change: [-46.405% -46.309% -46.209%] (p = 0.00 <
0.05)
Performance has improved.
Found 12 outliers among 100 measurements (12.00%)
6 (6.00%) high mild
6 (6.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0
time: [220.15 µs 220.26 µs 220.37 µs]
change: [-50.754% -50.696% -50.599%] (p = 0.00 <
0.05)
Performance has improved.
Found 8 outliers among 100 measurements (8.00%)
4 (4.00%) high mild
4 (4.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0
time: [603.80 µs 604.12 µs 604.46 µs]
change: [-49.568% -49.475% -49.382%] (p = 0.00 <
0.05)
Performance has improved.
Found 4 outliers among 100 measurements (4.00%)
2 (2.00%) high mild
2 (2.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0
time: [1.1896 ms 1.1902 ms 1.1908 ms]
change: [-50.507% -50.457% -50.399%] (p = 0.00 <
0.05)
Performance has improved.
Found 7 outliers among 100 measurements (7.00%)
4 (4.00%) high mild
3 (3.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0
time: [184.41 µs 184.51 µs 184.63 µs]
change: [-46.395% -46.288% -46.180%] (p = 0.00 <
0.05)
Performance has improved.
Found 17 outliers among 100 measurements (17.00%)
1 (1.00%) low mild
2 (2.00%) high mild
14 (14.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0
time: [220.30 µs 220.38 µs 220.48 µs]
change: [-50.821% -50.738% -50.657%] (p = 0.00 <
0.05)
Performance has improved.
Found 14 outliers among 100 measurements (14.00%)
6 (6.00%) high mild
8 (8.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1
time: [378.11 µs 378.38 µs 378.69 µs]
change: [-49.039% -48.933% -48.829%] (p = 0.00 <
0.05)
Performance has improved.
Found 3 outliers among 100 measurements (3.00%)
2 (2.00%) high mild
1 (1.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1
time: [612.46 µs 612.69 µs 612.94 µs]
change: [-37.391% -37.306% -37.215%] (p = 0.00 <
0.05)
Performance has improved.
Found 9 outliers among 100 measurements (9.00%)
5 (5.00%) high mild
4 (4.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1
time: [261.74 µs 261.94 µs 262.14 µs]
change: [-46.855% -46.783% -46.700%] (p = 0.00 <
0.05)
Performance has improved.
Found 4 outliers among 100 measurements (4.00%)
3 (3.00%) high mild
1 (1.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1
time: [325.58 µs 325.75 µs 325.93 µs]
change: [-43.071% -42.962% -42.855%] (p = 0.00 <
0.05)
Performance has improved.
Found 4 outliers among 100 measurements (4.00%)
2 (2.00%) high mild
2 (2.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1
time: [499.83 µs 500.08 µs 500.34 µs]
change: [-52.121% -52.023% -51.939%] (p = 0.00 <
0.05)
Performance has improved.
Found 9 outliers among 100 measurements (9.00%)
2 (2.00%) low mild
4 (4.00%) high mild
3 (3.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1
time: [884.19 µs 884.60 µs 885.07 µs]
change: [-45.898% -45.830% -45.764%] (p = 0.00 <
0.05)
Performance has improved.
Found 7 outliers among 100 measurements (7.00%)
4 (4.00%) high mild
3 (3.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1
time: [261.80 µs 261.91 µs 262.04 µs]
change: [-46.855% -46.766% -46.651%] (p = 0.00 <
0.05)
Performance has improved.
Found 11 outliers among 100 measurements (11.00%)
6 (6.00%) high mild
5 (5.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1
time: [326.22 µs 326.37 µs 326.54 µs]
change: [-43.056% -42.946% -42.845%] (p = 0.00 <
0.05)
Performance has improved.
Found 9 outliers among 100 measurements (9.00%)
5 (5.00%) high mild
4 (4.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1
time: [646.08 µs 646.36 µs 646.66 µs]
change: [-58.699% -58.631% -58.545%] (p = 0.00 <
0.05)
Performance has improved.
Found 8 outliers among 100 measurements (8.00%)
1 (1.00%) low mild
5 (5.00%) high mild
2 (2.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1
time: [1.1819 ms 1.1823 ms 1.1828 ms]
change: [-57.450% -57.412% -57.352%] (p = 0.00 <
0.05)
Performance has improved.
Found 6 outliers among 100 measurements (6.00%)
5 (5.00%) high mild
1 (1.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1
time: [262.13 µs 262.29 µs 262.49 µs]
change: [-46.866% -46.768% -46.668%] (p = 0.00 <
0.05)
Performance has improved.
Found 9 outliers among 100 measurements (9.00%)
2 (2.00%) high mild
7 (7.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1
time: [325.61 µs 325.77 µs 325.99 µs]
change: [-43.180% -43.061% -42.947%] (p = 0.00 <
0.05)
Performance has improved.
Found 8 outliers among 100 measurements (8.00%)
2 (2.00%) high mild
6 (6.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5
time: [310.68 µs 310.83 µs 311.00 µs]
change: [-50.227% -50.135% -50.035%] (p = 0.00 <
0.05)
Performance has improved.
Found 6 outliers among 100 measurements (6.00%)
4 (4.00%) high mild
2 (2.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5
time: [482.26 µs 482.43 µs 482.62 µs]
change: [-40.847% -40.758% -40.669%] (p = 0.00 <
0.05)
Performance has improved.
Found 7 outliers among 100 measurements (7.00%)
5 (5.00%) high mild
2 (2.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5
time: [250.93 µs 251.05 µs 251.17 µs]
change: [-45.001% -44.890% -44.743%] (p = 0.00 <
0.05)
Performance has improved.
Found 9 outliers among 100 measurements (9.00%)
4 (4.00%) high mild
5 (5.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5
time: [311.69 µs 311.83 µs 311.98 µs]
change: [-40.073% -39.921% -39.796%] (p = 0.00 <
0.05)
Performance has improved.
Found 12 outliers among 100 measurements (12.00%)
6 (6.00%) high mild
6 (6.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5
time: [387.30 µs 387.64 µs 387.98 µs]
change: [-54.331% -54.245% -54.142%] (p = 0.00 <
0.05)
Performance has improved.
Found 3 outliers among 100 measurements (3.00%)
1 (1.00%) high mild
2 (2.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5
time: [629.41 µs 629.72 µs 630.07 µs]
change: [-52.353% -52.259% -52.171%] (p = 0.00 <
0.05)
Performance has improved.
Found 8 outliers among 100 measurements (8.00%)
5 (5.00%) high mild
3 (3.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5
time: [250.41 µs 250.50 µs 250.60 µs]
change: [-45.202% -45.107% -44.993%] (p = 0.00 <
0.05)
Performance has improved.
Found 12 outliers among 100 measurements (12.00%)
1 (1.00%) low mild
6 (6.00%) high mild
5 (5.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5
time: [311.48 µs 311.60 µs 311.74 µs]
change: [-40.037% -39.932% -39.841%] (p = 0.00 <
0.05)
Performance has improved.
Found 11 outliers among 100 measurements (11.00%)
4 (4.00%) high mild
7 (7.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5
time: [484.81 µs 485.07 µs 485.35 µs]
change: [-61.369% -61.303% -61.235%] (p = 0.00 <
0.05)
Performance has improved.
Found 7 outliers among 100 measurements (7.00%)
1 (1.00%) low mild
3 (3.00%) high mild
3 (3.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5
time: [825.12 µs 825.48 µs 825.87 µs]
change: [-62.526% -62.494% -62.450%] (p = 0.00 <
0.05)
Performance has improved.
Found 3 outliers among 100 measurements (3.00%)
2 (2.00%) high mild
1 (1.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5
time: [249.95 µs 250.05 µs 250.16 µs]
change: [-45.170% -45.076% -44.972%] (p = 0.00 <
0.05)
Performance has improved.
Found 10 outliers among 100 measurements (10.00%)
1 (1.00%) low mild
5 (5.00%) high mild
4 (4.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5
time: [311.61 µs 311.72 µs 311.85 µs]
change: [-39.994% -39.856% -39.708%] (p = 0.00 <
0.05)
Performance has improved.
Found 8 outliers among 100 measurements (8.00%)
4 (4.00%) high mild
4 (4.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0
time: [317.88 µs 318.05 µs 318.24 µs]
change: [-45.762% -45.642% -45.516%] (p = 0.00 <
0.05)
Performance has improved.
Found 8 outliers among 100 measurements (8.00%)
2 (2.00%) high mild
6 (6.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0
time: [534.66 µs 534.87 µs 535.10 µs]
change: [-34.145% -34.046% -33.921%] (p = 0.00 <
0.05)
Performance has improved.
Found 13 outliers among 100 measurements (13.00%)
6 (6.00%) high mild
7 (7.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0
time: [184.25 µs 184.34 µs 184.47 µs]
change: [-46.503% -46.406% -46.311%] (p = 0.00 <
0.05)
Performance has improved.
Found 11 outliers among 100 measurements (11.00%)
5 (5.00%) high mild
6 (6.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0
time: [220.59 µs 220.71 µs 220.86 µs]
change: [-50.679% -50.542% -50.429%] (p = 0.00 <
0.05)
Performance has improved.
Found 8 outliers among 100 measurements (8.00%)
5 (5.00%) high mild
3 (3.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0
time: [447.80 µs 448.11 µs 448.44 µs]
change: [-44.948% -44.860% -44.761%] (p = 0.00 <
0.05)
Performance has improved.
Found 6 outliers among 100 measurements (6.00%)
1 (1.00%) low mild
3 (3.00%) high mild
2 (2.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0
time: [834.24 µs 834.66 µs 835.13 µs]
change: [-40.649% -40.568% -40.493%] (p = 0.00 <
0.05)
Performance has improved.
Found 9 outliers among 100 measurements (9.00%)
4 (4.00%) high mild
5 (5.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0
time: [184.60 µs 184.68 µs 184.76 µs]
change: [-46.387% -46.276% -46.164%] (p = 0.00 <
0.05)
Performance has improved.
Found 14 outliers among 100 measurements (14.00%)
1 (1.00%) low mild
4 (4.00%) high mild
9 (9.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0
time: [220.34 µs 220.44 µs 220.55 µs]
change: [-50.591% -50.513% -50.428%] (p = 0.00 <
0.05)
Performance has improved.
Found 6 outliers among 100 measurements (6.00%)
3 (3.00%) high mild
3 (3.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0
time: [601.98 µs 602.35 µs 602.81 µs]
change: [-49.679% -49.590% -49.517%] (p = 0.00 <
0.05)
Performance has improved.
Found 10 outliers among 100 measurements (10.00%)
3 (3.00%) high mild
7 (7.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0
time: [1.1897 ms 1.1903 ms 1.1910 ms]
change: [-50.241% -50.197% -50.155%] (p = 0.00 <
0.05)
Performance has improved.
Found 10 outliers among 100 measurements (10.00%)
5 (5.00%) high mild
5 (5.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0
time: [184.35 µs 184.44 µs 184.55 µs]
change: [-46.474% -46.351% -46.228%] (p = 0.00 <
0.05)
Performance has improved.
Found 14 outliers among 100 measurements (14.00%)
6 (6.00%) high mild
8 (8.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0
time: [220.35 µs 220.44 µs 220.53 µs]
change: [-50.673% -50.605% -50.554%] (p = 0.00 <
0.05)
Performance has improved.
Found 10 outliers among 100 measurements (10.00%)
6 (6.00%) high mild
4 (4.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1
time: [379.38 µs 379.64 µs 379.91 µs]
change: [-48.908% -48.828% -48.761%] (p = 0.00 <
0.05)
Performance has improved.
Found 9 outliers among 100 measurements (9.00%)
6 (6.00%) high mild
3 (3.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1
time: [611.33 µs 611.57 µs 611.83 µs]
change: [-37.400% -37.339% -37.291%] (p = 0.00 <
0.05)
Performance has improved.
Found 7 outliers among 100 measurements (7.00%)
5 (5.00%) high mild
2 (2.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1
time: [262.05 µs 262.16 µs 262.29 µs]
change: [-46.919% -46.846% -46.779%] (p = 0.00 <
0.05)
Performance has improved.
Found 9 outliers among 100 measurements (9.00%)
5 (5.00%) high mild
4 (4.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1
time: [325.99 µs 326.17 µs 326.38 µs]
change: [-43.095% -42.996% -42.920%] (p = 0.00 <
0.05)
Performance has improved.
Found 8 outliers among 100 measurements (8.00%)
3 (3.00%) high mild
5 (5.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1
time: [499.05 µs 499.31 µs 499.58 µs]
change: [-52.229% -52.182% -52.137%] (p = 0.00 <
0.05)
Performance has improved.
Found 5 outliers among 100 measurements (5.00%)
4 (4.00%) high mild
1 (1.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1
time: [884.59 µs 884.93 µs 885.29 µs]
change: [-46.024% -45.966% -45.922%] (p = 0.00 <
0.05)
Performance has improved.
Found 8 outliers among 100 measurements (8.00%)
6 (6.00%) high mild
2 (2.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1
time: [261.96 µs 262.08 µs 262.22 µs]
change: [-46.906% -46.832% -46.773%] (p = 0.00 <
0.05)
Performance has improved.
Found 7 outliers among 100 measurements (7.00%)
3 (3.00%) high mild
4 (4.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1
time: [325.68 µs 325.82 µs 325.99 µs]
change: [-43.175% -43.075% -42.990%] (p = 0.00 <
0.05)
Performance has improved.
Found 10 outliers among 100 measurements (10.00%)
3 (3.00%) high mild
7 (7.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1
time: [648.99 µs 649.67 µs 650.48 µs]
change: [-58.611% -58.547% -58.485%] (p = 0.00 <
0.05)
Performance has improved.
Found 5 outliers among 100 measurements (5.00%)
3 (3.00%) high mild
2 (2.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1
time: [1.1823 ms 1.1827 ms 1.1832 ms]
change: [-57.509% -57.479% -57.449%] (p = 0.00 <
0.05)
Performance has improved.
Found 12 outliers among 100 measurements (12.00%)
8 (8.00%) high mild
4 (4.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1
time: [261.83 µs 261.95 µs 262.10 µs]
change: [-46.956% -46.915% -46.875%] (p = 0.00 <
0.05)
Performance has improved.
Found 9 outliers among 100 measurements (9.00%)
2 (2.00%) high mild
7 (7.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1
time: [325.76 µs 325.88 µs 326.01 µs]
change: [-43.047% -43.001% -42.960%] (p = 0.00 <
0.05)
Performance has improved.
Found 9 outliers among 100 measurements (9.00%)
2 (2.00%) high mild
7 (7.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5
time: [311.34 µs 311.47 µs 311.60 µs]
change: [-50.255% -50.173% -50.110%] (p = 0.00 <
0.05)
Performance has improved.
Found 8 outliers among 100 measurements (8.00%)
5 (5.00%) high mild
3 (3.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5
time: [482.09 µs 482.30 µs 482.55 µs]
change: [-40.862% -40.790% -40.734%] (p = 0.00 <
0.05)
Performance has improved.
Found 8 outliers among 100 measurements (8.00%)
4 (4.00%) high mild
4 (4.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5
time: [249.66 µs 249.76 µs 249.88 µs]
change: [-45.318% -45.242% -45.183%] (p = 0.00 <
0.05)
Performance has improved.
Found 8 outliers among 100 measurements (8.00%)
5 (5.00%) high mild
3 (3.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5
time: [312.05 µs 312.16 µs 312.29 µs]
change: [-40.111% -39.946% -39.815%] (p = 0.00 <
0.05)
Performance has improved.
Found 11 outliers among 100 measurements (11.00%)
4 (4.00%) high mild
7 (7.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5
time: [385.89 µs 386.22 µs 386.56 µs]
change: [-54.581% -54.495% -54.421%] (p = 0.00 <
0.05)
Performance has improved.
Found 9 outliers among 100 measurements (9.00%)
8 (8.00%) high mild
1 (1.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5
time: [629.63 µs 629.89 µs 630.18 µs]
change: [-52.291% -52.215% -52.158%] (p = 0.00 <
0.05)
Performance has improved.
Found 9 outliers among 100 measurements (9.00%)
6 (6.00%) high mild
3 (3.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5
time: [250.53 µs 250.63 µs 250.73 µs]
change: [-45.208% -45.120% -45.061%] (p = 0.00 <
0.05)
Performance has improved.
Found 6 outliers among 100 measurements (6.00%)
4 (4.00%) high mild
2 (2.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5
time: [311.73 µs 312.14 µs 312.84 µs]
change: [-40.001% -39.846% -39.664%] (p = 0.00 <
0.05)
Performance has improved.
Found 14 outliers among 100 measurements (14.00%)
4 (4.00%) high mild
10 (10.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5
time: [485.48 µs 485.79 µs 486.15 µs]
change: [-61.400% -61.369% -61.338%] (p = 0.00 <
0.05)
Performance has improved.
Found 4 outliers among 100 measurements (4.00%)
1 (1.00%) high mild
3 (3.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5
time: [821.14 µs 821.43 µs 821.75 µs]
change: [-62.793% -62.772% -62.751%] (p = 0.00 <
0.05)
Performance has improved.
Found 8 outliers among 100 measurements (8.00%)
3 (3.00%) high mild
5 (5.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5
time: [250.50 µs 250.60 µs 250.71 µs]
change: [-45.067% -45.031% -44.991%] (p = 0.00 <
0.05)
Performance has improved.
Found 12 outliers among 100 measurements (12.00%)
7 (7.00%) high mild
5 (5.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5
time: [311.67 µs 311.78 µs 311.91 µs]
change: [-40.104% -40.004% -39.933%] (p = 0.00 <
0.05)
Performance has improved.
Found 10 outliers among 100 measurements (10.00%)
3 (3.00%) high mild
7 (7.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0
time: [317.22 µs 317.35 µs 317.49 µs]
change: [-45.953% -45.850% -45.776%] (p = 0.00 <
0.05)
Performance has improved.
Found 7 outliers among 100 measurements (7.00%)
6 (6.00%) high mild
1 (1.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0
time: [535.44 µs 535.71 µs 536.02 µs]
change: [-34.093% -34.009% -33.943%] (p = 0.00 <
0.05)
Performance has improved.
Found 14 outliers among 100 measurements (14.00%)
9 (9.00%) high mild
5 (5.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.9, nulls: 0
time: [184.53 µs 184.61 µs 184.70 µs]
change: [-46.348% -46.203% -46.018%] (p = 0.00 <
0.05)
Performance has improved.
Found 15 outliers among 100 measurements (15.00%)
1 (1.00%) low mild
4 (4.00%) high mild
10 (10.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.9, nulls: 0
time: [220.76 µs 220.85 µs 220.96 µs]
change: [-50.533% -50.507% -50.479%] (p = 0.00 <
0.05)
Performance has improved.
Found 12 outliers among 100 measurements (12.00%)
6 (6.00%) high mild
6 (6.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0
time: [448.90 µs 449.25 µs 449.63 µs]
change: [-44.921% -44.846% -44.786%] (p = 0.00 <
0.05)
Performance has improved.
Found 5 outliers among 100 measurements (5.00%)
5 (5.00%) high mild
lookup_table_case_when/case when utf8 -> i32, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0
time: [834.84 µs 835.13 µs 835.48 µs]
change: [-40.804% -40.722% -40.666%] (p = 0.00 <
0.05)
Performance has improved.
Found 9 outliers among 100 measurements (9.00%)
3 (3.00%) high mild
6 (6.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.9, nulls: 0
time: [184.62 µs 184.71 µs 184.82 µs]
change: [-46.457% -46.324% -46.147%] (p = 0.00 <
0.05)
Performance has improved.
Found 15 outliers among 100 measurements (15.00%)
1 (1.00%) high mild
14 (14.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.9, nulls: 0
time: [220.54 µs 220.64 µs 220.76 µs]
change: [-50.627% -50.541% -50.446%] (p = 0.00 <
0.05)
Performance has improved.
Found 12 outliers among 100 measurements (12.00%)
6 (6.00%) high mild
6 (6.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0
time: [604.72 µs 605.11 µs 605.52 µs]
change: [-49.608% -49.500% -49.397%] (p = 0.00 <
0.05)
Performance has improved.
Found 6 outliers among 100 measurements (6.00%)
3 (3.00%) high mild
3 (3.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0
time: [1.1897 ms 1.1902 ms 1.1908 ms]
change: [-50.301% -50.239% -50.166%] (p = 0.00 <
0.05)
Performance has improved.
Found 12 outliers among 100 measurements (12.00%)
4 (4.00%) high mild
8 (8.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.9, nulls: 0
time: [184.78 µs 184.89 µs 185.02 µs]
change: [-46.327% -46.264% -46.188%] (p = 0.00 <
0.05)
Performance has improved.
Found 14 outliers among 100 measurements (14.00%)
4 (4.00%) high mild
10 (10.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.9, nulls: 0
time: [220.78 µs 220.89 µs 221.02 µs]
change: [-50.481% -50.384% -50.286%] (p = 0.00 <
0.05)
Performance has improved.
Found 12 outliers among 100 measurements (12.00%)
5 (5.00%) high mild
7 (7.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1
time: [380.11 µs 380.35 µs 380.60 µs]
change: [-48.763% -48.658% -48.547%] (p = 0.00 <
0.05)
Performance has improved.
Found 3 outliers among 100 measurements (3.00%)
2 (2.00%) high mild
1 (1.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1
time: [612.17 µs 612.50 µs 612.86 µs]
change: [-37.370% -37.290% -37.198%] (p = 0.00 <
0.05)
Performance has improved.
Found 8 outliers among 100 measurements (8.00%)
6 (6.00%) high mild
2 (2.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1
time: [261.13 µs 261.27 µs 261.43 µs]
change: [-47.060% -46.965% -46.873%] (p = 0.00 <
0.05)
Performance has improved.
Found 10 outliers among 100 measurements (10.00%)
4 (4.00%) high mild
6 (6.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1
time: [325.59 µs 325.77 µs 325.98 µs]
change: [-43.134% -43.031% -42.932%] (p = 0.00 <
0.05)
Performance has improved.
Found 11 outliers among 100 measurements (11.00%)
5 (5.00%) high mild
6 (6.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1
time: [499.78 µs 500.12 µs 500.47 µs]
change: [-52.360% -52.251% -52.151%] (p = 0.00 <
0.05)
Performance has improved.
Found 13 outliers among 100 measurements (13.00%)
1 (1.00%) low mild
8 (8.00%) high mild
4 (4.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1
time: [885.91 µs 886.37 µs 886.91 µs]
change: [-45.948% -45.899% -45.838%] (p = 0.00 <
0.05)
Performance has improved.
Found 11 outliers among 100 measurements (11.00%)
2 (2.00%) high mild
9 (9.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1
time: [261.69 µs 261.82 µs 261.96 µs]
change: [-46.933% -46.816% -46.698%] (p = 0.00 <
0.05)
Performance has improved.
Found 8 outliers among 100 measurements (8.00%)
3 (3.00%) high mild
5 (5.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1
time: [325.81 µs 326.10 µs 326.47 µs]
change: [-43.161% -43.052% -42.950%] (p = 0.00 <
0.05)
Performance has improved.
Found 14 outliers among 100 measurements (14.00%)
5 (5.00%) high mild
9 (9.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1
time: [646.48 µs 646.83 µs 647.21 µs]
change: [-58.858% -58.753% -58.676%] (p = 0.00 <
0.05)
Performance has improved.
Found 7 outliers among 100 measurements (7.00%)
4 (4.00%) high mild
3 (3.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1
time: [1.1822 ms 1.1827 ms 1.1833 ms]
change: [-57.590% -57.554% -57.511%] (p = 0.00 <
0.05)
Performance has improved.
Found 11 outliers among 100 measurements (11.00%)
6 (6.00%) high mild
5 (5.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1
time: [261.53 µs 261.64 µs 261.75 µs]
change: [-47.034% -46.964% -46.912%] (p = 0.00 <
0.05)
Performance has improved.
Found 10 outliers among 100 measurements (10.00%)
6 (6.00%) high mild
4 (4.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1
time: [325.64 µs 325.75 µs 325.88 µs]
change: [-43.223% -43.074% -42.873%] (p = 0.00 <
0.05)
Performance has improved.
Found 13 outliers among 100 measurements (13.00%)
5 (5.00%) high mild
8 (8.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 5 entries, all equally
true/case_when 8192 rows: in_range: 1, nulls: 0
time: [318.60 µs 318.77 µs 318.98 µs]
change: [-45.598% -45.499% -45.401%] (p = 0.00 <
0.05)
Performance has improved.
Found 7 outliers among 100 measurements (7.00%)
3 (3.00%) high mild
4 (4.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 5 entries, all equally
true/case_when 8192 rows: in_range: 1, nulls: 0
time: [535.79 µs 536.02 µs 536.27 µs]
change: [-34.078% -34.002% -33.946%] (p = 0.00 <
0.05)
Performance has improved.
Found 10 outliers among 100 measurements (10.00%)
4 (4.00%) high mild
6 (6.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 1, nulls: 0
time: [184.35 µs 184.43 µs 184.52 µs]
change: [-46.597% -46.499% -46.424%] (p = 0.00 <
0.05)
Performance has improved.
Found 13 outliers among 100 measurements (13.00%)
3 (3.00%) high mild
10 (10.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 1, nulls: 0
time: [221.24 µs 221.32 µs 221.40 µs]
change: [-50.529% -50.450% -50.396%] (p = 0.00 <
0.05)
Performance has improved.
Found 9 outliers among 100 measurements (9.00%)
4 (4.00%) high mild
5 (5.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 10 entries, all equally
true/case_when 8192 rows: in_range: 1, nulls: 0
time: [447.56 µs 447.88 µs 448.22 µs]
change: [-44.991% -44.910% -44.843%] (p = 0.00 <
0.05)
Performance has improved.
Found 7 outliers among 100 measurements (7.00%)
1 (1.00%) low mild
3 (3.00%) high mild
3 (3.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 10 entries, all equally
true/case_when 8192 rows: in_range: 1, nulls: 0
time: [834.38 µs 834.71 µs 835.05 µs]
change: [-40.699% -40.629% -40.579%] (p = 0.00 <
0.05)
Performance has improved.
Found 7 outliers among 100 measurements (7.00%)
5 (5.00%) high mild
2 (2.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 1, nulls: 0
time: [184.54 µs 184.61 µs 184.70 µs]
change: [-46.448% -46.323% -46.219%] (p = 0.00 <
0.05)
Performance has improved.
Found 15 outliers among 100 measurements (15.00%)
1 (1.00%) low mild
3 (3.00%) high mild
11 (11.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 1, nulls: 0
time: [220.74 µs 220.83 µs 220.93 µs]
change: [-50.540% -50.468% -50.418%] (p = 0.00 <
0.05)
Performance has improved.
Found 12 outliers among 100 measurements (12.00%)
7 (7.00%) high mild
5 (5.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 20 entries, all equally
true/case_when 8192 rows: in_range: 1, nulls: 0
time: [600.44 µs 600.73 µs 601.04 µs]
change: [-49.882% -49.802% -49.745%] (p = 0.00 <
0.05)
Performance has improved.
Found 2 outliers among 100 measurements (2.00%)
2 (2.00%) high mild
lookup_table_case_when/case when utf8 -> i32, 20 entries, all equally
true/case_when 8192 rows: in_range: 1, nulls: 0
time: [1.1902 ms 1.1907 ms 1.1913 ms]
change: [-50.332% -50.302% -50.274%] (p = 0.00 <
0.05)
Performance has improved.
Found 15 outliers among 100 measurements (15.00%)
4 (4.00%) low mild
6 (6.00%) high mild
5 (5.00%) high severe
lookup_table_case_when/case when i32 -> utf8, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 1, nulls: 0
time: [184.29 µs 184.37 µs 184.47 µs]
change: [-46.503% -46.416% -46.354%] (p = 0.00 <
0.05)
Performance has improved.
Found 13 outliers among 100 measurements (13.00%)
6 (6.00%) high mild
7 (7.00%) high severe
lookup_table_case_when/case when utf8 -> i32, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 1, nulls: 0
time: [220.92 µs 221.01 µs 221.11 µs]
change: [-50.534% -50.467% -50.411%] (p = 0.00 <
0.05)
Performance has improved.
Found 13 outliers among 100 measurements (13.00%)
7 (7.00%) high mild
6 (6.00%) high severe
```
</details>
--
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]
