{ "queryPlanner": { "plannerVersion": 1, "namespace": "iamw.AssistantReports", "indexFilterSet": false, "parsedQuery": { "$and": [ { "employerId": { "$eq": "badf90fe0546862aa50fe845" } }, { "erased": { "$not": { "$eq": true } } }, { "parentReport": { "$not": { "$exists": true } } } ] }, "winningPlan": { "stage": "PROJECTION_SIMPLE", "transformBy": { "reportType": 1 }, "inputStage": { "stage": "SORT", "sortPattern": { "createdAt": -1 }, "limitAmount": 50, "inputStage": { "stage": "SORT_KEY_GENERATOR", "inputStage": { "stage": "FETCH", "filter": { "parentReport": { "$not": { "$exists": true } } }, "inputStage": { "stage": "IXSCAN", "keyPattern": { "employerId": 1, "erased": 1, "parentReport": 1, "createdAt": -1 }, "indexName": "FAST_Publish_AssistantReports_TITLES_PAGED_reverse2", "isMultiKey": false, "multiKeyPaths": { "employerId": [], "erased": [], "parentReport": [], "createdAt": [] }, "isUnique": false, "isSparse": false, "isPartial": false, "indexVersion": 2, "direction": "forward", "indexBounds": { "employerId": [ "[ObjectId('badf90fe0546862aa50fe845'), ObjectId('badf90fe0546862aa50fe845')]" ], "erased": [ "[MinKey, true)", "(true, MaxKey]" ], "parentReport": [ "[null, null]" ], "createdAt": [ "[MaxKey, MinKey]" ] } } } } } }, "rejectedPlans": [ { "stage": "PROJECTION_SIMPLE", "transformBy": { "reportType": 1 }, "inputStage": { "stage": "SORT", "sortPattern": { "createdAt": -1 }, "limitAmount": 50, "inputStage": { "stage": "SORT_KEY_GENERATOR", "inputStage": { "stage": "FETCH", "filter": { "parentReport": { "$not": { "$exists": true } } }, "inputStage": { "stage": "IXSCAN", "keyPattern": { "employerId": 1, "erased": 1, "createdAt": 1, "parentReport": 1 }, "indexName": "FAST_Publish_AssistantReports_TITLES_PAGED3", "isMultiKey": false, "multiKeyPaths": { "employerId": [], "erased": [], "createdAt": [], "parentReport": [] }, "isUnique": false, "isSparse": false, "isPartial": false, "indexVersion": 1, "direction": "forward", "indexBounds": { "employerId": [ "[ObjectId('badf90fe0546862aa50fe845'), ObjectId('badf90fe0546862aa50fe845')]" ], "erased": [ "[MinKey, true)", "(true, MaxKey]" ], "createdAt": [ "[MinKey, MaxKey]" ], "parentReport": [ "[null, null]" ] } } } } } }, { "stage": "PROJECTION_SIMPLE", "transformBy": { "reportType": 1 }, "inputStage": { "stage": "SORT", "sortPattern": { "createdAt": -1 }, "limitAmount": 50, "inputStage": { "stage": "SORT_KEY_GENERATOR", "inputStage": { "stage": "FETCH", "filter": { "parentReport": { "$not": { "$exists": true } } }, "inputStage": { "stage": "IXSCAN", "keyPattern": { "employerId": 1, "dateBegin": 1, "dateEnd": 1, "reportType": 1, "erased": 1 }, "indexName": "FAST_Publish_AssistantReports_QUERY", "isMultiKey": false, "multiKeyPaths": { "employerId": [], "dateBegin": [], "dateEnd": [], "reportType": [], "erased": [] }, "isUnique": false, "isSparse": false, "isPartial": false, "indexVersion": 1, "direction": "forward", "indexBounds": { "employerId": [ "[ObjectId('badf90fe0546862aa50fe845'), ObjectId('badf90fe0546862aa50fe845')]" ], "dateBegin": [ "[MinKey, MaxKey]" ], "dateEnd": [ "[MinKey, MaxKey]" ], "reportType": [ "[MinKey, MaxKey]" ], "erased": [ "[MinKey, true)", "(true, MaxKey]" ] } } } } } }, { "stage": "PROJECTION_SIMPLE", "transformBy": { "reportType": 1 }, "inputStage": { "stage": "SORT", "sortPattern": { "createdAt": -1 }, "limitAmount": 50, "inputStage": { "stage": "SORT_KEY_GENERATOR", "inputStage": { "stage": "FETCH", "filter": { "parentReport": { "$not": { "$exists": true } } }, "inputStage": { "stage": "IXSCAN", "keyPattern": { "employerId": 1, "erased": 1, "parentReport": 1, "createdAt": 1 }, "indexName": "FAST_Publish_AssistantReports_TITLES_PAGED", "isMultiKey": false, "multiKeyPaths": { "employerId": [], "erased": [], "parentReport": [], "createdAt": [] }, "isUnique": false, "isSparse": false, "isPartial": false, "indexVersion": 2, "direction": "forward", "indexBounds": { "employerId": [ "[ObjectId('badf90fe0546862aa50fe845'), ObjectId('badf90fe0546862aa50fe845')]" ], "erased": [ "[MinKey, true)", "(true, MaxKey]" ], "parentReport": [ "[null, null]" ], "createdAt": [ "[MinKey, MaxKey]" ] } } } } } }, { "stage": "PROJECTION_SIMPLE", "transformBy": { "reportType": 1 }, "inputStage": { "stage": "SORT", "sortPattern": { "createdAt": -1 }, "limitAmount": 50, "inputStage": { "stage": "SORT_KEY_GENERATOR", "inputStage": { "stage": "FETCH", "filter": { "parentReport": { "$not": { "$exists": true } } }, "inputStage": { "stage": "IXSCAN", "keyPattern": { "employerId": 1, "erased": 1, "createdAt": 1 }, "indexName": "FAST_Publish_AssistantReports_TITLES_PAGED4_1", "isMultiKey": false, "multiKeyPaths": { "employerId": [], "erased": [], "createdAt": [] }, "isUnique": false, "isSparse": false, "isPartial": false, "indexVersion": 2, "direction": "forward", "indexBounds": { "employerId": [ "[ObjectId('badf90fe0546862aa50fe845'), ObjectId('badf90fe0546862aa50fe845')]" ], "erased": [ "[MinKey, true)", "(true, MaxKey]" ], "createdAt": [ "[MinKey, MaxKey]" ] } } } } } }, { "stage": "PROJECTION_SIMPLE", "transformBy": { "reportType": 1 }, "inputStage": { "stage": "SORT", "sortPattern": { "createdAt": -1 }, "limitAmount": 50, "inputStage": { "stage": "SORT_KEY_GENERATOR", "inputStage": { "stage": "FETCH", "filter": { "parentReport": { "$not": { "$exists": true } } }, "inputStage": { "stage": "IXSCAN", "keyPattern": { "employerId": 1, "erased": 1, "createdAt": -1 }, "indexName": "FAST_Publish_AssistantReports_TITLES_PAGED4_minus1", "isMultiKey": false, "multiKeyPaths": { "employerId": [], "erased": [], "createdAt": [] }, "isUnique": false, "isSparse": false, "isPartial": false, "indexVersion": 2, "direction": "forward", "indexBounds": { "employerId": [ "[ObjectId('badf90fe0546862aa50fe845'), ObjectId('badf90fe0546862aa50fe845')]" ], "erased": [ "[MinKey, true)", "(true, MaxKey]" ], "createdAt": [ "[MaxKey, MinKey]" ] } } } } } }, { "stage": "LIMIT", "limitAmount": 50, "inputStage": { "stage": "PROJECTION_SIMPLE", "transformBy": { "reportType": 1 }, "inputStage": { "stage": "FETCH", "filter": { "$and": [ { "employerId": { "$eq": "badf90fe0546862aa50fe845" } }, { "erased": { "$not": { "$eq": true } } }, { "parentReport": { "$not": { "$exists": true } } } ] }, "inputStage": { "stage": "IXSCAN", "keyPattern": { "createdAt": 1 }, "indexName": "FAST_Publish_AssistantReports_TITLES_PAGED_sortonly", "isMultiKey": false, "multiKeyPaths": { "createdAt": [] }, "isUnique": false, "isSparse": false, "isPartial": false, "indexVersion": 2, "direction": "backward", "indexBounds": { "createdAt": [ "[MaxKey, MinKey]" ] } } } } } ] }, "executionStats": { "executionSuccess": true, "nReturned": 50, "executionTimeMillis": 1558, "totalKeysExamined": 2328, "totalDocsExamined": 2325, "executionStages": { "stage": "PROJECTION_SIMPLE", "nReturned": 50, "executionTimeMillisEstimate": 314, "works": 2380, "advanced": 50, "needTime": 2329, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 1, "transformBy": { "reportType": 1 }, "inputStage": { "stage": "SORT", "nReturned": 50, "executionTimeMillisEstimate": 314, "works": 2380, "advanced": 50, "needTime": 2329, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 1, "sortPattern": { "createdAt": -1 }, "memUsage": 22472699, "memLimit": 33554432, "limitAmount": 50, "inputStage": { "stage": "SORT_KEY_GENERATOR", "nReturned": 2325, "executionTimeMillisEstimate": 284, "works": 2329, "advanced": 2325, "needTime": 3, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 1, "inputStage": { "stage": "FETCH", "filter": { "parentReport": { "$not": { "$exists": true } } }, "nReturned": 2325, "executionTimeMillisEstimate": 279, "works": 2328, "advanced": 2325, "needTime": 2, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 1, "docsExamined": 2325, "alreadyHasObj": 0, "inputStage": { "stage": "IXSCAN", "nReturned": 2325, "executionTimeMillisEstimate": 3, "works": 2328, "advanced": 2325, "needTime": 2, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 1, "keyPattern": { "employerId": 1, "erased": 1, "parentReport": 1, "createdAt": -1 }, "indexName": "FAST_Publish_AssistantReports_TITLES_PAGED_reverse2", "isMultiKey": false, "multiKeyPaths": { "employerId": [], "erased": [], "parentReport": [], "createdAt": [] }, "isUnique": false, "isSparse": false, "isPartial": false, "indexVersion": 2, "direction": "forward", "indexBounds": { "employerId": [ "[ObjectId('badf90fe0546862aa50fe845'), ObjectId('badf90fe0546862aa50fe845')]" ], "erased": [ "[MinKey, true)", "(true, MaxKey]" ], "parentReport": [ "[null, null]" ], "createdAt": [ "[MaxKey, MinKey]" ] }, "keysExamined": 2328, "seeks": 3, "dupsTested": 0, "dupsDropped": 0 } } } } }, "allPlansExecution": [ { "nReturned": 50, "executionTimeMillisEstimate": 314, "totalKeysExamined": 2328, "totalDocsExamined": 2325, "executionStages": { "stage": "PROJECTION_SIMPLE", "nReturned": 50, "executionTimeMillisEstimate": 314, "works": 2379, "advanced": 50, "needTime": 2329, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 1, "transformBy": { "reportType": 1 }, "inputStage": { "stage": "SORT", "nReturned": 50, "executionTimeMillisEstimate": 314, "works": 2379, "advanced": 50, "needTime": 2329, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 1, "sortPattern": { "createdAt": -1 }, "memUsage": 22472699, "memLimit": 33554432, "limitAmount": 50, "inputStage": { "stage": "SORT_KEY_GENERATOR", "nReturned": 2325, "executionTimeMillisEstimate": 284, "works": 2329, "advanced": 2325, "needTime": 3, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 1, "inputStage": { "stage": "FETCH", "filter": { "parentReport": { "$not": { "$exists": true } } }, "nReturned": 2325, "executionTimeMillisEstimate": 279, "works": 2328, "advanced": 2325, "needTime": 2, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 1, "docsExamined": 2325, "alreadyHasObj": 0, "inputStage": { "stage": "IXSCAN", "nReturned": 2325, "executionTimeMillisEstimate": 3, "works": 2328, "advanced": 2325, "needTime": 2, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 1, "keyPattern": { "employerId": 1, "erased": 1, "parentReport": 1, "createdAt": -1 }, "indexName": "FAST_Publish_AssistantReports_TITLES_PAGED_reverse2", "isMultiKey": false, "multiKeyPaths": { "employerId": [], "erased": [], "parentReport": [], "createdAt": [] }, "isUnique": false, "isSparse": false, "isPartial": false, "indexVersion": 2, "direction": "forward", "indexBounds": { "employerId": [ "[ObjectId('badf90fe0546862aa50fe845'), ObjectId('badf90fe0546862aa50fe845')]" ], "erased": [ "[MinKey, true)", "(true, MaxKey]" ], "parentReport": [ "[null, null]" ], "createdAt": [ "[MaxKey, MinKey]" ] }, "keysExamined": 2328, "seeks": 3, "dupsTested": 0, "dupsDropped": 0 } } } } } }, { "nReturned": 0, "executionTimeMillisEstimate": 126, "totalKeysExamined": 2361, "totalDocsExamined": 2030, "executionStages": { "stage": "PROJECTION_SIMPLE", "nReturned": 0, "executionTimeMillisEstimate": 126, "works": 2363, "advanced": 0, "needTime": 2362, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "transformBy": { "reportType": 1 }, "inputStage": { "stage": "SORT", "nReturned": 0, "executionTimeMillisEstimate": 126, "works": 2363, "advanced": 0, "needTime": 2362, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "sortPattern": { "createdAt": -1 }, "memUsage": 33677830, "memLimit": 33554432, "limitAmount": 50, "inputStage": { "stage": "SORT_KEY_GENERATOR", "nReturned": 2030, "executionTimeMillisEstimate": 77, "works": 2362, "advanced": 2030, "needTime": 332, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "inputStage": { "stage": "FETCH", "filter": { "parentReport": { "$not": { "$exists": true } } }, "nReturned": 2030, "executionTimeMillisEstimate": 77, "works": 2361, "advanced": 2030, "needTime": 331, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "docsExamined": 2030, "alreadyHasObj": 0, "inputStage": { "stage": "IXSCAN", "nReturned": 2030, "executionTimeMillisEstimate": 4, "works": 2361, "advanced": 2030, "needTime": 331, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "keyPattern": { "employerId": 1, "erased": 1, "createdAt": 1, "parentReport": 1 }, "indexName": "FAST_Publish_AssistantReports_TITLES_PAGED3", "isMultiKey": false, "multiKeyPaths": { "employerId": [], "erased": [], "createdAt": [], "parentReport": [] }, "isUnique": false, "isSparse": false, "isPartial": false, "indexVersion": 1, "direction": "forward", "indexBounds": { "employerId": [ "[ObjectId('badf90fe0546862aa50fe845'), ObjectId('badf90fe0546862aa50fe845')]" ], "erased": [ "[MinKey, true)", "(true, MaxKey]" ], "createdAt": [ "[MinKey, MaxKey]" ], "parentReport": [ "[null, null]" ] }, "keysExamined": 2361, "seeks": 332, "dupsTested": 0, "dupsDropped": 0 } } } } } }, { "nReturned": 0, "executionTimeMillisEstimate": 107, "totalKeysExamined": 1382, "totalDocsExamined": 1344, "executionStages": { "stage": "PROJECTION_SIMPLE", "nReturned": 0, "executionTimeMillisEstimate": 107, "works": 1384, "advanced": 0, "needTime": 1383, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "transformBy": { "reportType": 1 }, "inputStage": { "stage": "SORT", "nReturned": 0, "executionTimeMillisEstimate": 107, "works": 1384, "advanced": 0, "needTime": 1383, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "sortPattern": { "createdAt": -1 }, "memUsage": 46521086, "memLimit": 33554432, "limitAmount": 50, "inputStage": { "stage": "SORT_KEY_GENERATOR", "nReturned": 1104, "executionTimeMillisEstimate": 73, "works": 1383, "advanced": 1104, "needTime": 279, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "inputStage": { "stage": "FETCH", "filter": { "parentReport": { "$not": { "$exists": true } } }, "nReturned": 1104, "executionTimeMillisEstimate": 72, "works": 1382, "advanced": 1104, "needTime": 278, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "docsExamined": 1344, "alreadyHasObj": 0, "inputStage": { "stage": "IXSCAN", "nReturned": 1344, "executionTimeMillisEstimate": 0, "works": 1382, "advanced": 1344, "needTime": 38, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "keyPattern": { "employerId": 1, "dateBegin": 1, "dateEnd": 1, "reportType": 1, "erased": 1 }, "indexName": "FAST_Publish_AssistantReports_QUERY", "isMultiKey": false, "multiKeyPaths": { "employerId": [], "dateBegin": [], "dateEnd": [], "reportType": [], "erased": [] }, "isUnique": false, "isSparse": false, "isPartial": false, "indexVersion": 1, "direction": "forward", "indexBounds": { "employerId": [ "[ObjectId('badf90fe0546862aa50fe845'), ObjectId('badf90fe0546862aa50fe845')]" ], "dateBegin": [ "[MinKey, MaxKey]" ], "dateEnd": [ "[MinKey, MaxKey]" ], "reportType": [ "[MinKey, MaxKey]" ], "erased": [ "[MinKey, true)", "(true, MaxKey]" ] }, "keysExamined": 1382, "seeks": 39, "dupsTested": 0, "dupsDropped": 0 } } } } } }, { "nReturned": 0, "executionTimeMillisEstimate": 223, "totalKeysExamined": 2030, "totalDocsExamined": 2030, "executionStages": { "stage": "PROJECTION_SIMPLE", "nReturned": 0, "executionTimeMillisEstimate": 223, "works": 2032, "advanced": 0, "needTime": 2031, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "transformBy": { "reportType": 1 }, "inputStage": { "stage": "SORT", "nReturned": 0, "executionTimeMillisEstimate": 223, "works": 2032, "advanced": 0, "needTime": 2031, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "sortPattern": { "createdAt": -1 }, "memUsage": 33677830, "memLimit": 33554432, "limitAmount": 50, "inputStage": { "stage": "SORT_KEY_GENERATOR", "nReturned": 2030, "executionTimeMillisEstimate": 174, "works": 2031, "advanced": 2030, "needTime": 1, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "inputStage": { "stage": "FETCH", "filter": { "parentReport": { "$not": { "$exists": true } } }, "nReturned": 2030, "executionTimeMillisEstimate": 174, "works": 2030, "advanced": 2030, "needTime": 0, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "docsExamined": 2030, "alreadyHasObj": 0, "inputStage": { "stage": "IXSCAN", "nReturned": 2030, "executionTimeMillisEstimate": 13, "works": 2030, "advanced": 2030, "needTime": 0, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "keyPattern": { "employerId": 1, "erased": 1, "parentReport": 1, "createdAt": 1 }, "indexName": "FAST_Publish_AssistantReports_TITLES_PAGED", "isMultiKey": false, "multiKeyPaths": { "employerId": [], "erased": [], "parentReport": [], "createdAt": [] }, "isUnique": false, "isSparse": false, "isPartial": false, "indexVersion": 2, "direction": "forward", "indexBounds": { "employerId": [ "[ObjectId('badf90fe0546862aa50fe845'), ObjectId('badf90fe0546862aa50fe845')]" ], "erased": [ "[MinKey, true)", "(true, MaxKey]" ], "parentReport": [ "[null, null]" ], "createdAt": [ "[MinKey, MaxKey]" ] }, "keysExamined": 2030, "seeks": 1, "dupsTested": 0, "dupsDropped": 0 } } } } } }, { "nReturned": 0, "executionTimeMillisEstimate": 168, "totalKeysExamined": 2361, "totalDocsExamined": 2361, "executionStages": { "stage": "PROJECTION_SIMPLE", "nReturned": 0, "executionTimeMillisEstimate": 168, "works": 2363, "advanced": 0, "needTime": 2362, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "transformBy": { "reportType": 1 }, "inputStage": { "stage": "SORT", "nReturned": 0, "executionTimeMillisEstimate": 168, "works": 2363, "advanced": 0, "needTime": 2362, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "sortPattern": { "createdAt": -1 }, "memUsage": 33677830, "memLimit": 33554432, "limitAmount": 50, "inputStage": { "stage": "SORT_KEY_GENERATOR", "nReturned": 2030, "executionTimeMillisEstimate": 114, "works": 2362, "advanced": 2030, "needTime": 332, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "inputStage": { "stage": "FETCH", "filter": { "parentReport": { "$not": { "$exists": true } } }, "nReturned": 2030, "executionTimeMillisEstimate": 114, "works": 2361, "advanced": 2030, "needTime": 331, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "docsExamined": 2361, "alreadyHasObj": 0, "inputStage": { "stage": "IXSCAN", "nReturned": 2361, "executionTimeMillisEstimate": 12, "works": 2361, "advanced": 2361, "needTime": 0, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "keyPattern": { "employerId": 1, "erased": 1, "createdAt": 1 }, "indexName": "FAST_Publish_AssistantReports_TITLES_PAGED4_1", "isMultiKey": false, "multiKeyPaths": { "employerId": [], "erased": [], "createdAt": [] }, "isUnique": false, "isSparse": false, "isPartial": false, "indexVersion": 2, "direction": "forward", "indexBounds": { "employerId": [ "[ObjectId('badf90fe0546862aa50fe845'), ObjectId('badf90fe0546862aa50fe845')]" ], "erased": [ "[MinKey, true)", "(true, MaxKey]" ], "createdAt": [ "[MinKey, MaxKey]" ] }, "keysExamined": 2361, "seeks": 1, "dupsTested": 0, "dupsDropped": 0 } } } } } }, { "nReturned": 0, "executionTimeMillisEstimate": 204, "totalKeysExamined": 2378, "totalDocsExamined": 2378, "executionStages": { "stage": "PROJECTION_SIMPLE", "nReturned": 0, "executionTimeMillisEstimate": 204, "works": 2379, "advanced": 0, "needTime": 2379, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "transformBy": { "reportType": 1 }, "inputStage": { "stage": "SORT", "nReturned": 0, "executionTimeMillisEstimate": 199, "works": 2379, "advanced": 0, "needTime": 2379, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "sortPattern": { "createdAt": -1 }, "memUsage": 22472699, "memLimit": 33554432, "limitAmount": 50, "inputStage": { "stage": "SORT_KEY_GENERATOR", "nReturned": 2101, "executionTimeMillisEstimate": 191, "works": 2379, "advanced": 2101, "needTime": 278, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "inputStage": { "stage": "FETCH", "filter": { "parentReport": { "$not": { "$exists": true } } }, "nReturned": 2101, "executionTimeMillisEstimate": 187, "works": 2378, "advanced": 2101, "needTime": 277, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "docsExamined": 2378, "alreadyHasObj": 0, "inputStage": { "stage": "IXSCAN", "nReturned": 2378, "executionTimeMillisEstimate": 2, "works": 2378, "advanced": 2378, "needTime": 0, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "keyPattern": { "employerId": 1, "erased": 1, "createdAt": -1 }, "indexName": "FAST_Publish_AssistantReports_TITLES_PAGED4_minus1", "isMultiKey": false, "multiKeyPaths": { "employerId": [], "erased": [], "createdAt": [] }, "isUnique": false, "isSparse": false, "isPartial": false, "indexVersion": 2, "direction": "forward", "indexBounds": { "employerId": [ "[ObjectId('badf90fe0546862aa50fe845'), ObjectId('badf90fe0546862aa50fe845')]" ], "erased": [ "[MinKey, true)", "(true, MaxKey]" ], "createdAt": [ "[MaxKey, MinKey]" ] }, "keysExamined": 2378, "seeks": 1, "dupsTested": 0, "dupsDropped": 0 } } } } } }, { "nReturned": 42, "executionTimeMillisEstimate": 121, "totalKeysExamined": 2379, "totalDocsExamined": 2379, "executionStages": { "stage": "LIMIT", "nReturned": 42, "executionTimeMillisEstimate": 121, "works": 2379, "advanced": 42, "needTime": 2337, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "limitAmount": 50, "inputStage": { "stage": "PROJECTION_SIMPLE", "nReturned": 42, "executionTimeMillisEstimate": 121, "works": 2379, "advanced": 42, "needTime": 2337, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "transformBy": { "reportType": 1 }, "inputStage": { "stage": "FETCH", "filter": { "$and": [ { "employerId": { "$eq": "badf90fe0546862aa50fe845" } }, { "erased": { "$not": { "$eq": true } } }, { "parentReport": { "$not": { "$exists": true } } } ] }, "nReturned": 42, "executionTimeMillisEstimate": 121, "works": 2379, "advanced": 42, "needTime": 2337, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "docsExamined": 2379, "alreadyHasObj": 0, "inputStage": { "stage": "IXSCAN", "nReturned": 2379, "executionTimeMillisEstimate": 0, "works": 2379, "advanced": 2379, "needTime": 0, "needYield": 0, "saveState": 152, "restoreState": 152, "isEOF": 0, "keyPattern": { "createdAt": 1 }, "indexName": "FAST_Publish_AssistantReports_TITLES_PAGED_sortonly", "isMultiKey": false, "multiKeyPaths": { "createdAt": [] }, "isUnique": false, "isSparse": false, "isPartial": false, "indexVersion": 2, "direction": "backward", "indexBounds": { "createdAt": [ "[MaxKey, MinKey]" ] }, "keysExamined": 2379, "seeks": 1, "dupsTested": 0, "dupsDropped": 0 } } } } } ] }, "serverInfo": { "host": "atlas-ykej2l-shard-00-00.a16u7.mongodb.net", "port": 27017, "version": "4.2.15", "gitVersion": "d7fd78dead621a539c20791a93abec34bb1be385" }, "ok": 1, "$clusterTime": { "clusterTime": { "$timestamp": "6999639482261569539" }, "signature": { "hash": "E8rEkE6tvZHglux2FhuSOxt/kW0=", "keyId": { "low": 3, "high": 1624322872, "unsigned": false } } }, "operationTime": { "$timestamp": "6999639482261569539" } }