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

   
   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 1e38fef227a5186bb4dbb63fe11b97b5e27ab93b, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5429    5114    5203    5114
   q2   394     161     166     161
   q3   1461    1140    1067    1067
   q4   1073    837     800     800
   q5   3102    3163    3152    3152
   q6   224     136     134     134
   q7   983     555     510     510
   q8   2137    2281    2241    2241
   q9   6704    6709    6643    6643
   q10  3175    3106    3141    3106
   q11  348     226     214     214
   q12  383     233     237     233
   q13  4439    3654    3635    3635
   q14  249     212     221     212
   q15  571     541     533     533
   q16  463     409     416     409
   q17  1055    554     564     554
   q18  7099    6727    6775    6727
   q19  1642    1501    1437    1437
   q20  591     352     340     340
   q21  2926    2479    2477    2477
   q22  399     332     330     330
   Total cold run time: 44847 ms
   Total hot run time: 40029 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5112    5008    5051    5008
   q2   344     248     243     243
   q3   3388    3362    3317    3317
   q4   2152    2087    2056    2056
   q5   5974    5932    5938    5932
   q6   225     126     130     126
   q7   2401    1929    1905    1905
   q8   3579    3644    3687    3644
   q9   9046    8972    8966    8966
   q10  3895    3902    3910    3902
   q11  582     471     484     471
   q12  791     650     654     650
   q13  3878    3189    3177    3177
   q14  303     271     277     271
   q15  583     523     525     523
   q16  552     513     483     483
   q17  2019    1835    1798    1798
   q18  8741    8315    8296    8296
   q19  1739    1680    1686    1680
   q20  2258    1961    1955    1955
   q21  5792    5361    5284    5284
   q22  576     515     509     509
   Total cold run time: 63930 ms
   Total hot run time: 60196 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