Postgres not using index when index scan is much better option
Index (Only) Scan –> Bitmap Index Scan –> Sequential Scan For few rows it pays to run an index scan. If enough data pages are visible to all (= vacuumed enough, and not too much concurrent write load) and the index can provide all column values needed, then a faster index only scan is used. …