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?.
SELECT 1
jsonb_pretty |
---|
{ "parent": [ { "steps": [ { "name": "CONFIG1", "index": 1, "childStep": [ { "configuration": { } } ] }, { "name": "CONFIG2", "index": 2, "childStep": [ { "configuration": { "configInfo": { "info": "someinfo" } } } ] } ] } ] } |
SELECT 1
UPDATE 1
jsonb_pretty |
---|
{ "parent": [ { "steps": [ { "name": "CONFIG1", "index": 1, "childStep": [ { "configuration": { } } ] }, { "name": "CONFIG2", "index": 2, "configuration": { "configInfo": { "info": "someinfo" } } } ] } ] } |
SELECT 1