[SERVER-74327] Investigate group_spill_to_disk regressions Created: 23/Feb/23  Updated: 14/Mar/23

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

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

Assigned Teams:
Query Execution
Participants:
Story Points: 5

 Description   

db.sbe_perf_latest.aggregate([{ $match: {tags: {$exists: true}, tags: {$ne: "ignore"}, task: "group_spill_to_disk" } }, { $project: { signed_percent_change_stable: 1, test: 1, signed_percentage_change: 1, _id: 0 } }, { $sort: { signed_percent_change_stable: 1 } }])
[
  {
    signed_percent_change_stable: NaN,
    signed_percentage_change: NaN,
    test: 'GroupAddToSetAccumulatorWithLargeSets.aggregate'
  },
  {
    signed_percent_change_stable: NaN,
    signed_percentage_change: NaN,
    test: 'GroupPushAccumulatorConstructingLargeArrays.aggregate'
  },
  {
    signed_percent_change_stable: NaN,
    signed_percentage_change: NaN,
    test: 'GroupSumAccumulatorSpillDueToManyGroups.aggregate'
  },
  {
    signed_percent_change_stable: -11.306019551908065,
    signed_percentage_change: -11.17667026605578,
    test: 'GroupSumAccumulatorSpillDueToManyGroups.aggregate'
  },
  {
    signed_percent_change_stable: -11.306019551908065,
    signed_percentage_change: -11.17667026605578,
    test: 'GroupSumAccumulatorSpillDueToManyGroups.aggregate'
  },
  {
    signed_percent_change_stable: -10.005735619161072,
    signed_percentage_change: -11.39188329392529,
    test: 'GroupPushAccumulatorConstructingLargeArrays.aggregate'
  },
  {
    signed_percent_change_stable: -10.005735619161072,
    signed_percentage_change: -11.39188329392529,
    test: 'GroupPushAccumulatorConstructingLargeArrays.aggregate'
  },
  {
    signed_percent_change_stable: -0.3046553010070454,
    signed_percentage_change: -2.323401425378364,
    test: 'GroupAddToSetAccumulatorWithLargeSets.aggregate'
  },
  {
    signed_percent_change_stable: -0.3046553010070454,
    signed_percentage_change: -2.323401425378364,
    test: 'GroupAddToSetAccumulatorWithLargeSets.aggregate'
  }
] 



 Comments   
Comment by Mihai Andrei [ 23/Feb/23 ]

(cc david.storch@mongodb.com )

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