select distinct p.* from person p  join person_channel pc on p.id = pc.person_id where  pc.channel_type =all of this-> ('SMS' ,'PUSH');

select distinct p.* from person p  join person_channel pc on p.id = pc.person_id where  pc.channel_type  in ('SMS' ,'PUSH')

select distinct p.* from person p  join person_channel pc on p.id = pc.person_id where  pc.channel_type = have all of these elements (:list );

'SMS','PUSH','EMAIL'.....,etc

select  p.* from respondent p  join respondent_channel rc on p.id = rc.respondent_id where  rc.channel_type = any(string_to_array(:some_list,','))
group by p.id
having count(distinct rc.channel_type )=array_length(string_to_array(:some_list,','),1);

Seq Scan on respondent p  (cost=0.00..1870.24 rows=402 width=209) (actual time=0.186..2.018 rows=2 loops=1)
  Filter: (SubPlan 1)
  Rows Removed by Filter: 802
  SubPlan 1
    ->  Limit  (cost=1.15..2.30 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=804)
          ->  Seq Scan on respondent_channel rc  (cost=0.00..1.15 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=804)
"                Filter: ((channel_type = ANY ('{PUSH,SMS}'::text[])) AND (p.id = respondent_id))"
                Rows Removed by Filter: 10
Planning Time: 0.277 ms
Execution Time: 2.089 ms

select  p.* from respondent p where
  exists(select from respondent_channel rc where p.id = rc.respondent_id and   rc.channel_type ='SMS') and
  exists(select from respondent_channel rc where p.id = rc.respondent_id and   rc.channel_type ='PUSH')

Nested Loop Semi Join  (cost=1.54..9.65 rows=1 width=209) (actual time=0.101..0.115 rows=2 loops=1)
  ->  Nested Loop  (cost=1.40..9.45 rows=1 width=217) (actual time=0.067..0.076 rows=2 loops=1)
        ->  HashAggregate  (cost=1.13..1.14 rows=1 width=8) (actual time=0.030..0.032 rows=2 loops=1)
              Group Key: rc.respondent_id
              Batches: 1  Memory Usage: 24kB
              ->  Seq Scan on respondent_channel rc  (cost=0.00..1.12 rows=1 width=8) (actual time=0.021..0.022 rows=2 loops=1)
                    Filter: (channel_type = 'SMS'::text)
                    Rows Removed by Filter: 8
        ->  Index Scan using respondent_pkey on respondent p  (cost=0.28..8.29 rows=1 width=209) (actual time=0.019..0.019 rows=1 loops=2)
              Index Cond: (id = rc.respondent_id)
  ->  Index Only Scan using respondent_id_channel on respondent_channel rc_1  (cost=0.14..0.17 rows=1 width=8) (actual time=0.017..0.017 rows=1 loops=2)
        Index Cond: ((respondent_id = p.id) AND (channel_type = 'PUSH'::text))
        Heap Fetches: 2
Planning Time: 0.389 ms
Execution Time: 0.241 ms

select  p.* from respondent p where
 exists(select from respondent_channel rc where p.id = rc.respondent_id and   rc.channel_type in (:some_list) limit 1 offset 2)