gistfile1.txt

Limit  (cost=3748.55..3748.60 rows=20 width=82) (actual time=0.069..0.069 rows=0 loops=1)
  ->  Sort  (cost=3748.55..3748.85 rows=119 width=82) (actual time=0.066..0.066 rows=0 loops=1)
        Sort Key: t.due_date
        Sort Method: quicksort  Memory: 25kB
        ->  HashAggregate  (cost=3743.00..3744.19 rows=119 width=30) (actual time=0.046..0.046 rows=0 loops=1)
              ->  Append  (cost=10.74..3742.11 rows=119 width=30) (actual time=0.040..0.040 rows=0 loops=1)
                    ->  Nested Loop  (cost=10.74..2078.71 rows=83 width=30) (actual time=0.024..0.024 rows=0 loops=1)
                          ->  Bitmap Heap Scan on assignments a  (cost=10.17..892.60 rows=138 width=22) (actual time=0.021..0.021 rows=0 loops=1)
                                Recheck Cond: (organization_membership_id = '006ff3ea-8e4e-4aed-8051-47fe70bc7079'::uuid)
                                Filter: ((assignment_type)::text = 'Task'::text)
                                ->  Bitmap Index Scan on assignments_organization_membership_id_idx  (cost=0.00..10.14 rows=228 width=0) (actual time=0.016..0.016 rows=0 loops=1)
                                      Index Cond: (organization_membership_id = '006ff3ea-8e4e-4aed-8051-47fe70bc7079'::uuid)
                          ->  Index Scan using tasks_pkey on tasks t  (cost=0.56..8.58 rows=1 width=24) (never executed)
                                Index Cond: (id = a.task_id)
                    ->  Nested Loop  (cost=10.59..1662.22 rows=36 width=30) (actual time=0.011..0.011 rows=0 loops=1)
                          ->  Bitmap Heap Scan on assignments a_1  (cost=10.16..892.58 rows=91 width=22) (actual time=0.007..0.007 rows=0 loops=1)
                                Recheck Cond: (organization_membership_id = '006ff3ea-8e4e-4aed-8051-47fe70bc7079'::uuid)
                                Filter: ((assignment_type)::text = 'Checklist'::text)
                                ->  Bitmap Index Scan on assignments_organization_membership_id_idx  (cost=0.00..10.14 rows=228 width=0) (actual time=0.004..0.004 rows=0 loops=1)
                                      Index Cond: (organization_membership_id = '006ff3ea-8e4e-4aed-8051-47fe70bc7079'::uuid)
                          ->  Index Scan using process_groups_pkey on checklists c  (cost=0.43..8.45 rows=1 width=24) (never executed)
                                Index Cond: (id = a_1.checklist_id)
Total runtime: 0.218 ms