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

   
   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 09f40123e879462e95b5e4958a3c8b9b332ff697, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5561    5189    5152    5152
   q2   384     176     160     160
   q3   1475    1136    1166    1136
   q4   1090    838     843     838
   q5   3134    3130    3104    3104
   q6   223     140     137     137
   q7   979     559     518     518
   q8   2163    2282    2249    2249
   q9   6695    6675    6706    6675
   q10  3199    3139    3102    3102
   q11  345     226     208     208
   q12  382     241     235     235
   q13  4432    3659    3639    3639
   q14  258     225     227     225
   q15  578     540     531     531
   q16  457     395     394     394
   q17  1050    601     499     499
   q18  7134    6783    6814    6783
   q19  1662    1498    1434    1434
   q20  599     359     348     348
   q21  2908    2480    2526    2480
   q22  381     317     340     317
   Total cold run time: 45089 ms
   Total hot run time: 40164 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5072    5155    5058    5058
   q2   354     240     250     240
   q3   3357    3329    3310    3310
   q4   2178    2069    2063    2063
   q5   5972    5922    5930    5922
   q6   226     132     132     132
   q7   2378    1890    1907    1890
   q8   3568    3696    3683    3683
   q9   9120    9047    8985    8985
   q10  3875    3919    3911    3911
   q11  585     475     477     475
   q12  826     640     646     640
   q13  3875    3223    3209    3209
   q14  297     288     276     276
   q15  595     534     537     534
   q16  557     497     512     497
   q17  2024    1882    1811    1811
   q18  8790    8395    8355    8355
   q19  1752    1732    1706    1706
   q20  2259    2032    1969    1969
   q21  5761    5541    5359    5359
   q22  560     489     558     489
   Total cold run time: 63981 ms
   Total hot run time: 60514 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