[SERVER-12935] explain output is inaccurate Created: 27/Feb/14 Updated: 11/Jul/16 Resolved: 03/Mar/14 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Querying |
| Affects Version/s: | 2.6.0-rc0 |
| Fix Version/s: | 2.6.0-rc1 |
| Type: | Bug | Priority: | Minor - P4 |
| Reporter: | Stefan Meyer-Kahlen [X] | Assignee: | Benety Goh |
| Resolution: | Done | Votes: | 0 |
| Labels: | coveredIndex, indexing, query | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Backwards Compatibility: | Fully Compatible |
| Operating System: | ALL |
| Participants: |
| Description |
|
In 2.4.9 it worked fine, 2.6.0-rc queries ineffiecently See here for full details: |
| Comments |
| Comment by Benety Goh [ 04/Mar/14 ] | |||||||||||||||||||||||||||||||||||||||||||||||||
|
This is the git hash which fixed the issue: 51300745542e7df3b0864069079e74114c0c42c6 https://github.com/mongodb/mongo/commit/51300745542e7df3b0864069079e74114c0c42c6 planner_analysis.cpp: | |||||||||||||||||||||||||||||||||||||||||||||||||
| Comment by Githook User [ 03/Mar/14 ] | |||||||||||||||||||||||||||||||||||||||||||||||||
|
Author: {u'username': u'benety', u'name': u'Benety Goh', u'email': u'benety@mongodb.com'}Message: | |||||||||||||||||||||||||||||||||||||||||||||||||
| Comment by Daniel Pasette (Inactive) [ 01/Mar/14 ] | |||||||||||||||||||||||||||||||||||||||||||||||||
|
Thanks for the report stefan. I reproduced your issue with 2.6.0-rc0. The scanAndOrder problem is now fixed as of git hash: 2bf41261b20a02f06ec5ad7281f3c16e0b3d7fc3. We'll find out which commit changed the behavior. While repro'ing, I noticed a couple different minor issues with the explain output. It shows, nscannedObjects: 0, indexOnly: true in the beginning of the explain output (clauses), even thought the summary in "QueryOptimizerCursor" is correct.
|