Postgres 13

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 actions_table (profile_id int, action_name text, action_count int);

CREATE TABLE


insert into actions_table
values
  (1, 'action1', 2),
  (1, 'action2', 5),
  (2, 'action1', 3),
  (2, 'action2', 6),
  (2, 'action3', 7),
  (3, 'action1', 1);

INSERT 0 6


select profile_id, jsonb_object_agg(action_name, action_count)
from actions_table
group by profile_id
order by profile_id;


profile_id
jsonb_object_agg


1
{"action1": 2, "action2": 5}

2
{"action1": 3, "action2": 6, "action3": 7}

3
{"action1": 1}



SELECT 3

profile_id	jsonb_object_agg
1	{"action1": 2, "action2": 5}
2	{"action1": 3, "action2": 6, "action3": 7}
3	{"action1": 1}