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

   
   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 904cfae904ce587213cec1f2d0ae5b520a54cd06, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5603    5294    5270    5270
   q2   391     172     177     172
   q3   1548    1197    1249    1197
   q4   1153    899     823     823
   q5   3256    3223    3168    3168
   q6   239     137     136     136
   q7   1057    518     503     503
   q8   2299    2440    2391    2391
   q9   6906    6880    6863    6863
   q10  3267    3186    3156    3156
   q11  371     227     215     215
   q12  401     233     237     233
   q13  4446    3655    3629    3629
   q14  261     212     216     212
   q15  581     535     526     526
   q16  464     393     417     393
   q17  1062    584     544     544
   q18  7139    6879    6863    6863
   q19  1793    1694    1737    1694
   q20  579     352     345     345
   q21  3001    2583    2490    2490
   q22  402     319     336     319
   Total cold run time: 46219 ms
   Total hot run time: 41142 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5301    5264    5243    5243
   q2   356     241     245     241
   q3   3446    3403    3378    3378
   q4   2235    2094    2107    2094
   q5   6118    6084    6096    6084
   q6   243     129     130     129
   q7   2434    1910    1916    1910
   q8   3694    3831    3854    3831
   q9   9145    9072    9117    9072
   q10  3935    3992    3943    3943
   q11  601     494     481     481
   q12  833     670     631     631
   q13  4004    3192    3173    3173
   q14  298     276     281     276
   q15  599     530     522     522
   q16  569     488     509     488
   q17  2126    1855    1877    1855
   q18  8905    8408    8493    8408
   q19  1888    1815    1840    1815
   q20  2302    2002    1956    1956
   q21  5878    5358    5505    5358
   q22  588     495     459     459
   Total cold run time: 65498 ms
   Total hot run time: 61347 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