explain_query_geo_category

{
    "queryPlanner" : {
        "plannerVersion" : 1,
        "namespace" : "poi_database_production.pois",
        "indexFilterSet" : false,
        "parsedQuery" : {
            "$and" : [
                {
                    "status" : {
                        "$eq" : "enabled"
                    }
                },
                {
                    "category_ids" : {
                        "$in" : [
                            ObjectId("56056db896b23c29e2000001")
                        ]
                    }
                },
                {
                    "location" : {
                        "$near" : {
                            "$geometry" : {
                                "type" : "Point",
                                "coordinates" : [
                                    9,
                                    45.98
                                ]
                            }
                        }
                    }
                }
            ]
        },
        "winningPlan" : {
            "stage" : "LIMIT",
            "limitAmount" : 0,
            "inputStage" : {
                "stage" : "GEO_NEAR_2DSPHERE",
                "keyPattern" : {
                    "location" : "2dsphere",
                    "status" : 1,
                    "category_ids" : 1,
                    "properties.property_id" : 1,
                    "properties.value" : 1
                },
                "indexName" : "location_2dsphere_status_1_category_ids_1_properties.property_id_1_properties.value_1",
                "inputStage" : {
                    "stage" : "FETCH",
                    "inputStage" : {
                        "stage" : "IXSCAN",
                        "filter" : {
                            "TwoDSphereKeyInRegionExpression" : true
                        },
                        "keyPattern" : {
                            "location" : "2dsphere",
                            "status" : 1,
                            "category_ids" : 1,
                            "properties.property_id" : 1,
                            "properties.value" : 1
                        },
                        "indexName" : "location_2dsphere_status_1_category_ids_1_properties.property_id_1_properties.value_1",
                        "isMultiKey" : true,
                        "direction" : "forward",
                        "indexBounds" : {
                            "location" : [
                                "[\"2f0330020\", \"2f0330020\"]",
                                "[\"2f03300201\", \"2f03300201\"]",
                                "[\"2f033002011\", \"2f033002011\"]",
                                "[\"2f0330020112\", \"2f0330020112\"]",
                                "[\"2f03300201120\", \"2f03300201121\")",
                                "[\"2f03300201123\", \"2f03300201124\")",
                                "[\"2f0330020113\", \"2f0330020114\")",
                                "[\"2f033002012\", \"2f033002012\"]",
                                "[\"2f0330020120\", \"2f0330020120\"]",
                                "[\"2f03300201203\", \"2f03300201204\")"
                            ],
                            "status" : [
                                "[\"enabled\", \"enabled\"]"
                            ],
                            "category_ids" : [
                                "[ObjectId('56056db896b23c29e2000001'), ObjectId('56056db896b23c29e2000001')]"
                            ],
                            "properties.property_id" : [
                                "[MinKey, MaxKey]"
                            ],
                            "properties.value" : [
                                "[MinKey, MaxKey]"
                            ]
                        }
                    }
                }
            }
        },
        "rejectedPlans" : [ ]
    },
    "executionStats" : {
        "executionSuccess" : true,
        "nReturned" : 101,
        "executionTimeMillis" : 23,
        "totalKeysExamined" : 5158,
        "totalDocsExamined" : 2460,
        "executionStages" : {
            "stage" : "LIMIT",
            "nReturned" : 101,
            "executionTimeMillisEstimate" : 0,
            "works" : 5262,
            "advanced" : 101,
            "needTime" : 5160,
            "needFetch" : 0,
            "saveState" : 41,
            "restoreState" : 41,
            "isEOF" : 1,
            "invalidates" : 0,
            "limitAmount" : 0,
            "inputStage" : {
                "stage" : "GEO_NEAR_2DSPHERE",
                "nReturned" : 101,
                "executionTimeMillisEstimate" : 0,
                "works" : 5261,
                "advanced" : 101,
                "needTime" : 5160,
                "needFetch" : 0,
                "saveState" : 41,
                "restoreState" : 41,
                "isEOF" : 0,
                "invalidates" : 0,
                "keyPattern" : {
                    "location" : "2dsphere",
                    "status" : 1,
                    "category_ids" : 1,
                    "properties.property_id" : 1,
                    "properties.value" : 1
                },
                "indexName" : "location_2dsphere_status_1_category_ids_1_properties.property_id_1_properties.value_1",
                "searchIntervals" : [ ],
                "inputStage" : {
                    "stage" : "FETCH",
                    "nReturned" : 2460,
                    "executionTimeMillisEstimate" : 0,
                    "works" : 5159,
                    "advanced" : 2460,
                    "needTime" : 2698,
                    "needFetch" : 0,
                    "saveState" : 41,
                    "restoreState" : 41,
                    "isEOF" : 1,
                    "invalidates" : 0,
                    "docsExamined" : 2460,
                    "alreadyHasObj" : 0,
                    "inputStage" : {
                        "stage" : "IXSCAN",
                        "filter" : {
                            "TwoDSphereKeyInRegionExpression" : true
                        },
                        "nReturned" : 2460,
                        "executionTimeMillisEstimate" : 0,
                        "works" : 5159,
                        "advanced" : 2460,
                        "needTime" : 2698,
                        "needFetch" : 0,
                        "saveState" : 41,
                        "restoreState" : 41,
                        "isEOF" : 1,
                        "invalidates" : 0,
                        "keyPattern" : {
                            "location" : "2dsphere",
                            "status" : 1,
                            "category_ids" : 1,
                            "properties.property_id" : 1,
                            "properties.value" : 1
                        },
                        "indexName" : "location_2dsphere_status_1_category_ids_1_properties.property_id_1_properties.value_1",
                        "isMultiKey" : true,
                        "direction" : "forward",
                        "indexBounds" : {
                            "location" : [
                                "[\"2f0330020\", \"2f0330020\"]",
                                "[\"2f03300201\", \"2f03300201\"]",
                                "[\"2f033002011\", \"2f033002011\"]",
                                "[\"2f0330020112\", \"2f0330020112\"]",
                                "[\"2f03300201120\", \"2f03300201121\")",
                                "[\"2f03300201123\", \"2f03300201124\")",
                                "[\"2f0330020113\", \"2f0330020114\")",
                                "[\"2f033002012\", \"2f033002012\"]",
                                "[\"2f0330020120\", \"2f0330020120\"]",
                                "[\"2f03300201203\", \"2f03300201204\")"
                            ],
                            "status" : [
                                "[\"enabled\", \"enabled\"]"
                            ],
                            "category_ids" : [
                                "[ObjectId('56056db896b23c29e2000001'), ObjectId('56056db896b23c29e2000001')]"
                            ],
                            "properties.property_id" : [
                                "[MinKey, MaxKey]"
                            ],
                            "properties.value" : [
                                "[MinKey, MaxKey]"
                            ]
                        },
                        "keysExamined" : 5158,
                        "dupsTested" : 0,
                        "dupsDropped" : 0,
                        "seenInvalidated" : 0,
                        "matchTested" : 2460
                    }
                }
            }
        }
    },
    "serverInfo" : {
        "host" : "speedy.local",
        "port" : 27017,
        "version" : "3.0.3",
        "gitVersion" : "nogitversion"
    },
    "ok" : 1
}