Performance Issue with $group Pipeline

[Michael_Nwuju (Michael)]

Hi @yoni_egorov, I just responded to you regarding this issue, did you try it out?

Performance Issue when using $group Pipeline

Hi @yoni_egorov, so I took some time to understand what’s going on here, I did some research and yes you are correct, the $group operator does not use indexes. However, I think there’s a better approach to this. In the $group stage, I can see that you are still filtering, which is slowing things down, I think you should move this extra condition to the first $match stage so this makes the query faster. Plus, because the $match stage is basically a .find(), your indexes will work in the $match …