select p.*
from respondent p
where exists(select from respondent_channel rc where p.id = rc.respondent_id and rc.channel_type = 'EMAIL')
  and 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')
  and p.space_id = 1
  and p.deleted_at is null

Gather  (cost=74938.89..354961.35 rows=334684 width=276) (actual time=374.626..3153.443 rows=333335 loops=1)
  Workers Planned: 2
  Workers Launched: 2
  ->  Nested Loop  (cost=73938.89..320492.95 rows=139452 width=276) (actual time=325.696..2941.918 rows=111112 loops=3)
        ->  Nested Loop  (cost=73938.47..209098.75 rows=163608 width=24) (actual time=324.900..1410.851 rows=111112 loops=3)
              ->  Parallel Hash Join  (cost=73938.04..131767.11 rows=151040 width=16) (actual time=324.100..509.668 rows=111112 loops=3)
                    Hash Cond: (rc_1.respondent_id = rc_2.respondent_id)
                    ->  Parallel Bitmap Heap Scan on respondent_channel rc_1  (cost=11056.62..63470.11 rows=413559 width=8) (actual time=35.420..116.657 rows=333335 loops=3)
                          Recheck Cond: (channel_type = 'SMS'::text)
                          Heap Blocks: exact=3141
                          ->  Bitmap Index Scan on respondent_channel_channel_type  (cost=0.00..10808.49 rows=992541 width=0) (actual time=33.630..33.630 rows=1000005 loops=1)
                                Index Cond: (channel_type = 'SMS'::text)
                    ->  Parallel Hash  (cost=58271.09..58271.09 rows=280986 width=8) (actual time=126.210..126.211 rows=222223 loops=3)
                          Buckets: 131072  Batches: 16  Memory Usage: 2688kB
                          ->  Parallel Bitmap Heap Scan on respondent_channel rc_2  (cost=7514.77..58271.09 rows=280986 width=8) (actual time=8.623..70.018 rows=222223 loops=3)
                                Recheck Cond: (channel_type = 'PUSH'::text)
                                Heap Blocks: exact=3526
                                ->  Bitmap Index Scan on respondent_channel_channel_type  (cost=0.00..7346.18 rows=674366 width=0) (actual time=24.642..24.642 rows=666670 loops=1)
                                      Index Cond: (channel_type = 'PUSH'::text)
              ->  Index Only Scan using respondent_id_channel on respondent_channel rc  (cost=0.43..0.51 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=333335)
                    Index Cond: ((respondent_id = rc_1.respondent_id) AND (channel_type = 'EMAIL'::text))
                    Heap Fetches: 0
        ->  Index Scan using respondent_pkey on respondent p  (cost=0.43..0.68 rows=1 width=276) (actual time=0.013..0.013 rows=1 loops=333335)
              Index Cond: (id = rc.respondent_id)
              Filter: ((deleted_at IS NULL) AND (space_id = 1))
Planning Time: 0.937 ms
Execution Time: 3170.429 ms

select p.*
from respondent p
where exists(select from respondent_channel rc where p.id = rc.respondent_id and rc.channel_type = 'EMAIL')
  and 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')
  and p.space_id = 1
  and p.deleted_at is null
offset 0
limit 12;

explain analyze
select p.*
from respondent p
where exists(select from respondent_channel rc where p.id = rc.respondent_id and rc.channel_type = 'EMAIL')
  and 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')
  and p.space_id = 1
  and p.deleted_at is null
offset 0
limit 12;

Limit  (cost=1.72..22.83 rows=12 width=276) (actual time=0.072..0.123 rows=12 loops=1)
  ->  Nested Loop  (cost=1.72..588717.46 rows=334591 width=276) (actual time=0.071..0.120 rows=12 loops=1)
        ->  Merge Join  (cost=1.29..321388.23 rows=392622 width=24) (actual time=0.054..0.076 rows=12 loops=1)
              Merge Cond: (rc_1.respondent_id = rc.respondent_id)
              ->  Merge Join  (cost=0.86..202524.14 rows=362461 width=16) (actual time=0.039..0.050 rows=12 loops=1)
                    Merge Cond: (rc_1.respondent_id = rc_2.respondent_id)
                    ->  Index Only Scan using respondent_id_channel on respondent_channel rc_1  (cost=0.43..98957.06 rows=992449 width=8) (actual time=0.021..0.025 rows=36 loops=1)
                          Index Cond: (channel_type = 'SMS'::text)
                          Heap Fetches: 0
                    ->  Index Only Scan using respondent_id_channel on respondent_channel rc_2  (cost=0.43..95775.60 rows=674303 width=8) (actual time=0.013..0.016 rows=24 loops=1)
                          Index Cond: (channel_type = 'PUSH'::text)
                          Heap Fetches: 0
              ->  Index Only Scan using respondent_id_channel on respondent_channel rc  (cost=0.43..109031.89 rows=1999932 width=8) (actual time=0.013..0.017 rows=71 loops=1)
                    Index Cond: (channel_type = 'EMAIL'::text)
                    Heap Fetches: 0
        ->  Index Scan using respondent_pkey on respondent p  (cost=0.43..0.68 rows=1 width=276) (actual time=0.003..0.003 rows=1 loops=12)
              Index Cond: (id = rc.respondent_id)
              Filter: ((deleted_at IS NULL) AND (space_id = 1))
Planning Time: 1.218 ms
Execution Time: 0.174 ms

Limit  (cost=1.72..22.83 rows=12 width=276) (actual time=0.058..0.097 rows=12 loops=1)
  ->  Nested Loop  (cost=1.72..588717.46 rows=334591 width=276) (actual time=0.058..0.095 rows=12 loops=1)
        ->  Merge Join  (cost=1.29..321388.23 rows=392622 width=24) (actual time=0.047..0.063 rows=12 loops=1)
              Merge Cond: (rc_1.respondent_id = rc.respondent_id)
              ->  Merge Join  (cost=0.86..202524.14 rows=362461 width=16) (actual time=0.035..0.042 rows=12 loops=1)
                    Merge Cond: (rc_1.respondent_id = rc_2.respondent_id)
                    ->  Index Only Scan using respondent_id_channel on respondent_channel rc_1  (cost=0.43..98957.06 rows=992449 width=8) (actual time=0.021..0.024 rows=36 loops=1)
                          Index Cond: (channel_type = 'SMS'::text)
                          Heap Fetches: 0
                    ->  Index Only Scan using respondent_id_channel on respondent_channel rc_2  (cost=0.43..95775.60 rows=674303 width=8) (actual time=0.010..0.012 rows=24 loops=1)
                          Index Cond: (channel_type = 'PUSH'::text)
                          Heap Fetches: 0
              ->  Index Only Scan using respondent_id_channel on respondent_channel rc  (cost=0.43..109031.89 rows=1999932 width=8) (actual time=0.011..0.016 rows=71 loops=1)
                    Index Cond: (channel_type = 'EMAIL'::text)
                    Heap Fetches: 0
        ->  Index Scan using respondent_pkey on respondent p  (cost=0.43..0.68 rows=1 width=276) (actual time=0.002..0.002 rows=1 loops=12)
              Index Cond: (id = rc.respondent_id)
              Filter: ((deleted_at IS NULL) AND (space_id = 1))
Planning Time: 1.103 ms
Execution Time: 0.145 ms

2021-07-12 16:55:34.982 MSK [7888] LOG:  duration: 0.817 ms
2021-07-12 16:55:34.987 MSK [7888] LOG:  duration: 0.031 ms  parse <unnamed>: BEGIN
2021-07-12 16:55:34.988 MSK [7888] LOG:  duration: 0.010 ms  bind <unnamed>: BEGIN
2021-07-12 16:55:34.989 MSK [21780] LOG:  duration: 0.045 ms  parse <unnamed>: 
2021-07-12 16:55:34.989 MSK [7888] LOG:  execute <unnamed>: BEGIN
2021-07-12 16:55:34.990 MSK [21780] LOG:  duration: 0.006 ms  bind <unnamed>: 
2021-07-12 16:55:34.990 MSK [7888] LOG:  duration: 1.114 ms
2021-07-12 16:55:34.993 MSK [21780] LOG:  duration: 0.037 ms  parse <unnamed>: BEGIN
2021-07-12 16:55:34.994 MSK [21780] LOG:  duration: 0.017 ms  bind <unnamed>: BEGIN
2021-07-12 16:55:34.994 MSK [7888] LOG:  duration: 2.932 ms  parse <unnamed>: select p.* from respondent p where exists (select from respondent_channel rc where p.id=rc.respondent_id and rc.channel_type = 'EMAIL') and 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') and p.space_id = 1 and p.deleted_at is null limit $1
2021-07-12 16:55:34.995 MSK [21780] LOG:  execute <unnamed>: BEGIN
2021-07-12 16:55:34.996 MSK [21780] LOG:  duration: 1.082 ms
2021-07-12 16:55:35.001 MSK [21780] LOG:  duration: 4.756 ms  parse <unnamed>: update "user" set last_request_at = $1 where id = $2
2021-07-12 16:55:35.004 MSK [7888] LOG:  duration: 9.240 ms  bind <unnamed>/C_2: select p.* from respondent p where exists (select from respondent_channel rc where p.id=rc.respondent_id and rc.channel_type = 'EMAIL') and 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') and p.space_id = 1 and p.deleted_at is null limit $1
2021-07-12 16:55:35.004 MSK [7888] DETAIL:  parameters: $1 = '12'
2021-07-12 16:55:35.006 MSK [7888] LOG:  execute <unnamed>/C_2: select p.* from respondent p where exists (select from respondent_channel rc where p.id=rc.respondent_id and rc.channel_type = 'EMAIL') and 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') and p.space_id = 1 and p.deleted_at is null limit $1
2021-07-12 16:55:35.006 MSK [7888] DETAIL:  parameters: $1 = '12'
2021-07-12 16:55:35.006 MSK [21780] LOG:  duration: 4.016 ms  bind <unnamed>: update "user" set last_request_at = $1 where id = $2
2021-07-12 16:55:35.006 MSK [21780] DETAIL:  parameters: $1 = '2021-07-12 16:55:34.984744+03', $2 = '1'
2021-07-12 16:55:35.007 MSK [7888] LOG:  duration: 1.440 ms
2021-07-12 16:55:35.007 MSK [21780] LOG:  execute <unnamed>: update "user" set last_request_at = $1 where id = $2
2021-07-12 16:55:35.007 MSK [21780] DETAIL:  parameters: $1 = '2021-07-12 16:55:34.984744+03', $2 = '1'
2021-07-12 16:55:35.014 MSK [21780] LOG:  duration: 7.272 ms
2021-07-12 16:55:35.015 MSK [7888] LOG:  duration: 0.326 ms  parse <unnamed>: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.015 MSK [21780] LOG:  duration: 0.034 ms  parse S_1: COMMIT
2021-07-12 16:55:35.016 MSK [21780] LOG:  duration: 0.012 ms  bind S_1: COMMIT
2021-07-12 16:55:35.017 MSK [21780] LOG:  execute S_1: COMMIT
2021-07-12 16:55:35.019 MSK [21780] LOG:  duration: 2.060 ms
2021-07-12 16:55:35.019 MSK [7888] LOG:  duration: 2.786 ms  bind <unnamed>/C_3: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.019 MSK [7888] DETAIL:  parameters: $1 = '2148078'
2021-07-12 16:55:35.020 MSK [7888] LOG:  execute <unnamed>/C_3: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.020 MSK [7888] DETAIL:  parameters: $1 = '2148078'
2021-07-12 16:55:35.021 MSK [7888] LOG:  duration: 1.552 ms
2021-07-12 16:55:35.022 MSK [7888] LOG:  duration: 0.078 ms  parse <unnamed>: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.024 MSK [7888] LOG:  duration: 0.231 ms  bind <unnamed>/C_4: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.024 MSK [7888] DETAIL:  parameters: $1 = '2148072'
2021-07-12 16:55:35.025 MSK [7888] LOG:  execute <unnamed>/C_4: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.025 MSK [7888] DETAIL:  parameters: $1 = '2148072'
2021-07-12 16:55:35.025 MSK [7888] LOG:  duration: 1.151 ms
2021-07-12 16:55:35.027 MSK [7888] LOG:  duration: 0.124 ms  parse <unnamed>: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.029 MSK [7888] LOG:  duration: 0.265 ms  bind <unnamed>/C_5: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.029 MSK [7888] DETAIL:  parameters: $1 = '2148066'
2021-07-12 16:55:35.030 MSK [7888] LOG:  execute <unnamed>/C_5: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.030 MSK [7888] DETAIL:  parameters: $1 = '2148066'
2021-07-12 16:55:35.031 MSK [7888] LOG:  duration: 1.728 ms
2021-07-12 16:55:35.033 MSK [7888] LOG:  duration: 0.079 ms  parse <unnamed>: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.034 MSK [7888] LOG:  duration: 0.214 ms  bind <unnamed>/C_6: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.034 MSK [7888] DETAIL:  parameters: $1 = '2148060'
2021-07-12 16:55:35.036 MSK [7888] LOG:  execute <unnamed>/C_6: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.036 MSK [7888] DETAIL:  parameters: $1 = '2148060'
2021-07-12 16:55:35.037 MSK [7888] LOG:  duration: 1.532 ms
2021-07-12 16:55:35.038 MSK [7888] LOG:  duration: 0.095 ms  parse S_7: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.039 MSK [7888] LOG:  duration: 0.180 ms  bind S_7/C_8: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.039 MSK [7888] DETAIL:  parameters: $1 = '2148054'
2021-07-12 16:55:35.040 MSK [7888] LOG:  execute S_7/C_8: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.040 MSK [7888] DETAIL:  parameters: $1 = '2148054'
2021-07-12 16:55:35.041 MSK [7888] LOG:  duration: 1.193 ms
2021-07-12 16:55:35.043 MSK [7888] LOG:  duration: 0.229 ms  bind S_7/C_9: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.043 MSK [7888] DETAIL:  parameters: $1 = '2148048'
2021-07-12 16:55:35.045 MSK [7888] LOG:  execute S_7/C_9: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.045 MSK [7888] DETAIL:  parameters: $1 = '2148048'
2021-07-12 16:55:35.046 MSK [7888] LOG:  duration: 1.825 ms
2021-07-12 16:55:35.048 MSK [7888] LOG:  duration: 0.178 ms  bind S_7/C_10: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.048 MSK [7888] DETAIL:  parameters: $1 = '2148042'
2021-07-12 16:55:35.050 MSK [7888] LOG:  execute S_7/C_10: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.050 MSK [7888] DETAIL:  parameters: $1 = '2148042'
2021-07-12 16:55:35.050 MSK [7888] LOG:  duration: 1.193 ms
2021-07-12 16:55:35.052 MSK [7888] LOG:  duration: 0.195 ms  bind S_7/C_11: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.052 MSK [7888] DETAIL:  parameters: $1 = '2148036'
2021-07-12 16:55:35.054 MSK [7888] LOG:  execute S_7/C_11: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.054 MSK [7888] DETAIL:  parameters: $1 = '2148036'
2021-07-12 16:55:35.054 MSK [7888] LOG:  duration: 1.503 ms
2021-07-12 16:55:35.056 MSK [7888] LOG:  duration: 0.172 ms  bind S_7/C_12: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.056 MSK [7888] DETAIL:  parameters: $1 = '2148030'
2021-07-12 16:55:35.058 MSK [7888] LOG:  execute S_7/C_12: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.058 MSK [7888] DETAIL:  parameters: $1 = '2148030'
2021-07-12 16:55:35.059 MSK [7888] LOG:  duration: 1.218 ms
2021-07-12 16:55:35.062 MSK [7888] LOG:  duration: 0.222 ms  bind S_7/C_13: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.062 MSK [7888] DETAIL:  parameters: $1 = '2148024'
2021-07-12 16:55:35.064 MSK [7888] LOG:  execute S_7/C_13: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.064 MSK [7888] DETAIL:  parameters: $1 = '2148024'
2021-07-12 16:55:35.064 MSK [7888] LOG:  duration: 1.411 ms
2021-07-12 16:55:35.066 MSK [7888] LOG:  duration: 0.039 ms  bind S_7/C_14: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.066 MSK [7888] DETAIL:  parameters: $1 = '2148018'
2021-07-12 16:55:35.067 MSK [7888] LOG:  execute S_7/C_14: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.067 MSK [7888] DETAIL:  parameters: $1 = '2148018'
2021-07-12 16:55:35.068 MSK [7888] LOG:  duration: 1.224 ms
2021-07-12 16:55:35.070 MSK [7888] LOG:  duration: 0.070 ms  bind S_7/C_15: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.070 MSK [7888] DETAIL:  parameters: $1 = '2148012'
2021-07-12 16:55:35.071 MSK [7888] LOG:  execute S_7/C_15: select respondent0_.respondent_id as responde3_80_0_, respondent0_.respondent_group_id as responde2_80_0_, respondent1_.id as id1_79_1_, respondent1_.created_at as created_2_79_1_, respondent1_.deleted_at as deleted_3_79_1_, respondent1_.updated_at as updated_4_79_1_, respondent1_.group_name as group_na5_79_1_, respondent1_.space_id as space_id6_79_1_ from respondent_respondent_group respondent0_ inner join respondent_group respondent1_ on respondent0_.respondent_group_id=respondent1_.id and ( respondent1_.deleted_at is null) where respondent0_.respondent_id=$1
2021-07-12 16:55:35.071 MSK [7888] DETAIL:  parameters: $1 = '2148012'
2021-07-12 16:55:35.073 MSK [7888] LOG:  duration: 2.217 ms
2021-07-12 16:55:35.080 MSK [7888] LOG:  duration: 2.714 ms  parse <unnamed>: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.087 MSK [7888] LOG:  duration: 6.634 ms  bind <unnamed>/C_16: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.087 MSK [7888] DETAIL:  parameters: $1 = '2148012'
2021-07-12 16:55:35.088 MSK [7888] LOG:  execute <unnamed>/C_16: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.088 MSK [7888] DETAIL:  parameters: $1 = '2148012'
2021-07-12 16:55:35.089 MSK [7888] LOG:  duration: 1.166 ms
2021-07-12 16:55:35.090 MSK [7888] LOG:  duration: 0.065 ms  parse <unnamed>: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.091 MSK [7888] LOG:  duration: 0.144 ms  bind <unnamed>/C_17: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.091 MSK [7888] DETAIL:  parameters: $1 = '2148012'
2021-07-12 16:55:35.092 MSK [7888] LOG:  execute <unnamed>/C_17: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.092 MSK [7888] DETAIL:  parameters: $1 = '2148012'
2021-07-12 16:55:35.094 MSK [7888] LOG:  duration: 1.809 ms
2021-07-12 16:55:35.101 MSK [7888] LOG:  duration: 0.089 ms  parse <unnamed>: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.102 MSK [7888] LOG:  duration: 0.289 ms  bind <unnamed>/C_18: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.102 MSK [7888] DETAIL:  parameters: $1 = '2148018'
2021-07-12 16:55:35.103 MSK [7888] LOG:  execute <unnamed>/C_18: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.103 MSK [7888] DETAIL:  parameters: $1 = '2148018'
2021-07-12 16:55:35.104 MSK [7888] LOG:  duration: 1.431 ms
2021-07-12 16:55:35.107 MSK [7888] LOG:  duration: 0.096 ms  parse <unnamed>: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.108 MSK [7888] LOG:  duration: 0.157 ms  bind <unnamed>/C_19: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.108 MSK [7888] DETAIL:  parameters: $1 = '2148018'
2021-07-12 16:55:35.109 MSK [7888] LOG:  execute <unnamed>/C_19: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.109 MSK [7888] DETAIL:  parameters: $1 = '2148018'
2021-07-12 16:55:35.110 MSK [7888] LOG:  duration: 1.847 ms
2021-07-12 16:55:35.116 MSK [7888] LOG:  duration: 0.115 ms  parse <unnamed>: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.117 MSK [7888] LOG:  duration: 0.263 ms  bind <unnamed>/C_20: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.117 MSK [7888] DETAIL:  parameters: $1 = '2148024'
2021-07-12 16:55:35.118 MSK [7888] LOG:  execute <unnamed>/C_20: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.118 MSK [7888] DETAIL:  parameters: $1 = '2148024'
2021-07-12 16:55:35.119 MSK [7888] LOG:  duration: 1.150 ms
2021-07-12 16:55:35.121 MSK [7888] LOG:  duration: 0.062 ms  parse <unnamed>: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.122 MSK [7888] LOG:  duration: 0.160 ms  bind <unnamed>/C_21: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.122 MSK [7888] DETAIL:  parameters: $1 = '2148024'
2021-07-12 16:55:35.123 MSK [7888] LOG:  execute <unnamed>/C_21: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.123 MSK [7888] DETAIL:  parameters: $1 = '2148024'
2021-07-12 16:55:35.124 MSK [7888] LOG:  duration: 1.167 ms
2021-07-12 16:55:35.136 MSK [7888] LOG:  duration: 0.160 ms  parse <unnamed>: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.137 MSK [7888] LOG:  duration: 0.241 ms  bind <unnamed>/C_22: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.137 MSK [7888] DETAIL:  parameters: $1 = '2148030'
2021-07-12 16:55:35.138 MSK [7888] LOG:  execute <unnamed>/C_22: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.138 MSK [7888] DETAIL:  parameters: $1 = '2148030'
2021-07-12 16:55:35.139 MSK [7888] LOG:  duration: 1.166 ms
2021-07-12 16:55:35.141 MSK [7888] LOG:  duration: 0.132 ms  parse <unnamed>: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.142 MSK [7888] LOG:  duration: 0.109 ms  bind <unnamed>/C_23: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.142 MSK [7888] DETAIL:  parameters: $1 = '2148030'
2021-07-12 16:55:35.144 MSK [7888] LOG:  execute <unnamed>/C_23: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.144 MSK [7888] DETAIL:  parameters: $1 = '2148030'
2021-07-12 16:55:35.145 MSK [7888] LOG:  duration: 1.704 ms
2021-07-12 16:55:35.152 MSK [7888] LOG:  duration: 0.124 ms  parse S_24: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.153 MSK [7888] LOG:  duration: 0.238 ms  bind S_24/C_25: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.153 MSK [7888] DETAIL:  parameters: $1 = '2148036'
2021-07-12 16:55:35.154 MSK [7888] LOG:  execute S_24/C_25: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.154 MSK [7888] DETAIL:  parameters: $1 = '2148036'
2021-07-12 16:55:35.155 MSK [7888] LOG:  duration: 1.216 ms
2021-07-12 16:55:35.156 MSK [7888] LOG:  duration: 0.085 ms  parse S_26: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.157 MSK [7888] LOG:  duration: 0.238 ms  bind S_26/C_27: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.157 MSK [7888] DETAIL:  parameters: $1 = '2148036'
2021-07-12 16:55:35.158 MSK [7888] LOG:  execute S_26/C_27: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.158 MSK [7888] DETAIL:  parameters: $1 = '2148036'
2021-07-12 16:55:35.159 MSK [7888] LOG:  duration: 1.271 ms
2021-07-12 16:55:35.164 MSK [7888] LOG:  duration: 0.191 ms  bind S_24/C_28: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.164 MSK [7888] DETAIL:  parameters: $1 = '2148042'
2021-07-12 16:55:35.165 MSK [7888] LOG:  execute S_24/C_28: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.165 MSK [7888] DETAIL:  parameters: $1 = '2148042'
2021-07-12 16:55:35.166 MSK [7888] LOG:  duration: 1.082 ms
2021-07-12 16:55:35.167 MSK [7888] LOG:  duration: 0.092 ms  bind S_26/C_29: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.167 MSK [7888] DETAIL:  parameters: $1 = '2148042'
2021-07-12 16:55:35.168 MSK [7888] LOG:  execute S_26/C_29: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.168 MSK [7888] DETAIL:  parameters: $1 = '2148042'
2021-07-12 16:55:35.169 MSK [7888] LOG:  duration: 1.106 ms
2021-07-12 16:55:35.172 MSK [7888] LOG:  duration: 0.213 ms  bind S_24/C_30: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.172 MSK [7888] DETAIL:  parameters: $1 = '2148048'
2021-07-12 16:55:35.174 MSK [7888] LOG:  execute S_24/C_30: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.174 MSK [7888] DETAIL:  parameters: $1 = '2148048'
2021-07-12 16:55:35.175 MSK [7888] LOG:  duration: 1.988 ms
2021-07-12 16:55:35.178 MSK [7888] LOG:  duration: 0.155 ms  bind S_26/C_31: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.178 MSK [7888] DETAIL:  parameters: $1 = '2148048'
2021-07-12 16:55:35.180 MSK [7888] LOG:  execute S_26/C_31: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.180 MSK [7888] DETAIL:  parameters: $1 = '2148048'
2021-07-12 16:55:35.180 MSK [7888] LOG:  duration: 1.432 ms
2021-07-12 16:55:35.184 MSK [7888] LOG:  duration: 0.189 ms  bind S_24/C_32: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.184 MSK [7888] DETAIL:  parameters: $1 = '2148054'
2021-07-12 16:55:35.185 MSK [7888] LOG:  execute S_24/C_32: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.185 MSK [7888] DETAIL:  parameters: $1 = '2148054'
2021-07-12 16:55:35.186 MSK [7888] LOG:  duration: 1.084 ms
2021-07-12 16:55:35.187 MSK [7888] LOG:  duration: 0.122 ms  bind S_26/C_33: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.187 MSK [7888] DETAIL:  parameters: $1 = '2148054'
2021-07-12 16:55:35.189 MSK [7888] LOG:  execute S_26/C_33: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.189 MSK [7888] DETAIL:  parameters: $1 = '2148054'
2021-07-12 16:55:35.189 MSK [7888] LOG:  duration: 1.198 ms
2021-07-12 16:55:35.194 MSK [7888] LOG:  duration: 0.275 ms  bind S_24/C_34: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.194 MSK [7888] DETAIL:  parameters: $1 = '2148060'
2021-07-12 16:55:35.195 MSK [7888] LOG:  execute S_24/C_34: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.195 MSK [7888] DETAIL:  parameters: $1 = '2148060'
2021-07-12 16:55:35.196 MSK [7888] LOG:  duration: 1.380 ms
2021-07-12 16:55:35.198 MSK [7888] LOG:  duration: 0.101 ms  bind S_26/C_35: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.198 MSK [7888] DETAIL:  parameters: $1 = '2148060'
2021-07-12 16:55:35.199 MSK [7888] LOG:  execute S_26/C_35: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.199 MSK [7888] DETAIL:  parameters: $1 = '2148060'
2021-07-12 16:55:35.200 MSK [7888] LOG:  duration: 1.194 ms
2021-07-12 16:55:35.204 MSK [7888] LOG:  duration: 0.206 ms  bind S_24/C_36: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.204 MSK [7888] DETAIL:  parameters: $1 = '2148066'
2021-07-12 16:55:35.205 MSK [7888] LOG:  execute S_24/C_36: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.205 MSK [7888] DETAIL:  parameters: $1 = '2148066'
2021-07-12 16:55:35.206 MSK [7888] LOG:  duration: 1.693 ms
2021-07-12 16:55:35.208 MSK [7888] LOG:  duration: 0.122 ms  bind S_26/C_37: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.208 MSK [7888] DETAIL:  parameters: $1 = '2148066'
2021-07-12 16:55:35.210 MSK [7888] LOG:  execute S_26/C_37: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.210 MSK [7888] DETAIL:  parameters: $1 = '2148066'
2021-07-12 16:55:35.211 MSK [7888] LOG:  duration: 1.721 ms
2021-07-12 16:55:35.215 MSK [7888] LOG:  duration: 0.054 ms  bind S_24/C_38: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.215 MSK [7888] DETAIL:  parameters: $1 = '2148072'
2021-07-12 16:55:35.216 MSK [7888] LOG:  execute S_24/C_38: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.216 MSK [7888] DETAIL:  parameters: $1 = '2148072'
2021-07-12 16:55:35.217 MSK [7888] LOG:  duration: 1.270 ms
2021-07-12 16:55:35.219 MSK [7888] LOG:  duration: 0.027 ms  bind S_26/C_39: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.219 MSK [7888] DETAIL:  parameters: $1 = '2148072'
2021-07-12 16:55:35.220 MSK [7888] LOG:  execute S_26/C_39: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.220 MSK [7888] DETAIL:  parameters: $1 = '2148072'
2021-07-12 16:55:35.221 MSK [7888] LOG:  duration: 1.222 ms
2021-07-12 16:55:35.224 MSK [7888] LOG:  duration: 0.031 ms  bind S_24/C_40: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.224 MSK [7888] DETAIL:  parameters: $1 = '2148078'
2021-07-12 16:55:35.225 MSK [7888] LOG:  execute S_24/C_40: select ap.id as answer_poll_id,p.name as poll_name,ap.started_at as start_date,extract(epoch from (ap.finished_at - ap.started_at)) as duration,ap.comment from oprosso.public.answer_poll ap join poll p on ap.poll_id = p.id where ap.finished_at is not null and ap.debug is false and ap.deleted_at is null and ap.respondent_id = $1
2021-07-12 16:55:35.225 MSK [7888] DETAIL:  parameters: $1 = '2148078'
2021-07-12 16:55:35.226 MSK [7888] LOG:  duration: 1.413 ms
2021-07-12 16:55:35.229 MSK [7888] LOG:  duration: 0.031 ms  bind S_26/C_41: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.229 MSK [7888] DETAIL:  parameters: $1 = '2148078'
2021-07-12 16:55:35.230 MSK [7888] LOG:  execute S_26/C_41: select respondent0_.respondent_id as responde8_78_0_, respondent0_.id as id1_78_0_, respondent0_.id as id1_78_1_, respondent0_.created_at as created_2_78_1_, respondent0_.deleted_at as deleted_3_78_1_, respondent0_.updated_at as updated_4_78_1_, respondent0_.channel_name as channel_5_78_1_, respondent0_.channel_state as channel_6_78_1_, respondent0_.channel_type as channel_7_78_1_, respondent0_.respondent_id as responde8_78_1_ from respondent_channel respondent0_ where ( respondent0_.deleted_at is null) and respondent0_.respondent_id=$1
2021-07-12 16:55:35.230 MSK [7888] DETAIL:  parameters: $1 = '2148078'
2021-07-12 16:55:35.231 MSK [7888] LOG:  duration: 1.365 ms
2021-07-12 16:55:35.236 MSK [7888] LOG:  duration: 1.363 ms  parse <unnamed>: select count(*) from respondent p where exists (select from respondent_channel rc where p.id=rc.respondent_id and rc.channel_type = 'EMAIL') and 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') and p.space_id = 1 and p.deleted_at is null
2021-07-12 16:55:35.237 MSK [7888] LOG:  duration: 1.211 ms  bind <unnamed>/C_42: select count(*) from respondent p where exists (select from respondent_channel rc where p.id=rc.respondent_id and rc.channel_type = 'EMAIL') and 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') and p.space_id = 1 and p.deleted_at is null
2021-07-12 16:55:35.238 MSK [7888] LOG:  execute <unnamed>/C_42: select count(*) from respondent p where exists (select from respondent_channel rc where p.id=rc.respondent_id and rc.channel_type = 'EMAIL') and 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') and p.space_id = 1 and p.deleted_at is null
2021-07-12 16:55:41.657 MSK [7888] LOG:  duration: 6419.398 ms
2021-07-12 16:55:41.660 MSK [7888] LOG:  duration: 0.007 ms  bind S_1: COMMIT

2021-07-12 17:03:21.599 MSK [22188] DETAIL:  parameters: $1 = '1003'
2021-07-12 17:03:21.601 MSK [22188] LOG:  execute <unnamed>: SELECT e.typdelim FROM pg_catalog.pg_type t, pg_catalog.pg_type e WHERE t.oid = $1 and t.typelem = e.oid
2021-07-12 17:03:21.601 MSK [22188] DETAIL:  parameters: $1 = '1003'
2021-07-12 17:03:21.602 MSK [22188] LOG:  duration: 1.610 ms
2021-07-12 17:03:21.611 MSK [22188] LOG:  duration: 3.983 ms  parse <unnamed>: select p.*

	from respondent p

	where exists(select from respondent_channel rc where p.id = rc.respondent_id and rc.channel_type = 'EMAIL')

	  and 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')

	  and p.space_id = 1

	  and p.deleted_at is null

	limit 12
2021-07-12 17:03:21.624 MSK [22188] LOG:  duration: 12.068 ms  bind <unnamed>: select p.*

	from respondent p

	where exists(select from respondent_channel rc where p.id = rc.respondent_id and rc.channel_type = 'EMAIL')

	  and 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')

	  and p.space_id = 1

	  and p.deleted_at is null

	limit 12
2021-07-12 17:03:21.625 MSK [22188] LOG:  execute <unnamed>: select p.*

	from respondent p

	where exists(select from respondent_channel rc where p.id = rc.respondent_id and rc.channel_type = 'EMAIL')

	  and 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')

	  and p.space_id = 1

	  and p.deleted_at is null

	limit 12
2021-07-12 17:03:21.626 MSK [22188] LOG:  duration: 0.968 ms
2021-07-12 17:03:21.630 MSK [22188] LOG:  duration: 0.461 ms  parse <unnamed>: SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN (SELECT 461778 AS oid , 1 AS attnum UNION ALL SELECT 461778, 2 UNION ALL SELECT 461778, 3 UNION ALL SELECT 461778, 4 UNION ALL SELECT 461778, 5 UNION ALL SELECT 461778, 6 UNION ALL SELECT 461778, 7 UNION ALL SELECT 461778, 8 UNION ALL SELECT 461778, 9 UNION ALL SELECT 461778, 10 UNION ALL SELECT 461778, 11 UNION ALL SELECT 461778, 12 UNION ALL SELECT 461778, 13 UNION ALL SELECT 461778, 14 UNION ALL SELECT 461778, 15 UNION ALL SELECT 461778, 16 UNION ALL SELECT 461778, 17) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum) 
2021-07-12 17:03:21.638 MSK [22188] LOG:  duration: 7.459 ms  bind <unnamed>: SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN (SELECT 461778 AS oid , 1 AS attnum UNION ALL SELECT 461778, 2 UNION ALL SELECT 461778, 3 UNION ALL SELECT 461778, 4 UNION ALL SELECT 461778, 5 UNION ALL SELECT 461778, 6 UNION ALL SELECT 461778, 7 UNION ALL SELECT 461778, 8 UNION ALL SELECT 461778, 9 UNION ALL SELECT 461778, 10 UNION ALL SELECT 461778, 11 UNION ALL SELECT 461778, 12 UNION ALL SELECT 461778, 13 UNION ALL SELECT 461778, 14 UNION ALL SELECT 461778, 15 UNION ALL SELECT 461778, 16 UNION ALL SELECT 461778, 17) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum) 
2021-07-12 17:03:21.639 MSK [22188] LOG:  execute <unnamed>: SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN (SELECT 461778 AS oid , 1 AS attnum UNION ALL SELECT 461778, 2 UNION ALL SELECT 461778, 3 UNION ALL SELECT 461778, 4 UNION ALL SELECT 461778, 5 UNION ALL SELECT 461778, 6 UNION ALL SELECT 461778, 7 UNION ALL SELECT 461778, 8 UNION ALL SELECT 461778, 9 UNION ALL SELECT 461778, 10 UNION ALL SELECT 461778, 11 UNION ALL SELECT 461778, 12 UNION ALL SELECT 461778, 13 UNION ALL SELECT 461778, 14 UNION ALL SELECT 461778, 15 UNION ALL SELECT 461778, 16 UNION ALL SELECT 461778, 17) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum) 
2021-07-12 17:03:21.640 MSK [22188] LOG:  duration: 1.196 ms
2021-07-12 17:03:21.649 MSK [22188] LOG:  duration: 0.267 ms  parse <unnamed>: SELECT n.nspname = ANY(current_schemas(true)), n.nspname, t.typname FROM pg_catalog.pg_type t JOIN pg_catalog.pg_namespace n ON t.typnamespace = n.oid WHERE t.oid = $1
2021-07-12 17:03:21.651 MSK [22188] LOG:  duration: 0.323 ms  bind <unnamed>: SELECT n.nspname = ANY(current_schemas(true)), n.nspname, t.typname FROM pg_catalog.pg_type t JOIN pg_catalog.pg_namespace n ON t.typnamespace = n.oid WHERE t.oid = $1
2021-07-12 17:03:21.651 MSK [22188] DETAIL:  parameters: $1 = '3802'
2021-07-12 17:03:21.653 MSK [22188] LOG:  execute <unnamed>: SELECT n.nspname = ANY(current_schemas(true)), n.nspname, t.typname FROM pg_catalog.pg_type t JOIN pg_catalog.pg_namespace n ON t.typnamespace = n.oid WHERE t.oid = $1
2021-07-12 17:03:21.653 MSK [22188] DETAIL:  parameters: $1 = '3802'
2021-07-12 17:03:21.654 MSK [22188] LOG:  duration: 1.867 ms
2021-07-12 17:03:21.657 MSK [22188] LOG:  duration: 1.885 ms  parse <unnamed>: SELECT typinput='array_in'::regproc, typtype   FROM pg_catalog.pg_type   LEFT   JOIN (select ns.oid as nspoid, ns.nspname, r.r           from pg_namespace as ns           join ( select s.r, (current_schemas(false))[s.r] as nspname                    from generate_series(1, array_upper(current_schemas(false), 1)) as s(r) ) as r          using ( nspname )        ) as sp     ON sp.nspoid = typnamespace  WHERE typname = $1  ORDER BY sp.r, pg_type.oid DESC LIMIT 1
2021-07-12 17:03:21.658 MSK [22188] LOG:  duration: 0.410 ms  bind <unnamed>: SELECT typinput='array_in'::regproc, typtype   FROM pg_catalog.pg_type   LEFT   JOIN (select ns.oid as nspoid, ns.nspname, r.r           from pg_namespace as ns           join ( select s.r, (current_schemas(false))[s.r] as nspname                    from generate_series(1, array_upper(current_schemas(false), 1)) as s(r) ) as r          using ( nspname )        ) as sp     ON sp.nspoid = typnamespace  WHERE typname = $1  ORDER BY sp.r, pg_type.oid DESC LIMIT 1
2021-07-12 17:03:21.658 MSK [22188] DETAIL:  parameters: $1 = 'jsonb'
2021-07-12 17:03:21.659 MSK [22188] LOG:  execute <unnamed>: SELECT typinput='array_in'::regproc, typtype   FROM pg_catalog.pg_type   LEFT   JOIN (select ns.oid as nspoid, ns.nspname, r.r           from pg_namespace as ns           join ( select s.r, (current_schemas(false))[s.r] as nspname                    from generate_series(1, array_upper(current_schemas(false), 1)) as s(r) ) as r          using ( nspname )        ) as sp     ON sp.nspoid = typnamespace  WHERE typname = $1  ORDER BY sp.r, pg_type.oid DESC LIMIT 1
2021-07-12 17:03:21.659 MSK [22188] DETAIL:  parameters: $1 = 'jsonb'
2021-07-12 17:03:21.660 MSK [22188] LOG:  duration: 1.374 ms
2021-07-12 17:03:21.698 MSK [22188] LOG:  duration: 0.074 ms  parse <unnamed>: SHOW TRANSACTION ISOLATION LEVEL
2021-07-12 17:03:21.698 MSK [22188] LOG:  duration: 0.018 ms  bind <unnamed>: SHOW TRANSACTION ISOLATION LEVEL
2021-07-12 17:03:21.699 MSK [22188] LOG:  execute <unnamed>: SHOW TRANSACTION ISOLATION LEVEL
2021-07-12 17:03:21.700 MSK [22188] LOG:  duration: 0.854 ms

Finalize Aggregate  (cost=321825.09..321825.10 rows=1 width=8) (actual time=2905.765..2986.388 rows=1 loops=1)
  ->  Gather  (cost=321824.87..321825.08 rows=2 width=8) (actual time=2905.756..2986.382 rows=3 loops=1)
        Workers Planned: 2
        Workers Launched: 2
        ->  Partial Aggregate  (cost=320824.87..320824.88 rows=1 width=8) (actual time=2856.987..2856.990 rows=1 loops=3)
              ->  Nested Loop  (cost=73937.04..320476.34 rows=139413 width=0) (actual time=401.690..2842.161 rows=111112 loops=3)
                    ->  Nested Loop  (cost=73936.61..209089.50 rows=163592 width=24) (actual time=401.045..1415.931 rows=111112 loops=3)
                          ->  Parallel Hash Join  (cost=73936.18..131764.68 rows=151025 width=16) (actual time=400.262..574.423 rows=111112 loops=3)
                                Hash Cond: (rc_1.respondent_id = rc_2.respondent_id)
                                ->  Parallel Bitmap Heap Scan on respondent_channel rc_1  (cost=11055.91..63468.91 rows=413520 width=8) (actual time=48.222..145.581 rows=333335 loops=3)
                                      Recheck Cond: (channel_type = 'SMS'::text)
                                      Heap Blocks: exact=4083
                                      ->  Bitmap Index Scan on resp_channel_type  (cost=0.00..10807.80 rows=992449 width=0) (actual time=46.315..46.315 rows=1000005 loops=1)
                                            Index Cond: (channel_type = 'SMS'::text)
                                ->  Parallel Hash  (cost=58270.27..58270.27 rows=280960 width=8) (actual time=148.452..148.453 rows=222223 loops=3)
                                      Buckets: 131072  Batches: 16  Memory Usage: 2688kB
                                      ->  Parallel Bitmap Heap Scan on respondent_channel rc_2  (cost=7514.28..58270.27 rows=280960 width=8) (actual time=12.095..85.504 rows=222223 loops=3)
                                            Recheck Cond: (channel_type = 'PUSH'::text)
                                            Heap Blocks: exact=2675
                                            ->  Bitmap Index Scan on resp_channel_type  (cost=0.00..7345.70 rows=674303 width=0) (actual time=34.712..34.712 rows=666670 loops=1)
                                                  Index Cond: (channel_type = 'PUSH'::text)
                          ->  Index Only Scan using respondent_id_channel on respondent_channel rc  (cost=0.43..0.51 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=333335)
                                Index Cond: ((respondent_id = rc_1.respondent_id) AND (channel_type = 'EMAIL'::text))
                                Heap Fetches: 0
                    ->  Index Scan using respondent_pkey on respondent p  (cost=0.43..0.68 rows=1 width=8) (actual time=0.012..0.012 rows=1 loops=333335)
                          Index Cond: (id = rc.respondent_id)
                          Filter: ((deleted_at IS NULL) AND (space_id = 1))
Planning Time: 1.508 ms
Execution Time: 2986.795 ms