Unique  (cost=125255.37..126669.48 rows=199 width=204)
  ->  Merge Join  (cost=125255.37..126668.99 rows=199 width=204)
        Merge Cond: (tasks.gid = tasks__projects_1._sdc_source_key_gid)
        ->  Sort  (cost=113995.54..113996.04 rows=199 width=150)
              Sort Key: tasks.gid
              ->  Hash Right Join  (cost=94887.17..113987.94 rows=199 width=150)
                    Hash Cond: (tasks__custom_fields_3._sdc_source_key_gid = tasks.gid)
                    ->  Seq Scan on tasks__custom_fields tasks__custom_fields_3  (cost=0.00..18898.70 rows=53394 width=24)
                          Filter: (name = 'Task Owner'::text)
                    ->  Hash  (cost=94884.69..94884.69 rows=199 width=142)
                          ->  Hash Right Join  (cost=75787.09..94884.69 rows=199 width=142)
                                Hash Cond: (tasks__custom_fields_1._sdc_source_key_gid = tasks.gid)
                                ->  Seq Scan on tasks__custom_fields tasks__custom_fields_1  (cost=0.00..18898.70 rows=52556 width=24)
                                      Filter: (name = 'Estimated Hours'::text)
                                ->  Hash  (cost=75784.60..75784.60 rows=199 width=134)
                                      ->  Hash Right Join  (cost=56741.81..75784.60 rows=199 width=134)
                                            Hash Cond: (tasks__custom_fields._sdc_source_key_gid = tasks.gid)
                                            ->  Seq Scan on tasks__custom_fields  (cost=0.00..18898.70 rows=38077 width=24)
                                                  Filter: (name = '% completed'::text)
                                            ->  Hash  (cost=56739.32..56739.32 rows=199 width=126)
                                                  ->  Hash Right Join  (cost=41142.13..56739.32 rows=199 width=126)
                                                        Hash Cond: (tasks__custom_fields_2._sdc_source_key_gid = tasks.gid)
                                                        ->  Gather  (cost=1000.00..16586.49 rows=2827 width=24)
                                                              Workers Planned: 2
                                                              ->  Parallel Seq Scan on tasks__custom_fields tasks__custom_fields_2  (cost=0.00..15303.79 rows=1178 width=24)
                                                                    Filter: (name = 'IT/Engineering Status'::text)
                                                        ->  Hash  (cost=40139.64..40139.64 rows=199 width=118)
                                                              ->  Hash Right Join  (cost=24741.72..40139.64 rows=199 width=118)
                                                                    Hash Cond: (tasks__custom_fields_5._sdc_source_key_gid = tasks.gid)
                                                                    ->  Gather  (cost=1000.00..16394.49 rows=907 width=24)
                                                                          Workers Planned: 2
                                                                          ->  Parallel Seq Scan on tasks__custom_fields tasks__custom_fields_5  (cost=0.00..15303.79 rows=378 width=24)
                                                                                Filter: ((enum_value__name IS NOT NULL) AND (name = 'Priority'::text))
                                                                    ->  Hash  (cost=23739.23..23739.23 rows=199 width=110)
                                                                          ->  Hash Right Join  (cost=8106.52..23739.23 rows=199 width=110)
                                                                                Hash Cond: (tasks__custom_fields_4._sdc_source_key_gid = tasks.gid)
                                                                                ->  Gather  (cost=1000.00..16624.29 rows=3205 width=24)
                                                                                      Workers Planned: 2
                                                                                      ->  Parallel Seq Scan on tasks__custom_fields tasks__custom_fields_4  (cost=0.00..15303.79 rows=1335 width=24)
                                                                                            Filter: (name = 'IT/Eng Deadline Status'::text)
                                                                                ->  Hash  (cost=7104.04..7104.04 rows=199 width=102)
                                                                                      ->  Subquery Scan on tasks  (cost=7078.87..7104.04 rows=199 width=102)
                                                                                            ->  Unique  (cost=7078.87..7102.05 rows=199 width=641)
                                                                                                  ->  Gather Merge  (cost=7078.87..7101.55 rows=199 width=641)
                                                                                                        Workers Planned: 1
                                                                                                        ->  Sort  (cost=6078.86..6079.15 rows=117 width=641)
                                                                                                              Sort Key: tasks_1.gid
                                                                                                              ->  Nested Loop  (cost=0.42..6074.84 rows=117 width=641)
                                                                                                                    ->  Parallel Seq Scan on tasks__projects  (cost=0.00..2201.62 rows=745 width=16)
                                                                                                                          Filter: (gid = '1138791545416725'::text)
                                                                                                                    ->  Index Scan using tasks_pkey on tasks tasks_1  (cost=0.42..5.20 rows=1 width=102)
                                                                                                                          Index Cond: (gid = tasks__projects._sdc_source_key_gid)
                                                                                                                          Filter: ((NOT completed) AND (name <> ''::text))
        ->  Unique  (cost=11259.83..11747.99 rows=73320 width=108)
              ->  Sort  (cost=11259.83..11503.91 rows=97633 width=108)
                    Sort Key: tasks__projects_1._sdc_source_key_gid, projects.created_at DESC
                    ->  Hash Join  (cost=204.65..3168.45 rows=97633 width=108)
                          Hash Cond: (tasks__projects_1.gid = projects.gid)
                          ->  Seq Scan on tasks__projects tasks__projects_1  (cost=0.00..2461.40 rows=98140 width=32)
                          ->  Hash  (cost=185.38..185.38 rows=1542 width=76)
                                ->  Seq Scan on projects  (cost=0.00..185.38 rows=1542 width=76)
                                      Filter: ("substring"(name, '^[a-zA-Z]\w*(?:-\w+)+\M'::text) IS NOT NULL)
JIT:
  Functions: 97
  Options: Inlining false, Optimization false, Expressions true, Deforming true