JIYIK CN >

When working in MongoDB, do you know the size of your database? Today, we will learn how to get the size of a database in MongoDB using show dbsthe command and the method.db.stats()

Get the size of the database in MongoDB

We can show dbs;get the storage size of all databases in MongoDB using the command on the mongo shell as shown below.

Sample code:

> show dbs;

Output:

admin   0.000GB
config  0.000GB
local   0.000GB
test    0.001GB

The above output shows the database name and its size in GB. We use db.stats()the method to get detailed statistics about the database.

It has various fields that we need to understand first. Below is a brief description of each field, but you can find more detailed information about each field here .

Remember that we must db.stats()select a database before using the function.

Sample code:

> use test
> db.stats()

Output:

{
        "db" : "test",
        "collections" : 5,
        "views" : 0,
        "objects" : 15,
        "avgObjSize" : 99,
        "dataSize" : 1485,
        "storageSize" : 135168,
        "indexes" : 5,
        "indexSize" : 102400,
        "totalSize" : 237568,
        "scaleFactor" : 1,
        "fsUsedSize" : 176960913408,
        "fsTotalSize" : 208499617792,
        "ok" : 1
}

We can also pass the scale factor as per the project requirement.

See the following example as a demonstration.

Get statistics in bytes:

>db.stats()

Output:

{
        "db" : "test",
        "collections" : 5,
        "views" : 0,
        "objects" : 15,
        "avgObjSize" : 99,
        "dataSize" : 1485,
        "storageSize" : 135168,
        "indexes" : 5,
        "indexSize" : 102400,
        "totalSize" : 237568,
        "scaleFactor" : 1,
        "fsUsedSize" : 176986320896,
        "fsTotalSize" : 208499617792,
        "ok" : 1
}

Considering the above given storageSize, the database filesystemoccupies over 0.1352 MB. Similarly, we can get the size of the database in the following example.

Get statistics in KB:

> db.stats(1024)

Output:

{
        "db" : "test",
        "collections" : 5,
        "views" : 0,
        "objects" : 15,
        "avgObjSize" : 99,
        "dataSize" : 1.4501953125,
        "storageSize" : 132,
        "indexes" : 5,
        "indexSize" : 100,
        "totalSize" : 232,
        "scaleFactor" : 1024,
        "fsUsedSize" : 172839080,
        "fsTotalSize" : 203612908,
        "ok" : 1
}

Get statistics in MB:

> db.stats(1024*1024)

Output:

{
        "db" : "test",
        "collections" : 5,
        "views" : 0,
        "objects" : 15,
        "avgObjSize" : 99,
        "dataSize" : 0.0014162063598632812,
        "storageSize" : 0.12890625,
        "indexes" : 5,
        "indexSize" : 0.09765625,
        "totalSize" : 0.2265625,
        "scaleFactor" : 1048576,
        "fsUsedSize" : 168788.66796875,
        "fsTotalSize" : 198840.73046875,
        "ok" : 1
}

Get statistics in GB:

> db.stats(1024*1024*1024)

Output:

{
        "db" : "test",
        "collections" : 5,
        "views" : 0,
        "objects" : 15,
        "avgObjSize" : 99,
        "dataSize" : 0.0000013830140233039856,
        "storageSize" : 0.000125885009765625,
        "indexes" : 5,
        "indexSize" : 0.000095367431640625,
        "totalSize" : 0.00022125244140625,
        "scaleFactor" : 1073741824,
        "fsUsedSize" : 164.83288955688477,
        "fsTotalSize" : 194.18040084838867,
        "ok" : 1
}