$indexStats (Index Stats)

Last updated: 2026-10-09

$indexStats (Index Stats)

$indexStats returns usage statistics per index — name, access count, misses, and last-use time — one document per index. Use it to find unused indexes or evaluate hit rates. Counters accumulate on the mongod instance and reset on restart; sharded collections report per shard.

📝 Syntax

{ $indexStats: {} }

Returns：One statistics document per index

▶ Example

Run the commands below in your local mongosh (requires a running mongod):

// $indexStats: usage of each index on orders
db.orders.aggregate([
  { $indexStats: {} }
])

Output：

// One document per index with name, accesses, etc.

📌 Notes

• Counters accumulate from mongod start and reset on restart
• For index size and structure use $collStats instead
• Sharded collections emit one row per shard

🏷️ Related Tags

💡 Related Cases

📚 Related Tutorials

❓ FAQ

Web-Tutorial Tech Team

A team of developers maintaining programming tutorials. Each tutorial is written and reviewed by developers with expertise in that field. We work to keep our content accurate and reliable — if you spot an issue, please let us know.

About Us