Postgres 13

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 t (item json)

CREATE TABLE


insert into t values
('{
    "item": {
        "base_id": 18,
        "id": "27e46ec1-3d9a-412d-9807-8e08e515988d",
        "json": {
            "id": "27e46ec1-3d9a-412d-9807-8e08e515988d",
            "title": "",
            "type": "state_value",
            "attribute_wcomponent_id": "310edbfb-0af1-411b-9275-3fc87948c3a5"
        },
        "modified_at": "2022-04-23T22:11:13.533Z"
    }
}
')

INSERT 0 1


select (item->'item'->'json'->>'attribute_wcomponent_id')::uuid AS wid
from t


wid


310edbfb-0af1-411b-9275-3fc87948c3a5



SELECT 1