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 9.3.25 on x86_64-pc-linux-musl, compiled by gcc (Alpine 11.2.1_git20220219) 11.2.1 20220219, 64-bit |
SELECT 1
ALTER TABLE
attrelid | attnum | attname | attnotnull | attisdropped |
---|---|---|---|---|
notnull_tbl1 | 1 | c0 | t | f |
notnull_tbl1 | 2 | ........pg.dropped.2........ | f | t |
SELECT 2