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

   
   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 7e53af79dbaa1ca7c003d32b2fd1ce24f8791876, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5574    5168    5190    5168
   q2   394     189     160     160
   q3   1489    1224    1252    1224
   q4   1098    845     837     837
   q5   3141    3116    3056    3056
   q6   233     138     138     138
   q7   1006    572     526     526
   q8   2186    2287    2204    2204
   q9   6710    6698    6670    6670
   q10  3195    3163    3149    3149
   q11  348     231     217     217
   q12  393     256     249     249
   q13  4406    3692    3653    3653
   q14  268     226     217     217
   q15  644     580     564     564
   q16  464     435     405     405
   q17  1062    590     566     566
   q18  7110    6762    6814    6762
   q19  1655    1566    1520    1520
   q20  617     348     346     346
   q21  2861    2577    2518    2518
   q22  399     321     334     321
   Total cold run time: 45253 ms
   Total hot run time: 40470 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5075    5118    5118    5118
   q2   341     266     256     256
   q3   3392    3317    3327    3317
   q4   2154    2047    2041    2041
   q5   5932    5964    5982    5964
   q6   235     137     134     134
   q7   2401    1934    1961    1934
   q8   3553    3678    3699    3678
   q9   9114    9037    9055    9037
   q10  3890    3923    3948    3923
   q11  589     496     491     491
   q12  805     636     648     636
   q13  3890    3208    3160    3160
   q14  315     286     277     277
   q15  623     576     563     563
   q16  581     545     516     516
   q17  2020    1873    1849    1849
   q18  8793    8416    8644    8416
   q19  1774    1732    1769    1732
   q20  2283    2016    1979    1979
   q21  5747    5425    5336    5336
   q22  552     488     506     488
   Total cold run time: 64059 ms
   Total hot run time: 60845 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