Sort exceeded memory limit of 33554432 bytes error even after adding index

[steevej (Steeve Juneau)]

You could try to $sort before the $facet.

You could also eliminate your empty $match

@Vishnu_Ramana

{ "$match" : {}}

since it might throw off of the optimizer.