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?.
| session_id | name | actions |
|---|---|---|
| 1 | running | ["{"name":"inquired","check":false}", "{"name":"sent online guide","check":false}", "{"name":"booked!","check":false}"] |
| 2 | snowboarding | ["{"name":"rental","check":false}", "{"name":"booked ski passes","check":false}", "{"name":"survey","check":false}"] |
SELECT 2
| jsonb_agg |
|---|
| ["{"name":"inquired","check":false}", "{"name":"sent online guide","check":false}", "{"name":"booked!","check":false}", "{"name":"rental","check":false}", "{"name":"booked ski passes","check":false}", "{"name":"survey","check":false}"] |
SELECT 1