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?.
7 rows affected
| id | cnt | rel_id |
|---|---|---|
| PS291 | 6.606 | PS479 |
| PS377 | 1.335 | PS479 |
| PS386 | 0.867 | PS377 |
| PS479 | 14.756 | PS606 |
| PS650 | 0.297 | PS667 |
| PS667 | 3.409 | PS479 |
| PS779 | 0.224 | PS479 |
| root_id | sum |
|---|---|
| PS291 | 6.606 |
| PS377 | 2.202 |
| PS386 | 0.867 |
| PS479 | 27.494 |
| PS650 | 0.297 |
| PS667 | 3.706 |
| PS779 | 0.224 |