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

   
   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 ef85c8a97eb02d2453de453c119a29ea7be01d36, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5463    5102    5182    5102
   q2   396     182     174     174
   q3   1454    1129    1113    1113
   q4   1089    835     838     835
   q5   3147    3153    3091    3091
   q6   226     131     131     131
   q7   976     555     525     525
   q8   2152    2216    2205    2205
   q9   6686    6674    6631    6631
   q10  3201    3124    3170    3124
   q11  335     227     220     220
   q12  380     236     234     234
   q13  4355    3664    3627    3627
   q14  265     213     225     213
   q15  608     565     553     553
   q16  457     406     404     404
   q17  1039    521     463     463
   q18  7070    6677    6727    6677
   q19  1640    1519    1633    1519
   q20  606     366     344     344
   q21  2865    2582    2511    2511
   q22  399     310     345     310
   Total cold run time: 44809 ms
   Total hot run time: 40006 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5093    5087    5127    5087
   q2   336     231     260     231
   q3   3358    3337    3318    3318
   q4   2124    2005    1993    1993
   q5   5940    5915    5939    5915
   q6   229     127     126     126
   q7   2399    1909    1922    1909
   q8   3543    3638    3652    3638
   q9   9029    8920    8956    8920
   q10  3858    3892    3874    3874
   q11  579     497     464     464
   q12  824     653     659     653
   q13  3902    3171    3200    3171
   q14  310     272     267     267
   q15  619     550     551     550
   q16  545     508     521     508
   q17  2004    1818    1807    1807
   q18  8677    8385    8413    8385
   q19  1741    1630    1688    1630
   q20  2278    1992    1980    1980
   q21  5831    5372    5296    5296
   q22  585     481     476     476
   Total cold run time: 63804 ms
   Total hot run time: 60198 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