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
Advertise
Sponsor diff.blog
Put your product in front of developers who read and write about their craft. One exclusive sponsor at a time.
Become a sponsor →