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

   
   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 13e19270ecd5a03de5ade6a41049b1be1eb966f2, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5505    5135    5112    5112
   q2   392     162     157     157
   q3   1458    1217    1159    1159
   q4   1089    775     823     775
   q5   3178    3101    3132    3101
   q6   223     137     142     137
   q7   985     534     521     521
   q8   2154    2227    2228    2227
   q9   6679    6659    6649    6649
   q10  3177    3180    3127    3127
   q11  337     217     202     202
   q12  381     239     237     237
   q13  4417    3606    3632    3606
   q14  247     205     212     205
   q15  596     542     534     534
   q16  438     433     444     433
   q17  1051    555     502     502
   q18  7074    6901    6855    6855
   q19  1651    1536    1452    1452
   q20  607     491     331     331
   q21  2897    2507    2505    2505
   q22  405     324     349     324
   Total cold run time: 44941 ms
   Total hot run time: 40151 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5101    5102    5062    5062
   q2   352     240     231     231
   q3   3390    3338    3298    3298
   q4   2125    2062    2029    2029
   q5   5947    5937    5936    5936
   q6   233     128     130     128
   q7   2371    1917    1934    1917
   q8   3576    3652    3663    3652
   q9   9024    9063    8976    8976
   q10  3890    3895    3933    3895
   q11  588     481     486     481
   q12  800     692     696     692
   q13  3889    3203    3195    3195
   q14  293     278     272     272
   q15  610     545     534     534
   q16  564     528     489     489
   q17  2024    1796    1799    1796
   q18  8737    8413    8336    8336
   q19  1742    1659    1697    1659
   q20  2275    1994    1979    1979
   q21  5772    5330    5364    5330
   q22  580     478     493     478
   Total cold run time: 63883 ms
   Total hot run time: 60365 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to