Why is this aggregation query causing a partial collection scan?


Could you kindly tell me why the following $facet stage is resulting in a large partial document scan?

Oddly, looking at explain roughly 60k of 200k documents in total get examined when running this query, despite the $limit stage:

“docs”: [ {“$match”:{}},{“$skip”:0},{“$limit”:10}]

Thank you

We do not have enough information to help.

Please provide sample documents from your collection.

Please provide the whole pipeline.

Please provide the explain plan.