getStorageDetailsWithCollection.js

function getStorageDetails() {
  var db = this.db.getSiblingDB("admin");
  var totalIndexSize = 0,
      totalStorageSize = 0,
      totalDataSize = 0,
      formatSize = 1024 * 1024 * 1024;
  
  // List the databases
  var dbs = db.runCommand({ listDatabases: 1 }).databases;
  
  // Loop over and get storage stats for each database
  dbs.forEach(function(database) {
    db = db.getSiblingDB(database.name);
    coll = db.getCollectionNames();
  
    print(`\nDB: ${database.name}:`);
    print(`dataSize: ${db.stats(formatSize).dataSize}`);
    print(`storageSize: ${db.stats(formatSize).storageSize}`);
    print(`indexSize: ${db.stats(formatSize).indexSize}`);

    // Loop over each collection and print the totalIndexSize
    coll.forEach(function(collection) {
      print(`\nCollection: ${collection}:`);
      print(`indexSize: ${db.getCollection(collection).stats(formatSize).totalIndexSize}`);
      print(`dataSize: ${db.getCollection(collection).stats(formatSize).dataSize}`);
      print(`storageSize: ${db.getCollection(collection).stats(formatSize).storageSize}`);
    });
    
   print(`\n=====================================`);

    totalDataSize += db.stats(formatSize).dataSize;
    totalStorageSize += db.stats(formatSize).storageSize;
    totalIndexSize += db.stats(formatSize).indexSize;
  });
  
  // Show total information
  print("\nTotal:");
  print(`dataSize: ${totalDataSize}`);
  print(`storageSize: ${totalStorageSize}`);
  print(`indexSize: ${totalIndexSize}`);
}
 

getStorageDetails();