Details
-
Bug
-
Status: Closed
-
Minor - P4
-
Resolution: Gone away
-
None
-
None
-
None
-
Query Integration
-
ALL
-
-
QO 2021-11-15, QO 2021-11-29, QO 2021-12-13, QO 2021-12-27, QO 2022-01-10, QO 2022-01-24, QO 2022-02-07, QO 2022-02-21, QO 2022-03-07, QO 2022-03-21, QO 2022-04-04, QO 2022-04-18, QO 2022-05-02, QO 2022-05-16, QO 2022-05-30, QO 2022-06-13, QO 2022-06-27, QO 2022-07-11, QO 2022-07-25, QO 2022-08-08, QO 2022-08-22, QO 2022-09-05, QO 2022-09-19, QO 2022-10-03, QE 2022-10-17
Description
Querying a time-series collection produces a confusing query plan that has each $match predicate duplicated twice.
"winningPlan" : { |
"stage" : "SHARDING_FILTER", |
"inputStage" : { |
"stage" : "FETCH", |
"filter" : { |
"$and" : [ |
{
|
"_id" : { |
"$lte" : ObjectId("615776d0ffffffffffffffff") |
}
|
},
|
{
|
"_id" : { |
"$lte" : ObjectId("615776d0ffffffffffffffff") |
}
|
},
|
{
|
"_id" : { |
"$gte" : ObjectId("615625500000000000000000") |
}
|
},
|
{
|
"_id" : { |
"$gte" : ObjectId("615625500000000000000000") |
}
|
},
|
{
|
"control.max.time" : { |
"$_internalExprGte" : ISODate("2021-10-01T21:00:00Z") |
}
|
},
|
{
|
"control.max.time" : { |
"$_internalExprGte" : ISODate("2021-10-01T21:00:00Z") |
}
|
}
|
]
|
},
|
"inputStage" : { |
"stage" : "IXSCAN", |
"keyPattern" : { |
"control.min.time" : 1 |
},
|
"indexName" : "control.min.time_1", |
"isMultiKey" : false, |
"multiKeyPaths" : { |
"control.min.time" : [ ] |
},
|
"isUnique" : false, |
"isSparse" : false, |
"isPartial" : false, |
"indexVersion" : 2, |
"direction" : "forward", |
"indexBounds" : { |
"control.min.time" : [ |
"[new Date(1633035600000), new Date(1633122000000)]" |
]
|
}
|
}
|
}
|
}
|
Attachments
Issue Links
- is related to
-
SERVER-75079 Simplify boolean expressions before feeding them to the optimizer
-
- Open
-
-
SERVER-31360 MatchExpression::getOptimizer() for $or/$and should collapse equivalent clauses
-
- Backlog
-
- related to
-
SERVER-75998 Complete TODO listed in SERVER-60373
-
- Closed
-
-
SERVER-22857 eliminate redundant conditions/clauses from query
-
- Backlog
-