Postgres 11

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?.

CREATE TABLE fb_designs(id, items) AS
(VALUES('abc','{"listings":[{"id":"aaa","active":true}]}'::jsonb));

SELECT * FROM fb_designs

SELECT 1

id
items

abc
{"listings": [{"id": "aaa", "active": true}]}

SELECT 1

UPDATE fb_designs 
SET items = jsonb_set(items, '{listings, 0}', $${"id": "pYIO23Bgh", "active": true, "meta": {"title": "This is what we've been doing", "description": "They're great"}}$$)
WHERE id = 'abc'

UPDATE 1

SELECT * FROM fb_designs

id
items

abc
{"listings": [{"id": "pYIO23Bgh", "meta": {"title": "This is what we've been doing", "description": "They're great"}, "active": true}]}

SELECT 1