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?.
8 rows affected
| time | temp |
|---|---|
| 1606163169 | 10 |
| 1606163165 | 0 |
| 1606163163 | 5 |
| 1606162384 | 0 |
| 1606161384 | 0 |
| 1606160384 | 0 |
| 1606160380 | 24 |
| 1606160360 | 10 |
| time | temp | event |
|---|---|---|
| 1606160360 | 10 | 1 |
| 1606160380 | 24 | 1 |
| 1606160384 | 0 | 2 |
| 1606161384 | 0 | 2 |
| 1606162384 | 0 | 2 |
| 1606163163 | 5 | 3 |
| 1606163165 | 0 | 3 |
| 1606163169 | 10 | 3 |