Postgres 12

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 TYPE adresse AS
(
  id_adresse integer,
  plz integer,
  wohnort text,
  strasse text,
  hausnr integer,
  land text
);
CREATE TABLE person
(
  id integer NOT NULL,
  nachname character varying(255) COLLATE pg_catalog."default" NOT NULL,
  vorname character varying(255) COLLATE pg_catalog."default" NOT NULL,
  adresse adresse[],
  CONSTRAINT person_pkey PRIMARY KEY (id)
);
insert into person (id, nachname, vorname, adresse)
values 
(1,'Grabowsky','Karl Heinz', 
     ARRAY[ROW(1,55801, 'Bad Salzuflen','Soester Weg',51,'Deutschland')::Adresse, 
     row(2,15098,'Emsbueren','Ackerstraße',54,'Deutschland')::Adresse] 
);
1 rows affected

select id, nachname, vorname, adresse[1].wohnort, adresse[1].strasse
from person;


id
nachname
vorname
wohnort
strasse


1
Grabowsky
Karl Heinz
Bad Salzuflen
Soester Weg