gistfile1.txt

db.invitation.find({ "_id" : ObjectId("503f6c14e4b060812b6e99e7")}).explain()
{
	"cursor" : "BtreeCursor _id_",
	"isMultiKey" : false,
	"n" : 1,
	"nscannedObjects" : 1,
	"nscanned" : 1,
	"nscannedObjectsAllPlans" : 1,
	"nscannedAllPlans" : 1,
	"scanAndOrder" : false,
	"indexOnly" : false,
	"nYields" : 0,
	"nChunkSkips" : 0,
	"millis" : 0,
	"indexBounds" : {
		"start" : {
			"_id" : ObjectId("503f6c14e4b060812b6e99e7")
		},
		"end" : {
			"_id" : ObjectId("503f6c14e4b060812b6e99e7")
		}
	},
	"server" : "chainsaw.mongo.prod:27017"
}

09-07-12 - 19:52:13	jeraff	10343	jeraff.activityStream	query	 { "orderby" : { "_id" : -1} , "query" : { "userId" : "503c5822e4b026ff3a442f89"}}	

jeraffprod:PRIMARY> db.activityStream.find({ "userId" : "503c5822e4b026ff3a442f89"}).sort({ "_id" : -1}).explain()
{
	"cursor" : "BtreeCursor userId_1__id_-1",
	"isMultiKey" : false,
	"n" : 44,
	"nscannedObjects" : 44,
	"nscanned" : 44,
	"nscannedObjectsAllPlans" : 44,
	"nscannedAllPlans" : 44,
	"scanAndOrder" : false,
	"indexOnly" : false,
	"nYields" : 0,
	"nChunkSkips" : 0,
	"millis" : 0,
	"indexBounds" : {
		"userId" : [
			[
				"503c5822e4b026ff3a442f89",
				"503c5822e4b026ff3a442f89"
			]
		],
		"_id" : [
			[
				{
					"$maxElement" : 1
				},
				{
					"$minElement" : 1
				}
			]
		]
	},
	"server" : "chainsaw.mongo.prod:27017"
}



09-07-12 - 17:57:32	jeraff	5141	jeraff.relationship	query	 { "orderby" : { "_id" : -1} , "query" : { "followerId" : "503d57c7e4b0476258c7639f"}}
db.relationship.find({ "followerId" : "503d57c7e4b0476258c7639f"}).sort( { "_id" : -1}).explain()
{
	"cursor" : "BtreeCursor followerId_1__id_-1",
	"isMultiKey" : false,
	"n" : 2,
	"nscannedObjects" : 2,
	"nscanned" : 2,
	"nscannedObjectsAllPlans" : 2,
	"nscannedAllPlans" : 2,
	"scanAndOrder" : false,
	"indexOnly" : false,
	"nYields" : 0,
	"nChunkSkips" : 0,
	"millis" : 0,
	"indexBounds" : {
		"followerId" : [
			[
				"503d57c7e4b0476258c7639f",
				"503d57c7e4b0476258c7639f"
			]
		],
		"_id" : [
			[
				{
					"$maxElement" : 1
				},
				{
					"$minElement" : 1
				}
			]
		]
	},
	"server" : "chainsaw.mongo.prod:27017"
}


09-07-12 - 21:54:37	jeraff	1589	jeraff.invitation	query	 { "token" : "43a7409a-af33-4d03-9127-66e9e15684ea"}
db.invitation.find({ "token" : "43a7409a-af33-4d03-9127-66e9e15684ea"}).explain()
{
	"cursor" : "BtreeCursor token_1",
	"isMultiKey" : false,
	"n" : 1,
	"nscannedObjects" : 1,
	"nscanned" : 1,
	"nscannedObjectsAllPlans" : 1,
	"nscannedAllPlans" : 1,
	"scanAndOrder" : false,
	"indexOnly" : false,
	"nYields" : 0,
	"nChunkSkips" : 0,
	"millis" : 0,
	"indexBounds" : {
		"token" : [
			[
				"43a7409a-af33-4d03-9127-66e9e15684ea",
				"43a7409a-af33-4d03-9127-66e9e15684ea"
			]
		]
	},
	"server" : "chainsaw.mongo.prod:27017"
}
jeraffprod:PRIMARY> 



09-08-12 - 06:36:14	jeraff	1389	jeraff.todoList	query	 { "orderby" : { "_id" : -1} , "query" : { "_id" : { "$in" : [ { "$oid" : "50399769e4b0b097af88f5e2"} , { "$oid" : "50452bcee4b056fa716e2e89"} , { "$oid" : "503ff063e4b0855ac6e6a0da"} , { "$oid" : "503ec0a0e4b0a587bb3a348f"} , { "$oid" : "503d73fce4b0e5f503156e35"} , { "$oid" : "503ec45ce4b0a587bb3a9c7c"} , { "$oid" : "503e95e3e4b04e841e30e7c1"} , { "$oid" : "50454a94e4b09d88fe7c212d"} , { "$oid" : "503fd494e4b013b64803edee"}]}}}

db.todoList.find( { "_id" : { "$in" : [ { "$oid" : "50399769e4b0b097af88f5e2"} , { "$oid" : "50452bcee4b056fa716e2e89"} , { "$oid" : "503ff063e4b0855ac6e6a0da"} , { "$oid" : "503ec0a0e4b0a587bb3a348f"} , { "$oid" : "503d73fce4b0e5f503156e35"} , { "$oid" : "503ec45ce4b0a587bb3a9c7c"} , { "$oid" : "503e95e3e4b04e841e30e7c1"} , { "$oid" : "50454a94e4b09d88fe7c212d"} , { "$oid" : "503fd494e4b013b64803edee"}]}}).explain()
{
	"cursor" : "BtreeCursor _id_ multi",
	"isMultiKey" : false,
	"n" : 0,
	"nscannedObjects" : 0,
	"nscanned" : 0,
	"nscannedObjectsAllPlans" : 0,
	"nscannedAllPlans" : 0,
	"scanAndOrder" : false,
	"indexOnly" : false,
	"nYields" : 0,
	"nChunkSkips" : 0,
	"millis" : 0,
	"indexBounds" : {
		"_id" : [
			[
				{
					"$oid" : "50399769e4b0b097af88f5e2"
				},
				{
					"$oid" : "50399769e4b0b097af88f5e2"
				}
			],
			[
				{
					"$oid" : "503d73fce4b0e5f503156e35"
				},
				{
					"$oid" : "503d73fce4b0e5f503156e35"
				}
			],
			[
				{
					"$oid" : "503e95e3e4b04e841e30e7c1"
				},
				{
					"$oid" : "503e95e3e4b04e841e30e7c1"
				}
			],
			[
				{
					"$oid" : "503ec0a0e4b0a587bb3a348f"
				},
				{
					"$oid" : "503ec0a0e4b0a587bb3a348f"
				}
			],
			[
				{
					"$oid" : "503ec45ce4b0a587bb3a9c7c"
				},
				{
					"$oid" : "503ec45ce4b0a587bb3a9c7c"
				}
			],
			[
				{
					"$oid" : "503fd494e4b013b64803edee"
				},
				{
					"$oid" : "503fd494e4b013b64803edee"
				}
			],
			[
				{
					"$oid" : "503ff063e4b0855ac6e6a0da"
				},
				{
					"$oid" : "503ff063e4b0855ac6e6a0da"
				}
			],
			[
				{
					"$oid" : "50452bcee4b056fa716e2e89"
				},
				{
					"$oid" : "50452bcee4b056fa716e2e89"
				}
			],
			[
				{
					"$oid" : "50454a94e4b09d88fe7c212d"
				},
				{
					"$oid" : "50454a94e4b09d88fe7c212d"
				}
			]
		]
	},
	"server" : "chainsaw.mongo.prod:27017"
}
jeraffprod:PRIMARY> 



09-09-12 - 22:59:58	jeraff	493	jeraff.oAuthToken	query	 { "access_token": "4e9115a0afaf9cce6d929dcbd9d49ccb3d6fc8cb" , "isActive" : true}
db.oAuthToken.find({ "access_token" : "xxxx" , "isActive" : true}).explain()
{
	"cursor" : "BtreeCursor access_token_1_isActive_1",
	"isMultiKey" : false,
	"n" : 1,
	"nscannedObjects" : 1,
	"nscanned" : 1,
	"nscannedObjectsAllPlans" : 1,
	"nscannedAllPlans" : 1,
	"scanAndOrder" : false,
	"indexOnly" : false,
	"nYields" : 0,
	"nChunkSkips" : 0,
	"millis" : 0,
	"indexBounds" : {
		"access_token" : [
			[
				"4e9115a0afaf9cce6d929dcbd9d49ccb3d6fc8cb",
				"4e9115a0afaf9cce6d929dcbd9d49ccb3d6fc8cb"
			]
		],
		"isActive" : [
			[
				true,
				true
			]
		]
	},
	"server" : "chainsaw.mongo.prod:27017"
}
jeraffprod:PRIMARY> 



09-07-12 - 20:56:27	jeraff	467	jeraff.userFriendsList	query	 { "type" : 0 , "userId" : "503bc0a6e4b02732caf0b637"}

db.userFriendsList.find({ "type" : 0 , "userId" : "503bc0a6e4b02732caf0b637"}).explain()
{
	"cursor" : "BtreeCursor userId_1_type_1",
	"isMultiKey" : false,
	"n" : 1,
	"nscannedObjects" : 1,
	"nscanned" : 1,
	"nscannedObjectsAllPlans" : 1,
	"nscannedAllPlans" : 1,
	"scanAndOrder" : false,
	"indexOnly" : false,
	"nYields" : 0,
	"nChunkSkips" : 0,
	"millis" : 0,
	"indexBounds" : {
		"userId" : [
			[
				"503bc0a6e4b02732caf0b637",
				"503bc0a6e4b02732caf0b637"
			]
		],
		"type" : [
			[
				0,
				0
			]
		]
	},
	"server" : "chainsaw.mongo.prod:27017"
}


09-07-12 - 16:43:16	jeraff	451	jeraff.notification	query	 { "orderby" : { "_id" : -1} , "query" : { "recipientId" : "503bbb59e4b07292afca2377"}}
db.notification.find({ "recipientId" : "503bbb59e4b07292afca2377"}).sort({"_id": -1}).explain()
{
	"cursor" : "BtreeCursor recipientId_1__id_-1",
	"isMultiKey" : false,
	"n" : 20,
	"nscannedObjects" : 20,
	"nscanned" : 20,
	"nscannedObjectsAllPlans" : 20,
	"nscannedAllPlans" : 20,
	"scanAndOrder" : false,
	"indexOnly" : false,
	"nYields" : 0,
	"nChunkSkips" : 0,
	"millis" : 0,
	"indexBounds" : {
		"recipientId" : [
			[
				"503bbb59e4b07292afca2377",
				"503bbb59e4b07292afca2377"
			]
		],
		"_id" : [
			[
				{
					"$maxElement" : 1
				},
				{
					"$minElement" : 1
				}
			]
		]
	},
	"server" : "chainsaw.mongo.prod:27017"
}