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
CREATE TABLE
CREATE TABLE
INSERT 0 2
id | type |
---|---|
b1f05e8c-0bb4-4f3a-8d39-0fbae1157a1d | baz |
89f74feb-8afd-4d98-bc71-3d93cb013b27 | foo |
d82adcfa-6d9b-4a79-b326-328b79bae41f | bar |
SELECT 3
id | source_id | name | value_id |
---|---|---|---|
194a8680-9806-4678-ae1c-a04c776056ff | 89f74feb-8afd-4d98-bc71-3d93cb013b27 | bar | d82adcfa-6d9b-4a79-b326-328b79bae41f |
ee529ce8-6154-4914-8ad1-dbb0cd0225f0 | d82adcfa-6d9b-4a79-b326-328b79bae41f | baz | b1f05e8c-0bb4-4f3a-8d39-0fbae1157a1d |
SELECT 2
id | source_id | name | value |
---|---|---|---|
005a54d6-b1aa-499c-9f2c-677c85394cde | b1f05e8c-0bb4-4f3a-8d39-0fbae1157a1d | slug | hello-world |
SELECT 1
INSERT 0 0