In Mongo, how do I display the indexes of a collection?

mongodb indexing mongodb-indexes database
TIMEX picture TIMEX · Dec 19, 2010 · Viewed 23.5k times · Source

I just want to display all the indexes in the shell.

Answer

Cameron picture Cameron · Dec 19, 2010

If you want raw access to the indexes, you can query the db.system.indexes collection:

> db.system.indexes.find()

To find the indexes for a specific collection, you can do:

> db.collection.getIndexes()

See this question.

Related questions

A list of indices in MongoDB?

Is there a way to see a list of indices on a collection in mongodb in shell? i read through http://www.mongodb.org/display/DOCS/Indexes but i dont see anything

Read More
Mongodb background indexes - are they still background once created?

When creating an index in mongodb, you can specify the background: true flag, which causes the index creation to be non-blocking. This is great in production since you don't want the whole database locked up while creating an index that …

Read More
sparse indexes and null values in mongo

I'm not sure I understand sparse indexes correctly. I have a sparse unique index on fbId { "ns" : "mydb.users", "key" : { "fbId" : 1 }, "name" : "fbId_1", "unique" : true, "sparse" : true, "background" : false, "v" : 0 } And I was expecting that would allow me to insert …

Read More