I’ll introduce how to measure the total execution time of MongoDB queries.

Background: Want to Measure Query Execution Time Other Than explain()

To measure execution time of MongoDB find or aggregate queries, there are the following methods:

• explain for find etc.: cursor.explain() — MongoDB Manual
• explain for aggregate: [MongoDB] aggregate の実行時間を確認する方法 | CodeNote

This article introduces how to measure total execution time of JavaScript code spanning multiple lines, not just measuring a single find() or aggregate().

Sample Code for Measuring Total Execution Time of MongoDB Queries

var before = new Date()

// execute your query

load('/path/to/your_query.js')

var after = new Date()
var executionMilliseconds = after - before

print(executionMilliseconds + ' ms')
print(executionMilliseconds/1000 + ' sec')

That’s all from the Gemba.

Reference Information

• mongodb: how can I see the execution time for the aggregate command? - Stack Overflow