Measure time of query in Mongo

Question

How can I measure execution time of query in MongoDB ? I found Mongo-hacker plugin but it looks like it measure time of query including time of displaying all results. In PostgreSQL I use Explain Analyze SELECT ... , but i didn't found any information about time in mongo's db.collection.find({smth}).explain()

score 80 · Answer 1 · answered Sep 28 '17 at 08:28

80

You can add .explain("executionStats") at the end of the query.

answered Sep 28 '17 at 08:28

Rohit Patwa

1,092
1
9
12

8

If you need execution stats for an `aggregate` query, look here: https://jira.mongodb.org/browse/SERVER-19758 – Manuel Jun 04 '18 at 10:23
1

What about measuring execution time of insert operation? – Paweł Raglis Jan 19 '23 at 21:10
How to find execution time for updateOne operation ? – Jet Mar 20 '23 at 09:56

score 17 · Accepted Answer · answered Apr 15 '16 at 14:50

17

The easiest way is to set the profiling level in MongoDB: https://docs.mongodb.org/manual/tutorial/manage-the-database-profiler/

Once you've done this, details on all of your queries will be logged to the system profile table.

answered Apr 15 '16 at 14:50

James Crosswell

648
4
13

Himanshu Gupta · Answer 3 · 2021-07-01T08:54:53.953

Using Robo 3T and this worked for me in aggregation -

db.getCollection('product_verification').explain("executionStats").aggregate([
{$match: {"company_id":1}},
{$lookup: {
    "from": "product",
    "let": {"company": "$company_id", "code": "$item_code"},
    "pipeline": [
       {$match: {$expr: {$and: [
           {"$eq": ["$company_id", "$$company"]},
           {"$eq": ["$item_code", "$$code"]},
           {"$in": ["$brand_uid",[13, 20]]}
           ]}
           }}
    ],
    "as": "details"
    }}])

And when using not aggregation

db.getCollection('product').find({name: "lenovo"}).explain("executionStats")

Measure time of query in Mongo

3 Answers3