Need help with really slow aggregation

Perhaps you could provide the index information for the collections and the explain result.