Take the 2-minute tour ×

Is there a way to track 'query' performance in MongoDB? Specially testing indexes or subdocuments?

In sql you can run queries, see execution time and other analytic metrics.

I have a huge mongoDB collection and want to try different variations and indexes, not sure how to test it, would be nice to see how long did it take to find a record.. (I am new in MongoDB). Thanks

share|improve this question
add comment

2 Answers

up vote 16 down vote accepted

There are two things here that you'll likely be familiar with.

  1. Explain plans
  2. Slow Logs

Explain Plans

Here are some basic docs on explain. Running explain is as simple as db.foo.find(query).explain(). (note that this actually runs the query, so if your query is slow this will be too)

To understand the output, you'll want to check some of the docs on the slow logs below. You're basically given details about "how much index was scanned", "how many are found", etc. As is the case with such performance details, interpretation is really up to you. Read the docs above and below to point you in the right direction.

Slow Logs

By default, slow logs are active with a threshold of 100ms. Here's a link to the full documentation on profiling. A couple of key points to get you started:

Get/Set profiling:

db.setProfilingLevel(2); // 0 => none, 1 => slow, 2 => all

See slow queries:

share|improve this answer
add comment

MongoDB has a query profiler you can turn on. See: http://www.mongodb.org/display/DOCS/Database+Profiler

share|improve this answer
see this page, in particular the See Also section. mongodb.org/display/DOCS/Database+Profiler –  dm. Dec 9 '10 at 16:59
This answer is completely included in the other one... would help to remove it perhaps. –  Dan Dascalescu 2 days ago
add comment

Your Answer


