{
    "explainVersion" : "2",
    "queryPlanner" : {
        "namespace" : "myDB.myColl",
        "indexFilterSet" : false,
        "parsedQuery" : {
            "$and" : [
                {
                    "activeDay" : {
                        "$eq" : "2024"
                    }
                },
                {
                    "os" : {
                        "$lt" : 9.0
                    }
                },
                {
                    "os" : {
                        "$gt" : 0.0
                    }
                }
            ]
        },
        "queryHash" : "F9395191",
        "planCacheKey" : "21DA36DC",
        "optimizedPipeline" : true,
        "maxIndexedOrSolutionsReached" : false,
        "maxIndexedAndSolutionsReached" : false,
        "maxScansToExplodeReached" : false,
        "winningPlan" : {
            "queryPlan" : {
                "stage" : "GROUP",
                "planNodeId" : 3.0,
                "inputStage" : {
                    "stage" : "COLLSCAN",
                    "planNodeId" : 1.0,
                    "filter" : {
                        "$and" : [
                            {
                                "activeDay" : {
                                    "$eq" : "2024"
                                }
                            },
                            {
                                "os" : {
                                    "$lt" : 9.0
                                }
                            },
                            {
                                "os" : {
                                    "$gt" : 0.0
                                }
                            }
                        ]
                    },
                    "direction" : "forward"
                }
            },
            "slotBasedPlan" : {
                "slots" : "$$RESULT=s16 env: { s11 = 9, s2 = Nothing (SEARCH_META), s10 = \"2024\", s12 = 0, s3 = Timestamp(1735636125, 156) (CLUSTER_TIME), s4 = 1735636127908 (NOW), s1 = TimeZoneDatabase(Asia/Istanbul...America/Nipigon) (timeZoneDB) }",
                "stages" : "[3] project [s16 = newBsonObj(\"_id\", s13, \"value\", s14)] \n[3] group [s13] [s14 = sum(1)] spillSlots[s15] mergingExprs[sum(s15)] \n[3] project [s13 = (s5 ?: null)] \n[1] filter {(traverseF(s6, lambda(l1.0) { ((l1.0 == s10) ?: false) }, false) && (traverseF(s7, lambda(l2.0) { ((l2.0 < s11) ?: false) }, false) && traverseF(s7, lambda(l3.0) { ((l3.0 > s12) ?: false) }, false)))} \n[1] scan s8 s9 none none none none lowPriority [s5 = appId, s6 = activeDay, s7 = os] @\"50d3f897-6688-44b6-9bdb-ca787d6f2bc8\" true false "
            }
        },
        "rejectedPlans" : [

        ]
    },
    "executionStats" : {
        "executionSuccess" : true,
        "nReturned" : 62.0,
        "executionTimeMillis" : 5128.0,
        "totalKeysExamined" : 0.0,
        "totalDocsExamined" : 5084563.0,
        "executionStages" : {
            "stage" : "project",
            "planNodeId" : 3.0,
            "nReturned" : 62.0,
            "executionTimeMillisEstimate" : 5127.0,
            "opens" : 1.0,
            "closes" : 1.0,
            "saveState" : 5084.0,
            "restoreState" : 5084.0,
            "isEOF" : 1.0,
            "projections" : {
                "16" : "newBsonObj(\"_id\", s13, \"value\", s14) "
            },
            "inputStage" : {
                "stage" : "group",
                "planNodeId" : 3.0,
                "nReturned" : 62.0,
                "executionTimeMillisEstimate" : 5127.0,
                "opens" : 1.0,
                "closes" : 1.0,
                "saveState" : 5084.0,
                "restoreState" : 5084.0,
                "isEOF" : 1.0,
                "groupBySlots" : [
                    NumberLong(13)
                ],
                "expressions" : {
                    "14" : "sum(1) ",
                    "initExprs" : {
                        "14" : null
                    }
                },
                "mergingExprs" : {
                    "15" : "sum(s15) "
                },
                "usedDisk" : false,
                "spills" : 0.0,
                "spilledBytes" : 0.0,
                "spilledRecords" : 0.0,
                "spilledDataStorageSize" : 0.0,
                "inputStage" : {
                    "stage" : "project",
                    "planNodeId" : 3.0,
                    "nReturned" : 3725758.0,
                    "executionTimeMillisEstimate" : 4984.0,
                    "opens" : 1.0,
                    "closes" : 1.0,
                    "saveState" : 5084.0,
                    "restoreState" : 5084.0,
                    "isEOF" : 1.0,
                    "projections" : {
                        "13" : "(s5 ?: null) "
                    },
                    "inputStage" : {
                        "stage" : "filter",
                        "planNodeId" : 1.0,
                        "nReturned" : 3725758.0,
                        "executionTimeMillisEstimate" : 4963.0,
                        "opens" : 1.0,
                        "closes" : 1.0,
                        "saveState" : 5084.0,
                        "restoreState" : 5084.0,
                        "isEOF" : 1.0,
                        "numTested" : 5084563.0,
                        "filter" : "(traverseF(s6, lambda(l1.0) { ((l1.0 == s10) ?: false) }, false) && (traverseF(s7, lambda(l2.0) { ((l2.0 < s11) ?: false) }, false) && traverseF(s7, lambda(l3.0) { ((l3.0 > s12) ?: false) }, false))) ",
                        "inputStage" : {
                            "stage" : "scan",
                            "planNodeId" : 1.0,
                            "nReturned" : 5084563.0,
                            "executionTimeMillisEstimate" : 4684.0,
                            "opens" : 1.0,
                            "closes" : 1.0,
                            "saveState" : 5084.0,
                            "restoreState" : 5084.0,
                            "isEOF" : 1.0,
                            "numReads" : 5084563.0,
                            "recordSlot" : 8.0,
                            "recordIdSlot" : 9.0,
                            "fields" : [
                                "appId",
                                "activeDay",
                                "os"
                            ],
                            "outputSlots" : [
                                NumberLong(5),
                                NumberLong(6),
                                NumberLong(7)
                            ]
                        }
                    }
                }
            }
        }
    },
    "command" : {
        "aggregate" : "myColl",
        "pipeline" : [
            {
                "$match" : {
                    "activeDay" : "2024",
                    "os" : {
                        "$gt" : 0.0,
                        "$lt" : 9.0
                    }
                }
            },
            {
                "$group" : {
                    "_id" : "$appId",
                    "value" : {
                        "$count" : {

                        }
                    }
                }
            }
        ],
        "cursor" : {

        },
        "$db" : "myDB"
    },
    "serverInfo" : {
        "host" : "myHost",
        "port" : 27017.0,
        "version" : "7.0.15",
        "gitVersion" : "57939cc60865b0ce431c7e08c2589fa266a1a740"
    },
    "serverParameters" : {
        "internalQueryFacetBufferSizeBytes" : 104857600.0,
        "internalQueryFacetMaxOutputDocSizeBytes" : 104857600.0,
        "internalLookupStageIntermediateDocumentMaxSizeBytes" : 104857600.0,
        "internalDocumentSourceGroupMaxMemoryBytes" : 104857600.0,
        "internalQueryMaxBlockingSortMemoryUsageBytes" : 104857600.0,
        "internalQueryProhibitBlockingMergeOnMongoS" : 0.0,
        "internalQueryMaxAddToSetBytes" : 104857600.0,
        "internalDocumentSourceSetWindowFieldsMaxMemoryBytes" : 104857600.0,
        "internalQueryFrameworkControl" : "trySbeRestricted"
    },
    "ok" : 1.0,
    "$clusterTime" : {
        "clusterTime" : Timestamp(1735636131, 156),
        "signature" : {
            "hash" : BinData(0, "Buo6tujQSamk/LQFOHj0bR3BtHA="),
            "keyId" : NumberLong(7397444593077190837)
        }
    },
    "operationTime" : Timestamp(1735636131, 156)
}