$push (Array Gather Accumulator)

Last updated: 2026-10-09

$push (Array Gather Accumulator)

$push is an accumulator appending each document's expression result to an array during $group, in input order (usually not guaranteed stable). It gathers group details into a single document. $sort first when you need a stable order.

CategoryAccumulators
MongoDB Version1.0+
Example Languagemongosh (Shell)

📝 Syntax

{ $group: { _id: <key>, items: { $push: "$field" } } }

Returns:Array of every expression result in the group

▶ Example

Run the commands below in your local mongosh (requires a running mongod):

// $push: gather items per customer
db.orders.aggregate([
  { $group: { _id: '$cust_id', items: { $push: '$item' } } }
])

Output:

{ "_id": "A123", "items": ["Pen", "Book"] }

📌 Notes

📚 Related Tutorials

❓ FAQ

QIs $push output order stable?
ANot strictly; $sort earlier in the pipeline when order matters.
QWhat is the difference between $push and $addToSet?
A$push keeps duplicates; $addToSet deduplicates.
QHow do I collect only the first few elements?
AFollow $push with $slice, or $sort plus $limit before $group.
Web-Tutorial.com

Web-Tutorial Tech Team

A team of developers maintaining programming tutorials. Each tutorial is written and reviewed by developers with expertise in that field. We work to keep our content accurate and reliable — if you spot an issue, please let us know.

100%

🙏 帮我们做得更好

我们是刚上线的编程教程站,几个人的小团队,精力有限。页面虽经检查,难免还有疏漏——链接失效、排版错乱、内容有误、语言生硬……

如果您发现了,麻烦告诉我们,我们会在收到反馈后第一时间进行修复,再次感谢您的光临 🙏