zxealous opened a new issue, #12598:
URL: https://github.com/apache/doris/issues/12598

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and 
found no similar issues.
   
   
   ### Description
   
   Now, there are no statistics on remote segment cache hits, such as 
ReadSegmentCacheFilesNum, DownloadSegmentCacheFilesNum, HitSegmentCacheFilesNum.
   
   ### Solution
   
   Add some segment cache statistics, for example:
   ```
   Query:
       Summary:
             -  Start  Time:  2022-09-14  15:18:27
             -  End  Time:  2022-09-14  15:18:28
             -  Total:  1s339ms
             -  Query  State:  EOF
             -  Query  ID:  3042c4b738594677-b8e267fb3d97ea93
             -  Query  Type:  Query
             -  Doris  Version:  trunk
             -  User:  root
             -  Default  Db:  default_cluster:test
             -  Sql  Statement:  select  *  from  table_s3
             -  Is  Cached:  No
             -  Trace  ID:  
           Execution  Summary:
                 -  Analysis  Time:  17.768ms
                 -  Plan  Time:  75.774ms
                 -  Schedule  Time:  845.839ms
                 -  Wait  and  Fetch  Result  Time:  379.989ms
           Segment  Cache  Statistics:
                 -  ReadSegmentCacheFilesNum:  11
                 -  DownloadSegmentCacheFilesNum:  3
                 -  HitSegmentCacheFilesNum:  8
                 -  HitSegmentCacheFilesPercent:  72.73%
   ```
   
   ### Are you willing to submit PR?
   
   - [X] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of 
Conduct](https://www.apache.org/foundation/policies/conduct)
   


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