Error -- Option "explain" cannot be used on an aggregate call with writeConcern

Prem_kumar_Madheswaran · 2024-09-02T17:44:16.952Z

This is my connection string -
mongodb+srv://clustername:password@clustername.rq1blmy.mongodb.net/company?retryWrites=true&w=majority&appName=Clustername

this is the query i just used -

db.orders.explain(“executionStats”).aggregate([
{
$lookup: {
from: “A”,
localField: “B”,
foreignField: “_id”,
as: “details”
}
},
{
$unwind: “$details”
},
{
$lookup: {
from: “C”,
localField: “_id”,
foreignField: “_id”,
as: “details”
}
},
{
$unwind: “$details”
}
]);

I had tried with multiple updated queries. but all the time i got the Error -
*Option “explain” cannot be used on an aggregate call with writeConcern

How to resolve this error ?

Or is there any other way to find out Execution Time of queries ??

shreya_patel · 2024-09-03T05:44:26.456Z

Hi @Prem_kumar_Madheswaran,

This will help you to solve your error.:

"explain" cannot be used on an aggregate call with writeConcern Working with Data

We are using the explain option when writing aggregations, to debug slow queries etc. However, when we run the queries against one of our environments (stage), we get this error: "explain" cannot be used on an aggregate call with writeConcern Where can I check in atlas what this means / fix it? Thanks for your help.

Best,
Shreya

Prem_kumar_Madheswaran · 2024-09-03T09:37:55.327Z

Hello shreya_thakrar, Thanks for your support

I read this article yesterday, but it doesn’t have a proper solution for this.
Kindly help me with some other ways.

shreya_patel · 2024-09-04T06:14:07.221Z

Hello @Prem_kumar_Madheswaran,

Well, I’m not sure what the other solution will be in this case . I’ll try to find out and get back to you if I’ll have.

Best,
Shreya