Yeah and sadly using the index in those scenarios could be even more worth it due to the high selectivity it has. Is PG smart enough to avoid that if the query

Yeah and sadly using the index in those scenarios could be even more worth it due to the high selectivity it has. Is PG smart enough to avoid that if the query patterns are frequently or exclusively covered by the index?