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

   
   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 b432960ec1d34cad19f75a979bd94025cde3001f, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5531    5138    5159    5138
   q2   389     160     152     152
   q3   1461    1207    1139    1139
   q4   1103    797     772     772
   q5   3083    3142    3003    3003
   q6   234     146     143     143
   q7   977     542     547     542
   q8   2175    2270    2249    2249
   q9   6703    6657    6683    6657
   q10  3210    3130    3205    3130
   q11  362     228     218     218
   q12  389     241     243     241
   q13  4409    3628    3605    3605
   q14  250     228     211     211
   q15  574     546     534     534
   q16  449     401     397     397
   q17  1042    499     563     499
   q18  7119    6806    6786    6786
   q19  1655    1449    1570    1449
   q20  590     333     424     333
   q21  2905    2573    2465    2465
   q22  406     329     325     325
   Total cold run time: 45016 ms
   Total hot run time: 39988 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5121    5070    5166    5070
   q2   337     240     243     240
   q3   3355    3351    3336    3336
   q4   2169    2090    2063    2063
   q5   5964    5930    5966    5930
   q6   228     132     131     131
   q7   2378    1914    1890    1890
   q8   3569    3665    3684    3665
   q9   9095    9020    9023    9020
   q10  3871    3950    3888    3888
   q11  565     477     477     477
   q12  809     636     626     626
   q13  3861    3182    3193    3182
   q14  291     271     267     267
   q15  596     524     520     520
   q16  583     493     511     493
   q17  2050    1806    1794    1794
   q18  8790    8387    8369    8369
   q19  1762    1678    1703    1678
   q20  2251    2001    1971    1971
   q21  5756    5270    5364    5270
   q22  556     487     497     487
   Total cold run time: 63957 ms
   Total hot run time: 60367 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