mongodbwiredtiger

What are the sizes returned by `show collections`?


Edit: This question is not about vanilla MongoDB's show collections but about mongo-hacker. See accepted answer and comments.


Using Mongo DB 3.2 + WiredTiger, show collections displays two sizes: s1 / s2.

show collections
coll_1               → 10.361MB / 1.289MB
coll_2               →  0.000MB / 0.004MB
coll_3               →  0.000MB / 0.016MB
coll_4               →  0.001MB / 0.031MB

My guess is these are:

Is this correct? I couldn't find any reference in the docs.


Solution

  • Are you using mongo-hacker? By default in MongoDB 3.2.11, show collections doesn't show any size information at all.

    The size information provided by mongo-hacker is obtained from the output of db.collection.stats().size which shows you the total uncompressed size of the collection (without indexes), and db.collection.stats().storageSize which shows you the physical storage size. If you enable compression in WiredTiger, the storageSize will typically be smaller than size.

    You can find the relevant source code in here: https://github.com/TylerBrock/mongo-hacker/blob/0.0.13/hacks/show.js#L57-L72