Check keys examined and docs examined.

Section: Cross-database tools

MongoDB executionStats

javascript
javascript
db.users.find({ email: 'a@example.com' }).explain('executionStats')
Explanation

A large drop in docs examined is a strong sign the index is paying off.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing Cross-database tools
PostgreSQL EXPLAIN ANALYZE
See actual runtime, loops, and buffer reads.
OpenIn sheetsqlsame section
MySQL EXPLAIN
Inspect access path and chosen key.
OpenIn sheetsqlsame section
SQLite EXPLAIN QUERY PLAN
Inspect scans versus indexed searches.
OpenIn sheetsqlsame section
Healthy plan signals
A quick review checklist after creating an index.