История изменений

select *
 from
   (select
       users.id,
       jsonb_agg(jsonb_build_object('id', messages.id, 'message', messages.message)) as messages
   from
       users
   left outer join usermessages on
       usermessages."user" = users.id
   left outer join messages on
       messages.id = usermessages.message
   group by
       users.id
   ) as subquery
 where
     subquery.messages @> '[{ "message": "foo" }]'::jsonb;