[DOCS-15697] Investigate changes in SERVER-53657: $group's executionStats should report the spilled data file size Created: 20/Oct/22  Updated: 13/Nov/23  Resolved: 06/Feb/23

Status: Closed
Project: Documentation
Component/s: manual, Server
Affects Version/s: None
Fix Version/s: 6.2.0-rc0, 6.3.0-rc0, Server_Docs_20231030, Server_Docs_20231106, Server_Docs_20231105, Server_Docs_20231113

Type: Task Priority: Major - P3
Reporter: Backlog - Core Eng Program Management Team Assignee: Alison Huh
Resolution: Fixed Votes: 0
Labels: ready-for-work
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Documented
documents SERVER-53657 $group's executionStats should report... Closed
Participants:
Days since reply: 1 year, 9 weeks, 1 day ago
Epic Link: DOCSP-22091

 Description   
Original Downstream Change Summary

This commit introduces two fields to the execution stats explain output of $group in the classic engine:

  • spillFileSizeBytes, which reports the size of the spill file written to disk
  • numBytesSpilledEstimate, which reports an estimate of the size of $group data evicted from memory as part of spilling

Note that these are not the same quantity, typically, spillFileSizeBytes will be less than numBytesSpilledEstimate because the buffer will be compressed before being written to disk.

Description of Linked Ticket

$group's executionStats should expose a stats "spillFileSizeBytes". This stat should report the maximum files size bytes that was written to disk in bytes. This stat will help in better planning/recommendation on disk usage and maybe I/O capacity planning.



 Comments   
Comment by Education Bot [ 06/Dec/22 ]

Fix Version updated for upstream SERVER-53657:
6.3.0-rc0

Comment by David Hou [ 09/Nov/22 ]

Engineering reverted merge due to Evergreen test failure. There is no timeline for when work will pick up yet.

Comment by Education Bot [ 21/Oct/22 ]

Fix Version updated for upstream SERVER-53657:

Comment by Education Bot [ 20/Oct/22 ]

Fix Version updated for upstream SERVER-53657:
6.2.0-rc0

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