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
INSERT 0 5
p_id | data | c_id | data |
---|---|---|---|
1 | {"parent":null,"children":[2,3]} | 2 | {"parent":1,"children":[4,5]} |
1 | {"parent":null,"children":[2,3]} | 3 | {"parent":1,"children":[]} |
2 | {"parent":1,"children":[4,5]} | 4 | {"parent":2,"children":[]} |
2 | {"parent":1,"children":[4,5]} | 5 | {"parent":2,"children":[]} |
3 | {"parent":1,"children":[]} | null | null |
4 | {"parent":2,"children":[]} | null | null |
5 | {"parent":2,"children":[]} | null | null |
SELECT 7
p_id | p_data | c_id | c_data |
---|---|---|---|
1 | {"parent":null,"children":[2,3]} | 2 | {"parent":1,"children":[4,5]} |
1 | {"parent":null,"children":[2,3]} | 3 | {"parent":1,"children":[]} |
2 | {"parent":1,"children":[4,5]} | 4 | {"parent":2,"children":[]} |
2 | {"parent":1,"children":[4,5]} | 5 | {"parent":2,"children":[]} |
SELECT 4