[COMPASS-7229] Investigate changes in SERVER-75754: Consider moving query.planCacheTotalSizeEstimateBytes and query.planCacheTotalQueryShapes into query.planCache sub-document. Created: 19/Sep/23  Updated: 25/Sep/23  Resolved: 25/Sep/23

Status: Closed
Project: Compass
Component/s: None
Affects Version/s: None
Fix Version/s: No version

Type: Investigation Priority: Minor - P4
Reporter: Backlog - Core Eng Program Management Team Assignee: Rhys Howell
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
depends on SERVER-75754 Consider moving query.planCacheTotalS... Closed
Documentation Changes: Not Needed

 Description   
Original Downstream Change Summary

serverStatus fields:

metrics.query.planCacheTotalQueryShapes
metrics.query.planCacheTotalSizeEstimateBytes

moved to

metrics.query.planCache.totalQueryShapes
metrics.query.planCache.totalSizeEstimateBytes

Example planCache sub doc:

"planCache" : {
        "totalQueryShapes" : NumberLong(0),
        "totalSizeEstimateBytes" : NumberLong(0),
        "classic" : {
                "hits" : NumberLong(0),
                "misses" : NumberLong(2)
        },
        "sbe" : {
                "hits" : NumberLong(0),
                "misses" : NumberLong(0)
        }
},

Description of Linked Ticket

In SERVER-70025 we introduced 4 new plan cache counters which are surfaced via query.planCache sub-document.

We should consider moving all plan cache related counters into the query.planCache sub-document to group them logically together.

The two which are currently housed in the query document are:

  • query.planCacheTotalSizeEstimateBytes
  • query.planCacheTotalQueryShapes


 Comments   
Comment by Rhys Howell [ 25/Sep/23 ]

No dev tools changes needed, we don't use these fields currently except for surfacing the entire plan cache doc.

Comment by PM Bot [ 19/Sep/23 ]

Fix Version updated for upstream SERVER-75754:
7.2.0-rc0

Generated at Wed Feb 07 22:45:50 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.