{ "queryPlanner" : { "plannerVersion" : 1, "namespace" : "{db}.{coll}", "indexFilterSet" : false, "parsedQuery" : { "loc" : { "$nearSphere" : { "$geometry" : { "type" : "Point", "coordinates" : [ 120.993965, 31.449034 ] }, "$maxDistance" : 1000 } } }, "winningPlan" : { "stage" : "LIMIT", "limitAmount" : 1, "inputStage" : { "stage" : "GEO_NEAR_2DSPHERE", "keyPattern" : { "loc" : "2dsphere" }, "indexName" : "loc_2dsphere", "inputStage" : { "stage" : "FETCH", "inputStage" : { "stage" : "IXSCAN", "keyPattern" : { "loc" : "2dsphere" }, "indexName" : "loc_2dsphere", "isMultiKey" : false, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 1, "direction" : "forward", "indexBounds" : { "loc" : [ "[3819052484010180608, 3819052484010180608]", "[3868592079911256064, 3868592079911256064]", "[3869225398608855040, 3869225398608855040]", "[3869235294213505024, 3869235294213505024]", "[3869235569091411968, 3869235569091411968]", "[3869235579828830209, 3869235581976313855]", "[3869235581976313856, 3869235581976313856]", "[3869235586271281152, 3869235586271281152]", "[3869235637810888704, 3869235637810888704]", "[3869235689350496256, 3869235689350496256]", "[3869235689350496257, 3869235697940430847]", "[3869235697940430849, 3869235706530365439]", "[3869235706530365441, 3869235740890103807]", "[3869235740890103809, 3869235749480038399]", "[3869235758069972992, 3869235758069972992]", "[3869235766659907585, 3869235775249842175]", "[3869235775249842176, 3869235775249842176]", "[3869235775249842177, 3869235783839776767]", "[3869235792429711360, 3869235792429711360]", "[3869235818199515137, 3869235826789449727]", "[3869235826789449728, 3869235826789449728]", "[3869235827863191552, 3869235827863191552]", "[3869235827863191553, 3869235828400062463]", "[3869235828400062465, 3869235828936933375]", "[3869235828936933377, 3869235831084417023]", "[3869235831084417024, 3869235831084417024]", "[3869235831084417025, 3869235833231900671]", "[3869237493236760576, 3869237493236760576]", "[3869238317870481408, 3869238317870481408]", "[3869238386589958144, 3869238386589958144]", "[3869238403769827328, 3869238403769827328]", "[3869238416654729216, 3869238416654729216]", "[3869238419875954688, 3869238419875954688]", "[3869238420681261056, 3869238420681261056]", "[3869238420815478785, 3869238420949696511]", "[3869238420949696513, 3869238423097180159]", "[3869238423097180161, 3869238425244663807]", "[3869238425244663808, 3869238425244663808]", "[3869238425244663809, 3869238427392147455]", "[3869238438129565696, 3869238438129565696]", "[3869238446719500289, 3869238455309434879]", "[3869238455309434881, 3869238457456918527]", "[3869238457456918529, 3869238459604402175]", "[3869238459604402176, 3869238459604402176]", "[3869238461751885825, 3869238463899369471]", "[3869238472489304064, 3869238472489304064]", "[3869238524028911616, 3869238524028911616]", "[3869238592748388352, 3869238592748388352]", "[3869242990794899456, 3869242990794899456]", "[3869436504841388032, 3869436504841388032]", "[3869717979818098688, 3869717979818098688]", "[3873095679538626560, 3873095679538626560]" ] } } } } }, "rejectedPlans" : [ ] }, "executionStats" : { "executionSuccess" : true, "nReturned" : 1, "executionTimeMillis" : 195, "totalKeysExamined" : 24627, "totalDocsExamined" : 24615, "executionStages" : { "stage" : "LIMIT", "nReturned" : 1, "executionTimeMillisEstimate" : 190, "works" : 24646, "advanced" : 1, "needTime" : 24644, "needYield" : 0, "saveState" : 192, "restoreState" : 192, "isEOF" : 1, "invalidates" : 0, "limitAmount" : 1, "inputStage" : { "stage" : "GEO_NEAR_2DSPHERE", "nReturned" : 1, "executionTimeMillisEstimate" : 190, "works" : 24645, "advanced" : 1, "needTime" : 24644, "needYield" : 0, "saveState" : 192, "restoreState" : 192, "isEOF" : 0, "invalidates" : 0, "keyPattern" : { "loc" : "2dsphere" }, "indexName" : "loc_2dsphere", "searchIntervals" : [ { "minDistance" : 0, "maxDistance" : 1000, "maxInclusive" : true, "nBuffered" : 24615, "nReturned" : 1 } ], "inputStage" : { "stage" : "FETCH", "nReturned" : 24615, "executionTimeMillisEstimate" : 100, "works" : 24627, "advanced" : 24615, "needTime" : 11, "needYield" : 0, "saveState" : 192, "restoreState" : 192, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 24615, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 24615, "executionTimeMillisEstimate" : 30, "works" : 24627, "advanced" : 24615, "needTime" : 11, "needYield" : 0, "saveState" : 192, "restoreState" : 192, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "loc" : "2dsphere" }, "indexName" : "loc_2dsphere", "isMultiKey" : false, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 1, "direction" : "forward", "indexBounds" : { "loc" : [ "[3819052484010180608, 3819052484010180608]", "[3868592079911256064, 3868592079911256064]", "[3869225398608855040, 3869225398608855040]", "[3869235294213505024, 3869235294213505024]", "[3869235569091411968, 3869235569091411968]", "[3869235579828830209, 3869235581976313855]", "[3869235581976313856, 3869235581976313856]", "[3869235586271281152, 3869235586271281152]", "[3869235637810888704, 3869235637810888704]", "[3869235689350496256, 3869235689350496256]", "[3869235689350496257, 3869235697940430847]", "[3869235697940430849, 3869235706530365439]", "[3869235706530365441, 3869235740890103807]", "[3869235740890103809, 3869235749480038399]", "[3869235758069972992, 3869235758069972992]", "[3869235766659907585, 3869235775249842175]", "[3869235775249842176, 3869235775249842176]", "[3869235775249842177, 3869235783839776767]", "[3869235792429711360, 3869235792429711360]", "[3869235818199515137, 3869235826789449727]", "[3869235826789449728, 3869235826789449728]", "[3869235827863191552, 3869235827863191552]", "[3869235827863191553, 3869235828400062463]", "[3869235828400062465, 3869235828936933375]", "[3869235828936933377, 3869235831084417023]", "[3869235831084417024, 3869235831084417024]", "[3869235831084417025, 3869235833231900671]", "[3869237493236760576, 3869237493236760576]", "[3869238317870481408, 3869238317870481408]", "[3869238386589958144, 3869238386589958144]", "[3869238403769827328, 3869238403769827328]", "[3869238416654729216, 3869238416654729216]", "[3869238419875954688, 3869238419875954688]", "[3869238420681261056, 3869238420681261056]", "[3869238420815478785, 3869238420949696511]", "[3869238420949696513, 3869238423097180159]", "[3869238423097180161, 3869238425244663807]", "[3869238425244663808, 3869238425244663808]", "[3869238425244663809, 3869238427392147455]", "[3869238438129565696, 3869238438129565696]", "[3869238446719500289, 3869238455309434879]", "[3869238455309434881, 3869238457456918527]", "[3869238457456918529, 3869238459604402175]", "[3869238459604402176, 3869238459604402176]", "[3869238461751885825, 3869238463899369471]", "[3869238472489304064, 3869238472489304064]", "[3869238524028911616, 3869238524028911616]", "[3869238592748388352, 3869238592748388352]", "[3869242990794899456, 3869242990794899456]", "[3869436504841388032, 3869436504841388032]", "[3869717979818098688, 3869717979818098688]", "[3873095679538626560, 3873095679538626560]" ] }, "keysExamined" : 24627, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0 } } } }, "allPlansExecution" : [ ] }, "serverInfo" : { "host" : "{host}", "port" : 7004, "version" : "0.0.1-fake-", "gitVersion" : "nogitversion" }, "ok" : 1 }