get total index size for all databases

1,251 views
Skip to first unread message

kost BebiX

unread,
Jun 2, 2011, 10:49:59 AM6/2/11
to mongod...@googlegroups.com
Hi!

Is there a simple way to get sum of all indexes of all databases in mongo?

Thank you.

Andreas Jung

unread,
Jun 2, 2011, 10:57:45 AM6/2/11
to mongod...@googlegroups.com
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

kost BebiX wrote:
> Hi!
>
> Is there a simple way to get sum of all indexes of all databases in mongo?
>

Write a script iterating over all database and sum up
db.stats()['indexSize'].

- -aj
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQGUBAEBAgAGBQJN56ToAAoJEADcfz7u4AZjU9ILwMaOOWZdISHkN+lAxLDkIkvO
3DM/l9/uTzW+jH32zezRVrQ86qPNLNuV4WoSbtZreaH0Gmt/8/W2P0naHtbgss5R
S9J80Vv/i0go5+SlbMFHc1mKVacTvA9r58IDo0jHLDeOhzJts/Ng+wMUv7LXX4iX
sA7Yq+f7KAfV/UwaBVF6Tz5TiwwWNc9MCyZ+xUmHZ6LUDaAGFkk5W7N94gcuTeoz
x+EmpkWiqtcmGP34dug9xxkTmXBMyM/hOHxQq5gKRZ84vY3mY98ioarxNi5DCmLg
KO5rfpqB16DuW07jW5QNOC8TPGDYqlb9m64UxauN2qER4G1SAKLIKXaRwL6g2nrT
hSoGIPE4MZeiH35avAe6CMgqqPNjkE8qOVuA3sTfNN/dQ8xX7mnbIXeIOVzLX3Gq
aRHDnl/+2yyipLiQ0Qgz6qPJw8IUbnIUgQh9q8nX2XhUjiQ5pTjKeAbUAmNXqqVG
CYZtjv2YcygjbIuTKe6CnRJfQy/LwSE=
=0NzD
-----END PGP SIGNATURE-----

lists.vcf

Nat

unread,
Jun 2, 2011, 11:08:36 AM6/2/11
to mongod...@googlegroups.com
not so simple :)

var sum = 0; db.getMongo().getDBs()["databases"].forEach(function(x) { sum += db.getMongo().getDB(x.name).stats().indexSize }); print(sum)

kost BebiX

unread,
Jun 13, 2011, 8:49:49 AM6/13/11
to mongod...@googlegroups.com
Yeah, that's what I did) Thanks anyway)
Reply all
Reply to author
Forward
0 new messages