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

Investigate Find_* regressions

    • Type: Icon: Task Task
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 7.0.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • Query Execution
    • Fully Compatible
    • QE 2023-03-06, QE 2023-03-20, QE 2023-04-03
    • 3

      db.sbe_perf_latest.aggregate([{ $match: { tags: {$ne: "ignore"}, test: /Find_/} }, {$project: {signed_percent_change_stable: 1, test: 1, measurement: 1, _id: 0}}, {$sort: {test: 1}}, {$group: {_id: "$measurement", tests: {$push: {test: "$test", signed_percent_change_stable: "$signed_percent_change_stable"}}}}]).pretty()
      [
        {
          _id: 'Latency95thPercentile',
          tests: [
            {
              test: 'Find_1.findOne',
              signed_percent_change_stable: -8.791239544397953
            },
            {
              test: 'Find_128.findOne',
              signed_percent_change_stable: -22.051287254041867
            },
            {
              test: 'Find_16.findOne',
              signed_percent_change_stable: -21.794483091011813
            },
            {
              test: 'Find_250.findOne',
              signed_percent_change_stable: -68.27828240953801
            },
            {
              test: 'Find_32.findOne',
              signed_percent_change_stable: -11.864408014227877
            },
            {
              test: 'Find_64.findOne',
              signed_percent_change_stable: -18.153827378687865
            }
          ]
        },
        {
          _id: 'OperationThroughput',
          tests: [
            {
              test: 'Find_1.findOne',
              signed_percent_change_stable: -6.339420121212015
            },
            {
              test: 'Find_128.findOne',
              signed_percent_change_stable: -10.278890759781206
            },
            {
              test: 'Find_16.findOne',
              signed_percent_change_stable: -7.281482690068543
            },
            {
              test: 'Find_250.findOne',
              signed_percent_change_stable: -0.13229833676230385
            },
            {
              test: 'Find_32.findOne',
              signed_percent_change_stable: -8.215011971516063
            },
            {
              test: 'Find_64.findOne',
              signed_percent_change_stable: -8.781758998285156
            }
          ]
        },
        {
          _id: 'Latency50thPercentile',
          tests: [
            {
              test: 'Find_1.findOne',
              signed_percent_change_stable: -4.9922916038251515
            },
            {
              test: 'Find_128.findOne',
              signed_percent_change_stable: -19.54523436130758
            },
            {
              test: 'Find_16.findOne',
              signed_percent_change_stable: -6.120788418922601
            },
            {
              test: 'Find_250.findOne',
              signed_percent_change_stable: -6.185459775019268
            },
            {
              test: 'Find_32.findOne',
              signed_percent_change_stable: -6.397085903131924
            },
            {
              test: 'Find_64.findOne',
              signed_percent_change_stable: -6.268861567796563
            }
          ]
        }
      ] 

            Assignee:
            ivan.fefer@mongodb.com Ivan Fefer
            Reporter:
            mihai.andrei@mongodb.com Mihai Andrei
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: