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

   
   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 e196fc0a7f204622fa09c908e7d7122a40e2bc08, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5515    5082    5149    5082
   q2   404     173     149     149
   q3   1453    1183    1179    1179
   q4   1088    854     850     850
   q5   3152    3178    3093    3093
   q6   221     135     137     135
   q7   1014    572     532     532
   q8   2184    2210    2215    2210
   q9   6724    6650    6648    6648
   q10  3171    3185    3074    3074
   q11  333     216     225     216
   q12  395     235     239     235
   q13  4442    3711    3757    3711
   q14  261     230     221     221
   q15  580     534     539     534
   q16  456     395     383     383
   q17  1046    494     494     494
   q18  7161    6854    6880    6854
   q19  1648    1551    1440    1440
   q20  550     343     340     340
   q21  2892    2465    2477    2465
   q22  395     340     342     340
   Total cold run time: 45085 ms
   Total hot run time: 40185 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5086    5053    5102    5053
   q2   350     238     240     238
   q3   3379    3338    3304    3304
   q4   2172    2095    2071    2071
   q5   5971    5951    5973    5951
   q6   227     126     128     126
   q7   2398    1939    1952    1939
   q8   3582    3658    3668    3658
   q9   9090    8993    9066    8993
   q10  3924    3900    3941    3900
   q11  607     474     492     474
   q12  801     635     663     635
   q13  3905    3226    3202    3202
   q14  293     263     287     263
   q15  591     544     532     532
   q16  575     501     514     501
   q17  2052    1810    1819    1810
   q18  8834    8439    8404    8404
   q19  1760    1715    1680    1680
   q20  2394    2016    1968    1968
   q21  5805    5350    5423    5350
   q22  550     477     493     477
   Total cold run time: 64346 ms
   Total hot run time: 60529 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: [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]

Reply via email to