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
| t1 | j1 | r2 | j2 | r3 | j3 | r4 | j4 |
|---|---|---|---|---|---|---|---|
| (1,x,42.1) | {"?column?":1,"?column?":"x","numeric":42.1} | (1,x,42.1) | {"f1":1,"f2":"x","f3":42.1} | (1,x,42.1) | {"f1":1,"f2":"x","f3":42.1} | (1,x,42.1) | {"xx1":1,"xx2":"x","xx3":42.1} |
SELECT 1