[DOCS-14965] [Server] Enable all accumulators for $group pushdown Created: 03/Dec/21  Updated: 22/Jan/24

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

Type: Task Priority: Major - P3
Reporter: Backlog - Core Eng Program Management Team Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: backlog, request
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Documented
documents SERVER-61569 Enable all accumulators for $group pu... Closed
Participants:
Days since reply: 2 years, 9 weeks, 5 days ago

 Description   
Downstream Change Summary

The explain plan will now contain a GROUP stage in the winninPlan part of the queryPlanner section of the explain plan. For an example see,

"winningPlan" : {
"queryPlan" : {
"stage" : "GROUP", <--- new node.
"planNodeId" : 2,
"inputStage" : {
"stage" : "COLLSCAN",
"planNodeId" : 1,
"filter" : {

},
"direction" : "forward"
}
},
"slotBasedPlan" :

Unknown macro: { "slots" }

",
"stages" : "[2] mkbson s11 [_id = s7, s = s10] true false \n[2] project [s10 = doubleDoubleSumFinalize (s9)] \n[2] group [s7] [s9 = aggDoubleDoubleSum (s8)] \n[2] project [s8 = getField (s4, \"x\")] \n[2] project [s7 = fillEmpty (s6, null)] \n[2] project [s6 = getField (s4, \"_idMod10\")] \n[1] scan s4 s5 none none none none [] @\"9d840c15-b98e-4daf-a0d5-e79fdfa85311\" true false "
}
},

Description of Linked Ticket

https://docs.mongodb.com/manual/reference/operator/aggregation/group/



 Comments   
Comment by PM Bot [ 03/Dec/21 ]

Downstream changes updated for upstream SERVER-61569:
The explain plan will now contain a GROUP stage in the winninPlan part of the queryPlanner section of the explain plan. For an example see,

"winningPlan" : {
"queryPlan" : {
"stage" : "GROUP", <--- new node.
"planNodeId" : 2,
"inputStage" : {
"stage" : "COLLSCAN",
"planNodeId" : 1,
"filter" : {

},
"direction" : "forward"
}
},
"slotBasedPlan" : {
"slots" : "$$RESULT=s11 env:

{ s2 = Nothing (SEARCH_META), s3 = 1638564533061 (NOW), s1 = TimeZoneDatabase(America/Argentina/Jujuy...America/Eirunepe) (timeZoneDB) }

",
"stages" : "[2] mkbson s11 [_id = s7, s = s10] true false \n[2] project [s10 = doubleDoubleSumFinalize (s9)] \n[2] group [s7] [s9 = aggDoubleDoubleSum (s8)] \n[2] project [s8 = getField (s4, \"x\")] \n[2] project [s7 = fillEmpty (s6, null)] \n[2] project [s6 = getField (s4, \"_idMod10\")] \n[1] scan s4 s5 none none none none [] @\"9d840c15-b98e-4daf-a0d5-e79fdfa85311\" true false "
}
},

Generated at Thu Feb 08 08:11:38 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.