Postgres Scan Types in EXPLAIN Plans

· Crunchy Data · Dec. 4, 2025, 5:35 p.m.
Production Postgres postgresql indexing Performance Tuning Database Management
Summary
This blog post explains the different types of scans in PostgreSQL, including sequential scans, index scans, parallel scans, and bitmap heap scans, with diagrams for better understanding.
Read full post on www.crunchydata.com →
AUTHOR