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?.
| question | verygood | good | bad | verybad | verygoodper | goodper | badper | verybadper |
|---|---|---|---|---|---|---|---|---|
| 1 | 23 | 12 | 23 | 67 | 18.40000000000000000000 | 9.60000000000000000000 | 18.40000000000000000000 | 53.60000000000000000000 |
| 2 | 56 | 90 | 23 | 18 | 29.94652406417112299500 | 48.12834224598930481300 | 12.29946524064171123000 | 9.62566844919786096300 |