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

   
   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 b3a17a14e2d1e66f1b07f1311be7d34b1ebf8fa0, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5492    5149    5078    5078
   q2   386     168     156     156
   q3   1457    1172    1146    1146
   q4   1067    799     826     799
   q5   3117    3104    3148    3104
   q6   224     135     136     135
   q7   963     542     514     514
   q8   2154    2208    2286    2208
   q9   6691    6660    6652    6652
   q10  3162    3118    3133    3118
   q11  341     233     234     233
   q12  374     231     228     228
   q13  4421    3659    3657    3657
   q14  255     216     210     210
   q15  582     536     532     532
   q16  452     404     397     397
   q17  1041    484     515     484
   q18  7111    6748    6901    6748
   q19  1637    1482    1406    1406
   q20  617     344     385     344
   q21  2820    2551    2493    2493
   q22  402     348     330     330
   Total cold run time: 44766 ms
   Total hot run time: 39972 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5061    5064    4981    4981
   q2   338     238     228     228
   q3   3403    3354    3333    3333
   q4   2170    2023    2002    2002
   q5   5956    5956    5911    5911
   q6   224     126     131     126
   q7   2408    1934    1913    1913
   q8   3559    3692    3670    3670
   q9   8998    9011    8952    8952
   q10  3865    3904    3909    3904
   q11  565     472     479     472
   q12  806     640     627     627
   q13  3908    3175    3190    3175
   q14  298     285     288     285
   q15  593     525     527     525
   q16  590     525     476     476
   q17  2049    1859    1792    1792
   q18  8731    8363    8326    8326
   q19  1748    1711    1707    1707
   q20  2239    1979    1976    1976
   q21  5660    5244    5321    5244
   q22  568     511     508     508
   Total cold run time: 63737 ms
   Total hot run time: 60133 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: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to