explain.depesz.com

PostgreSQL's explain analyze made readable

Result: y6D6

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 313.723 ↑ 1.0 1 1

Limit (cost=293,454.87..293,455.26 rows=1 width=0) (actual time=313.722..313.723 rows=1 loops=1)

  • Output: ($4), ($10), ($16), ($22), ($28), ($34), ($40), ($46)
  • Buffers: shared hit=158213 read=1397
2.          

Initplan (for Limit)

3. 3.660 96.724 ↑ 1.0 1 1

Aggregate (cost=41,961.65..41,961.66 rows=1 width=0) (actual time=96.724..96.724 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=49768 read=1317
4. 6.143 93.064 ↑ 1.5 15,150 1

Append (cost=15,593.73..41,903.36 rows=23,313 width=0) (actual time=46.738..93.064 rows=15,150 loops=1)

  • Buffers: shared hit=49768 read=1317
5. 15.598 75.240 ↓ 15,150.0 15,150 1

Subquery Scan on *SELECT* 1_1 (cost=15,593.73..21,349.60 rows=1 width=0) (actual time=46.738..75.240 rows=15,150 loops=1)

  • Filter: ((hashed SubPlan 1) OR (hashed SubPlan 2) OR (hashed SubPlan 3))
  • Buffers: shared hit=47165 read=95
6. 9.876 28.667 ↓ 15,150.0 15,150 1

Merge Anti Join (cost=0.57..5,756.43 rows=1 width=4) (actual time=9.477..28.667 rows=15,150 loops=1)

  • Output: dm_projectlist_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), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::interval, NULL::interval, NULL::numeric(19,4), NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::uuid, NULL::numeric(19,4)
  • Merge Cond: (dm_projectlist_facts_1.projectid = dm_projectlist_realtime_facts_2.projectid)
  • Buffers: shared hit=20753 read=95
7. 9.334 9.334 ↓ 1.8 15,150 1

Index Scan using dm_projectlist_facts_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_facts dm_projectlist_facts_1 (cost=0.29..836.02 rows=8,400 width=4) (actual time=0.015..9.334 rows=15,150 loops=1)

  • Output: dm_projectlist_facts_1.projectid, dm_projectlist_facts_1.projectguidid, dm_projectlist_facts_1.name, dm_projectlist_facts_1.slug, dm_projectlist_facts_1.code, dm_projectlist_facts_1.statustype, dm_projectlist_facts_1.invoicingtype, dm_projectlist_facts_1.estimationmode, dm_projectlist_facts_1.startdate, dm_projectlist_facts_1.enddate, dm_projectlist_facts_1.projectleaderid, dm_projectlist_facts_1.projectleaderdisplayname, dm_projectlist_facts_1.projectleaderslug, dm_projectlist_facts_1.programid, dm_projectlist_facts_1.programname, dm_projectlist_facts_1.programslug, dm_projectlist_facts_1.totalestimatedbillinginbasecurrency, dm_projectlist_facts_1.totalactualbillinginbasecurrency, dm_projectlist_facts_1.totalestimatedcostinbasecurrency, dm_projectlist_facts_1.totalestimatedcostcapexinbasecurrency, dm_projectlist_facts_1.totalestimatedcostopexinbasecurrency, dm_projectlist_facts_1.totalactualcostinbasecurrency, dm_projectlist_facts_1.totalactualcostcapexinbasecurrency, dm_projectlist_facts_1.totalactualcostopexinbasecurrency, dm_projectlist_facts_1.totalestimatedhours, dm_projectlist_facts_1.totalactualhours, dm_projectlist_facts_1.hoursfte, dm_projectlist_facts_1.estimatedresources, dm_projectlist_facts_1.assignedresources, dm_projectlist_facts_1.placeholderresources, dm_projectlist_facts_1.totalactualbillingamountinbasecurrency
  • Filter: ((dm_projectlist_facts_1.statustype <> 5) OR (dm_projectlist_facts_1.statustype IS NULL))
  • Buffers: shared hit=9169 read=95
8. 9.457 9.457 ↓ 0.0 0 1

Index Only Scan using dm_projectlist_realtime_facts_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_realtime_facts dm_projectlist_realtime_facts_2 (cost=0.29..4,681.54 rows=53,550 width=4) (actual time=9.457..9.457 rows=0 loops=1)

  • Output: dm_projectlist_realtime_facts_2.projectid
  • Heap Fetches: 12484
  • Buffers: shared hit=11584
9.          

SubPlan (for Subquery Scan)

10. 12.170 30.975 ↑ 1.0 15,150 1

Merge Semi Join (cost=0.57..4,416.32 rows=15,150 width=4) (actual time=0.031..30.975 rows=15,150 loops=1)

  • Output: project1.id
  • Merge Cond: (project1.id = project2.id)
  • Buffers: shared hit=26412
11. 10.687 10.687 ↑ 1.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project1 (cost=0.29..2,094.53 rows=15,150 width=4) (actual time=0.019..10.687 rows=15,150 loops=1)

  • Output: project1.id
  • Heap Fetches: 25031
  • Buffers: shared hit=13206
12. 8.118 8.118 ↑ 1.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project2 (cost=0.29..2,094.53 rows=15,150 width=4) (actual time=0.008..8.118 rows=15,150 loops=1)

  • Output: project2.id
  • Heap Fetches: 25030
  • Buffers: shared hit=13206
13. 0.000 0.000 ↓ 0.0 0

Merge Left Join (cost=0.44..2,217.02 rows=76 width=4) (never executed)

  • Output: project3.id
  • Merge Cond: (project3.id = projectsharingassignment4.projectid)
  • Filter: ((project3.projectleaderapproverid = 2) OR (projectsharingassignment4.userid = 2))
14. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project3 (cost=0.29..2,094.53 rows=15,150 width=8) (never executed)

  • Output: project3.id, project3.guidid, project3.name, project3.slug, project3.code, project3.clientid, project3.projectleaderapproverid, project3.projectstatuslabelid, project3.isprojectleaderapprovalrequired, project3.startdate, project3.enddate, project3.programid, project3.billingtype, project3.fixedbidamount, project3.fixedbidcurrencyid, project3.fixedbidfrequency, project3.timeentrycappercent, project3.costtype, project3.clientbillingallocationmethod, project3.description, project3.percentcomplete, project3.istimeentryallowed, project3.estimatedhours, project3.estimatedexpenses, project3.estimatedexpensescurrencyid, project3.estimatedcost, project3.estimatedcostcurrencyid, project3.timeandexpenseentrytype, project3.estimationmode, project3.billingratefrequencyid, project3.billingratefrequencyduration, project3.defaultbillingcurrencyid, project3.billingcontractid, project3.projecthealthstateid, project3.projecthealthstatedescription, project3.totalestimatedcontractamount, project3.totalestimatedcontractcurrencyid, project3.budgetedhours, project3.budgetedcost, project3.budgetedcostcurrencyid, project3.info1, project3.info2, project3.info3, project3.info4, project3.info5, project3.info6, project3.info7, project3.info8, project3.info9, project3.info10, project3.info11, project3.info12, project3.info13, project3.info14, project3.info15, project3.info16, project3.info17, project3.info18, project3.info19, project3.info20
15. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment4 (cost=0.15..45.06 rows=2,260 width=8) (never executed)

  • Output: projectsharingassignment4.projectid, projectsharingassignment4.userid
  • Heap Fetches: 0
16. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,132.61..8,886.87 rows=13,953 width=4) (never executed)

  • Output: project5.id
  • Hash Cond: (projectclient6.clientid = clients7.id)
  • Filter: ((clients7.clientmanageruserid = 2) OR (clientsharingassignment8.userid = 2))
17. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=2,122.88..8,101.98 rows=178,194 width=8) (never executed)

  • Output: project5.id, projectclient6.clientid
  • Hash Cond: (projectclient6.projectid = project5.id)
18. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient6 (cost=0.00..3,528.94 rows=178,194 width=8) (never executed)

  • Output: projectclient6.id, projectclient6.projectid, projectclient6.clientid, projectclient6.costallocationpercentage, projectclient6.effectivedate, projectclient6.enddate
19. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,933.50..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project5.id
20. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".project project5 (cost=0.00..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project5.id
21. 0.000 0.000 ↓ 0.0 0

Hash (cost=9.64..9.64 rows=8 width=12) (never executed)

  • Output: clients7.id, clients7.clientmanageruserid, clientsharingassignment8.userid
22. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.40..9.64 rows=8 width=12) (never executed)

  • Output: clients7.id, clients7.clientmanageruserid, clientsharingassignment8.userid
23. 0.000 0.000 ↓ 0.0 0

Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients7 (cost=0.25..2.26 rows=1 width=8) (never executed)

  • Output: clients7.id, clients7.name, clients7.slug, clients7.code, clients7.comments, clients7.clientmanageruserid, clients7.disabled, clients7.address, clients7.city, clients7.stateprovince, clients7.zippostalcode, clients7.country, clients7.email, clients7.telephone, clients7.fax, clients7.website, clients7.billingcontact, clients7.billingaddress, clients7.billingcity, clients7.billingstateprovince, clients7.billingzippostalcode, clients7.billingcountry, clients7.billingemail, clients7.billingtelephone, clients7.billingfax, clients7.billingwebsite, clients7.info1, clients7.info2, clients7.info3, clients7.info4, clients7.info5, clients7.info6, clients7.info7, clients7.info8, clients7.info9, clients7.info10, clients7.info11, clients7.info12, clients7.defaultbillingcurrencyid
24. 0.000 0.000 ↓ 0.0 0

Index Scan using ixcsaclientid on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment8 (cost=0.15..7.29 rows=8 width=8) (never executed)

  • Output: clientsharingassignment8.id, clientsharingassignment8.clientid, clientsharingassignment8.userid
  • Index Cond: (clientsharingassignment8.clientid = clients7.id)
25. 0.000 11.681 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_1 (cost=15,593.15..20,553.76 rows=23,312 width=0) (actual time=11.681..11.681 rows=0 loops=1)

  • Filter: ((hashed SubPlan 1) OR (hashed SubPlan 2) OR (hashed SubPlan 3))
  • Buffers: shared hit=2603 read=1222
26. 11.679 11.679 ↓ 0.0 0 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_realtime_facts dm_projectlist_realtime_facts_3 (cost=0.00..4,494.38 rows=26,642 width=4) (actual time=11.679..11.679 rows=0 loops=1)

  • Output: dm_projectlist_realtime_facts_3.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), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::interval, NULL::interval, NULL::numeric(19,4), NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::uuid, NULL::numeric(19,4)
  • Filter: ((NOT dm_projectlist_realtime_facts_3.deleted) AND ((dm_projectlist_realtime_facts_3.statustype <> 5) OR (dm_projectlist_realtime_facts_3.statustype IS NULL)))
  • Buffers: shared hit=2603 read=1222
27.          

SubPlan (for Subquery Scan)

28. 12.170 30.975 ↑ 1.0 15,150 1

Merge Semi Join (cost=0.57..4,416.32 rows=15,150 width=4) (actual time=0.031..30.975 rows=15,150 loops=1)

  • Output: project1.id
  • Merge Cond: (project1.id = project2.id)
  • Buffers: shared hit=26412
29. 10.687 10.687 ↑ 1.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project1 (cost=0.29..2,094.53 rows=15,150 width=4) (actual time=0.019..10.687 rows=15,150 loops=1)

  • Output: project1.id
  • Heap Fetches: 25031
  • Buffers: shared hit=13206
30. 8.118 8.118 ↑ 1.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project2 (cost=0.29..2,094.53 rows=15,150 width=4) (actual time=0.008..8.118 rows=15,150 loops=1)

  • Output: project2.id
  • Heap Fetches: 25030
  • Buffers: shared hit=13206
31. 0.000 0.000 ↓ 0.0 0

Merge Left Join (cost=0.44..2,217.02 rows=76 width=4) (never executed)

  • Output: project3.id
  • Merge Cond: (project3.id = projectsharingassignment4.projectid)
  • Filter: ((project3.projectleaderapproverid = 2) OR (projectsharingassignment4.userid = 2))
32. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project3 (cost=0.29..2,094.53 rows=15,150 width=8) (never executed)

  • Output: project3.id, project3.guidid, project3.name, project3.slug, project3.code, project3.clientid, project3.projectleaderapproverid, project3.projectstatuslabelid, project3.isprojectleaderapprovalrequired, project3.startdate, project3.enddate, project3.programid, project3.billingtype, project3.fixedbidamount, project3.fixedbidcurrencyid, project3.fixedbidfrequency, project3.timeentrycappercent, project3.costtype, project3.clientbillingallocationmethod, project3.description, project3.percentcomplete, project3.istimeentryallowed, project3.estimatedhours, project3.estimatedexpenses, project3.estimatedexpensescurrencyid, project3.estimatedcost, project3.estimatedcostcurrencyid, project3.timeandexpenseentrytype, project3.estimationmode, project3.billingratefrequencyid, project3.billingratefrequencyduration, project3.defaultbillingcurrencyid, project3.billingcontractid, project3.projecthealthstateid, project3.projecthealthstatedescription, project3.totalestimatedcontractamount, project3.totalestimatedcontractcurrencyid, project3.budgetedhours, project3.budgetedcost, project3.budgetedcostcurrencyid, project3.info1, project3.info2, project3.info3, project3.info4, project3.info5, project3.info6, project3.info7, project3.info8, project3.info9, project3.info10, project3.info11, project3.info12, project3.info13, project3.info14, project3.info15, project3.info16, project3.info17, project3.info18, project3.info19, project3.info20
33. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment4 (cost=0.15..45.06 rows=2,260 width=8) (never executed)

  • Output: projectsharingassignment4.projectid, projectsharingassignment4.userid
  • Heap Fetches: 0
34. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,132.61..8,886.87 rows=13,953 width=4) (never executed)

  • Output: project5.id
  • Hash Cond: (projectclient6.clientid = clients7.id)
  • Filter: ((clients7.clientmanageruserid = 2) OR (clientsharingassignment8.userid = 2))
35. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=2,122.88..8,101.98 rows=178,194 width=8) (never executed)

  • Output: project5.id, projectclient6.clientid
  • Hash Cond: (projectclient6.projectid = project5.id)
36. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient6 (cost=0.00..3,528.94 rows=178,194 width=8) (never executed)

  • Output: projectclient6.id, projectclient6.projectid, projectclient6.clientid, projectclient6.costallocationpercentage, projectclient6.effectivedate, projectclient6.enddate
37. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,933.50..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project5.id
38. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".project project5 (cost=0.00..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project5.id
39. 0.000 0.000 ↓ 0.0 0

Hash (cost=9.64..9.64 rows=8 width=12) (never executed)

  • Output: clients7.id, clients7.clientmanageruserid, clientsharingassignment8.userid
40. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.40..9.64 rows=8 width=12) (never executed)

  • Output: clients7.id, clients7.clientmanageruserid, clientsharingassignment8.userid
41. 0.000 0.000 ↓ 0.0 0

Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients7 (cost=0.25..2.26 rows=1 width=8) (never executed)

  • Output: clients7.id, clients7.name, clients7.slug, clients7.code, clients7.comments, clients7.clientmanageruserid, clients7.disabled, clients7.address, clients7.city, clients7.stateprovince, clients7.zippostalcode, clients7.country, clients7.email, clients7.telephone, clients7.fax, clients7.website, clients7.billingcontact, clients7.billingaddress, clients7.billingcity, clients7.billingstateprovince, clients7.billingzippostalcode, clients7.billingcountry, clients7.billingemail, clients7.billingtelephone, clients7.billingfax, clients7.billingwebsite, clients7.info1, clients7.info2, clients7.info3, clients7.info4, clients7.info5, clients7.info6, clients7.info7, clients7.info8, clients7.info9, clients7.info10, clients7.info11, clients7.info12, clients7.defaultbillingcurrencyid
42. 0.000 0.000 ↓ 0.0 0

Index Scan using ixcsaclientid on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment8 (cost=0.15..7.29 rows=8 width=8) (never executed)

  • Output: clientsharingassignment8.id, clientsharingassignment8.clientid, clientsharingassignment8.userid
  • Index Cond: (clientsharingassignment8.clientid = clients7.id)
43. 0.003 5.846 ↑ 1.0 1 1

Aggregate (cost=35,946.65..35,946.66 rows=1 width=0) (actual time=5.846..5.846 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=3825 read=2
44. 0.002 5.843 ↓ 0.0 0 1

Append (cost=15,593.73..35,946.35 rows=117 width=0) (actual time=5.843..5.843 rows=0 loops=1)

  • Buffers: shared hit=3825 read=2
45. 0.000 0.017 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1_2 (cost=15,593.73..15,722.63 rows=1 width=0) (actual time=0.017..0.017 rows=0 loops=1)

  • Filter: ((hashed SubPlan 5) OR (hashed SubPlan 6) OR (hashed SubPlan 7))
  • Buffers: shared read=2
46. 0.002 0.017 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.57..129.46 rows=1 width=4) (actual time=0.017..0.017 rows=0 loops=1)

  • Output: dm_projectlist_facts_2.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), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::interval, NULL::interval, NULL::numeric(19,4), NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::uuid, NULL::numeric(19,4)
  • Buffers: shared read=2
47. 0.015 0.015 ↓ 0.0 0 1

Index Scan using ixdprjfprojectleaderid on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_facts dm_projectlist_facts_2 (cost=0.29..43.12 rows=42 width=4) (actual time=0.015..0.015 rows=0 loops=1)

  • Output: dm_projectlist_facts_2.projectid, dm_projectlist_facts_2.projectguidid, dm_projectlist_facts_2.name, dm_projectlist_facts_2.slug, dm_projectlist_facts_2.code, dm_projectlist_facts_2.statustype, dm_projectlist_facts_2.invoicingtype, dm_projectlist_facts_2.estimationmode, dm_projectlist_facts_2.startdate, dm_projectlist_facts_2.enddate, dm_projectlist_facts_2.projectleaderid, dm_projectlist_facts_2.projectleaderdisplayname, dm_projectlist_facts_2.projectleaderslug, dm_projectlist_facts_2.programid, dm_projectlist_facts_2.programname, dm_projectlist_facts_2.programslug, dm_projectlist_facts_2.totalestimatedbillinginbasecurrency, dm_projectlist_facts_2.totalactualbillinginbasecurrency, dm_projectlist_facts_2.totalestimatedcostinbasecurrency, dm_projectlist_facts_2.totalestimatedcostcapexinbasecurrency, dm_projectlist_facts_2.totalestimatedcostopexinbasecurrency, dm_projectlist_facts_2.totalactualcostinbasecurrency, dm_projectlist_facts_2.totalactualcostcapexinbasecurrency, dm_projectlist_facts_2.totalactualcostopexinbasecurrency, dm_projectlist_facts_2.totalestimatedhours, dm_projectlist_facts_2.totalactualhours, dm_projectlist_facts_2.hoursfte, dm_projectlist_facts_2.estimatedresources, dm_projectlist_facts_2.assignedresources, dm_projectlist_facts_2.placeholderresources, dm_projectlist_facts_2.totalactualbillingamountinbasecurrency
  • Index Cond: (dm_projectlist_facts_2.projectleaderid = 2)
  • Filter: ((dm_projectlist_facts_2.statustype <> 5) OR (dm_projectlist_facts_2.statustype IS NULL))
  • Buffers: shared read=2
48. 0.000 0.000 ↓ 0.0 0

Index Only Scan using dm_projectlist_realtime_facts_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_realtime_facts dm_projectlist_realtime_facts_4 (cost=0.29..2.05 rows=1 width=4) (never executed)

  • Output: dm_projectlist_realtime_facts_4.projectid
  • Index Cond: (dm_projectlist_realtime_facts_4.projectid = dm_projectlist_facts_2.projectid)
  • Heap Fetches: 0
49.          

SubPlan (for Subquery Scan)

50. 0.000 0.000 ↓ 0.0 0

Merge Semi Join (cost=0.57..4,416.32 rows=15,150 width=4) (never executed)

  • Output: project10.id
  • Merge Cond: (project10.id = project11.id)
51. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project10 (cost=0.29..2,094.53 rows=15,150 width=4) (never executed)

  • Output: project10.id
  • Heap Fetches: 0
52. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project11 (cost=0.29..2,094.53 rows=15,150 width=4) (never executed)

  • Output: project11.id
  • Heap Fetches: 0
53. 0.000 0.000 ↓ 0.0 0

Merge Left Join (cost=0.44..2,217.02 rows=76 width=4) (never executed)

  • Output: project12.id
  • Merge Cond: (project12.id = projectsharingassignment13.projectid)
  • Filter: ((project12.projectleaderapproverid = 2) OR (projectsharingassignment13.userid = 2))
54. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project12 (cost=0.29..2,094.53 rows=15,150 width=8) (never executed)

  • Output: project12.id, project12.guidid, project12.name, project12.slug, project12.code, project12.clientid, project12.projectleaderapproverid, project12.projectstatuslabelid, project12.isprojectleaderapprovalrequired, project12.startdate, project12.enddate, project12.programid, project12.billingtype, project12.fixedbidamount, project12.fixedbidcurrencyid, project12.fixedbidfrequency, project12.timeentrycappercent, project12.costtype, project12.clientbillingallocationmethod, project12.description, project12.percentcomplete, project12.istimeentryallowed, project12.estimatedhours, project12.estimatedexpenses, project12.estimatedexpensescurrencyid, project12.estimatedcost, project12.estimatedcostcurrencyid, project12.timeandexpenseentrytype, project12.estimationmode, project12.billingratefrequencyid, project12.billingratefrequencyduration, project12.defaultbillingcurrencyid, project12.billingcontractid, project12.projecthealthstateid, project12.projecthealthstatedescription, project12.totalestimatedcontractamount, project12.totalestimatedcontractcurrencyid, project12.budgetedhours, project12.budgetedcost, project12.budgetedcostcurrencyid, project12.info1, project12.info2, project12.info3, project12.info4, project12.info5, project12.info6, project12.info7, project12.info8, project12.info9, project12.info10, project12.info11, project12.info12, project12.info13, project12.info14, project12.info15, project12.info16, project12.info17, project12.info18, project12.info19, project12.info20
55. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment13 (cost=0.15..45.06 rows=2,260 width=8) (never executed)

  • Output: projectsharingassignment13.projectid, projectsharingassignment13.userid
  • Heap Fetches: 0
56. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,132.61..8,886.87 rows=13,953 width=4) (never executed)

  • Output: project14.id
  • Hash Cond: (projectclient15.clientid = clients16.id)
  • Filter: ((clients16.clientmanageruserid = 2) OR (clientsharingassignment17.userid = 2))
57. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=2,122.88..8,101.98 rows=178,194 width=8) (never executed)

  • Output: project14.id, projectclient15.clientid
  • Hash Cond: (projectclient15.projectid = project14.id)
58. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient15 (cost=0.00..3,528.94 rows=178,194 width=8) (never executed)

  • Output: projectclient15.id, projectclient15.projectid, projectclient15.clientid, projectclient15.costallocationpercentage, projectclient15.effectivedate, projectclient15.enddate
59. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,933.50..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project14.id
60. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".project project14 (cost=0.00..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project14.id
61. 0.000 0.000 ↓ 0.0 0

Hash (cost=9.64..9.64 rows=8 width=12) (never executed)

  • Output: clients16.id, clients16.clientmanageruserid, clientsharingassignment17.userid
62. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.40..9.64 rows=8 width=12) (never executed)

  • Output: clients16.id, clients16.clientmanageruserid, clientsharingassignment17.userid
63. 0.000 0.000 ↓ 0.0 0

Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients16 (cost=0.25..2.26 rows=1 width=8) (never executed)

  • Output: clients16.id, clients16.name, clients16.slug, clients16.code, clients16.comments, clients16.clientmanageruserid, clients16.disabled, clients16.address, clients16.city, clients16.stateprovince, clients16.zippostalcode, clients16.country, clients16.email, clients16.telephone, clients16.fax, clients16.website, clients16.billingcontact, clients16.billingaddress, clients16.billingcity, clients16.billingstateprovince, clients16.billingzippostalcode, clients16.billingcountry, clients16.billingemail, clients16.billingtelephone, clients16.billingfax, clients16.billingwebsite, clients16.info1, clients16.info2, clients16.info3, clients16.info4, clients16.info5, clients16.info6, clients16.info7, clients16.info8, clients16.info9, clients16.info10, clients16.info11, clients16.info12, clients16.defaultbillingcurrencyid
64. 0.000 0.000 ↓ 0.0 0

Index Scan using ixcsaclientid on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment17 (cost=0.15..7.29 rows=8 width=8) (never executed)

  • Output: clientsharingassignment17.id, clientsharingassignment17.clientid, clientsharingassignment17.userid
  • Index Cond: (clientsharingassignment17.clientid = clients16.id)
65. 0.000 5.824 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_2 (cost=15,593.15..20,223.73 rows=116 width=0) (actual time=5.824..5.824 rows=0 loops=1)

  • Filter: ((hashed SubPlan 5) OR (hashed SubPlan 6) OR (hashed SubPlan 7))
  • Buffers: shared hit=3825
66. 5.824 5.824 ↓ 0.0 0 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_realtime_facts dm_projectlist_realtime_facts_5 (cost=0.00..4,628.25 rows=133 width=4) (actual time=5.824..5.824 rows=0 loops=1)

  • Output: dm_projectlist_realtime_facts_5.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), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::interval, NULL::interval, NULL::numeric(19,4), NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::uuid, NULL::numeric(19,4)
  • Filter: ((NOT dm_projectlist_realtime_facts_5.deleted) AND ((dm_projectlist_realtime_facts_5.statustype <> 5) OR (dm_projectlist_realtime_facts_5.statustype IS NULL)) AND (dm_projectlist_realtime_facts_5.projectleaderid = 2))
  • Buffers: shared hit=3825
67.          

SubPlan (for Subquery Scan)

68. 0.000 0.000 ↓ 0.0 0

Merge Semi Join (cost=0.57..4,416.32 rows=15,150 width=4) (never executed)

  • Output: project10.id
  • Merge Cond: (project10.id = project11.id)
69. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project10 (cost=0.29..2,094.53 rows=15,150 width=4) (never executed)

  • Output: project10.id
  • Heap Fetches: 0
70. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project11 (cost=0.29..2,094.53 rows=15,150 width=4) (never executed)

  • Output: project11.id
  • Heap Fetches: 0
71. 0.000 0.000 ↓ 0.0 0

Merge Left Join (cost=0.44..2,217.02 rows=76 width=4) (never executed)

  • Output: project12.id
  • Merge Cond: (project12.id = projectsharingassignment13.projectid)
  • Filter: ((project12.projectleaderapproverid = 2) OR (projectsharingassignment13.userid = 2))
72. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project12 (cost=0.29..2,094.53 rows=15,150 width=8) (never executed)

  • Output: project12.id, project12.guidid, project12.name, project12.slug, project12.code, project12.clientid, project12.projectleaderapproverid, project12.projectstatuslabelid, project12.isprojectleaderapprovalrequired, project12.startdate, project12.enddate, project12.programid, project12.billingtype, project12.fixedbidamount, project12.fixedbidcurrencyid, project12.fixedbidfrequency, project12.timeentrycappercent, project12.costtype, project12.clientbillingallocationmethod, project12.description, project12.percentcomplete, project12.istimeentryallowed, project12.estimatedhours, project12.estimatedexpenses, project12.estimatedexpensescurrencyid, project12.estimatedcost, project12.estimatedcostcurrencyid, project12.timeandexpenseentrytype, project12.estimationmode, project12.billingratefrequencyid, project12.billingratefrequencyduration, project12.defaultbillingcurrencyid, project12.billingcontractid, project12.projecthealthstateid, project12.projecthealthstatedescription, project12.totalestimatedcontractamount, project12.totalestimatedcontractcurrencyid, project12.budgetedhours, project12.budgetedcost, project12.budgetedcostcurrencyid, project12.info1, project12.info2, project12.info3, project12.info4, project12.info5, project12.info6, project12.info7, project12.info8, project12.info9, project12.info10, project12.info11, project12.info12, project12.info13, project12.info14, project12.info15, project12.info16, project12.info17, project12.info18, project12.info19, project12.info20
73. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment13 (cost=0.15..45.06 rows=2,260 width=8) (never executed)

  • Output: projectsharingassignment13.projectid, projectsharingassignment13.userid
  • Heap Fetches: 0
74. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,132.61..8,886.87 rows=13,953 width=4) (never executed)

  • Output: project14.id
  • Hash Cond: (projectclient15.clientid = clients16.id)
  • Filter: ((clients16.clientmanageruserid = 2) OR (clientsharingassignment17.userid = 2))
75. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=2,122.88..8,101.98 rows=178,194 width=8) (never executed)

  • Output: project14.id, projectclient15.clientid
  • Hash Cond: (projectclient15.projectid = project14.id)
76. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient15 (cost=0.00..3,528.94 rows=178,194 width=8) (never executed)

  • Output: projectclient15.id, projectclient15.projectid, projectclient15.clientid, projectclient15.costallocationpercentage, projectclient15.effectivedate, projectclient15.enddate
77. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,933.50..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project14.id
78. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".project project14 (cost=0.00..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project14.id
79. 0.000 0.000 ↓ 0.0 0

Hash (cost=9.64..9.64 rows=8 width=12) (never executed)

  • Output: clients16.id, clients16.clientmanageruserid, clientsharingassignment17.userid
80. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.40..9.64 rows=8 width=12) (never executed)

  • Output: clients16.id, clients16.clientmanageruserid, clientsharingassignment17.userid
81. 0.000 0.000 ↓ 0.0 0

Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients16 (cost=0.25..2.26 rows=1 width=8) (never executed)

  • Output: clients16.id, clients16.name, clients16.slug, clients16.code, clients16.comments, clients16.clientmanageruserid, clients16.disabled, clients16.address, clients16.city, clients16.stateprovince, clients16.zippostalcode, clients16.country, clients16.email, clients16.telephone, clients16.fax, clients16.website, clients16.billingcontact, clients16.billingaddress, clients16.billingcity, clients16.billingstateprovince, clients16.billingzippostalcode, clients16.billingcountry, clients16.billingemail, clients16.billingtelephone, clients16.billingfax, clients16.billingwebsite, clients16.info1, clients16.info2, clients16.info3, clients16.info4, clients16.info5, clients16.info6, clients16.info7, clients16.info8, clients16.info9, clients16.info10, clients16.info11, clients16.info12, clients16.defaultbillingcurrencyid
82. 0.000 0.000 ↓ 0.0 0

Index Scan using ixcsaclientid on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment17 (cost=0.15..7.29 rows=8 width=8) (never executed)

  • Output: clientsharingassignment17.id, clientsharingassignment17.clientid, clientsharingassignment17.userid
  • Index Cond: (clientsharingassignment17.clientid = clients16.id)
83. 0.003 5.678 ↑ 1.0 1 1

Aggregate (cost=35,946.65..35,946.66 rows=1 width=0) (actual time=5.678..5.678 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=3825 read=2
84. 0.001 5.675 ↓ 0.0 0 1

Append (cost=15,593.73..35,946.35 rows=117 width=0) (actual time=5.675..5.675 rows=0 loops=1)

  • Buffers: shared hit=3825 read=2
85. 0.001 0.017 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1_3 (cost=15,593.73..15,722.63 rows=1 width=0) (actual time=0.017..0.017 rows=0 loops=1)

  • Filter: ((hashed SubPlan 9) OR (hashed SubPlan 10) OR (hashed SubPlan 11))
  • Buffers: shared read=2
86. 0.001 0.016 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.57..129.46 rows=1 width=4) (actual time=0.016..0.016 rows=0 loops=1)

  • Output: dm_projectlist_facts_3.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), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::interval, NULL::interval, NULL::numeric(19,4), NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::uuid, NULL::numeric(19,4)
  • Buffers: shared read=2
87. 0.015 0.015 ↓ 0.0 0 1

Index Scan using ixdprjfstatustype on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_facts dm_projectlist_facts_3 (cost=0.29..43.12 rows=42 width=4) (actual time=0.015..0.015 rows=0 loops=1)

  • Output: dm_projectlist_facts_3.projectid, dm_projectlist_facts_3.projectguidid, dm_projectlist_facts_3.name, dm_projectlist_facts_3.slug, dm_projectlist_facts_3.code, dm_projectlist_facts_3.statustype, dm_projectlist_facts_3.invoicingtype, dm_projectlist_facts_3.estimationmode, dm_projectlist_facts_3.startdate, dm_projectlist_facts_3.enddate, dm_projectlist_facts_3.projectleaderid, dm_projectlist_facts_3.projectleaderdisplayname, dm_projectlist_facts_3.projectleaderslug, dm_projectlist_facts_3.programid, dm_projectlist_facts_3.programname, dm_projectlist_facts_3.programslug, dm_projectlist_facts_3.totalestimatedbillinginbasecurrency, dm_projectlist_facts_3.totalactualbillinginbasecurrency, dm_projectlist_facts_3.totalestimatedcostinbasecurrency, dm_projectlist_facts_3.totalestimatedcostcapexinbasecurrency, dm_projectlist_facts_3.totalestimatedcostopexinbasecurrency, dm_projectlist_facts_3.totalactualcostinbasecurrency, dm_projectlist_facts_3.totalactualcostcapexinbasecurrency, dm_projectlist_facts_3.totalactualcostopexinbasecurrency, dm_projectlist_facts_3.totalestimatedhours, dm_projectlist_facts_3.totalactualhours, dm_projectlist_facts_3.hoursfte, dm_projectlist_facts_3.estimatedresources, dm_projectlist_facts_3.assignedresources, dm_projectlist_facts_3.placeholderresources, dm_projectlist_facts_3.totalactualbillingamountinbasecurrency
  • Index Cond: (dm_projectlist_facts_3.statustype = 0)
  • Buffers: shared read=2
88. 0.000 0.000 ↓ 0.0 0

Index Only Scan using dm_projectlist_realtime_facts_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_realtime_facts dm_projectlist_realtime_facts_6 (cost=0.29..2.05 rows=1 width=4) (never executed)

  • Output: dm_projectlist_realtime_facts_6.projectid
  • Index Cond: (dm_projectlist_realtime_facts_6.projectid = dm_projectlist_facts_3.projectid)
  • Heap Fetches: 0
89.          

SubPlan (for Subquery Scan)

90. 0.000 0.000 ↓ 0.0 0

Merge Semi Join (cost=0.57..4,416.32 rows=15,150 width=4) (never executed)

  • Output: project19.id
  • Merge Cond: (project19.id = project20.id)
91. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project19 (cost=0.29..2,094.53 rows=15,150 width=4) (never executed)

  • Output: project19.id
  • Heap Fetches: 0
92. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project20 (cost=0.29..2,094.53 rows=15,150 width=4) (never executed)

  • Output: project20.id
  • Heap Fetches: 0
93. 0.000 0.000 ↓ 0.0 0

Merge Left Join (cost=0.44..2,217.02 rows=76 width=4) (never executed)

  • Output: project21.id
  • Merge Cond: (project21.id = projectsharingassignment22.projectid)
  • Filter: ((project21.projectleaderapproverid = 2) OR (projectsharingassignment22.userid = 2))
94. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project21 (cost=0.29..2,094.53 rows=15,150 width=8) (never executed)

  • Output: project21.id, project21.guidid, project21.name, project21.slug, project21.code, project21.clientid, project21.projectleaderapproverid, project21.projectstatuslabelid, project21.isprojectleaderapprovalrequired, project21.startdate, project21.enddate, project21.programid, project21.billingtype, project21.fixedbidamount, project21.fixedbidcurrencyid, project21.fixedbidfrequency, project21.timeentrycappercent, project21.costtype, project21.clientbillingallocationmethod, project21.description, project21.percentcomplete, project21.istimeentryallowed, project21.estimatedhours, project21.estimatedexpenses, project21.estimatedexpensescurrencyid, project21.estimatedcost, project21.estimatedcostcurrencyid, project21.timeandexpenseentrytype, project21.estimationmode, project21.billingratefrequencyid, project21.billingratefrequencyduration, project21.defaultbillingcurrencyid, project21.billingcontractid, project21.projecthealthstateid, project21.projecthealthstatedescription, project21.totalestimatedcontractamount, project21.totalestimatedcontractcurrencyid, project21.budgetedhours, project21.budgetedcost, project21.budgetedcostcurrencyid, project21.info1, project21.info2, project21.info3, project21.info4, project21.info5, project21.info6, project21.info7, project21.info8, project21.info9, project21.info10, project21.info11, project21.info12, project21.info13, project21.info14, project21.info15, project21.info16, project21.info17, project21.info18, project21.info19, project21.info20
95. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment22 (cost=0.15..45.06 rows=2,260 width=8) (never executed)

  • Output: projectsharingassignment22.projectid, projectsharingassignment22.userid
  • Heap Fetches: 0
96. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,132.61..8,886.87 rows=13,953 width=4) (never executed)

  • Output: project23.id
  • Hash Cond: (projectclient24.clientid = clients25.id)
  • Filter: ((clients25.clientmanageruserid = 2) OR (clientsharingassignment26.userid = 2))
97. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=2,122.88..8,101.98 rows=178,194 width=8) (never executed)

  • Output: project23.id, projectclient24.clientid
  • Hash Cond: (projectclient24.projectid = project23.id)
98. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient24 (cost=0.00..3,528.94 rows=178,194 width=8) (never executed)

  • Output: projectclient24.id, projectclient24.projectid, projectclient24.clientid, projectclient24.costallocationpercentage, projectclient24.effectivedate, projectclient24.enddate
99. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,933.50..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project23.id
100. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".project project23 (cost=0.00..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project23.id
101. 0.000 0.000 ↓ 0.0 0

Hash (cost=9.64..9.64 rows=8 width=12) (never executed)

  • Output: clients25.id, clients25.clientmanageruserid, clientsharingassignment26.userid
102. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.40..9.64 rows=8 width=12) (never executed)

  • Output: clients25.id, clients25.clientmanageruserid, clientsharingassignment26.userid
103. 0.000 0.000 ↓ 0.0 0

Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients25 (cost=0.25..2.26 rows=1 width=8) (never executed)

  • Output: clients25.id, clients25.name, clients25.slug, clients25.code, clients25.comments, clients25.clientmanageruserid, clients25.disabled, clients25.address, clients25.city, clients25.stateprovince, clients25.zippostalcode, clients25.country, clients25.email, clients25.telephone, clients25.fax, clients25.website, clients25.billingcontact, clients25.billingaddress, clients25.billingcity, clients25.billingstateprovince, clients25.billingzippostalcode, clients25.billingcountry, clients25.billingemail, clients25.billingtelephone, clients25.billingfax, clients25.billingwebsite, clients25.info1, clients25.info2, clients25.info3, clients25.info4, clients25.info5, clients25.info6, clients25.info7, clients25.info8, clients25.info9, clients25.info10, clients25.info11, clients25.info12, clients25.defaultbillingcurrencyid
104. 0.000 0.000 ↓ 0.0 0

Index Scan using ixcsaclientid on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment26 (cost=0.15..7.29 rows=8 width=8) (never executed)

  • Output: clientsharingassignment26.id, clientsharingassignment26.clientid, clientsharingassignment26.userid
  • Index Cond: (clientsharingassignment26.clientid = clients25.id)
105. 0.001 5.657 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_3 (cost=15,593.15..20,223.73 rows=116 width=0) (actual time=5.657..5.657 rows=0 loops=1)

  • Filter: ((hashed SubPlan 9) OR (hashed SubPlan 10) OR (hashed SubPlan 11))
  • Buffers: shared hit=3825
106. 5.656 5.656 ↓ 0.0 0 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_realtime_facts dm_projectlist_realtime_facts_7 (cost=0.00..4,628.25 rows=133 width=4) (actual time=5.656..5.656 rows=0 loops=1)

  • Output: dm_projectlist_realtime_facts_7.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), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::interval, NULL::interval, NULL::numeric(19,4), NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::uuid, NULL::numeric(19,4)
  • Filter: ((NOT dm_projectlist_realtime_facts_7.deleted) AND ((dm_projectlist_realtime_facts_7.statustype <> 5) OR (dm_projectlist_realtime_facts_7.statustype IS NULL)) AND (dm_projectlist_realtime_facts_7.statustype = 0))
  • Buffers: shared hit=3825
107.          

SubPlan (for Subquery Scan)

108. 0.000 0.000 ↓ 0.0 0

Merge Semi Join (cost=0.57..4,416.32 rows=15,150 width=4) (never executed)

  • Output: project19.id
  • Merge Cond: (project19.id = project20.id)
109. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project19 (cost=0.29..2,094.53 rows=15,150 width=4) (never executed)

  • Output: project19.id
  • Heap Fetches: 0
110. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project20 (cost=0.29..2,094.53 rows=15,150 width=4) (never executed)

  • Output: project20.id
  • Heap Fetches: 0
111. 0.000 0.000 ↓ 0.0 0

Merge Left Join (cost=0.44..2,217.02 rows=76 width=4) (never executed)

  • Output: project21.id
  • Merge Cond: (project21.id = projectsharingassignment22.projectid)
  • Filter: ((project21.projectleaderapproverid = 2) OR (projectsharingassignment22.userid = 2))
112. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project21 (cost=0.29..2,094.53 rows=15,150 width=8) (never executed)

  • Output: project21.id, project21.guidid, project21.name, project21.slug, project21.code, project21.clientid, project21.projectleaderapproverid, project21.projectstatuslabelid, project21.isprojectleaderapprovalrequired, project21.startdate, project21.enddate, project21.programid, project21.billingtype, project21.fixedbidamount, project21.fixedbidcurrencyid, project21.fixedbidfrequency, project21.timeentrycappercent, project21.costtype, project21.clientbillingallocationmethod, project21.description, project21.percentcomplete, project21.istimeentryallowed, project21.estimatedhours, project21.estimatedexpenses, project21.estimatedexpensescurrencyid, project21.estimatedcost, project21.estimatedcostcurrencyid, project21.timeandexpenseentrytype, project21.estimationmode, project21.billingratefrequencyid, project21.billingratefrequencyduration, project21.defaultbillingcurrencyid, project21.billingcontractid, project21.projecthealthstateid, project21.projecthealthstatedescription, project21.totalestimatedcontractamount, project21.totalestimatedcontractcurrencyid, project21.budgetedhours, project21.budgetedcost, project21.budgetedcostcurrencyid, project21.info1, project21.info2, project21.info3, project21.info4, project21.info5, project21.info6, project21.info7, project21.info8, project21.info9, project21.info10, project21.info11, project21.info12, project21.info13, project21.info14, project21.info15, project21.info16, project21.info17, project21.info18, project21.info19, project21.info20
113. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment22 (cost=0.15..45.06 rows=2,260 width=8) (never executed)

  • Output: projectsharingassignment22.projectid, projectsharingassignment22.userid
  • Heap Fetches: 0
114. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,132.61..8,886.87 rows=13,953 width=4) (never executed)

  • Output: project23.id
  • Hash Cond: (projectclient24.clientid = clients25.id)
  • Filter: ((clients25.clientmanageruserid = 2) OR (clientsharingassignment26.userid = 2))
115. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=2,122.88..8,101.98 rows=178,194 width=8) (never executed)

  • Output: project23.id, projectclient24.clientid
  • Hash Cond: (projectclient24.projectid = project23.id)
116. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient24 (cost=0.00..3,528.94 rows=178,194 width=8) (never executed)

  • Output: projectclient24.id, projectclient24.projectid, projectclient24.clientid, projectclient24.costallocationpercentage, projectclient24.effectivedate, projectclient24.enddate
117. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,933.50..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project23.id
118. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".project project23 (cost=0.00..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project23.id
119. 0.000 0.000 ↓ 0.0 0

Hash (cost=9.64..9.64 rows=8 width=12) (never executed)

  • Output: clients25.id, clients25.clientmanageruserid, clientsharingassignment26.userid
120. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.40..9.64 rows=8 width=12) (never executed)

  • Output: clients25.id, clients25.clientmanageruserid, clientsharingassignment26.userid
121. 0.000 0.000 ↓ 0.0 0

Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients25 (cost=0.25..2.26 rows=1 width=8) (never executed)

  • Output: clients25.id, clients25.name, clients25.slug, clients25.code, clients25.comments, clients25.clientmanageruserid, clients25.disabled, clients25.address, clients25.city, clients25.stateprovince, clients25.zippostalcode, clients25.country, clients25.email, clients25.telephone, clients25.fax, clients25.website, clients25.billingcontact, clients25.billingaddress, clients25.billingcity, clients25.billingstateprovince, clients25.billingzippostalcode, clients25.billingcountry, clients25.billingemail, clients25.billingtelephone, clients25.billingfax, clients25.billingwebsite, clients25.info1, clients25.info2, clients25.info3, clients25.info4, clients25.info5, clients25.info6, clients25.info7, clients25.info8, clients25.info9, clients25.info10, clients25.info11, clients25.info12, clients25.defaultbillingcurrencyid
122. 0.000 0.000 ↓ 0.0 0

Index Scan using ixcsaclientid on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment26 (cost=0.15..7.29 rows=8 width=8) (never executed)

  • Output: clientsharingassignment26.id, clientsharingassignment26.clientid, clientsharingassignment26.userid
  • Index Cond: (clientsharingassignment26.clientid = clients25.id)
123. 5.326 156.775 ↑ 1.0 1 1

Aggregate (cost=35,946.65..35,946.66 rows=1 width=0) (actual time=156.774..156.775 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=73900 read=76
124. 8.810 151.449 ↓ 129.5 15,150 1

Append (cost=15,593.73..35,946.35 rows=117 width=0) (actual time=37.475..151.449 rows=15,150 loops=1)

  • Buffers: shared hit=73900 read=76
125. 20.115 132.589 ↓ 15,150.0 15,150 1

Subquery Scan on *SELECT* 1_4 (cost=15,593.73..15,722.63 rows=1 width=0) (actual time=37.474..132.589 rows=15,150 loops=1)

  • Filter: ((hashed SubPlan 13) OR (hashed SubPlan 14) OR (hashed SubPlan 15))
  • Buffers: shared hit=70075 read=76
126. 20.026 81.197 ↓ 15,150.0 15,150 1

Nested Loop Anti Join (cost=0.57..129.46 rows=1 width=4) (actual time=0.026..81.197 rows=15,150 loops=1)

  • Output: dm_projectlist_facts_4.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), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::interval, NULL::interval, NULL::numeric(19,4), NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::uuid, NULL::numeric(19,4)
  • Buffers: shared hit=43663 read=76
127. 15.721 15.721 ↓ 360.7 15,150 1

Index Scan using ixdprjfstatustype on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_facts dm_projectlist_facts_4 (cost=0.29..43.12 rows=42 width=4) (actual time=0.009..15.721 rows=15,150 loops=1)

  • Output: dm_projectlist_facts_4.projectid, dm_projectlist_facts_4.projectguidid, dm_projectlist_facts_4.name, dm_projectlist_facts_4.slug, dm_projectlist_facts_4.code, dm_projectlist_facts_4.statustype, dm_projectlist_facts_4.invoicingtype, dm_projectlist_facts_4.estimationmode, dm_projectlist_facts_4.startdate, dm_projectlist_facts_4.enddate, dm_projectlist_facts_4.projectleaderid, dm_projectlist_facts_4.projectleaderdisplayname, dm_projectlist_facts_4.projectleaderslug, dm_projectlist_facts_4.programid, dm_projectlist_facts_4.programname, dm_projectlist_facts_4.programslug, dm_projectlist_facts_4.totalestimatedbillinginbasecurrency, dm_projectlist_facts_4.totalactualbillinginbasecurrency, dm_projectlist_facts_4.totalestimatedcostinbasecurrency, dm_projectlist_facts_4.totalestimatedcostcapexinbasecurrency, dm_projectlist_facts_4.totalestimatedcostopexinbasecurrency, dm_projectlist_facts_4.totalactualcostinbasecurrency, dm_projectlist_facts_4.totalactualcostcapexinbasecurrency, dm_projectlist_facts_4.totalactualcostopexinbasecurrency, dm_projectlist_facts_4.totalestimatedhours, dm_projectlist_facts_4.totalactualhours, dm_projectlist_facts_4.hoursfte, dm_projectlist_facts_4.estimatedresources, dm_projectlist_facts_4.assignedresources, dm_projectlist_facts_4.placeholderresources, dm_projectlist_facts_4.totalactualbillingamountinbasecurrency
  • Index Cond: (dm_projectlist_facts_4.statustype = 1)
  • Buffers: shared hit=819 read=76
128. 45.450 45.450 ↓ 0.0 0 15,150

Index Only Scan using dm_projectlist_realtime_facts_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_realtime_facts dm_projectlist_realtime_facts_8 (cost=0.29..2.05 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=15,150)

  • Output: dm_projectlist_realtime_facts_8.projectid
  • Index Cond: (dm_projectlist_realtime_facts_8.projectid = dm_projectlist_facts_4.projectid)
  • Heap Fetches: 12484
  • Buffers: shared hit=42844
129.          

SubPlan (for Subquery Scan)

130. 12.206 31.277 ↑ 1.0 15,150 1

Merge Semi Join (cost=0.57..4,416.32 rows=15,150 width=4) (actual time=0.023..31.277 rows=15,150 loops=1)

  • Output: project28.id
  • Merge Cond: (project28.id = project29.id)
  • Buffers: shared hit=26412
131. 11.090 11.090 ↑ 1.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project28 (cost=0.29..2,094.53 rows=15,150 width=4) (actual time=0.013..11.090 rows=15,150 loops=1)

  • Output: project28.id
  • Heap Fetches: 25031
  • Buffers: shared hit=13206
132. 7.981 7.981 ↑ 1.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project29 (cost=0.29..2,094.53 rows=15,150 width=4) (actual time=0.007..7.981 rows=15,150 loops=1)

  • Output: project29.id
  • Heap Fetches: 25030
  • Buffers: shared hit=13206
133. 0.000 0.000 ↓ 0.0 0

Merge Left Join (cost=0.44..2,217.02 rows=76 width=4) (never executed)

  • Output: project30.id
  • Merge Cond: (project30.id = projectsharingassignment31.projectid)
  • Filter: ((project30.projectleaderapproverid = 2) OR (projectsharingassignment31.userid = 2))
134. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project30 (cost=0.29..2,094.53 rows=15,150 width=8) (never executed)

  • Output: project30.id, project30.guidid, project30.name, project30.slug, project30.code, project30.clientid, project30.projectleaderapproverid, project30.projectstatuslabelid, project30.isprojectleaderapprovalrequired, project30.startdate, project30.enddate, project30.programid, project30.billingtype, project30.fixedbidamount, project30.fixedbidcurrencyid, project30.fixedbidfrequency, project30.timeentrycappercent, project30.costtype, project30.clientbillingallocationmethod, project30.description, project30.percentcomplete, project30.istimeentryallowed, project30.estimatedhours, project30.estimatedexpenses, project30.estimatedexpensescurrencyid, project30.estimatedcost, project30.estimatedcostcurrencyid, project30.timeandexpenseentrytype, project30.estimationmode, project30.billingratefrequencyid, project30.billingratefrequencyduration, project30.defaultbillingcurrencyid, project30.billingcontractid, project30.projecthealthstateid, project30.projecthealthstatedescription, project30.totalestimatedcontractamount, project30.totalestimatedcontractcurrencyid, project30.budgetedhours, project30.budgetedcost, project30.budgetedcostcurrencyid, project30.info1, project30.info2, project30.info3, project30.info4, project30.info5, project30.info6, project30.info7, project30.info8, project30.info9, project30.info10, project30.info11, project30.info12, project30.info13, project30.info14, project30.info15, project30.info16, project30.info17, project30.info18, project30.info19, project30.info20
135. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment31 (cost=0.15..45.06 rows=2,260 width=8) (never executed)

  • Output: projectsharingassignment31.projectid, projectsharingassignment31.userid
  • Heap Fetches: 0
136. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,132.61..8,886.87 rows=13,953 width=4) (never executed)

  • Output: project32.id
  • Hash Cond: (projectclient33.clientid = clients34.id)
  • Filter: ((clients34.clientmanageruserid = 2) OR (clientsharingassignment35.userid = 2))
137. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=2,122.88..8,101.98 rows=178,194 width=8) (never executed)

  • Output: project32.id, projectclient33.clientid
  • Hash Cond: (projectclient33.projectid = project32.id)
138. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient33 (cost=0.00..3,528.94 rows=178,194 width=8) (never executed)

  • Output: projectclient33.id, projectclient33.projectid, projectclient33.clientid, projectclient33.costallocationpercentage, projectclient33.effectivedate, projectclient33.enddate
139. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,933.50..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project32.id
140. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".project project32 (cost=0.00..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project32.id
141. 0.000 0.000 ↓ 0.0 0

Hash (cost=9.64..9.64 rows=8 width=12) (never executed)

  • Output: clients34.id, clients34.clientmanageruserid, clientsharingassignment35.userid
142. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.40..9.64 rows=8 width=12) (never executed)

  • Output: clients34.id, clients34.clientmanageruserid, clientsharingassignment35.userid
143. 0.000 0.000 ↓ 0.0 0

Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients34 (cost=0.25..2.26 rows=1 width=8) (never executed)

  • Output: clients34.id, clients34.name, clients34.slug, clients34.code, clients34.comments, clients34.clientmanageruserid, clients34.disabled, clients34.address, clients34.city, clients34.stateprovince, clients34.zippostalcode, clients34.country, clients34.email, clients34.telephone, clients34.fax, clients34.website, clients34.billingcontact, clients34.billingaddress, clients34.billingcity, clients34.billingstateprovince, clients34.billingzippostalcode, clients34.billingcountry, clients34.billingemail, clients34.billingtelephone, clients34.billingfax, clients34.billingwebsite, clients34.info1, clients34.info2, clients34.info3, clients34.info4, clients34.info5, clients34.info6, clients34.info7, clients34.info8, clients34.info9, clients34.info10, clients34.info11, clients34.info12, clients34.defaultbillingcurrencyid
144. 0.000 0.000 ↓ 0.0 0

Index Scan using ixcsaclientid on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment35 (cost=0.15..7.29 rows=8 width=8) (never executed)

  • Output: clientsharingassignment35.id, clientsharingassignment35.clientid, clientsharingassignment35.userid
  • Index Cond: (clientsharingassignment35.clientid = clients34.id)
145. 0.000 10.050 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_4 (cost=15,593.15..20,223.73 rows=116 width=0) (actual time=10.050..10.050 rows=0 loops=1)

  • Filter: ((hashed SubPlan 13) OR (hashed SubPlan 14) OR (hashed SubPlan 15))
  • Buffers: shared hit=3825
146. 10.049 10.049 ↓ 0.0 0 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_realtime_facts dm_projectlist_realtime_facts_9 (cost=0.00..4,628.25 rows=133 width=4) (actual time=10.049..10.049 rows=0 loops=1)

  • Output: dm_projectlist_realtime_facts_9.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), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::interval, NULL::interval, NULL::numeric(19,4), NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::uuid, NULL::numeric(19,4)
  • Filter: ((NOT dm_projectlist_realtime_facts_9.deleted) AND ((dm_projectlist_realtime_facts_9.statustype <> 5) OR (dm_projectlist_realtime_facts_9.statustype IS NULL)) AND (dm_projectlist_realtime_facts_9.statustype = 1))
  • Buffers: shared hit=3825
147.          

SubPlan (for Subquery Scan)

148. 12.206 31.277 ↑ 1.0 15,150 1

Merge Semi Join (cost=0.57..4,416.32 rows=15,150 width=4) (actual time=0.023..31.277 rows=15,150 loops=1)

  • Output: project28.id
  • Merge Cond: (project28.id = project29.id)
  • Buffers: shared hit=26412
149. 11.090 11.090 ↑ 1.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project28 (cost=0.29..2,094.53 rows=15,150 width=4) (actual time=0.013..11.090 rows=15,150 loops=1)

  • Output: project28.id
  • Heap Fetches: 25031
  • Buffers: shared hit=13206
150. 7.981 7.981 ↑ 1.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project29 (cost=0.29..2,094.53 rows=15,150 width=4) (actual time=0.007..7.981 rows=15,150 loops=1)

  • Output: project29.id
  • Heap Fetches: 25030
  • Buffers: shared hit=13206
151. 0.000 0.000 ↓ 0.0 0

Merge Left Join (cost=0.44..2,217.02 rows=76 width=4) (never executed)

  • Output: project30.id
  • Merge Cond: (project30.id = projectsharingassignment31.projectid)
  • Filter: ((project30.projectleaderapproverid = 2) OR (projectsharingassignment31.userid = 2))
152. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project30 (cost=0.29..2,094.53 rows=15,150 width=8) (never executed)

  • Output: project30.id, project30.guidid, project30.name, project30.slug, project30.code, project30.clientid, project30.projectleaderapproverid, project30.projectstatuslabelid, project30.isprojectleaderapprovalrequired, project30.startdate, project30.enddate, project30.programid, project30.billingtype, project30.fixedbidamount, project30.fixedbidcurrencyid, project30.fixedbidfrequency, project30.timeentrycappercent, project30.costtype, project30.clientbillingallocationmethod, project30.description, project30.percentcomplete, project30.istimeentryallowed, project30.estimatedhours, project30.estimatedexpenses, project30.estimatedexpensescurrencyid, project30.estimatedcost, project30.estimatedcostcurrencyid, project30.timeandexpenseentrytype, project30.estimationmode, project30.billingratefrequencyid, project30.billingratefrequencyduration, project30.defaultbillingcurrencyid, project30.billingcontractid, project30.projecthealthstateid, project30.projecthealthstatedescription, project30.totalestimatedcontractamount, project30.totalestimatedcontractcurrencyid, project30.budgetedhours, project30.budgetedcost, project30.budgetedcostcurrencyid, project30.info1, project30.info2, project30.info3, project30.info4, project30.info5, project30.info6, project30.info7, project30.info8, project30.info9, project30.info10, project30.info11, project30.info12, project30.info13, project30.info14, project30.info15, project30.info16, project30.info17, project30.info18, project30.info19, project30.info20
153. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment31 (cost=0.15..45.06 rows=2,260 width=8) (never executed)

  • Output: projectsharingassignment31.projectid, projectsharingassignment31.userid
  • Heap Fetches: 0
154. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,132.61..8,886.87 rows=13,953 width=4) (never executed)

  • Output: project32.id
  • Hash Cond: (projectclient33.clientid = clients34.id)
  • Filter: ((clients34.clientmanageruserid = 2) OR (clientsharingassignment35.userid = 2))
155. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=2,122.88..8,101.98 rows=178,194 width=8) (never executed)

  • Output: project32.id, projectclient33.clientid
  • Hash Cond: (projectclient33.projectid = project32.id)
156. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient33 (cost=0.00..3,528.94 rows=178,194 width=8) (never executed)

  • Output: projectclient33.id, projectclient33.projectid, projectclient33.clientid, projectclient33.costallocationpercentage, projectclient33.effectivedate, projectclient33.enddate
157. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,933.50..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project32.id
158. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".project project32 (cost=0.00..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project32.id
159. 0.000 0.000 ↓ 0.0 0

Hash (cost=9.64..9.64 rows=8 width=12) (never executed)

  • Output: clients34.id, clients34.clientmanageruserid, clientsharingassignment35.userid
160. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.40..9.64 rows=8 width=12) (never executed)

  • Output: clients34.id, clients34.clientmanageruserid, clientsharingassignment35.userid
161. 0.000 0.000 ↓ 0.0 0

Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients34 (cost=0.25..2.26 rows=1 width=8) (never executed)

  • Output: clients34.id, clients34.name, clients34.slug, clients34.code, clients34.comments, clients34.clientmanageruserid, clients34.disabled, clients34.address, clients34.city, clients34.stateprovince, clients34.zippostalcode, clients34.country, clients34.email, clients34.telephone, clients34.fax, clients34.website, clients34.billingcontact, clients34.billingaddress, clients34.billingcity, clients34.billingstateprovince, clients34.billingzippostalcode, clients34.billingcountry, clients34.billingemail, clients34.billingtelephone, clients34.billingfax, clients34.billingwebsite, clients34.info1, clients34.info2, clients34.info3, clients34.info4, clients34.info5, clients34.info6, clients34.info7, clients34.info8, clients34.info9, clients34.info10, clients34.info11, clients34.info12, clients34.defaultbillingcurrencyid
162. 0.000 0.000 ↓ 0.0 0

Index Scan using ixcsaclientid on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment35 (cost=0.15..7.29 rows=8 width=8) (never executed)

  • Output: clientsharingassignment35.id, clientsharingassignment35.clientid, clientsharingassignment35.userid
  • Index Cond: (clientsharingassignment35.clientid = clients34.id)
163. 0.005 9.734 ↑ 1.0 1 1

Aggregate (cost=35,946.65..35,946.66 rows=1 width=0) (actual time=9.733..9.734 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=3827
164. 0.003 9.729 ↓ 0.0 0 1

Append (cost=15,593.73..35,946.35 rows=117 width=0) (actual time=9.729..9.729 rows=0 loops=1)

  • Buffers: shared hit=3827
165. 0.001 0.008 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1_5 (cost=15,593.73..15,722.63 rows=1 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: ((hashed SubPlan 17) OR (hashed SubPlan 18) OR (hashed SubPlan 19))
  • Buffers: shared hit=2
166. 0.002 0.007 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.57..129.46 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=1)

  • Output: dm_projectlist_facts_5.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), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::interval, NULL::interval, NULL::numeric(19,4), NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::uuid, NULL::numeric(19,4)
  • Buffers: shared hit=2
167. 0.005 0.005 ↓ 0.0 0 1

Index Scan using ixdprjfstatustype on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_facts dm_projectlist_facts_5 (cost=0.29..43.12 rows=42 width=4) (actual time=0.005..0.005 rows=0 loops=1)

  • Output: dm_projectlist_facts_5.projectid, dm_projectlist_facts_5.projectguidid, dm_projectlist_facts_5.name, dm_projectlist_facts_5.slug, dm_projectlist_facts_5.code, dm_projectlist_facts_5.statustype, dm_projectlist_facts_5.invoicingtype, dm_projectlist_facts_5.estimationmode, dm_projectlist_facts_5.startdate, dm_projectlist_facts_5.enddate, dm_projectlist_facts_5.projectleaderid, dm_projectlist_facts_5.projectleaderdisplayname, dm_projectlist_facts_5.projectleaderslug, dm_projectlist_facts_5.programid, dm_projectlist_facts_5.programname, dm_projectlist_facts_5.programslug, dm_projectlist_facts_5.totalestimatedbillinginbasecurrency, dm_projectlist_facts_5.totalactualbillinginbasecurrency, dm_projectlist_facts_5.totalestimatedcostinbasecurrency, dm_projectlist_facts_5.totalestimatedcostcapexinbasecurrency, dm_projectlist_facts_5.totalestimatedcostopexinbasecurrency, dm_projectlist_facts_5.totalactualcostinbasecurrency, dm_projectlist_facts_5.totalactualcostcapexinbasecurrency, dm_projectlist_facts_5.totalactualcostopexinbasecurrency, dm_projectlist_facts_5.totalestimatedhours, dm_projectlist_facts_5.totalactualhours, dm_projectlist_facts_5.hoursfte, dm_projectlist_facts_5.estimatedresources, dm_projectlist_facts_5.assignedresources, dm_projectlist_facts_5.placeholderresources, dm_projectlist_facts_5.totalactualbillingamountinbasecurrency
  • Index Cond: (dm_projectlist_facts_5.statustype = 2)
  • Buffers: shared hit=2
168. 0.000 0.000 ↓ 0.0 0

Index Only Scan using dm_projectlist_realtime_facts_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_realtime_facts dm_projectlist_realtime_facts_10 (cost=0.29..2.05 rows=1 width=4) (never executed)

  • Output: dm_projectlist_realtime_facts_10.projectid
  • Index Cond: (dm_projectlist_realtime_facts_10.projectid = dm_projectlist_facts_5.projectid)
  • Heap Fetches: 0
169.          

SubPlan (for Subquery Scan)

170. 0.000 0.000 ↓ 0.0 0

Merge Semi Join (cost=0.57..4,416.32 rows=15,150 width=4) (never executed)

  • Output: project37.id
  • Merge Cond: (project37.id = project38.id)
171. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project37 (cost=0.29..2,094.53 rows=15,150 width=4) (never executed)

  • Output: project37.id
  • Heap Fetches: 0
172. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project38 (cost=0.29..2,094.53 rows=15,150 width=4) (never executed)

  • Output: project38.id
  • Heap Fetches: 0
173. 0.000 0.000 ↓ 0.0 0

Merge Left Join (cost=0.44..2,217.02 rows=76 width=4) (never executed)

  • Output: project39.id
  • Merge Cond: (project39.id = projectsharingassignment40.projectid)
  • Filter: ((project39.projectleaderapproverid = 2) OR (projectsharingassignment40.userid = 2))
174. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project39 (cost=0.29..2,094.53 rows=15,150 width=8) (never executed)

  • Output: project39.id, project39.guidid, project39.name, project39.slug, project39.code, project39.clientid, project39.projectleaderapproverid, project39.projectstatuslabelid, project39.isprojectleaderapprovalrequired, project39.startdate, project39.enddate, project39.programid, project39.billingtype, project39.fixedbidamount, project39.fixedbidcurrencyid, project39.fixedbidfrequency, project39.timeentrycappercent, project39.costtype, project39.clientbillingallocationmethod, project39.description, project39.percentcomplete, project39.istimeentryallowed, project39.estimatedhours, project39.estimatedexpenses, project39.estimatedexpensescurrencyid, project39.estimatedcost, project39.estimatedcostcurrencyid, project39.timeandexpenseentrytype, project39.estimationmode, project39.billingratefrequencyid, project39.billingratefrequencyduration, project39.defaultbillingcurrencyid, project39.billingcontractid, project39.projecthealthstateid, project39.projecthealthstatedescription, project39.totalestimatedcontractamount, project39.totalestimatedcontractcurrencyid, project39.budgetedhours, project39.budgetedcost, project39.budgetedcostcurrencyid, project39.info1, project39.info2, project39.info3, project39.info4, project39.info5, project39.info6, project39.info7, project39.info8, project39.info9, project39.info10, project39.info11, project39.info12, project39.info13, project39.info14, project39.info15, project39.info16, project39.info17, project39.info18, project39.info19, project39.info20
175. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment40 (cost=0.15..45.06 rows=2,260 width=8) (never executed)

  • Output: projectsharingassignment40.projectid, projectsharingassignment40.userid
  • Heap Fetches: 0
176. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,132.61..8,886.87 rows=13,953 width=4) (never executed)

  • Output: project41.id
  • Hash Cond: (projectclient42.clientid = clients43.id)
  • Filter: ((clients43.clientmanageruserid = 2) OR (clientsharingassignment44.userid = 2))
177. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=2,122.88..8,101.98 rows=178,194 width=8) (never executed)

  • Output: project41.id, projectclient42.clientid
  • Hash Cond: (projectclient42.projectid = project41.id)
178. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient42 (cost=0.00..3,528.94 rows=178,194 width=8) (never executed)

  • Output: projectclient42.id, projectclient42.projectid, projectclient42.clientid, projectclient42.costallocationpercentage, projectclient42.effectivedate, projectclient42.enddate
179. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,933.50..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project41.id
180. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".project project41 (cost=0.00..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project41.id
181. 0.000 0.000 ↓ 0.0 0

Hash (cost=9.64..9.64 rows=8 width=12) (never executed)

  • Output: clients43.id, clients43.clientmanageruserid, clientsharingassignment44.userid
182. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.40..9.64 rows=8 width=12) (never executed)

  • Output: clients43.id, clients43.clientmanageruserid, clientsharingassignment44.userid
183. 0.000 0.000 ↓ 0.0 0

Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients43 (cost=0.25..2.26 rows=1 width=8) (never executed)

  • Output: clients43.id, clients43.name, clients43.slug, clients43.code, clients43.comments, clients43.clientmanageruserid, clients43.disabled, clients43.address, clients43.city, clients43.stateprovince, clients43.zippostalcode, clients43.country, clients43.email, clients43.telephone, clients43.fax, clients43.website, clients43.billingcontact, clients43.billingaddress, clients43.billingcity, clients43.billingstateprovince, clients43.billingzippostalcode, clients43.billingcountry, clients43.billingemail, clients43.billingtelephone, clients43.billingfax, clients43.billingwebsite, clients43.info1, clients43.info2, clients43.info3, clients43.info4, clients43.info5, clients43.info6, clients43.info7, clients43.info8, clients43.info9, clients43.info10, clients43.info11, clients43.info12, clients43.defaultbillingcurrencyid
184. 0.000 0.000 ↓ 0.0 0

Index Scan using ixcsaclientid on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment44 (cost=0.15..7.29 rows=8 width=8) (never executed)

  • Output: clientsharingassignment44.id, clientsharingassignment44.clientid, clientsharingassignment44.userid
  • Index Cond: (clientsharingassignment44.clientid = clients43.id)
185. 0.002 9.718 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_5 (cost=15,593.15..20,223.73 rows=116 width=0) (actual time=9.718..9.718 rows=0 loops=1)

  • Filter: ((hashed SubPlan 17) OR (hashed SubPlan 18) OR (hashed SubPlan 19))
  • Buffers: shared hit=3825
186. 9.716 9.716 ↓ 0.0 0 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_realtime_facts dm_projectlist_realtime_facts_11 (cost=0.00..4,628.25 rows=133 width=4) (actual time=9.716..9.716 rows=0 loops=1)

  • Output: dm_projectlist_realtime_facts_11.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), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::interval, NULL::interval, NULL::numeric(19,4), NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::uuid, NULL::numeric(19,4)
  • Filter: ((NOT dm_projectlist_realtime_facts_11.deleted) AND ((dm_projectlist_realtime_facts_11.statustype <> 5) OR (dm_projectlist_realtime_facts_11.statustype IS NULL)) AND (dm_projectlist_realtime_facts_11.statustype = 2))
  • Buffers: shared hit=3825
187.          

SubPlan (for Subquery Scan)

188. 0.000 0.000 ↓ 0.0 0

Merge Semi Join (cost=0.57..4,416.32 rows=15,150 width=4) (never executed)

  • Output: project37.id
  • Merge Cond: (project37.id = project38.id)
189. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project37 (cost=0.29..2,094.53 rows=15,150 width=4) (never executed)

  • Output: project37.id
  • Heap Fetches: 0
190. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project38 (cost=0.29..2,094.53 rows=15,150 width=4) (never executed)

  • Output: project38.id
  • Heap Fetches: 0
191. 0.000 0.000 ↓ 0.0 0

Merge Left Join (cost=0.44..2,217.02 rows=76 width=4) (never executed)

  • Output: project39.id
  • Merge Cond: (project39.id = projectsharingassignment40.projectid)
  • Filter: ((project39.projectleaderapproverid = 2) OR (projectsharingassignment40.userid = 2))
192. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project39 (cost=0.29..2,094.53 rows=15,150 width=8) (never executed)

  • Output: project39.id, project39.guidid, project39.name, project39.slug, project39.code, project39.clientid, project39.projectleaderapproverid, project39.projectstatuslabelid, project39.isprojectleaderapprovalrequired, project39.startdate, project39.enddate, project39.programid, project39.billingtype, project39.fixedbidamount, project39.fixedbidcurrencyid, project39.fixedbidfrequency, project39.timeentrycappercent, project39.costtype, project39.clientbillingallocationmethod, project39.description, project39.percentcomplete, project39.istimeentryallowed, project39.estimatedhours, project39.estimatedexpenses, project39.estimatedexpensescurrencyid, project39.estimatedcost, project39.estimatedcostcurrencyid, project39.timeandexpenseentrytype, project39.estimationmode, project39.billingratefrequencyid, project39.billingratefrequencyduration, project39.defaultbillingcurrencyid, project39.billingcontractid, project39.projecthealthstateid, project39.projecthealthstatedescription, project39.totalestimatedcontractamount, project39.totalestimatedcontractcurrencyid, project39.budgetedhours, project39.budgetedcost, project39.budgetedcostcurrencyid, project39.info1, project39.info2, project39.info3, project39.info4, project39.info5, project39.info6, project39.info7, project39.info8, project39.info9, project39.info10, project39.info11, project39.info12, project39.info13, project39.info14, project39.info15, project39.info16, project39.info17, project39.info18, project39.info19, project39.info20
193. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment40 (cost=0.15..45.06 rows=2,260 width=8) (never executed)

  • Output: projectsharingassignment40.projectid, projectsharingassignment40.userid
  • Heap Fetches: 0
194. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,132.61..8,886.87 rows=13,953 width=4) (never executed)

  • Output: project41.id
  • Hash Cond: (projectclient42.clientid = clients43.id)
  • Filter: ((clients43.clientmanageruserid = 2) OR (clientsharingassignment44.userid = 2))
195. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=2,122.88..8,101.98 rows=178,194 width=8) (never executed)

  • Output: project41.id, projectclient42.clientid
  • Hash Cond: (projectclient42.projectid = project41.id)
196. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient42 (cost=0.00..3,528.94 rows=178,194 width=8) (never executed)

  • Output: projectclient42.id, projectclient42.projectid, projectclient42.clientid, projectclient42.costallocationpercentage, projectclient42.effectivedate, projectclient42.enddate
197. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,933.50..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project41.id
198. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".project project41 (cost=0.00..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project41.id
199. 0.000 0.000 ↓ 0.0 0

Hash (cost=9.64..9.64 rows=8 width=12) (never executed)

  • Output: clients43.id, clients43.clientmanageruserid, clientsharingassignment44.userid
200. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.40..9.64 rows=8 width=12) (never executed)

  • Output: clients43.id, clients43.clientmanageruserid, clientsharingassignment44.userid
201. 0.000 0.000 ↓ 0.0 0

Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients43 (cost=0.25..2.26 rows=1 width=8) (never executed)

  • Output: clients43.id, clients43.name, clients43.slug, clients43.code, clients43.comments, clients43.clientmanageruserid, clients43.disabled, clients43.address, clients43.city, clients43.stateprovince, clients43.zippostalcode, clients43.country, clients43.email, clients43.telephone, clients43.fax, clients43.website, clients43.billingcontact, clients43.billingaddress, clients43.billingcity, clients43.billingstateprovince, clients43.billingzippostalcode, clients43.billingcountry, clients43.billingemail, clients43.billingtelephone, clients43.billingfax, clients43.billingwebsite, clients43.info1, clients43.info2, clients43.info3, clients43.info4, clients43.info5, clients43.info6, clients43.info7, clients43.info8, clients43.info9, clients43.info10, clients43.info11, clients43.info12, clients43.defaultbillingcurrencyid
202. 0.000 0.000 ↓ 0.0 0

Index Scan using ixcsaclientid on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment44 (cost=0.15..7.29 rows=8 width=8) (never executed)

  • Output: clientsharingassignment44.id, clientsharingassignment44.clientid, clientsharingassignment44.userid
  • Index Cond: (clientsharingassignment44.clientid = clients43.id)
203. 0.004 9.553 ↑ 1.0 1 1

Aggregate (cost=35,946.65..35,946.66 rows=1 width=0) (actual time=9.552..9.553 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=3827
204. 0.003 9.549 ↓ 0.0 0 1

Append (cost=15,593.73..35,946.35 rows=117 width=0) (actual time=9.549..9.549 rows=0 loops=1)

  • Buffers: shared hit=3827
205. 0.001 0.007 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1_6 (cost=15,593.73..15,722.63 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: ((hashed SubPlan 21) OR (hashed SubPlan 22) OR (hashed SubPlan 23))
  • Buffers: shared hit=2
206. 0.001 0.006 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.57..129.46 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)

  • Output: dm_projectlist_facts_6.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), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::interval, NULL::interval, NULL::numeric(19,4), NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::uuid, NULL::numeric(19,4)
  • Buffers: shared hit=2
207. 0.005 0.005 ↓ 0.0 0 1

Index Scan using ixdprjfstatustype on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_facts dm_projectlist_facts_6 (cost=0.29..43.12 rows=42 width=4) (actual time=0.005..0.005 rows=0 loops=1)

  • Output: dm_projectlist_facts_6.projectid, dm_projectlist_facts_6.projectguidid, dm_projectlist_facts_6.name, dm_projectlist_facts_6.slug, dm_projectlist_facts_6.code, dm_projectlist_facts_6.statustype, dm_projectlist_facts_6.invoicingtype, dm_projectlist_facts_6.estimationmode, dm_projectlist_facts_6.startdate, dm_projectlist_facts_6.enddate, dm_projectlist_facts_6.projectleaderid, dm_projectlist_facts_6.projectleaderdisplayname, dm_projectlist_facts_6.projectleaderslug, dm_projectlist_facts_6.programid, dm_projectlist_facts_6.programname, dm_projectlist_facts_6.programslug, dm_projectlist_facts_6.totalestimatedbillinginbasecurrency, dm_projectlist_facts_6.totalactualbillinginbasecurrency, dm_projectlist_facts_6.totalestimatedcostinbasecurrency, dm_projectlist_facts_6.totalestimatedcostcapexinbasecurrency, dm_projectlist_facts_6.totalestimatedcostopexinbasecurrency, dm_projectlist_facts_6.totalactualcostinbasecurrency, dm_projectlist_facts_6.totalactualcostcapexinbasecurrency, dm_projectlist_facts_6.totalactualcostopexinbasecurrency, dm_projectlist_facts_6.totalestimatedhours, dm_projectlist_facts_6.totalactualhours, dm_projectlist_facts_6.hoursfte, dm_projectlist_facts_6.estimatedresources, dm_projectlist_facts_6.assignedresources, dm_projectlist_facts_6.placeholderresources, dm_projectlist_facts_6.totalactualbillingamountinbasecurrency
  • Index Cond: (dm_projectlist_facts_6.statustype = 3)
  • Buffers: shared hit=2
208. 0.000 0.000 ↓ 0.0 0

Index Only Scan using dm_projectlist_realtime_facts_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_realtime_facts dm_projectlist_realtime_facts_12 (cost=0.29..2.05 rows=1 width=4) (never executed)

  • Output: dm_projectlist_realtime_facts_12.projectid
  • Index Cond: (dm_projectlist_realtime_facts_12.projectid = dm_projectlist_facts_6.projectid)
  • Heap Fetches: 0
209.          

SubPlan (for Subquery Scan)

210. 0.000 0.000 ↓ 0.0 0

Merge Semi Join (cost=0.57..4,416.32 rows=15,150 width=4) (never executed)

  • Output: project46.id
  • Merge Cond: (project46.id = project47.id)
211. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project46 (cost=0.29..2,094.53 rows=15,150 width=4) (never executed)

  • Output: project46.id
  • Heap Fetches: 0
212. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project47 (cost=0.29..2,094.53 rows=15,150 width=4) (never executed)

  • Output: project47.id
  • Heap Fetches: 0
213. 0.000 0.000 ↓ 0.0 0

Merge Left Join (cost=0.44..2,217.02 rows=76 width=4) (never executed)

  • Output: project48.id
  • Merge Cond: (project48.id = projectsharingassignment49.projectid)
  • Filter: ((project48.projectleaderapproverid = 2) OR (projectsharingassignment49.userid = 2))
214. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project48 (cost=0.29..2,094.53 rows=15,150 width=8) (never executed)

  • Output: project48.id, project48.guidid, project48.name, project48.slug, project48.code, project48.clientid, project48.projectleaderapproverid, project48.projectstatuslabelid, project48.isprojectleaderapprovalrequired, project48.startdate, project48.enddate, project48.programid, project48.billingtype, project48.fixedbidamount, project48.fixedbidcurrencyid, project48.fixedbidfrequency, project48.timeentrycappercent, project48.costtype, project48.clientbillingallocationmethod, project48.description, project48.percentcomplete, project48.istimeentryallowed, project48.estimatedhours, project48.estimatedexpenses, project48.estimatedexpensescurrencyid, project48.estimatedcost, project48.estimatedcostcurrencyid, project48.timeandexpenseentrytype, project48.estimationmode, project48.billingratefrequencyid, project48.billingratefrequencyduration, project48.defaultbillingcurrencyid, project48.billingcontractid, project48.projecthealthstateid, project48.projecthealthstatedescription, project48.totalestimatedcontractamount, project48.totalestimatedcontractcurrencyid, project48.budgetedhours, project48.budgetedcost, project48.budgetedcostcurrencyid, project48.info1, project48.info2, project48.info3, project48.info4, project48.info5, project48.info6, project48.info7, project48.info8, project48.info9, project48.info10, project48.info11, project48.info12, project48.info13, project48.info14, project48.info15, project48.info16, project48.info17, project48.info18, project48.info19, project48.info20
215. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment49 (cost=0.15..45.06 rows=2,260 width=8) (never executed)

  • Output: projectsharingassignment49.projectid, projectsharingassignment49.userid
  • Heap Fetches: 0
216. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,132.61..8,886.87 rows=13,953 width=4) (never executed)

  • Output: project50.id
  • Hash Cond: (projectclient51.clientid = clients52.id)
  • Filter: ((clients52.clientmanageruserid = 2) OR (clientsharingassignment53.userid = 2))
217. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=2,122.88..8,101.98 rows=178,194 width=8) (never executed)

  • Output: project50.id, projectclient51.clientid
  • Hash Cond: (projectclient51.projectid = project50.id)
218. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient51 (cost=0.00..3,528.94 rows=178,194 width=8) (never executed)

  • Output: projectclient51.id, projectclient51.projectid, projectclient51.clientid, projectclient51.costallocationpercentage, projectclient51.effectivedate, projectclient51.enddate
219. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,933.50..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project50.id
220. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".project project50 (cost=0.00..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project50.id
221. 0.000 0.000 ↓ 0.0 0

Hash (cost=9.64..9.64 rows=8 width=12) (never executed)

  • Output: clients52.id, clients52.clientmanageruserid, clientsharingassignment53.userid
222. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.40..9.64 rows=8 width=12) (never executed)

  • Output: clients52.id, clients52.clientmanageruserid, clientsharingassignment53.userid
223. 0.000 0.000 ↓ 0.0 0

Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients52 (cost=0.25..2.26 rows=1 width=8) (never executed)

  • Output: clients52.id, clients52.name, clients52.slug, clients52.code, clients52.comments, clients52.clientmanageruserid, clients52.disabled, clients52.address, clients52.city, clients52.stateprovince, clients52.zippostalcode, clients52.country, clients52.email, clients52.telephone, clients52.fax, clients52.website, clients52.billingcontact, clients52.billingaddress, clients52.billingcity, clients52.billingstateprovince, clients52.billingzippostalcode, clients52.billingcountry, clients52.billingemail, clients52.billingtelephone, clients52.billingfax, clients52.billingwebsite, clients52.info1, clients52.info2, clients52.info3, clients52.info4, clients52.info5, clients52.info6, clients52.info7, clients52.info8, clients52.info9, clients52.info10, clients52.info11, clients52.info12, clients52.defaultbillingcurrencyid
224. 0.000 0.000 ↓ 0.0 0

Index Scan using ixcsaclientid on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment53 (cost=0.15..7.29 rows=8 width=8) (never executed)

  • Output: clientsharingassignment53.id, clientsharingassignment53.clientid, clientsharingassignment53.userid
  • Index Cond: (clientsharingassignment53.clientid = clients52.id)
225. 0.001 9.539 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_6 (cost=15,593.15..20,223.73 rows=116 width=0) (actual time=9.539..9.539 rows=0 loops=1)

  • Filter: ((hashed SubPlan 21) OR (hashed SubPlan 22) OR (hashed SubPlan 23))
  • Buffers: shared hit=3825
226. 9.538 9.538 ↓ 0.0 0 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_realtime_facts dm_projectlist_realtime_facts_13 (cost=0.00..4,628.25 rows=133 width=4) (actual time=9.538..9.538 rows=0 loops=1)

  • Output: dm_projectlist_realtime_facts_13.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), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::interval, NULL::interval, NULL::numeric(19,4), NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::uuid, NULL::numeric(19,4)
  • Filter: ((NOT dm_projectlist_realtime_facts_13.deleted) AND ((dm_projectlist_realtime_facts_13.statustype <> 5) OR (dm_projectlist_realtime_facts_13.statustype IS NULL)) AND (dm_projectlist_realtime_facts_13.statustype = 3))
  • Buffers: shared hit=3825
227.          

SubPlan (for Subquery Scan)

228. 0.000 0.000 ↓ 0.0 0

Merge Semi Join (cost=0.57..4,416.32 rows=15,150 width=4) (never executed)

  • Output: project46.id
  • Merge Cond: (project46.id = project47.id)
229. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project46 (cost=0.29..2,094.53 rows=15,150 width=4) (never executed)

  • Output: project46.id
  • Heap Fetches: 0
230. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project47 (cost=0.29..2,094.53 rows=15,150 width=4) (never executed)

  • Output: project47.id
  • Heap Fetches: 0
231. 0.000 0.000 ↓ 0.0 0

Merge Left Join (cost=0.44..2,217.02 rows=76 width=4) (never executed)

  • Output: project48.id
  • Merge Cond: (project48.id = projectsharingassignment49.projectid)
  • Filter: ((project48.projectleaderapproverid = 2) OR (projectsharingassignment49.userid = 2))
232. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project48 (cost=0.29..2,094.53 rows=15,150 width=8) (never executed)

  • Output: project48.id, project48.guidid, project48.name, project48.slug, project48.code, project48.clientid, project48.projectleaderapproverid, project48.projectstatuslabelid, project48.isprojectleaderapprovalrequired, project48.startdate, project48.enddate, project48.programid, project48.billingtype, project48.fixedbidamount, project48.fixedbidcurrencyid, project48.fixedbidfrequency, project48.timeentrycappercent, project48.costtype, project48.clientbillingallocationmethod, project48.description, project48.percentcomplete, project48.istimeentryallowed, project48.estimatedhours, project48.estimatedexpenses, project48.estimatedexpensescurrencyid, project48.estimatedcost, project48.estimatedcostcurrencyid, project48.timeandexpenseentrytype, project48.estimationmode, project48.billingratefrequencyid, project48.billingratefrequencyduration, project48.defaultbillingcurrencyid, project48.billingcontractid, project48.projecthealthstateid, project48.projecthealthstatedescription, project48.totalestimatedcontractamount, project48.totalestimatedcontractcurrencyid, project48.budgetedhours, project48.budgetedcost, project48.budgetedcostcurrencyid, project48.info1, project48.info2, project48.info3, project48.info4, project48.info5, project48.info6, project48.info7, project48.info8, project48.info9, project48.info10, project48.info11, project48.info12, project48.info13, project48.info14, project48.info15, project48.info16, project48.info17, project48.info18, project48.info19, project48.info20
233. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment49 (cost=0.15..45.06 rows=2,260 width=8) (never executed)

  • Output: projectsharingassignment49.projectid, projectsharingassignment49.userid
  • Heap Fetches: 0
234. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,132.61..8,886.87 rows=13,953 width=4) (never executed)

  • Output: project50.id
  • Hash Cond: (projectclient51.clientid = clients52.id)
  • Filter: ((clients52.clientmanageruserid = 2) OR (clientsharingassignment53.userid = 2))
235. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=2,122.88..8,101.98 rows=178,194 width=8) (never executed)

  • Output: project50.id, projectclient51.clientid
  • Hash Cond: (projectclient51.projectid = project50.id)
236. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient51 (cost=0.00..3,528.94 rows=178,194 width=8) (never executed)

  • Output: projectclient51.id, projectclient51.projectid, projectclient51.clientid, projectclient51.costallocationpercentage, projectclient51.effectivedate, projectclient51.enddate
237. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,933.50..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project50.id
238. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".project project50 (cost=0.00..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project50.id
239. 0.000 0.000 ↓ 0.0 0

Hash (cost=9.64..9.64 rows=8 width=12) (never executed)

  • Output: clients52.id, clients52.clientmanageruserid, clientsharingassignment53.userid
240. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.40..9.64 rows=8 width=12) (never executed)

  • Output: clients52.id, clients52.clientmanageruserid, clientsharingassignment53.userid
241. 0.000 0.000 ↓ 0.0 0

Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients52 (cost=0.25..2.26 rows=1 width=8) (never executed)

  • Output: clients52.id, clients52.name, clients52.slug, clients52.code, clients52.comments, clients52.clientmanageruserid, clients52.disabled, clients52.address, clients52.city, clients52.stateprovince, clients52.zippostalcode, clients52.country, clients52.email, clients52.telephone, clients52.fax, clients52.website, clients52.billingcontact, clients52.billingaddress, clients52.billingcity, clients52.billingstateprovince, clients52.billingzippostalcode, clients52.billingcountry, clients52.billingemail, clients52.billingtelephone, clients52.billingfax, clients52.billingwebsite, clients52.info1, clients52.info2, clients52.info3, clients52.info4, clients52.info5, clients52.info6, clients52.info7, clients52.info8, clients52.info9, clients52.info10, clients52.info11, clients52.info12, clients52.defaultbillingcurrencyid
242. 0.000 0.000 ↓ 0.0 0

Index Scan using ixcsaclientid on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment53 (cost=0.15..7.29 rows=8 width=8) (never executed)

  • Output: clientsharingassignment53.id, clientsharingassignment53.clientid, clientsharingassignment53.userid
  • Index Cond: (clientsharingassignment53.clientid = clients52.id)
243. 0.005 9.566 ↑ 1.0 1 1

Aggregate (cost=35,946.65..35,946.66 rows=1 width=0) (actual time=9.565..9.566 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=3827
244. 0.003 9.561 ↓ 0.0 0 1

Append (cost=15,593.73..35,946.35 rows=117 width=0) (actual time=9.561..9.561 rows=0 loops=1)

  • Buffers: shared hit=3827
245. 0.000 0.007 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1_7 (cost=15,593.73..15,722.63 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: ((hashed SubPlan 25) OR (hashed SubPlan 26) OR (hashed SubPlan 27))
  • Buffers: shared hit=2
246. 0.002 0.007 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.57..129.46 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=1)

  • Output: dm_projectlist_facts_7.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), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::interval, NULL::interval, NULL::numeric(19,4), NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::uuid, NULL::numeric(19,4)
  • Buffers: shared hit=2
247. 0.005 0.005 ↓ 0.0 0 1

Index Scan using ixdprjfstatustype on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_facts dm_projectlist_facts_7 (cost=0.29..43.12 rows=42 width=4) (actual time=0.005..0.005 rows=0 loops=1)

  • Output: dm_projectlist_facts_7.projectid, dm_projectlist_facts_7.projectguidid, dm_projectlist_facts_7.name, dm_projectlist_facts_7.slug, dm_projectlist_facts_7.code, dm_projectlist_facts_7.statustype, dm_projectlist_facts_7.invoicingtype, dm_projectlist_facts_7.estimationmode, dm_projectlist_facts_7.startdate, dm_projectlist_facts_7.enddate, dm_projectlist_facts_7.projectleaderid, dm_projectlist_facts_7.projectleaderdisplayname, dm_projectlist_facts_7.projectleaderslug, dm_projectlist_facts_7.programid, dm_projectlist_facts_7.programname, dm_projectlist_facts_7.programslug, dm_projectlist_facts_7.totalestimatedbillinginbasecurrency, dm_projectlist_facts_7.totalactualbillinginbasecurrency, dm_projectlist_facts_7.totalestimatedcostinbasecurrency, dm_projectlist_facts_7.totalestimatedcostcapexinbasecurrency, dm_projectlist_facts_7.totalestimatedcostopexinbasecurrency, dm_projectlist_facts_7.totalactualcostinbasecurrency, dm_projectlist_facts_7.totalactualcostcapexinbasecurrency, dm_projectlist_facts_7.totalactualcostopexinbasecurrency, dm_projectlist_facts_7.totalestimatedhours, dm_projectlist_facts_7.totalactualhours, dm_projectlist_facts_7.hoursfte, dm_projectlist_facts_7.estimatedresources, dm_projectlist_facts_7.assignedresources, dm_projectlist_facts_7.placeholderresources, dm_projectlist_facts_7.totalactualbillingamountinbasecurrency
  • Index Cond: (dm_projectlist_facts_7.statustype = 4)
  • Buffers: shared hit=2
248. 0.000 0.000 ↓ 0.0 0

Index Only Scan using dm_projectlist_realtime_facts_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_realtime_facts dm_projectlist_realtime_facts_14 (cost=0.29..2.05 rows=1 width=4) (never executed)

  • Output: dm_projectlist_realtime_facts_14.projectid
  • Index Cond: (dm_projectlist_realtime_facts_14.projectid = dm_projectlist_facts_7.projectid)
  • Heap Fetches: 0
249.          

SubPlan (for Subquery Scan)

250. 0.000 0.000 ↓ 0.0 0

Merge Semi Join (cost=0.57..4,416.32 rows=15,150 width=4) (never executed)

  • Output: project55.id
  • Merge Cond: (project55.id = project56.id)
251. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project55 (cost=0.29..2,094.53 rows=15,150 width=4) (never executed)

  • Output: project55.id
  • Heap Fetches: 0
252. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project56 (cost=0.29..2,094.53 rows=15,150 width=4) (never executed)

  • Output: project56.id
  • Heap Fetches: 0
253. 0.000 0.000 ↓ 0.0 0

Merge Left Join (cost=0.44..2,217.02 rows=76 width=4) (never executed)

  • Output: project57.id
  • Merge Cond: (project57.id = projectsharingassignment58.projectid)
  • Filter: ((project57.projectleaderapproverid = 2) OR (projectsharingassignment58.userid = 2))
254. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project57 (cost=0.29..2,094.53 rows=15,150 width=8) (never executed)

  • Output: project57.id, project57.guidid, project57.name, project57.slug, project57.code, project57.clientid, project57.projectleaderapproverid, project57.projectstatuslabelid, project57.isprojectleaderapprovalrequired, project57.startdate, project57.enddate, project57.programid, project57.billingtype, project57.fixedbidamount, project57.fixedbidcurrencyid, project57.fixedbidfrequency, project57.timeentrycappercent, project57.costtype, project57.clientbillingallocationmethod, project57.description, project57.percentcomplete, project57.istimeentryallowed, project57.estimatedhours, project57.estimatedexpenses, project57.estimatedexpensescurrencyid, project57.estimatedcost, project57.estimatedcostcurrencyid, project57.timeandexpenseentrytype, project57.estimationmode, project57.billingratefrequencyid, project57.billingratefrequencyduration, project57.defaultbillingcurrencyid, project57.billingcontractid, project57.projecthealthstateid, project57.projecthealthstatedescription, project57.totalestimatedcontractamount, project57.totalestimatedcontractcurrencyid, project57.budgetedhours, project57.budgetedcost, project57.budgetedcostcurrencyid, project57.info1, project57.info2, project57.info3, project57.info4, project57.info5, project57.info6, project57.info7, project57.info8, project57.info9, project57.info10, project57.info11, project57.info12, project57.info13, project57.info14, project57.info15, project57.info16, project57.info17, project57.info18, project57.info19, project57.info20
255. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment58 (cost=0.15..45.06 rows=2,260 width=8) (never executed)

  • Output: projectsharingassignment58.projectid, projectsharingassignment58.userid
  • Heap Fetches: 0
256. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,132.61..8,886.87 rows=13,953 width=4) (never executed)

  • Output: project59.id
  • Hash Cond: (projectclient60.clientid = clients61.id)
  • Filter: ((clients61.clientmanageruserid = 2) OR (clientsharingassignment62.userid = 2))
257. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=2,122.88..8,101.98 rows=178,194 width=8) (never executed)

  • Output: project59.id, projectclient60.clientid
  • Hash Cond: (projectclient60.projectid = project59.id)
258. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient60 (cost=0.00..3,528.94 rows=178,194 width=8) (never executed)

  • Output: projectclient60.id, projectclient60.projectid, projectclient60.clientid, projectclient60.costallocationpercentage, projectclient60.effectivedate, projectclient60.enddate
259. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,933.50..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project59.id
260. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".project project59 (cost=0.00..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project59.id
261. 0.000 0.000 ↓ 0.0 0

Hash (cost=9.64..9.64 rows=8 width=12) (never executed)

  • Output: clients61.id, clients61.clientmanageruserid, clientsharingassignment62.userid
262. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.40..9.64 rows=8 width=12) (never executed)

  • Output: clients61.id, clients61.clientmanageruserid, clientsharingassignment62.userid
263. 0.000 0.000 ↓ 0.0 0

Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients61 (cost=0.25..2.26 rows=1 width=8) (never executed)

  • Output: clients61.id, clients61.name, clients61.slug, clients61.code, clients61.comments, clients61.clientmanageruserid, clients61.disabled, clients61.address, clients61.city, clients61.stateprovince, clients61.zippostalcode, clients61.country, clients61.email, clients61.telephone, clients61.fax, clients61.website, clients61.billingcontact, clients61.billingaddress, clients61.billingcity, clients61.billingstateprovince, clients61.billingzippostalcode, clients61.billingcountry, clients61.billingemail, clients61.billingtelephone, clients61.billingfax, clients61.billingwebsite, clients61.info1, clients61.info2, clients61.info3, clients61.info4, clients61.info5, clients61.info6, clients61.info7, clients61.info8, clients61.info9, clients61.info10, clients61.info11, clients61.info12, clients61.defaultbillingcurrencyid
264. 0.000 0.000 ↓ 0.0 0

Index Scan using ixcsaclientid on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment62 (cost=0.15..7.29 rows=8 width=8) (never executed)

  • Output: clientsharingassignment62.id, clientsharingassignment62.clientid, clientsharingassignment62.userid
  • Index Cond: (clientsharingassignment62.clientid = clients61.id)
265. 0.002 9.551 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_7 (cost=15,593.15..20,223.73 rows=116 width=0) (actual time=9.551..9.551 rows=0 loops=1)

  • Filter: ((hashed SubPlan 25) OR (hashed SubPlan 26) OR (hashed SubPlan 27))
  • Buffers: shared hit=3825
266. 9.549 9.549 ↓ 0.0 0 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_realtime_facts dm_projectlist_realtime_facts_15 (cost=0.00..4,628.25 rows=133 width=4) (actual time=9.549..9.549 rows=0 loops=1)

  • Output: dm_projectlist_realtime_facts_15.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), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::interval, NULL::interval, NULL::numeric(19,4), NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::uuid, NULL::numeric(19,4)
  • Filter: ((NOT dm_projectlist_realtime_facts_15.deleted) AND ((dm_projectlist_realtime_facts_15.statustype <> 5) OR (dm_projectlist_realtime_facts_15.statustype IS NULL)) AND (dm_projectlist_realtime_facts_15.statustype = 4))
  • Buffers: shared hit=3825
267.          

SubPlan (for Subquery Scan)

268. 0.000 0.000 ↓ 0.0 0

Merge Semi Join (cost=0.57..4,416.32 rows=15,150 width=4) (never executed)

  • Output: project55.id
  • Merge Cond: (project55.id = project56.id)
269. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project55 (cost=0.29..2,094.53 rows=15,150 width=4) (never executed)

  • Output: project55.id
  • Heap Fetches: 0
270. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project56 (cost=0.29..2,094.53 rows=15,150 width=4) (never executed)

  • Output: project56.id
  • Heap Fetches: 0
271. 0.000 0.000 ↓ 0.0 0

Merge Left Join (cost=0.44..2,217.02 rows=76 width=4) (never executed)

  • Output: project57.id
  • Merge Cond: (project57.id = projectsharingassignment58.projectid)
  • Filter: ((project57.projectleaderapproverid = 2) OR (projectsharingassignment58.userid = 2))
272. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project57 (cost=0.29..2,094.53 rows=15,150 width=8) (never executed)

  • Output: project57.id, project57.guidid, project57.name, project57.slug, project57.code, project57.clientid, project57.projectleaderapproverid, project57.projectstatuslabelid, project57.isprojectleaderapprovalrequired, project57.startdate, project57.enddate, project57.programid, project57.billingtype, project57.fixedbidamount, project57.fixedbidcurrencyid, project57.fixedbidfrequency, project57.timeentrycappercent, project57.costtype, project57.clientbillingallocationmethod, project57.description, project57.percentcomplete, project57.istimeentryallowed, project57.estimatedhours, project57.estimatedexpenses, project57.estimatedexpensescurrencyid, project57.estimatedcost, project57.estimatedcostcurrencyid, project57.timeandexpenseentrytype, project57.estimationmode, project57.billingratefrequencyid, project57.billingratefrequencyduration, project57.defaultbillingcurrencyid, project57.billingcontractid, project57.projecthealthstateid, project57.projecthealthstatedescription, project57.totalestimatedcontractamount, project57.totalestimatedcontractcurrencyid, project57.budgetedhours, project57.budgetedcost, project57.budgetedcostcurrencyid, project57.info1, project57.info2, project57.info3, project57.info4, project57.info5, project57.info6, project57.info7, project57.info8, project57.info9, project57.info10, project57.info11, project57.info12, project57.info13, project57.info14, project57.info15, project57.info16, project57.info17, project57.info18, project57.info19, project57.info20
273. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment58 (cost=0.15..45.06 rows=2,260 width=8) (never executed)

  • Output: projectsharingassignment58.projectid, projectsharingassignment58.userid
  • Heap Fetches: 0
274. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,132.61..8,886.87 rows=13,953 width=4) (never executed)

  • Output: project59.id
  • Hash Cond: (projectclient60.clientid = clients61.id)
  • Filter: ((clients61.clientmanageruserid = 2) OR (clientsharingassignment62.userid = 2))
275. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=2,122.88..8,101.98 rows=178,194 width=8) (never executed)

  • Output: project59.id, projectclient60.clientid
  • Hash Cond: (projectclient60.projectid = project59.id)
276. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient60 (cost=0.00..3,528.94 rows=178,194 width=8) (never executed)

  • Output: projectclient60.id, projectclient60.projectid, projectclient60.clientid, projectclient60.costallocationpercentage, projectclient60.effectivedate, projectclient60.enddate
277. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,933.50..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project59.id
278. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".project project59 (cost=0.00..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project59.id
279. 0.000 0.000 ↓ 0.0 0

Hash (cost=9.64..9.64 rows=8 width=12) (never executed)

  • Output: clients61.id, clients61.clientmanageruserid, clientsharingassignment62.userid
280. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.40..9.64 rows=8 width=12) (never executed)

  • Output: clients61.id, clients61.clientmanageruserid, clientsharingassignment62.userid
281. 0.000 0.000 ↓ 0.0 0

Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients61 (cost=0.25..2.26 rows=1 width=8) (never executed)

  • Output: clients61.id, clients61.name, clients61.slug, clients61.code, clients61.comments, clients61.clientmanageruserid, clients61.disabled, clients61.address, clients61.city, clients61.stateprovince, clients61.zippostalcode, clients61.country, clients61.email, clients61.telephone, clients61.fax, clients61.website, clients61.billingcontact, clients61.billingaddress, clients61.billingcity, clients61.billingstateprovince, clients61.billingzippostalcode, clients61.billingcountry, clients61.billingemail, clients61.billingtelephone, clients61.billingfax, clients61.billingwebsite, clients61.info1, clients61.info2, clients61.info3, clients61.info4, clients61.info5, clients61.info6, clients61.info7, clients61.info8, clients61.info9, clients61.info10, clients61.info11, clients61.info12, clients61.defaultbillingcurrencyid
282. 0.000 0.000 ↓ 0.0 0

Index Scan using ixcsaclientid on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment62 (cost=0.15..7.29 rows=8 width=8) (never executed)

  • Output: clientsharingassignment62.id, clientsharingassignment62.clientid, clientsharingassignment62.userid
  • Index Cond: (clientsharingassignment62.clientid = clients61.id)
283. 0.003 9.497 ↑ 1.0 1 1

Aggregate (cost=35,812.69..35,812.70 rows=1 width=0) (actual time=9.497..9.497 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=3827
284. 0.003 9.494 ↓ 0.0 0 1

Append (cost=15,593.73..35,812.39 rows=118 width=0) (actual time=9.494..9.494 rows=0 loops=1)

  • Buffers: shared hit=3827
285. 0.002 0.008 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1_8 (cost=15,593.73..15,722.52 rows=1 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: ((hashed SubPlan 29) OR (hashed SubPlan 30) OR (hashed SubPlan 31))
  • Buffers: shared hit=2
286. 0.000 0.006 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.57..129.35 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)

  • Output: dm_projectlist_facts_8.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), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::interval, NULL::interval, NULL::numeric(19,4), NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::uuid, NULL::numeric(19,4)
  • Buffers: shared hit=2
287. 0.006 0.006 ↓ 0.0 0 1

Index Scan using ixdprjfstatustype on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_facts dm_projectlist_facts_8 (cost=0.29..43.02 rows=42 width=4) (actual time=0.006..0.006 rows=0 loops=1)

  • Output: dm_projectlist_facts_8.projectid, dm_projectlist_facts_8.projectguidid, dm_projectlist_facts_8.name, dm_projectlist_facts_8.slug, dm_projectlist_facts_8.code, dm_projectlist_facts_8.statustype, dm_projectlist_facts_8.invoicingtype, dm_projectlist_facts_8.estimationmode, dm_projectlist_facts_8.startdate, dm_projectlist_facts_8.enddate, dm_projectlist_facts_8.projectleaderid, dm_projectlist_facts_8.projectleaderdisplayname, dm_projectlist_facts_8.projectleaderslug, dm_projectlist_facts_8.programid, dm_projectlist_facts_8.programname, dm_projectlist_facts_8.programslug, dm_projectlist_facts_8.totalestimatedbillinginbasecurrency, dm_projectlist_facts_8.totalactualbillinginbasecurrency, dm_projectlist_facts_8.totalestimatedcostinbasecurrency, dm_projectlist_facts_8.totalestimatedcostcapexinbasecurrency, dm_projectlist_facts_8.totalestimatedcostopexinbasecurrency, dm_projectlist_facts_8.totalactualcostinbasecurrency, dm_projectlist_facts_8.totalactualcostcapexinbasecurrency, dm_projectlist_facts_8.totalactualcostopexinbasecurrency, dm_projectlist_facts_8.totalestimatedhours, dm_projectlist_facts_8.totalactualhours, dm_projectlist_facts_8.hoursfte, dm_projectlist_facts_8.estimatedresources, dm_projectlist_facts_8.assignedresources, dm_projectlist_facts_8.placeholderresources, dm_projectlist_facts_8.totalactualbillingamountinbasecurrency
  • Index Cond: (dm_projectlist_facts_8.statustype = 5)
  • Buffers: shared hit=2
288. 0.000 0.000 ↓ 0.0 0

Index Only Scan using dm_projectlist_realtime_facts_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_realtime_facts dm_projectlist_realtime_facts_16 (cost=0.29..2.05 rows=1 width=4) (never executed)

  • Output: dm_projectlist_realtime_facts_16.projectid
  • Index Cond: (dm_projectlist_realtime_facts_16.projectid = dm_projectlist_facts_8.projectid)
  • Heap Fetches: 0
289.          

SubPlan (for Subquery Scan)

290. 0.000 0.000 ↓ 0.0 0

Merge Semi Join (cost=0.57..4,416.32 rows=15,150 width=4) (never executed)

  • Output: project64.id
  • Merge Cond: (project64.id = project65.id)
291. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project64 (cost=0.29..2,094.53 rows=15,150 width=4) (never executed)

  • Output: project64.id
  • Heap Fetches: 0
292. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project65 (cost=0.29..2,094.53 rows=15,150 width=4) (never executed)

  • Output: project65.id
  • Heap Fetches: 0
293. 0.000 0.000 ↓ 0.0 0

Merge Left Join (cost=0.44..2,217.02 rows=76 width=4) (never executed)

  • Output: project66.id
  • Merge Cond: (project66.id = projectsharingassignment67.projectid)
  • Filter: ((project66.projectleaderapproverid = 2) OR (projectsharingassignment67.userid = 2))
294. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project66 (cost=0.29..2,094.53 rows=15,150 width=8) (never executed)

  • Output: project66.id, project66.guidid, project66.name, project66.slug, project66.code, project66.clientid, project66.projectleaderapproverid, project66.projectstatuslabelid, project66.isprojectleaderapprovalrequired, project66.startdate, project66.enddate, project66.programid, project66.billingtype, project66.fixedbidamount, project66.fixedbidcurrencyid, project66.fixedbidfrequency, project66.timeentrycappercent, project66.costtype, project66.clientbillingallocationmethod, project66.description, project66.percentcomplete, project66.istimeentryallowed, project66.estimatedhours, project66.estimatedexpenses, project66.estimatedexpensescurrencyid, project66.estimatedcost, project66.estimatedcostcurrencyid, project66.timeandexpenseentrytype, project66.estimationmode, project66.billingratefrequencyid, project66.billingratefrequencyduration, project66.defaultbillingcurrencyid, project66.billingcontractid, project66.projecthealthstateid, project66.projecthealthstatedescription, project66.totalestimatedcontractamount, project66.totalestimatedcontractcurrencyid, project66.budgetedhours, project66.budgetedcost, project66.budgetedcostcurrencyid, project66.info1, project66.info2, project66.info3, project66.info4, project66.info5, project66.info6, project66.info7, project66.info8, project66.info9, project66.info10, project66.info11, project66.info12, project66.info13, project66.info14, project66.info15, project66.info16, project66.info17, project66.info18, project66.info19, project66.info20
295. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment67 (cost=0.15..45.06 rows=2,260 width=8) (never executed)

  • Output: projectsharingassignment67.projectid, projectsharingassignment67.userid
  • Heap Fetches: 0
296. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,132.61..8,886.87 rows=13,953 width=4) (never executed)

  • Output: project68.id
  • Hash Cond: (projectclient69.clientid = clients70.id)
  • Filter: ((clients70.clientmanageruserid = 2) OR (clientsharingassignment71.userid = 2))
297. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=2,122.88..8,101.98 rows=178,194 width=8) (never executed)

  • Output: project68.id, projectclient69.clientid
  • Hash Cond: (projectclient69.projectid = project68.id)
298. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient69 (cost=0.00..3,528.94 rows=178,194 width=8) (never executed)

  • Output: projectclient69.id, projectclient69.projectid, projectclient69.clientid, projectclient69.costallocationpercentage, projectclient69.effectivedate, projectclient69.enddate
299. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,933.50..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project68.id
300. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".project project68 (cost=0.00..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project68.id
301. 0.000 0.000 ↓ 0.0 0

Hash (cost=9.64..9.64 rows=8 width=12) (never executed)

  • Output: clients70.id, clients70.clientmanageruserid, clientsharingassignment71.userid
302. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.40..9.64 rows=8 width=12) (never executed)

  • Output: clients70.id, clients70.clientmanageruserid, clientsharingassignment71.userid
303. 0.000 0.000 ↓ 0.0 0

Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients70 (cost=0.25..2.26 rows=1 width=8) (never executed)

  • Output: clients70.id, clients70.name, clients70.slug, clients70.code, clients70.comments, clients70.clientmanageruserid, clients70.disabled, clients70.address, clients70.city, clients70.stateprovince, clients70.zippostalcode, clients70.country, clients70.email, clients70.telephone, clients70.fax, clients70.website, clients70.billingcontact, clients70.billingaddress, clients70.billingcity, clients70.billingstateprovince, clients70.billingzippostalcode, clients70.billingcountry, clients70.billingemail, clients70.billingtelephone, clients70.billingfax, clients70.billingwebsite, clients70.info1, clients70.info2, clients70.info3, clients70.info4, clients70.info5, clients70.info6, clients70.info7, clients70.info8, clients70.info9, clients70.info10, clients70.info11, clients70.info12, clients70.defaultbillingcurrencyid
304. 0.000 0.000 ↓ 0.0 0

Index Scan using ixcsaclientid on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment71 (cost=0.15..7.29 rows=8 width=8) (never executed)

  • Output: clientsharingassignment71.id, clientsharingassignment71.clientid, clientsharingassignment71.userid
  • Index Cond: (clientsharingassignment71.clientid = clients70.id)
305. 0.001 9.483 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_8 (cost=15,593.15..20,089.87 rows=117 width=0) (actual time=9.483..9.483 rows=0 loops=1)

  • Filter: ((hashed SubPlan 29) OR (hashed SubPlan 30) OR (hashed SubPlan 31))
  • Buffers: shared hit=3825
306. 9.482 9.482 ↓ 0.0 0 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_realtime_facts dm_projectlist_realtime_facts_17 (cost=0.00..4,494.38 rows=134 width=4) (actual time=9.482..9.482 rows=0 loops=1)

  • Output: dm_projectlist_realtime_facts_17.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), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::interval, NULL::interval, NULL::numeric(19,4), NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::uuid, NULL::numeric(19,4)
  • Filter: ((NOT dm_projectlist_realtime_facts_17.deleted) AND (dm_projectlist_realtime_facts_17.statustype = 5))
  • Buffers: shared hit=3825
307.          

SubPlan (for Subquery Scan)

308. 0.000 0.000 ↓ 0.0 0

Merge Semi Join (cost=0.57..4,416.32 rows=15,150 width=4) (never executed)

  • Output: project64.id
  • Merge Cond: (project64.id = project65.id)
309. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project64 (cost=0.29..2,094.53 rows=15,150 width=4) (never executed)

  • Output: project64.id
  • Heap Fetches: 0
310. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project65 (cost=0.29..2,094.53 rows=15,150 width=4) (never executed)

  • Output: project65.id
  • Heap Fetches: 0
311. 0.000 0.000 ↓ 0.0 0

Merge Left Join (cost=0.44..2,217.02 rows=76 width=4) (never executed)

  • Output: project66.id
  • Merge Cond: (project66.id = projectsharingassignment67.projectid)
  • Filter: ((project66.projectleaderapproverid = 2) OR (projectsharingassignment67.userid = 2))
312. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project66 (cost=0.29..2,094.53 rows=15,150 width=8) (never executed)

  • Output: project66.id, project66.guidid, project66.name, project66.slug, project66.code, project66.clientid, project66.projectleaderapproverid, project66.projectstatuslabelid, project66.isprojectleaderapprovalrequired, project66.startdate, project66.enddate, project66.programid, project66.billingtype, project66.fixedbidamount, project66.fixedbidcurrencyid, project66.fixedbidfrequency, project66.timeentrycappercent, project66.costtype, project66.clientbillingallocationmethod, project66.description, project66.percentcomplete, project66.istimeentryallowed, project66.estimatedhours, project66.estimatedexpenses, project66.estimatedexpensescurrencyid, project66.estimatedcost, project66.estimatedcostcurrencyid, project66.timeandexpenseentrytype, project66.estimationmode, project66.billingratefrequencyid, project66.billingratefrequencyduration, project66.defaultbillingcurrencyid, project66.billingcontractid, project66.projecthealthstateid, project66.projecthealthstatedescription, project66.totalestimatedcontractamount, project66.totalestimatedcontractcurrencyid, project66.budgetedhours, project66.budgetedcost, project66.budgetedcostcurrencyid, project66.info1, project66.info2, project66.info3, project66.info4, project66.info5, project66.info6, project66.info7, project66.info8, project66.info9, project66.info10, project66.info11, project66.info12, project66.info13, project66.info14, project66.info15, project66.info16, project66.info17, project66.info18, project66.info19, project66.info20
313. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment67 (cost=0.15..45.06 rows=2,260 width=8) (never executed)

  • Output: projectsharingassignment67.projectid, projectsharingassignment67.userid
  • Heap Fetches: 0
314. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,132.61..8,886.87 rows=13,953 width=4) (never executed)

  • Output: project68.id
  • Hash Cond: (projectclient69.clientid = clients70.id)
  • Filter: ((clients70.clientmanageruserid = 2) OR (clientsharingassignment71.userid = 2))
315. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=2,122.88..8,101.98 rows=178,194 width=8) (never executed)

  • Output: project68.id, projectclient69.clientid
  • Hash Cond: (projectclient69.projectid = project68.id)
316. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient69 (cost=0.00..3,528.94 rows=178,194 width=8) (never executed)

  • Output: projectclient69.id, projectclient69.projectid, projectclient69.clientid, projectclient69.costallocationpercentage, projectclient69.effectivedate, projectclient69.enddate
317. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,933.50..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project68.id
318. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".project project68 (cost=0.00..1,933.50 rows=15,150 width=4) (never executed)

  • Output: project68.id
319. 0.000 0.000 ↓ 0.0 0

Hash (cost=9.64..9.64 rows=8 width=12) (never executed)

  • Output: clients70.id, clients70.clientmanageruserid, clientsharingassignment71.userid
320. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.40..9.64 rows=8 width=12) (never executed)

  • Output: clients70.id, clients70.clientmanageruserid, clientsharingassignment71.userid
321. 0.000 0.000 ↓ 0.0 0

Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients70 (cost=0.25..2.26 rows=1 width=8) (never executed)

  • Output: clients70.id, clients70.name, clients70.slug, clients70.code, clients70.comments, clients70.clientmanageruserid, clients70.disabled, clients70.address, clients70.city, clients70.stateprovince, clients70.zippostalcode, clients70.country, clients70.email, clients70.telephone, clients70.fax, clients70.website, clients70.billingcontact, clients70.billingaddress, clients70.billingcity, clients70.billingstateprovince, clients70.billingzippostalcode, clients70.billingcountry, clients70.billingemail, clients70.billingtelephone, clients70.billingfax, clients70.billingwebsite, clients70.info1, clients70.info2, clients70.info3, clients70.info4, clients70.info5, clients70.info6, clients70.info7, clients70.info8, clients70.info9, clients70.info10, clients70.info11, clients70.info12, clients70.defaultbillingcurrencyid
322. 0.000 0.000 ↓ 0.0 0

Index Scan using ixcsaclientid on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment71 (cost=0.15..7.29 rows=8 width=8) (never executed)

  • Output: clientsharingassignment71.id, clientsharingassignment71.clientid, clientsharingassignment71.userid
  • Index Cond: (clientsharingassignment71.clientid = clients70.id)
323. 303.395 313.720 ↑ 26,776.0 1 1

Result (cost=0.57..10,364.11 rows=26,776 width=0) (actual time=313.720..313.720 rows=1 loops=1)

  • Output: $4, $10, $16, $22, $28, $34, $40, $46
  • Buffers: shared hit=158213 read=1397
324. 0.002 10.325 ↑ 26,776.0 1 1

Append (cost=0.57..10,364.11 rows=26,776 width=0) (actual time=10.325..10.325 rows=1 loops=1)

  • Buffers: shared hit=11587
325. 0.000 10.323 ↑ 1.0 1 1

Subquery Scan on *SELECT* 1 (cost=0.57..5,735.86 rows=1 width=0) (actual time=10.323..10.323 rows=1 loops=1)

  • Buffers: shared hit=11587
326. 0.005 10.323 ↑ 1.0 1 1

Merge Anti Join (cost=0.57..5,735.85 rows=1 width=0) (actual time=10.323..10.323 rows=1 loops=1)

  • Output: NULL::integer, 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), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::interval, NULL::interval, 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=11587
327. 0.009 0.009 ↑ 8,442.0 1 1

Index Only Scan using dm_projectlist_facts_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_facts (cost=0.29..814.91 rows=8,442 width=4) (actual time=0.009..0.009 rows=1 loops=1)

  • Output: dm_projectlist_facts.projectid
  • Heap Fetches: 1
  • Buffers: shared hit=3
328. 10.309 10.309 ↓ 0.0 0 1

Index Only Scan using dm_projectlist_realtime_facts_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_realtime_facts (cost=0.29..4,681.54 rows=53,550 width=4) (actual time=10.309..10.309 rows=0 loops=1)

  • Output: dm_projectlist_realtime_facts.projectid
  • Heap Fetches: 12484
  • Buffers: shared hit=11584
329. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2 (cost=0.00..4,628.25 rows=26,775 width=0) (never executed)

330. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_realtime_facts dm_projectlist_realtime_facts_1 (cost=0.00..4,360.50 rows=26,775 width=0) (never executed)

  • Output: NULL::integer, 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), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), NULL::interval, NULL::interval, 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)
Planning time : 9.230 ms
Execution time : 315.791 ms