Postgres 9.5

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 apts (
tslot varchar(10),	
Data1 int,	Data2	int);
insert into apts values
('08:00',	1234,	6758),	
('08:10',	5768,	4658),	
('09:00',	6754,	8674);
3 rows affected

create table slots( tim varchar(10));
insert into slots values
('08:00'),('08:10'),('08:20'),
('08:30'),('08:40'),('08:50'),
('09:00');
7 rows affected

select tim slot,data1,data2
from apts 
right join slots on tslot = tim;


slot
data1
data2


08:00
1234
6758

08:10
5768
4658

08:20
null
null

08:30
null
null

08:40
null
null

08:50
null
null

09:00
6754
8674

slot	data1	data2
08:00	1234	6758
08:10	5768	4658
08:20	null	null
08:30	null	null
08:40	null	null
08:50	null	null
09:00	6754	8674