Subset pattern for large documents in MongoDB - Step-by-Step Execution

Concept Flow - Subset pattern for large documents

Start with large document

↓

Identify needed fields

↓

Create projection with those fields

↓

Run query with projection

↓

Return only subset of fields

↓

End

This flow shows how to get only needed parts of large documents by selecting specific fields using projection.

Execution Sample

MongoDB

db.collection.find({}, {name:1, age:1, _id:0})

This query returns only the 'name' and 'age' fields from documents, excluding the '_id' field.

Execution Table

Step	Action	Query Part	Resulting Document Fields
1	Start query	find({}, {name:1, age:1, _id:0})	Full document with all fields
2	Apply filter	{}	All documents selected (no filter)
3	Apply projection	{name:1, age:1, _id:0}	Only 'name' and 'age' fields included, '_id' excluded
4	Return result	Projected fields	{name: 'Alice', age: 30}
5	Return result	Projected fields	{name: 'Bob', age: 25}
6	Return result	Projected fields	{name: 'Carol', age: 40}
7	End query	All documents processed	Query complete with subset fields

💡 All documents returned with only the specified subset of fields.

Variable Tracker

Variable	Start	After Step 3	Final
Document Fields	All fields	Only 'name' and 'age' fields	Only 'name' and 'age' fields

Key Moments - 3 Insights

Why do we set _id:0 in the projection?

By default, MongoDB includes the _id field. Setting _id:0 excludes it so only the specified fields appear, as shown in step 3 of the execution table.

What happens if we don't specify any projection?

Without projection, the entire document is returned with all fields, as shown in step 1 where the full document is available.

Can we include some fields and exclude others at the same time?

No, except for _id, you either include fields (set to 1) or exclude fields (set to 0). Mixing inclusion and exclusion causes an error, except for _id which can be excluded.

Visual Quiz - 3 Questions

Look at the execution table, what fields are returned after step 3?

A All fields including _id

B Only 'name' and 'age' fields, excluding _id

C Only _id field

D No fields returned

💡 Hint

Check the 'Resulting Document Fields' column at step 3 in the execution table.

At which step does the query exclude the _id field?

A Step 1

B Step 2

C Step 3

D Step 4

💡 Hint

Look for when the projection is applied in the execution table.

If we remove _id:0 from the projection, what changes in the output?

A The _id field will be included in the results

B The query will return no documents

C Only the _id field will be returned

D The query will fail with an error

💡 Hint

Refer to the key moment about _id field default behavior.

Concept Snapshot

Subset pattern in MongoDB:
Use projection in find() to select only needed fields.
Syntax: find(filter, {field1:1, field2:1, _id:0})
By default, _id is included; set _id:0 to exclude.
This reduces data size and improves performance.

Full Transcript

This visual execution shows how to use the subset pattern in MongoDB to retrieve only specific fields from large documents. The process starts with a full document, then a projection is applied to include only the 'name' and 'age' fields while excluding the '_id' field. The execution table traces each step, showing how the query filters and projects fields, returning smaller documents. Key moments clarify why _id is excluded explicitly and the rules about mixing inclusion and exclusion in projections. The quiz tests understanding of when fields are included or excluded and the effect of removing _id:0. The snapshot summarizes the syntax and behavior for quick reference.