[SERVER-75416] Support $planCacheStats aggregation stage on time-series collection (sharded and unsharded) Created: 28/Mar/23  Updated: 25/Jul/23

Status: Backlog
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: Adi Agrawal Assignee: Backlog - Query Execution
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
related to SERVER-72686 Add support for $collStats agg stage ... Closed
Assigned Teams:
Query Execution
Participants:

 Description   

Running coll.aggregate([\{$planCacheStats: {}}]) on a time-series collection will fail with
"$planCacheStats is only valid as the first stage in a pipeline".
 
In case of time-series pipelines, $_internalUnpackBucket is the first stage. We need special handling for stages with constraints on pipeline position like the following for $indexStats. https://github.com/10gen/mongo/blob/master/src/mongo/db/views/resolved_view.cpp/#L137-L161



 Comments   
Comment by Ana Meza [ 25/Jul/23 ]

During Quick Wins Triage the team decided to send this ticket to the Backlog

Generated at Thu Feb 08 06:30:07 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.