mongo db query binary data sorted by size

Question

I have some binary data inside a mongodb collection. I would like to clear a little bit the too heavy data. How can I sort the top 10 binary data (biggest size on disk)? Thanks

Wernfried Domscheit · Accepted Answer · 2023-01-08 11:05:39Z

1

Use this:

db.collection.aggregate([
  { $set: { binSize: { $bsonSize: "$binary_data" } } },
  { $sort: { binSize: -1 } },
  { $limit: 10 }
])

answered Jan 8, 2023 at 11:05

Wernfried Domscheit

60.4k10 gold badges93 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mongo db query binary data sorted by size

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related