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

   
   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 2edc59f1c174d2814e5addb954c49d7a03397683, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5491    5128    5157    5128
   q2   390     156     158     156
   q3   1459    1186    1199    1186
   q4   1096    870     793     793
   q5   3115    3086    3116    3086
   q6   225     137     132     132
   q7   996     551     518     518
   q8   2158    2216    2207    2207
   q9   6708    6634    6669    6634
   q10  3183    3176    3094    3094
   q11  325     218     214     214
   q12  384     229     243     229
   q13  4397    3600    3603    3600
   q14  243     225     212     212
   q15  600     556     557     556
   q16  452     410     391     391
   q17  1049    542     487     487
   q18  7109    6706    6769    6706
   q19  1659    1491    1605    1491
   q20  578     342     355     342
   q21  2838    2499    2445    2445
   q22  399     339     317     317
   Total cold run time: 44854 ms
   Total hot run time: 39924 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5199    5119    5094    5094
   q2   336     240     261     240
   q3   3351    3331    3353    3331
   q4   2145    2003    1996    1996
   q5   5943    5920    5950    5920
   q6   232     130     126     126
   q7   2358    1909    1868    1868
   q8   3582    3650    3630    3630
   q9   9052    9015    8980    8980
   q10  3878    3936    3939    3936
   q11  567     480     481     480
   q12  792     646     651     646
   q13  3918    3191    3185    3185
   q14  313     279     295     279
   q15  615     545     528     528
   q16  589     531     528     528
   q17  2008    1831    1810    1810
   q18  8800    8345    8376    8345
   q19  1754    1651    1680    1651
   q20  2285    2002    1981    1981
   q21  5673    5409    5337    5337
   q22  582     522     490     490
   Total cold run time: 63972 ms
   Total hot run time: 60381 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