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

   
   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 80200b991282dc1551a29a3252e756121a0784b3, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5474    5180    5187    5180
   q2   398     177     159     159
   q3   1475    1144    1164    1144
   q4   1107    820     845     820
   q5   3132    3147    3122    3122
   q6   235     139     136     136
   q7   997     575     520     520
   q8   2181    2233    2239    2233
   q9   6723    6710    6684    6684
   q10  3187    3122    3164    3122
   q11  339     229     214     214
   q12  394     248     243     243
   q13  4425    3668    3699    3668
   q14  244     225     228     225
   q15  611     549     546     546
   q16  471     419     406     406
   q17  1049    562     525     525
   q18  7103    6892    7451    6892
   q19  1663    1533    1513    1513
   q20  603     342     336     336
   q21  2878    2418    2458    2418
   q22  400     333     344     333
   Total cold run time: 45089 ms
   Total hot run time: 40439 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5160    5132    5091    5091
   q2   333     245     259     245
   q3   3378    3342    3319    3319
   q4   2148    2082    2034    2034
   q5   5950    5949    5927    5927
   q6   227     131     132     131
   q7   2390    1920    1932    1920
   q8   3575    3692    3726    3692
   q9   9103    9080    9010    9010
   q10  3899    3927    3928    3927
   q11  577     501     479     479
   q12  812     635     640     635
   q13  3950    3241    3220    3220
   q14  307     288     275     275
   q15  606     545     552     545
   q16  559     521     513     513
   q17  2034    1806    1818    1806
   q18  8735    8422    8651    8422
   q19  1739    1662    1683    1662
   q20  2276    2015    1989    1989
   q21  5752    5315    5398    5315
   q22  559     495     531     495
   Total cold run time: 64069 ms
   Total hot run time: 60652 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