collection_size_to_csv.js

Exporting collection size to csv.

use <dbname>;

var collectionNames = db.getCollectionNames(), stats = [];

collectionNames.forEach(function(n){ 
    stats.push(db[n].stats()); 
});

stats = stats.sort(function(a, b) { return b['size'] - a['size']; });

print("collection,size,sizeOnDisk");
for(var c in stats){
    print(stats[c]['ns'] + "," + stats[c]['size'] + "," + stats[c]['storageSize']); // in bytes
    //print(stats[c]['ns'] + "," + stats[c]['size']/1000000 + "," + stats[c]['storageSize']/1000000); // in MBs
    //print(stats[c]['ns'] + "," + stats[c]['size']/1000000000 + "," + stats[c]['storageSize']/1000000000); // in GBs
}

// How to use:
// cat collection_size_to_csv.js | mongo > output.csv