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?.
5 rows affected
id | name | path | parent_id | depth | slug |
---|---|---|---|---|---|
1 | name1 | {1} | null | 0 | slug1 |
2 | name2 | {1,2} | 1 | 1 | slug2 |
3 | name3 | {1,2,3} | 2 | 2 | slug3 |
5 | name5 | {5} | null | 0 | slug5 |
9 | name9 | {5,9} | 5 | 1 | slug9 |
1 rows affected
id | name |
---|---|
1 | nameitems1 |
2 rows affected
id | json_agg |
---|---|
3 | [{"name" : "name1", "slug" : "slug1"}, {"name" : "name2", "slug" : "slug2"}, {"name" : "name3", "slug" : "slug3"}] |
9 | [{"name" : "name5", "slug" : "slug5"}, {"name" : "name9", "slug" : "slug9"}] |