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

   
   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 dc12cc7b40cc09d5e35e9c49e431d80af2624f44, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5512    5076    5118    5076
   q2   393     163     147     147
   q3   1461    1168    1162    1162
   q4   1074    836     817     817
   q5   3107    3104    3062    3062
   q6   223     135     132     132
   q7   972     528     535     528
   q8   2145    2171    2255    2171
   q9   6698    6673    6647    6647
   q10  3162    3157    3078    3078
   q11  349     221     207     207
   q12  376     238     236     236
   q13  4383    3647    3623    3623
   q14  257     227     218     218
   q15  577     532     529     529
   q16  446     427     384     384
   q17  1031    530     473     473
   q18  7087    6720    6718    6718
   q19  1630    1570    1523    1523
   q20  597     342     337     337
   q21  2876    2445    2495    2445
   q22  395     317     332     317
   Total cold run time: 44751 ms
   Total hot run time: 39830 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5105    5075    5055    5055
   q2   334     231     236     231
   q3   3358    3358    3305    3305
   q4   2146    2054    2033    2033
   q5   5950    5909    5912    5909
   q6   220     124     126     124
   q7   2396    1905    1895    1895
   q8   3562    3652    3654    3652
   q9   8974    8987    8950    8950
   q10  3852    3897    3901    3897
   q11  586     484     471     471
   q12  794     655     627     627
   q13  3866    3238    3161    3161
   q14  289     283     264     264
   q15  582     516     524     516
   q16  583     529     493     493
   q17  2028    1835    1826    1826
   q18  8662    8399    8408    8399
   q19  1744    1652    1684    1652
   q20  2264    1986    1965    1965
   q21  5848    5271    5327    5271
   q22  559     504     508     504
   Total cold run time: 63702 ms
   Total hot run time: 60200 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