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 14.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10), 64-bit |
SELECT 1
CREATE TABLE
CREATE TABLE
INSERT 0 7
INSERT 0 4
mid | m_oid_wohnort | vorname | nachname | geburtsdatum | lieblingsort | lieblingsbeschaeftigung |
---|---|---|---|---|---|---|
1 | null | you | null | null | null | Datenbanken |
2 | 7 | me | null | 1987-12-24 | Meer | Datenbanken |
3 | 6 | Udo | Lindenberg | 1946-05-17 | null | Musik |
4 | 5 | Ludwig | van Beethoven | 1770-12-17 | null | Musik |
SELECT 4
vorname | ort |
---|---|
me | New York |
Udo | Berlin |
Ludwig | Bonn |
SELECT 3
vorname | ort |
---|---|
you | null |
me | New York |
Udo | Berlin |
Ludwig | Bonn |
SELECT 4
vorname | ort |
---|---|
Udo | Berlin |
Ludwig | Bonn |
SELECT 2