"Aggregate  (cost=16500.12..16500.13 rows=1 width=60) (actual time=219618.958..219618.958 rows=1 loops=1)"
"  Output: sum("*SELECT* 1".totalactualhours), sum(CASE WHEN (hashed SubPlan 3) THEN "*SELECT* 1".totalactualcostinbasecurrency ELSE NULL::numeric END), sum(CASE WHEN (hashed SubPlan 6) THEN "*SELECT* 1".totalactualbillinginbasecurrency ELSE NULL::numeric END)"
"  Buffers: shared hit=200269561 read=5154"
"  ->  Append  (cost=768.76..12253.42 rows=23313 width=60) (actual time=219279.270..219339.948 rows=15150 loops=1)"
"        Buffers: shared hit=200104434 read=4345"
"        ->  Subquery Scan on "*SELECT* 1"  (cost=768.76..6524.63 rows=1 width=60) (actual time=219279.269..219318.962 rows=15150 loops=1)"
"              Output: "*SELECT* 1".totalactualhours, "*SELECT* 1".projectid, "*SELECT* 1".totalactualcostinbasecurrency, "*SELECT* 1".totalactualbillinginbasecurrency"
"              Filter: ((hashed SubPlan 7) OR (hashed SubPlan 8) OR (hashed SubPlan 9))"
"              Buffers: shared hit=200101831 read=3123"
"              ->  Merge Anti Join  (cost=0.57..5756.43 rows=1 width=60) (actual time=19.530..46.921 rows=15150 loops=1)"
"                    Output: dm_projectlist_facts.projectid, NULL::text, NULL::text, NULL::text, NULL::integer, NULL::integer, NULL::date, NULL::date, NULL::integer, NULL::text, NULL::text, NULL::uuid, NULL::text, NULL::text, NULL::numeric(19,4), dm_projectlist_facts.totalactualbillinginbasecurrency, NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), dm_projectlist_facts.totalactualcostinbasecurrency, NULL::numeric(19,4), NULL::numeric(19,4), NULL::interval, dm_projectlist_facts.totalactualhours, NULL::numeric(19,4), NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::uuid, NULL::numeric(19,4)"
"                    Merge Cond: (dm_projectlist_facts.projectid = dm_projectlist_realtime_facts.projectid)"
"                    Buffers: shared hit=17725 read=3123"
"                    ->  Index Scan using dm_projectlist_facts_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_facts  (cost=0.29..836.02 rows=8400 width=60) (actual time=0.016..13.059 rows=15150 loops=1)"
"                          Output: dm_projectlist_facts.projectid, dm_projectlist_facts.projectguidid, dm_projectlist_facts.name, dm_projectlist_facts.slug, dm_projectlist_facts.code, dm_projectlist_facts.statustype, dm_projectlist_facts.invoicingtype, dm_projectlist_facts.estimationmode, dm_projectlist_facts.startdate, dm_projectlist_facts.enddate, dm_projectlist_facts.projectleaderid, dm_projectlist_facts.projectleaderdisplayname, dm_projectlist_facts.projectleaderslug, dm_projectlist_facts.programid, dm_projectlist_facts.programname, dm_projectlist_facts.programslug, dm_projectlist_facts.totalestimatedbillinginbasecurrency, dm_projectlist_facts.totalactualbillinginbasecurrency, dm_projectlist_facts.totalestimatedcostinbasecurrency, dm_projectlist_facts.totalestimatedcostcapexinbasecurrency, dm_projectlist_facts.totalestimatedcostopexinbasecurrency, dm_projectlist_facts.totalactualcostinbasecurrency, dm_projectlist_facts.totalactualcostcapexinbasecurrency, dm_projectlist_facts.totalactualcostopexinbasecurrency, dm_projectlist_facts.totalestimatedhours, dm_projectlist_facts.totalactualhours, dm_projectlist_facts.hoursfte, dm_projectlist_facts.estimatedresources, dm_projectlist_facts.assignedresources, dm_projectlist_facts.placeholderresources, dm_projectlist_facts.totalactualbillingamountinbasecurrency"
"                          Filter: ((dm_projectlist_facts.statustype <> 5) OR (dm_projectlist_facts.statustype IS NULL))"
"                          Buffers: shared hit=8796 read=468"
"                    ->  Index Only Scan using dm_projectlist_realtime_facts_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_realtime_facts  (cost=0.29..4681.54 rows=53550 width=4) (actual time=19.508..19.508 rows=0 loops=1)"
"                          Output: dm_projectlist_realtime_facts.projectid"
"                          Heap Fetches: 12484"
"                          Buffers: shared hit=8929 read=2655"
"              SubPlan 7"
"                ->  Nested Loop  (cost=0.50..4.54 rows=1 width=4) (actual time=0.031..219212.272 rows=15150 loops=1)"
"                      Output: project13.id"
"                      Join Filter: (project13.id = project14.id)"
"                      Rows Removed by Join Filter: 229507350"
"                      Buffers: shared hit=200084106"
"                      ->  Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project13  (cost=0.25..2.26 rows=1 width=4) (actual time=0.014..19.285 rows=15150 loops=1)"
"                            Output: project13.id"
"                            Heap Fetches: 25031"
"                            Buffers: shared hit=13206"
"                      ->  Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project14  (cost=0.25..2.26 rows=1 width=4) (actual time=0.006..10.458 rows=15150 loops=15150)"
"                            Output: project14.id"
"                            Heap Fetches: 379219650"
"                            Buffers: shared hit=200070900"
"              SubPlan 8"
"                ->  Nested Loop Left Join  (cost=0.41..11.78 rows=1 width=4) (never executed)"
"                      Output: project15.id"
"                      Filter: ((project15.projectleaderapproverid = 2) OR (projectsharingassignment16.userid = 2))"
"                      ->  Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project15  (cost=0.25..2.26 rows=1 width=8) (never executed)"
"                            Output: project15.id, project15.guidid, project15.name, project15.slug, project15.code, project15.clientid, project15.projectleaderapproverid, project15.projectstatuslabelid, project15.isprojectleaderapprovalrequired, project15.startdate, project15.enddate, project15.programid, project15.billingtype, project15.fixedbidamount, project15.fixedbidcurrencyid, project15.fixedbidfrequency, project15.timeentrycappercent, project15.costtype, project15.clientbillingallocationmethod, project15.description, project15.percentcomplete, project15.istimeentryallowed, project15.estimatedhours, project15.estimatedexpenses, project15.estimatedexpensescurrencyid, project15.estimatedcost, project15.estimatedcostcurrencyid, project15.timeandexpenseentrytype, project15.estimationmode, project15.billingratefrequencyid, project15.billingratefrequencyduration, project15.defaultbillingcurrencyid, project15.billingcontractid, project15.projecthealthstateid, project15.projecthealthstatedescription, project15.totalestimatedcontractamount, project15.totalestimatedcontractcurrencyid, project15.budgetedhours, project15.budgetedcost, project15.budgetedcostcurrencyid, project15.info1, project15.info2, project15.info3, project15.info4, project15.info5, project15.info6, project15.info7, project15.info8, project15.info9, project15.info10, project15.info11, project15.info12, project15.info13, project15.info14, project15.info15, project15.info16, project15.info17, project15.info18, project15.info19, project15.info20"
"                      ->  Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment16  (cost=0.15..9.35 rows=11 width=8) (never executed)"
"                            Output: projectsharingassignment16.projectid, projectsharingassignment16.userid"
"                            Index Cond: (projectsharingassignment16.projectid = project15.id)"
"                            Heap Fetches: 0"
"              SubPlan 9"
"                ->  Hash Left Join  (cost=10.28..751.68 rows=70 width=4) (never executed)"
"                      Output: project17.id"
"                      Hash Cond: (projectclient18.clientid = clients19.id)"
"                      Filter: ((clients19.clientmanageruserid = 2) OR (clientsharingassignment20.userid = 2))"
"                      ->  Nested Loop Left Join  (cost=0.54..738.06 rows=891 width=8) (never executed)"
"                            Output: project17.id, projectclient18.clientid"
"                            ->  Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project17  (cost=0.25..2.26 rows=1 width=4) (never executed)"
"                                  Output: project17.id"
"                                  Heap Fetches: 0"
"                            ->  Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient18  (cost=0.29..726.89 rows=891 width=8) (never executed)"
"                                  Output: projectclient18.projectid, projectclient18.clientid, projectclient18.effectivedate, projectclient18.enddate"
"                                  Index Cond: (projectclient18.projectid = project17.id)"
"                                  Heap Fetches: 0"
"                      ->  Hash  (cost=9.64..9.64 rows=8 width=12) (never executed)"
"                            Output: clients19.id, clients19.clientmanageruserid, clientsharingassignment20.userid"
"                            ->  Nested Loop Left Join  (cost=0.40..9.64 rows=8 width=12) (never executed)"
"                                  Output: clients19.id, clients19.clientmanageruserid, clientsharingassignment20.userid"
"                                  ->  Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients19  (cost=0.25..2.26 rows=1 width=8) (never executed)"
"                                        Output: clients19.id, clients19.name, clients19.slug, clients19.code, clients19.comments, clients19.clientmanageruserid, clients19.disabled, clients19.address, clients19.city, clients19.stateprovince, clients19.zippostalcode, clients19.country, clients19.email, clients19.telephone, clients19.fax, clients19.website, clients19.billingcontact, clients19.billingaddress, clients19.billingcity, clients19.billingstateprovince, clients19.billingzippostalcode, clients19.billingcountry, clients19.billingemail, clients19.billingtelephone, clients19.billingfax, clients19.billingwebsite, clients19.info1, clients19.info2, clients19.info3, clients19.info4, clients19.info5, clients19.info6, clients19.info7, clients19.info8, clients19.info9, clients19.info10, clients19.info11, clients19.info12, clients19.defaultbillingcurrencyid"
"                                  ->  Index Scan using ixcsaclientid on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment20  (cost=0.15..7.29 rows=8 width=8) (never executed)"
"                                        Output: clientsharingassignment20.id, clientsharingassignment20.clientid, clientsharingassignment20.userid"
"                                        Index Cond: (clientsharingassignment20.clientid = clients19.id)"
"        ->  Subquery Scan on "*SELECT* 2"  (cost=768.18..5728.79 rows=23312 width=60) (actual time=12.875..12.875 rows=0 loops=1)"
"              Output: "*SELECT* 2".totalactualhours, "*SELECT* 2".projectid, "*SELECT* 2".totalactualcostinbasecurrency, "*SELECT* 2".totalactualbillinginbasecurrency"
"              Filter: ((hashed SubPlan 7) OR (hashed SubPlan 8) OR (hashed SubPlan 9))"
"              Buffers: shared hit=2603 read=1222"
"              ->  Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_realtime_facts dm_projectlist_realtime_facts_1  (cost=0.00..4494.38 rows=26642 width=60) (actual time=12.873..12.873 rows=0 loops=1)"
"                    Output: dm_projectlist_realtime_facts_1.projectid, NULL::text, NULL::text, NULL::text, NULL::integer, NULL::integer, NULL::date, NULL::date, NULL::integer, NULL::text, NULL::text, NULL::uuid, NULL::text, NULL::text, NULL::numeric(19,4), dm_projectlist_realtime_facts_1.totalactualbillinginbasecurrency, NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), dm_projectlist_realtime_facts_1.totalactualcostinbasecurrency, NULL::numeric(19,4), NULL::numeric(19,4), NULL::interval, dm_projectlist_realtime_facts_1.totalactualhours, NULL::numeric(19,4), NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::uuid, NULL::numeric(19,4)"
"                    Filter: ((NOT dm_projectlist_realtime_facts_1.deleted) AND ((dm_projectlist_realtime_facts_1.statustype <> 5) OR (dm_projectlist_realtime_facts_1.statustype IS NULL)))"
"                    Buffers: shared hit=2603 read=1222"
"              SubPlan 7"
"                ->  Nested Loop  (cost=0.50..4.54 rows=1 width=4) (actual time=0.031..219212.272 rows=15150 loops=1)"
"                      Output: project13.id"
"                      Join Filter: (project13.id = project14.id)"
"                      Rows Removed by Join Filter: 229507350"
"                      Buffers: shared hit=200084106"
"                      ->  Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project13  (cost=0.25..2.26 rows=1 width=4) (actual time=0.014..19.285 rows=15150 loops=1)"
"                            Output: project13.id"
"                            Heap Fetches: 25031"
"                            Buffers: shared hit=13206"
"                      ->  Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project14  (cost=0.25..2.26 rows=1 width=4) (actual time=0.006..10.458 rows=15150 loops=15150)"
"                            Output: project14.id"
"                            Heap Fetches: 379219650"
"                            Buffers: shared hit=200070900"
"              SubPlan 8"
"                ->  Nested Loop Left Join  (cost=0.41..11.78 rows=1 width=4) (never executed)"
"                      Output: project15.id"
"                      Filter: ((project15.projectleaderapproverid = 2) OR (projectsharingassignment16.userid = 2))"
"                      ->  Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project15  (cost=0.25..2.26 rows=1 width=8) (never executed)"
"                            Output: project15.id, project15.guidid, project15.name, project15.slug, project15.code, project15.clientid, project15.projectleaderapproverid, project15.projectstatuslabelid, project15.isprojectleaderapprovalrequired, project15.startdate, project15.enddate, project15.programid, project15.billingtype, project15.fixedbidamount, project15.fixedbidcurrencyid, project15.fixedbidfrequency, project15.timeentrycappercent, project15.costtype, project15.clientbillingallocationmethod, project15.description, project15.percentcomplete, project15.istimeentryallowed, project15.estimatedhours, project15.estimatedexpenses, project15.estimatedexpensescurrencyid, project15.estimatedcost, project15.estimatedcostcurrencyid, project15.timeandexpenseentrytype, project15.estimationmode, project15.billingratefrequencyid, project15.billingratefrequencyduration, project15.defaultbillingcurrencyid, project15.billingcontractid, project15.projecthealthstateid, project15.projecthealthstatedescription, project15.totalestimatedcontractamount, project15.totalestimatedcontractcurrencyid, project15.budgetedhours, project15.budgetedcost, project15.budgetedcostcurrencyid, project15.info1, project15.info2, project15.info3, project15.info4, project15.info5, project15.info6, project15.info7, project15.info8, project15.info9, project15.info10, project15.info11, project15.info12, project15.info13, project15.info14, project15.info15, project15.info16, project15.info17, project15.info18, project15.info19, project15.info20"
"                      ->  Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment16  (cost=0.15..9.35 rows=11 width=8) (never executed)"
"                            Output: projectsharingassignment16.projectid, projectsharingassignment16.userid"
"                            Index Cond: (projectsharingassignment16.projectid = project15.id)"
"                            Heap Fetches: 0"
"              SubPlan 9"
"                ->  Hash Left Join  (cost=10.28..751.68 rows=70 width=4) (never executed)"
"                      Output: project17.id"
"                      Hash Cond: (projectclient18.clientid = clients19.id)"
"                      Filter: ((clients19.clientmanageruserid = 2) OR (clientsharingassignment20.userid = 2))"
"                      ->  Nested Loop Left Join  (cost=0.54..738.06 rows=891 width=8) (never executed)"
"                            Output: project17.id, projectclient18.clientid"
"                            ->  Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project17  (cost=0.25..2.26 rows=1 width=4) (never executed)"
"                                  Output: project17.id"
"                                  Heap Fetches: 0"
"                            ->  Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient18  (cost=0.29..726.89 rows=891 width=8) (never executed)"
"                                  Output: projectclient18.projectid, projectclient18.clientid, projectclient18.effectivedate, projectclient18.enddate"
"                                  Index Cond: (projectclient18.projectid = project17.id)"
"                                  Heap Fetches: 0"
"                      ->  Hash  (cost=9.64..9.64 rows=8 width=12) (never executed)"
"                            Output: clients19.id, clients19.clientmanageruserid, clientsharingassignment20.userid"
"                            ->  Nested Loop Left Join  (cost=0.40..9.64 rows=8 width=12) (never executed)"
"                                  Output: clients19.id, clients19.clientmanageruserid, clientsharingassignment20.userid"
"                                  ->  Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients19  (cost=0.25..2.26 rows=1 width=8) (never executed)"
"                                        Output: clients19.id, clients19.name, clients19.slug, clients19.code, clients19.comments, clients19.clientmanageruserid, clients19.disabled, clients19.address, clients19.city, clients19.stateprovince, clients19.zippostalcode, clients19.country, clients19.email, clients19.telephone, clients19.fax, clients19.website, clients19.billingcontact, clients19.billingaddress, clients19.billingcity, clients19.billingstateprovince, clients19.billingzippostalcode, clients19.billingcountry, clients19.billingemail, clients19.billingtelephone, clients19.billingfax, clients19.billingwebsite, clients19.info1, clients19.info2, clients19.info3, clients19.info4, clients19.info5, clients19.info6, clients19.info7, clients19.info8, clients19.info9, clients19.info10, clients19.info11, clients19.info12, clients19.defaultbillingcurrencyid"
"                                  ->  Index Scan using ixcsaclientid on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment20  (cost=0.15..7.29 rows=8 width=8) (never executed)"
"                                        Output: clientsharingassignment20.id, clientsharingassignment20.clientid, clientsharingassignment20.userid"
"                                        Index Cond: (clientsharingassignment20.clientid = clients19.id)"
"  SubPlan 3"
"    ->  Hash Left Join  (cost=10.44..1879.56 rows=39233 width=4) (actual time=25.456..113.929 rows=15150 loops=1)"
"          Output: project1.id"
"          Hash Cond: (projectclient3.clientid = clients4.id)"
"          Filter: ((alternatives: SubPlan 1 or hashed SubPlan 2) OR (project1.projectleaderapproverid = 2) OR (projectsharingassignment2.userid = 2) OR (clients4.clientmanageruserid = 2) OR (clientsharingassignment5.userid = 2))"
"          Buffers: shared hit=82968"
"          ->  Merge Left Join  (cost=0.70..936.37 rows=9801 width=16) (actual time=0.023..73.071 rows=15150 loops=1)"
"                Output: project1.id, project1.projectleaderapproverid, projectsharingassignment2.userid, projectclient3.clientid"
"                Merge Cond: (project1.id = projectsharingassignment2.projectid)"
"                Buffers: shared hit=66841"
"                ->  Nested Loop Left Join  (cost=0.54..738.06 rows=891 width=12) (actual time=0.017..64.529 rows=15150 loops=1)"
"                      Output: project1.id, project1.projectleaderapproverid, projectclient3.clientid"
"                      Buffers: shared hit=66840"
"                      ->  Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project1  (cost=0.25..2.26 rows=1 width=8) (actual time=0.007..12.302 rows=15150 loops=1)"
"                            Output: project1.id, project1.guidid, project1.name, project1.slug, project1.code, project1.clientid, project1.projectleaderapproverid, project1.projectstatuslabelid, project1.isprojectleaderapprovalrequired, project1.startdate, project1.enddate, project1.programid, project1.billingtype, project1.fixedbidamount, project1.fixedbidcurrencyid, project1.fixedbidfrequency, project1.timeentrycappercent, project1.costtype, project1.clientbillingallocationmethod, project1.description, project1.percentcomplete, project1.istimeentryallowed, project1.estimatedhours, project1.estimatedexpenses, project1.estimatedexpensescurrencyid, project1.estimatedcost, project1.estimatedcostcurrencyid, project1.timeandexpenseentrytype, project1.estimationmode, project1.billingratefrequencyid, project1.billingratefrequencyduration, project1.defaultbillingcurrencyid, project1.billingcontractid, project1.projecthealthstateid, project1.projecthealthstatedescription, project1.totalestimatedcontractamount, project1.totalestimatedcontractcurrencyid, project1.budgetedhours, project1.budgetedcost, project1.budgetedcostcurrencyid, project1.info1, project1.info2, project1.info3, project1.info4, project1.info5, project1.info6, project1.info7, project1.info8, project1.info9, project1.info10, project1.info11, project1.info12, project1.info13, project1.info14, project1.info15, project1.info16, project1.info17, project1.info18, project1.info19, project1.info20"
"                            Buffers: shared hit=13206"
"                      ->  Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient3  (cost=0.29..726.89 rows=891 width=8) (actual time=0.002..0.002 rows=1 loops=15150)"
"                            Output: projectclient3.projectid, projectclient3.clientid, projectclient3.effectivedate, projectclient3.enddate"
"                            Index Cond: (projectclient3.projectid = project1.id)"
"                            Heap Fetches: 25037"
"                            Buffers: shared hit=53634"
"                ->  Materialize  (cost=0.15..50.71 rows=2260 width=8) (actual time=0.005..0.005 rows=0 loops=1)"
"                      Output: projectsharingassignment2.projectid, projectsharingassignment2.userid"
"                      Buffers: shared hit=1"
"                      ->  Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment2  (cost=0.15..45.06 rows=2260 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
"                            Output: projectsharingassignment2.projectid, projectsharingassignment2.userid"
"                            Heap Fetches: 0"
"                            Buffers: shared hit=1"
"          ->  Hash  (cost=9.64..9.64 rows=8 width=12) (actual time=3.564..3.564 rows=1515 loops=1)"
"                Output: clients4.id, clients4.clientmanageruserid, clientsharingassignment5.userid"
"                Buckets: 2048 (originally 1024)  Batches: 1 (originally 1)  Memory Usage: 70kB"
"                Buffers: shared hit=2921"
"                ->  Nested Loop Left Join  (cost=0.40..9.64 rows=8 width=12) (actual time=0.013..3.003 rows=1515 loops=1)"
"                      Output: clients4.id, clients4.clientmanageruserid, clientsharingassignment5.userid"
"                      Buffers: shared hit=2921"
"                      ->  Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients4  (cost=0.25..2.26 rows=1 width=8) (actual time=0.008..1.082 rows=1515 loops=1)"
"                            Output: clients4.id, clients4.name, clients4.slug, clients4.code, clients4.comments, clients4.clientmanageruserid, clients4.disabled, clients4.address, clients4.city, clients4.stateprovince, clients4.zippostalcode, clients4.country, clients4.email, clients4.telephone, clients4.fax, clients4.website, clients4.billingcontact, clients4.billingaddress, clients4.billingcity, clients4.billingstateprovince, clients4.billingzippostalcode, clients4.billingcountry, clients4.billingemail, clients4.billingtelephone, clients4.billingfax, clients4.billingwebsite, clients4.info1, clients4.info2, clients4.info3, clients4.info4, clients4.info5, clients4.info6, clients4.info7, clients4.info8, clients4.info9, clients4.info10, clients4.info11, clients4.info12, clients4.defaultbillingcurrencyid"
"                            Buffers: shared hit=1406"
"                      ->  Index Scan using ixcsaclientid on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment5  (cost=0.15..7.29 rows=8 width=8) (actual time=0.000..0.000 rows=0 loops=1515)"
"                            Output: clientsharingassignment5.id, clientsharingassignment5.clientid, clientsharingassignment5.userid"
"                            Index Cond: (clientsharingassignment5.clientid = clients4.id)"
"                            Buffers: shared hit=1515"
"          SubPlan 1"
"            ->  Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project6  (cost=0.25..2.27 rows=1 width=0) (never executed)"
"                  Index Cond: (project6.id = project1.id)"
"                  Heap Fetches: 0"
"          SubPlan 2"
"            ->  Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project6_1  (cost=0.25..2.26 rows=1 width=4) (actual time=0.010..13.159 rows=15150 loops=1)"
"                  Output: project6_1.id"
"                  Heap Fetches: 25031"
"                  Buffers: shared hit=13206"
"  SubPlan 6"
"    ->  Hash Left Join  (cost=10.44..1879.56 rows=39233 width=4) (actual time=25.029..127.641 rows=15150 loops=1)"
"          Output: project7.id"
"          Hash Cond: (projectclient9.clientid = clients10.id)"
"          Filter: ((alternatives: SubPlan 4 or hashed SubPlan 5) OR (project7.projectleaderapproverid = 2) OR (projectsharingassignment8.userid = 2) OR (clients10.clientmanageruserid = 2) OR (clientsharingassignment11.userid = 2))"
"          Buffers: shared hit=82159 read=809"
"          ->  Merge Left Join  (cost=0.70..936.37 rows=9801 width=16) (actual time=0.070..85.446 rows=15150 loops=1)"
"                Output: project7.id, project7.projectleaderapproverid, projectsharingassignment8.userid, projectclient9.clientid"
"                Merge Cond: (project7.id = projectsharingassignment8.projectid)"
"                Buffers: shared hit=66032 read=809"
"                ->  Nested Loop Left Join  (cost=0.54..738.06 rows=891 width=12) (actual time=0.058..76.445 rows=15150 loops=1)"
"                      Output: project7.id, project7.projectleaderapproverid, projectclient9.clientid"
"                      Buffers: shared hit=66031 read=809"
"                      ->  Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project7  (cost=0.25..2.26 rows=1 width=8) (actual time=0.013..13.425 rows=15150 loops=1)"
"                            Output: project7.id, project7.guidid, project7.name, project7.slug, project7.code, project7.clientid, project7.projectleaderapproverid, project7.projectstatuslabelid, project7.isprojectleaderapprovalrequired, project7.startdate, project7.enddate, project7.programid, project7.billingtype, project7.fixedbidamount, project7.fixedbidcurrencyid, project7.fixedbidfrequency, project7.timeentrycappercent, project7.costtype, project7.clientbillingallocationmethod, project7.description, project7.percentcomplete, project7.istimeentryallowed, project7.estimatedhours, project7.estimatedexpenses, project7.estimatedexpensescurrencyid, project7.estimatedcost, project7.estimatedcostcurrencyid, project7.timeandexpenseentrytype, project7.estimationmode, project7.billingratefrequencyid, project7.billingratefrequencyduration, project7.defaultbillingcurrencyid, project7.billingcontractid, project7.projecthealthstateid, project7.projecthealthstatedescription, project7.totalestimatedcontractamount, project7.totalestimatedcontractcurrencyid, project7.budgetedhours, project7.budgetedcost, project7.budgetedcostcurrencyid, project7.info1, project7.info2, project7.info3, project7.info4, project7.info5, project7.info6, project7.info7, project7.info8, project7.info9, project7.info10, project7.info11, project7.info12, project7.info13, project7.info14, project7.info15, project7.info16, project7.info17, project7.info18, project7.info19, project7.info20"
"                            Buffers: shared hit=13206"
"                      ->  Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient9  (cost=0.29..726.89 rows=891 width=8) (actual time=0.002..0.003 rows=1 loops=15150)"
"                            Output: projectclient9.projectid, projectclient9.clientid, projectclient9.effectivedate, projectclient9.enddate"
"                            Index Cond: (projectclient9.projectid = project7.id)"
"                            Heap Fetches: 25037"
"                            Buffers: shared hit=52825 read=809"
"                ->  Materialize  (cost=0.15..50.71 rows=2260 width=8) (actual time=0.008..0.008 rows=0 loops=1)"
"                      Output: projectsharingassignment8.projectid, projectsharingassignment8.userid"
"                      Buffers: shared hit=1"
"                      ->  Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment8  (cost=0.15..45.06 rows=2260 width=8) (actual time=0.003..0.003 rows=0 loops=1)"
"                            Output: projectsharingassignment8.projectid, projectsharingassignment8.userid"
"                            Heap Fetches: 0"
"                            Buffers: shared hit=1"
"          ->  Hash  (cost=9.64..9.64 rows=8 width=12) (actual time=5.270..5.270 rows=1515 loops=1)"
"                Output: clients10.id, clients10.clientmanageruserid, clientsharingassignment11.userid"
"                Buckets: 2048 (originally 1024)  Batches: 1 (originally 1)  Memory Usage: 70kB"
"                Buffers: shared hit=2921"
"                ->  Nested Loop Left Join  (cost=0.40..9.64 rows=8 width=12) (actual time=0.022..4.457 rows=1515 loops=1)"
"                      Output: clients10.id, clients10.clientmanageruserid, clientsharingassignment11.userid"
"                      Buffers: shared hit=2921"
"                      ->  Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients10  (cost=0.25..2.26 rows=1 width=8) (actual time=0.014..1.562 rows=1515 loops=1)"
"                            Output: clients10.id, clients10.name, clients10.slug, clients10.code, clients10.comments, clients10.clientmanageruserid, clients10.disabled, clients10.address, clients10.city, clients10.stateprovince, clients10.zippostalcode, clients10.country, clients10.email, clients10.telephone, clients10.fax, clients10.website, clients10.billingcontact, clients10.billingaddress, clients10.billingcity, clients10.billingstateprovince, clients10.billingzippostalcode, clients10.billingcountry, clients10.billingemail, clients10.billingtelephone, clients10.billingfax, clients10.billingwebsite, clients10.info1, clients10.info2, clients10.info3, clients10.info4, clients10.info5, clients10.info6, clients10.info7, clients10.info8, clients10.info9, clients10.info10, clients10.info11, clients10.info12, clients10.defaultbillingcurrencyid"
"                            Buffers: shared hit=1406"
"                      ->  Index Scan using ixcsaclientid on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment11  (cost=0.15..7.29 rows=8 width=8) (actual time=0.001..0.001 rows=0 loops=1515)"
"                            Output: clientsharingassignment11.id, clientsharingassignment11.clientid, clientsharingassignment11.userid"
"                            Index Cond: (clientsharingassignment11.clientid = clients10.id)"
"                            Buffers: shared hit=1515"
"          SubPlan 4"
"            ->  Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project12  (cost=0.25..2.27 rows=1 width=0) (never executed)"
"                  Index Cond: (project12.id = project7.id)"
"                  Heap Fetches: 0"
"          SubPlan 5"
"            ->  Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project12_1  (cost=0.25..2.26 rows=1 width=4) (actual time=0.010..11.768 rows=15150 loops=1)"
"                  Output: project12_1.id"
"                  Heap Fetches: 25031"
"                  Buffers: shared hit=13206"
"Planning time: 3.785 ms"
"Execution time: 219620.252 ms"