Best way to sum array sizes fields in mongoDB

Question

I have documents with an array field and I need to sum the sizes of this array across all documents. I'm using python --> PyMongo.

In a nutshell, applying the aforementioned query to this set of documents should return 6:

{_id: a, array: [a,b]}
{_id: b, array: [c, d, e]}
{_id: c, array: [f]}

Searching around the Internet, I've come up with the following solution:

value = collection.aggregate([{"$unwind": "$array"}, {"$group": {"_id": "null", "total": {"$sum": 1}}}])

It works and I get the number I want in the following way:

count = value['result'][0]['total']

Is it the best query I can do? Is there a more efficient way?

I'm not particularly expert about mongo aggregation framework, so I thought it was better to ask.

Yes, This is the best way according to me. – Lalit Agarwal Dec 08 '14 at 19:58 — Lalit Agarwal, Dec 08 '14 at 19:58

score 2 · Accepted Answer · answered Dec 08 '14 at 20:36

2

No need to unwind the array just to get the size.

>>> collection.aggregate([{'$group': {'_id': None, 'total': {'$sum': {'$size': '$array'}}}}])
{u'ok': 1.0, u'result': [{u'total': 6, u'_id': None}]}

answered Dec 08 '14 at 20:36

A. Coady

It works! Is it also more efficient? I guess it is because it doesn't unwind. – Alberto Coletta Dec 09 '14 at 09:33

1 Answers1