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

   
   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 e1cb5ddfb4c43c55f8f27fcfb1443a07a343d756, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5499    5174    5130    5130
   q2   384     163     159     159
   q3   1472    1153    1178    1153
   q4   1102    732     841     732
   q5   3205    3069    3148    3069
   q6   225     135     135     135
   q7   982     581     522     522
   q8   2172    2264    2206    2206
   q9   6719    6753    6713    6713
   q10  3200    3174    3114    3114
   q11  340     207     216     207
   q12  391     233     233     233
   q13  4414    3657    3656    3656
   q14  254     220     228     220
   q15  579     537     540     537
   q16  467     425     397     397
   q17  1047    514     559     514
   q18  7055    6727    6793    6727
   q19  1648    1557    1618    1557
   q20  607     324     320     320
   q21  2893    2556    2557    2556
   q22  401     335     339     335
   Total cold run time: 45056 ms
   Total hot run time: 40192 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5236    5192    5083    5083
   q2   354     235     229     229
   q3   3422    3352    3346    3346
   q4   2190    2045    2076    2045
   q5   5962    5968    5962    5962
   q6   231     127     127     127
   q7   2391    1904    1934    1904
   q8   3604    3683    3693    3683
   q9   9029    9054    9022    9022
   q10  3884    3920    3964    3920
   q11  590     477     483     477
   q12  816     622     624     622
   q13  3900    3194    3167    3167
   q14  295     284     274     274
   q15  591     525     533     525
   q16  555     508     520     508
   q17  2066    1866    1830    1830
   q18  8786    8426    8399    8399
   q19  1773    1716    1694    1694
   q20  2278    1970    1969    1969
   q21  5863    5300    5476    5300
   q22  563     529     483     483
   Total cold run time: 64379 ms
   Total hot run time: 60569 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