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 table_1 (id_user int, name text, value text);
insert into table_1 
values 
(1489, 'name 1', 'value aaaaaa'),
(1489, 'name 2', 'value babababab'),
(1490, 'name 12', 'value aaaaaa'),
(1490, 'name 2', 'value babababab'),
(1491, 'name 13', 'value aaaaaa'),
(1491, 'name 23', 'value uouououo');
6 rows affected

SELECT jsonb_agg(to_jsonb(body)) as jsonarray
FROM (
  SELECT distinct id_user, name, value
  FROM table_1
) body
group by body.id_user
having bool_or(name = 'name 2');


jsonarray


[{"name": "name 1", "value": "value aaaaaa", "id_user": 1489}, {"name": "name 2", "value": "value babababab", "id_user": 1489}]

[{"name": "name 12", "value": "value aaaaaa", "id_user": 1490}, {"name": "name 2", "value": "value babababab", "id_user": 1490}]