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

   
   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 0db27f14983c77a7716b5d1596e272dfc8314ce2, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5493    5132    5217    5132
   q2   400     159     147     147
   q3   1466    1164    1142    1142
   q4   1092    779     779     779
   q5   3139    3106    3079    3079
   q6   232     144     129     129
   q7   974     583     528     528
   q8   2151    2219    2214    2214
   q9   6674    6666    6618    6618
   q10  3201    3141    3131    3131
   q11  339     229     214     214
   q12  387     228     244     228
   q13  4408    3657    3666    3657
   q14  257     214     215     214
   q15  603     549     535     535
   q16  470     442     423     423
   q17  1038    542     501     501
   q18  7054    6748    6923    6748
   q19  1635    1473    1502    1473
   q20  703     468     338     338
   q21  2877    2414    2509    2414
   q22  409     342     314     314
   Total cold run time: 45002 ms
   Total hot run time: 39958 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5106    5090    5059    5059
   q2   334     257     250     250
   q3   3354    3331    3275    3275
   q4   2136    2040    2035    2035
   q5   5960    5927    5940    5927
   q6   232     127     124     124
   q7   2385    1960    1937    1937
   q8   3570    3667    3676    3667
   q9   9063    9015    9051    9015
   q10  3885    3884    3916    3884
   q11  587     487     509     487
   q12  786     620     636     620
   q13  3899    3222    3173    3173
   q14  291     262     262     262
   q15  606     558     548     548
   q16  554     532     535     532
   q17  2025    1838    1794    1794
   q18  8717    8372    8355    8355
   q19  1740    1695    1660    1660
   q20  2292    2006    1995    1995
   q21  5818    5267    5311    5267
   q22  581     500     468     468
   Total cold run time: 63921 ms
   Total hot run time: 60334 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to