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

   
   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 dcb088ffeb3e2b6e52a0a144acb0c545dcb092db, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5496    5134    5168    5134
   q2   381     182     159     159
   q3   1452    1145    1119    1119
   q4   1094    881     788     788
   q5   3179    3110    3075    3075
   q6   222     134     133     133
   q7   956     557     531     531
   q8   2146    2265    2241    2241
   q9   6710    6647    6688    6647
   q10  3169    3113    3148    3113
   q11  337     231     215     215
   q12  382     238     238     238
   q13  4426    3643    3633    3633
   q14  252     214     211     211
   q15  593     534     542     534
   q16  452     391     403     391
   q17  1041    564     605     564
   q18  7077    6730    6784    6730
   q19  1636    1463    1355    1355
   q20  594     324     353     324
   q21  2867    2454    2512    2454
   q22  389     345     329     329
   Total cold run time: 44851 ms
   Total hot run time: 39918 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5075    5063    5017    5017
   q2   342     237     236     236
   q3   3367    3334    3319    3319
   q4   2173    2066    2027    2027
   q5   5937    5916    5923    5916
   q6   227     128     129     128
   q7   2419    1893    1922    1893
   q8   3552    3653    3681    3653
   q9   8984    9056    8981    8981
   q10  3880    3905    3923    3905
   q11  572     487     491     487
   q12  804     647     656     647
   q13  3873    3230    3216    3216
   q14  306     274     286     274
   q15  600     543     528     528
   q16  551     500     496     496
   q17  2027    1787    1810    1787
   q18  8807    8285    8329    8285
   q19  1741    1631    1667    1631
   q20  2250    1972    1966    1966
   q21  5840    5327    5469    5327
   q22  565     473     515     473
   Total cold run time: 63892 ms
   Total hot run time: 60192 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