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

   
   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 42c3c22d09402b0fc103c1bc9eb0bc7f614343fb, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5480    5135    5123    5123
   q2   393     162     159     159
   q3   1463    1232    1195    1195
   q4   1087    752     775     752
   q5   3126    3111    3107    3107
   q6   221     131     132     131
   q7   968     555     514     514
   q8   2176    2305    2256    2256
   q9   6715    6715    6654    6654
   q10  3191    3175    3129    3129
   q11  336     230     217     217
   q12  385     234     234     234
   q13  4401    3644    3617    3617
   q14  243     213     207     207
   q15  570     539     533     533
   q16  463     387     411     387
   q17  1050    514     648     514
   q18  7141    6804    6749    6749
   q19  1661    1490    1423    1423
   q20  603     347     319     319
   q21  2855    2490    2430    2430
   q22  383     336     334     334
   Total cold run time: 44911 ms
   Total hot run time: 39984 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5089    5132    5072    5072
   q2   337     229     229     229
   q3   3346    3323    3315    3315
   q4   2159    2060    2047    2047
   q5   5934    5922    5921    5921
   q6   223     125     127     125
   q7   2392    1938    1930    1930
   q8   3564    3660    3686    3660
   q9   9046    9048    8996    8996
   q10  3854    3905    3930    3905
   q11  583     496     490     490
   q12  795     618     628     618
   q13  3882    3202    3203    3202
   q14  292     266     270     266
   q15  589     535     521     521
   q16  561     499     492     492
   q17  2034    1798    1824    1798
   q18  8715    8446    8310    8310
   q19  1767    1725    1699    1699
   q20  2275    2012    1957    1957
   q21  5834    5424    5369    5369
   q22  549     458     533     458
   Total cold run time: 63820 ms
   Total hot run time: 60380 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