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?.
create table test
(
id integer generated always as identity,
some_date date default current_date,
some_nr int default 42
)
insert into test
default values;
1 rows affected
select *
from test;
| id | some_date | some_nr |
|---|---|---|
| 1 | 2022-04-07 | 42 |