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?.
5 rows affected
| location | array_agg | string_agg |
|---|---|---|
| L4 | {user5} | user5 |
| L2 | {user2,user3} | user2,user3 |
| L1 | {user1} | user1 |
| L3 | {user4} | user4 |