Why PostgreSQL Ignores Your Index

EXPLAIN costs demystified, bitmap scans, data correlation, covering indexes, GiST, GIN — all on 4 million rows with live SQL.