Help me to improve this lookup query

{

                        $lookup: {

                            from: "listings",

                            as: "listings",

                            let: { listingId: "$_id" },

                            pipeline: [

                                {

                                    $match: {

                                        $expr: {

                                            $and: [

                                                { $eq: ["$project", "$$listingId"] },

                                                { $eq: ["$status", "available"] },

                                            ],

                                        },

                                    },

                                },

                            ],

                        },

                    },

This lookup query is very slow. Can someone help to find an alternative or improve this query performance?

You only shared the $lookup stage. What do you have before and after? The issue might not be the $lookup.

What are your indexes?

What is your installation? RAM vs working set size.