countDocuments method in MongoDB - Step-by-Step Execution

Concept Flow - countDocuments method

Start countDocuments call

↓

Apply filter to collection

↓

Scan matching documents

↓

Count matched documents

↓

Return count result

↓

End

The countDocuments method starts by applying a filter to the collection, scans all matching documents, counts them, and returns the total count.

Execution Sample

MongoDB

db.users.countDocuments({ age: { $gte: 18 } })

Counts how many documents in the 'users' collection have an age of 18 or older.

Execution Table

Step	Action	Filter Applied	Documents Scanned	Count So Far	Result Returned
1	Start countDocuments	{ age: { $gte: 18 } }	0	0
2	Scan document 1	{ age: { $gte: 18 } }	1	1
3	Scan document 2	{ age: { $gte: 18 } }	2	2
4	Scan document 3	{ age: { $gte: 18 } }	3	2
5	Scan document 4	{ age: { $gte: 18 } }	4	3
6	All documents scanned	{ age: { $gte: 18 } }	4	3	3
7	Return count				3

💡 All documents scanned; count of matching documents (3) returned.

Variable Tracker

Variable	Start	After 1	After 2	After 3	After 4	Final
Documents Scanned	0	1	2	3	4	4
Count So Far	0	1	2	2	3	3

Key Moments - 2 Insights

Why does the count not increase when scanning document 3?

Because document 3 does not match the filter { age: { $gte: 18 } }, so the count remains the same as shown in execution_table row 4.

Does countDocuments return the actual documents?

No, countDocuments only returns the number of documents matching the filter, not the documents themselves, as seen in the final result in execution_table row 7.

Visual Quiz - 3 Questions

Look at the execution table, what is the count after scanning the second document?

A 1

B 0

C 2

D 3

💡 Hint

Check the 'Count So Far' column at Step 3 in the execution_table.

At which step does the countDocuments method return the final count?

A Step 5

B Step 7

C Step 6

D Step 4

💡 Hint

Look at the 'Result Returned' column in the execution_table to find when the count is returned.

If the filter was changed to { age: { $gte: 21 } }, how would the count after scanning document 4 change?

A It would be 2

B It would be 3

C It would be 4

D It would be 1

💡 Hint

Refer to variable_tracker and consider which documents meet the new filter condition.

Concept Snapshot

countDocuments(filter)
- Counts documents matching filter in a collection
- Returns number, not documents
- Efficient for counting large sets
- Filter is optional; counts all if omitted

Full Transcript

The countDocuments method in MongoDB counts how many documents in a collection match a given filter. It starts by applying the filter, scans each document, increments the count if the document matches, and finally returns the total count. For example, counting users aged 18 or older scans each user document, counts those with age >= 18, and returns that number. The method does not return the documents themselves, only the count. This process is efficient and useful for quickly knowing how many records meet certain criteria.

Practice

1.

What does the countDocuments method do in MongoDB?

easy

A. Counts how many documents match a given filter

B. Deletes documents matching a filter

C. Updates documents matching a filter

D. Returns all documents in a collection

Solution

1. Step 1: Understand the purpose of countDocuments

   The countDocuments method is used to count documents that match a filter in a collection.

2. Step 2: Compare with other operations

   Deleting, updating, or returning documents are different operations and not related to counting.

3. Final Answer:

   Counts how many documents match a given filter -> Option A

4. Quick Check:

   countDocuments = count matching documents [OK]

Hint: Remember: countDocuments counts, not modifies data [OK]

Common Mistakes:

• Confusing countDocuments with delete or update methods
• Thinking it returns the documents instead of a count
• Assuming it counts all documents without a filter

2.

Which of the following is the correct syntax to count documents with status equal to "active" in a collection named users?

?

easy

A. db.users.countDocuments({ status: "active" })

B. db.users.count({ status: active })

C. db.users.find({ status: "active" }).countDocuments({ status: "active" })

D. db.users.countDocuments("status = active")

Solution

1. Step 1: Identify correct method usage

   The countDocuments method is called on the collection with a filter object inside parentheses.

2. Step 2: Check filter format

   The filter must be an object like { status: "active" }, not a string or chained after find().

3. Final Answer:

   db.users.countDocuments({ status: "active" }) -> Option A

4. Quick Check:

   Correct syntax uses countDocuments(filter) [OK]

Hint: Use countDocuments with a filter object inside parentheses [OK]

Common Mistakes:

• Using deprecated count() method
• Passing filter as a string instead of object
• Calling countDocuments after find()

3.

Given the collection orders with documents:

[{ "status": "shipped" }, { "status": "pending" }, { "status": "shipped" }]

What will db.orders.countDocuments({ status: "shipped" }) return?

medium

A. 1

B. 0

C. 2

D. 3

Solution

1. Step 1: Identify documents matching the filter

   Documents with status: "shipped" are the first and third documents.

2. Step 2: Count matching documents

   There are 2 such documents in total.

3. Final Answer:

   2 -> Option C

4. Quick Check:

   Count of shipped orders = 2 [OK]

Hint: Count documents matching filter exactly [OK]

Common Mistakes:

• Counting all documents instead of filtered ones
• Misreading the status values
• Assuming countDocuments returns documents, not count

4.

What is wrong with this code snippet?

const count = db.products.countDocuments("category: 'books'");

It aims to count documents where category is "books".

medium

A. Missing await keyword for asynchronous call

B. The filter is passed as a string instead of an object

C. countDocuments cannot be used on the products collection

D. The method name should be count, not countDocuments

Solution

1. Step 1: Check filter argument type

   The filter must be an object like { category: 'books' }, not a string.

2. Step 2: Confirm method usage

   countDocuments is valid on collections and accepts an object filter.

3. Final Answer:

   The filter is passed as a string instead of an object -> Option B

4. Quick Check:

   Filter must be an object, not a string [OK]

Hint: Filters are objects, not strings in countDocuments [OK]

Common Mistakes:

• Passing filter as a string
• Confusing countDocuments with count
• Ignoring async/await in some environments (not always error)

5.

You want to count how many users have either age greater than 30 or status equal to "active". Which query correctly uses countDocuments to do this?

hard

A. db.users.countDocuments({ age > 30 || status == "active" })

B. db.users.countDocuments({ age: { $gt: 30 }, status: "active" })

C. db.users.countDocuments({ $and: [ { age: { $gt: 30 } }, { status: "active" } ] })

D. db.users.countDocuments({ $or: [ { age: { $gt: 30 } }, { status: "active" } ] })

Solution

1. Step 1: Understand the filter logic

   We want documents where age is greater than 30 OR status is "active".

2. Step 2: Use correct MongoDB query syntax

   The $or operator takes an array of conditions to match either one.

3. Step 3: Check each option

   The option using { $or: [ { age: { $gt: 30 } }, { status: "active" } ] } is correct. The option with comma-separated conditions uses implicit AND, the one with $and uses explicit AND, and the last uses invalid syntax.

4. Final Answer:

   db.users.countDocuments({ $or: [ { age: { $gt: 30 } }, { status: "active" } ] }) -> Option D

5. Quick Check:

   Use $or with array for OR conditions [OK]

Hint: Use $or with array for OR conditions in filters [OK]

Common Mistakes:

• Using implicit AND instead of OR
• Writing invalid filter syntax
• Confusing $and and $or operators