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

   
   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 758ba6ccc9919f27eba204d4e3b79aa5d16c8de9, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5427    5143    5128    5128
   q2   388     196     159     159
   q3   1450    1198    1200    1198
   q4   1102    882     822     822
   q5   3108    3148    3064    3064
   q6   222     131     129     129
   q7   963     537     531     531
   q8   2147    2293    2245    2245
   q9   6713    6702    6658    6658
   q10  3165    3187    3091    3091
   q11  340     223     233     223
   q12  381     231     237     231
   q13  4396    3655    3628    3628
   q14  253     216     216     216
   q15  597     556     537     537
   q16  454     393     435     393
   q17  1048    537     515     515
   q18  7063    6715    7019    6715
   q19  1641    1571    1597    1571
   q20  589     368     344     344
   q21  2893    2500    2449    2449
   q22  411     320     343     320
   Total cold run time: 44751 ms
   Total hot run time: 40167 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5106    5134    5095    5095
   q2   335     241     267     241
   q3   3344    3338    3287    3287
   q4   2148    2013    1990    1990
   q5   5954    5924    5929    5924
   q6   231     125     124     124
   q7   2397    1907    1955    1907
   q8   3573    3686    3666    3666
   q9   9061    9030    8934    8934
   q10  3875    3934    3927    3927
   q11  587     503     472     472
   q12  799     657     654     654
   q13  3889    3195    3186    3186
   q14  303     263     259     259
   q15  610     546     535     535
   q16  565     511     517     511
   q17  2038    1773    1783    1773
   q18  8795    8426    8390    8390
   q19  1736    1669    1669    1669
   q20  2285    2006    1966    1966
   q21  5821    5369    5269    5269
   q22  571     504     512     504
   Total cold run time: 64023 ms
   Total hot run time: 60283 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