Skip to content

Instantly share code, notes, and snippets.

@flabodotes

flabodotes/mongodb_collection_sizes.js

Forked from joeyAghion/mongodb_collection_sizes.js
Created September 30, 2019 10:26
Show Gist options
  • Save flabodotes/7a783d5d3a5266423f69af4780053ade to your computer and use it in GitHub Desktop.
Save flabodotes/7a783d5d3a5266423f69af4780053ade to your computer and use it in GitHub Desktop.
Download ZIP
List mongodb collections in descending order of size. Helpful for finding largest collections. First number is "size," second is "storageSize."
Raw
mongodb_collection_sizes.js
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']; });
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