rs0 [direct: secondary] mydb> db['mycoll'].find({"fsType": "PageRef","page.formData.pt_title.value": "a"}).sort({ _id: -1 }).explain('executionStats');
{
  explainVersion: '2',
  queryPlanner: {
    namespace: 'mydb.mycoll',
    indexFilterSet: false,
    parsedQuery: {
      '$and': [
        { fsType: { '$eq': 'PageRef' } },
        { 'page.formData.pt_title.value': { '$eq': 'a' } }
      ]
    },
    queryHash: '49E80741',
    planCacheKey: '545A094B',
    maxIndexedOrSolutionsReached: false,
    maxIndexedAndSolutionsReached: false,
    maxScansToExplodeReached: false,
    winningPlan: {
      queryPlan: {
        stage: 'FETCH',
        planNodeId: 2,
        filter: {
          '$and': [
            { fsType: { '$eq': 'PageRef' } },
            { 'page.formData.pt_title.value': { '$eq': 'a' } }
          ]
        },
        inputStage: {
          stage: 'IXSCAN',
          planNodeId: 1,
          keyPattern: { _id: 1 },
          indexName: '_id_',
          isMultiKey: false,
          isUnique: true,
          isSparse: false,
          isPartial: false,
          indexVersion: 2,
          direction: 'backward',
          indexBounds: { _id: [ '[MaxKey, MinKey]' ] }
        }
      },
      slotBasedPlan: {
        slots: '$$RESULT=s10 env: { s1 = TimeZoneDatabase(Africa/Tunis...Asia/Choibalsan) (timeZoneDB), s15 = "a", s2 = Nothing (SEARCH_META), s14 = "PageRef", s4 = 1697464838631 (NOW), s3 = Timestamp(1697464836, 1) (CLUSTER_TIME), s9 = {"_id" : 1} }',
        stages: '[2] filter {(traverseF(s12, lambda(l1.0) { ((l1.0 == s14) ?: false) }, false) && traverseF(s13, lambda(l2.0) { traverseF(getField(l2.0, "formData"), lambda(l3.0) { traverseF(getField(l3.0, "pt_title"), lambda(l4.0) { traverseF(getField(l4.0, "value"), lambda(l5.0) { ((l5.0 == s15) ?: false) }, false) }, false) }, false) }, false))} \n' +
          '[2] nlj inner [] [s5, s6, s7, s8, s9] \n' +
          '    left \n' +
          '        [1] ixseek KS(F0FE04) KS(0A0104) s8 s5 s6 s7 lowPriority [] @"5bc49e92-73d2-472f-97ba-ef6c696a1d12" @"_id_" false \n' +
          '    right \n' +
          '        [2] limit 1 \n' +
          '        [2] seek s5 s10 s11 s6 s7 s8 s9 [s12 = fsType, s13 = page] @"5bc49e92-73d2-472f-97ba-ef6c696a1d12" true false \n'
      }
    },
    rejectedPlans: [
      {
        queryPlan: {
          stage: 'SORT',
          planNodeId: 3,
          sortPattern: { _id: -1 },
          memLimit: 104857600,
          type: 'simple',
          inputStage: {
            stage: 'FETCH',
            planNodeId: 2,
            filter: { 'page.formData.pt_title.value': { '$eq': 'a' } },
            inputStage: {
              stage: 'IXSCAN',
              planNodeId: 1,
              keyPattern: {
                fsType: 1,
                'page.template.uid': 1,
                'page.translated': 1
              },
              indexName: 'myIndex',
              isMultiKey: false,
              multiKeyPaths: {
                fsType: [],
                'page.template.uid': [],
                'page.translated': []
              },
              isUnique: false,
              isSparse: false,
              isPartial: false,
              indexVersion: 2,
              direction: 'forward',
              indexBounds: {
                fsType: [ '["PageRef", "PageRef"]' ],
                'page.template.uid': [ '[MinKey, MaxKey]' ],
                'page.translated': [ '[MinKey, MaxKey]' ]
              }
            }
          }
        },
        slotBasedPlan: {
          slots: '$$RESULT=s12 env: { s11 = {"fsType" : 1, "page.template.uid" : 1, "page.translated" : 1}, s1 = TimeZoneDatabase(Africa/Tunis...Asia/Choibalsan) (timeZoneDB), s7 = KS(3C5061676552656600F0F0FE04), s4 = 1697465388086 (NOW), s16 = "a", s3 = Timestamp(1697465386, 1) (CLUSTER_TIME), s6 = KS(3C50616765526566000A0A0104), s2 = Nothing (SEARCH_META) }',
          stages: '[3] sort [s17] [desc] [s12] \n' +
            '[3] project [s17 = \n' +
            '    if (isArray(s14) ?: false) \n' +
            '    then (_internalGreatest(s14) ?: undefined) \n' +
            '    else (s14 ?: null) \n' +
            '] \n' +
            '[2] filter {traverseF(s15, lambda(l1.0) { traverseF(getField(l1.0, "formData"), lambda(l2.0) { traverseF(getField(l2.0, "pt_title"), lambda(l3.0) { traverseF(getField(l3.0, "value"), lambda(l4.0) { ((l4.0 == s16) ?: false) }, false) }, false) }, false) }, false)} \n' +
            '[2] nlj inner [] [s5, s8, s9, s10, s11] \n' +
            '    left \n' +
            '        [1] cfilter {(exists(s6) && exists(s7))} \n' +
            '        [1] ixseek s6 s7 s10 s5 s8 s9 [] @"5bc49e92-73d2-472f-97ba-ef6c696a1d12" @"myIndex" true \n' +
            '    right \n' +
            '        [2] limit 1 \n' +
            '        [2] seek s5 s12 s13 s8 s9 s10 s11 [s14 = _id, s15 = page] @"5bc49e92-73d2-472f-97ba-ef6c696a1d12" true false \n'
        }
      }
    ]
  },
  executionStats: {
    executionSuccess: true,
    nReturned: 0,
    executionTimeMillis: 12562,
    totalKeysExamined: 660244,
    totalDocsExamined: 660244,
    executionStages: {
      stage: 'filter',
      planNodeId: 2,
      nReturned: 0,
      executionTimeMillisEstimate: 11792,
      opens: 1,
      closes: 1,
      saveState: 786,
      restoreState: 786,
      isEOF: 1,
      numTested: 660244,
      filter: '(traverseF(s12, lambda(l1.0) { ((l1.0 == s14) ?: false) }, false) && traverseF(s13, lambda(l2.0) { traverseF(getField(l2.0, "formData"), lambda(l3.0) { traverseF(getField(l3.0, "pt_title"), lambda(l4.0) { traverseF(getField(l4.0, "value"), lambda(l5.0) { ((l5.0 == s15) ?: false) }, false) }, false) }, false) }, false)) ',
      inputStage: {
        stage: 'nlj',
        planNodeId: 2,
        nReturned: 660244,
        executionTimeMillisEstimate: 11675,
        opens: 1,
        closes: 1,
        saveState: 786,
        restoreState: 786,
        isEOF: 1,
        totalDocsExamined: 660244,
        totalKeysExamined: 660244,
        collectionScans: 0,
        collectionSeeks: 660244,
        indexScans: 0,
        indexSeeks: 1,
        indexesUsed: [ '_id_' ],
        innerOpens: 660244,
        innerCloses: 1,
        outerProjects: [],
        outerCorrelated: [ Long("5"), Long("6"), Long("7"), Long("8"), Long("9") ],
        outerStage: {
          stage: 'ixseek',
          planNodeId: 1,
          nReturned: 660244,
          executionTimeMillisEstimate: 2184,
          opens: 1,
          closes: 1,
          saveState: 786,
          restoreState: 786,
          isEOF: 1,
          indexName: '_id_',
          keysExamined: 660244,
          seeks: 1,
          numReads: 660245,
          indexKeySlot: 8,
          recordIdSlot: 5,
          snapshotIdSlot: 6,
          indexIdentSlot: 7,
          outputSlots: [],
          indexKeysToInclude: '00000000000000000000000000000000',
          seekKeyLow: 'KS(F0FE04) ',
          seekKeyHigh: 'KS(0A0104) '
        },
        innerStage: {
          stage: 'limit',
          planNodeId: 2,
          nReturned: 660244,
          executionTimeMillisEstimate: 9443,
          opens: 660244,
          closes: 1,
          saveState: 786,
          restoreState: 786,
          isEOF: 1,
          limit: 1,
          inputStage: {
            stage: 'seek',
            planNodeId: 2,
            nReturned: 660244,
            executionTimeMillisEstimate: 9428,
            opens: 660244,
            closes: 1,
            saveState: 786,
            restoreState: 786,
            isEOF: 0,
            numReads: 660244,
            recordSlot: 10,
            recordIdSlot: 11,
            seekKeySlot: 5,
            snapshotIdSlot: 6,
            indexIdentSlot: 7,
            indexKeySlot: 8,
            indexKeyPatternSlot: 9,
            fields: [ 'fsType', 'page' ],
            outputSlots: [ Long("12"), Long("13") ]
          }
        }
      }
    }
  },
  command: {
    find: 'mycoll',
    filter: { fsType: 'PageRef', 'page.formData.pt_title.value': 'a' },
    sort: { _id: -1 },
    '$db': 'mydb'
  },
  serverInfo: {
    host: 'mongo-0',
    port: 27017,
    version: '7.0.2',
    gitVersion: '02b3c655e1302209ef046da6ba3ef6749dd0b62a'
  },
  serverParameters: {
    internalQueryFacetBufferSizeBytes: 104857600,
    internalQueryFacetMaxOutputDocSizeBytes: 104857600,
    internalLookupStageIntermediateDocumentMaxSizeBytes: 104857600,
    internalDocumentSourceGroupMaxMemoryBytes: 104857600,
    internalQueryMaxBlockingSortMemoryUsageBytes: 104857600,
    internalQueryProhibitBlockingMergeOnMongoS: 0,
    internalQueryMaxAddToSetBytes: 104857600,
    internalDocumentSourceSetWindowFieldsMaxMemoryBytes: 104857600,
    internalQueryFrameworkControl: 'trySbeEngine'
  },
  ok: 1,
  operationTime: Timestamp({ t: 1697464846, i: 1 })
}
rs0 [direct: secondary] mydb>