When running query during multiPlanRunner stage some combinations of values and data distribute can cause a fast query have a possible plan/index choice where full index scan (of a non-selective attribute) would be evaluated. Running explain(true) can show which index has unusually high nscanned.
It seems during race-off the full scan is finished, causing some percentage of queries to be excessively slow.
- is related to
-
SERVER-14525 Perf regression in 2.6.2 caused by not caching plans that tie during plan ranking
- Closed
-
SERVER-15528 Distinct queries can scan many index keys without yielding read lock
- Closed
- related to
-
SERVER-14311 skipping of index keys is not accounted for in plan ranking by the index scan stage
- Closed