Skip to content

Instantly share code, notes, and snippets.

@bompus
Forked from joeyAghion/mongodb_collection_sizes.js
Last active August 29, 2015 14:27
Show Gist options
  • Save bompus/74c2fc1d1759064cb366 to your computer and use it in GitHub Desktop.
Save bompus/74c2fc1d1759064cb366 to your computer and use it in GitHub Desktop.
List mongodb collections in descending order of size. Helpful for finding largest collections. First number is "size," second is "storageSize."
var collectionNames = db.getCollectionNames(), stats = [];
collectionNames.forEach(function (n) { stats.push(db[n].stats()); });
(function(){ stats = stats.sort(function(a, b) { return b['size'] - a['size']; }); })();
for (var c in stats) { print(stats[c]['ns'] + ": " + stats[c]['size'] + " (" + stats[c]['storageSize'] + ")"); }
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment