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?.
| version |
|---|
| PostgreSQL 12.0 (Debian 12.0-1.pgdg90+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit |
| num | md | a_2_s |
|---|---|---|
| 1 | e7dd7b67de3ad2378ee745a22c39758e | SIOVR |
| 2 | aa0abc309f3bd1e47c84aca7b8706f37 | WJFDT |
| 3 | 95fd9290f4589afa1846beaeb9662eca | WJFDT |
| 4 | 66de4c867a5939c73cba14466dcc2371 | WJFDT |
| 5 | ddc9bdf00fcdd4d125c54176b51db532 | WJFDT |