[SERVER-7578] QueryOptimizer not choosing the right key when querying. From a query of 16087 millis to 29 millis Created: 07/Nov/12  Updated: 07/Mar/14  Resolved: 07/Nov/12

Status: Closed
Project: Core Server
Component/s: Querying
Affects Version/s: 2.2.0
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: Esteban Feldman Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Linux vizvid-mongo-1 3.2.0-31-virtual #50-Ubuntu SMP Fri Sep 7 16:36:36 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux 8GB ram


Issue Links:
Duplicate
duplicates SERVER-7579 QueryOptimizer not choosing the right... Closed
Operating System: Linux
Participants:

 Description   

mongos> db.current_views.find({ ts:

{ $gte: 1352300700, $lt: 1352301000 }

, site: "506f0fea7cbdc70464aea9e9" } ).hint(

{site:1}

).explain()
{
"clusteredType" : "ParallelSort",
"shards" : {
"vizvid-mongo-1:27019" : [
{
"cursor" : "BtreeCursor site_1",
"isMultiKey" : false,
"n" : 3413,
"nscannedObjects" : 4470768,
"nscanned" : 4470768,
"nscannedObjectsAllPlans" : 4470768,
"nscannedAllPlans" : 4470768,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 29754,
"nChunkSkips" : 0,
"millis" : 16086,
"indexBounds" :

{ "site" : [ [ "506f0fea7cbdc70464aea9e9", "506f0fea7cbdc70464aea9e9" ] ] }

,
"server" : "vizvid-mongo-1:27019"
}
]
},
"cursor" : "BtreeCursor site_1",
"n" : 3413,
"nChunkSkips" : 0,
"nYields" : 29754,
"nscanned" : 4470768,
"nscannedAllPlans" : 4470768,
"nscannedObjects" : 4470768,
"nscannedObjectsAllPlans" : 4470768,
"millisShardTotal" : 16086,
"millisShardAvg" : 16086,
"millis" : 16086,
"indexBounds" :

{ "site" : [ [ "506f0fea7cbdc70464aea9e9", "506f0fea7cbdc70464aea9e9" ] ] }

,
"server" : "vizvid-mongo-1:27019"
}
]
},
"cursor" : "BtreeCursor site_1",
"n" : 3413,
"nChunkSkips" : 0,
"nYields" : 29754,
"nscanned" : 4470768,
"nscannedAllPlans" : 4470768,
"nscannedObjects" : 4470768,
"nscannedObjectsAllPlans" : 4470768,
"millisShardTotal" : 16086,
"millisShardAvg" : 16086,
"numQueries" : 1,
"numShards" : 1,
"indexBounds" :

{ "site" : [ [ "506f0fea7cbdc70464aea9e9", "506f0fea7cbdc70464aea9e9" ] ] }

,
"millis" : 16087
}

###########################
.... Now with the hint ....
###########################

mongos> db.current_views.find({ ts:

{ $gte: 1352300700, $lt: 1352301000 }

, site: "506f0fea7cbdc70464aea9e9" } ).hint(

{ts:1, site:1}

).explain()
{
"clusteredType" : "ParallelSort",
"shards" : {
"vizvid-mongo-1:27019" : [
{
"cursor" : "BtreeCursor ts_1_site_1",
"isMultiKey" : false,
"n" : 3413,
"nscannedObjects" : 3413,
"nscanned" : 3472,
"nscannedObjectsAllPlans" : 3413,
"nscannedAllPlans" : 3472,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1,
"nChunkSkips" : 0,
"millis" : 27,
"indexBounds" :

{ "ts" : [ [ 1352300700, 1352301000 ] ], "site" : [ [ "506f0fea7cbdc70464aea9e9", "506f0fea7cbdc70464aea9e9" ] ] }

,
"server" : "vizvid-mongo-1:27019"
}
]
},
"cursor" : "BtreeCursor ts_1_site_1",
"n" : 3413,
"nChunkSkips" : 0,
"nYields" : 1,
"nscanned" : 3472,
"nscannedAllPlans" : 3472,
"nscannedObjects" : 3413,
"nscannedObjectsAllPlans" : 3413,
"millisShardTotal" : 27,
"millisShardAvg" : 27,
"numQueries" : 1,
"numShards" : 1,
"indexBounds" :

{ "ts" : [ [ 1352300700, 1352301000 ] ], "site" : [ [ "506f0fea7cbdc70464aea9e9", "506f0fea7cbdc70464aea9e9" ] ] }

,
"millis" : 29
}



 Comments   
Comment by Esteban Feldman [ 07/Nov/12 ]

Ignore this tkt... bad paste... don't know how to edit or delete the tkt.

see this instead https://jira.mongodb.org/browse/SERVER-7579

Generated at Thu Feb 08 03:14:57 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.