mongosh appdb --eval 'db.users.explain("executionStats").find({email: "a@b.com"})'

Category: Databases & SQL

mongosh appdb --eval 'db.users.explain("executionStats").find({email: "a@b.com"})'

Explain a query with execution stats

Runs the query in explain mode and reports the winning plan, documents examined, and execution time. Documents examined far above documents returned usually means a missing index. The core tool for query tuning.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.