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?.
10 rows affected
| 供應商 | 月份 | 產品1 | 產品2 |
|---|---|---|---|
| 好吃雞腿 | 202108 | 炸雞腿 | 滷雞腿 |
| 好吃雞腿 | 202109 | 蜜汁雞腿 | 還是蜜汁雞腿 |
| 黯然排骨 | 202108 | 排骨酥 | 椒鹽排骨 |