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

   
   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 9c8087c850b1b63a466fa509c24ea8c326c5d38b, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5478    5210    5206    5206
   q2   390     165     159     159
   q3   1480    1243    1241    1241
   q4   1100    938     794     794
   q5   3105    3143    3184    3143
   q6   225     137     136     136
   q7   990     550     507     507
   q8   2184    2229    2267    2229
   q9   6742    6719    6723    6719
   q10  3178    3153    3151    3151
   q11  364     213     211     211
   q12  393     232     239     232
   q13  4438    3670    3688    3670
   q14  255     222     213     213
   q15  582     533     525     525
   q16  466     419     431     419
   q17  1053    545     567     545
   q18  7085    6785    6785    6785
   q19  1672    1539    1622    1539
   q20  566     315     314     314
   q21  2870    2505    2549    2505
   q22  411     340     335     335
   Total cold run time: 45027 ms
   Total hot run time: 40578 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5177    5117    5101    5101
   q2   344     237     235     235
   q3   3380    3367    3321    3321
   q4   2191    2093    2091    2091
   q5   5986    5932    5941    5932
   q6   229     128     131     128
   q7   2366    1915    1937    1915
   q8   3587    3716    3698    3698
   q9   9091    9017    9027    9017
   q10  3890    3910    3921    3910
   q11  584     483     484     483
   q12  806     635     647     635
   q13  3887    3220    3191    3191
   q14  290     283     268     268
   q15  599     544     521     521
   q16  563     521     500     500
   q17  2105    1812    1823    1812
   q18  8778    8393    8401    8393
   q19  1776    1707    1716    1707
   q20  2297    2006    1980    1980
   q21  5777    5384    5308    5308
   q22  561     493     505     493
   Total cold run time: 64264 ms
   Total hot run time: 60639 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