Tuesday, April 5, 2011

In MongoDB, is there anyway to tell what index is on a collection besides using coll.find({...}).explain()?

I think explain() will tell any possible index it can use. How about just showing all the indexes defined on the collection? (or even for the whole db?)

From stackoverflow
  • >db.system.indexes.find();
    
    >db.system.indexes.find( { ns: "tablename" } );
    

    will give you something like

     { 
      "ns" : "test.fs.chunks", 
      "key" : { "files_id" : 1, "n" : 1 }, 
      "name" : "files_id_1_n_1" 
     }
    

    for every index (ns is the collection name).

    動靜能量 : looks like the `ns:` portion needs a database name and collection name, such as `foo.analytics`

0 comments:

Post a Comment