[nattaylor]

It does have to read it because NULLs aren't counted

[teddyh]

If the column is NOT NULL, does it still read it?

[avianlyric]

Shouldn’t do. Postgres is usually pretty good at making these types of optimisations.