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 | temperature | t1 | t2 |
|---|---|---|---|
| 1 | ABC 2 Core 0sdg q346 | 20 | 20 |
| 2 | 0 Core 0 | 0 | 0 |
| 3 | Core 0 | 0 | 0 |
| 4 | 0 Core | 0 | 0 |
| 5 | 01 Core 01 | 1 | 1 |
| 6 | Core 01 | 1 | 1 |
| 7 | 01 Core | 1 | 1 |
| 8 | 123 Core 321 | 12 | 12 |
| 9 | Core 123 | 12 | 12 |
| 10 | 123 Core | 12 | 12 |
| 11 | asr1a 6aertga0gads f ga 1 era2e har tj 0j5rjk6jk98 | 16 | 16 |
| 12 | 0 | 0 | 0 |
| 13 | A | null | null |
| 14 | null | null | |
| 15 | null | null | null |