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?.
SELECT 5
SELECT 5
| gp_n | gp_conc | n | x |
|---|---|---|---|
| 1 | 0 | null | n1x5 |
| 1 | 0 | null | n2x4 |
| 1 | 0 | null | n3x3 |
| 1 | 0 | null | n4x2 |
| 1 | 0 | null | n5x1 |
| 0 | 1 | n1 | null |
| 0 | 1 | n2 | null |
| 0 | 1 | n3 | null |
| 0 | 1 | n4 | null |
| 0 | 1 | n5 | null |
SELECT 10