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

   
   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 9d1d794e44959a6da499db96aa19d89d10d86b91, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5634    5142    5429    5142
   q2   400     175     160     160
   q3   1478    1143    1126    1126
   q4   1100    812     807     807
   q5   3165    3084    3075    3075
   q6   225     140     139     139
   q7   1002    559     511     511
   q8   2164    2293    2275    2275
   q9   6701    6671    6712    6671
   q10  3161    3178    3167    3167
   q11  342     228     221     221
   q12  388     236     238     236
   q13  4422    3647    3636    3636
   q14  265     227     221     221
   q15  582     543     539     539
   q16  455     414     393     393
   q17  1052    554     576     554
   q18  7086    6718    6753    6718
   q19  1660    1608    1413    1413
   q20  549     313     316     313
   q21  2904    2492    2538    2492
   q22  403     332     335     332
   Total cold run time: 45138 ms
   Total hot run time: 40141 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5180    5169    5052    5052
   q2   337     232     252     232
   q3   3363    3344    3337    3337
   q4   2150    2083    2006    2006
   q5   5959    5902    5940    5902
   q6   228     130     130     130
   q7   2405    1888    1948    1888
   q8   3565    3695    3692    3692
   q9   9051    9025    8965    8965
   q10  3886    3913    3952    3913
   q11  599     503     486     486
   q12  807     645     666     645
   q13  3887    3196    3208    3196
   q14  303     277     281     277
   q15  595     533     535     533
   q16  548     519     497     497
   q17  2069    1871    1816    1816
   q18  8777    8359    8271    8271
   q19  1761    1785    1769    1769
   q20  2274    1989    1969    1969
   q21  5867    5403    5283    5283
   q22  576     482     520     482
   Total cold run time: 64187 ms
   Total hot run time: 60341 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