[SERVER-74063] Investigate Find_* regressions Created: 15/Feb/23  Updated: 29/Oct/23  Resolved: 21/Mar/23

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

Type: Task Priority: Major - P3
Reporter: Mihai Andrei Assignee: Ivan Fefer
Resolution: Fixed Votes: 0
Labels: pm2697-m4
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Assigned Teams:
Query Execution
Backwards Compatibility: Fully Compatible
Sprint: QE 2023-03-06, QE 2023-03-20, QE 2023-04-03
Participants:
Story Points: 3

 Description   

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



 Comments   
Comment by Githook User [ 10/Mar/23 ]

Author:

{'name': 'Ivan Fefer', 'email': 'ivan.fefer@mongodb.com', 'username': 'Fefer-Ivan'}

Message: SERVER-74063 Delete plan executor ASAP to release cursors
Branch: master
https://github.com/mongodb/mongo/commit/66644d0b12d9e598adf0f6af791605b146aa6b7a

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