zhuqi-lucas commented on PR #16771:
URL: https://github.com/apache/datafusion/pull/16771#issuecomment-3142010548
> 🤖: Benchmark completed
>
> Details
>
> ```
> group main
reduce_expr_size
> ----- ----
----------------
> logical_aggregate_with_join 1.00 625.3±5.41µs
? ?/sec 1.02 638.6±4.90µs ? ?/sec
> logical_select_all_from_1000 1.00 11.2±0.03ms
? ?/sec 1.02 11.4±0.05ms ? ?/sec
> logical_select_one_from_700 1.00 407.5±1.46µs
? ?/sec 1.04 424.5±1.85µs ? ?/sec
> logical_trivial_join_high_numbered_columns 1.00 368.6±1.13µs
? ?/sec 1.03 379.7±1.68µs ? ?/sec
> logical_trivial_join_low_numbered_columns 1.00 355.7±2.48µs
? ?/sec 1.03 366.6±3.68µs ? ?/sec
> physical_intersection 1.00 823.8±6.20µs
? ?/sec 1.03 845.5±4.49µs ? ?/sec
> physical_join_consider_sort 1.00 1357.4±5.64µs
? ?/sec 1.04 1408.9±6.90µs ? ?/sec
> physical_join_distinct 1.00 345.1±2.08µs
? ?/sec 1.03 355.8±1.11µs ? ?/sec
> physical_many_self_joins 1.00 10.0±0.06ms
? ?/sec 1.06 10.6±0.07ms ? ?/sec
> physical_plan_clickbench_all 1.00 189.3±1.70ms
? ?/sec 1.05 199.1±10.69ms ? ?/sec
> physical_plan_clickbench_q1 1.00 2.6±0.02ms
? ?/sec 1.02 2.6±0.07ms ? ?/sec
> physical_plan_clickbench_q10 1.00 3.4±0.03ms
? ?/sec 1.04 3.5±0.15ms ? ?/sec
> physical_plan_clickbench_q11 1.00 3.6±0.05ms
? ?/sec 1.06 3.8±0.21ms ? ?/sec
> physical_plan_clickbench_q12 1.00 3.8±0.08ms
? ?/sec 1.05 3.9±0.18ms ? ?/sec
> physical_plan_clickbench_q13 1.00 3.4±0.03ms
? ?/sec 1.05 3.5±0.16ms ? ?/sec
> physical_plan_clickbench_q14 1.00 3.6±0.05ms
? ?/sec 1.02 3.7±0.16ms ? ?/sec
> physical_plan_clickbench_q15 1.00 3.5±0.03ms
? ?/sec 1.06 3.7±0.21ms ? ?/sec
> physical_plan_clickbench_q16 1.00 3.3±0.04ms
? ?/sec 1.03 3.4±0.14ms ? ?/sec
> physical_plan_clickbench_q17 1.00 3.4±0.03ms
? ?/sec 1.05 3.6±0.15ms ? ?/sec
> physical_plan_clickbench_q18 1.00 2.9±0.02ms
? ?/sec 1.06 3.1±0.15ms ? ?/sec
> physical_plan_clickbench_q19 1.00 3.8±0.05ms
? ?/sec 1.07 4.1±0.20ms ? ?/sec
> physical_plan_clickbench_q2 1.00 3.0±0.03ms
? ?/sec 1.02 3.0±0.09ms ? ?/sec
> physical_plan_clickbench_q20 1.00 2.7±0.03ms
? ?/sec 1.04 2.8±0.08ms ? ?/sec
> physical_plan_clickbench_q21 1.00 3.0±0.03ms
? ?/sec 1.05 3.2±0.14ms ? ?/sec
> physical_plan_clickbench_q22 1.00 3.6±0.04ms
? ?/sec 1.07 3.8±0.18ms ? ?/sec
> physical_plan_clickbench_q23 1.00 3.9±0.04ms
? ?/sec 1.05 4.1±0.19ms ? ?/sec
> physical_plan_clickbench_q24 1.00 4.3±0.04ms
? ?/sec 1.04 4.5±0.20ms ? ?/sec
> physical_plan_clickbench_q25 1.00 3.1±0.05ms
? ?/sec 1.05 3.2±0.12ms ? ?/sec
> physical_plan_clickbench_q26 1.00 3.0±0.03ms
? ?/sec 1.03 3.0±0.13ms ? ?/sec
> physical_plan_clickbench_q27 1.00 3.1±0.04ms
? ?/sec 1.07 3.3±0.12ms ? ?/sec
> physical_plan_clickbench_q28 1.00 3.9±0.05ms
? ?/sec 1.07 4.2±0.22ms ? ?/sec
> physical_plan_clickbench_q29 1.00 4.6±0.05ms
? ?/sec 1.09 5.0±0.24ms ? ?/sec
> physical_plan_clickbench_q3 1.00 2.9±0.03ms
? ?/sec 1.05 3.0±0.09ms ? ?/sec
> physical_plan_clickbench_q30 1.00 12.9±0.16ms
? ?/sec 1.06 13.7±0.33ms ? ?/sec
> physical_plan_clickbench_q31 1.00 3.9±0.04ms
? ?/sec 1.08 4.2±0.21ms ? ?/sec
> physical_plan_clickbench_q32 1.00 3.9±0.04ms
? ?/sec 1.08 4.2±0.21ms ? ?/sec
> physical_plan_clickbench_q33 1.00 3.4±0.04ms
? ?/sec 1.11 3.8±0.14ms ? ?/sec
> physical_plan_clickbench_q34 1.00 3.1±0.03ms
? ?/sec 1.08 3.4±0.17ms ? ?/sec
> physical_plan_clickbench_q35 1.00 3.2±0.02ms
? ?/sec 1.06 3.4±0.11ms ? ?/sec
> physical_plan_clickbench_q36 1.00 4.0±0.10ms
? ?/sec 1.03 4.1±0.18ms ? ?/sec
> physical_plan_clickbench_q37 1.00 3.9±0.05ms
? ?/sec 1.06 4.2±0.20ms ? ?/sec
> physical_plan_clickbench_q38 1.00 3.9±0.04ms
? ?/sec 1.06 4.2±0.21ms ? ?/sec
> physical_plan_clickbench_q39 1.00 3.8±0.05ms
? ?/sec 1.07 4.0±0.17ms ? ?/sec
> physical_plan_clickbench_q4 1.00 2.6±0.03ms
? ?/sec 1.03 2.7±0.11ms ? ?/sec
> physical_plan_clickbench_q40 1.00 4.4±0.08ms
? ?/sec 1.06 4.7±0.22ms ? ?/sec
> physical_plan_clickbench_q41 1.00 3.9±0.04ms
? ?/sec 1.05 4.1±0.17ms ? ?/sec
> physical_plan_clickbench_q42 1.00 3.9±0.04ms
? ?/sec 1.04 4.0±0.15ms ? ?/sec
> physical_plan_clickbench_q43 1.00 4.2±0.05ms
? ?/sec 1.08 4.6±0.22ms ? ?/sec
> physical_plan_clickbench_q44 1.00 2.8±0.03ms
? ?/sec 1.04 2.9±0.11ms ? ?/sec
> physical_plan_clickbench_q45 1.00 2.8±0.03ms
? ?/sec 1.04 2.9±0.12ms ? ?/sec
> physical_plan_clickbench_q46 1.00 3.2±0.03ms
? ?/sec 1.06 3.4±0.13ms ? ?/sec
> physical_plan_clickbench_q47 1.00 3.8±0.05ms
? ?/sec 1.09 4.1±0.20ms ? ?/sec
> physical_plan_clickbench_q48 1.00 4.5±0.05ms
? ?/sec 1.06 4.7±0.23ms ? ?/sec
> physical_plan_clickbench_q49 1.00 4.7±0.05ms
? ?/sec 1.08 5.1±0.28ms ? ?/sec
> physical_plan_clickbench_q5 1.00 2.9±0.03ms
? ?/sec 1.04 3.0±0.11ms ? ?/sec
> physical_plan_clickbench_q50 1.00 4.3±0.07ms
? ?/sec 1.06 4.5±0.15ms ? ?/sec
> physical_plan_clickbench_q51 1.00 3.3±0.03ms
? ?/sec 1.06 3.5±0.15ms ? ?/sec
> physical_plan_clickbench_q6 1.00 2.9±0.02ms
? ?/sec 1.01 2.9±0.08ms ? ?/sec
> physical_plan_clickbench_q7 1.00 2.6±0.02ms
? ?/sec 1.01 2.6±0.06ms ? ?/sec
> physical_plan_clickbench_q8 1.00 3.4±0.03ms
? ?/sec 1.01 3.4±0.10ms ? ?/sec
> physical_plan_clickbench_q9 1.00 3.3±0.03ms
? ?/sec 1.01 3.3±0.10ms ? ?/sec
> physical_plan_tpcds_all 1.00 1037.0±4.58ms
? ?/sec 1.02 1054.4±9.52ms ? ?/sec
> physical_plan_tpch_all 1.00 62.9±0.39ms
? ?/sec 1.00 63.0±1.20ms ? ?/sec
> physical_plan_tpch_q1 1.01 2.0±0.01ms
? ?/sec 1.00 2.0±0.01ms ? ?/sec
> physical_plan_tpch_q10 1.00 3.8±0.02ms
? ?/sec 1.01 3.8±0.07ms ? ?/sec
> physical_plan_tpch_q11 1.00 3.3±0.02ms
? ?/sec 1.00 3.3±0.03ms ? ?/sec
> physical_plan_tpch_q12 1.00 1810.0±9.40µs
? ?/sec 1.00 1801.7±26.08µs ? ?/sec
> physical_plan_tpch_q13 1.00 1466.8±8.13µs
? ?/sec 1.00 1464.8±10.59µs ? ?/sec
> physical_plan_tpch_q14 1.01 1936.8±9.22µs
? ?/sec 1.00 1926.2±12.19µs ? ?/sec
> physical_plan_tpch_q16 1.00 2.5±0.01ms
? ?/sec 1.00 2.5±0.03ms ? ?/sec
> physical_plan_tpch_q17 1.00 2.4±0.01ms
? ?/sec 1.00 2.4±0.02ms ? ?/sec
> physical_plan_tpch_q18 1.00 2.7±0.01ms
? ?/sec 1.00 2.7±0.05ms ? ?/sec
> physical_plan_tpch_q19 1.02 3.2±0.01ms
? ?/sec 1.00 3.2±0.03ms ? ?/sec
> physical_plan_tpch_q2 1.00 5.5±0.07ms
? ?/sec 1.00 5.5±0.04ms ? ?/sec
> physical_plan_tpch_q20 1.01 3.1±0.02ms
? ?/sec 1.00 3.1±0.03ms ? ?/sec
> physical_plan_tpch_q21 1.00 4.1±0.02ms
? ?/sec 1.01 4.1±0.05ms ? ?/sec
> physical_plan_tpch_q22 1.00 2.7±0.01ms
? ?/sec 1.00 2.7±0.04ms ? ?/sec
> physical_plan_tpch_q3 1.00 2.5±0.01ms
? ?/sec 1.00 2.5±0.01ms ? ?/sec
> physical_plan_tpch_q4 1.01 1533.8±10.45µs
? ?/sec 1.00 1525.9±5.09µs ? ?/sec
> physical_plan_tpch_q5 1.00 3.2±0.01ms
? ?/sec 1.00 3.2±0.02ms ? ?/sec
> physical_plan_tpch_q6 1.02 865.4±6.90µs
? ?/sec 1.00 848.0±5.88µs ? ?/sec
> physical_plan_tpch_q7 1.00 4.3±0.02ms
? ?/sec 1.00 4.2±0.03ms ? ?/sec
> physical_plan_tpch_q8 1.00 5.2±0.03ms
? ?/sec 1.00 5.2±0.05ms ? ?/sec
> physical_plan_tpch_q9 1.00 4.1±0.02ms
? ?/sec 1.02 4.2±0.09ms ? ?/sec
> physical_select_aggregates_from_200 1.01 18.3±0.10ms
? ?/sec 1.00 18.1±0.09ms ? ?/sec
> physical_select_all_from_1000 1.00 24.6±0.10ms
? ?/sec 1.02 25.1±0.17ms ? ?/sec
> physical_select_one_from_700 1.00 1034.0±4.69µs
? ?/sec 1.07 1110.0±7.55µs ? ?/sec
> physical_sorted_union_orderby 1.00 41.8±0.29ms
? ?/sec 1.03 43.0±0.41ms ? ?/sec
> physical_theta_join_consider_sort 1.00 1728.4±8.41µs
? ?/sec 1.03 1777.1±5.94µs ? ?/sec
> physical_unnest_to_join 1.00 1281.0±5.26µs
? ?/sec 1.02 1309.8±7.33µs ? ?/sec
> with_param_values_many_columns 1.02 129.0±1.01µs
? ?/sec 1.00 126.3±0.67µs ? ?/sec
> ```
Than you @alamb , strange, it always bad performance now.
--
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]
