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

   
   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 c6e72adb82e96b8ccf516c4fc5aedd00e2088810, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5505    5073    5177    5073
   q2   382     200     159     159
   q3   1444    1184    1225    1184
   q4   1071    830     830     830
   q5   3082    3141    3136    3136
   q6   217     131     136     131
   q7   978     547     519     519
   q8   2144    2263    2219    2219
   q9   6718    6622    6651    6622
   q10  3152    3143    3098    3098
   q11  345     216     208     208
   q12  381     223     238     223
   q13  4375    3638    3635    3635
   q14  242     221     224     221
   q15  578     550     524     524
   q16  453     395     391     391
   q17  1036    569     478     478
   q18  7078    6722    6853    6722
   q19  1643    1543    1593    1543
   q20  587     319     321     319
   q21  2926    2409    2490    2409
   q22  402     311     319     311
   Total cold run time: 44739 ms
   Total hot run time: 39955 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5132    5120    5066    5066
   q2   338     238     235     235
   q3   3350    3306    3309    3306
   q4   2129    2031    2012    2012
   q5   5918    5893    5937    5893
   q6   224     127     129     127
   q7   2395    1926    1909    1909
   q8   3526    3657    3699    3657
   q9   8984    8958    8941    8941
   q10  3859    3900    3914    3900
   q11  570     481     495     481
   q12  807     634     627     627
   q13  3860    3168    3155    3155
   q14  311     324     287     287
   q15  580     522     529     522
   q16  562     519     505     505
   q17  2041    1809    1804    1804
   q18  8693    8311    8415    8311
   q19  1742    1682    1649    1649
   q20  2272    1971    1967    1967
   q21  5755    5327    5275    5275
   q22  561     536     515     515
   Total cold run time: 63609 ms
   Total hot run time: 60144 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