I am getting performance issue with this aggregation pipeline?This almost takes 20 sec to give response of 30000 records

Did you made any progress on your side?

What did you tried?

@John_Sewell, presented a few things to try like embedding and view, was any useful? Which one you tried? What worked and what failed?

Other People cannot keep working on your issue if you do not followup on the previous advice.