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

   
   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 acbb64ff690dc4f827a4c8dc8765253a86d3070c, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5506    5157    5168    5157
   q2   381     175     177     175
   q3   1461    1167    1110    1110
   q4   1084    874     787     787
   q5   3145    3095    3053    3053
   q6   230     131     130     130
   q7   970     551     515     515
   q8   2159    2296    2229    2229
   q9   6691    6685    6683    6683
   q10  3185    3126    3157    3126
   q11  345     211     218     211
   q12  379     238     242     238
   q13  4400    3627    3661    3627
   q14  244     232     213     213
   q15  587     537     535     535
   q16  467     403     384     384
   q17  1041    482     592     482
   q18  7096    6705    6976    6705
   q19  1652    1522    1583    1522
   q20  585     342     350     342
   q21  2963    2508    2482    2482
   q22  409     333     328     328
   Total cold run time: 44980 ms
   Total hot run time: 40034 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5160    5086    5071    5071
   q2   336     239     237     237
   q3   3342    3341    3336    3336
   q4   2178    2006    1988    1988
   q5   5936    5924    5920    5920
   q6   222     125     128     125
   q7   2397    1930    1935    1930
   q8   3555    3651    3685    3651
   q9   9019    8962    9002    8962
   q10  3875    3886    3925    3886
   q11  578     501     467     467
   q12  799     636     635     635
   q13  3916    3209    3222    3209
   q14  307     284     274     274
   q15  585     539     523     523
   q16  578     483     491     483
   q17  2047    1826    1798    1798
   q18  8744    8365    8512    8365
   q19  1747    1711    1709    1709
   q20  2272    1979    1967    1967
   q21  5810    5416    5286    5286
   q22  547     534     539     534
   Total cold run time: 63950 ms
   Total hot run time: 60356 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