mongodb: how can I see the execution time for the aggregate command?

Question

I execute the follow mongodb command in mongo shell

db.coll.aggregate(...) 

and i see the list of result. but is it possible to see the query execution time? Is there any equivalent function for explain method for aggregation queries.

Answer 1

var before = new Date() #aggregation query var after = new Date() execution_mills = after - before 

Answer 2

You can add a time function to your .mongorc.js file (in your home directory):

function time(command) {     const t1 = new Date();     const result = command();     const t2 = new Date();     print("time: " + (t2 - t1) + "ms");     return result;  } 

and then you can use it like so:

time(() => db.coll.aggregate(...)) 

---

Caution

This method doesn't give relevant results for db.collection.find()