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 8
| prequelid | resid | path | lev |
|---|---|---|---|
| B1002 | B1004 | B1002->B1003->B1004 | 2 |
| B5001 | B5006 | B5001->B5002->B5003->B5004->B5005->B5006 | 5 |
SELECT 2