Find unused indexes

Show how often each index is used. An index with zero ops is a candidate to drop and makes writes cheaper

mongosh --eval 'db.<name>.aggregate([{$indexStats:{}}]).forEach(i=>print(i.name,i.accesses.ops))'

tool
mongodb20 commands
tags
mongodbperformancediskmonitoring

More mongodb commands

  • mongosh --eval 'db.setProfilingLevel(1,{slowms:100}); db.system.profile.find().sort({millis:-1}).limit(5)'

    Record operations slower than 100ms, then show the 5 slowest from system.profile

  • mongosh 'mongodb://user:pass@mongo:27017/dbname'

    Open an interactive shell to a MongoDB instance

  • mongosh --eval 'rs.status()' mongodb://mongo:27017

    Show replica set members, lag and election status

  • mongosh --eval 'db.stats()' mongodb://mongo:27017/mydb

    Show data size, storage size and number of collections in a database

  • mongosh --eval 'db.myCollection.stats()' mongodb://mongo:27017/mydb

    Show document count, index sizes and storage size of a collection

all 20 mongodb commands