add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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