javascriptmongodbdocumentobjectidobjectsize

How to get the size of single document in Mongodb?


I encountered a strange behavior of mongo and I would like to clarify it a bit...
My request is simple as that: I would like to get a size of single document in collection. I found two possible solutions:

Here, I provide some code I perform testing on:

  1. I created new database 'test' and input simple document with only one attribute: type:"auto"

    db.test.insert({type:"auto"})
    
  2. output from stats() function call: db.test.stats():

    { 
      "ns" : "test.test",
      "count" : 1,
      "size" : 40,
      "avgObjSize" : 40,
      "storageSize" : 4096,
      "numExtents" : 1,
      "nindexes" : 1,
      "lastExtentSize" : 4096,
      "paddingFactor" : 1,
      "systemFlags" : 1,
      "userFlags" : 0,
      "totalIndexSize" : 8176,
      "indexSizes" : {
            "_id_" : 8176
    },
    "ok" : 1
    

    }

  3. output from bsonsize function call: Object.bsonsize(db.test.find({test:"auto"}))

    481
    

Solution

  • In the previous call of Object.bsonsize(), Mongodb returned the size of the cursor, rather than the document.

    Correct way is to use this command:

    Object.bsonsize(db.test.findOne())
    

    With findOne(), you can define your query for a specific document:

    Object.bsonsize(db.test.findOne({type:"auto"}))
    

    This will return the correct size (in bytes) of the particular document.