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

   
   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 deb93c1f411ab333d4cfef0b0a10bdd405fc232d, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5444    5155    5126    5126
   q2   386     158     165     158
   q3   1463    1157    1141    1141
   q4   1101    882     830     830
   q5   3180    3066    3120    3066
   q6   222     137     135     135
   q7   985     565     527     527
   q8   2153    2207    2221    2207
   q9   6694    6658    6619    6619
   q10  3155    3135    3149    3135
   q11  352     230     213     213
   q12  384     235     238     235
   q13  4389    3681    3668    3668
   q14  248     226     215     215
   q15  592     531     538     531
   q16  452     418     415     415
   q17  1050    536     554     536
   q18  7101    6774    6805    6774
   q19  1656    1529    1444    1444
   q20  586     341     315     315
   q21  2946    2550    2530    2530
   q22  383     314     339     314
   Total cold run time: 44922 ms
   Total hot run time: 40134 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5206    5146    5095    5095
   q2   337     233     241     233
   q3   3375    3351    3340    3340
   q4   2183    2096    2093    2093
   q5   5940    5924    5968    5924
   q6   223     125     128     125
   q7   2353    1955    1953    1953
   q8   3584    3658    3667    3658
   q9   9035    9048    8999    8999
   q10  3855    3899    3920    3899
   q11  591     504     485     485
   q12  796     628     645     628
   q13  3920    3228    3215    3215
   q14  296     280     272     272
   q15  588     547     530     530
   q16  546     492     516     492
   q17  2052    1831    1844    1831
   q18  8779    8355    8250    8250
   q19  1749    1705    1701    1701
   q20  2300    2008    1968    1968
   q21  5826    5335    5375    5335
   q22  604     493     485     485
   Total cold run time: 64138 ms
   Total hot run time: 60511 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