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

   
   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 daa8f7e189660a5d04ff1b5117487720a652b202, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5457    5136    5130    5130
   q2   386     169     167     167
   q3   1471    1226    1219    1219
   q4   1087    845     805     805
   q5   3288    3106    3127    3106
   q6   224     141     143     141
   q7   988     563     530     530
   q8   2159    2264    2203    2203
   q9   6720    6639    6699    6639
   q10  3201    3161    3143    3143
   q11  359     236     230     230
   q12  391     247     243     243
   q13  4403    3646    3614    3614
   q14  258     221     225     221
   q15  596     542     535     535
   q16  459     403     403     403
   q17  1062    534     573     534
   q18  7091    6790    6808    6790
   q19  1648    1543    1608    1543
   q20  627     351     336     336
   q21  2856    2490    2533    2490
   q22  404     335     342     335
   Total cold run time: 45135 ms
   Total hot run time: 40357 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5115    5074    5126    5074
   q2   339     250     250     250
   q3   3364    3332    3324    3324
   q4   2147    2082    2067    2067
   q5   5946    5901    5925    5901
   q6   232     133     140     133
   q7   2379    1965    1929    1929
   q8   3551    3633    3681    3633
   q9   9053    8977    9037    8977
   q10  3909    3943    3929    3929
   q11  579     464     477     464
   q12  821     655     650     650
   q13  3878    3168    3195    3168
   q14  308     281     272     272
   q15  600     537     537     537
   q16  555     503     526     503
   q17  2028    1819    1824    1819
   q18  8775    8354    8352    8352
   q19  1760    1722    1719    1719
   q20  2294    1978    1976    1976
   q21  5652    5336    5379    5336
   q22  538     475     465     465
   Total cold run time: 63823 ms
   Total hot run time: 60478 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