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?.
| id | timestep1 | timestep2 | timestep3 | timestep4 |
|---|---|---|---|---|
| a | foo1 | null | null | null |
| a | foo1 | bar1 | null | null |
| a | foo1 | bar1 | baz1 | null |
| a | foo1 | bar1 | baz1 | qux1 |
| b | foo2 | null | null | null |
| b | foo2 | bar2 | null | null |
| b | foo2 | bar2 | baz2 | null |
| id | timestep1 | timestep2 | timestep3 | timestep4 |
|---|---|---|---|---|
| a | foo1 | null | null | null |
| a | foo1 | bar1 | null | null |
| a | foo1 | bar1 | baz1 | null |
| a | foo1 | bar1 | baz1 | qux1 |
| b | foo2 | null | null | null |
| b | foo2 | bar2 | null | null |
| b | foo2 | bar2 | baz2 | null |