{ "queryPlanner" : { "plannerVersion" : 1, "namespace" : "st2.action_execution_d_b", "indexFilterSet" : false, "parsedQuery" : { "$and" : [ { "action.ref" : { "$eq" : "sre.fleet_execution" } }, { "status" : { "$eq" : "succeeded" } }, { "start_timestamp" : { "$lt" : NumberLong("1644192000000000") } }, { "start_timestamp" : { "$gt" : NumberLong("1638316000000000") } } ] }, "winningPlan" : { "stage" : "PROJECTION_DEFAULT", "transformBy" : { "context" : 1, "parameters" : 1, "action" : 1, "start_timestamp" : 1, "status" : 1, "runner.runner_parameters" : 1, "_id" : 1, "end_timestamp" : 1 }, "inputStage" : { "stage" : "FETCH", "inputStage" : { "stage" : "SORT", "sortPattern" : { "start_timestamp" : -1, "action.ref" : 1 }, "inputStage" : { "stage" : "SORT_KEY_GENERATOR", "inputStage" : { "stage" : "IXSCAN", "keyPattern" : { "action.ref" : 1, "status" : 1, "start_timestamp" : -1 }, "indexName" : "action.ref_1_status_1_start_timestamp_-1", "isMultiKey" : false, "multiKeyPaths" : { "action.ref" : [ ], "status" : [ ], "start_timestamp" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "action.ref" : [ "[\"sre.fleet_execution\", \"sre.fleet_execution\"]" ], "status" : [ "[\"succeeded\", \"succeeded\"]" ], "start_timestamp" : [ "(1644192000000000, 1638316000000000)" ] } } } } } }, "rejectedPlans" : [ { "stage" : "PROJECTION_DEFAULT", "transformBy" : { "context" : 1, "parameters" : 1, "action" : 1, "start_timestamp" : 1, "status" : 1, "runner.runner_parameters" : 1, "_id" : 1, "end_timestamp" : 1 }, "inputStage" : { "stage" : "SORT", "sortPattern" : { "start_timestamp" : -1, "action.ref" : 1 }, "inputStage" : { "stage" : "SORT_KEY_GENERATOR", "inputStage" : { "stage" : "FETCH", "filter" : { "$and" : [ { "status" : { "$eq" : "succeeded" } }, { "start_timestamp" : { "$lt" : NumberLong("1644192000000000") } }, { "start_timestamp" : { "$gt" : NumberLong("1638316000000000") } } ] }, "inputStage" : { "stage" : "IXSCAN", "keyPattern" : { "action.ref" : 1 }, "indexName" : "action.ref_1", "isMultiKey" : false, "multiKeyPaths" : { "action.ref" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "action.ref" : [ "[\"sre.fleet_execution\", \"sre.fleet_execution\"]" ] } } } } } }, { "stage" : "PROJECTION_DEFAULT", "transformBy" : { "context" : 1, "parameters" : 1, "action" : 1, "start_timestamp" : 1, "status" : 1, "runner.runner_parameters" : 1, "_id" : 1, "end_timestamp" : 1 }, "inputStage" : { "stage" : "SORT", "sortPattern" : { "start_timestamp" : -1, "action.ref" : 1 }, "inputStage" : { "stage" : "SORT_KEY_GENERATOR", "inputStage" : { "stage" : "FETCH", "filter" : { "$and" : [ { "action.ref" : { "$eq" : "sre.fleet_execution" } }, { "status" : { "$eq" : "succeeded" } } ] }, "inputStage" : { "stage" : "IXSCAN", "keyPattern" : { "start_timestamp" : 1 }, "indexName" : "start_timestamp_1", "isMultiKey" : false, "multiKeyPaths" : { "start_timestamp" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "start_timestamp" : [ "(1638316000000000, 1644192000000000)" ] } } } } } }, { "stage" : "PROJECTION_DEFAULT", "transformBy" : { "context" : 1, "parameters" : 1, "action" : 1, "start_timestamp" : 1, "status" : 1, "runner.runner_parameters" : 1, "_id" : 1, "end_timestamp" : 1 }, "inputStage" : { "stage" : "SORT", "sortPattern" : { "start_timestamp" : -1, "action.ref" : 1 }, "inputStage" : { "stage" : "SORT_KEY_GENERATOR", "inputStage" : { "stage" : "FETCH", "filter" : { "$and" : [ { "action.ref" : { "$eq" : "sre.fleet_execution" } }, { "start_timestamp" : { "$lt" : NumberLong("1644192000000000") } }, { "start_timestamp" : { "$gt" : NumberLong("1638316000000000") } } ] }, "inputStage" : { "stage" : "IXSCAN", "keyPattern" : { "status" : 1 }, "indexName" : "status_1", "isMultiKey" : false, "multiKeyPaths" : { "status" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "status" : [ "[\"succeeded\", \"succeeded\"]" ] } } } } } }, { "stage" : "PROJECTION_DEFAULT", "transformBy" : { "context" : 1, "parameters" : 1, "action" : 1, "start_timestamp" : 1, "status" : 1, "runner.runner_parameters" : 1, "_id" : 1, "end_timestamp" : 1 }, "inputStage" : { "stage" : "FETCH", "inputStage" : { "stage" : "IXSCAN", "keyPattern" : { "start_timestamp" : -1, "action.ref" : 1, "status" : 1 }, "indexName" : "start_timestamp_-1_action.ref_1_status_1", "isMultiKey" : false, "multiKeyPaths" : { "start_timestamp" : [ ], "action.ref" : [ ], "status" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "start_timestamp" : [ "(1644192000000000, 1638316000000000)" ], "action.ref" : [ "[\"sre.fleet_execution\", \"sre.fleet_execution\"]" ], "status" : [ "[\"succeeded\", \"succeeded\"]" ] } } } }, { "stage" : "PROJECTION_DEFAULT", "transformBy" : { "context" : 1, "parameters" : 1, "action" : 1, "start_timestamp" : 1, "status" : 1, "runner.runner_parameters" : 1, "_id" : 1, "end_timestamp" : 1 }, "inputStage" : { "stage" : "FETCH", "inputStage" : { "stage" : "SORT", "sortPattern" : { "start_timestamp" : -1, "action.ref" : 1 }, "inputStage" : { "stage" : "SORT_KEY_GENERATOR", "inputStage" : { "stage" : "IXSCAN", "keyPattern" : { "action.ref" : 1, "start_timestamp" : -1, "status" : 1 }, "indexName" : "action.ref_1_start_timestamp_-1_status_1", "isMultiKey" : false, "multiKeyPaths" : { "action.ref" : [ ], "start_timestamp" : [ ], "status" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "action.ref" : [ "[\"sre.fleet_execution\", \"sre.fleet_execution\"]" ], "start_timestamp" : [ "(1644192000000000, 1638316000000000)" ], "status" : [ "[\"succeeded\", \"succeeded\"]" ] } } } } } } ] }, "executionStats" : { "executionSuccess" : true, "nReturned" : 472, "executionTimeMillis" : 25, "totalKeysExamined" : 472, "totalDocsExamined" : 472, "executionStages" : { "stage" : "PROJECTION_DEFAULT", "nReturned" : 472, "executionTimeMillisEstimate" : 4, "works" : 947, "advanced" : 472, "needTime" : 474, "needYield" : 0, "saveState" : 30, "restoreState" : 30, "isEOF" : 1, "transformBy" : { "context" : 1, "parameters" : 1, "action" : 1, "start_timestamp" : 1, "status" : 1, "runner.runner_parameters" : 1, "_id" : 1, "end_timestamp" : 1 }, "inputStage" : { "stage" : "FETCH", "nReturned" : 472, "executionTimeMillisEstimate" : 4, "works" : 947, "advanced" : 472, "needTime" : 474, "needYield" : 0, "saveState" : 30, "restoreState" : 30, "isEOF" : 1, "docsExamined" : 472, "alreadyHasObj" : 0, "inputStage" : { "stage" : "SORT", "nReturned" : 472, "executionTimeMillisEstimate" : 0, "works" : 946, "advanced" : 472, "needTime" : 474, "needYield" : 0, "saveState" : 30, "restoreState" : 30, "isEOF" : 1, "sortPattern" : { "start_timestamp" : -1, "action.ref" : 1 }, "memUsage" : 37288, "memLimit" : 33554432, "inputStage" : { "stage" : "SORT_KEY_GENERATOR", "nReturned" : 472, "executionTimeMillisEstimate" : 0, "works" : 474, "advanced" : 472, "needTime" : 1, "needYield" : 0, "saveState" : 30, "restoreState" : 30, "isEOF" : 1, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 472, "executionTimeMillisEstimate" : 0, "works" : 473, "advanced" : 472, "needTime" : 0, "needYield" : 0, "saveState" : 30, "restoreState" : 30, "isEOF" : 1, "keyPattern" : { "action.ref" : 1, "status" : 1, "start_timestamp" : -1 }, "indexName" : "action.ref_1_status_1_start_timestamp_-1", "isMultiKey" : false, "multiKeyPaths" : { "action.ref" : [ ], "status" : [ ], "start_timestamp" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "action.ref" : [ "[\"sre.fleet_execution\", \"sre.fleet_execution\"]" ], "status" : [ "[\"succeeded\", \"succeeded\"]" ], "start_timestamp" : [ "(1644192000000000, 1638316000000000)" ] }, "keysExamined" : 472, "seeks" : 1, "dupsTested" : 0, "dupsDropped" : 0 } } } } }, "allPlansExecution" : [ { "nReturned" : 101, "executionTimeMillisEstimate" : 0, "totalKeysExamined" : 472, "totalDocsExamined" : 101, "executionStages" : { "stage" : "PROJECTION_DEFAULT", "nReturned" : 101, "executionTimeMillisEstimate" : 0, "works" : 575, "advanced" : 101, "needTime" : 474, "needYield" : 0, "saveState" : 26, "restoreState" : 26, "isEOF" : 0, "transformBy" : { "context" : 1, "parameters" : 1, "action" : 1, "start_timestamp" : 1, "status" : 1, "runner.runner_parameters" : 1, "_id" : 1, "end_timestamp" : 1 }, "inputStage" : { "stage" : "FETCH", "nReturned" : 101, "executionTimeMillisEstimate" : 0, "works" : 575, "advanced" : 101, "needTime" : 474, "needYield" : 0, "saveState" : 26, "restoreState" : 26, "isEOF" : 0, "docsExamined" : 101, "alreadyHasObj" : 0, "inputStage" : { "stage" : "SORT", "nReturned" : 101, "executionTimeMillisEstimate" : 0, "works" : 575, "advanced" : 101, "needTime" : 474, "needYield" : 0, "saveState" : 26, "restoreState" : 26, "isEOF" : 0, "sortPattern" : { "start_timestamp" : -1, "action.ref" : 1 }, "memUsage" : 37288, "memLimit" : 33554432, "inputStage" : { "stage" : "SORT_KEY_GENERATOR", "nReturned" : 472, "executionTimeMillisEstimate" : 0, "works" : 474, "advanced" : 472, "needTime" : 1, "needYield" : 0, "saveState" : 26, "restoreState" : 26, "isEOF" : 1, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 472, "executionTimeMillisEstimate" : 0, "works" : 473, "advanced" : 472, "needTime" : 0, "needYield" : 0, "saveState" : 26, "restoreState" : 26, "isEOF" : 1, "keyPattern" : { "action.ref" : 1, "status" : 1, "start_timestamp" : -1 }, "indexName" : "action.ref_1_status_1_start_timestamp_-1", "isMultiKey" : false, "multiKeyPaths" : { "action.ref" : [ ], "status" : [ ], "start_timestamp" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "action.ref" : [ "[\"sre.fleet_execution\", \"sre.fleet_execution\"]" ], "status" : [ "[\"succeeded\", \"succeeded\"]" ], "start_timestamp" : [ "(1644192000000000, 1638316000000000)" ] }, "keysExamined" : 472, "seeks" : 1, "dupsTested" : 0, "dupsDropped" : 0 } } } } } }, { "nReturned" : 0, "executionTimeMillisEstimate" : 0, "totalKeysExamined" : 574, "totalDocsExamined" : 574, "executionStages" : { "stage" : "PROJECTION_DEFAULT", "nReturned" : 0, "executionTimeMillisEstimate" : 0, "works" : 575, "advanced" : 0, "needTime" : 575, "needYield" : 0, "saveState" : 30, "restoreState" : 30, "isEOF" : 0, "transformBy" : { "context" : 1, "parameters" : 1, "action" : 1, "start_timestamp" : 1, "status" : 1, "runner.runner_parameters" : 1, "_id" : 1, "end_timestamp" : 1 }, "inputStage" : { "stage" : "SORT", "nReturned" : 0, "executionTimeMillisEstimate" : 0, "works" : 575, "advanced" : 0, "needTime" : 575, "needYield" : 0, "saveState" : 30, "restoreState" : 30, "isEOF" : 0, "sortPattern" : { "start_timestamp" : -1, "action.ref" : 1 }, "memUsage" : 892648, "memLimit" : 33554432, "inputStage" : { "stage" : "SORT_KEY_GENERATOR", "nReturned" : 119, "executionTimeMillisEstimate" : 0, "works" : 575, "advanced" : 119, "needTime" : 456, "needYield" : 0, "saveState" : 30, "restoreState" : 30, "isEOF" : 0, "inputStage" : { "stage" : "FETCH", "filter" : { "$and" : [ { "status" : { "$eq" : "succeeded" } }, { "start_timestamp" : { "$lt" : NumberLong("1644192000000000") } }, { "start_timestamp" : { "$gt" : NumberLong("1638316000000000") } } ] }, "nReturned" : 119, "executionTimeMillisEstimate" : 0, "works" : 574, "advanced" : 119, "needTime" : 455, "needYield" : 0, "saveState" : 30, "restoreState" : 30, "isEOF" : 0, "docsExamined" : 574, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 574, "executionTimeMillisEstimate" : 0, "works" : 574, "advanced" : 574, "needTime" : 0, "needYield" : 0, "saveState" : 30, "restoreState" : 30, "isEOF" : 0, "keyPattern" : { "action.ref" : 1 }, "indexName" : "action.ref_1", "isMultiKey" : false, "multiKeyPaths" : { "action.ref" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "action.ref" : [ "[\"sre.fleet_execution\", \"sre.fleet_execution\"]" ] }, "keysExamined" : 574, "seeks" : 1, "dupsTested" : 0, "dupsDropped" : 0 } } } } } }, { "nReturned" : 0, "executionTimeMillisEstimate" : 0, "totalKeysExamined" : 574, "totalDocsExamined" : 574, "executionStages" : { "stage" : "PROJECTION_DEFAULT", "nReturned" : 0, "executionTimeMillisEstimate" : 0, "works" : 575, "advanced" : 0, "needTime" : 575, "needYield" : 0, "saveState" : 30, "restoreState" : 30, "isEOF" : 0, "transformBy" : { "context" : 1, "parameters" : 1, "action" : 1, "start_timestamp" : 1, "status" : 1, "runner.runner_parameters" : 1, "_id" : 1, "end_timestamp" : 1 }, "inputStage" : { "stage" : "SORT", "nReturned" : 0, "executionTimeMillisEstimate" : 0, "works" : 575, "advanced" : 0, "needTime" : 575, "needYield" : 0, "saveState" : 30, "restoreState" : 30, "isEOF" : 0, "sortPattern" : { "start_timestamp" : -1, "action.ref" : 1 }, "memUsage" : 24170, "memLimit" : 33554432, "inputStage" : { "stage" : "SORT_KEY_GENERATOR", "nReturned" : 2, "executionTimeMillisEstimate" : 0, "works" : 575, "advanced" : 2, "needTime" : 573, "needYield" : 0, "saveState" : 30, "restoreState" : 30, "isEOF" : 0, "inputStage" : { "stage" : "FETCH", "filter" : { "$and" : [ { "action.ref" : { "$eq" : "sre.fleet_execution" } }, { "status" : { "$eq" : "succeeded" } } ] }, "nReturned" : 2, "executionTimeMillisEstimate" : 0, "works" : 574, "advanced" : 2, "needTime" : 572, "needYield" : 0, "saveState" : 30, "restoreState" : 30, "isEOF" : 0, "docsExamined" : 574, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 574, "executionTimeMillisEstimate" : 0, "works" : 574, "advanced" : 574, "needTime" : 0, "needYield" : 0, "saveState" : 30, "restoreState" : 30, "isEOF" : 0, "keyPattern" : { "start_timestamp" : 1 }, "indexName" : "start_timestamp_1", "isMultiKey" : false, "multiKeyPaths" : { "start_timestamp" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "start_timestamp" : [ "(1638316000000000, 1644192000000000)" ] }, "keysExamined" : 574, "seeks" : 1, "dupsTested" : 0, "dupsDropped" : 0 } } } } } }, { "nReturned" : 0, "executionTimeMillisEstimate" : 1, "totalKeysExamined" : 574, "totalDocsExamined" : 574, "executionStages" : { "stage" : "PROJECTION_DEFAULT", "nReturned" : 0, "executionTimeMillisEstimate" : 1, "works" : 575, "advanced" : 0, "needTime" : 575, "needYield" : 0, "saveState" : 30, "restoreState" : 30, "isEOF" : 0, "transformBy" : { "context" : 1, "parameters" : 1, "action" : 1, "start_timestamp" : 1, "status" : 1, "runner.runner_parameters" : 1, "_id" : 1, "end_timestamp" : 1 }, "inputStage" : { "stage" : "SORT", "nReturned" : 0, "executionTimeMillisEstimate" : 1, "works" : 575, "advanced" : 0, "needTime" : 575, "needYield" : 0, "saveState" : 30, "restoreState" : 30, "isEOF" : 0, "sortPattern" : { "start_timestamp" : -1, "action.ref" : 1 }, "memUsage" : 24170, "memLimit" : 33554432, "inputStage" : { "stage" : "SORT_KEY_GENERATOR", "nReturned" : 2, "executionTimeMillisEstimate" : 1, "works" : 575, "advanced" : 2, "needTime" : 573, "needYield" : 0, "saveState" : 30, "restoreState" : 30, "isEOF" : 0, "inputStage" : { "stage" : "FETCH", "filter" : { "$and" : [ { "action.ref" : { "$eq" : "sre.fleet_execution" } }, { "start_timestamp" : { "$lt" : NumberLong("1644192000000000") } }, { "start_timestamp" : { "$gt" : NumberLong("1638316000000000") } } ] }, "nReturned" : 2, "executionTimeMillisEstimate" : 1, "works" : 574, "advanced" : 2, "needTime" : 572, "needYield" : 0, "saveState" : 30, "restoreState" : 30, "isEOF" : 0, "docsExamined" : 574, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 574, "executionTimeMillisEstimate" : 1, "works" : 574, "advanced" : 574, "needTime" : 0, "needYield" : 0, "saveState" : 30, "restoreState" : 30, "isEOF" : 0, "keyPattern" : { "status" : 1 }, "indexName" : "status_1", "isMultiKey" : false, "multiKeyPaths" : { "status" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "status" : [ "[\"succeeded\", \"succeeded\"]" ] }, "keysExamined" : 574, "seeks" : 1, "dupsTested" : 0, "dupsDropped" : 0 } } } } } }, { "nReturned" : 0, "executionTimeMillisEstimate" : 0, "totalKeysExamined" : 575, "totalDocsExamined" : 0, "executionStages" : { "stage" : "PROJECTION_DEFAULT", "nReturned" : 0, "executionTimeMillisEstimate" : 0, "works" : 575, "advanced" : 0, "needTime" : 575, "needYield" : 0, "saveState" : 30, "restoreState" : 30, "isEOF" : 0, "transformBy" : { "context" : 1, "parameters" : 1, "action" : 1, "start_timestamp" : 1, "status" : 1, "runner.runner_parameters" : 1, "_id" : 1, "end_timestamp" : 1 }, "inputStage" : { "stage" : "FETCH", "nReturned" : 0, "executionTimeMillisEstimate" : 0, "works" : 575, "advanced" : 0, "needTime" : 575, "needYield" : 0, "saveState" : 30, "restoreState" : 30, "isEOF" : 0, "docsExamined" : 0, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 0, "executionTimeMillisEstimate" : 0, "works" : 575, "advanced" : 0, "needTime" : 575, "needYield" : 0, "saveState" : 30, "restoreState" : 30, "isEOF" : 0, "keyPattern" : { "start_timestamp" : -1, "action.ref" : 1, "status" : 1 }, "indexName" : "start_timestamp_-1_action.ref_1_status_1", "isMultiKey" : false, "multiKeyPaths" : { "start_timestamp" : [ ], "action.ref" : [ ], "status" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "start_timestamp" : [ "(1644192000000000, 1638316000000000)" ], "action.ref" : [ "[\"sre.fleet_execution\", \"sre.fleet_execution\"]" ], "status" : [ "[\"succeeded\", \"succeeded\"]" ] }, "keysExamined" : 575, "seeks" : 575, "dupsTested" : 0, "dupsDropped" : 0 } } } }, { "nReturned" : 0, "executionTimeMillisEstimate" : 0, "totalKeysExamined" : 574, "totalDocsExamined" : 0, "executionStages" : { "stage" : "PROJECTION_DEFAULT", "nReturned" : 0, "executionTimeMillisEstimate" : 0, "works" : 575, "advanced" : 0, "needTime" : 575, "needYield" : 0, "saveState" : 30, "restoreState" : 30, "isEOF" : 0, "transformBy" : { "context" : 1, "parameters" : 1, "action" : 1, "start_timestamp" : 1, "status" : 1, "runner.runner_parameters" : 1, "_id" : 1, "end_timestamp" : 1 }, "inputStage" : { "stage" : "FETCH", "nReturned" : 0, "executionTimeMillisEstimate" : 0, "works" : 575, "advanced" : 0, "needTime" : 575, "needYield" : 0, "saveState" : 30, "restoreState" : 30, "isEOF" : 0, "docsExamined" : 0, "alreadyHasObj" : 0, "inputStage" : { "stage" : "SORT", "nReturned" : 0, "executionTimeMillisEstimate" : 0, "works" : 575, "advanced" : 0, "needTime" : 575, "needYield" : 0, "saveState" : 30, "restoreState" : 30, "isEOF" : 0, "sortPattern" : { "start_timestamp" : -1, "action.ref" : 1 }, "memUsage" : 5372, "memLimit" : 33554432, "inputStage" : { "stage" : "SORT_KEY_GENERATOR", "nReturned" : 68, "executionTimeMillisEstimate" : 0, "works" : 575, "advanced" : 68, "needTime" : 507, "needYield" : 0, "saveState" : 30, "restoreState" : 30, "isEOF" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 68, "executionTimeMillisEstimate" : 0, "works" : 574, "advanced" : 68, "needTime" : 506, "needYield" : 0, "saveState" : 30, "restoreState" : 30, "isEOF" : 0, "keyPattern" : { "action.ref" : 1, "start_timestamp" : -1, "status" : 1 }, "indexName" : "action.ref_1_start_timestamp_-1_status_1", "isMultiKey" : false, "multiKeyPaths" : { "action.ref" : [ ], "start_timestamp" : [ ], "status" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "action.ref" : [ "[\"sre.fleet_execution\", \"sre.fleet_execution\"]" ], "start_timestamp" : [ "(1644192000000000, 1638316000000000)" ], "status" : [ "[\"succeeded\", \"succeeded\"]" ] }, "keysExamined" : 574, "seeks" : 506, "dupsTested" : 0, "dupsDropped" : 0 } } } } } } ] }, "serverInfo" : { "host" : "ap-mongodb-0", "port" : 27017, "version" : "4.2.18", "gitVersion" : "f65ce5e25c0b26a00d091a4d24eec1a8b3a4c016" }, "ok" : 1, "$clusterTime" : { "clusterTime" : Timestamp(1644213210, 1), "signature" : { "hash" : BinData(0,"EKaJysWAfgieGbZ92m7tEXZyE0g="), "keyId" : NumberLong("7029223547708899330") } }, "operationTime" : Timestamp(1644213210, 1) }