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 mytable(id text, date1 date, string1 text, date2 date, string2 text)
CREATE TABLE
insert into mytable values('INI100', '2020-02-02', 'aaaaa', '2020-02-03', 'bbbbb');
INSERT 0 1
select v.*
from mytable t
cross join lateral(
values(id, date1::text), (id, string1), (id, date2::text), (id, string2)
) v(id, val)
| id | val |
|---|---|
| INI100 | 2020-02-02 |
| INI100 | aaaaa |
| INI100 | 2020-02-03 |
| INI100 | bbbbb |
SELECT 4