I have a collection with 300,000 documents. In collection there is a 2dsphere index on 'geo' field.
Here is a query I run:
Stats of this query are weird:
In the query I limit results to 500 documents. But in stats I see that mongoDB reads 80166 (objectsLoaded) documents from disk and only then cuts it out.
No need to read extra documents from disk if there is a limit on result length.