rs0 [direct: secondary] mydb> db['mycoll'].find({"fsType": "PageRef","page.formData.pt_title.value": "a"}).explain('executionStats');
{
  explainVersion: '2',
  queryPlanner: {
    namespace: 'mydb.mycoll',
    indexFilterSet: false,
    parsedQuery: {
      '$and': [
        { fsType: { '$eq': 'PageRef' } },
        { 'page.formData.pt_title.value': { '$eq': 'a' } }
      ]
    },
    queryHash: 'BF579442',
    planCacheKey: 'CE055B02',
    maxIndexedOrSolutionsReached: false,
    maxIndexedAndSolutionsReached: false,
    maxScansToExplodeReached: false,
    winningPlan: {
      queryPlan: {
        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: { s15 = "a", s6 = KS(3C50616765526566000A0A0104), s11 = {"fsType" : 1, "page.template.uid" : 1, "page.translated" : 1}, s2 = Nothing (SEARCH_META), s7 = KS(3C5061676552656600F0F0FE04), s1 = TimeZoneDatabase(Africa/Tunis...Asia/Choibalsan) (timeZoneDB), s4 = 1697467176654 (NOW), s3 = Timestamp(1697467170, 35) (CLUSTER_TIME) }',
        stages: '[2] filter {traverseF(s14, 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 == s15) ?: 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 = page] @"5bc49e92-73d2-472f-97ba-ef6c696a1d12" true false \n'
      }
    },
    rejectedPlans: []
  },
  executionStats: {
    executionSuccess: true,
    nReturned: 0,
    executionTimeMillis: 283,
    totalKeysExamined: 21489,
    totalDocsExamined: 21489,
    executionStages: {
      stage: 'filter',
      planNodeId: 2,
      nReturned: 0,
      executionTimeMillisEstimate: 68,
      opens: 1,
      closes: 1,
      saveState: 21,
      restoreState: 21,
      isEOF: 1,
      numTested: 21489,
      filter: 'traverseF(s14, 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 == s15) ?: false) }, false) }, false) }, false) }, false) ',
      inputStage: {
        stage: 'nlj',
        planNodeId: 2,
        nReturned: 21489,
        executionTimeMillisEstimate: 62,
        opens: 1,
        closes: 1,
        saveState: 21,
        restoreState: 21,
        isEOF: 1,
        totalDocsExamined: 21489,
        totalKeysExamined: 21489,
        collectionScans: 0,
        collectionSeeks: 21489,
        indexScans: 0,
        indexSeeks: 1,
        indexesUsed: [ 'myIndex' ],
        innerOpens: 21489,
        innerCloses: 1,
        outerProjects: [],
        outerCorrelated: [ Long("5"), Long("8"), Long("9"), Long("10"), Long("11") ],
        outerStage: {
          stage: 'cfilter',
          planNodeId: 1,
          nReturned: 21489,
          executionTimeMillisEstimate: 50,
          opens: 1,
          closes: 1,
          saveState: 21,
          restoreState: 21,
          isEOF: 1,
          numTested: 1,
          filter: '(exists(s6) && exists(s7)) ',
          inputStage: {
            stage: 'ixseek',
            planNodeId: 1,
            nReturned: 21489,
            executionTimeMillisEstimate: 50,
            opens: 1,
            closes: 1,
            saveState: 21,
            restoreState: 21,
            isEOF: 1,
            indexName: 'myIndex',
            keysExamined: 21489,
            seeks: 1,
            numReads: 21490,
            indexKeySlot: 10,
            recordIdSlot: 5,
            snapshotIdSlot: 8,
            indexIdentSlot: 9,
            outputSlots: [],
            indexKeysToInclude: '00000000000000000000000000000000',
            seekKeyLow: 's6 ',
            seekKeyHigh: 's7 '
          }
        },
        innerStage: {
          stage: 'limit',
          planNodeId: 2,
          nReturned: 21489,
          executionTimeMillisEstimate: 12,
          opens: 21489,
          closes: 1,
          saveState: 21,
          restoreState: 21,
          isEOF: 1,
          limit: 1,
          inputStage: {
            stage: 'seek',
            planNodeId: 2,
            nReturned: 21489,
            executionTimeMillisEstimate: 12,
            opens: 21489,
            closes: 1,
            saveState: 21,
            restoreState: 21,
            isEOF: 0,
            numReads: 21489,
            recordSlot: 12,
            recordIdSlot: 13,
            seekKeySlot: 5,
            snapshotIdSlot: 8,
            indexIdentSlot: 9,
            indexKeySlot: 10,
            indexKeyPatternSlot: 11,
            fields: [ 'page' ],
            outputSlots: [ Long("14") ]
          }
        }
      }
    }
  },
  command: {
    find: 'mycoll',
    filter: { fsType: 'PageRef', 'page.formData.pt_title.value': 'a' },
    '$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: 1697467170, i: 35 })
}
rs0 [direct: secondary] mydb>