"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"