查看一次mongodb查询所耗费的时间

Question

在命令行中操作mongodb，db.testrests.find({})要想知道这条语句的时间，要怎么查看那？

Answer 1

1. Please use explain directly for find operation, for example:

db.tablename.find().explain( "executionStats" )

关注输出的如下数值：explain.executionStats.executionTimeMillis

2. For Update/delete/insert operations, please set the profile and then check the log, for example:

db.setProfilingLevel(2)
db.getProfilingLevel(）

db.system.profile.find()