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

Investigate sort regressions

    • Type: Icon: Task Task
    • Resolution: Duplicate
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • QE 2023-02-06, QE 2023-02-20, QE 2023-03-06
    • 10

      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'
        }
      ] 

            Assignee:
            anna.wawrzyniak@mongodb.com Anna Wawrzyniak
            Reporter:
            mihai.andrei@mongodb.com Mihai Andrei
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: