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?.
attrelid | attname | serial_type |
---|---|---|
tbl | tbl_id | bigserial |
attrelid | attname | data_type |
---|---|---|
tbl | test1 | integer |
tbl | tbl_id | bigserial |
tbl | col1 | timestamp(2) without time zone |
tbl | col2 | numeric(9,3) |
tbl | test2 | integer |
tbl | some_serial | serial |
tbl | some_other | serial |