Why is my FETCH in aggregation so slow?

[Aasawari (Aasawari Sahasrabuddhe)]

Hi @eddy_turbox and welcome to the MongoDB community forum!!

@eddy_turbox

"indexBounds" : {
					"date" : [ "[new Date(...), new Date(...))" ],
					"extra_attributes.attribute" : [ "[\"\", \"\"]" ],
					"extra_attributes.value" : [ "[MinKey, MaxKey]" ],
					"is_valid" : [ "[false, false]", "[true, true]" ],
					"name" : [ "[MinKey, MaxKey]" ]
				}

From the execution stats being shared above, it looks like the indexes are being used and seems to be optimal for the current criteria.
However, for further understanding, could you share the aggregation pipeline that you are trying and the index created for the above sample documents.

Best Regards
Aasawari