By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
CREATE TYPE
| recipient | all_null | all_notnull | some_notnull | some_null |
|---|---|---|---|---|
| (foo,1) | f | t | t | f |
| (,2) | f | f | t | t |
| (,) | t | f | f | t |
| null | t | f | f | t |
SELECT 4