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 t (name varchar, id int);
CREATE TABLE
insert into t(name, id) values ('a', 1) , ('b', 2), ('c', null)
INSERT 0 3
select * from t where id in (select id from t)
| name | id |
|---|---|
| a | 1 |
| b | 2 |
SELECT 2