db.getCollection("nari_dynamic").explain('executionStats').aggregate ( [ { "$match": { "geoloc": { "$geoWithin": { "$geometry": { "type" : "Polygon" , "coordinates": [ [ [ -5.00, 45.00 ], [ +0.00, 45.00 ], [ +0.00, 50.00 ], [ -5.00, 50.00 ], [ -5.00, 45.00 ] ] ] }}}} } ] ) ############################# WITHOUT INDEX ############################# /* 1 */ { "queryPlanner" : { "plannerVersion" : 1, "namespace" : "mscdata.nari_dynamic", "indexFilterSet" : false, "parsedQuery" : { "geoloc" : { "$geoWithin" : { "$geometry" : { "type" : "Polygon", "coordinates" : [ [ [ -5.0, 45.0 ], [ 0.0, 45.0 ], [ 0.0, 50.0 ], [ -5.0, 50.0 ], [ -5.0, 45.0 ] ] ] } } } }, "optimizedPipeline" : true, "winningPlan" : { "stage" : "COLLSCAN", "filter" : { "geoloc" : { "$geoWithin" : { "$geometry" : { "type" : "Polygon", "coordinates" : [ [ [ -5.0, 45.0 ], [ 0.0, 45.0 ], [ 0.0, 50.0 ], [ -5.0, 50.0 ], [ -5.0, 45.0 ] ] ] } } } }, "direction" : "forward" }, "rejectedPlans" : [] }, "executionStats" : { "executionSuccess" : true, "nReturned" : 18254550, "executionTimeMillis" : 92372, "totalKeysExamined" : 0, "totalDocsExamined" : 19035630, "executionStages" : { "stage" : "COLLSCAN", "filter" : { "geoloc" : { "$geoWithin" : { "$geometry" : { "type" : "Polygon", "coordinates" : [ [ [ -5.0, 45.0 ], [ 0.0, 45.0 ], [ 0.0, 50.0 ], [ -5.0, 50.0 ], [ -5.0, 45.0 ] ] ] } } } }, "nReturned" : 18254550, "executionTimeMillisEstimate" : 33859, "works" : 19035632, "advanced" : 18254550, "needTime" : 781081, "needYield" : 0, "saveState" : 19280, "restoreState" : 19280, "isEOF" : 1, "direction" : "forward", "docsExamined" : 19035630 } }, "serverInfo" : { "host" : "ubuntu16", "port" : 27017, "version" : "4.4.1", "gitVersion" : "ad91a93a5a31e175f5cbf8c69561e788bbc55ce1" }, "ok" : 1.0 } ############################# WITH INDEX ############################# /* 1 */ { "queryPlanner" : { "plannerVersion" : 1, "namespace" : "mscdata.nari_dynamic", "indexFilterSet" : false, "parsedQuery" : { "geoloc" : { "$geoWithin" : { "$geometry" : { "type" : "Polygon", "coordinates" : [ [ [ -5.0, 45.0 ], [ 0.0, 45.0 ], [ 0.0, 50.0 ], [ -5.0, 50.0 ], [ -5.0, 45.0 ] ] ] } } } }, "optimizedPipeline" : true, "winningPlan" : { "stage" : "PROJECTION_SIMPLE", "transformBy" : { "_id" : true }, "inputStage" : { "stage" : "FETCH", "filter" : { "geoloc" : { "$geoWithin" : { "$geometry" : { "type" : "Polygon", "coordinates" : [ [ [ -5.0, 45.0 ], [ 0.0, 45.0 ], [ 0.0, 50.0 ], [ -5.0, 50.0 ], [ -5.0, 45.0 ] ] ] } } } }, "inputStage" : { "stage" : "IXSCAN", "keyPattern" : { "geoloc" : "2dsphere" }, "indexName" : "geocol", "isMultiKey" : false, "multiKeyPaths" : { "geoloc" : [] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "geoloc" : [ "[936748722493063168, 936748722493063168]", "[954763121002545152, 954763121002545152]", "[959266720629915648, 959266720629915648]", "[960392620536758272, 960392620536758272]", "[960674095513468928, 960674095513468928]", "[960744464257646592, 960744464257646592]", "[960762056443691008, 960762056443691008]", "[960766454490202112, 960766454490202112]", "[960767554001829888, 960767554001829888]", "[960767828879736832, 960767828879736832]", "[960767897599213568, 960767897599213568]", "[960767914779082752, 960767914779082752]", "[960767919074050048, 960767919074050048]", "[960767920147791872, 960767920147791872]", "[960767920416227328, 960767920416227328]", "[960767920483336192, 960767920483336192]", "[960767920500113408, 960767920500113408]", "[960767920504307712, 960767920504307712]", "[960767920505356288, 960767920505356288]", "[960767920505618432, 960767920505618432]", "[960767920505683968, 960767920505683968]", "[960767920505683969, 960767920505716735]", "[1345075088707977217, 1345075088708009983]", "[1345075088708009984, 1345075088708009984]", "[1345075088708075520, 1345075088708075520]", "[1345075088708337664, 1345075088708337664]", "[1345075088709386240, 1345075088709386240]", "[1345075088713580544, 1345075088713580544]", "[1345075088730357760, 1345075088730357760]", "[1345075088797466624, 1345075088797466624]", "[1345075089065902080, 1345075089065902080]", "[1345075090139643904, 1345075090139643904]", "[1345075094434611200, 1345075094434611200]", "[1345075111614480384, 1345075111614480384]", "[1345075180333957120, 1345075180333957120]", "[1345075455211864064, 1345075455211864064]", "[1345076554723491840, 1345076554723491840]", "[1345080952770002944, 1345080952770002944]", "[1345098544956047360, 1345098544956047360]", "[1345168913700225024, 1345168913700225024]", "[1345450388676935680, 1345450388676935680]", "[1346576288583778304, 1346576288583778304]", "[1351079888211148800, 1351079888211148800]", "[1369094286720630784, 1369094286720630784]", "[5116089176692883456, 5116089176692883456]", "[5170132372221329408, 5170132372221329408]", "[5179139571476070401, 5179702521429491711]", "[5179702521429491713, 5180265471382913023]", "[5180265471382913024, 5180265471382913024]", "[5183643171103440896, 5183643171103440896]", "[5187020870823968768, 5187020870823968768]", "[5187020870823968769, 5187583820777390079]", "[5187583820777390081, 5188146770730811391]", "[5188146770730811393, 5197153969985552383]", "[5206161169240293376, 5206161169240293376]", "[5218264593238851584, 5218264593238851584]", "[5218264593238851585, 5218405330727206911]", "[5218546068215562240, 5218546068215562240]", "[5218546068215562241, 5219109018168983551]", "[5219671968122404864, 5219671968122404864]", "[5220234918075826177, 5220797868029247487]", "[5220797868029247488, 5220797868029247488]", "[5220938605517602817, 5221079343005958143]", "[5221079343005958144, 5221079343005958144]", "[5260204364768739328, 5260204364768739328]" ] } } } }, "rejectedPlans" : [] }, "executionStats" : { "executionSuccess" : true, "nReturned" : 18254550, "executionTimeMillis" : 363103, "totalKeysExamined" : 18854121, "totalDocsExamined" : 18854117, "executionStages" : { "stage" : "PROJECTION_SIMPLE", "nReturned" : 18254550, "executionTimeMillisEstimate" : 288803, "works" : 18854122, "advanced" : 18254550, "needTime" : 599571, "needYield" : 0, "saveState" : 24778, "restoreState" : 24778, "isEOF" : 1, "transformBy" : { "_id" : true }, "inputStage" : { "stage" : "FETCH", "filter" : { "geoloc" : { "$geoWithin" : { "$geometry" : { "type" : "Polygon", "coordinates" : [ [ [ -5.0, 45.0 ], [ 0.0, 45.0 ], [ 0.0, 50.0 ], [ -5.0, 50.0 ], [ -5.0, 45.0 ] ] ] } } } }, "nReturned" : 18254550, "executionTimeMillisEstimate" : 282163, "works" : 18854122, "advanced" : 18254550, "needTime" : 599571, "needYield" : 0, "saveState" : 24778, "restoreState" : 24778, "isEOF" : 1, "docsExamined" : 18854117, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 18854117, "executionTimeMillisEstimate" : 27021, "works" : 18854122, "advanced" : 18854117, "needTime" : 4, "needYield" : 0, "saveState" : 24778, "restoreState" : 24778, "isEOF" : 1, "keyPattern" : { "geoloc" : "2dsphere" }, "indexName" : "geocol", "isMultiKey" : false, "multiKeyPaths" : { "geoloc" : [] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "geoloc" : [ "[936748722493063168, 936748722493063168]", "[954763121002545152, 954763121002545152]", "[959266720629915648, 959266720629915648]", "[960392620536758272, 960392620536758272]", "[960674095513468928, 960674095513468928]", "[960744464257646592, 960744464257646592]", "[960762056443691008, 960762056443691008]", "[960766454490202112, 960766454490202112]", "[960767554001829888, 960767554001829888]", "[960767828879736832, 960767828879736832]", "[960767897599213568, 960767897599213568]", "[960767914779082752, 960767914779082752]", "[960767919074050048, 960767919074050048]", "[960767920147791872, 960767920147791872]", "[960767920416227328, 960767920416227328]", "[960767920483336192, 960767920483336192]", "[960767920500113408, 960767920500113408]", "[960767920504307712, 960767920504307712]", "[960767920505356288, 960767920505356288]", "[960767920505618432, 960767920505618432]", "[960767920505683968, 960767920505683968]", "[960767920505683969, 960767920505716735]", "[1345075088707977217, 1345075088708009983]", "[1345075088708009984, 1345075088708009984]", "[1345075088708075520, 1345075088708075520]", "[1345075088708337664, 1345075088708337664]", "[1345075088709386240, 1345075088709386240]", "[1345075088713580544, 1345075088713580544]", "[1345075088730357760, 1345075088730357760]", "[1345075088797466624, 1345075088797466624]", "[1345075089065902080, 1345075089065902080]", "[1345075090139643904, 1345075090139643904]", "[1345075094434611200, 1345075094434611200]", "[1345075111614480384, 1345075111614480384]", "[1345075180333957120, 1345075180333957120]", "[1345075455211864064, 1345075455211864064]", "[1345076554723491840, 1345076554723491840]", "[1345080952770002944, 1345080952770002944]", "[1345098544956047360, 1345098544956047360]", "[1345168913700225024, 1345168913700225024]", "[1345450388676935680, 1345450388676935680]", "[1346576288583778304, 1346576288583778304]", "[1351079888211148800, 1351079888211148800]", "[1369094286720630784, 1369094286720630784]", "[5116089176692883456, 5116089176692883456]", "[5170132372221329408, 5170132372221329408]", "[5179139571476070401, 5179702521429491711]", "[5179702521429491713, 5180265471382913023]", "[5180265471382913024, 5180265471382913024]", "[5183643171103440896, 5183643171103440896]", "[5187020870823968768, 5187020870823968768]", "[5187020870823968769, 5187583820777390079]", "[5187583820777390081, 5188146770730811391]", "[5188146770730811393, 5197153969985552383]", "[5206161169240293376, 5206161169240293376]", "[5218264593238851584, 5218264593238851584]", "[5218264593238851585, 5218405330727206911]", "[5218546068215562240, 5218546068215562240]", "[5218546068215562241, 5219109018168983551]", "[5219671968122404864, 5219671968122404864]", "[5220234918075826177, 5220797868029247487]", "[5220797868029247488, 5220797868029247488]", "[5220938605517602817, 5221079343005958143]", "[5221079343005958144, 5221079343005958144]", "[5260204364768739328, 5260204364768739328]" ] }, "keysExamined" : 18854121, "seeks" : 5, "dupsTested" : 0, "dupsDropped" : 0 } } } }, "serverInfo" : { "host" : "ubuntu16", "port" : 27017, "version" : "4.4.1", "gitVersion" : "ad91a93a5a31e175f5cbf8c69561e788bbc55ce1" }, "ok" : 1.0 } /* 2 */ { "queryPlanner" : { "plannerVersion" : 1, "namespace" : "mscdata.nari_dynamic", "indexFilterSet" : false, "parsedQuery" : { "geoloc" : { "$geoWithin" : { "$geometry" : { "type" : "Polygon", "coordinates" : [ [ [ -5.0, 45.0 ], [ 0.0, 45.0 ], [ 0.0, 50.0 ], [ -5.0, 50.0 ], [ -5.0, 45.0 ] ] ] } } } }, "optimizedPipeline" : true, "winningPlan" : { "stage" : "FETCH", "filter" : { "geoloc" : { "$geoWithin" : { "$geometry" : { "type" : "Polygon", "coordinates" : [ [ [ -5.0, 45.0 ], [ 0.0, 45.0 ], [ 0.0, 50.0 ], [ -5.0, 50.0 ], [ -5.0, 45.0 ] ] ] } } } }, "inputStage" : { "stage" : "IXSCAN", "keyPattern" : { "geoloc" : "2dsphere" }, "indexName" : "geocol", "isMultiKey" : false, "multiKeyPaths" : { "geoloc" : [] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "geoloc" : [ "[936748722493063168, 936748722493063168]", "[954763121002545152, 954763121002545152]", "[959266720629915648, 959266720629915648]", "[960392620536758272, 960392620536758272]", "[960674095513468928, 960674095513468928]", "[960744464257646592, 960744464257646592]", "[960762056443691008, 960762056443691008]", "[960766454490202112, 960766454490202112]", "[960767554001829888, 960767554001829888]", "[960767828879736832, 960767828879736832]", "[960767897599213568, 960767897599213568]", "[960767914779082752, 960767914779082752]", "[960767919074050048, 960767919074050048]", "[960767920147791872, 960767920147791872]", "[960767920416227328, 960767920416227328]", "[960767920483336192, 960767920483336192]", "[960767920500113408, 960767920500113408]", "[960767920504307712, 960767920504307712]", "[960767920505356288, 960767920505356288]", "[960767920505618432, 960767920505618432]", "[960767920505683968, 960767920505683968]", "[960767920505683969, 960767920505716735]", "[1345075088707977217, 1345075088708009983]", "[1345075088708009984, 1345075088708009984]", "[1345075088708075520, 1345075088708075520]", "[1345075088708337664, 1345075088708337664]", "[1345075088709386240, 1345075088709386240]", "[1345075088713580544, 1345075088713580544]", "[1345075088730357760, 1345075088730357760]", "[1345075088797466624, 1345075088797466624]", "[1345075089065902080, 1345075089065902080]", "[1345075090139643904, 1345075090139643904]", "[1345075094434611200, 1345075094434611200]", "[1345075111614480384, 1345075111614480384]", "[1345075180333957120, 1345075180333957120]", "[1345075455211864064, 1345075455211864064]", "[1345076554723491840, 1345076554723491840]", "[1345080952770002944, 1345080952770002944]", "[1345098544956047360, 1345098544956047360]", "[1345168913700225024, 1345168913700225024]", "[1345450388676935680, 1345450388676935680]", "[1346576288583778304, 1346576288583778304]", "[1351079888211148800, 1351079888211148800]", "[1369094286720630784, 1369094286720630784]", "[5116089176692883456, 5116089176692883456]", "[5170132372221329408, 5170132372221329408]", "[5179139571476070401, 5179702521429491711]", "[5179702521429491713, 5180265471382913023]", "[5180265471382913024, 5180265471382913024]", "[5183643171103440896, 5183643171103440896]", "[5187020870823968768, 5187020870823968768]", "[5187020870823968769, 5187583820777390079]", "[5187583820777390081, 5188146770730811391]", "[5188146770730811393, 5197153969985552383]", "[5206161169240293376, 5206161169240293376]", "[5218264593238851584, 5218264593238851584]", "[5218264593238851585, 5218405330727206911]", "[5218546068215562240, 5218546068215562240]", "[5218546068215562241, 5219109018168983551]", "[5219671968122404864, 5219671968122404864]", "[5220234918075826177, 5220797868029247487]", "[5220797868029247488, 5220797868029247488]", "[5220938605517602817, 5221079343005958143]", "[5221079343005958144, 5221079343005958144]", "[5260204364768739328, 5260204364768739328]" ] } } }, "rejectedPlans" : [] }, "executionStats" : { "executionSuccess" : true, "nReturned" : 18254550, "executionTimeMillis" : 377805, "totalKeysExamined" : 18854121, "totalDocsExamined" : 18854117, "executionStages" : { "stage" : "FETCH", "filter" : { "geoloc" : { "$geoWithin" : { "$geometry" : { "type" : "Polygon", "coordinates" : [ [ [ -5.0, 45.0 ], [ 0.0, 45.0 ], [ 0.0, 50.0 ], [ -5.0, 50.0 ], [ -5.0, 45.0 ] ] ] } } } }, "nReturned" : 18254550, "executionTimeMillisEstimate" : 304306, "works" : 18854122, "advanced" : 18254550, "needTime" : 599571, "needYield" : 0, "saveState" : 25332, "restoreState" : 25332, "isEOF" : 1, "docsExamined" : 18854117, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 18854117, "executionTimeMillisEstimate" : 29739, "works" : 18854122, "advanced" : 18854117, "needTime" : 4, "needYield" : 0, "saveState" : 25332, "restoreState" : 25332, "isEOF" : 1, "keyPattern" : { "geoloc" : "2dsphere" }, "indexName" : "geocol", "isMultiKey" : false, "multiKeyPaths" : { "geoloc" : [] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "geoloc" : [ "[936748722493063168, 936748722493063168]", "[954763121002545152, 954763121002545152]", "[959266720629915648, 959266720629915648]", "[960392620536758272, 960392620536758272]", "[960674095513468928, 960674095513468928]", "[960744464257646592, 960744464257646592]", "[960762056443691008, 960762056443691008]", "[960766454490202112, 960766454490202112]", "[960767554001829888, 960767554001829888]", "[960767828879736832, 960767828879736832]", "[960767897599213568, 960767897599213568]", "[960767914779082752, 960767914779082752]", "[960767919074050048, 960767919074050048]", "[960767920147791872, 960767920147791872]", "[960767920416227328, 960767920416227328]", "[960767920483336192, 960767920483336192]", "[960767920500113408, 960767920500113408]", "[960767920504307712, 960767920504307712]", "[960767920505356288, 960767920505356288]", "[960767920505618432, 960767920505618432]", "[960767920505683968, 960767920505683968]", "[960767920505683969, 960767920505716735]", "[1345075088707977217, 1345075088708009983]", "[1345075088708009984, 1345075088708009984]", "[1345075088708075520, 1345075088708075520]", "[1345075088708337664, 1345075088708337664]", "[1345075088709386240, 1345075088709386240]", "[1345075088713580544, 1345075088713580544]", "[1345075088730357760, 1345075088730357760]", "[1345075088797466624, 1345075088797466624]", "[1345075089065902080, 1345075089065902080]", "[1345075090139643904, 1345075090139643904]", "[1345075094434611200, 1345075094434611200]", "[1345075111614480384, 1345075111614480384]", "[1345075180333957120, 1345075180333957120]", "[1345075455211864064, 1345075455211864064]", "[1345076554723491840, 1345076554723491840]", "[1345080952770002944, 1345080952770002944]", "[1345098544956047360, 1345098544956047360]", "[1345168913700225024, 1345168913700225024]", "[1345450388676935680, 1345450388676935680]", "[1346576288583778304, 1346576288583778304]", "[1351079888211148800, 1351079888211148800]", "[1369094286720630784, 1369094286720630784]", "[5116089176692883456, 5116089176692883456]", "[5170132372221329408, 5170132372221329408]", "[5179139571476070401, 5179702521429491711]", "[5179702521429491713, 5180265471382913023]", "[5180265471382913024, 5180265471382913024]", "[5183643171103440896, 5183643171103440896]", "[5187020870823968768, 5187020870823968768]", "[5187020870823968769, 5187583820777390079]", "[5187583820777390081, 5188146770730811391]", "[5188146770730811393, 5197153969985552383]", "[5206161169240293376, 5206161169240293376]", "[5218264593238851584, 5218264593238851584]", "[5218264593238851585, 5218405330727206911]", "[5218546068215562240, 5218546068215562240]", "[5218546068215562241, 5219109018168983551]", "[5219671968122404864, 5219671968122404864]", "[5220234918075826177, 5220797868029247487]", "[5220797868029247488, 5220797868029247488]", "[5220938605517602817, 5221079343005958143]", "[5221079343005958144, 5221079343005958144]", "[5260204364768739328, 5260204364768739328]" ] }, "keysExamined" : 18854121, "seeks" : 5, "dupsTested" : 0, "dupsDropped" : 0 } } }, "serverInfo" : { "host" : "ubuntu16", "port" : 27017, "version" : "4.4.1", "gitVersion" : "ad91a93a5a31e175f5cbf8c69561e788bbc55ce1" }, "ok" : 1.0 }