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

   
   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 87c7369671a0a6464f498a4b0752902023d7c7a9, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5509    5150    5148    5148
   q2   392     181     168     168
   q3   1473    1145    1169    1145
   q4   1079    887     781     781
   q5   3123    3087    3117    3087
   q6   223     134     134     134
   q7   955     548     531     531
   q8   2149    2240    2299    2240
   q9   6759    6694    6687    6687
   q10  3228    3127    3135    3127
   q11  344     224     215     215
   q12  383     228     234     228
   q13  4375    3626    3606    3606
   q14  251     210     219     210
   q15  576     525     537     525
   q16  456     403     400     400
   q17  1039    568     511     511
   q18  7098    6795    6765    6765
   q19  1648    1620    1454    1454
   q20  589     323     316     316
   q21  2855    2445    2453    2445
   q22  396     333     320     320
   Total cold run time: 44900 ms
   Total hot run time: 40043 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5126    5079    5100    5079
   q2   335     231     228     228
   q3   3351    3327    3327    3327
   q4   2159    2065    2039    2039
   q5   5956    5927    5904    5904
   q6   223     125     125     125
   q7   2400    1897    1915    1897
   q8   3564    3664    3667    3664
   q9   9013    8972    8923    8923
   q10  3856    3957    3932    3932
   q11  609     490     471     471
   q12  799     626     639     626
   q13  3859    3194    3201    3194
   q14  304     270     265     265
   q15  606     529     525     525
   q16  534     507     523     507
   q17  2030    1820    1811    1811
   q18  8755    8407    8331    8331
   q19  1756    1708    1713    1708
   q20  2284    1988    1974    1974
   q21  5710    5322    5248    5248
   q22  549     463     490     463
   Total cold run time: 63778 ms
   Total hot run time: 60241 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