Finalize Aggregate  (cost=24741.60..24741.60 rows=1 width=8) (actual time=429.478..429.478 rows=1 loops=1)
  ->  Gather  (cost=24741.49..24741.60 rows=1 width=8) (actual time=429.204..445.027 rows=2 loops=1)
        Workers Planned: 1
        Workers Launched: 1
        ->  Partial Aggregate  (cost=23741.49..23741.50 rows=1 width=8) (actual time=420.130..420.130 rows=1 loops=2)
              ->  Nested Loop  (cost=15134.68..23739.67 rows=3640 width=0) (actual time=89.982..419.729 rows=1729 loops=2)
                    ->  Hash Join  (cost=15134.60..22918.76 rows=8621 width=4) (actual time=89.440..367.009 rows=7892 loops=2)
                          Hash Cond: (crm_role.user_id = tcauth_user.id)
                          ->  Parallel Seq Scan on crm_role  (cost=0.00..7519.84 rows=317948 width=8) (actual time=0.015..180.495 rows=271204 loops=2)
                          ->  Hash  (cost=15085.97..15085.97 rows=13894 width=4) (actual time=89.225..89.225 rows=15655 loops=2)
                                Buckets: 16384  Batches: 1  Memory Usage: 679kB
                                ->  Bitmap Heap Scan on tcauth_user  (cost=149.43..15085.97 rows=13894 width=4) (actual time=6.147..78.915 rows=15655 loops=2)
                                      Recheck Cond: (branch_id = ?)
                                      Filter: (NOT is_deleted)
                                      Rows Removed by Filter: 253
                                      Heap Blocks: exact=4844
                                      ->  Bitmap Index Scan on tcauth_user_09fd5b13  (cost=0.00..148.73 rows=15100 width=0) (actual time=5.176..5.176 rows=15914
                                            Index Cond: (branch_id = ?)
                    ->  Index Only Scan using crm_client_pkey on crm_client  (cost=0.08..0.09 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=15784)
                          Index Cond: (role_ptr_id = crm_role.id)
                          Heap Fetches: 73
Planning time: 2.769 ms
Execution time: 445.225 ms