-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathGetStats.js
More file actions
51 lines (45 loc) · 1.96 KB
/
GetStats.js
File metadata and controls
51 lines (45 loc) · 1.96 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
// Aggregate db.stats for every DB in a MongoDB deployment
var totalIndexSize = 0;
var totalDataSize = 0;
var totalStorageSize = 0;
var totalDocuments = 0;
var reservedDBs = ["admin","config","local"];
// Switch to admin database and get list of databases.
db = db.getSiblingDB("admin");
dbs = db.runCommand({ "listDatabases": 1 }).databases;
// Iterate through each database and get its stats.
dbs.forEach(function(database) {
if (reservedDBs.includes(database.name))
return;
db = db.getSiblingDB(database.name);
var stats = db.stats(1024*1024*1024);
totalIndexSize += stats.indexSize;
totalDataSize += stats.dataSize;
totalStorageSize += stats.storageSize;
totalDocuments += stats.objects;
print ("============================================");
print("["+database.name+"] DB");
print ("============================================");
print ("data size in GB: " + stats.dataSize.toFixed(2));
print ("index size in GB: " + stats.indexSize.toFixed(2));
print ("storage size in GB: " + stats.storageSize.toFixed(2));
print ("documents: " + stats.objects.toFixed(0));
db.getCollectionNames().forEach(function(collname) {
var coll= db.getCollection(collname);
var stats = coll.stats(1024*1024);
print ();
print("["+stats.ns+"] Coll");
print ("---------------------------------------");
print ("data size in MB: " + stats.size.toFixed(2));
print ("index size in MB: " + stats.totalIndexSize.toFixed(2));
print ("storage size in MB: " + stats.storageSize.toFixed(2));
print ("documents: " + stats.count.toFixed(0));
print ();
});
});
print ();
print ("============================================");
print ("Total data size in GB: " + totalDataSize.toFixed(2));
print ("Total index size in GB: " + totalIndexSize.toFixed(2));
print ("Total storage size in GB: " + totalStorageSize.toFixed(2));
print ("Total documents: " + totalDocuments.toFixed(0));