mongodbmongodb-queryaggregation-frameworkmongodb-indexes

How does mongodb use an index to count documents?

According to docs, db.collection.countDocuments() wraps this:

db.collection.aggregate([
   { $match: <query> },
   { $group: { _id: null, n: { $sum: 1 } } }
])

Even if there is an index, all of the matched docs will be passed into the $group to be counted, no?

If not, how is mongodb able to count the docs without processing all matching docs?

Solution

  • The MongoDB query planner can make some optimizations.

    In that sample aggregation, it can see that no fields are required except for the ones referenced in <query>, so it can add an implicit $project stage to select only those fields.

    If those fields and the _id are all included in a single index, there is no need to fetch the documents to execute that query, all the necessary information is available from the index.