View the time spent on a mongodb query

Question

When operating mongodb on the command line, db.testrests.find({})If you want to know the time of this statement, how can you check it?

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()