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

   
   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 46760bc22ca7879dd549bc48a401d8687ab1a83c, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5462    5131    5078    5078
   q2   386     169     157     157
   q3   1458    1162    1181    1162
   q4   1088    822     776     776
   q5   3112    3119    3099    3099
   q6   236     131     128     128
   q7   963     545     528     528
   q8   2154    2233    2283    2233
   q9   6691    6660    6645    6645
   q10  3137    3095    3110    3095
   q11  356     227     213     213
   q12  379     232     235     232
   q13  4392    3684    3645    3645
   q14  246     230     212     212
   q15  606     556     550     550
   q16  459     396     403     396
   q17  1039    601     562     562
   q18  7066    6825    6812    6812
   q19  1636    1519    1548    1519
   q20  602     333     333     333
   q21  2892    2491    2497    2491
   q22  398     319     331     319
   Total cold run time: 44758 ms
   Total hot run time: 40185 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5155    5001    5043    5001
   q2   335     233     248     233
   q3   3407    3322    3336    3322
   q4   2118    1989    1995    1989
   q5   5958    5933    5955    5933
   q6   226     124     129     124
   q7   2394    1921    1921    1921
   q8   3576    3657    3687    3657
   q9   9090    8965    8998    8965
   q10  3883    3913    3910    3910
   q11  593     488     482     482
   q12  812     628     643     628
   q13  3864    3225    3173    3173
   q14  299     276     276     276
   q15  616     541     545     541
   q16  556     531     542     531
   q17  2034    1838    1818    1818
   q18  8790    8365    8389    8365
   q19  1744    1649    1671    1649
   q20  2277    1981    1990    1981
   q21  5742    5317    5354    5317
   q22  572     511     485     485
   Total cold run time: 64041 ms
   Total hot run time: 60301 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