Skip to content

Instantly share code, notes, and snippets.

@mManishTrivedi

mManishTrivedi/mongodb_collection_sizes.js

Forked from joeyAghion/mongodb_collection_sizes.js
Created February 26, 2018 14:32
Show Gist options
  • Save mManishTrivedi/56c7dfa094d4a460ed958cafe41be81b to your computer and use it in GitHub Desktop.
Save mManishTrivedi/56c7dfa094d4a460ed958cafe41be81b 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