PostgreSQL execution plan operations

Index and Table AccessSeq ScanThe Seq Scan operation scans the entire relation (table) as stored on disk (like TABLE ACCESS FULL). Index ScanThe Index Scan performs a B-tree traversal, walks through the leaf nodes to find all matching entries, and fetches the corresponding table data. It is like an INDEX RANGE SCAN followed by a TABLE ACCESS BY INDEX ROWID operation. See also Chapter 1, “Anatomy o