Postgres 12

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 data (users text, day text, polls int);
insert into data
values
('alberto', 'day1', 23),
('alberto', 'day2', 2),
('alberto', 'day3', 43),
('alberto', 'day4', 12);
4 rows affected

select users, jsonb_object_agg(day, polls)
from data
group by users;


users
jsonb_object_agg


alberto
{"day1": 23, "day2": 2, "day3": 43, "day4": 12}