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?.
3 rows affected
1 rows affected
| lvl | _item | _coll |
|---|---|---|
| 0 | (1,2,c) | null |
| 1 | null | (2,3) |
| 2 | (3,4,i) | null |
| 3 | (4,,i) | null |