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?.
DO
| id | tagname | count | excerptpostid | wikipostid |
|---|---|---|---|---|
| 1 | .net | 316293 | 3624959 | 3607476 |
| 2 | html | 1116853 | 3673183 | 3673182 |
| 3 | javascript | 2343663 | 3624960 | 3607052 |
SELECT 3