Query operators
PostgreSQL currently has 19 query operators.
Seq Scan
The Seq Scan
operator is the most basic query operator. Any single-table query can be carried out using the Seq Scan
operator.
Index Scan
An Index Scan
operator works by traversing an index structure. If you specify a starting value for an indexed column (WHERE record_id >= 1000
, for example), the Index Scan
will begin at the appropriate value. If you specify an ending value (such as WHERE record_id < 2000
), the Index Scan
will complete as soon as it finds an index entry greater than the ending value.
Sort
The Sort
operator imposes an ordering on the result set. PostgreSQL uses two different sort strategies: an in-memory sort and an on-disk sort. You can tune a PostgreSQL instance ...
Get PostgreSQL Development Essentials now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.