Mryange opened a new pull request, #27094:
URL: https://github.com/apache/doris/pull/27094

   ## Proposed changes
   
   before
   ```
               PipelineXTask  (index=11):
                     -  PrepareTime:  avg  78.733us,  max  89.808us,  min  
71.909us
                     -  WaitBfTime:  avg  0ns,  max  0ns,  min  0ns
                     -  WaitSinkTime:  avg  0ns,  max  0ns,  min  0ns
                     -  WaitSourceTime:  avg  261.370ms,  max  261.405ms,  min  
261.284ms
               STREAMING_AGGREGATION_SINK_OPERATOR  (id=3099):
                     -  CloseTime:  avg  607ns,  max  1.107us,  min  375ns
                     -  ExecTime:  avg  740.257ms,  max  812.969ms,  min  
677.686ms
                     -  InputRows:  64.581046M  (64581046)
                     -  OpenTime:  avg  43.374us,  max  52.176us,  min  39.741us
               HASH_JOIN_OPERATOR  (id=3093):
                     -  PlanInfo
                           -  join  op:  INNER  JOIN(BROADCAST)[]
                           -  equal  join  conjunct:  sold_date_sk  =  d_date_sk
                           -  cardinality=64,808,873
                           -  vec  output  tuple  id:  5
                           -  vIntermediate  tuple  ids:  4  
                           -  hash  output  slot  ids:  97  4  14  
                     -  BlocksReturned:  29.582K  (29582)
                     -  CloseTime:  avg  7.279us,  max  9.966us,  min  5.206us
                     -  ExecTime:  avg  264.493ms,  max  301.136ms,  min  
244.740ms
                     -  OpenTime:  avg  11.738us,  max  21.142us,  min  8.637us
                     -  ProbeRows:  64.802663M  (64802663)
                     -  ProjectionTime:  avg  8.456ms,  max  9.687ms,  min  
7.707ms
                     -  RowsReturned:  64.581046M  (64581046)
                   UNION_OPERATOR  (id=3083):
                         -  PlanInfo
   ```
   
   now
   ```
               PipelineXTask  (index=21):
                     -  PrepareTime:  avg  87.253us,  max  99.736us,  min  
76.171us
                     -  WaitBfTime:  avg  0ns,  max  0ns,  min  0ns
                     -  WaitSinkTime:  avg  0ns,  max  0ns,  min  0ns
                     -  WaitSourceTime:  avg  9.901ms,  max  9.930ms,  min  
9.864ms
               STREAMING_AGGREGATION_SINK_OPERATOR  (id=3099):
                     -  CloseTime:  avg  635ns,  max  908ns,  min  424ns
                     -  ExecTime:  avg  711.554ms,  max  768.809ms,  min  
639.653ms
                     -  InputRows:  64.581046M  (64581046)
                     -  OpenTime:  avg  49.843us,  max  58.92us,  min  43.792us
               HASH_JOIN_OPERATOR  (id=3093):
                     -  PlanInfo
                           -  join  op:  INNER  JOIN(BROADCAST)[]
                           -  equal  join  conjunct:  sold_date_sk  =  d_date_sk
                           -  cardinality=64,808,873
                           -  vec  output  tuple  id:  5
                           -  vIntermediate  tuple  ids:  4  
                           -  hash  output  slot  ids:  97  4  14  
                     -  BlocksReturned:  29.597K  (29597)
                     -  CloseTime:  avg  5.891us,  max  9.851us,  min  4.338us
                     -  ExecTime:  avg  256.265ms,  max  281.435ms,  min  
227.90ms
                     -  OpenTime:  avg  11.821us,  max  15.428us,  min  8.692us
                     -  ProbeRows:  64.802663M  (64802663)
                     -  ProjectionTime:  avg  8.142ms,  max  9.347ms,  min  
7.149ms
                     -  RowsReturned:  64.581046M  (64581046)
                   UNION_OPERATOR  (id=3083):
   ```
   
   
   <!--Describe your changes.-->
   
   ## Further comments
   
   If this is a relatively large or complex change, kick off the discussion at 
[d...@doris.apache.org](mailto:d...@doris.apache.org) by explaining why you 
chose the solution you did and what alternatives you considered, etc...
   
   


-- 
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