Postgres 13

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 SEQUENCE tag_seq START WITH 1;

CREATE TABLE tag 
    (id TEXT NOT NULL DEFAULT 'tag_'||nextval('tag_seq'::regclass), 
    name TEXT);

CREATE SEQUENCE

CREATE TABLE

INSERT INTO tag (name) VALUES ('foo'),('bar');    

INSERT 0 2

SELECT * FROM tag;

id
name

tag_1
foo

tag_2
bar

SELECT 2