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

   
   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 0709b4df9b26ec1bd7a24db38c78678165aa2c9d, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5473    5143    5120    5120
   q2   394     161     156     156
   q3   1468    1160    1197    1160
   q4   1103    823     790     790
   q5   3155    3037    3088    3037
   q6   229     142     131     131
   q7   998     556     512     512
   q8   2148    2248    2256    2248
   q9   6721    6665    6675    6665
   q10  3205    3112    3060    3060
   q11  335     227     207     207
   q12  383     231     228     228
   q13  4382    3663    3627    3627
   q14  253     217     216     216
   q15  604     551     544     544
   q16  449     408     393     393
   q17  1051    559     498     498
   q18  7125    6691    6790    6691
   q19  1651    1528    1600    1528
   q20  766     318     347     318
   q21  2939    2440    2445    2440
   q22  406     331     319     319
   Total cold run time: 45238 ms
   Total hot run time: 39888 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5153    5031    5106    5031
   q2   338     266     250     250
   q3   3364    3299    3291    3291
   q4   2160    2044    2049    2044
   q5   5987    5901    5946    5901
   q6   225     127     128     127
   q7   2381    1909    1925    1909
   q8   3562    3695    3690    3690
   q9   9020    8943    9038    8943
   q10  3871    3913    3941    3913
   q11  593     475     492     475
   q12  805     619     630     619
   q13  3868    3190    3200    3190
   q14  297     274     277     274
   q15  611     536     532     532
   q16  576     513     515     513
   q17  2039    1850    1820    1820
   q18  8724    8304    8343    8304
   q19  1743    1690    1701    1690
   q20  2279    1994    1992    1992
   q21  5712    5383    5374    5374
   q22  603     515     491     491
   Total cold run time: 63911 ms
   Total hot run time: 60373 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