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
3 rows affected
jsonb_pretty |
---|
[ { "id": 1, "name": "Alice", "status": "a", "accounts": [ { "type": "CHK", "balance": 100.00, "account_number": "300-1" } ], "registered_on": "2020-03-04" }, { "id": 2, "name": "Vincent", "status": "p", "accounts": [ { "type": "SAV", "balance": 24.00, "account_number": "307-5" }, { "type": "CHK", "balance": 350.00, "account_number": "307-6" } ], "registered_on": "2020-03-05" }, { "id": 3, "name": "Anne", "status": "a", "accounts": [ ], "registered_on": "2020-03-06" } ] |