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

   
   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 0ffb9992856aba58fd644e91d4844e83f474b635, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5485    5083    5137    5083
   q2   391     164     156     156
   q3   1475    1222    1199    1199
   q4   1110    863     809     809
   q5   3067    3126    3132    3126
   q6   234     139     141     139
   q7   980     572     523     523
   q8   2147    2208    2229    2208
   q9   6701    6666    6641    6641
   q10  3189    3130    3121    3121
   q11  347     217     226     217
   q12  382     251     241     241
   q13  4422    3644    3683    3644
   q14  253     224     220     220
   q15  612     558     543     543
   q16  466     406     406     406
   q17  1042    531     504     504
   q18  7130    6843    6781    6781
   q19  1639    1558    1537    1537
   q20  777     344     356     344
   q21  2883    2507    2508    2507
   q22  395     317     341     317
   Total cold run time: 45127 ms
   Total hot run time: 40266 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5146    5157    5079    5079
   q2   341     262     235     235
   q3   3365    3321    3338    3321
   q4   2161    2004    2015    2004
   q5   5962    5905    5947    5905
   q6   230     129     132     129
   q7   2381    1906    1946    1906
   q8   3549    3662    3674    3662
   q9   9060    9033    8976    8976
   q10  3885    3964    3961    3961
   q11  600     497     487     487
   q12  801     663     669     663
   q13  3886    3248    3212    3212
   q14  309     270     269     269
   q15  608     554     545     545
   q16  580     512     561     512
   q17  2039    1856    1821    1821
   q18  8799    8458    8447    8447
   q19  1740    1665    1692    1665
   q20  2290    1976    2004    1976
   q21  5712    5340    5313    5313
   q22  560     497     487     487
   Total cold run time: 64004 ms
   Total hot run time: 60575 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