{
$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?