|
, "saveState" : 0, "restoreState" : 0, "isEOF" : 1, "invalidates" : 0, "direction" : "forward", "docsExamined" : 3 }, "ts" : ISODate("2015-08-06T05:28:23.407Z"), "client" : "127.0.0.1", "allUsers" : [ ], "user" : "" }
wind:PRIMARY>
---6.评估查询
wind:PRIMARY> db.tblbooks.find({"orderno" : {$in: ["1001","1189"]}});
{ "_id" : ObjectId("55c069cf0bef81df34afc6d3"), "orderno" : "1001", "pname" : "jinri", "scity" : "pek", "price" : 1650 }
{ "_id" : ObjectId("55c0701c9ee8e3a9b7f8109f"), "orderno" : "1189", "pname" : "ocpyang", "scity" : "ctu", "price" : 780 }
wind:PRIMARY> db.tblbooks.find({"orderno" : {$in: ["1001","1189"]}}).explain();
{
"queryPlanner" : {
"plannerVersion" : 1,
"namespace" : "snow.tblbooks",
"indexFilterSet" : false,
"parsedQuery" : {
"orderno" : {
"$in" : [
"1001",
"1189"
]
}
},
"winningPlan" : {
"stage" : "COLLSCAN",
"filter" : {
"orderno" : {
"$in" : [
"1001",
"1189"
]
}
},
"direction" : "forward"
},
"rejectedPlans" : [ ]
},
"serverInfo" : {
"host" : "mg02.atalas.com",
"port" : 27017,
"version" : "3.0.5",
"gitVersion" : "8bc4ae20708dbb493cb09338d9e7be6698e4a3a3"
},
"ok" : 1
}
wind:PRIMARY>
----7.诊断命令top
use admin;
db.runCommand({top : 1});
wind:PRIMARY> db.runCommand({top : 1});
{
"totals" : {
"note" : "all times in microseconds",
"admin.system.roles" : {
"total" : {
"time" : 198,
"count" : 1
},
"readLock" : {
"time" : 198,
"count" : 1
},
"writeLock" : {
"time" : 0,
"count" : 0
},
"queries" : {
"time" : 198,
"count" : 1
},
"getmore" : {
"time" : 0,
"count" : 0
},
"insert" : {
"time" : 0,
"count" : 0
},
"update" : {
"time" : 0,
"count" : 0
},
"remove" : {
"time" : 0,
"count" : 0
},
"commands" : {
"time" : 0,
"count" : 0
}
},
"admin.system.version" : {
"total" : {
"time" : 19,
"count" : 1
},
"readLock" : {
"time" : 19,
"count" : 1
},
"writeLock" : {
"time" : 0,
"count" : 0
},
"queries" : {
"time" : 19,
"count" : 1
},
"getmore" : {
"time" : 0,
"count" : 0
},
"insert" : {
"time" : 0,
"count" : 0
},
"update" : {
"time" : 0,
"count" : 0
},
"remove" : {
"time" : 0,
"count" : 0
},
"commands" : {
"time" : 0,
"count" : 0
}
},
"jinri.system.indexes" : {
"total" : {
"time" : 100018,
"count" : 41799
},
"readLock" : {
"time" : 100017,
"count" : 41798
},
"writeLock" : {
"time" : 1,
"count" : 1
},
"queries" : {
"time" : 1,
"count" : 1
},
"getmore" : {
"time" : 0,
"count" : 0
},
"insert" : {
"time" : 0,
"count" : 0
},
"update" : {
"time" : 0,
"count" : 0
},
"remove" : {
"time" : 0,
"count" : 0
},
"commands" : {
"time" : 0,
"count" : 0
}
},
"jinri.system.namespaces" : {
"total" : {
"time" : 103262,
"count" : 41799
},
"readLock" : {
"time" : 103260,
"count" : 4 |