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

   
   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 7340b9de2cb045150968f10ba6cbe1362961c433, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5479    5130    5176    5130
   q2   383     157     155     155
   q3   1465    1192    1159    1159
   q4   1089    757     771     757
   q5   3130    3051    3087    3051
   q6   220     132     135     132
   q7   972     540     524     524
   q8   2172    2237    2243    2237
   q9   6745    6684    6669    6669
   q10  3201    3124    3125    3124
   q11  344     217     206     206
   q12  371     228     234     228
   q13  4427    3661    3602    3602
   q14  257     211     212     211
   q15  576     535     521     521
   q16  453     385     411     385
   q17  1039    589     541     541
   q18  7115    6778    6818    6778
   q19  1631    1519    1512    1512
   q20  605     318     343     318
   q21  2848    2440    2496    2440
   q22  407     332     335     332
   Total cold run time: 44929 ms
   Total hot run time: 40012 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5095    5061    4992    4992
   q2   332     231     250     231
   q3   3382    3354    3328    3328
   q4   2151    2031    2030    2030
   q5   5932    5926    5924    5924
   q6   224     126     128     126
   q7   2398    1949    1926    1926
   q8   3570    3635    3677    3635
   q9   9074    9005    8962    8962
   q10  3865    3879    3898    3879
   q11  576     469     479     469
   q12  814     634     638     634
   q13  3861    3204    3194    3194
   q14  306     265     275     265
   q15  585     530     541     530
   q16  530     490     513     490
   q17  2008    1819    1825    1819
   q18  8750    8341    8409    8341
   q19  1741    1704    1657    1657
   q20  2264    1963    1952    1952
   q21  5630    5306    5241    5241
   q22  557     498     514     498
   Total cold run time: 63645 ms
   Total hot run time: 60123 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