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?.
7 rows affected
| id | ids | names |
|---|---|---|
| 1 | {1,2,3} | {x_0,x_1,x_2} |
| 4 | {4,5,6,7} | {y_0,y_1,y_2,y_3} |