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

   
   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 a00a48d163ea941da42193b1c51d324f8ddfe0cc, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   17632   4671    4657    4657
   q2   2029    148     135     135
   q3   10783   1062    1186    1062
   q4   10548   747     911     747
   q5   7777    2974    3069    2974
   q6   239     123     125     123
   q7   1013    491     522     491
   q8   9221    2004    2014    2004
   q9   6699    6603    6586    6586
   q10  8306    3243    3161    3161
   q11  421     218     214     214
   q12  360     205     205     205
   q13  17996   3404    3407    3404
   q14  244     214     203     203
   q15  560     520     508     508
   q16  442     389     385     385
   q17  944     696     516     516
   q18  7350    6807    6705    6705
   q19  1595    1535    1539    1535
   q20  614     320     319     319
   q21  3058    2613    2632    2613
   q22  347     305     313     305
   Total cold run time: 108178 ms
   Total hot run time: 38852 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   4627    4614    4621    4614
   q2   275     165     171     165
   q3   3318    3329    3309    3309
   q4   2191    2185    2187    2185
   q5   5624    5622    5623    5622
   q6   234     114     116     114
   q7   2315    1833    1840    1833
   q8   3427    3433    3439    3433
   q9   9174    9145    9100    9100
   q10  3772    3819    3833    3819
   q11  469     385     382     382
   q12  765     597     584     584
   q13  7411    3213    3225    3213
   q14  277     256     266     256
   q15  567     519     514     514
   q16  497     453     436     436
   q17  1876    1886    1872    1872
   q18  8685    8210    8186    8186
   q19  1644    1650    1657    1650
   q20  2187    1887    1913    1887
   q21  5968    5643    5625    5625
   q22  549     470     473     470
   Total cold run time: 65852 ms
   Total hot run time: 59269 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