doris-robot commented on PR #29405:
URL: https://github.com/apache/doris/pull/29405#issuecomment-1873758965

   
   TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with 
scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
   ```
   Tpch sf100 test result on commit c16622c6b574e18ad20c1d885fe6e9de382e4029, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5502    5271    5330    5271
   q2   407     168     159     159
   q3   1556    1300    1265    1265
   q4   1162    915     877     877
   q5   3222    3222    3186    3186
   q6   242     156     134     134
   q7   1055    533     507     507
   q8   2306    2357    2321    2321
   q9   6927    6858    6848    6848
   q10  3238    3195    3150    3150
   q11  352     216     218     216
   q12  405     232     234     232
   q13  4443    3637    3621    3621
   q14  249     213     210     210
   q15  622     527     542     527
   q16  438     405     412     405
   q17  1074    569     536     536
   q18  7117    6780    6820    6780
   q19  1787    1606    1608    1606
   q20  585     356     322     322
   q21  2998    2600    2554    2554
   q22  402     311     340     311
   Total cold run time: 46089 ms
   Total hot run time: 41038 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5313    5132    5187    5132
   q2   352     258     246     246
   q3   3443    3365    3374    3365
   q4   2204    2048    2028    2028
   q5   6106    6059    6076    6059
   q6   246     127     123     123
   q7   2420    1896    1895    1895
   q8   3709    3819    3835    3819
   q9   9206    9086    9047    9047
   q10  3926    3973    4010    3973
   q11  591     488     466     466
   q12  819     673     637     637
   q13  3926    3190    3189    3189
   q14  310     277     269     269
   q15  608     546     548     546
   q16  551     531     496     496
   q17  2140    1870    1907    1870
   q18  8898    8511    8454    8454
   q19  1923    1875    1878    1875
   q20  2313    1977    1994    1977
   q21  5882    5300    5409    5300
   q22  582     513     479     479
   Total cold run time: 65468 ms
   Total hot run time: 61245 ms
   ```
   


-- 
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: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to