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 |