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

   
   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 2baa5b2ca54631faa3b40e06a7496c4cfa9f7152, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5501    5206    5179    5179
   q2   394     161     157     157
   q3   1460    1200    1138    1138
   q4   1105    857     819     819
   q5   3092    3109    3172    3109
   q6   226     136     138     136
   q7   978     561     536     536
   q8   2141    2280    2288    2280
   q9   6706    6676    6736    6676
   q10  3215    3099    3131    3099
   q11  339     230     218     218
   q12  383     239     241     239
   q13  4402    3674    3632    3632
   q14  245     221     222     221
   q15  587     548     547     547
   q16  450     408     406     406
   q17  1045    481     526     481
   q18  7126    6731    6754    6731
   q19  1646    1508    1426    1426
   q20  607     339     336     336
   q21  2893    2549    2416    2416
   q22  403     339     330     330
   Total cold run time: 44944 ms
   Total hot run time: 40112 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5129    5119    5044    5044
   q2   337     241     260     241
   q3   3385    3336    3375    3336
   q4   2141    2044    2036    2036
   q5   5917    5935    5930    5930
   q6   227     125     127     125
   q7   2403    1917    1947    1917
   q8   3583    3655    3673    3655
   q9   9047    9015    8989    8989
   q10  3880    3907    3916    3907
   q11  587     472     504     472
   q12  820     668     652     652
   q13  3877    3241    3218    3218
   q14  297     272     263     263
   q15  633     549     566     549
   q16  559     517     509     509
   q17  2038    1811    1872    1811
   q18  8730    8330    8350    8330
   q19  1757    1708    1687    1687
   q20  2296    1988    2007    1988
   q21  5739    5326    5330    5326
   q22  578     494     470     470
   Total cold run time: 63960 ms
   Total hot run time: 60455 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