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 tbl(name text, count int);
insert into tbl values ('name 1', 100),('name 2 ', 140),('name 3', 500);
3 rows affected
select name, max(count) cnt
from tbl
group by name
limit 1;
| name | cnt |
|---|---|
| name 3 | 500 |