[SERVER-72856] Investigate sort regressions Created: 13/Jan/23  Updated: 01/Mar/23  Resolved: 01/Mar/23

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

Type: Task Priority: Major - P3
Reporter: Mihai Andrei Assignee: Anna Wawrzyniak
Resolution: Duplicate Votes: 0
Labels: pm2697-63, pm2697-m3
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Issue split
split to SERVER-73569 Improve sort performance for small ar... Closed
Related
is related to SERVER-71037 Investigate remaining sort regressions Closed
Sprint: QE 2023-02-06, QE 2023-02-20, QE 2023-03-06
Participants:
Story Points: 10

 Description   

Note that this overlaps with SERVER-71037.

The regressions in question: 

Atlas atlas-1ozv3p-shard-0 [primary] perfreports> db.sbe_perf_latest.aggregate([{ $match: { test: {$nin: [/2KeyCommonPrefix/]}, tags: "sort", signed_percent_change_stable: {$lt: -10}, signed_z_score_change_stable: {$lt: -2}} }, {$project: {_id: 0, classification: 1, test: 1, signed_percent_change_stable: 1, signed_z_score_change_stable: 1}}])
[
  {
    classification: 'regression critical',
    signed_percent_change_stable: -31.33664719878287,
    signed_z_score_change_stable: -9.37996597220802,
    test: 'Queries.SortNoLimitCollection100K_1PathKey3Components'
  },
  {
    classification: 'regression critical',
    signed_percent_change_stable: -28.76809350028948,
    signed_z_score_change_stable: -8.127885070101737,
    test: 'Queries.SortNoLimitCollection100K_1Key'
  },
  {
    classification: 'regression critical',
    signed_percent_change_stable: -23.500576278085703,
    signed_z_score_change_stable: -7.08884511595428,
    test: 'Queries.SortNoLimitCollection100K_1PathKey3Components'
  },
  {
    classification: 'regression critical',
    signed_percent_change_stable: -15.937287884970956,
    signed_z_score_change_stable: -4.4965167297875,
    test: 'Queries.SortNoLimitCollection100K_1PathKey3Components'
  },
  {
    classification: 'regression critical',
    signed_percent_change_stable: -15.207486056520565,
    signed_z_score_change_stable: -4.192089409734391,
    test: 'Queries.SortNoLimitCollection100K_1Key'
  },
  {
    classification: 'regression critical',
    signed_percent_change_stable: -14.565946597806473,
    signed_z_score_change_stable: -4.021665022392767,
    test: 'Queries.SortNoLimitCollection10K_1PathKey3Components'
  },
  {
    classification: 'regression critical',
    signed_percent_change_stable: -12.673300564086091,
    signed_z_score_change_stable: -3.700062154123524,
    test: 'Queries.SortNoLimitCollection10K_1PathKey3Components'
  },
  {
    classification: 'regression critical',
    signed_percent_change_stable: -12.784065111367966,
    signed_z_score_change_stable: -3.1782241959005075,
    test: 'Queries.SortNoLimitCollection10K_1PathKey3Components'
  },
  {
    classification: 'regression critical',
    signed_percent_change_stable: -16.23339505337792,
    signed_z_score_change_stable: -2.671492319567669,
    test: 'Queries.SortLimitHundredCollection1K_1PathKey3Components'
  },
  {
    classification: 'regression critical',
    signed_percent_change_stable: -14.032750571603458,
    signed_z_score_change_stable: -2.4447480835556825,
    test: 'Queries.SortLimitHundredCollection1K_1PathKey3Components'
  },
  {
    classification: 'regression critical',
    signed_percent_change_stable: -14.150219767176424,
    signed_z_score_change_stable: -2.3865820307784986,
    test: 'Queries.SortLimitHundredCollection1K_1PathKey3Components'
  },
  {
    classification: 'regression critical',
    signed_percent_change_stable: -13.543168184817162,
    signed_z_score_change_stable: -2.3442390461063716,
    test: 'Queries.SortLimitHundredCollection1K_1PathKey3Components'
  }
] 


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