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

   
   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 0733ab43533bcf5c7fdc61a339519ebb7c1d4df2, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5489    5130    5106    5106
   q2   388     167     159     159
   q3   1434    1174    1226    1174
   q4   1078    845     819     819
   q5   3124    3102    3108    3102
   q6   223     133     130     130
   q7   959     542     548     542
   q8   2149    2204    2222    2204
   q9   6721    6650    6624    6624
   q10  3176    3155    3069    3069
   q11  355     225     210     210
   q12  386     241     234     234
   q13  4409    3670    3642    3642
   q14  254     225     224     224
   q15  606     563     551     551
   q16  473     398     425     398
   q17  1044    585     522     522
   q18  7056    6782    6837    6782
   q19  1639    1558    1559    1558
   q20  622     350     331     331
   q21  2894    2464    2506    2464
   q22  399     314     332     314
   Total cold run time: 44878 ms
   Total hot run time: 40159 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5104    5099    5043    5043
   q2   340     251     241     241
   q3   3382    3298    3310    3298
   q4   2161    2029    2034    2029
   q5   5959    5907    5918    5907
   q6   227     124     121     121
   q7   2390    1912    1937    1912
   q8   3581    3625    3657    3625
   q9   9054    9003    9035    9003
   q10  3862    3915    3916    3915
   q11  596     490     503     490
   q12  809     668     649     649
   q13  3870    3209    3190    3190
   q14  296     289     280     280
   q15  617     550     553     550
   q16  560     501     543     501
   q17  2062    1817    1775    1775
   q18  8783    8363    8340    8340
   q19  1735    1669    1660    1660
   q20  2277    1985    1988    1985
   q21  5774    5455    5387    5387
   q22  552     506     504     504
   Total cold run time: 63991 ms
   Total hot run time: 60405 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