alamb commented on PR #18329:
URL: https://github.com/apache/datafusion/pull/18329#issuecomment-3459127209
🤖: Benchmark completed
<details><summary>Details</summary>
<p>
```
group
main
projected_case
-----
----
--------------
case_when 8192x100: CASE WHEN c1 < 0 THEN 0 WHEN c1 < 1000 THEN 1 ... WHEN
c1 < n * 1000 THEN n ELSE n + 1 END 19.61 2.7±0.02ms
? ?/sec 1.00 137.6±1.66µs ? ?/sec
case_when 8192x100: CASE WHEN c1 <= 500 THEN 1 ELSE 0 END
1.00 55.7±0.10µs
? ?/sec 1.00 55.4±0.19µs ? ?/sec
case_when 8192x100: CASE WHEN c1 <= 500 THEN c2 ELSE c3 END
15.83 383.2±9.95µs
? ?/sec 1.00 24.2±0.54µs ? ?/sec
case_when 8192x100: CASE WHEN c1 <= 500 THEN c2 [ELSE NULL] END
1.01 6.8±0.02µs
? ?/sec 1.00 6.8±0.02µs ? ?/sec
case_when 8192x100: CASE WHEN c1 == 0 THEN 0 WHEN c1 == 1 THEN 1 ... WHEN c1
== n THEN n ELSE n + 1 END 34.74 1673.0±10.59ms
? ?/sec 1.00 48.2±0.20ms ? ?/sec
case_when 8192x100: CASE c1 WHEN 0 THEN 0 WHEN 1 THEN 1 ... WHEN n THEN n
ELSE n + 1 END 32.32 1698.5±10.39ms
? ?/sec 1.00 52.6±0.30ms ? ?/sec
case_when 8192x100: CASE c1 WHEN 1 THEN c2 WHEN 2 THEN c3 END
13.28 395.9±9.86µs
? ?/sec 1.00 29.8±0.50µs ? ?/sec
case_when 8192x100: CASE c2 WHEN 0 THEN 0 WHEN 1000 THEN 1 ... WHEN n * 1000
THEN n ELSE n + 1 END 22.73 2.7±0.02ms
? ?/sec 1.00 120.6±1.13µs ? ?/sec
case_when 8192x3: CASE WHEN c1 < 0 THEN 0 WHEN c1 < 1000 THEN 1 ... WHEN c1
< n * 1000 THEN n ELSE n + 1 END 1.51 207.9±2.19µs
? ?/sec 1.00 137.4±1.64µs ? ?/sec
case_when 8192x3: CASE WHEN c1 <= 500 THEN 1 ELSE 0 END
1.01 55.5±0.17µs
? ?/sec 1.00 55.0±0.12µs ? ?/sec
case_when 8192x3: CASE WHEN c1 <= 500 THEN c2 ELSE c3 END
1.00 23.2±0.49µs
? ?/sec 1.01 23.6±0.45µs ? ?/sec
case_when 8192x3: CASE WHEN c1 <= 500 THEN c2 [ELSE NULL] END
1.00 6.8±0.02µs
? ?/sec 1.01 6.8±0.02µs ? ?/sec
case_when 8192x3: CASE WHEN c1 == 0 THEN 0 WHEN c1 == 1 THEN 1 ... WHEN c1
== n THEN n ELSE n + 1 END 1.41 68.3±0.29ms
? ?/sec 1.00 48.3±0.29ms ? ?/sec
case_when 8192x3: CASE c1 WHEN 0 THEN 0 WHEN 1 THEN 1 ... WHEN n THEN n ELSE
n + 1 END 1.38 73.3±0.47ms
? ?/sec 1.00 53.0±0.37ms ? ?/sec
case_when 8192x3: CASE c1 WHEN 1 THEN c2 WHEN 2 THEN c3 END
1.01 29.9±0.71µs
? ?/sec 1.00 29.8±0.57µs ? ?/sec
case_when 8192x3: CASE c2 WHEN 0 THEN 0 WHEN 1000 THEN 1 ... WHEN n * 1000
THEN n ELSE n + 1 END 1.58 190.7±1.74µs
? ?/sec 1.00 120.5±1.56µs ? ?/sec
case_when 8192x50: CASE WHEN c1 < 0 THEN 0 WHEN c1 < 1000 THEN 1 ... WHEN c1
< n * 1000 THEN n ELSE n + 1 END 9.95 1374.8±9.67µs
? ?/sec 1.00 138.2±1.63µs ? ?/sec
case_when 8192x50: CASE WHEN c1 <= 500 THEN 1 ELSE 0 END
1.01 55.6±0.19µs
? ?/sec 1.00 55.1±0.12µs ? ?/sec
case_when 8192x50: CASE WHEN c1 <= 500 THEN c2 ELSE c3 END
7.37 177.8±4.35µs
? ?/sec 1.00 24.1±0.48µs ? ?/sec
case_when 8192x50: CASE WHEN c1 <= 500 THEN c2 [ELSE NULL] END
1.00 6.8±0.02µs
? ?/sec 1.00 6.8±0.01µs ? ?/sec
case_when 8192x50: CASE WHEN c1 == 0 THEN 0 WHEN c1 == 1 THEN 1 ... WHEN c1
== n THEN n ELSE n + 1 END 15.53 750.3±5.06ms
? ?/sec 1.00 48.3±0.23ms ? ?/sec
case_when 8192x50: CASE c1 WHEN 0 THEN 0 WHEN 1 THEN 1 ... WHEN n THEN n
ELSE n + 1 END 14.49 764.2±5.57ms
? ?/sec 1.00 52.8±0.30ms ? ?/sec
case_when 8192x50: CASE c1 WHEN 1 THEN c2 WHEN 2 THEN c3 END
6.23 183.3±4.96µs
? ?/sec 1.00 29.4±0.64µs ? ?/sec
case_when 8192x50: CASE c2 WHEN 0 THEN 0 WHEN 1000 THEN 1 ... WHEN n * 1000
THEN n ELSE n + 1 END 11.37 1373.7±9.49µs
? ?/sec 1.00 120.8±1.22µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0 1.03
475.3±2.02µs ? ?/sec 1.00 459.4±2.24µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1 1.03
530.2±3.21µs ? ?/sec 1.00 516.5±1.50µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5 1.01
405.4±2.21µs ? ?/sec 1.00 402.5±1.24µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0 1.02
470.8±1.22µs ? ?/sec 1.00 463.6±3.65µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1 1.01
525.9±1.84µs ? ?/sec 1.00 520.0±2.40µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5 1.00
405.2±2.12µs ? ?/sec 1.00 404.4±2.55µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0 1.02
472.3±2.60µs ? ?/sec 1.00 464.0±1.65µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1 1.02
526.0±1.90µs ? ?/sec 1.00 517.2±4.05µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 10 entries, all equally
true/case_when 8192 rows: in_range: 1, nulls: 0 1.02
472.7±1.75µs ? ?/sec 1.00 464.5±3.33µs ? ?/sec
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.01 196.1±1.49µs
? ?/sec 1.00 194.2±0.45µs ? ?/sec
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 1.01 275.5±1.39µs
? ?/sec 1.00 273.5±0.92µs ? ?/sec
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 1.01 261.8±0.85µs
? ?/sec 1.00 259.8±1.34µs ? ?/sec
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.00 195.5±0.37µs
? ?/sec 1.00 194.8±0.77µs ? ?/sec
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 1.00 274.9±0.91µs
? ?/sec 1.00 274.0±0.75µs ? ?/sec
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 1.00 261.3±0.60µs
? ?/sec 1.00 260.4±1.02µs ? ?/sec
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.01 195.9±0.91µs
? ?/sec 1.00 194.7±0.46µs ? ?/sec
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 1.01 275.8±1.33µs
? ?/sec 1.00 274.2±0.83µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 1, nulls: 0 1.00 195.7±0.56µs
? ?/sec 1.00 195.0±0.43µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0 1.05
644.1±2.41µs ? ?/sec 1.00 616.1±1.92µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1 1.04
688.8±3.69µs ? ?/sec 1.00 660.8±2.61µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5 1.03
511.2±7.70µs ? ?/sec 1.00 498.5±1.75µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0 1.04
642.0±3.67µs ? ?/sec 1.00 619.1±1.94µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1 1.03
685.5±2.54µs ? ?/sec 1.00 663.3±4.43µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5 1.02
511.0±2.55µs ? ?/sec 1.00 501.3±2.51µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0 1.03
639.8±3.19µs ? ?/sec 1.00 618.6±5.47µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1 1.04
685.1±3.31µs ? ?/sec 1.00 661.2±3.75µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 20 entries, all equally
true/case_when 8192 rows: in_range: 1, nulls: 0 1.04
642.1±3.73µs ? ?/sec 1.00 616.2±3.76µs ? ?/sec
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.00 195.4±0.47µs
? ?/sec 1.00 194.9±0.61µs ? ?/sec
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 1.01 275.9±1.24µs
? ?/sec 1.00 273.0±0.94µs ? ?/sec
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 1.00 261.3±1.58µs
? ?/sec 1.00 260.2±1.03µs ? ?/sec
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.00 195.6±0.59µs
? ?/sec 1.00 195.2±2.38µs ? ?/sec
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 1.00 275.3±1.19µs
? ?/sec 1.00 274.7±2.44µs ? ?/sec
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 1.00 261.6±2.74µs
? ?/sec 1.00 260.6±1.21µs ? ?/sec
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.00 195.6±0.83µs
? ?/sec 1.00 195.0±0.48µs ? ?/sec
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 1.00 275.0±0.90µs
? ?/sec 1.00 274.5±1.73µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 1, nulls: 0 1.00 195.9±0.64µs
? ?/sec 1.00 195.8±0.43µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0 1.02
338.7±1.59µs ? ?/sec 1.00 332.4±0.91µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1 1.01
399.6±1.52µs ? ?/sec 1.00 396.4±1.26µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5 1.01
326.9±1.62µs ? ?/sec 1.00 325.0±4.86µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0 1.02
338.5±1.41µs ? ?/sec 1.00 332.5±1.27µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1 1.01
399.5±1.54µs ? ?/sec 1.00 396.9±1.30µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5 1.00
325.4±1.04µs ? ?/sec 1.00 325.2±1.55µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0 1.02
338.4±2.00µs ? ?/sec 1.00 333.0±1.17µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1 1.01
399.4±1.52µs ? ?/sec 1.00 396.0±0.88µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 5 entries, all equally
true/case_when 8192 rows: in_range: 1, nulls: 0 1.03
344.0±21.42µs ? ?/sec 1.00 333.4±1.47µs ? ?/sec
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.01 195.8±0.43µs
? ?/sec 1.00 194.2±0.66µs ? ?/sec
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 1.01 276.0±1.14µs
? ?/sec 1.00 273.9±3.04µs ? ?/sec
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 1.01 261.8±1.15µs
? ?/sec 1.00 259.5±1.00µs ? ?/sec
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.01 195.8±1.71µs
? ?/sec 1.00 194.5±0.42µs ? ?/sec
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 1.01 275.6±0.82µs
? ?/sec 1.00 273.6±1.79µs ? ?/sec
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 1.00 261.5±0.80µs
? ?/sec 1.00 261.0±1.16µs ? ?/sec
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.01 195.8±0.62µs
? ?/sec 1.00 194.9±0.65µs ? ?/sec
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 1.00 275.5±1.09µs
? ?/sec 1.00 275.1±1.35µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 1, nulls: 0 1.01 196.3±0.63µs
? ?/sec 1.00 195.3±0.65µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0 1.00
850.5±1.95µs ? ?/sec 1.01 858.1±1.92µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1 1.00
902.8±3.60µs ? ?/sec 1.01 910.6±1.45µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5 1.00
636.8±7.77µs ? ?/sec 1.02 648.5±1.66µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0 1.00
850.6±1.99µs ? ?/sec 1.01 858.7±8.75µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1 1.00
901.9±2.27µs ? ?/sec 1.01 912.6±2.35µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5 1.00
634.9±1.85µs ? ?/sec 1.02 648.5±1.86µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0 1.00
850.4±2.55µs ? ?/sec 1.01 859.1±3.68µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1 1.00
902.6±2.49µs ? ?/sec 1.01 910.3±4.27µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 10 entries, all equally
true/case_when 8192 rows: in_range: 1, nulls: 0 1.00
849.5±1.90µs ? ?/sec 1.01 858.8±5.66µs ? ?/sec
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.00 230.2±1.37µs
? ?/sec 1.00 230.1±0.51µs ? ?/sec
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 1.01 343.3±27.93µs
? ?/sec 1.00 341.2±15.74µs ? ?/sec
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 1.00 316.8±2.00µs
? ?/sec 1.02 321.7±5.32µs ? ?/sec
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.00 230.3±1.62µs
? ?/sec 1.00 230.2±0.63µs ? ?/sec
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 1.00 336.8±1.03µs
? ?/sec 1.01 340.0±2.57µs ? ?/sec
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 1.00 317.6±1.28µs
? ?/sec 1.01 322.0±1.04µs ? ?/sec
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.00 230.4±0.59µs
? ?/sec 1.00 229.8±0.76µs ? ?/sec
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 1.00 336.8±1.25µs
? ?/sec 1.01 340.2±1.41µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 1, nulls: 0 1.00 230.2±0.57µs
? ?/sec 1.00 230.3±0.64µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0 1.00
1210.6±5.03µs ? ?/sec 1.02 1229.5±6.49µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1 1.00
1212.7±6.94µs ? ?/sec 1.00 1218.4±2.75µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5 1.00
833.7±2.05µs ? ?/sec 1.01 846.0±1.75µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0 1.00
1212.0±12.13µs ? ?/sec 1.01 1228.0±7.01µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1 1.00
1201.1±3.71µs ? ?/sec 1.02 1219.5±6.77µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5 1.00
834.6±3.98µs ? ?/sec 1.02 848.1±3.33µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0 1.00
1209.7±3.32µs ? ?/sec 1.02 1228.0±3.80µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1 1.00
1200.2±3.96µs ? ?/sec 1.01 1218.1±3.17µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 20 entries, all equally
true/case_when 8192 rows: in_range: 1, nulls: 0 1.00
1213.2±6.32µs ? ?/sec 1.01 1226.5±2.48µs ? ?/sec
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.00 230.2±0.79µs
? ?/sec 1.00 230.0±0.43µs ? ?/sec
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 1.00 336.4±1.44µs
? ?/sec 1.00 337.8±0.91µs ? ?/sec
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 1.00 317.8±2.80µs
? ?/sec 1.01 321.5±2.43µs ? ?/sec
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.00 230.4±0.49µs
? ?/sec 1.00 230.9±0.99µs ? ?/sec
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 1.00 336.8±1.02µs
? ?/sec 1.01 339.5±2.20µs ? ?/sec
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 1.00 318.7±3.78µs
? ?/sec 1.01 322.4±2.85µs ? ?/sec
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.00 230.2±0.52µs
? ?/sec 1.00 230.6±2.64µs ? ?/sec
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 1.00 336.3±0.83µs
? ?/sec 1.01 339.2±1.87µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 1, nulls: 0 1.00 230.4±0.52µs
? ?/sec 1.00 229.9±0.39µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0 1.00
548.6±1.34µs ? ?/sec 1.01 555.2±1.30µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1 1.00
629.5±3.44µs ? ?/sec 1.01 634.7±2.70µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5 1.00
486.3±1.52µs ? ?/sec 1.03 499.4±1.81µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0 1.00
549.8±1.35µs ? ?/sec 1.01 555.0±1.59µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1 1.00
627.6±2.21µs ? ?/sec 1.01 635.8±3.00µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5 1.00
485.2±1.64µs ? ?/sec 1.03 500.6±2.18µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0 1.00
547.9±1.99µs ? ?/sec 1.01 554.2±1.55µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1 1.00
629.5±1.77µs ? ?/sec 1.01 634.3±1.65µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 5 entries, all equally
true/case_when 8192 rows: in_range: 1, nulls: 0 1.00
549.3±2.01µs ? ?/sec 1.01 556.5±1.82µs ? ?/sec
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.00 230.3±0.76µs
? ?/sec 1.00 230.1±0.61µs ? ?/sec
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 1.00 336.6±2.33µs
? ?/sec 1.01 338.4±1.16µs ? ?/sec
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 1.00 317.9±1.27µs
? ?/sec 1.01 321.5±0.58µs ? ?/sec
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.00 230.4±0.98µs
? ?/sec 1.00 230.0±0.54µs ? ?/sec
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 1.00 336.5±0.77µs
? ?/sec 1.01 339.3±1.23µs ? ?/sec
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 1.00 317.7±1.17µs
? ?/sec 1.01 321.4±0.79µs ? ?/sec
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.00 230.8±0.87µs
? ?/sec 1.00 230.2±0.76µs ? ?/sec
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 1.00 336.6±1.42µs
? ?/sec 1.01 339.9±2.57µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 1, nulls: 0 1.00 230.3±0.59µs
? ?/sec 1.00 230.5±2.74µs ? ?/sec
```
</p>
</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]
