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?.
4 rows affected
| response | document | label | bill | product | answer |
|---|---|---|---|---|---|
| 71788176 | 79907201 | bill | 26899 | null | null |
| 71788176 | 79907201 | amount | null | null | 1 |
| 71788176 | 79907201 | product | null | shoes | null |
| 71788176 | 79907201 | price | null | null | 25.99 |
| response | document | bill | amount | product | price |
|---|---|---|---|---|---|
| 71788176 | 79907201 | 26899 | 1 | shoes | 25.99 |