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

   
   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 299bd705278a38c585698fe9d4addd550c51b156, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5460    5196    5206    5196
   q2   396     191     158     158
   q3   1455    1198    1132    1132
   q4   1090    886     825     825
   q5   3156    3077    3080    3077
   q6   230     142     130     130
   q7   972     556     521     521
   q8   2157    2134    2295    2134
   q9   6721    6648    6658    6648
   q10  3184    3154    3102    3102
   q11  335     211     211     211
   q12  386     236     246     236
   q13  4379    3649    3634    3634
   q14  256     213     215     213
   q15  603     550     545     545
   q16  460     402     399     399
   q17  1047    520     521     520
   q18  7067    6798    6780    6780
   q19  1638    1539    1518    1518
   q20  580     328     325     325
   q21  2848    2506    2477    2477
   q22  391     317     312     312
   Total cold run time: 44811 ms
   Total hot run time: 40093 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5121    5106    5053    5053
   q2   343     251     261     251
   q3   3369    3311    3303    3303
   q4   2126    1985    2029    1985
   q5   5929    5915    5908    5908
   q6   227     127     123     123
   q7   2389    1917    1917    1917
   q8   3562    3648    3654    3648
   q9   8992    8998    9029    8998
   q10  3870    3917    3914    3914
   q11  601     490     465     465
   q12  795     650     633     633
   q13  3877    3231    3167    3167
   q14  296     260     261     260
   q15  622     534     541     534
   q16  581     546     517     517
   q17  2006    1799    1785    1785
   q18  8737    8369    8343    8343
   q19  1746    1680    1681    1680
   q20  2289    2014    1979    1979
   q21  5678    5353    5463    5353
   q22  582     484     502     484
   Total cold run time: 63738 ms
   Total hot run time: 60300 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