Aggregation is slow

[steevej (Steeve Juneau)]

It should. But it needs to be the correct one. See

@steevej

What indexes do you have?

@solo_dios

i using indexes (amonut : 1) (date.year : 1) & …

and

@steevej

A compound index that starts with amount is surely useless for most use case. It is for this one for sure. You $match on date.year and date.month. That is the index you need.

and

@steevej

To sum the amount by date an compound index date,amount may also be helped with a $project after $match.