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

   
   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 1193c42854cc6a5a158f95455b0327d436e44be2, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5469    5116    5125    5116
   q2   387     168     149     149
   q3   1437    1128    1199    1128
   q4   1087    833     778     778
   q5   3124    3156    3013    3013
   q6   223     132     132     132
   q7   993     534     527     527
   q8   2156    2255    2291    2255
   q9   6694    6678    6666    6666
   q10  3186    3112    3154    3112
   q11  343     216     203     203
   q12  375     231     223     223
   q13  4372    3616    3632    3616
   q14  250     215     217     215
   q15  581     537     531     531
   q16  447     398     408     398
   q17  1046    554     543     543
   q18  7084    6765    6783    6765
   q19  1649    1460    1408    1408
   q20  604     397     318     318
   q21  2896    2511    2504    2504
   q22  398     330     311     311
   Total cold run time: 44801 ms
   Total hot run time: 39911 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5152    5043    4999    4999
   q2   338     233     235     233
   q3   3354    3340    3306    3306
   q4   2152    2028    2076    2028
   q5   5951    5914    5926    5914
   q6   227     124     128     124
   q7   2387    1953    1951    1951
   q8   3543    3648    3682    3648
   q9   9045    9003    9039    9003
   q10  3866    3905    3908    3905
   q11  579     470     485     470
   q12  809     663     637     637
   q13  3863    3172    3180    3172
   q14  298     260     271     260
   q15  588     532     520     520
   q16  540     503     493     493
   q17  2040    1831    1797    1797
   q18  8802    8332    8420    8332
   q19  1740    1652    1701    1652
   q20  2271    1998    1956    1956
   q21  5739    5361    5386    5361
   q22  569     510     514     510
   Total cold run time: 63853 ms
   Total hot run time: 60271 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