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?.
version |
---|
PostgreSQL 13.13 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-20), 64-bit |
SELECT 1
CREATE TABLE
INSERT 0 9
id | name | parent_id |
---|---|---|
1 | home | null |
2 | root | null |
3 | user | 1 |
4 | documents | 3 |
5 | pictures | 3 |
6 | downloads | 3 |
7 | vacations | 5 |
8 | baltic sea | 7 |
9 | tatra mountains | 7 |
SELECT 9
id | name | parent |
---|---|---|
1 | home | null |
2 | root | null |
3 | user | home |
4 | documents | user |
5 | pictures | user |
6 | downloads | user |
7 | vacations | pictures |
8 | baltic sea | vacations |
9 | tatra mountains | vacations |
SELECT 9
id | name |
---|---|
8 | baltic sea |
7 | vacations |
5 | pictures |
3 | user |
1 | home |
SELECT 5