Postgres Scan Types in EXPLAIN Plans

· 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
Sponsored
Zulip logo Zulip
Organized team chat for people who take work seriously. Topic-based threading keeps conversations focused.
Try Zulip
Become a sponsor →