Unique  (cost=11787.13..12081.81 rows=11787 width=81)"
  ->  Sort  (cost=11787.13..11816.60 rows=11787 width=81)"
        Sort Key: t.user_id, i.email, t.enabled, t.admin, t.abonnement, t.actu, t.first_sbsc, t.thematique, t.creation_date"
        ->  Hash Left Join  (cost=4303.35..10423.04 rows=11787 width=81)"
              Hash Cond: ((acl.account_id)::text = (s.account_id)::text)"
              Filter: (s.account_id IS NULL)"
              ->  Nested Loop Left Join  (cost=2671.24..6316.24 rows=12330 width=92)"
                    ->  Hash Left Join  (cost=2671.24..3742.10 rows=5042 width=91)"
                          Hash Cond: ((u.id)::text = (t.user_id)::text)"
                          ->  Hash Left Join  (cost=1422.12..2047.04 rows=5042 width=33)"
                                Hash Cond: ((i.email)::text = (u.email)::text)"
                                ->  Seq Scan on inrq_information_request i  (cost=0.00..266.42 rows=5042 width=23)"
                                ->  Hash  (cost=886.61..886.61 rows=26361 width=37)"
                                      ->  Seq Scan on sbsc_user u  (cost=0.00..886.61 rows=26361 width=37)"
                          ->  Hash  (cost=635.61..635.61 rows=26361 width=58)"
                                ->  Seq Scan on talend_users t  (cost=0.00..635.61 rows=26361 width=58)"
                    ->  Index Scan using ix_sbscaccntacl_usrid on sbsc_account_acl acl  (cost=0.00..0.47 rows=3 width=21)"
                          Index Cond: ((u.id)::text = (acl.user_id)::text)"
              ->  Hash  (cost=932.27..932.27 rows=40227 width=11)"
                    ->  Seq Scan on sbsc_subscription s  (cost=0.00..932.27 rows=40227 width=11)"