Skip to content

Instantly share code, notes, and snippets.

@namcxn

namcxn/mongodb_collection_sizes.js

Forked from joeyAghion/mongodb_collection_sizes.js
Created May 7, 2021 07:56
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save namcxn/7e9476c753d2bfa4ea834bdfb1e5b243 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save namcxn/7e9476c753d2bfa4ea834bdfb1e5b243 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