-
Type:
Bug
-
Resolution: Done
-
Priority:
Major - P3
-
Affects Version/s: 3.0.0-rc11
-
Component/s: Geo
-
None
-
Fully Compatible
-
ALL
-
Hide
Start with a collection with a ~500k documents
Unable to find source-code formatter for language: javascript. Available languages are: actionscript, ada, applescript, bash, c, c#, c++, cpp, css, erlang, go, groovy, haskell, html, java, javascript, js, json, lua, none, nyan, objc, perl, php, python, r, rainbow, ruby, scala, sh, sql, swift, visualbasic, xml, yamldb.getCollection("some_collection:Place").count() 583104
2.6.5 nearSphere query with explain()
> db.getCollection("some_collection:Place").find({location: { $nearSphere: [ 106.6331, 10.7395 ] }}).explain() { "cursor" : "GeoSearchCursor", "isMultiKey" : false, "n" : 100, "nscannedObjects" : 599, "nscanned" : 3692, "nscannedObjectsAllPlans" : 599, "nscannedAllPlans" : 3692, "scanAndOrder" : false, "indexOnly" : false, "nYields" : 0, "nChunkSkips" : 0, "millis" : 5, "indexBounds" : { }
Run same query with explain("executionStats") on 3.0.0-rc11
db.getCollection("some_collection:Place").find({location: { $nearSphere: [ 106.6331, 10.7395 ] }}).explain("executionStats") { "queryPlanner" : { "plannerVersion" : 1, "namespace" : "test.some_collection:Place", "indexFilterSet" : false, "parsedQuery" : { "location" : { "$nearSphere" : [ 106.6331, 10.7395 ] } }, "winningPlan" : { "stage" : "GEO_NEAR_2D", "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "inputStages" : [ { "stage" : "FETCH", "inputStage" : { "stage" : "IXSCAN", "filter" : { "TwoDKeyInRegionExpression" : true }, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "location" : [ "[BinData(128, E09F97C000000000), BinData(128, E09F97FFFFFFFFFF)]", "[BinData(128, E09F9C0000000000), BinData(128, E09F9FFFFFFFFFFF)]", "[BinData(128, E09FB40000000000), BinData(128, E09FB7FFFFFFFFFF)]", "[BinData(128, E09FBC0000000000), BinData(128, E09FBFFFFFFFFFFF)]", "[BinData(128, E09FC00000000000), BinData(128, E09FCFFFFFFFFFFF)]", "[BinData(128, E09FD28000000000), BinData(128, E09FD2BFFFFFFFFF)]", "[BinData(128, E09FD2E000000000), BinData(128, E09FD2EFFFFFFFFF)]", "[BinData(128, E09FD80000000000), BinData(128, E09FDBFFFFFFFFFF)]", "[BinData(128, E09FDE8000000000), BinData(128, E09FDEBFFFFFFFFF)]", "[BinData(128, E09FE00000000000), BinData(128, E09FEFFFFFFFFFFF)]", "[BinData(128, E09FF00000000000), BinData(128, E09FFFFFFFFFFFFF)]", "[BinData(128, E0B5150000000000), BinData(128, E0B515FFFFFFFFFF)]", "[BinData(128, E0B5400000000000), BinData(128, E0B543FFFFFFFFFF)]", "[BinData(128, E0B5440000000000), BinData(128, E0B547FFFFFFFFFF)]", "[BinData(128, E0B5500000000000), BinData(128, E0B550FFFFFFFFFF)]", "[BinData(128, E0B5510000000000), BinData(128, E0B5513FFFFFFFFF)]" ] } } }, { "stage" : "FETCH", "inputStage" : { "stage" : "IXSCAN", "filter" : { "TwoDKeyInRegionExpression" : true }, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "location" : [ "[BinData(128, E09F3C0000000000), BinData(128, E09F3FFFFFFFFFFF)]", "[BinData(128, E09F600000000000), BinData(128, E09F6FFFFFFFFFFF)]", "[BinData(128, E09F780000000000), BinData(128, E09F7BFFFFFFFFFF)]", "[BinData(128, E09F900000000000), BinData(128, E09F9FFFFFFFFFFF)]", "[BinData(128, E09FA40000000000), BinData(128, E09FA7FFFFFFFFFF)]", "[BinData(128, E09FB00000000000), BinData(128, E09FBFFFFFFFFFFF)]", "[BinData(128, E09FC00000000000), BinData(128, E09FCFFFFFFFFFFF)]", "[BinData(128, E09FD00000000000), BinData(128, E09FDFFFFFFFFFFF)]", "[BinData(128, E09FE00000000000), BinData(128, E09FEFFFFFFFFFFF)]", "[BinData(128, E09FF00000000000), BinData(128, E09FFFFFFFFFFFFF)]", "[BinData(128, E0B5100000000000), BinData(128, E0B51FFFFFFFFFFF)]", "[BinData(128, E0B5400000000000), BinData(128, E0B54FFFFFFFFFFF)]", "[BinData(128, E0B5500000000000), BinData(128, E0B55FFFFFFFFFFF)]", "[BinData(128, E0CA8A0000000000), BinData(128, E0CA8AFFFFFFFFFF)]", "[BinData(128, E0CAA00000000000), BinData(128, E0CAA3FFFFFFFFFF)]", "[BinData(128, E0CAA80000000000), BinData(128, E0CAABFFFFFFFFFF)]" ] } } }, { "stage" : "FETCH", "inputStage" : { "stage" : "IXSCAN", "filter" : { "TwoDKeyInRegionExpression" : true }, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "location" : [ "[BinData(128, E09F3B0000000000), BinData(128, E09F3BFFFFFFFFFF)]", "[BinData(128, E09F3C0000000000), BinData(128, E09F3FFFFFFFFFFF)]", "[BinData(128, E09F600000000000), BinData(128, E09F6FFFFFFFFFFF)]", "[BinData(128, E09F700000000000), BinData(128, E09F7FFFFFFFFFFF)]", "[BinData(128, E09F800000000000), BinData(128, E09F8FFFFFFFFFFF)]", "[BinData(128, E09F900000000000), BinData(128, E09F9FFFFFFFFFFF)]", "[BinData(128, E09FA00000000000), BinData(128, E09FAFFFFFFFFFFF)]", "[BinData(128, E09FB00000000000), BinData(128, E09FBFFFFFFFFFFF)]", "[BinData(128, E09FC00000000000), BinData(128, E09FFFFFFFFFFFFF)]", "[BinData(128, E0B5050000000000), BinData(128, E0B505FFFFFFFFFF)]", "[BinData(128, E0B5100000000000), BinData(128, E0B51FFFFFFFFFFF)]", "[BinData(128, E0B5354000000000), BinData(128, E0B5357FFFFFFFFF)]", "[BinData(128, E0B5400000000000), BinData(128, E0B57FFFFFFFFFFF)]", "[BinData(128, E0CA800000000000), BinData(128, E0CA8FFFFFFFFFFF)]", "[BinData(128, E0CAA00000000000), BinData(128, E0CAAFFFFFFFFFFF)]", "[BinData(128, E0E0000000000000), BinData(128, E0E003FFFFFFFFFF)]" ] } } }, { "stage" : "FETCH", "inputStage" : { "stage" : "IXSCAN", "filter" : { "TwoDKeyInRegionExpression" : true }, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "location" : [ "[BinData(128, E09F2C0000000000), BinData(128, E09F2FFFFFFFFFFF)]", "[BinData(128, E09F300000000000), BinData(128, E09F3FFFFFFFFFFF)]", "[BinData(128, E09F4B0000000000), BinData(128, E09F4BFFFFFFFFFF)]", "[BinData(128, E09F4C0000000000), BinData(128, E09F4FFFFFFFFFFF)]", "[BinData(128, E09F600000000000), BinData(128, E09F6FFFFFFFFFFF)]", "[BinData(128, E09F700000000000), BinData(128, E09F7FFFFFFFFFFF)]", "[BinData(128, E09F800000000000), BinData(128, E09FBFFFFFFFFFFF)]", "[BinData(128, E09FC00000000000), BinData(128, E09FFFFFFFFFFFFF)]", "[BinData(128, E0B5000000000000), BinData(128, E0B53FFFFFFFFFFF)]", "[BinData(128, E0B5400000000000), BinData(128, E0B57FFFFFFFFFFF)]", "[BinData(128, E0CA22AA80000000), BinData(128, E0CA22AABFFFFFFF)]", "[BinData(128, E0CA280000000000), BinData(128, E0CA2BFFFFFFFFFF)]", "[BinData(128, E0CA800000000000), BinData(128, E0CA8FFFFFFFFFFF)]", "[BinData(128, E0CAA00000000000), BinData(128, E0CAAFFFFFFFFFFF)]", "[BinData(128, E0E0000000000000), BinData(128, E0E00FFFFFFFFFFF)]", "[BinData(128, E0E0200000000000), BinData(128, E0E020FFFFFFFFFF)]" ] } } }, { "stage" : "FETCH", "inputStage" : { "stage" : "IXSCAN", "filter" : { "TwoDKeyInRegionExpression" : true }, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "location" : [ "[BinData(128, E09DBFFC00000000), BinData(128, E09DBFFFFFFFFFFF)]", "[BinData(128, E09DE00000000000), BinData(128, E09DEFFFFFFFFFFF)]", "[BinData(128, E09DFA8000000000), BinData(128, E09DFABFFFFFFFFF)]", "[BinData(128, E09E700000000000), BinData(128, E09E7FFFFFFFFFFF)]", "[BinData(128, E09EC00000000000), BinData(128, E09EFFFFFFFFFFFF)]", "[BinData(128, E09F000000000000), BinData(128, E09FFFFFFFFFFFFF)]", "[BinData(128, E0B4500000000000), BinData(128, E0B45FFFFFFFFFFF)]", "[BinData(128, E0B4700000000000), BinData(128, E0B47FFFFFFFFFFF)]", "[BinData(128, E0B5000000000000), BinData(128, E0B53FFFFFFFFFFF)]", "[BinData(128, E0B5400000000000), BinData(128, E0B57FFFFFFFFFFF)]", "[BinData(128, E0B5800000000000), BinData(128, E0B5BFFFFFFFFFFF)]", "[BinData(128, E0B5C00000000000), BinData(128, E0B5FFFFFFFFFFFF)]", "[BinData(128, E0CA000000000000), BinData(128, E0CA3FFFFFFFFFFF)]", "[BinData(128, E0CA800000000000), BinData(128, E0CABFFFFFFFFFFF)]", "[BinData(128, E0E0000000000000), BinData(128, E0E03FFFFFFFFFFF)]", "[BinData(128, E0E0800000000000), BinData(128, E0E08FFFFFFFFFFF)]" ] } } }, { "stage" : "FETCH", "inputStage" : { "stage" : "IXSCAN", "filter" : { "TwoDKeyInRegionExpression" : true }, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "location" : [ "[BinData(128, E09CC00000000000), BinData(128, E09CFFFFFFFFFFFF)]", "[BinData(128, E09D000000000000), BinData(128, E09DFFFFFFFFFFFF)]", "[BinData(128, E09E000000000000), BinData(128, E09EFFFFFFFFFFFF)]", "[BinData(128, E09F000000000000), BinData(128, E09FFFFFFFFFFFFF)]", "[BinData(128, E0B4000000000000), BinData(128, E0B4FFFFFFFFFFFF)]", "[BinData(128, E0B5000000000000), BinData(128, E0B5FFFFFFFFFFFF)]", "[BinData(128, E0B6550000000000), BinData(128, E0B655FFFFFFFFFF)]", "[BinData(128, E0B7000000000000), BinData(128, E0B70FFFFFFFFFFF)]", "[BinData(128, E0B7100000000000), BinData(128, E0B71FFFFFFFFFFF)]", "[BinData(128, E0B7400000000000), BinData(128, E0B74FFFFFFFFFFF)]", "[BinData(128, E0B7500000000000), BinData(128, E0B75FFFFFFFFFFF)]", "[BinData(128, E0C8800000000000), BinData(128, E0C8BFFFFFFFFFFF)]", "[BinData(128, E0C8E00000000000), BinData(128, E0C8EFFFFFFFFFFF)]", "[BinData(128, E0CA000000000000), BinData(128, E0CAFFFFFFFFFFFF)]", "[BinData(128, E0E0000000000000), BinData(128, E0E0FFFFFFFFFFFF)]", "[BinData(128, E0E2000000000000), BinData(128, E0E23FFFFFFFFFFF)]" ] } } }, { "stage" : "FETCH", "inputStage" : { "stage" : "IXSCAN", "filter" : { "TwoDKeyInRegionExpression" : true }, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "location" : [ "[BinData(128, E094000000000000), BinData(128, E097FFFFFFFFFFFF)]", "[BinData(128, E099000000000000), BinData(128, E099FFFFFFFFFFFF)]", "[BinData(128, E09B000000000000), BinData(128, E09BFFFFFFFFFFFF)]", "[BinData(128, E09C000000000000), BinData(128, E09FFFFFFFFFFFFF)]", "[BinData(128, E0B1000000000000), BinData(128, E0B1FFFFFFFFFFFF)]", "[BinData(128, E0B3000000000000), BinData(128, E0B3FFFFFFFFFFFF)]", "[BinData(128, E0B4000000000000), BinData(128, E0B7FFFFFFFFFFFF)]", "[BinData(128, E0BC400000000000), BinData(128, E0BC7FFFFFFFFFFF)]", "[BinData(128, E0BD000000000000), BinData(128, E0BDFFFFFFFFFFFF)]", "[BinData(128, E0C2000000000000), BinData(128, E0C2FFFFFFFFFFFF)]", "[BinData(128, E0C3A00000000000), BinData(128, E0C3AFFFFFFFFFFF)]", "[BinData(128, E0C8000000000000), BinData(128, E0CBFFFFFFFFFFFF)]", "[BinData(128, E0CE000000000000), BinData(128, E0CEFFFFFFFFFFFF)]", "[BinData(128, E0E0000000000000), BinData(128, E0E3FFFFFFFFFFFF)]", "[BinData(128, E0E4000000000000), BinData(128, E0E40FFFFFFFFFFF)]", "[BinData(128, E0E8000000000000), BinData(128, E0E8FFFFFFFFFFFF)]" ] } } }, { "stage" : "FETCH", "inputStage" : { "stage" : "IXSCAN", "filter" : { "TwoDKeyInRegionExpression" : true }, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "location" : [ "[BinData(128, E03B000000000000), BinData(128, E03BFFFFFFFFFFFF)]", "[BinData(128, E03C000000000000), BinData(128, E03FFFFFFFFFFFFF)]", "[BinData(128, E068000000000000), BinData(128, E06BFFFFFFFFFFFF)]", "[BinData(128, E087000000000000), BinData(128, E087FFFFFFFFFFFF)]", "[BinData(128, E08C000000000000), BinData(128, E08FFFFFFFFFFFFF)]", "[BinData(128, E090000000000000), BinData(128, E09FFFFFFFFFFFFF)]", "[BinData(128, E0A4000000000000), BinData(128, E0A7FFFFFFFFFFFF)]", "[BinData(128, E0AD400000000000), BinData(128, E0AD7FFFFFFFFFFF)]", "[BinData(128, E0B0000000000000), BinData(128, E0BFFFFFFFFFFFFF)]", "[BinData(128, E0C0000000000000), BinData(128, E0CFFFFFFFFFFFFF)]", "[BinData(128, E0D8000000000000), BinData(128, E0DBFFFFFFFFFFFF)]", "[BinData(128, E0E0000000000000), BinData(128, E0EFFFFFFFFFFFFF)]", "[BinData(128, E0F0000000000000), BinData(128, E0F0FFFFFFFFFFFF)]", "[BinData(128, E211555540000000), BinData(128, E21155557FFFFFFF)]", "[BinData(128, E214000000000000), BinData(128, E217FFFFFFFFFFFF)]", "[BinData(128, E240000000000000), BinData(128, E243FFFFFFFFFFFF)]" ] } } }, { "stage" : "FETCH", "inputStage" : { "stage" : "IXSCAN", "filter" : { "TwoDKeyInRegionExpression" : true }, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "location" : [ "[BinData(128, B57FC00000000000), BinData(128, B57FFFFFFFFFFFFF)]", "[BinData(128, B5D0000000000000), BinData(128, B5DFFFFFFFFFFFFF)]", "[BinData(128, B5F0000000000000), BinData(128, B5FFFFFFFFFFFFFF)]", "[BinData(128, E000000000000000), BinData(128, E03FFFFFFFFFFFFF)]", "[BinData(128, E040000000000000), BinData(128, E04FFFFFFFFFFFFF)]", "[BinData(128, E060000000000000), BinData(128, E06FFFFFFFFFFFFF)]", "[BinData(128, E070000000000000), BinData(128, E07FFFFFFFFFFFFF)]", "[BinData(128, E080000000000000), BinData(128, E0BFFFFFFFFFFFFF)]", "[BinData(128, E0C0000000000000), BinData(128, E0FFFFFFFFFFFFFF)]", "[BinData(128, E180000000000000), BinData(128, E18FFFFFFFFFFFFF)]", "[BinData(128, E1A0000000000000), BinData(128, E1AFFFFFFFFFFFFF)]", "[BinData(128, E200000000000000), BinData(128, E20FFFFFFFFFFFFF)]", "[BinData(128, E210000000000000), BinData(128, E21FFFFFFFFFFFFF)]", "[BinData(128, E230000000000000), BinData(128, E233FFFFFFFFFFFF)]", "[BinData(128, E234000000000000), BinData(128, E237FFFFFFFFFFFF)]", "[BinData(128, E240000000000000), BinData(128, E27FFFFFFFFFFFFF)]" ] } } }, { "stage" : "FETCH", "inputStage" : { "stage" : "IXSCAN", "filter" : { "TwoDKeyInRegionExpression" : true }, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "location" : [ "[BinData(128, 9FEC000000000000), BinData(128, 9FEFFFFFFFFFFFFF)]", "[BinData(128, 9FF0000000000000), BinData(128, 9FFFFFFFFFFFFFFF)]", "[BinData(128, B500000000000000), BinData(128, B5FFFFFFFFFFFFFF)]", "[BinData(128, B710000000000000), BinData(128, B71FFFFFFFFFFFFF)]", "[BinData(128, B740000000000000), BinData(128, B77FFFFFFFFFFFFF)]", "[BinData(128, B7C5000000000000), BinData(128, B7C5FFFFFFFFFFFF)]", "[BinData(128, B7D0000000000000), BinData(128, B7DFFFFFFFFFFFFF)]", "[BinData(128, CA80000000000000), BinData(128, CABFFFFFFFFFFFFF)]", "[BinData(128, CAC0000000000000), BinData(128, CAFFFFFFFFFFFFFF)]", "[BinData(128, CB80000000000000), BinData(128, CBBFFFFFFFFFFFFF)]", "[BinData(128, E000000000000000), BinData(128, E0FFFFFFFFFFFFFF)]", "[BinData(128, E100000000000000), BinData(128, E1FFFFFFFFFFFFFF)]", "[BinData(128, E200000000000000), BinData(128, E2FFFFFFFFFFFFFF)]", "[BinData(128, E300000000000000), BinData(128, E33FFFFFFFFFFFFF)]", "[BinData(128, E340000000000000), BinData(128, E343FFFFFFFFFFFF)]", "[BinData(128, E380000000000000), BinData(128, E3BFFFFFFFFFFFFF)]" ] } } }, { "stage" : "FETCH", "inputStage" : { "stage" : "IXSCAN", "filter" : { "TwoDKeyInRegionExpression" : true }, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "location" : [ "[BinData(128, 9D00000000000000), BinData(128, 9DFFFFFFFFFFFFFF)]", "[BinData(128, 9E00000000000000), BinData(128, 9EFFFFFFFFFFFFFF)]", "[BinData(128, 9F00000000000000), BinData(128, 9FFFFFFFFFFFFFFF)]", "[BinData(128, B400000000000000), BinData(128, B7FFFFFFFFFFFFFF)]", "[BinData(128, BC40000000000000), BinData(128, BC7FFFFFFFFFFFFF)]", "[BinData(128, BD00000000000000), BinData(128, BDFFFFFFFFFFFFFF)]", "[BinData(128, C800000000000000), BinData(128, CBFFFFFFFFFFFFFF)]", "[BinData(128, CE00000000000000), BinData(128, CEFFFFFFFFFFFFFF)]", "[BinData(128, E000000000000000), BinData(128, E3FFFFFFFFFFFFFF)]", "[BinData(128, E400000000000000), BinData(128, E4FFFFFFFFFFFFFF)]", "[BinData(128, E600000000000000), BinData(128, E6FFFFFFFFFFFFFF)]", "[BinData(128, E800000000000000), BinData(128, E8FFFFFFFFFFFFFF)]", "[BinData(128, E900000000000000), BinData(128, E9FFFFFFFFFFFFFF)]", "[BinData(128, EA00000000000000), BinData(128, EA3FFFFFFFFFFFFF)]", "[BinData(128, EA40000000000000), BinData(128, EA7FFFFFFFFFFFFF)]", "[BinData(128, EC00000000000000), BinData(128, EC3FFFFFFFFFFFFF)]" ] } } }, { "stage" : "FETCH", "inputStage" : { "stage" : "IXSCAN", "filter" : { "TwoDKeyInRegionExpression" : true }, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "location" : [ "[BinData(128, 3B00000000000000), BinData(128, 3BFFFFFFFFFFFFFF)]", "[BinData(128, 3C00000000000000), BinData(128, 3FFFFFFFFFFFFFFF)]", "[BinData(128, 6800000000000000), BinData(128, 6BFFFFFFFFFFFFFF)]", "[BinData(128, 6C00000000000000), BinData(128, 6FFFFFFFFFFFFFFF)]", "[BinData(128, 8400000000000000), BinData(128, 87FFFFFFFFFFFFFF)]", "[BinData(128, 8C00000000000000), BinData(128, 8FFFFFFFFFFFFFFF)]", "[BinData(128, 9000000000000000), BinData(128, 9FFFFFFFFFFFFFFF)]", "[BinData(128, A400000000000000), BinData(128, A7FFFFFFFFFFFFFF)]", "[BinData(128, AC00000000000000), BinData(128, AFFFFFFFFFFFFFFF)]", "[BinData(128, B000000000000000), BinData(128, BFFFFFFFFFFFFFFF)]", "[BinData(128, C000000000000000), BinData(128, CFFFFFFFFFFFFFFF)]", "[BinData(128, D000000000000000), BinData(128, D3FFFFFFFFFFFFFF)]", "[BinData(128, D800000000000000), BinData(128, DBFFFFFFFFFFFFFF)]", "[BinData(128, DC00000000000000), BinData(128, DFFFFFFFFFFFFFFF)]", "[BinData(128, E000000000000000), BinData(128, EFFFFFFFFFFFFFFF)]", "[BinData(128, F000000000000000), BinData(128, FFFFFFFFFFFFFFFF)]" ] } } }, { "stage" : "FETCH", "inputStage" : { "stage" : "IXSCAN", "filter" : { "TwoDKeyInRegionExpression" : true }, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "location" : [ "[BinData(128, 0000000000000000), BinData(128, FFFFFFFFFFFFFFFF)]" ] } } }, { "stage" : "FETCH", "inputStage" : { "stage" : "IXSCAN", "filter" : { "TwoDKeyInRegionExpression" : true }, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "location" : [ "[BinData(128, 0000000000000000), BinData(128, FFFFFFFFFFFFFFFF)]" ] } } } ] }, "rejectedPlans" : [ ] }, "executionStats" : { "executionSuccess" : true, "nReturned" : 583104, "executionTimeMillis" : 28562, "totalKeysExamined" : 8163456, "totalDocsExamined" : 8163456, "executionStages" : { "stage" : "GEO_NEAR_2D", "nReturned" : 583104, "executionTimeMillisEstimate" : 27177, "works" : 8746590, "advanced" : 583104, "needTime" : 8163485, "needFetch" : 0, "saveState" : 68334, "restoreState" : 68334, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "searchIntervals" : [ { "minDistance" : 0, "maxDistance" : 20037.39210386106, "maxInclusive" : false }, { "minDistance" : 20037.39210386106, "maxDistance" : 30056.088155791593, "maxInclusive" : false }, { "minDistance" : 30056.088155791593, "maxDistance" : 35065.43618175686, "maxInclusive" : false }, { "minDistance" : 35065.43618175686, "maxDistance" : 45084.132233687385, "maxInclusive" : false }, { "minDistance" : 45084.132233687385, "maxDistance" : 65121.52433754844, "maxInclusive" : false }, { "minDistance" : 65121.52433754844, "maxDistance" : 105196.30854527056, "maxInclusive" : false }, { "minDistance" : 105196.30854527056, "maxDistance" : 185345.8769607148, "maxInclusive" : false }, { "minDistance" : 185345.8769607148, "maxDistance" : 345645.01379160327, "maxInclusive" : false }, { "minDistance" : 345645.01379160327, "maxDistance" : 666243.2874533802, "maxInclusive" : false }, { "minDistance" : 666243.2874533802, "maxDistance" : 1307439.8347769342, "maxInclusive" : false }, { "minDistance" : 1307439.8347769342, "maxDistance" : 2589832.929424042, "maxInclusive" : false }, { "minDistance" : 2589832.929424042, "maxDistance" : 5154619.118718257, "maxInclusive" : false }, { "minDistance" : 5154619.118718257, "maxDistance" : 10284191.49730669, "maxInclusive" : false }, { "minDistance" : 10284191.49730669, "maxDistance" : 20037392.10386106, "maxInclusive" : true } ], "inputStages" : [ { "stage" : "FETCH", "nReturned" : 583104, "executionTimeMillisEstimate" : 1090, "works" : 583105, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 68334, "restoreState" : 68334, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 583104, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "filter" : { "TwoDKeyInRegionExpression" : true }, "nReturned" : 583104, "executionTimeMillisEstimate" : 840, "works" : 583104, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 68334, "restoreState" : 68334, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "location" : [ "[BinData(128, E09F97C000000000), BinData(128, E09F97FFFFFFFFFF)]", "[BinData(128, E09F9C0000000000), BinData(128, E09F9FFFFFFFFFFF)]", "[BinData(128, E09FB40000000000), BinData(128, E09FB7FFFFFFFFFF)]", "[BinData(128, E09FBC0000000000), BinData(128, E09FBFFFFFFFFFFF)]", "[BinData(128, E09FC00000000000), BinData(128, E09FCFFFFFFFFFFF)]", "[BinData(128, E09FD28000000000), BinData(128, E09FD2BFFFFFFFFF)]", "[BinData(128, E09FD2E000000000), BinData(128, E09FD2EFFFFFFFFF)]", "[BinData(128, E09FD80000000000), BinData(128, E09FDBFFFFFFFFFF)]", "[BinData(128, E09FDE8000000000), BinData(128, E09FDEBFFFFFFFFF)]", "[BinData(128, E09FE00000000000), BinData(128, E09FEFFFFFFFFFFF)]", "[BinData(128, E09FF00000000000), BinData(128, E09FFFFFFFFFFFFF)]", "[BinData(128, E0B5150000000000), BinData(128, E0B515FFFFFFFFFF)]", "[BinData(128, E0B5400000000000), BinData(128, E0B543FFFFFFFFFF)]", "[BinData(128, E0B5440000000000), BinData(128, E0B547FFFFFFFFFF)]", "[BinData(128, E0B5500000000000), BinData(128, E0B550FFFFFFFFFF)]", "[BinData(128, E0B5510000000000), BinData(128, E0B5513FFFFFFFFF)]" ] }, "keysExamined" : 583104, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 583104 } }, { "stage" : "FETCH", "nReturned" : 583104, "executionTimeMillisEstimate" : 1110, "works" : 583105, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 59279, "restoreState" : 59279, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 583104, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "filter" : { "TwoDKeyInRegionExpression" : true }, "nReturned" : 583104, "executionTimeMillisEstimate" : 760, "works" : 583104, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 59279, "restoreState" : 59279, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "location" : [ "[BinData(128, E09F3C0000000000), BinData(128, E09F3FFFFFFFFFFF)]", "[BinData(128, E09F600000000000), BinData(128, E09F6FFFFFFFFFFF)]", "[BinData(128, E09F780000000000), BinData(128, E09F7BFFFFFFFFFF)]", "[BinData(128, E09F900000000000), BinData(128, E09F9FFFFFFFFFFF)]", "[BinData(128, E09FA40000000000), BinData(128, E09FA7FFFFFFFFFF)]", "[BinData(128, E09FB00000000000), BinData(128, E09FBFFFFFFFFFFF)]", "[BinData(128, E09FC00000000000), BinData(128, E09FCFFFFFFFFFFF)]", "[BinData(128, E09FD00000000000), BinData(128, E09FDFFFFFFFFFFF)]", "[BinData(128, E09FE00000000000), BinData(128, E09FEFFFFFFFFFFF)]", "[BinData(128, E09FF00000000000), BinData(128, E09FFFFFFFFFFFFF)]", "[BinData(128, E0B5100000000000), BinData(128, E0B51FFFFFFFFFFF)]", "[BinData(128, E0B5400000000000), BinData(128, E0B54FFFFFFFFFFF)]", "[BinData(128, E0B5500000000000), BinData(128, E0B55FFFFFFFFFFF)]", "[BinData(128, E0CA8A0000000000), BinData(128, E0CA8AFFFFFFFFFF)]", "[BinData(128, E0CAA00000000000), BinData(128, E0CAA3FFFFFFFFFF)]", "[BinData(128, E0CAA80000000000), BinData(128, E0CAABFFFFFFFFFF)]" ] }, "keysExamined" : 583104, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 583104 } }, { "stage" : "FETCH", "nReturned" : 583104, "executionTimeMillisEstimate" : 970, "works" : 583105, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 54667, "restoreState" : 54667, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 583104, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "filter" : { "TwoDKeyInRegionExpression" : true }, "nReturned" : 583104, "executionTimeMillisEstimate" : 710, "works" : 583104, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 54667, "restoreState" : 54667, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "location" : [ "[BinData(128, E09F3B0000000000), BinData(128, E09F3BFFFFFFFFFF)]", "[BinData(128, E09F3C0000000000), BinData(128, E09F3FFFFFFFFFFF)]", "[BinData(128, E09F600000000000), BinData(128, E09F6FFFFFFFFFFF)]", "[BinData(128, E09F700000000000), BinData(128, E09F7FFFFFFFFFFF)]", "[BinData(128, E09F800000000000), BinData(128, E09F8FFFFFFFFFFF)]", "[BinData(128, E09F900000000000), BinData(128, E09F9FFFFFFFFFFF)]", "[BinData(128, E09FA00000000000), BinData(128, E09FAFFFFFFFFFFF)]", "[BinData(128, E09FB00000000000), BinData(128, E09FBFFFFFFFFFFF)]", "[BinData(128, E09FC00000000000), BinData(128, E09FFFFFFFFFFFFF)]", "[BinData(128, E0B5050000000000), BinData(128, E0B505FFFFFFFFFF)]", "[BinData(128, E0B5100000000000), BinData(128, E0B51FFFFFFFFFFF)]", "[BinData(128, E0B5354000000000), BinData(128, E0B5357FFFFFFFFF)]", "[BinData(128, E0B5400000000000), BinData(128, E0B57FFFFFFFFFFF)]", "[BinData(128, E0CA800000000000), BinData(128, E0CA8FFFFFFFFFFF)]", "[BinData(128, E0CAA00000000000), BinData(128, E0CAAFFFFFFFFFFF)]", "[BinData(128, E0E0000000000000), BinData(128, E0E003FFFFFFFFFF)]" ] }, "keysExamined" : 583104, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 583104 } }, { "stage" : "FETCH", "nReturned" : 583104, "executionTimeMillisEstimate" : 904, "works" : 583105, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 50111, "restoreState" : 50111, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 583104, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "filter" : { "TwoDKeyInRegionExpression" : true }, "nReturned" : 583104, "executionTimeMillisEstimate" : 694, "works" : 583104, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 50111, "restoreState" : 50111, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "location" : [ "[BinData(128, E09F2C0000000000), BinData(128, E09F2FFFFFFFFFFF)]", "[BinData(128, E09F300000000000), BinData(128, E09F3FFFFFFFFFFF)]", "[BinData(128, E09F4B0000000000), BinData(128, E09F4BFFFFFFFFFF)]", "[BinData(128, E09F4C0000000000), BinData(128, E09F4FFFFFFFFFFF)]", "[BinData(128, E09F600000000000), BinData(128, E09F6FFFFFFFFFFF)]", "[BinData(128, E09F700000000000), BinData(128, E09F7FFFFFFFFFFF)]", "[BinData(128, E09F800000000000), BinData(128, E09FBFFFFFFFFFFF)]", "[BinData(128, E09FC00000000000), BinData(128, E09FFFFFFFFFFFFF)]", "[BinData(128, E0B5000000000000), BinData(128, E0B53FFFFFFFFFFF)]", "[BinData(128, E0B5400000000000), BinData(128, E0B57FFFFFFFFFFF)]", "[BinData(128, E0CA22AA80000000), BinData(128, E0CA22AABFFFFFFF)]", "[BinData(128, E0CA280000000000), BinData(128, E0CA2BFFFFFFFFFF)]", "[BinData(128, E0CA800000000000), BinData(128, E0CA8FFFFFFFFFFF)]", "[BinData(128, E0CAA00000000000), BinData(128, E0CAAFFFFFFFFFFF)]", "[BinData(128, E0E0000000000000), BinData(128, E0E00FFFFFFFFFFF)]", "[BinData(128, E0E0200000000000), BinData(128, E0E020FFFFFFFFFF)]" ] }, "keysExamined" : 583104, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 583104 } }, { "stage" : "FETCH", "nReturned" : 583104, "executionTimeMillisEstimate" : 900, "works" : 583105, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 45556, "restoreState" : 45556, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 583104, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "filter" : { "TwoDKeyInRegionExpression" : true }, "nReturned" : 583104, "executionTimeMillisEstimate" : 610, "works" : 583104, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 45556, "restoreState" : 45556, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "location" : [ "[BinData(128, E09DBFFC00000000), BinData(128, E09DBFFFFFFFFFFF)]", "[BinData(128, E09DE00000000000), BinData(128, E09DEFFFFFFFFFFF)]", "[BinData(128, E09DFA8000000000), BinData(128, E09DFABFFFFFFFFF)]", "[BinData(128, E09E700000000000), BinData(128, E09E7FFFFFFFFFFF)]", "[BinData(128, E09EC00000000000), BinData(128, E09EFFFFFFFFFFFF)]", "[BinData(128, E09F000000000000), BinData(128, E09FFFFFFFFFFFFF)]", "[BinData(128, E0B4500000000000), BinData(128, E0B45FFFFFFFFFFF)]", "[BinData(128, E0B4700000000000), BinData(128, E0B47FFFFFFFFFFF)]", "[BinData(128, E0B5000000000000), BinData(128, E0B53FFFFFFFFFFF)]", "[BinData(128, E0B5400000000000), BinData(128, E0B57FFFFFFFFFFF)]", "[BinData(128, E0B5800000000000), BinData(128, E0B5BFFFFFFFFFFF)]", "[BinData(128, E0B5C00000000000), BinData(128, E0B5FFFFFFFFFFFF)]", "[BinData(128, E0CA000000000000), BinData(128, E0CA3FFFFFFFFFFF)]", "[BinData(128, E0CA800000000000), BinData(128, E0CABFFFFFFFFFFF)]", "[BinData(128, E0E0000000000000), BinData(128, E0E03FFFFFFFFFFF)]", "[BinData(128, E0E0800000000000), BinData(128, E0E08FFFFFFFFFFF)]" ] }, "keysExamined" : 583104, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 583104 } }, { "stage" : "FETCH", "nReturned" : 583104, "executionTimeMillisEstimate" : 950, "works" : 583105, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 41000, "restoreState" : 41000, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 583104, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "filter" : { "TwoDKeyInRegionExpression" : true }, "nReturned" : 583104, "executionTimeMillisEstimate" : 740, "works" : 583104, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 41000, "restoreState" : 41000, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "location" : [ "[BinData(128, E09CC00000000000), BinData(128, E09CFFFFFFFFFFFF)]", "[BinData(128, E09D000000000000), BinData(128, E09DFFFFFFFFFFFF)]", "[BinData(128, E09E000000000000), BinData(128, E09EFFFFFFFFFFFF)]", "[BinData(128, E09F000000000000), BinData(128, E09FFFFFFFFFFFFF)]", "[BinData(128, E0B4000000000000), BinData(128, E0B4FFFFFFFFFFFF)]", "[BinData(128, E0B5000000000000), BinData(128, E0B5FFFFFFFFFFFF)]", "[BinData(128, E0B6550000000000), BinData(128, E0B655FFFFFFFFFF)]", "[BinData(128, E0B7000000000000), BinData(128, E0B70FFFFFFFFFFF)]", "[BinData(128, E0B7100000000000), BinData(128, E0B71FFFFFFFFFFF)]", "[BinData(128, E0B7400000000000), BinData(128, E0B74FFFFFFFFFFF)]", "[BinData(128, E0B7500000000000), BinData(128, E0B75FFFFFFFFFFF)]", "[BinData(128, E0C8800000000000), BinData(128, E0C8BFFFFFFFFFFF)]", "[BinData(128, E0C8E00000000000), BinData(128, E0C8EFFFFFFFFFFF)]", "[BinData(128, E0CA000000000000), BinData(128, E0CAFFFFFFFFFFFF)]", "[BinData(128, E0E0000000000000), BinData(128, E0E0FFFFFFFFFFFF)]", "[BinData(128, E0E2000000000000), BinData(128, E0E23FFFFFFFFFFF)]" ] }, "keysExamined" : 583104, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 583104 } }, { "stage" : "FETCH", "nReturned" : 583104, "executionTimeMillisEstimate" : 830, "works" : 583105, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 36445, "restoreState" : 36445, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 583104, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "filter" : { "TwoDKeyInRegionExpression" : true }, "nReturned" : 583104, "executionTimeMillisEstimate" : 570, "works" : 583104, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 36445, "restoreState" : 36445, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "location" : [ "[BinData(128, E094000000000000), BinData(128, E097FFFFFFFFFFFF)]", "[BinData(128, E099000000000000), BinData(128, E099FFFFFFFFFFFF)]", "[BinData(128, E09B000000000000), BinData(128, E09BFFFFFFFFFFFF)]", "[BinData(128, E09C000000000000), BinData(128, E09FFFFFFFFFFFFF)]", "[BinData(128, E0B1000000000000), BinData(128, E0B1FFFFFFFFFFFF)]", "[BinData(128, E0B3000000000000), BinData(128, E0B3FFFFFFFFFFFF)]", "[BinData(128, E0B4000000000000), BinData(128, E0B7FFFFFFFFFFFF)]", "[BinData(128, E0BC400000000000), BinData(128, E0BC7FFFFFFFFFFF)]", "[BinData(128, E0BD000000000000), BinData(128, E0BDFFFFFFFFFFFF)]", "[BinData(128, E0C2000000000000), BinData(128, E0C2FFFFFFFFFFFF)]", "[BinData(128, E0C3A00000000000), BinData(128, E0C3AFFFFFFFFFFF)]", "[BinData(128, E0C8000000000000), BinData(128, E0CBFFFFFFFFFFFF)]", "[BinData(128, E0CE000000000000), BinData(128, E0CEFFFFFFFFFFFF)]", "[BinData(128, E0E0000000000000), BinData(128, E0E3FFFFFFFFFFFF)]", "[BinData(128, E0E4000000000000), BinData(128, E0E40FFFFFFFFFFF)]", "[BinData(128, E0E8000000000000), BinData(128, E0E8FFFFFFFFFFFF)]" ] }, "keysExamined" : 583104, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 583104 } }, { "stage" : "FETCH", "nReturned" : 583104, "executionTimeMillisEstimate" : 1060, "works" : 583105, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 31889, "restoreState" : 31889, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 583104, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "filter" : { "TwoDKeyInRegionExpression" : true }, "nReturned" : 583104, "executionTimeMillisEstimate" : 780, "works" : 583104, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 31889, "restoreState" : 31889, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "location" : [ "[BinData(128, E03B000000000000), BinData(128, E03BFFFFFFFFFFFF)]", "[BinData(128, E03C000000000000), BinData(128, E03FFFFFFFFFFFFF)]", "[BinData(128, E068000000000000), BinData(128, E06BFFFFFFFFFFFF)]", "[BinData(128, E087000000000000), BinData(128, E087FFFFFFFFFFFF)]", "[BinData(128, E08C000000000000), BinData(128, E08FFFFFFFFFFFFF)]", "[BinData(128, E090000000000000), BinData(128, E09FFFFFFFFFFFFF)]", "[BinData(128, E0A4000000000000), BinData(128, E0A7FFFFFFFFFFFF)]", "[BinData(128, E0AD400000000000), BinData(128, E0AD7FFFFFFFFFFF)]", "[BinData(128, E0B0000000000000), BinData(128, E0BFFFFFFFFFFFFF)]", "[BinData(128, E0C0000000000000), BinData(128, E0CFFFFFFFFFFFFF)]", "[BinData(128, E0D8000000000000), BinData(128, E0DBFFFFFFFFFFFF)]", "[BinData(128, E0E0000000000000), BinData(128, E0EFFFFFFFFFFFFF)]", "[BinData(128, E0F0000000000000), BinData(128, E0F0FFFFFFFFFFFF)]", "[BinData(128, E211555540000000), BinData(128, E21155557FFFFFFF)]", "[BinData(128, E214000000000000), BinData(128, E217FFFFFFFFFFFF)]", "[BinData(128, E240000000000000), BinData(128, E243FFFFFFFFFFFF)]" ] }, "keysExamined" : 583104, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 583104 } }, { "stage" : "FETCH", "nReturned" : 583104, "executionTimeMillisEstimate" : 926, "works" : 583105, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 27334, "restoreState" : 27334, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 583104, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "filter" : { "TwoDKeyInRegionExpression" : true }, "nReturned" : 583104, "executionTimeMillisEstimate" : 716, "works" : 583104, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 27334, "restoreState" : 27334, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "location" : [ "[BinData(128, B57FC00000000000), BinData(128, B57FFFFFFFFFFFFF)]", "[BinData(128, B5D0000000000000), BinData(128, B5DFFFFFFFFFFFFF)]", "[BinData(128, B5F0000000000000), BinData(128, B5FFFFFFFFFFFFFF)]", "[BinData(128, E000000000000000), BinData(128, E03FFFFFFFFFFFFF)]", "[BinData(128, E040000000000000), BinData(128, E04FFFFFFFFFFFFF)]", "[BinData(128, E060000000000000), BinData(128, E06FFFFFFFFFFFFF)]", "[BinData(128, E070000000000000), BinData(128, E07FFFFFFFFFFFFF)]", "[BinData(128, E080000000000000), BinData(128, E0BFFFFFFFFFFFFF)]", "[BinData(128, E0C0000000000000), BinData(128, E0FFFFFFFFFFFFFF)]", "[BinData(128, E180000000000000), BinData(128, E18FFFFFFFFFFFFF)]", "[BinData(128, E1A0000000000000), BinData(128, E1AFFFFFFFFFFFFF)]", "[BinData(128, E200000000000000), BinData(128, E20FFFFFFFFFFFFF)]", "[BinData(128, E210000000000000), BinData(128, E21FFFFFFFFFFFFF)]", "[BinData(128, E230000000000000), BinData(128, E233FFFFFFFFFFFF)]", "[BinData(128, E234000000000000), BinData(128, E237FFFFFFFFFFFF)]", "[BinData(128, E240000000000000), BinData(128, E27FFFFFFFFFFFFF)]" ] }, "keysExamined" : 583104, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 583104 } }, { "stage" : "FETCH", "nReturned" : 583104, "executionTimeMillisEstimate" : 840, "works" : 583105, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 22778, "restoreState" : 22778, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 583104, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "filter" : { "TwoDKeyInRegionExpression" : true }, "nReturned" : 583104, "executionTimeMillisEstimate" : 580, "works" : 583104, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 22778, "restoreState" : 22778, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "location" : [ "[BinData(128, 9FEC000000000000), BinData(128, 9FEFFFFFFFFFFFFF)]", "[BinData(128, 9FF0000000000000), BinData(128, 9FFFFFFFFFFFFFFF)]", "[BinData(128, B500000000000000), BinData(128, B5FFFFFFFFFFFFFF)]", "[BinData(128, B710000000000000), BinData(128, B71FFFFFFFFFFFFF)]", "[BinData(128, B740000000000000), BinData(128, B77FFFFFFFFFFFFF)]", "[BinData(128, B7C5000000000000), BinData(128, B7C5FFFFFFFFFFFF)]", "[BinData(128, B7D0000000000000), BinData(128, B7DFFFFFFFFFFFFF)]", "[BinData(128, CA80000000000000), BinData(128, CABFFFFFFFFFFFFF)]", "[BinData(128, CAC0000000000000), BinData(128, CAFFFFFFFFFFFFFF)]", "[BinData(128, CB80000000000000), BinData(128, CBBFFFFFFFFFFFFF)]", "[BinData(128, E000000000000000), BinData(128, E0FFFFFFFFFFFFFF)]", "[BinData(128, E100000000000000), BinData(128, E1FFFFFFFFFFFFFF)]", "[BinData(128, E200000000000000), BinData(128, E2FFFFFFFFFFFFFF)]", "[BinData(128, E300000000000000), BinData(128, E33FFFFFFFFFFFFF)]", "[BinData(128, E340000000000000), BinData(128, E343FFFFFFFFFFFF)]", "[BinData(128, E380000000000000), BinData(128, E3BFFFFFFFFFFFFF)]" ] }, "keysExamined" : 583104, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 583104 } }, { "stage" : "FETCH", "nReturned" : 583104, "executionTimeMillisEstimate" : 1184, "works" : 583105, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 18223, "restoreState" : 18223, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 583104, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "filter" : { "TwoDKeyInRegionExpression" : true }, "nReturned" : 583104, "executionTimeMillisEstimate" : 954, "works" : 583104, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 18223, "restoreState" : 18223, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "location" : [ "[BinData(128, 9D00000000000000), BinData(128, 9DFFFFFFFFFFFFFF)]", "[BinData(128, 9E00000000000000), BinData(128, 9EFFFFFFFFFFFFFF)]", "[BinData(128, 9F00000000000000), BinData(128, 9FFFFFFFFFFFFFFF)]", "[BinData(128, B400000000000000), BinData(128, B7FFFFFFFFFFFFFF)]", "[BinData(128, BC40000000000000), BinData(128, BC7FFFFFFFFFFFFF)]", "[BinData(128, BD00000000000000), BinData(128, BDFFFFFFFFFFFFFF)]", "[BinData(128, C800000000000000), BinData(128, CBFFFFFFFFFFFFFF)]", "[BinData(128, CE00000000000000), BinData(128, CEFFFFFFFFFFFFFF)]", "[BinData(128, E000000000000000), BinData(128, E3FFFFFFFFFFFFFF)]", "[BinData(128, E400000000000000), BinData(128, E4FFFFFFFFFFFFFF)]", "[BinData(128, E600000000000000), BinData(128, E6FFFFFFFFFFFFFF)]", "[BinData(128, E800000000000000), BinData(128, E8FFFFFFFFFFFFFF)]", "[BinData(128, E900000000000000), BinData(128, E9FFFFFFFFFFFFFF)]", "[BinData(128, EA00000000000000), BinData(128, EA3FFFFFFFFFFFFF)]", "[BinData(128, EA40000000000000), BinData(128, EA7FFFFFFFFFFFFF)]", "[BinData(128, EC00000000000000), BinData(128, EC3FFFFFFFFFFFFF)]" ] }, "keysExamined" : 583104, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 583104 } }, { "stage" : "FETCH", "nReturned" : 583104, "executionTimeMillisEstimate" : 1070, "works" : 583105, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 13667, "restoreState" : 13667, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 583104, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "filter" : { "TwoDKeyInRegionExpression" : true }, "nReturned" : 583104, "executionTimeMillisEstimate" : 740, "works" : 583104, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 13667, "restoreState" : 13667, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "location" : [ "[BinData(128, 3B00000000000000), BinData(128, 3BFFFFFFFFFFFFFF)]", "[BinData(128, 3C00000000000000), BinData(128, 3FFFFFFFFFFFFFFF)]", "[BinData(128, 6800000000000000), BinData(128, 6BFFFFFFFFFFFFFF)]", "[BinData(128, 6C00000000000000), BinData(128, 6FFFFFFFFFFFFFFF)]", "[BinData(128, 8400000000000000), BinData(128, 87FFFFFFFFFFFFFF)]", "[BinData(128, 8C00000000000000), BinData(128, 8FFFFFFFFFFFFFFF)]", "[BinData(128, 9000000000000000), BinData(128, 9FFFFFFFFFFFFFFF)]", "[BinData(128, A400000000000000), BinData(128, A7FFFFFFFFFFFFFF)]", "[BinData(128, AC00000000000000), BinData(128, AFFFFFFFFFFFFFFF)]", "[BinData(128, B000000000000000), BinData(128, BFFFFFFFFFFFFFFF)]", "[BinData(128, C000000000000000), BinData(128, CFFFFFFFFFFFFFFF)]", "[BinData(128, D000000000000000), BinData(128, D3FFFFFFFFFFFFFF)]", "[BinData(128, D800000000000000), BinData(128, DBFFFFFFFFFFFFFF)]", "[BinData(128, DC00000000000000), BinData(128, DFFFFFFFFFFFFFFF)]", "[BinData(128, E000000000000000), BinData(128, EFFFFFFFFFFFFFFF)]", "[BinData(128, F000000000000000), BinData(128, FFFFFFFFFFFFFFFF)]" ] }, "keysExamined" : 583104, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 583104 } }, { "stage" : "FETCH", "nReturned" : 583104, "executionTimeMillisEstimate" : 920, "works" : 583105, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 9111, "restoreState" : 9111, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 583104, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "filter" : { "TwoDKeyInRegionExpression" : true }, "nReturned" : 583104, "executionTimeMillisEstimate" : 630, "works" : 583104, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 9111, "restoreState" : 9111, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "location" : [ "[BinData(128, 0000000000000000), BinData(128, FFFFFFFFFFFFFFFF)]" ] }, "keysExamined" : 583104, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 583104 } }, { "stage" : "FETCH", "nReturned" : 583104, "executionTimeMillisEstimate" : 870, "works" : 583105, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 4556, "restoreState" : 4556, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 583104, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "filter" : { "TwoDKeyInRegionExpression" : true }, "nReturned" : 583104, "executionTimeMillisEstimate" : 620, "works" : 583104, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 4556, "restoreState" : 4556, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d", "isMultiKey" : false, "direction" : "forward", "indexBounds" : { "location" : [ "[BinData(128, 0000000000000000), BinData(128, FFFFFFFFFFFFFFFF)]" ] }, "keysExamined" : 583104, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 583104 } } ] } }, "serverInfo" : { "host" : "some_host", "port" : 27017, "version" : "3.0.0-rc11", "gitVersion" : "709cafbbb86c994bc153df189ace58a9c2e4145b" }, "ok" : 1 }
ShowStart with a collection with a ~500k documents Unable to find source-code formatter for language: javascript. Available languages are: actionscript, ada, applescript, bash, c, c#, c++, cpp, css, erlang, go, groovy, haskell, html, java, javascript, js, json, lua, none, nyan, objc, perl, php, python, r, rainbow, ruby, scala, sh, sql, swift, visualbasic, xml, yaml db.getCollection( "some_collection:Place" ).count() 583104 2.6.5 nearSphere query with explain() > db.getCollection( "some_collection:Place" ).find({location: { $nearSphere: [ 106.6331, 10.7395 ] }}).explain() { "cursor" : "GeoSearchCursor" , "isMultiKey" : false , "n" : 100, "nscannedObjects" : 599, "nscanned" : 3692, "nscannedObjectsAllPlans" : 599, "nscannedAllPlans" : 3692, "scanAndOrder" : false , "indexOnly" : false , "nYields" : 0, "nChunkSkips" : 0, "millis" : 5, "indexBounds" : { } Run same query with explain("executionStats") on 3.0.0-rc11 db.getCollection( "some_collection:Place" ).find({location: { $nearSphere: [ 106.6331, 10.7395 ] }}).explain( "executionStats" ) { "queryPlanner" : { "plannerVersion" : 1, "namespace" : "test.some_collection:Place" , "indexFilterSet" : false , "parsedQuery" : { "location" : { "$nearSphere" : [ 106.6331, 10.7395 ] } }, "winningPlan" : { "stage" : "GEO_NEAR_2D" , "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "inputStages" : [ { "stage" : "FETCH" , "inputStage" : { "stage" : "IXSCAN" , "filter" : { "TwoDKeyInRegionExpression" : true }, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "isMultiKey" : false , "direction" : "forward" , "indexBounds" : { "location" : [ "[BinData(128, E09F97C000000000), BinData(128, E09F97FFFFFFFFFF)]" , "[BinData(128, E09F9C0000000000), BinData(128, E09F9FFFFFFFFFFF)]" , "[BinData(128, E09FB40000000000), BinData(128, E09FB7FFFFFFFFFF)]" , "[BinData(128, E09FBC0000000000), BinData(128, E09FBFFFFFFFFFFF)]" , "[BinData(128, E09FC00000000000), BinData(128, E09FCFFFFFFFFFFF)]" , "[BinData(128, E09FD28000000000), BinData(128, E09FD2BFFFFFFFFF)]" , "[BinData(128, E09FD2E000000000), BinData(128, E09FD2EFFFFFFFFF)]" , "[BinData(128, E09FD80000000000), BinData(128, E09FDBFFFFFFFFFF)]" , "[BinData(128, E09FDE8000000000), BinData(128, E09FDEBFFFFFFFFF)]" , "[BinData(128, E09FE00000000000), BinData(128, E09FEFFFFFFFFFFF)]" , "[BinData(128, E09FF00000000000), BinData(128, E09FFFFFFFFFFFFF)]" , "[BinData(128, E0B5150000000000), BinData(128, E0B515FFFFFFFFFF)]" , "[BinData(128, E0B5400000000000), BinData(128, E0B543FFFFFFFFFF)]" , "[BinData(128, E0B5440000000000), BinData(128, E0B547FFFFFFFFFF)]" , "[BinData(128, E0B5500000000000), BinData(128, E0B550FFFFFFFFFF)]" , "[BinData(128, E0B5510000000000), BinData(128, E0B5513FFFFFFFFF)]" ] } } }, { "stage" : "FETCH" , "inputStage" : { "stage" : "IXSCAN" , "filter" : { "TwoDKeyInRegionExpression" : true }, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "isMultiKey" : false , "direction" : "forward" , "indexBounds" : { "location" : [ "[BinData(128, E09F3C0000000000), BinData(128, E09F3FFFFFFFFFFF)]" , "[BinData(128, E09F600000000000), BinData(128, E09F6FFFFFFFFFFF)]" , "[BinData(128, E09F780000000000), BinData(128, E09F7BFFFFFFFFFF)]" , "[BinData(128, E09F900000000000), BinData(128, E09F9FFFFFFFFFFF)]" , "[BinData(128, E09FA40000000000), BinData(128, E09FA7FFFFFFFFFF)]" , "[BinData(128, E09FB00000000000), BinData(128, E09FBFFFFFFFFFFF)]" , "[BinData(128, E09FC00000000000), BinData(128, E09FCFFFFFFFFFFF)]" , "[BinData(128, E09FD00000000000), BinData(128, E09FDFFFFFFFFFFF)]" , "[BinData(128, E09FE00000000000), BinData(128, E09FEFFFFFFFFFFF)]" , "[BinData(128, E09FF00000000000), BinData(128, E09FFFFFFFFFFFFF)]" , "[BinData(128, E0B5100000000000), BinData(128, E0B51FFFFFFFFFFF)]" , "[BinData(128, E0B5400000000000), BinData(128, E0B54FFFFFFFFFFF)]" , "[BinData(128, E0B5500000000000), BinData(128, E0B55FFFFFFFFFFF)]" , "[BinData(128, E0CA8A0000000000), BinData(128, E0CA8AFFFFFFFFFF)]" , "[BinData(128, E0CAA00000000000), BinData(128, E0CAA3FFFFFFFFFF)]" , "[BinData(128, E0CAA80000000000), BinData(128, E0CAABFFFFFFFFFF)]" ] } } }, { "stage" : "FETCH" , "inputStage" : { "stage" : "IXSCAN" , "filter" : { "TwoDKeyInRegionExpression" : true }, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "isMultiKey" : false , "direction" : "forward" , "indexBounds" : { "location" : [ "[BinData(128, E09F3B0000000000), BinData(128, E09F3BFFFFFFFFFF)]" , "[BinData(128, E09F3C0000000000), BinData(128, E09F3FFFFFFFFFFF)]" , "[BinData(128, E09F600000000000), BinData(128, E09F6FFFFFFFFFFF)]" , "[BinData(128, E09F700000000000), BinData(128, E09F7FFFFFFFFFFF)]" , "[BinData(128, E09F800000000000), BinData(128, E09F8FFFFFFFFFFF)]" , "[BinData(128, E09F900000000000), BinData(128, E09F9FFFFFFFFFFF)]" , "[BinData(128, E09FA00000000000), BinData(128, E09FAFFFFFFFFFFF)]" , "[BinData(128, E09FB00000000000), BinData(128, E09FBFFFFFFFFFFF)]" , "[BinData(128, E09FC00000000000), BinData(128, E09FFFFFFFFFFFFF)]" , "[BinData(128, E0B5050000000000), BinData(128, E0B505FFFFFFFFFF)]" , "[BinData(128, E0B5100000000000), BinData(128, E0B51FFFFFFFFFFF)]" , "[BinData(128, E0B5354000000000), BinData(128, E0B5357FFFFFFFFF)]" , "[BinData(128, E0B5400000000000), BinData(128, E0B57FFFFFFFFFFF)]" , "[BinData(128, E0CA800000000000), BinData(128, E0CA8FFFFFFFFFFF)]" , "[BinData(128, E0CAA00000000000), BinData(128, E0CAAFFFFFFFFFFF)]" , "[BinData(128, E0E0000000000000), BinData(128, E0E003FFFFFFFFFF)]" ] } } }, { "stage" : "FETCH" , "inputStage" : { "stage" : "IXSCAN" , "filter" : { "TwoDKeyInRegionExpression" : true }, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "isMultiKey" : false , "direction" : "forward" , "indexBounds" : { "location" : [ "[BinData(128, E09F2C0000000000), BinData(128, E09F2FFFFFFFFFFF)]" , "[BinData(128, E09F300000000000), BinData(128, E09F3FFFFFFFFFFF)]" , "[BinData(128, E09F4B0000000000), BinData(128, E09F4BFFFFFFFFFF)]" , "[BinData(128, E09F4C0000000000), BinData(128, E09F4FFFFFFFFFFF)]" , "[BinData(128, E09F600000000000), BinData(128, E09F6FFFFFFFFFFF)]" , "[BinData(128, E09F700000000000), BinData(128, E09F7FFFFFFFFFFF)]" , "[BinData(128, E09F800000000000), BinData(128, E09FBFFFFFFFFFFF)]" , "[BinData(128, E09FC00000000000), BinData(128, E09FFFFFFFFFFFFF)]" , "[BinData(128, E0B5000000000000), BinData(128, E0B53FFFFFFFFFFF)]" , "[BinData(128, E0B5400000000000), BinData(128, E0B57FFFFFFFFFFF)]" , "[BinData(128, E0CA22AA80000000), BinData(128, E0CA22AABFFFFFFF)]" , "[BinData(128, E0CA280000000000), BinData(128, E0CA2BFFFFFFFFFF)]" , "[BinData(128, E0CA800000000000), BinData(128, E0CA8FFFFFFFFFFF)]" , "[BinData(128, E0CAA00000000000), BinData(128, E0CAAFFFFFFFFFFF)]" , "[BinData(128, E0E0000000000000), BinData(128, E0E00FFFFFFFFFFF)]" , "[BinData(128, E0E0200000000000), BinData(128, E0E020FFFFFFFFFF)]" ] } } }, { "stage" : "FETCH" , "inputStage" : { "stage" : "IXSCAN" , "filter" : { "TwoDKeyInRegionExpression" : true }, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "isMultiKey" : false , "direction" : "forward" , "indexBounds" : { "location" : [ "[BinData(128, E09DBFFC00000000), BinData(128, E09DBFFFFFFFFFFF)]" , "[BinData(128, E09DE00000000000), BinData(128, E09DEFFFFFFFFFFF)]" , "[BinData(128, E09DFA8000000000), BinData(128, E09DFABFFFFFFFFF)]" , "[BinData(128, E09E700000000000), BinData(128, E09E7FFFFFFFFFFF)]" , "[BinData(128, E09EC00000000000), BinData(128, E09EFFFFFFFFFFFF)]" , "[BinData(128, E09F000000000000), BinData(128, E09FFFFFFFFFFFFF)]" , "[BinData(128, E0B4500000000000), BinData(128, E0B45FFFFFFFFFFF)]" , "[BinData(128, E0B4700000000000), BinData(128, E0B47FFFFFFFFFFF)]" , "[BinData(128, E0B5000000000000), BinData(128, E0B53FFFFFFFFFFF)]" , "[BinData(128, E0B5400000000000), BinData(128, E0B57FFFFFFFFFFF)]" , "[BinData(128, E0B5800000000000), BinData(128, E0B5BFFFFFFFFFFF)]" , "[BinData(128, E0B5C00000000000), BinData(128, E0B5FFFFFFFFFFFF)]" , "[BinData(128, E0CA000000000000), BinData(128, E0CA3FFFFFFFFFFF)]" , "[BinData(128, E0CA800000000000), BinData(128, E0CABFFFFFFFFFFF)]" , "[BinData(128, E0E0000000000000), BinData(128, E0E03FFFFFFFFFFF)]" , "[BinData(128, E0E0800000000000), BinData(128, E0E08FFFFFFFFFFF)]" ] } } }, { "stage" : "FETCH" , "inputStage" : { "stage" : "IXSCAN" , "filter" : { "TwoDKeyInRegionExpression" : true }, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "isMultiKey" : false , "direction" : "forward" , "indexBounds" : { "location" : [ "[BinData(128, E09CC00000000000), BinData(128, E09CFFFFFFFFFFFF)]" , "[BinData(128, E09D000000000000), BinData(128, E09DFFFFFFFFFFFF)]" , "[BinData(128, E09E000000000000), BinData(128, E09EFFFFFFFFFFFF)]" , "[BinData(128, E09F000000000000), BinData(128, E09FFFFFFFFFFFFF)]" , "[BinData(128, E0B4000000000000), BinData(128, E0B4FFFFFFFFFFFF)]" , "[BinData(128, E0B5000000000000), BinData(128, E0B5FFFFFFFFFFFF)]" , "[BinData(128, E0B6550000000000), BinData(128, E0B655FFFFFFFFFF)]" , "[BinData(128, E0B7000000000000), BinData(128, E0B70FFFFFFFFFFF)]" , "[BinData(128, E0B7100000000000), BinData(128, E0B71FFFFFFFFFFF)]" , "[BinData(128, E0B7400000000000), BinData(128, E0B74FFFFFFFFFFF)]" , "[BinData(128, E0B7500000000000), BinData(128, E0B75FFFFFFFFFFF)]" , "[BinData(128, E0C8800000000000), BinData(128, E0C8BFFFFFFFFFFF)]" , "[BinData(128, E0C8E00000000000), BinData(128, E0C8EFFFFFFFFFFF)]" , "[BinData(128, E0CA000000000000), BinData(128, E0CAFFFFFFFFFFFF)]" , "[BinData(128, E0E0000000000000), BinData(128, E0E0FFFFFFFFFFFF)]" , "[BinData(128, E0E2000000000000), BinData(128, E0E23FFFFFFFFFFF)]" ] } } }, { "stage" : "FETCH" , "inputStage" : { "stage" : "IXSCAN" , "filter" : { "TwoDKeyInRegionExpression" : true }, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "isMultiKey" : false , "direction" : "forward" , "indexBounds" : { "location" : [ "[BinData(128, E094000000000000), BinData(128, E097FFFFFFFFFFFF)]" , "[BinData(128, E099000000000000), BinData(128, E099FFFFFFFFFFFF)]" , "[BinData(128, E09B000000000000), BinData(128, E09BFFFFFFFFFFFF)]" , "[BinData(128, E09C000000000000), BinData(128, E09FFFFFFFFFFFFF)]" , "[BinData(128, E0B1000000000000), BinData(128, E0B1FFFFFFFFFFFF)]" , "[BinData(128, E0B3000000000000), BinData(128, E0B3FFFFFFFFFFFF)]" , "[BinData(128, E0B4000000000000), BinData(128, E0B7FFFFFFFFFFFF)]" , "[BinData(128, E0BC400000000000), BinData(128, E0BC7FFFFFFFFFFF)]" , "[BinData(128, E0BD000000000000), BinData(128, E0BDFFFFFFFFFFFF)]" , "[BinData(128, E0C2000000000000), BinData(128, E0C2FFFFFFFFFFFF)]" , "[BinData(128, E0C3A00000000000), BinData(128, E0C3AFFFFFFFFFFF)]" , "[BinData(128, E0C8000000000000), BinData(128, E0CBFFFFFFFFFFFF)]" , "[BinData(128, E0CE000000000000), BinData(128, E0CEFFFFFFFFFFFF)]" , "[BinData(128, E0E0000000000000), BinData(128, E0E3FFFFFFFFFFFF)]" , "[BinData(128, E0E4000000000000), BinData(128, E0E40FFFFFFFFFFF)]" , "[BinData(128, E0E8000000000000), BinData(128, E0E8FFFFFFFFFFFF)]" ] } } }, { "stage" : "FETCH" , "inputStage" : { "stage" : "IXSCAN" , "filter" : { "TwoDKeyInRegionExpression" : true }, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "isMultiKey" : false , "direction" : "forward" , "indexBounds" : { "location" : [ "[BinData(128, E03B000000000000), BinData(128, E03BFFFFFFFFFFFF)]" , "[BinData(128, E03C000000000000), BinData(128, E03FFFFFFFFFFFFF)]" , "[BinData(128, E068000000000000), BinData(128, E06BFFFFFFFFFFFF)]" , "[BinData(128, E087000000000000), BinData(128, E087FFFFFFFFFFFF)]" , "[BinData(128, E08C000000000000), BinData(128, E08FFFFFFFFFFFFF)]" , "[BinData(128, E090000000000000), BinData(128, E09FFFFFFFFFFFFF)]" , "[BinData(128, E0A4000000000000), BinData(128, E0A7FFFFFFFFFFFF)]" , "[BinData(128, E0AD400000000000), BinData(128, E0AD7FFFFFFFFFFF)]" , "[BinData(128, E0B0000000000000), BinData(128, E0BFFFFFFFFFFFFF)]" , "[BinData(128, E0C0000000000000), BinData(128, E0CFFFFFFFFFFFFF)]" , "[BinData(128, E0D8000000000000), BinData(128, E0DBFFFFFFFFFFFF)]" , "[BinData(128, E0E0000000000000), BinData(128, E0EFFFFFFFFFFFFF)]" , "[BinData(128, E0F0000000000000), BinData(128, E0F0FFFFFFFFFFFF)]" , "[BinData(128, E211555540000000), BinData(128, E21155557FFFFFFF)]" , "[BinData(128, E214000000000000), BinData(128, E217FFFFFFFFFFFF)]" , "[BinData(128, E240000000000000), BinData(128, E243FFFFFFFFFFFF)]" ] } } }, { "stage" : "FETCH" , "inputStage" : { "stage" : "IXSCAN" , "filter" : { "TwoDKeyInRegionExpression" : true }, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "isMultiKey" : false , "direction" : "forward" , "indexBounds" : { "location" : [ "[BinData(128, B57FC00000000000), BinData(128, B57FFFFFFFFFFFFF)]" , "[BinData(128, B5D0000000000000), BinData(128, B5DFFFFFFFFFFFFF)]" , "[BinData(128, B5F0000000000000), BinData(128, B5FFFFFFFFFFFFFF)]" , "[BinData(128, E000000000000000), BinData(128, E03FFFFFFFFFFFFF)]" , "[BinData(128, E040000000000000), BinData(128, E04FFFFFFFFFFFFF)]" , "[BinData(128, E060000000000000), BinData(128, E06FFFFFFFFFFFFF)]" , "[BinData(128, E070000000000000), BinData(128, E07FFFFFFFFFFFFF)]" , "[BinData(128, E080000000000000), BinData(128, E0BFFFFFFFFFFFFF)]" , "[BinData(128, E0C0000000000000), BinData(128, E0FFFFFFFFFFFFFF)]" , "[BinData(128, E180000000000000), BinData(128, E18FFFFFFFFFFFFF)]" , "[BinData(128, E1A0000000000000), BinData(128, E1AFFFFFFFFFFFFF)]" , "[BinData(128, E200000000000000), BinData(128, E20FFFFFFFFFFFFF)]" , "[BinData(128, E210000000000000), BinData(128, E21FFFFFFFFFFFFF)]" , "[BinData(128, E230000000000000), BinData(128, E233FFFFFFFFFFFF)]" , "[BinData(128, E234000000000000), BinData(128, E237FFFFFFFFFFFF)]" , "[BinData(128, E240000000000000), BinData(128, E27FFFFFFFFFFFFF)]" ] } } }, { "stage" : "FETCH" , "inputStage" : { "stage" : "IXSCAN" , "filter" : { "TwoDKeyInRegionExpression" : true }, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "isMultiKey" : false , "direction" : "forward" , "indexBounds" : { "location" : [ "[BinData(128, 9FEC000000000000), BinData(128, 9FEFFFFFFFFFFFFF)]" , "[BinData(128, 9FF0000000000000), BinData(128, 9FFFFFFFFFFFFFFF)]" , "[BinData(128, B500000000000000), BinData(128, B5FFFFFFFFFFFFFF)]" , "[BinData(128, B710000000000000), BinData(128, B71FFFFFFFFFFFFF)]" , "[BinData(128, B740000000000000), BinData(128, B77FFFFFFFFFFFFF)]" , "[BinData(128, B7C5000000000000), BinData(128, B7C5FFFFFFFFFFFF)]" , "[BinData(128, B7D0000000000000), BinData(128, B7DFFFFFFFFFFFFF)]" , "[BinData(128, CA80000000000000), BinData(128, CABFFFFFFFFFFFFF)]" , "[BinData(128, CAC0000000000000), BinData(128, CAFFFFFFFFFFFFFF)]" , "[BinData(128, CB80000000000000), BinData(128, CBBFFFFFFFFFFFFF)]" , "[BinData(128, E000000000000000), BinData(128, E0FFFFFFFFFFFFFF)]" , "[BinData(128, E100000000000000), BinData(128, E1FFFFFFFFFFFFFF)]" , "[BinData(128, E200000000000000), BinData(128, E2FFFFFFFFFFFFFF)]" , "[BinData(128, E300000000000000), BinData(128, E33FFFFFFFFFFFFF)]" , "[BinData(128, E340000000000000), BinData(128, E343FFFFFFFFFFFF)]" , "[BinData(128, E380000000000000), BinData(128, E3BFFFFFFFFFFFFF)]" ] } } }, { "stage" : "FETCH" , "inputStage" : { "stage" : "IXSCAN" , "filter" : { "TwoDKeyInRegionExpression" : true }, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "isMultiKey" : false , "direction" : "forward" , "indexBounds" : { "location" : [ "[BinData(128, 9D00000000000000), BinData(128, 9DFFFFFFFFFFFFFF)]" , "[BinData(128, 9E00000000000000), BinData(128, 9EFFFFFFFFFFFFFF)]" , "[BinData(128, 9F00000000000000), BinData(128, 9FFFFFFFFFFFFFFF)]" , "[BinData(128, B400000000000000), BinData(128, B7FFFFFFFFFFFFFF)]" , "[BinData(128, BC40000000000000), BinData(128, BC7FFFFFFFFFFFFF)]" , "[BinData(128, BD00000000000000), BinData(128, BDFFFFFFFFFFFFFF)]" , "[BinData(128, C800000000000000), BinData(128, CBFFFFFFFFFFFFFF)]" , "[BinData(128, CE00000000000000), BinData(128, CEFFFFFFFFFFFFFF)]" , "[BinData(128, E000000000000000), BinData(128, E3FFFFFFFFFFFFFF)]" , "[BinData(128, E400000000000000), BinData(128, E4FFFFFFFFFFFFFF)]" , "[BinData(128, E600000000000000), BinData(128, E6FFFFFFFFFFFFFF)]" , "[BinData(128, E800000000000000), BinData(128, E8FFFFFFFFFFFFFF)]" , "[BinData(128, E900000000000000), BinData(128, E9FFFFFFFFFFFFFF)]" , "[BinData(128, EA00000000000000), BinData(128, EA3FFFFFFFFFFFFF)]" , "[BinData(128, EA40000000000000), BinData(128, EA7FFFFFFFFFFFFF)]" , "[BinData(128, EC00000000000000), BinData(128, EC3FFFFFFFFFFFFF)]" ] } } }, { "stage" : "FETCH" , "inputStage" : { "stage" : "IXSCAN" , "filter" : { "TwoDKeyInRegionExpression" : true }, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "isMultiKey" : false , "direction" : "forward" , "indexBounds" : { "location" : [ "[BinData(128, 3B00000000000000), BinData(128, 3BFFFFFFFFFFFFFF)]" , "[BinData(128, 3C00000000000000), BinData(128, 3FFFFFFFFFFFFFFF)]" , "[BinData(128, 6800000000000000), BinData(128, 6BFFFFFFFFFFFFFF)]" , "[BinData(128, 6C00000000000000), BinData(128, 6FFFFFFFFFFFFFFF)]" , "[BinData(128, 8400000000000000), BinData(128, 87FFFFFFFFFFFFFF)]" , "[BinData(128, 8C00000000000000), BinData(128, 8FFFFFFFFFFFFFFF)]" , "[BinData(128, 9000000000000000), BinData(128, 9FFFFFFFFFFFFFFF)]" , "[BinData(128, A400000000000000), BinData(128, A7FFFFFFFFFFFFFF)]" , "[BinData(128, AC00000000000000), BinData(128, AFFFFFFFFFFFFFFF)]" , "[BinData(128, B000000000000000), BinData(128, BFFFFFFFFFFFFFFF)]" , "[BinData(128, C000000000000000), BinData(128, CFFFFFFFFFFFFFFF)]" , "[BinData(128, D000000000000000), BinData(128, D3FFFFFFFFFFFFFF)]" , "[BinData(128, D800000000000000), BinData(128, DBFFFFFFFFFFFFFF)]" , "[BinData(128, DC00000000000000), BinData(128, DFFFFFFFFFFFFFFF)]" , "[BinData(128, E000000000000000), BinData(128, EFFFFFFFFFFFFFFF)]" , "[BinData(128, F000000000000000), BinData(128, FFFFFFFFFFFFFFFF)]" ] } } }, { "stage" : "FETCH" , "inputStage" : { "stage" : "IXSCAN" , "filter" : { "TwoDKeyInRegionExpression" : true }, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "isMultiKey" : false , "direction" : "forward" , "indexBounds" : { "location" : [ "[BinData(128, 0000000000000000), BinData(128, FFFFFFFFFFFFFFFF)]" ] } } }, { "stage" : "FETCH" , "inputStage" : { "stage" : "IXSCAN" , "filter" : { "TwoDKeyInRegionExpression" : true }, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "isMultiKey" : false , "direction" : "forward" , "indexBounds" : { "location" : [ "[BinData(128, 0000000000000000), BinData(128, FFFFFFFFFFFFFFFF)]" ] } } } ] }, "rejectedPlans" : [ ] }, "executionStats" : { "executionSuccess" : true , "nReturned" : 583104, "executionTimeMillis" : 28562, "totalKeysExamined" : 8163456, "totalDocsExamined" : 8163456, "executionStages" : { "stage" : "GEO_NEAR_2D" , "nReturned" : 583104, "executionTimeMillisEstimate" : 27177, "works" : 8746590, "advanced" : 583104, "needTime" : 8163485, "needFetch" : 0, "saveState" : 68334, "restoreState" : 68334, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "searchIntervals" : [ { "minDistance" : 0, "maxDistance" : 20037.39210386106, "maxInclusive" : false }, { "minDistance" : 20037.39210386106, "maxDistance" : 30056.088155791593, "maxInclusive" : false }, { "minDistance" : 30056.088155791593, "maxDistance" : 35065.43618175686, "maxInclusive" : false }, { "minDistance" : 35065.43618175686, "maxDistance" : 45084.132233687385, "maxInclusive" : false }, { "minDistance" : 45084.132233687385, "maxDistance" : 65121.52433754844, "maxInclusive" : false }, { "minDistance" : 65121.52433754844, "maxDistance" : 105196.30854527056, "maxInclusive" : false }, { "minDistance" : 105196.30854527056, "maxDistance" : 185345.8769607148, "maxInclusive" : false }, { "minDistance" : 185345.8769607148, "maxDistance" : 345645.01379160327, "maxInclusive" : false }, { "minDistance" : 345645.01379160327, "maxDistance" : 666243.2874533802, "maxInclusive" : false }, { "minDistance" : 666243.2874533802, "maxDistance" : 1307439.8347769342, "maxInclusive" : false }, { "minDistance" : 1307439.8347769342, "maxDistance" : 2589832.929424042, "maxInclusive" : false }, { "minDistance" : 2589832.929424042, "maxDistance" : 5154619.118718257, "maxInclusive" : false }, { "minDistance" : 5154619.118718257, "maxDistance" : 10284191.49730669, "maxInclusive" : false }, { "minDistance" : 10284191.49730669, "maxDistance" : 20037392.10386106, "maxInclusive" : true } ], "inputStages" : [ { "stage" : "FETCH" , "nReturned" : 583104, "executionTimeMillisEstimate" : 1090, "works" : 583105, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 68334, "restoreState" : 68334, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 583104, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN" , "filter" : { "TwoDKeyInRegionExpression" : true }, "nReturned" : 583104, "executionTimeMillisEstimate" : 840, "works" : 583104, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 68334, "restoreState" : 68334, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "isMultiKey" : false , "direction" : "forward" , "indexBounds" : { "location" : [ "[BinData(128, E09F97C000000000), BinData(128, E09F97FFFFFFFFFF)]" , "[BinData(128, E09F9C0000000000), BinData(128, E09F9FFFFFFFFFFF)]" , "[BinData(128, E09FB40000000000), BinData(128, E09FB7FFFFFFFFFF)]" , "[BinData(128, E09FBC0000000000), BinData(128, E09FBFFFFFFFFFFF)]" , "[BinData(128, E09FC00000000000), BinData(128, E09FCFFFFFFFFFFF)]" , "[BinData(128, E09FD28000000000), BinData(128, E09FD2BFFFFFFFFF)]" , "[BinData(128, E09FD2E000000000), BinData(128, E09FD2EFFFFFFFFF)]" , "[BinData(128, E09FD80000000000), BinData(128, E09FDBFFFFFFFFFF)]" , "[BinData(128, E09FDE8000000000), BinData(128, E09FDEBFFFFFFFFF)]" , "[BinData(128, E09FE00000000000), BinData(128, E09FEFFFFFFFFFFF)]" , "[BinData(128, E09FF00000000000), BinData(128, E09FFFFFFFFFFFFF)]" , "[BinData(128, E0B5150000000000), BinData(128, E0B515FFFFFFFFFF)]" , "[BinData(128, E0B5400000000000), BinData(128, E0B543FFFFFFFFFF)]" , "[BinData(128, E0B5440000000000), BinData(128, E0B547FFFFFFFFFF)]" , "[BinData(128, E0B5500000000000), BinData(128, E0B550FFFFFFFFFF)]" , "[BinData(128, E0B5510000000000), BinData(128, E0B5513FFFFFFFFF)]" ] }, "keysExamined" : 583104, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 583104 } }, { "stage" : "FETCH" , "nReturned" : 583104, "executionTimeMillisEstimate" : 1110, "works" : 583105, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 59279, "restoreState" : 59279, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 583104, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN" , "filter" : { "TwoDKeyInRegionExpression" : true }, "nReturned" : 583104, "executionTimeMillisEstimate" : 760, "works" : 583104, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 59279, "restoreState" : 59279, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "isMultiKey" : false , "direction" : "forward" , "indexBounds" : { "location" : [ "[BinData(128, E09F3C0000000000), BinData(128, E09F3FFFFFFFFFFF)]" , "[BinData(128, E09F600000000000), BinData(128, E09F6FFFFFFFFFFF)]" , "[BinData(128, E09F780000000000), BinData(128, E09F7BFFFFFFFFFF)]" , "[BinData(128, E09F900000000000), BinData(128, E09F9FFFFFFFFFFF)]" , "[BinData(128, E09FA40000000000), BinData(128, E09FA7FFFFFFFFFF)]" , "[BinData(128, E09FB00000000000), BinData(128, E09FBFFFFFFFFFFF)]" , "[BinData(128, E09FC00000000000), BinData(128, E09FCFFFFFFFFFFF)]" , "[BinData(128, E09FD00000000000), BinData(128, E09FDFFFFFFFFFFF)]" , "[BinData(128, E09FE00000000000), BinData(128, E09FEFFFFFFFFFFF)]" , "[BinData(128, E09FF00000000000), BinData(128, E09FFFFFFFFFFFFF)]" , "[BinData(128, E0B5100000000000), BinData(128, E0B51FFFFFFFFFFF)]" , "[BinData(128, E0B5400000000000), BinData(128, E0B54FFFFFFFFFFF)]" , "[BinData(128, E0B5500000000000), BinData(128, E0B55FFFFFFFFFFF)]" , "[BinData(128, E0CA8A0000000000), BinData(128, E0CA8AFFFFFFFFFF)]" , "[BinData(128, E0CAA00000000000), BinData(128, E0CAA3FFFFFFFFFF)]" , "[BinData(128, E0CAA80000000000), BinData(128, E0CAABFFFFFFFFFF)]" ] }, "keysExamined" : 583104, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 583104 } }, { "stage" : "FETCH" , "nReturned" : 583104, "executionTimeMillisEstimate" : 970, "works" : 583105, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 54667, "restoreState" : 54667, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 583104, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN" , "filter" : { "TwoDKeyInRegionExpression" : true }, "nReturned" : 583104, "executionTimeMillisEstimate" : 710, "works" : 583104, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 54667, "restoreState" : 54667, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "isMultiKey" : false , "direction" : "forward" , "indexBounds" : { "location" : [ "[BinData(128, E09F3B0000000000), BinData(128, E09F3BFFFFFFFFFF)]" , "[BinData(128, E09F3C0000000000), BinData(128, E09F3FFFFFFFFFFF)]" , "[BinData(128, E09F600000000000), BinData(128, E09F6FFFFFFFFFFF)]" , "[BinData(128, E09F700000000000), BinData(128, E09F7FFFFFFFFFFF)]" , "[BinData(128, E09F800000000000), BinData(128, E09F8FFFFFFFFFFF)]" , "[BinData(128, E09F900000000000), BinData(128, E09F9FFFFFFFFFFF)]" , "[BinData(128, E09FA00000000000), BinData(128, E09FAFFFFFFFFFFF)]" , "[BinData(128, E09FB00000000000), BinData(128, E09FBFFFFFFFFFFF)]" , "[BinData(128, E09FC00000000000), BinData(128, E09FFFFFFFFFFFFF)]" , "[BinData(128, E0B5050000000000), BinData(128, E0B505FFFFFFFFFF)]" , "[BinData(128, E0B5100000000000), BinData(128, E0B51FFFFFFFFFFF)]" , "[BinData(128, E0B5354000000000), BinData(128, E0B5357FFFFFFFFF)]" , "[BinData(128, E0B5400000000000), BinData(128, E0B57FFFFFFFFFFF)]" , "[BinData(128, E0CA800000000000), BinData(128, E0CA8FFFFFFFFFFF)]" , "[BinData(128, E0CAA00000000000), BinData(128, E0CAAFFFFFFFFFFF)]" , "[BinData(128, E0E0000000000000), BinData(128, E0E003FFFFFFFFFF)]" ] }, "keysExamined" : 583104, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 583104 } }, { "stage" : "FETCH" , "nReturned" : 583104, "executionTimeMillisEstimate" : 904, "works" : 583105, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 50111, "restoreState" : 50111, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 583104, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN" , "filter" : { "TwoDKeyInRegionExpression" : true }, "nReturned" : 583104, "executionTimeMillisEstimate" : 694, "works" : 583104, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 50111, "restoreState" : 50111, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "isMultiKey" : false , "direction" : "forward" , "indexBounds" : { "location" : [ "[BinData(128, E09F2C0000000000), BinData(128, E09F2FFFFFFFFFFF)]" , "[BinData(128, E09F300000000000), BinData(128, E09F3FFFFFFFFFFF)]" , "[BinData(128, E09F4B0000000000), BinData(128, E09F4BFFFFFFFFFF)]" , "[BinData(128, E09F4C0000000000), BinData(128, E09F4FFFFFFFFFFF)]" , "[BinData(128, E09F600000000000), BinData(128, E09F6FFFFFFFFFFF)]" , "[BinData(128, E09F700000000000), BinData(128, E09F7FFFFFFFFFFF)]" , "[BinData(128, E09F800000000000), BinData(128, E09FBFFFFFFFFFFF)]" , "[BinData(128, E09FC00000000000), BinData(128, E09FFFFFFFFFFFFF)]" , "[BinData(128, E0B5000000000000), BinData(128, E0B53FFFFFFFFFFF)]" , "[BinData(128, E0B5400000000000), BinData(128, E0B57FFFFFFFFFFF)]" , "[BinData(128, E0CA22AA80000000), BinData(128, E0CA22AABFFFFFFF)]" , "[BinData(128, E0CA280000000000), BinData(128, E0CA2BFFFFFFFFFF)]" , "[BinData(128, E0CA800000000000), BinData(128, E0CA8FFFFFFFFFFF)]" , "[BinData(128, E0CAA00000000000), BinData(128, E0CAAFFFFFFFFFFF)]" , "[BinData(128, E0E0000000000000), BinData(128, E0E00FFFFFFFFFFF)]" , "[BinData(128, E0E0200000000000), BinData(128, E0E020FFFFFFFFFF)]" ] }, "keysExamined" : 583104, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 583104 } }, { "stage" : "FETCH" , "nReturned" : 583104, "executionTimeMillisEstimate" : 900, "works" : 583105, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 45556, "restoreState" : 45556, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 583104, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN" , "filter" : { "TwoDKeyInRegionExpression" : true }, "nReturned" : 583104, "executionTimeMillisEstimate" : 610, "works" : 583104, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 45556, "restoreState" : 45556, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "isMultiKey" : false , "direction" : "forward" , "indexBounds" : { "location" : [ "[BinData(128, E09DBFFC00000000), BinData(128, E09DBFFFFFFFFFFF)]" , "[BinData(128, E09DE00000000000), BinData(128, E09DEFFFFFFFFFFF)]" , "[BinData(128, E09DFA8000000000), BinData(128, E09DFABFFFFFFFFF)]" , "[BinData(128, E09E700000000000), BinData(128, E09E7FFFFFFFFFFF)]" , "[BinData(128, E09EC00000000000), BinData(128, E09EFFFFFFFFFFFF)]" , "[BinData(128, E09F000000000000), BinData(128, E09FFFFFFFFFFFFF)]" , "[BinData(128, E0B4500000000000), BinData(128, E0B45FFFFFFFFFFF)]" , "[BinData(128, E0B4700000000000), BinData(128, E0B47FFFFFFFFFFF)]" , "[BinData(128, E0B5000000000000), BinData(128, E0B53FFFFFFFFFFF)]" , "[BinData(128, E0B5400000000000), BinData(128, E0B57FFFFFFFFFFF)]" , "[BinData(128, E0B5800000000000), BinData(128, E0B5BFFFFFFFFFFF)]" , "[BinData(128, E0B5C00000000000), BinData(128, E0B5FFFFFFFFFFFF)]" , "[BinData(128, E0CA000000000000), BinData(128, E0CA3FFFFFFFFFFF)]" , "[BinData(128, E0CA800000000000), BinData(128, E0CABFFFFFFFFFFF)]" , "[BinData(128, E0E0000000000000), BinData(128, E0E03FFFFFFFFFFF)]" , "[BinData(128, E0E0800000000000), BinData(128, E0E08FFFFFFFFFFF)]" ] }, "keysExamined" : 583104, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 583104 } }, { "stage" : "FETCH" , "nReturned" : 583104, "executionTimeMillisEstimate" : 950, "works" : 583105, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 41000, "restoreState" : 41000, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 583104, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN" , "filter" : { "TwoDKeyInRegionExpression" : true }, "nReturned" : 583104, "executionTimeMillisEstimate" : 740, "works" : 583104, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 41000, "restoreState" : 41000, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "isMultiKey" : false , "direction" : "forward" , "indexBounds" : { "location" : [ "[BinData(128, E09CC00000000000), BinData(128, E09CFFFFFFFFFFFF)]" , "[BinData(128, E09D000000000000), BinData(128, E09DFFFFFFFFFFFF)]" , "[BinData(128, E09E000000000000), BinData(128, E09EFFFFFFFFFFFF)]" , "[BinData(128, E09F000000000000), BinData(128, E09FFFFFFFFFFFFF)]" , "[BinData(128, E0B4000000000000), BinData(128, E0B4FFFFFFFFFFFF)]" , "[BinData(128, E0B5000000000000), BinData(128, E0B5FFFFFFFFFFFF)]" , "[BinData(128, E0B6550000000000), BinData(128, E0B655FFFFFFFFFF)]" , "[BinData(128, E0B7000000000000), BinData(128, E0B70FFFFFFFFFFF)]" , "[BinData(128, E0B7100000000000), BinData(128, E0B71FFFFFFFFFFF)]" , "[BinData(128, E0B7400000000000), BinData(128, E0B74FFFFFFFFFFF)]" , "[BinData(128, E0B7500000000000), BinData(128, E0B75FFFFFFFFFFF)]" , "[BinData(128, E0C8800000000000), BinData(128, E0C8BFFFFFFFFFFF)]" , "[BinData(128, E0C8E00000000000), BinData(128, E0C8EFFFFFFFFFFF)]" , "[BinData(128, E0CA000000000000), BinData(128, E0CAFFFFFFFFFFFF)]" , "[BinData(128, E0E0000000000000), BinData(128, E0E0FFFFFFFFFFFF)]" , "[BinData(128, E0E2000000000000), BinData(128, E0E23FFFFFFFFFFF)]" ] }, "keysExamined" : 583104, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 583104 } }, { "stage" : "FETCH" , "nReturned" : 583104, "executionTimeMillisEstimate" : 830, "works" : 583105, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 36445, "restoreState" : 36445, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 583104, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN" , "filter" : { "TwoDKeyInRegionExpression" : true }, "nReturned" : 583104, "executionTimeMillisEstimate" : 570, "works" : 583104, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 36445, "restoreState" : 36445, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "isMultiKey" : false , "direction" : "forward" , "indexBounds" : { "location" : [ "[BinData(128, E094000000000000), BinData(128, E097FFFFFFFFFFFF)]" , "[BinData(128, E099000000000000), BinData(128, E099FFFFFFFFFFFF)]" , "[BinData(128, E09B000000000000), BinData(128, E09BFFFFFFFFFFFF)]" , "[BinData(128, E09C000000000000), BinData(128, E09FFFFFFFFFFFFF)]" , "[BinData(128, E0B1000000000000), BinData(128, E0B1FFFFFFFFFFFF)]" , "[BinData(128, E0B3000000000000), BinData(128, E0B3FFFFFFFFFFFF)]" , "[BinData(128, E0B4000000000000), BinData(128, E0B7FFFFFFFFFFFF)]" , "[BinData(128, E0BC400000000000), BinData(128, E0BC7FFFFFFFFFFF)]" , "[BinData(128, E0BD000000000000), BinData(128, E0BDFFFFFFFFFFFF)]" , "[BinData(128, E0C2000000000000), BinData(128, E0C2FFFFFFFFFFFF)]" , "[BinData(128, E0C3A00000000000), BinData(128, E0C3AFFFFFFFFFFF)]" , "[BinData(128, E0C8000000000000), BinData(128, E0CBFFFFFFFFFFFF)]" , "[BinData(128, E0CE000000000000), BinData(128, E0CEFFFFFFFFFFFF)]" , "[BinData(128, E0E0000000000000), BinData(128, E0E3FFFFFFFFFFFF)]" , "[BinData(128, E0E4000000000000), BinData(128, E0E40FFFFFFFFFFF)]" , "[BinData(128, E0E8000000000000), BinData(128, E0E8FFFFFFFFFFFF)]" ] }, "keysExamined" : 583104, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 583104 } }, { "stage" : "FETCH" , "nReturned" : 583104, "executionTimeMillisEstimate" : 1060, "works" : 583105, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 31889, "restoreState" : 31889, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 583104, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN" , "filter" : { "TwoDKeyInRegionExpression" : true }, "nReturned" : 583104, "executionTimeMillisEstimate" : 780, "works" : 583104, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 31889, "restoreState" : 31889, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "isMultiKey" : false , "direction" : "forward" , "indexBounds" : { "location" : [ "[BinData(128, E03B000000000000), BinData(128, E03BFFFFFFFFFFFF)]" , "[BinData(128, E03C000000000000), BinData(128, E03FFFFFFFFFFFFF)]" , "[BinData(128, E068000000000000), BinData(128, E06BFFFFFFFFFFFF)]" , "[BinData(128, E087000000000000), BinData(128, E087FFFFFFFFFFFF)]" , "[BinData(128, E08C000000000000), BinData(128, E08FFFFFFFFFFFFF)]" , "[BinData(128, E090000000000000), BinData(128, E09FFFFFFFFFFFFF)]" , "[BinData(128, E0A4000000000000), BinData(128, E0A7FFFFFFFFFFFF)]" , "[BinData(128, E0AD400000000000), BinData(128, E0AD7FFFFFFFFFFF)]" , "[BinData(128, E0B0000000000000), BinData(128, E0BFFFFFFFFFFFFF)]" , "[BinData(128, E0C0000000000000), BinData(128, E0CFFFFFFFFFFFFF)]" , "[BinData(128, E0D8000000000000), BinData(128, E0DBFFFFFFFFFFFF)]" , "[BinData(128, E0E0000000000000), BinData(128, E0EFFFFFFFFFFFFF)]" , "[BinData(128, E0F0000000000000), BinData(128, E0F0FFFFFFFFFFFF)]" , "[BinData(128, E211555540000000), BinData(128, E21155557FFFFFFF)]" , "[BinData(128, E214000000000000), BinData(128, E217FFFFFFFFFFFF)]" , "[BinData(128, E240000000000000), BinData(128, E243FFFFFFFFFFFF)]" ] }, "keysExamined" : 583104, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 583104 } }, { "stage" : "FETCH" , "nReturned" : 583104, "executionTimeMillisEstimate" : 926, "works" : 583105, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 27334, "restoreState" : 27334, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 583104, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN" , "filter" : { "TwoDKeyInRegionExpression" : true }, "nReturned" : 583104, "executionTimeMillisEstimate" : 716, "works" : 583104, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 27334, "restoreState" : 27334, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "isMultiKey" : false , "direction" : "forward" , "indexBounds" : { "location" : [ "[BinData(128, B57FC00000000000), BinData(128, B57FFFFFFFFFFFFF)]" , "[BinData(128, B5D0000000000000), BinData(128, B5DFFFFFFFFFFFFF)]" , "[BinData(128, B5F0000000000000), BinData(128, B5FFFFFFFFFFFFFF)]" , "[BinData(128, E000000000000000), BinData(128, E03FFFFFFFFFFFFF)]" , "[BinData(128, E040000000000000), BinData(128, E04FFFFFFFFFFFFF)]" , "[BinData(128, E060000000000000), BinData(128, E06FFFFFFFFFFFFF)]" , "[BinData(128, E070000000000000), BinData(128, E07FFFFFFFFFFFFF)]" , "[BinData(128, E080000000000000), BinData(128, E0BFFFFFFFFFFFFF)]" , "[BinData(128, E0C0000000000000), BinData(128, E0FFFFFFFFFFFFFF)]" , "[BinData(128, E180000000000000), BinData(128, E18FFFFFFFFFFFFF)]" , "[BinData(128, E1A0000000000000), BinData(128, E1AFFFFFFFFFFFFF)]" , "[BinData(128, E200000000000000), BinData(128, E20FFFFFFFFFFFFF)]" , "[BinData(128, E210000000000000), BinData(128, E21FFFFFFFFFFFFF)]" , "[BinData(128, E230000000000000), BinData(128, E233FFFFFFFFFFFF)]" , "[BinData(128, E234000000000000), BinData(128, E237FFFFFFFFFFFF)]" , "[BinData(128, E240000000000000), BinData(128, E27FFFFFFFFFFFFF)]" ] }, "keysExamined" : 583104, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 583104 } }, { "stage" : "FETCH" , "nReturned" : 583104, "executionTimeMillisEstimate" : 840, "works" : 583105, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 22778, "restoreState" : 22778, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 583104, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN" , "filter" : { "TwoDKeyInRegionExpression" : true }, "nReturned" : 583104, "executionTimeMillisEstimate" : 580, "works" : 583104, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 22778, "restoreState" : 22778, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "isMultiKey" : false , "direction" : "forward" , "indexBounds" : { "location" : [ "[BinData(128, 9FEC000000000000), BinData(128, 9FEFFFFFFFFFFFFF)]" , "[BinData(128, 9FF0000000000000), BinData(128, 9FFFFFFFFFFFFFFF)]" , "[BinData(128, B500000000000000), BinData(128, B5FFFFFFFFFFFFFF)]" , "[BinData(128, B710000000000000), BinData(128, B71FFFFFFFFFFFFF)]" , "[BinData(128, B740000000000000), BinData(128, B77FFFFFFFFFFFFF)]" , "[BinData(128, B7C5000000000000), BinData(128, B7C5FFFFFFFFFFFF)]" , "[BinData(128, B7D0000000000000), BinData(128, B7DFFFFFFFFFFFFF)]" , "[BinData(128, CA80000000000000), BinData(128, CABFFFFFFFFFFFFF)]" , "[BinData(128, CAC0000000000000), BinData(128, CAFFFFFFFFFFFFFF)]" , "[BinData(128, CB80000000000000), BinData(128, CBBFFFFFFFFFFFFF)]" , "[BinData(128, E000000000000000), BinData(128, E0FFFFFFFFFFFFFF)]" , "[BinData(128, E100000000000000), BinData(128, E1FFFFFFFFFFFFFF)]" , "[BinData(128, E200000000000000), BinData(128, E2FFFFFFFFFFFFFF)]" , "[BinData(128, E300000000000000), BinData(128, E33FFFFFFFFFFFFF)]" , "[BinData(128, E340000000000000), BinData(128, E343FFFFFFFFFFFF)]" , "[BinData(128, E380000000000000), BinData(128, E3BFFFFFFFFFFFFF)]" ] }, "keysExamined" : 583104, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 583104 } }, { "stage" : "FETCH" , "nReturned" : 583104, "executionTimeMillisEstimate" : 1184, "works" : 583105, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 18223, "restoreState" : 18223, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 583104, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN" , "filter" : { "TwoDKeyInRegionExpression" : true }, "nReturned" : 583104, "executionTimeMillisEstimate" : 954, "works" : 583104, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 18223, "restoreState" : 18223, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "isMultiKey" : false , "direction" : "forward" , "indexBounds" : { "location" : [ "[BinData(128, 9D00000000000000), BinData(128, 9DFFFFFFFFFFFFFF)]" , "[BinData(128, 9E00000000000000), BinData(128, 9EFFFFFFFFFFFFFF)]" , "[BinData(128, 9F00000000000000), BinData(128, 9FFFFFFFFFFFFFFF)]" , "[BinData(128, B400000000000000), BinData(128, B7FFFFFFFFFFFFFF)]" , "[BinData(128, BC40000000000000), BinData(128, BC7FFFFFFFFFFFFF)]" , "[BinData(128, BD00000000000000), BinData(128, BDFFFFFFFFFFFFFF)]" , "[BinData(128, C800000000000000), BinData(128, CBFFFFFFFFFFFFFF)]" , "[BinData(128, CE00000000000000), BinData(128, CEFFFFFFFFFFFFFF)]" , "[BinData(128, E000000000000000), BinData(128, E3FFFFFFFFFFFFFF)]" , "[BinData(128, E400000000000000), BinData(128, E4FFFFFFFFFFFFFF)]" , "[BinData(128, E600000000000000), BinData(128, E6FFFFFFFFFFFFFF)]" , "[BinData(128, E800000000000000), BinData(128, E8FFFFFFFFFFFFFF)]" , "[BinData(128, E900000000000000), BinData(128, E9FFFFFFFFFFFFFF)]" , "[BinData(128, EA00000000000000), BinData(128, EA3FFFFFFFFFFFFF)]" , "[BinData(128, EA40000000000000), BinData(128, EA7FFFFFFFFFFFFF)]" , "[BinData(128, EC00000000000000), BinData(128, EC3FFFFFFFFFFFFF)]" ] }, "keysExamined" : 583104, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 583104 } }, { "stage" : "FETCH" , "nReturned" : 583104, "executionTimeMillisEstimate" : 1070, "works" : 583105, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 13667, "restoreState" : 13667, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 583104, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN" , "filter" : { "TwoDKeyInRegionExpression" : true }, "nReturned" : 583104, "executionTimeMillisEstimate" : 740, "works" : 583104, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 13667, "restoreState" : 13667, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "isMultiKey" : false , "direction" : "forward" , "indexBounds" : { "location" : [ "[BinData(128, 3B00000000000000), BinData(128, 3BFFFFFFFFFFFFFF)]" , "[BinData(128, 3C00000000000000), BinData(128, 3FFFFFFFFFFFFFFF)]" , "[BinData(128, 6800000000000000), BinData(128, 6BFFFFFFFFFFFFFF)]" , "[BinData(128, 6C00000000000000), BinData(128, 6FFFFFFFFFFFFFFF)]" , "[BinData(128, 8400000000000000), BinData(128, 87FFFFFFFFFFFFFF)]" , "[BinData(128, 8C00000000000000), BinData(128, 8FFFFFFFFFFFFFFF)]" , "[BinData(128, 9000000000000000), BinData(128, 9FFFFFFFFFFFFFFF)]" , "[BinData(128, A400000000000000), BinData(128, A7FFFFFFFFFFFFFF)]" , "[BinData(128, AC00000000000000), BinData(128, AFFFFFFFFFFFFFFF)]" , "[BinData(128, B000000000000000), BinData(128, BFFFFFFFFFFFFFFF)]" , "[BinData(128, C000000000000000), BinData(128, CFFFFFFFFFFFFFFF)]" , "[BinData(128, D000000000000000), BinData(128, D3FFFFFFFFFFFFFF)]" , "[BinData(128, D800000000000000), BinData(128, DBFFFFFFFFFFFFFF)]" , "[BinData(128, DC00000000000000), BinData(128, DFFFFFFFFFFFFFFF)]" , "[BinData(128, E000000000000000), BinData(128, EFFFFFFFFFFFFFFF)]" , "[BinData(128, F000000000000000), BinData(128, FFFFFFFFFFFFFFFF)]" ] }, "keysExamined" : 583104, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 583104 } }, { "stage" : "FETCH" , "nReturned" : 583104, "executionTimeMillisEstimate" : 920, "works" : 583105, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 9111, "restoreState" : 9111, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 583104, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN" , "filter" : { "TwoDKeyInRegionExpression" : true }, "nReturned" : 583104, "executionTimeMillisEstimate" : 630, "works" : 583104, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 9111, "restoreState" : 9111, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "isMultiKey" : false , "direction" : "forward" , "indexBounds" : { "location" : [ "[BinData(128, 0000000000000000), BinData(128, FFFFFFFFFFFFFFFF)]" ] }, "keysExamined" : 583104, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 583104 } }, { "stage" : "FETCH" , "nReturned" : 583104, "executionTimeMillisEstimate" : 870, "works" : 583105, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 4556, "restoreState" : 4556, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 583104, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN" , "filter" : { "TwoDKeyInRegionExpression" : true }, "nReturned" : 583104, "executionTimeMillisEstimate" : 620, "works" : 583104, "advanced" : 583104, "needTime" : 0, "needFetch" : 0, "saveState" : 4556, "restoreState" : 4556, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "location" : "2d" }, "indexName" : "location_2d" , "isMultiKey" : false , "direction" : "forward" , "indexBounds" : { "location" : [ "[BinData(128, 0000000000000000), BinData(128, FFFFFFFFFFFFFFFF)]" ] }, "keysExamined" : 583104, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "matchTested" : 583104 } } ] } }, "serverInfo" : { "host" : "some_host" , "port" : 27017, "version" : "3.0.0-rc11" , "gitVersion" : "709cafbbb86c994bc153df189ace58a9c2e4145b" }, "ok" : 1 } -
RPL 1 04/03/15
ISSUE SUMMARY
$nearSphere queries using 2d indexes start from a fixed size of initial search area, which is too large for dense data. This strategy may lead to poor performance in some cases.
In 2.6.x and earlier, 2d indexes used a different initial search strategy, which was not susceptible to this issue.
USER IMPACT
Some $nearSphere queries using 2d indexes may suffer from very poor performance.
WORKAROUNDS
Use 2dsphere indexes for spherical data when possible.
AFFECTED VERSIONS
3.0.0 and 3.0.1
FIX VERSION
The fix is included in the 3.0.2 production release.
Original description
We noticed a performance regression in nearSphere queries when comparing 2.6.5 with 3.0.0-rc11. It looks like in 3.0 returns the entire collection is scanned vs only a few thousand documents in 2.6.5
- 2d-regression.tar.gz
- 5.98 MB
- Michael Kania
- 2d-regression-date-range.tar.gz
- 11.97 MB
- Michael Kania