Sequential scan
A sequential scan examines items in an ordered sequence one at a time, for example to evaluate a condition or accumulate a result.
Just Use Postgres!
A sequential scan, or full table scan, examines every row of a table to find rows matching a query rather than locating them through an index.
- How it is used
- Uses full-row inspection to answer queries when no suitable index exists or scanning is judged efficient.
- How deep it goes
- Explains linear behavior, filtering, row counts, parallel execution, and planner tradeoffs without detailing scan implementation internals.
- Examples
- Demonstrates scans on player wins, score ranges, champion titles, JSON fields, time-series measurements, and message queues.
- What you can do after
- Diagnose/debug with EXPLAIN by identifying Seq Scan nodes, filters, rejected rows, timing, and possible indexing opportunities.
PostgreSQL Mistakes and How to Avoid Them
A full table scan is a query execution method that examines rows throughout a table rather than locating them through a selective index lookup.
- How it is used
- Diagnoses slow PostgreSQL queries whose plans scan entire tables instead of using selective indexes.
- How deep it goes
- Explains plan inspection, predicate matching, partial indexes, foreign-key indexing, and expression-predicate workarounds without exhaustive index-type detail.
- Examples
- Uses open-ticket counts, timestamped payments, and invoice lookups by customer to compare scan and index-backed plans.
- What you can do after
- Diagnose/debug with it by reading PostgreSQL plans and selecting predicate-aligned indexing or query rewrites.
Read how PostgreSQL Mistakes and How to Avoid Them explains sequential scan →
MongoDB 8.0 in Action, Third Edition
A collection scan is query execution that examines documents throughout a collection to find matches without relying on an applicable index.
- How it is used
- Explains how MongoDB retrieves matches when no applicable index supports a query.
- How deep it goes
- Explains scan behavior, index trade-offs, $or requirements, and selectivity, but does not detail scan internals.
- Examples
- Uses server-log queries and an unindexed movie-rating $or clause to demonstrate collection-scan behavior.
- What you can do after
- Diagnose collection scans with explain and improve eligible $or queries by adding supporting indexes.
Read how MongoDB 8.0 in Action, Third Edition explains sequential scan →
Also covered in
What to know first
- execution planAn execution plan is a structured representation of intended operations or tasks and their organization for carrying out a query or other task.
- listA list is an ordered collection of elements arranged in a sequence.
Related concepts
- index scancontrasts with · An index scan is a database query operation that traverses an index to locate or retrieve records matching query conditions.
- indexingcontrasts with · Indexing is the process of assigning or using positions, keys, or lookup structures to identify and access elements or records.
- membership operatorused by · A membership operator is a language construct that tests whether a specified value or property is present in a supported collection, range, or object.
- composite indexcontrasts with · A composite index is a database index whose key contains multiple fields or columns, ordered according to the index definition.
- parallel sequential scanincludes · A parallel sequential scan divides a table scan among multiple database execution processes or workers.
Questions about sequential scan
What is sequential scan?
A sequential scan examines items in an ordered sequence one at a time, for example to evaluate a condition or accumulate a result.
Which Manning books explain sequential scan?
Just Use Postgres!, PostgreSQL Mistakes and How to Avoid Them and MongoDB 8.0 in Action, Third Edition.
What should I know before learning sequential scan?
Manning books that teach sequential scan usually introduce execution plan and list first.
What is the difference between sequential scan and index scan?
A sequential scan examines items in an ordered sequence one at a time, for example to evaluate a condition or accumulate a result. An index scan is a database query operation that traverses an index to locate or retrieve records matching query conditions.
What kinds of sequential scan are there?
Kinds of sequential scan include parallel sequential scan.
What is sequential scan also called?
Sequential scan is also called full table scan or Seq Scan.
These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.


