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

   
   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 b809485d2002ed2bd5b04dd53080eafd389df313, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   6033    5263    5240    5240
   q2   400     167     157     157
   q3   1471    1185    1161    1161
   q4   1102    863     821     821
   q5   3150    3126    2913    2913
   q6   233     149     132     132
   q7   1022    586     508     508
   q8   2159    2215    2256    2215
   q9   6723    6711    6703    6703
   q10  3182    3143    3143    3143
   q11  352     217     231     217
   q12  384     243     241     241
   q13  4455    3673    3656    3656
   q14  246     216     218     216
   q15  625     561     566     561
   q16  455     410     418     410
   q17  1055    489     530     489
   q18  7381    6953    7711    6953
   q19  1634    1496    1431    1431
   q20  573     354     330     330
   q21  2862    2517    2503    2503
   q22  399     326     335     326
   Total cold run time: 45896 ms
   Total hot run time: 40326 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5221    5091    5043    5043
   q2   339     260     252     252
   q3   3388    3334    3305    3305
   q4   2163    2020    2004    2004
   q5   5996    5961    5937    5937
   q6   231     125     127     125
   q7   2401    1896    1955    1896
   q8   3590    3663    3650    3650
   q9   9116    9112    9055    9055
   q10  3942    3975    3973    3973
   q11  593     482     509     482
   q12  799     660     642     642
   q13  3886    3193    3219    3193
   q14  296     286     276     276
   q15  617     539     545     539
   q16  563     545     518     518
   q17  2081    1818    1860    1818
   q18  9081    8513    8675    8513
   q19  1747    1676    1693    1676
   q20  2324    2007    1989    1989
   q21  5745    5392    5361    5361
   q22  580     492     514     492
   Total cold run time: 64699 ms
   Total hot run time: 60739 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