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?.
9 rows affected
| personid | status | unixtime | partition_start | partition_end |
|---|---|---|---|---|
| 1 | 2 | 213214 | t | f |
| 1 | 2 | 213328 | f | t |
| 1 | 3 | 214330 | t | f |
| 1 | 3 | 214332 | f | t |
| 1 | 2 | 324543 | t | t |