mongo_cheatsheet.md

MongoDB Cheatsheet

Query plan

db.collection.find().explain()
db.collection.find().explain({ verbose: 'executionStats' })

Profiling

db.getProfilingStatus()
db.getProfilingLevel()
db.setProfilingLevel(1, { slowms: 20 })

db.system.profile.find().limit(10).sort( { ts : -1 } ).pretty()
db.system.profile.find( { millis : { $gt : 5 } } ).pretty()

Indexes

db.collection.getIndexes()
db.collection.createIndex({ field: 1 })
db.collection.createIndex({ field: 'hashed' })