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?.
8 rows affected
3 rows affected
id | name | path |
---|---|---|
1 | A1 | /A1 |
7 | C2 | /A1/B1/C2 |
4 | B2 | /A1/B2 |
8 | C3 | /A1/B2/C3 |