-
Type:
Improvement
-
Resolution: Unresolved
-
Priority:
Blocker - P1
-
None
-
Affects Version/s: None
-
Component/s: None
-
Query Optimization
-
None
-
None
-
None
-
None
-
None
-
None
-
None
A query that has $all: [...] with many arguments takes long time to estimate, enough to trigger a slow query log event.
Perf reports the following:
+ 99.49% 0.00% conn9 mongod_with_debug [.] mongo::(anonymous namespace)::PrepareExecutionHelper<mongo::PlanCacheKey, mongo::(anonymous namespace)::ClassicRuntimePlannerResult>::prepare() + 99.49% 0.00% conn9 mongod_with_debug [.] mongo::QueryPlanner::planWithCostBasedRanking(mongo::CanonicalQuery const&, mongo::QueryPlannerParams const&, mongo::ce::SamplingEstimator*, mong + 99.46% 0.00% conn9 mongod_with_debug [.] mongo::cost_based_ranker::CardinalityEstimator::estimate(mongo::QuerySolutionNode const*) + 99.46% 0.00% conn9 mongod_with_debug [.] mongo::cost_based_ranker::CardinalityEstimator::estimate(mongo::FetchNode const*) + 99.20% 0.00% conn9 mongod_with_debug [.] mongo::cost_based_ranker::CardinalityEstimator::estimate(mongo::FetchNode const*)::$_1::operator()() const + 98.46% 0.00% conn9 mongod_with_debug [.] mongo::ce::SamplingEstimatorImpl::estimateCardinality(mongo::MatchExpression const*) const + 98.41% 0.01% conn9 mongod_with_debug [.] mongo::exec::matcher::MatchExpressionEvaluator::visit(mongo::AndMatchExpression const*) + 98.39% 15.53% conn9 mongod_with_debug [.] mongo::exec::matcher::MatchExpressionEvaluator::visitPathExpression(mongo::PathMatchExpression const*) + 39.22% 29.10% conn9 mongod_with_debug [.] mongo::BSONElementIterator::more() + 38.04% 15.84% conn9 mongod_with_debug [.] mongo::exec::matcher::MatchesSingleElementEvaluator::visit(mongo::EqualityMatchExpression const*) + 22.21% 22.21% conn9 mongod_with_debug [.] mongo::BSONElement::compareElements(mongo::BSONElement const&, mongo::BSONElement const&, unsigned int, mongo::StringDataComparator const*) + 10.11% 10.11% conn9 mongod_with_debug [.] mongo::BSONElementIterator::subCursorHasMore() + 3.93% 3.93% conn9 mongod_with_debug [.] mongo::BSONElementIterator::next() + 1.64% 1.64% conn9 mongod_with_debug [.] mongo::EqualityMatchExpression::acceptVisitor(mongo::MatchExpressionVisitor<true>*) const
The scenario is DatasetWideArrayIndex.WorkloadAll in jstests/product_limits/query_limits_test.js
- related to
-
-
- Needs Scheduling
-