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

   
   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 c775d9ee99b9621bc736065c1c45f8af4f01023d, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5474    5090    5128    5090
   q2   391     174     183     174
   q3   1466    1109    1170    1109
   q4   1084    746     814     746
   q5   3160    3090    3072    3072
   q6   239     136     132     132
   q7   991     560     525     525
   q8   2140    2193    2254    2193
   q9   6679    6665    6662    6662
   q10  3202    3104    3148    3104
   q11  352     219     205     205
   q12  378     229     236     229
   q13  4427    3634    3658    3634
   q14  260     220     212     212
   q15  584     540     539     539
   q16  467     398     406     398
   q17  1044    577     533     533
   q18  7104    6741    6801    6741
   q19  1637    1521    1483    1483
   q20  592     330     348     330
   q21  2884    2410    2492    2410
   q22  384     341     318     318
   Total cold run time: 44939 ms
   Total hot run time: 39839 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5132    5058    5016    5016
   q2   335     232     234     232
   q3   3357    3324    3319    3319
   q4   2151    2037    2056    2037
   q5   5941    5966    5940    5940
   q6   223     126     128     126
   q7   2394    1896    1924    1896
   q8   3549    3623    3706    3623
   q9   9013    8975    8999    8975
   q10  3861    3896    3890    3890
   q11  583     492     483     483
   q12  807     627     616     616
   q13  3903    3183    3209    3183
   q14  309     287     258     258
   q15  594     540     528     528
   q16  545     522     496     496
   q17  2029    1821    1809    1809
   q18  8719    8396    8362    8362
   q19  1741    1668    1708    1668
   q20  2246    1986    1970    1970
   q21  5688    5350    5315    5315
   q22  553     475     476     475
   Total cold run time: 63673 ms
   Total hot run time: 60217 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