Run the command below after switch database. use test; db.collname.find( { }, { _id: 1, _id: 0 } ).hint( { _id: 1 } ).explain(true) “chunkSkips” : 0, check the chunkskips row. If its greater than 0 that means there are some orphan records on mongodb. —— Clear Orphan var dbName: Continue Reading