Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-49027

Extend $group explain execution stats to report memory consumption per accumulator

    • Fully Compatible
    • Query 2020-11-30, Query 2020-12-14

      We've seen several cases in the field of $group operations which use $addToSet or $push to create very large arrays. This can lead to the memory footprint being large. In related ticket SERVER-44174, we added a check that will fail a query if a particular $addToSet or $push accumulator's memory consumption exceeds 100MB. However, understanding the memory consumption for a query can still be difficult since there are limited diagnostics in this area.

      In order to help users understand which operators in the query plan are consuming memory, we should extend "executionStats" and "allPlansExecution" verbosity explain output for aggregate commands to include the maximum memory footprint attained at query runtime on a per-accumulator basis.

            Assignee:
            ruoxin.xu@mongodb.com Ruoxin Xu
            Reporter:
            david.storch@mongodb.com David Storch
            Votes:
            0 Vote for this issue
            Watchers:
            9 Start watching this issue

              Created:
              Updated:
              Resolved: