{ "stages" : [ { "$cursor" : { "query" : { "location" : { "$geoWithin" : { "$geometry" : { "type" : "Polygon", "coordinates" : [ [ [ 23.55, 37.9262 ], [ 23.95, 37.9262 ], [ 23.95, 38.3 ], [ 23.55, 38.3 ], [ 23.55, 37.9262 ] ] ] } } } }, "queryPlanner" : { "plannerVersion" : 1, "namespace" : "synthetic1.geoPoints", "indexFilterSet" : false, "parsedQuery" : { "location" : { "$geoWithin" : { "$geometry" : { "type" : "Polygon", "coordinates" : [ [ [ 23.55, 37.9262 ], [ 23.95, 37.9262 ], [ 23.95, 38.3 ], [ 23.55, 38.3 ], [ 23.55, 37.9262 ] ] ] } } } }, "winningPlan" : { "stage" : "FETCH", "filter" : { "location" : { "$geoWithin" : { "$geometry" : { "type" : "Polygon", "coordinates" : [ [ [ 23.55, 37.9262 ], [ 23.95, 37.9262 ], [ 23.95, 38.3 ], [ 23.55, 38.3 ], [ 23.55, 37.9262 ] ] ] } } } }, "inputStage" : { "stage" : "IXSCAN", "keyPattern" : { "location" : "2dsphere" }, "indexName" : "location_2dsphere", "isMultiKey" : false, "multiKeyPaths" : { "location" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "location" : [ "[1486469352008974336, 1486469352008974336]", "[1486473750055485440, 1486473750055485440]", "[1486474849567113216, 1486474849567113216]", "[1486475399322927105, 1486475949078740991]", "[1486475949078740993, 1486478148101996543]", "[1486478148101996545, 1486486944195018751]", "[1486486944195018752, 1486486944195018752]", "[1486539720753152000, 1486539720753152000]", "[1486588099264774144, 1486588099264774144]", "[1486588099264774145, 1486590298288029695]", "[1486590298288029697, 1486592497311285247]", "[1486592497311285248, 1486592497311285248]", "[1486592497311285249, 1486601293404307455]", "[1486627681683374080, 1486627681683374080]", "[1486627681683374081, 1486628231439187967]", "[1486628231439187969, 1486628781195001855]", "[1486628781195001856, 1486628781195001856]", "[1486632079729885184, 1486632079729885184]", "[1486634278753140737, 1486636477776396287]", "[1486636477776396289, 1486645273869418495]", "[1486645273869418497, 1486654069962440703]", "[1486654069962440705, 1486656268985696255]", "[1486658468008951808, 1486658468008951808]", "[1486660667032207361, 1486662866055462911]", "[1486662866055462912, 1486662866055462912]", "[1486662866055462913, 1486663415811276799]", "[1486663415811276801, 1486663965567090687]", "[1486663965567090688, 1486663965567090688]", "[1486667264101974016, 1486667264101974016]", "[1486670562636857344, 1486670562636857344]", "[1486670562636857345, 1486671112392671231]", "[1486671662148485121, 1486680458241507327]", "[1486680458241507328, 1486680458241507328]", "[1487313776939106304, 1487313776939106304]", "[1490691476659634176, 1490691476659634176]", "[1495195076287004672, 1495195076287004672]", "[1513209474796486656, 1513209474796486656]" ] } } }, "rejectedPlans" : [ ] }, "executionStats" : { "executionSuccess" : true, "nReturned" : 120091, "executionTimeMillis" : 787966, "totalKeysExamined" : 167644, "totalDocsExamined" : 167627, "executionStages" : { "stage" : "FETCH", "filter" : { "location" : { "$geoWithin" : { "$geometry" : { "type" : "Polygon", "coordinates" : [ [ [ 23.55, 37.9262 ], [ 23.95, 37.9262 ], [ 23.95, 38.3 ], [ 23.55, 38.3 ], [ 23.55, 37.9262 ] ] ] } } } }, "nReturned" : 120091, "executionTimeMillisEstimate" : 787322, "works" : 167644, "advanced" : 120091, "needTime" : 47552, "needYield" : 0, "saveState" : 36562, "restoreState" : 36562, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 167627, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 167627, "executionTimeMillisEstimate" : 1320, "works" : 167644, "advanced" : 167627, "needTime" : 16, "needYield" : 0, "saveState" : 36562, "restoreState" : 36562, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2dsphere" }, "indexName" : "location_2dsphere", "isMultiKey" : false, "multiKeyPaths" : { "location" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "location" : [ "[1486469352008974336, 1486469352008974336]", "[1486473750055485440, 1486473750055485440]", "[1486474849567113216, 1486474849567113216]", "[1486475399322927105, 1486475949078740991]", "[1486475949078740993, 1486478148101996543]", "[1486478148101996545, 1486486944195018751]", "[1486486944195018752, 1486486944195018752]", "[1486539720753152000, 1486539720753152000]", "[1486588099264774144, 1486588099264774144]", "[1486588099264774145, 1486590298288029695]", "[1486590298288029697, 1486592497311285247]", "[1486592497311285248, 1486592497311285248]", "[1486592497311285249, 1486601293404307455]", "[1486627681683374080, 1486627681683374080]", "[1486627681683374081, 1486628231439187967]", "[1486628231439187969, 1486628781195001855]", "[1486628781195001856, 1486628781195001856]", "[1486632079729885184, 1486632079729885184]", "[1486634278753140737, 1486636477776396287]", "[1486636477776396289, 1486645273869418495]", "[1486645273869418497, 1486654069962440703]", "[1486654069962440705, 1486656268985696255]", "[1486658468008951808, 1486658468008951808]", "[1486660667032207361, 1486662866055462911]", "[1486662866055462912, 1486662866055462912]", "[1486662866055462913, 1486663415811276799]", "[1486663415811276801, 1486663965567090687]", "[1486663965567090688, 1486663965567090688]", "[1486667264101974016, 1486667264101974016]", "[1486670562636857344, 1486670562636857344]", "[1486670562636857345, 1486671112392671231]", "[1486671662148485121, 1486680458241507327]", "[1486680458241507328, 1486680458241507328]", "[1487313776939106304, 1487313776939106304]", "[1490691476659634176, 1490691476659634176]", "[1495195076287004672, 1495195076287004672]", "[1513209474796486656, 1513209474796486656]" ] }, "keysExamined" : 167644, "seeks" : 17, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0 } } } } }, { "$group" : { "_id" : { "$const" : null }, "count" : { "$sum" : { "$const" : 1 } } } }, { "$project" : { "_id" : false, "count" : true } } ], "ok" : 1 }