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

   
   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 5f7bca48fd193a3287f239e12329f329fbc12c3c, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5504    5130    5134    5130
   q2   387     167     178     167
   q3   1459    1108    1120    1108
   q4   1083    819     815     815
   q5   3170    2986    3091    2986
   q6   223     141     142     141
   q7   987     556     567     556
   q8   2147    2290    2288    2288
   q9   6724    6662    6677    6662
   q10  3167    3218    3140    3140
   q11  351     231     231     231
   q12  387     248     244     244
   q13  4413    3680    3695    3680
   q14  259     220     215     215
   q15  597     534     536     534
   q16  455     397     408     397
   q17  1052    530     534     530
   q18  7095    6803    6733    6733
   q19  1646    1603    1582    1582
   q20  604     361     335     335
   q21  2893    2547    2432    2432
   q22  408     342     332     332
   Total cold run time: 45011 ms
   Total hot run time: 40238 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5124    5096    5045    5045
   q2   336     237     229     229
   q3   3393    3337    3318    3318
   q4   2170    2100    2077    2077
   q5   5967    5924    5909    5909
   q6   230     136     134     134
   q7   2396    1938    1926    1926
   q8   3565    3666    3678    3666
   q9   9050    8952    8948    8948
   q10  3884    3925    3935    3925
   q11  585     480     478     478
   q12  810     650     639     639
   q13  3878    3227    3223    3223
   q14  303     288     291     288
   q15  595     537     540     537
   q16  539     506     506     506
   q17  1987    1785    1818    1785
   q18  8727    8378    8346    8346
   q19  1761    1732    1717    1717
   q20  2276    1978    1991    1978
   q21  5788    5399    5434    5399
   q22  555     510     511     510
   Total cold run time: 63919 ms
   Total hot run time: 60583 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