-
Type:
Bug
-
Resolution: Incomplete
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Aggregation Framework
-
None
-
ALL
I Have 8 million records i created compound index on id,ind_id and is_valid this order.
I execute below query, I got 0.2 seconds match result but why $sortByCount result comes too slow.
It takes 2 minutes.
db.panelist.aggregate(
// Pipeline
[
// Stage 1
{
$match: {"$and":
[{id:{$in:[1,2,5,4]}},
{"ind_id":{$exists:true}}
]
}
},
// Stage 2
{
$project: {
"_id":0,
"id":1,
"ind_id":1,
"is_valid":1
}
},
// Stage 3
{
$sortByCount: "$is_valid"
},
],
// Options
{
cursor: {
batchSize: 50
},
allowDiskUse: true
}
// Created with Studio 3T, the IDE for MongoDB - https://studio3t.com/
);
- related to
-
SERVER-7568 Aggregation framework favors non-blocking sorts
-
- Closed
-