$count accumulator in MongoDB - Step-by-Step Execution

Concept Flow - $count accumulator

Start Aggregation Pipeline

↓

Process Each Document

↓

$count Accumulator Increments

↓

Output Total Count

↓

End

The $count accumulator counts each document passing through the pipeline and outputs the total count at the end.

Execution Sample

MongoDB

db.collection.aggregate([
  { $group: { _id: null, total: { $sum: 1 } } }
])

Counts all documents in the collection and outputs the total count as 'total'.

Execution Table

Step	Document Processed	$count Value	Action	Output
1	{_id: 1, name: 'Alice'}	1	Increment count by 1	No output yet
2	{_id: 2, name: 'Bob'}	2	Increment count by 1	No output yet
3	{_id: 3, name: 'Charlie'}	3	Increment count by 1	No output yet
4	No more documents	3	Output total count	{_id: null, total: 3}

💡 All documents processed, $count outputs the total count 3.

Variable Tracker

Variable	Start	After 1	After 2	After 3	Final
$count	0	1	2	3	3

Key Moments - 2 Insights

Why does $count output only once at the end instead of after each document?

$count accumulates the count internally as documents pass through. It outputs only once after processing all documents, as shown in execution_table row 4.

Can $count be used without $group stage?

$count is an accumulator and must be used inside a $group stage, as in the example code. It cannot be used alone.

Visual Quiz - 3 Questions

Look at the execution table, what is the $count value after processing the second document?

A 1

B 3

C 2

D 0

💡 Hint

Check the $count Value column at Step 2 in the execution_table.

At which step does the $count accumulator output the total count?

A Step 4

B Step 1

C Step 3

D Step 2

💡 Hint

Look for the step where 'Output total count' action happens in the execution_table.

If the collection had 5 documents instead of 3, what would be the final $count value?

A 4

B 5

C 3

D 6

💡 Hint

Refer to variable_tracker showing $count increments per document.

Concept Snapshot

$count accumulator counts documents in a $group stage.
Syntax: { $group: { _id: null, total: { $sum: 1 } } }
Counts each document passing through.
Outputs total count once after all documents.
Must be used inside $group stage.

Full Transcript

The $count accumulator in MongoDB aggregation counts how many documents pass through the pipeline. It is used inside a $group stage to accumulate a total count. As each document is processed, $count increments by one. It does not output intermediate counts but only outputs the final total count after all documents are processed. For example, if there are three documents, $count increments from 0 to 3, then outputs {total: 3}. This accumulator is useful to find the number of documents matching certain criteria in aggregation pipelines.