List indexes

Show all indexes on a collection

mongosh --eval 'db.myCollection.getIndexes()' mongodb://mongo:27017/mydb
tool
mongodb20 commands
tags
mongodb

More mongodb commands

  • Connect with URI
    mongosh 'mongodb+srv://user:pass@cluster.example.com/mydb'

    Connect to Atlas or any MongoDB URI with mongosh

  • Explain query plan
    db.orders.find({status:'new'}).explain('executionStats')

    Show execution stats including index usage

  • Create compound index
    db.orders.createIndex({userId: 1, createdAt: -1}, {background: true})

    Ascending userId + descending createdAt index

  • Aggregation pipeline example
    db.orders.aggregate([{$match:{status:'paid'}},{$group:{_id:'$userId',total:{$sum:'$amount'}}},{$sort:{total:-1}},{$limit:10}])

    Top 10 users by paid order amount

  • Check replication lag
    rs.printSecondaryReplicationInfo()

    Show secondary lag and oplog window

all 20 mongodb commands