Postgres Scan Types in EXPLAIN Plans

1 · Crunchy Data · Dec. 4, 2025, 5:35 p.m.
Production Postgres postgresql Database Management Scans indexing
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