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

   
   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 99cef0af133030559dfc4b61e3bc6081dbfe2a4e, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5498    5150    5127    5127
   q2   391     175     158     158
   q3   1448    1177    1137    1137
   q4   1083    836     804     804
   q5   3136    3126    3118    3118
   q6   233     131     128     128
   q7   990     542     519     519
   q8   2142    2179    2215    2179
   q9   6685    6654    6653    6653
   q10  3178    3079    3115    3079
   q11  330     221     212     212
   q12  385     236     229     229
   q13  4421    3660    3608    3608
   q14  261     212     207     207
   q15  603     533     548     533
   q16  445     399     416     399
   q17  1046    526     536     526
   q18  7089    6720    6740    6720
   q19  1636    1504    1551    1504
   q20  551     323     318     318
   q21  2918    2476    2401    2401
   q22  396     324     328     324
   Total cold run time: 44865 ms
   Total hot run time: 39883 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5125    5053    5036    5036
   q2   342     236     251     236
   q3   3362    3287    3237    3237
   q4   2161    2005    2024    2005
   q5   5943    5920    5881    5881
   q6   226     124     124     124
   q7   2392    1881    1908    1881
   q8   3571    3656    3667    3656
   q9   9043    8992    8930    8930
   q10  3847    3899    3931    3899
   q11  588     492     472     472
   q12  786     616     651     616
   q13  3897    3180    3159    3159
   q14  300     267     265     265
   q15  618     544     535     535
   q16  571     532     537     532
   q17  2031    1792    1799    1792
   q18  8795    8361    8316    8316
   q19  1746    1680    1698    1680
   q20  2281    1969    1978    1969
   q21  5727    5389    5259    5259
   q22  582     472     502     472
   Total cold run time: 63934 ms
   Total hot run time: 59952 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