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?.
| a | ?column? |
|---|---|
| 庭 | 1 |
| 院 | 1 |
| 深 | 3 |
| 幾 | 1 |
| 許 | 1 |
| 繼 | 1 |
| 光 | 1 |
| 香 | 3 |
| 雞 | 1 |
| 酒 | 1 |
| 香 | 1 |
| 不 | 1 |
| 怕 | 1 |
| 巷 | 1 |
| 子 | 1 |
| 深 | 1 |
| 香 | 2 |
| 深 | 2 |
| 有 | 1 |
| 幾 | 1 |
| 何 | 1 |
SELECT 21