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

   
   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 f68c3d081ff7df41a37f9ee9f3f23324937fb87e, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5551    5126    5059    5059
   q2   381     174     159     159
   q3   1465    1178    1210    1178
   q4   1083    788     748     748
   q5   3145    3028    3089    3028
   q6   218     133     133     133
   q7   963     555     540     540
   q8   2148    2285    2283    2283
   q9   6708    6668    6674    6668
   q10  3167    3136    3175    3136
   q11  343     221     215     215
   q12  377     207     216     207
   q13  4355    3644    3646    3644
   q14  254     221     219     219
   q15  574     532     536     532
   q16  456     405     415     405
   q17  1041    583     570     570
   q18  7123    6813    6893    6813
   q19  1638    1504    1465    1465
   q20  591     348     452     348
   q21  2910    2471    2483    2471
   q22  394     326     338     326
   Total cold run time: 44885 ms
   Total hot run time: 40147 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5089    5069    5020    5020
   q2   343     235     252     235
   q3   3366    3340    3309    3309
   q4   2153    2049    2046    2046
   q5   5955    5913    5952    5913
   q6   227     125     125     125
   q7   2402    1925    1957    1925
   q8   3575    3657    3689    3657
   q9   9018    8987    8971    8971
   q10  3866    3882    3898    3882
   q11  595     483     468     468
   q12  805     637     626     626
   q13  3890    3201    3179    3179
   q14  285     278     269     269
   q15  588     527     537     527
   q16  551     506     508     506
   q17  2013    1825    1851    1825
   q18  8766    8283    8368    8283
   q19  1731    1693    1718    1693
   q20  2253    1981    1963    1963
   q21  5668    5318    5268    5268
   q22  578     509     505     505
   Total cold run time: 63717 ms
   Total hot run time: 60195 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