explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 61lk : Q1

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 450,786.121 ↑ 1.0 1 1

Limit (cost=56,255.37..56,255.76 rows=1 width=0) (actual time=450,786.120..450,786.121 rows=1 loops=1)

  • Output: ($6), ($14), ($22), ($30), ($38), ($46), ($54), ($62)
  • Buffers: shared hit=400273003 read=2111 dirtied=26
2.          

Initplan (forLimit)

3. 6.535 230,560.165 ↑ 1.0 1 1

Aggregate (cost=12,311.71..12,311.72 rows=1 width=0) (actual time=230,560.164..230,560.165 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=200106920 read=1859
4. 10.766 230,553.630 ↑ 1.5 15,150 1

Append (cost=768.76..12,253.42 rows=23,313 width=0) (actual time=230,472.293..230,553.630 rows=15,150 loops=1)

  • Buffers: shared hit=200106920 read=1859
5. 66.327 230,525.815 ↓ 15,150.0 15,150 1

Subquery Scan on *SELECT* 1_1 (cost=768.76..6,524.63 rows=1 width=0) (actual time=230,472.292..230,525.815 rows=15,150 loops=1)

  • Filter: ((hashed SubPlan 1) OR (hashed SubPlan 2) OR (hashed SubPlan 3))
  • Buffers: shared hit=200104317 read=637
6. 17.168 47.483 ↓ 15,150.0 15,150 1

Merge Anti Join (cost=0.57..5,756.43 rows=1 width=4) (actual time=10.919..47.483 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=20211 read=637
7. 19.416 19.416 ↓ 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..19.416 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=8627 read=637
8. 10.899 10.899 ↓ 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=10.899..10.899 rows=0 loops=1)

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

SubPlan (forSubquery Scan)

10. 62,393.016 230,412.005 ↓ 15,150.0 15,150 1

Nested Loop (cost=0.50..4.54 rows=1 width=4) (actual time=0.036..230,412.005 rows=15,150 loops=1)

  • Output: project1.id
  • Join Filter: (project1.id = project2.id)
  • Rows Removed by Join Filter: 229507350
  • Buffers: shared hit=200084106
11. 20.639 20.639 ↓ 15,150.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project1 (cost=0.25..2.26 rows=1 width=4) (actual time=0.019..20.639 rows=15,150 loops=1)

  • Output: project1.id
  • Heap Fetches: 25031
  • Buffers: shared hit=13206
12. 167,998.350 167,998.350 ↓ 15,150.0 15,150 15,150

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project2 (cost=0.25..2.26 rows=1 width=4) (actual time=0.007..11.089 rows=15,150 loops=15,150)

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

Nested Loop Left Join (cost=0.41..11.78 rows=1 width=4) (never executed)

  • Output: project3.id
  • 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.25..2.26 rows=1 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..9.35 rows=11 width=8) (never executed)

  • Output: projectsharingassignment4.projectid, projectsharingassignment4.userid
  • Index Cond: (projectsharingassignment4.projectid = project3.id)
  • Heap Fetches: 0
16. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=10.28..751.68 rows=70 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

Nested Loop Left Join (cost=0.54..738.06 rows=891 width=8) (never executed)

  • Output: project5.id, projectclient6.clientid
18. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project5 (cost=0.25..2.26 rows=1 width=4) (never executed)

  • Output: project5.id
  • Heap Fetches: 0
19. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient6 (cost=0.29..726.89 rows=891 width=8) (never executed)

  • Output: projectclient6.projectid, projectclient6.clientid, projectclient6.effectivedate, projectclient6.enddate
  • Index Cond: (projectclient6.projectid = project5.id)
  • Heap Fetches: 0
20. 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
21. 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
22. 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
23. 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)
24. 0.000 17.049 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_1 (cost=768.18..5,728.79 rows=23,312 width=0) (actual time=17.049..17.049 rows=0 loops=1)

  • Filter: ((hashed SubPlan 1) OR (hashed SubPlan 2) OR (hashed SubPlan 3))
  • Buffers: shared hit=2603 read=1222
25. 17.047 17.047 ↓ 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=17.047..17.047 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
26.          

SubPlan (forSubquery Scan)

27. 62,393.016 230,412.005 ↓ 15,150.0 15,150 1

Nested Loop (cost=0.50..4.54 rows=1 width=4) (actual time=0.036..230,412.005 rows=15,150 loops=1)

  • Output: project1.id
  • Join Filter: (project1.id = project2.id)
  • Rows Removed by Join Filter: 229507350
  • Buffers: shared hit=200084106
28. 20.639 20.639 ↓ 15,150.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project1 (cost=0.25..2.26 rows=1 width=4) (actual time=0.019..20.639 rows=15,150 loops=1)

  • Output: project1.id
  • Heap Fetches: 25031
  • Buffers: shared hit=13206
29. 167,998.350 167,998.350 ↓ 15,150.0 15,150 15,150

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project2 (cost=0.25..2.26 rows=1 width=4) (actual time=0.007..11.089 rows=15,150 loops=15,150)

  • Output: project2.id
  • Heap Fetches: 379219650
  • Buffers: shared hit=200070900
30. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.41..11.78 rows=1 width=4) (never executed)

  • Output: project3.id
  • Filter: ((project3.projectleaderapproverid = 2) OR (projectsharingassignment4.userid = 2))
31. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project3 (cost=0.25..2.26 rows=1 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
32. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment4 (cost=0.15..9.35 rows=11 width=8) (never executed)

  • Output: projectsharingassignment4.projectid, projectsharingassignment4.userid
  • Index Cond: (projectsharingassignment4.projectid = project3.id)
  • Heap Fetches: 0
33. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=10.28..751.68 rows=70 width=4) (never executed)

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

Nested Loop Left Join (cost=0.54..738.06 rows=891 width=8) (never executed)

  • Output: project5.id, projectclient6.clientid
35. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project5 (cost=0.25..2.26 rows=1 width=4) (never executed)

  • Output: project5.id
  • Heap Fetches: 0
36. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient6 (cost=0.29..726.89 rows=891 width=8) (never executed)

  • Output: projectclient6.projectid, projectclient6.clientid, projectclient6.effectivedate, projectclient6.enddate
  • Index Cond: (projectclient6.projectid = project5.id)
  • Heap Fetches: 0
37. 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
38. 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
39. 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
40. 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)
41. 0.002 5.741 ↑ 1.0 1 1

Aggregate (cost=6,296.71..6,296.72 rows=1 width=0) (actual time=5.741..5.741 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=3825 read=2
42. 0.003 5.739 ↓ 0.0 0 1

Append (cost=768.76..6,296.42 rows=117 width=0) (actual time=5.739..5.739 rows=0 loops=1)

  • Buffers: shared hit=3825 read=2
43. 0.001 0.022 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1_2 (cost=768.76..897.66 rows=1 width=0) (actual time=0.022..0.022 rows=0 loops=1)

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

Nested Loop Anti Join (cost=0.57..129.46 rows=1 width=4) (actual time=0.021..0.021 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
45. 0.019 0.019 ↓ 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.019..0.019 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
46. 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
47.          

SubPlan (forSubquery Scan)

48. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.50..4.54 rows=1 width=4) (never executed)

  • Output: project10.id
  • Join Filter: (project10.id = project11.id)
49. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project10 (cost=0.25..2.26 rows=1 width=4) (never executed)

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

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project11 (cost=0.25..2.26 rows=1 width=4) (never executed)

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

Nested Loop Left Join (cost=0.41..11.78 rows=1 width=4) (never executed)

  • Output: project12.id
  • Filter: ((project12.projectleaderapproverid = 2) OR (projectsharingassignment13.userid = 2))
52. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project12 (cost=0.25..2.26 rows=1 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
53. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment13 (cost=0.15..9.35 rows=11 width=8) (never executed)

  • Output: projectsharingassignment13.projectid, projectsharingassignment13.userid
  • Index Cond: (projectsharingassignment13.projectid = project12.id)
  • Heap Fetches: 0
54. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=10.28..751.68 rows=70 width=4) (never executed)

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

Nested Loop Left Join (cost=0.54..738.06 rows=891 width=8) (never executed)

  • Output: project14.id, projectclient15.clientid
56. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project14 (cost=0.25..2.26 rows=1 width=4) (never executed)

  • Output: project14.id
  • Heap Fetches: 0
57. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient15 (cost=0.29..726.89 rows=891 width=8) (never executed)

  • Output: projectclient15.projectid, projectclient15.clientid, projectclient15.effectivedate, projectclient15.enddate
  • Index Cond: (projectclient15.projectid = project14.id)
  • Heap Fetches: 0
58. 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
59. 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
60. 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
61. 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)
62. 0.001 5.714 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_2 (cost=768.18..5,398.76 rows=116 width=0) (actual time=5.714..5.714 rows=0 loops=1)

  • Filter: ((hashed SubPlan 5) OR (hashed SubPlan 6) OR (hashed SubPlan 7))
  • Buffers: shared hit=3825
63. 5.713 5.713 ↓ 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.713..5.713 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
64.          

SubPlan (forSubquery Scan)

65. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.50..4.54 rows=1 width=4) (never executed)

  • Output: project10.id
  • Join Filter: (project10.id = project11.id)
66. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project10 (cost=0.25..2.26 rows=1 width=4) (never executed)

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

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project11 (cost=0.25..2.26 rows=1 width=4) (never executed)

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

Nested Loop Left Join (cost=0.41..11.78 rows=1 width=4) (never executed)

  • Output: project12.id
  • Filter: ((project12.projectleaderapproverid = 2) OR (projectsharingassignment13.userid = 2))
69. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project12 (cost=0.25..2.26 rows=1 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
70. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment13 (cost=0.15..9.35 rows=11 width=8) (never executed)

  • Output: projectsharingassignment13.projectid, projectsharingassignment13.userid
  • Index Cond: (projectsharingassignment13.projectid = project12.id)
  • Heap Fetches: 0
71. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=10.28..751.68 rows=70 width=4) (never executed)

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

Nested Loop Left Join (cost=0.54..738.06 rows=891 width=8) (never executed)

  • Output: project14.id, projectclient15.clientid
73. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project14 (cost=0.25..2.26 rows=1 width=4) (never executed)

  • Output: project14.id
  • Heap Fetches: 0
74. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient15 (cost=0.29..726.89 rows=891 width=8) (never executed)

  • Output: projectclient15.projectid, projectclient15.clientid, projectclient15.effectivedate, projectclient15.enddate
  • Index Cond: (projectclient15.projectid = project14.id)
  • Heap Fetches: 0
75. 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
76. 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
77. 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
78. 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)
79. 0.003 4.561 ↑ 1.0 1 1

Aggregate (cost=6,296.71..6,296.72 rows=1 width=0) (actual time=4.561..4.561 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=3825 read=2
80. 0.000 4.558 ↓ 0.0 0 1

Append (cost=768.76..6,296.42 rows=117 width=0) (actual time=4.558..4.558 rows=0 loops=1)

  • Buffers: shared hit=3825 read=2
81. 0.001 0.021 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1_3 (cost=768.76..897.66 rows=1 width=0) (actual time=0.021..0.021 rows=0 loops=1)

  • Filter: ((hashed SubPlan 9) OR (hashed SubPlan 10) OR (hashed SubPlan 11))
  • Buffers: shared read=2
82. 0.002 0.020 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.57..129.46 rows=1 width=4) (actual time=0.020..0.020 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
83. 0.018 0.018 ↓ 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.018..0.018 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
84. 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
85.          

SubPlan (forSubquery Scan)

86. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.50..4.54 rows=1 width=4) (never executed)

  • Output: project19.id
  • Join Filter: (project19.id = project20.id)
87. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project19 (cost=0.25..2.26 rows=1 width=4) (never executed)

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

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project20 (cost=0.25..2.26 rows=1 width=4) (never executed)

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

Nested Loop Left Join (cost=0.41..11.78 rows=1 width=4) (never executed)

  • Output: project21.id
  • Filter: ((project21.projectleaderapproverid = 2) OR (projectsharingassignment22.userid = 2))
90. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project21 (cost=0.25..2.26 rows=1 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
91. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment22 (cost=0.15..9.35 rows=11 width=8) (never executed)

  • Output: projectsharingassignment22.projectid, projectsharingassignment22.userid
  • Index Cond: (projectsharingassignment22.projectid = project21.id)
  • Heap Fetches: 0
92. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=10.28..751.68 rows=70 width=4) (never executed)

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

Nested Loop Left Join (cost=0.54..738.06 rows=891 width=8) (never executed)

  • Output: project23.id, projectclient24.clientid
94. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project23 (cost=0.25..2.26 rows=1 width=4) (never executed)

  • Output: project23.id
  • Heap Fetches: 0
95. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient24 (cost=0.29..726.89 rows=891 width=8) (never executed)

  • Output: projectclient24.projectid, projectclient24.clientid, projectclient24.effectivedate, projectclient24.enddate
  • Index Cond: (projectclient24.projectid = project23.id)
  • Heap Fetches: 0
96. 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
97. 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
98. 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
99. 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)
100. 0.001 4.537 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_3 (cost=768.18..5,398.76 rows=116 width=0) (actual time=4.537..4.537 rows=0 loops=1)

  • Filter: ((hashed SubPlan 9) OR (hashed SubPlan 10) OR (hashed SubPlan 11))
  • Buffers: shared hit=3825
101. 4.536 4.536 ↓ 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=4.536..4.536 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
102.          

SubPlan (forSubquery Scan)

103. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.50..4.54 rows=1 width=4) (never executed)

  • Output: project19.id
  • Join Filter: (project19.id = project20.id)
104. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project19 (cost=0.25..2.26 rows=1 width=4) (never executed)

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

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project20 (cost=0.25..2.26 rows=1 width=4) (never executed)

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

Nested Loop Left Join (cost=0.41..11.78 rows=1 width=4) (never executed)

  • Output: project21.id
  • Filter: ((project21.projectleaderapproverid = 2) OR (projectsharingassignment22.userid = 2))
107. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project21 (cost=0.25..2.26 rows=1 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
108. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment22 (cost=0.15..9.35 rows=11 width=8) (never executed)

  • Output: projectsharingassignment22.projectid, projectsharingassignment22.userid
  • Index Cond: (projectsharingassignment22.projectid = project21.id)
  • Heap Fetches: 0
109. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=10.28..751.68 rows=70 width=4) (never executed)

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

Nested Loop Left Join (cost=0.54..738.06 rows=891 width=8) (never executed)

  • Output: project23.id, projectclient24.clientid
111. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project23 (cost=0.25..2.26 rows=1 width=4) (never executed)

  • Output: project23.id
  • Heap Fetches: 0
112. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient24 (cost=0.29..726.89 rows=891 width=8) (never executed)

  • Output: projectclient24.projectid, projectclient24.clientid, projectclient24.effectivedate, projectclient24.enddate
  • Index Cond: (projectclient24.projectid = project23.id)
  • Heap Fetches: 0
113. 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
114. 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
115. 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
116. 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)
117. 5.339 220,171.754 ↑ 1.0 1 1

Aggregate (cost=6,296.71..6,296.72 rows=1 width=0) (actual time=220,171.754..220,171.754 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=200131538 read=248 dirtied=26
118. 8.791 220,166.415 ↓ 129.5 15,150 1

Append (cost=768.76..6,296.42 rows=117 width=0) (actual time=220,046.513..220,166.415 rows=15,150 loops=1)

  • Buffers: shared hit=200131538 read=248 dirtied=26
119. 59.147 220,145.557 ↓ 15,150.0 15,150 1

Subquery Scan on *SELECT* 1_4 (cost=768.76..897.66 rows=1 width=0) (actual time=220,046.512..220,145.557 rows=15,150 loops=1)

  • Filter: ((hashed SubPlan 13) OR (hashed SubPlan 14) OR (hashed SubPlan 15))
  • Buffers: shared hit=200127713 read=248 dirtied=26
120. 19.880 84.102 ↓ 15,150.0 15,150 1

Nested Loop Anti Join (cost=0.57..129.46 rows=1 width=4) (actual time=0.026..84.102 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=43607 read=248 dirtied=26
121. 18.772 18.772 ↓ 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.008..18.772 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=813 read=198 dirtied=26
122. 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=42794 read=50
123.          

SubPlan (forSubquery Scan)

124. 59,090.421 220,002.308 ↓ 15,150.0 15,150 1

Nested Loop (cost=0.50..4.54 rows=1 width=4) (actual time=0.029..220,002.308 rows=15,150 loops=1)

  • Output: project28.id
  • Join Filter: (project28.id = project29.id)
  • Rows Removed by Join Filter: 229507350
  • Buffers: shared hit=200084106
125. 18.887 18.887 ↓ 15,150.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project28 (cost=0.25..2.26 rows=1 width=4) (actual time=0.011..18.887 rows=15,150 loops=1)

  • Output: project28.id
  • Heap Fetches: 25031
  • Buffers: shared hit=13206
126. 160,893.000 160,893.000 ↓ 15,150.0 15,150 15,150

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project29 (cost=0.25..2.26 rows=1 width=4) (actual time=0.007..10.620 rows=15,150 loops=15,150)

  • Output: project29.id
  • Heap Fetches: 379219650
  • Buffers: shared hit=200070900
127. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.41..11.78 rows=1 width=4) (never executed)

  • Output: project30.id
  • Filter: ((project30.projectleaderapproverid = 2) OR (projectsharingassignment31.userid = 2))
128. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project30 (cost=0.25..2.26 rows=1 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
129. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment31 (cost=0.15..9.35 rows=11 width=8) (never executed)

  • Output: projectsharingassignment31.projectid, projectsharingassignment31.userid
  • Index Cond: (projectsharingassignment31.projectid = project30.id)
  • Heap Fetches: 0
130. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=10.28..751.68 rows=70 width=4) (never executed)

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

Nested Loop Left Join (cost=0.54..738.06 rows=891 width=8) (never executed)

  • Output: project32.id, projectclient33.clientid
132. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project32 (cost=0.25..2.26 rows=1 width=4) (never executed)

  • Output: project32.id
  • Heap Fetches: 0
133. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient33 (cost=0.29..726.89 rows=891 width=8) (never executed)

  • Output: projectclient33.projectid, projectclient33.clientid, projectclient33.effectivedate, projectclient33.enddate
  • Index Cond: (projectclient33.projectid = project32.id)
  • Heap Fetches: 0
134. 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
135. 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
136. 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
137. 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)
138. 0.000 12.067 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_4 (cost=768.18..5,398.76 rows=116 width=0) (actual time=12.067..12.067 rows=0 loops=1)

  • Filter: ((hashed SubPlan 13) OR (hashed SubPlan 14) OR (hashed SubPlan 15))
  • Buffers: shared hit=3825
139. 12.065 12.065 ↓ 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=12.065..12.065 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
140.          

SubPlan (forSubquery Scan)

141. 59,090.421 220,002.308 ↓ 15,150.0 15,150 1

Nested Loop (cost=0.50..4.54 rows=1 width=4) (actual time=0.029..220,002.308 rows=15,150 loops=1)

  • Output: project28.id
  • Join Filter: (project28.id = project29.id)
  • Rows Removed by Join Filter: 229507350
  • Buffers: shared hit=200084106
142. 18.887 18.887 ↓ 15,150.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project28 (cost=0.25..2.26 rows=1 width=4) (actual time=0.011..18.887 rows=15,150 loops=1)

  • Output: project28.id
  • Heap Fetches: 25031
  • Buffers: shared hit=13206
143. 160,893.000 160,893.000 ↓ 15,150.0 15,150 15,150

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project29 (cost=0.25..2.26 rows=1 width=4) (actual time=0.007..10.620 rows=15,150 loops=15,150)

  • Output: project29.id
  • Heap Fetches: 379219650
  • Buffers: shared hit=200070900
144. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.41..11.78 rows=1 width=4) (never executed)

  • Output: project30.id
  • Filter: ((project30.projectleaderapproverid = 2) OR (projectsharingassignment31.userid = 2))
145. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project30 (cost=0.25..2.26 rows=1 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
146. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment31 (cost=0.15..9.35 rows=11 width=8) (never executed)

  • Output: projectsharingassignment31.projectid, projectsharingassignment31.userid
  • Index Cond: (projectsharingassignment31.projectid = project30.id)
  • Heap Fetches: 0
147. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=10.28..751.68 rows=70 width=4) (never executed)

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

Nested Loop Left Join (cost=0.54..738.06 rows=891 width=8) (never executed)

  • Output: project32.id, projectclient33.clientid
149. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project32 (cost=0.25..2.26 rows=1 width=4) (never executed)

  • Output: project32.id
  • Heap Fetches: 0
150. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient33 (cost=0.29..726.89 rows=891 width=8) (never executed)

  • Output: projectclient33.projectid, projectclient33.clientid, projectclient33.effectivedate, projectclient33.enddate
  • Index Cond: (projectclient33.projectid = project32.id)
  • Heap Fetches: 0
151. 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
152. 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
153. 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
154. 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)
155. 0.003 11.000 ↑ 1.0 1 1

Aggregate (cost=6,296.71..6,296.72 rows=1 width=0) (actual time=11.000..11.000 rows=1 loops=1)

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

Append (cost=768.76..6,296.42 rows=117 width=0) (actual time=10.997..10.997 rows=0 loops=1)

  • Buffers: shared hit=3827
157. 0.002 0.010 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1_5 (cost=768.76..897.66 rows=1 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Filter: ((hashed SubPlan 17) OR (hashed SubPlan 18) OR (hashed SubPlan 19))
  • Buffers: shared hit=2
158. 0.001 0.008 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.57..129.46 rows=1 width=4) (actual time=0.008..0.008 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
159. 0.007 0.007 ↓ 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.007..0.007 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
160. 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
161.          

SubPlan (forSubquery Scan)

162. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.50..4.54 rows=1 width=4) (never executed)

  • Output: project37.id
  • Join Filter: (project37.id = project38.id)
163. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project37 (cost=0.25..2.26 rows=1 width=4) (never executed)

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

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project38 (cost=0.25..2.26 rows=1 width=4) (never executed)

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

Nested Loop Left Join (cost=0.41..11.78 rows=1 width=4) (never executed)

  • Output: project39.id
  • Filter: ((project39.projectleaderapproverid = 2) OR (projectsharingassignment40.userid = 2))
166. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project39 (cost=0.25..2.26 rows=1 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
167. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment40 (cost=0.15..9.35 rows=11 width=8) (never executed)

  • Output: projectsharingassignment40.projectid, projectsharingassignment40.userid
  • Index Cond: (projectsharingassignment40.projectid = project39.id)
  • Heap Fetches: 0
168. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=10.28..751.68 rows=70 width=4) (never executed)

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

Nested Loop Left Join (cost=0.54..738.06 rows=891 width=8) (never executed)

  • Output: project41.id, projectclient42.clientid
170. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project41 (cost=0.25..2.26 rows=1 width=4) (never executed)

  • Output: project41.id
  • Heap Fetches: 0
171. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient42 (cost=0.29..726.89 rows=891 width=8) (never executed)

  • Output: projectclient42.projectid, projectclient42.clientid, projectclient42.effectivedate, projectclient42.enddate
  • Index Cond: (projectclient42.projectid = project41.id)
  • Heap Fetches: 0
172. 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
173. 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
174. 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
175. 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)
176. 0.002 10.984 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_5 (cost=768.18..5,398.76 rows=116 width=0) (actual time=10.984..10.984 rows=0 loops=1)

  • Filter: ((hashed SubPlan 17) OR (hashed SubPlan 18) OR (hashed SubPlan 19))
  • Buffers: shared hit=3825
177. 10.982 10.982 ↓ 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=10.982..10.982 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
178.          

SubPlan (forSubquery Scan)

179. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.50..4.54 rows=1 width=4) (never executed)

  • Output: project37.id
  • Join Filter: (project37.id = project38.id)
180. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project37 (cost=0.25..2.26 rows=1 width=4) (never executed)

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

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project38 (cost=0.25..2.26 rows=1 width=4) (never executed)

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

Nested Loop Left Join (cost=0.41..11.78 rows=1 width=4) (never executed)

  • Output: project39.id
  • Filter: ((project39.projectleaderapproverid = 2) OR (projectsharingassignment40.userid = 2))
183. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project39 (cost=0.25..2.26 rows=1 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
184. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment40 (cost=0.15..9.35 rows=11 width=8) (never executed)

  • Output: projectsharingassignment40.projectid, projectsharingassignment40.userid
  • Index Cond: (projectsharingassignment40.projectid = project39.id)
  • Heap Fetches: 0
185. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=10.28..751.68 rows=70 width=4) (never executed)

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

Nested Loop Left Join (cost=0.54..738.06 rows=891 width=8) (never executed)

  • Output: project41.id, projectclient42.clientid
187. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project41 (cost=0.25..2.26 rows=1 width=4) (never executed)

  • Output: project41.id
  • Heap Fetches: 0
188. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient42 (cost=0.29..726.89 rows=891 width=8) (never executed)

  • Output: projectclient42.projectid, projectclient42.clientid, projectclient42.effectivedate, projectclient42.enddate
  • Index Cond: (projectclient42.projectid = project41.id)
  • Heap Fetches: 0
189. 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
190. 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
191. 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
192. 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)
193. 0.003 9.922 ↑ 1.0 1 1

Aggregate (cost=6,296.71..6,296.72 rows=1 width=0) (actual time=9.922..9.922 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=3827
194. 0.000 9.919 ↓ 0.0 0 1

Append (cost=768.76..6,296.42 rows=117 width=0) (actual time=9.919..9.919 rows=0 loops=1)

  • Buffers: shared hit=3827
195. 0.002 0.009 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1_6 (cost=768.76..897.66 rows=1 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: ((hashed SubPlan 21) OR (hashed SubPlan 22) OR (hashed SubPlan 23))
  • Buffers: shared hit=2
196. 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_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
197. 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
198. 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
199.          

SubPlan (forSubquery Scan)

200. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.50..4.54 rows=1 width=4) (never executed)

  • Output: project46.id
  • Join Filter: (project46.id = project47.id)
201. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project46 (cost=0.25..2.26 rows=1 width=4) (never executed)

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

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project47 (cost=0.25..2.26 rows=1 width=4) (never executed)

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

Nested Loop Left Join (cost=0.41..11.78 rows=1 width=4) (never executed)

  • Output: project48.id
  • Filter: ((project48.projectleaderapproverid = 2) OR (projectsharingassignment49.userid = 2))
204. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project48 (cost=0.25..2.26 rows=1 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
205. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment49 (cost=0.15..9.35 rows=11 width=8) (never executed)

  • Output: projectsharingassignment49.projectid, projectsharingassignment49.userid
  • Index Cond: (projectsharingassignment49.projectid = project48.id)
  • Heap Fetches: 0
206. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=10.28..751.68 rows=70 width=4) (never executed)

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

Nested Loop Left Join (cost=0.54..738.06 rows=891 width=8) (never executed)

  • Output: project50.id, projectclient51.clientid
208. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project50 (cost=0.25..2.26 rows=1 width=4) (never executed)

  • Output: project50.id
  • Heap Fetches: 0
209. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient51 (cost=0.29..726.89 rows=891 width=8) (never executed)

  • Output: projectclient51.projectid, projectclient51.clientid, projectclient51.effectivedate, projectclient51.enddate
  • Index Cond: (projectclient51.projectid = project50.id)
  • Heap Fetches: 0
210. 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
211. 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
212. 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
213. 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)
214. 0.002 9.910 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_6 (cost=768.18..5,398.76 rows=116 width=0) (actual time=9.910..9.910 rows=0 loops=1)

  • Filter: ((hashed SubPlan 21) OR (hashed SubPlan 22) OR (hashed SubPlan 23))
  • Buffers: shared hit=3825
215. 9.908 9.908 ↓ 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.908..9.908 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
216.          

SubPlan (forSubquery Scan)

217. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.50..4.54 rows=1 width=4) (never executed)

  • Output: project46.id
  • Join Filter: (project46.id = project47.id)
218. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project46 (cost=0.25..2.26 rows=1 width=4) (never executed)

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

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project47 (cost=0.25..2.26 rows=1 width=4) (never executed)

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

Nested Loop Left Join (cost=0.41..11.78 rows=1 width=4) (never executed)

  • Output: project48.id
  • Filter: ((project48.projectleaderapproverid = 2) OR (projectsharingassignment49.userid = 2))
221. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project48 (cost=0.25..2.26 rows=1 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
222. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment49 (cost=0.15..9.35 rows=11 width=8) (never executed)

  • Output: projectsharingassignment49.projectid, projectsharingassignment49.userid
  • Index Cond: (projectsharingassignment49.projectid = project48.id)
  • Heap Fetches: 0
223. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=10.28..751.68 rows=70 width=4) (never executed)

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

Nested Loop Left Join (cost=0.54..738.06 rows=891 width=8) (never executed)

  • Output: project50.id, projectclient51.clientid
225. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project50 (cost=0.25..2.26 rows=1 width=4) (never executed)

  • Output: project50.id
  • Heap Fetches: 0
226. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient51 (cost=0.29..726.89 rows=891 width=8) (never executed)

  • Output: projectclient51.projectid, projectclient51.clientid, projectclient51.effectivedate, projectclient51.enddate
  • Index Cond: (projectclient51.projectid = project50.id)
  • Heap Fetches: 0
227. 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
228. 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
229. 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
230. 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)
231. 0.002 6.220 ↑ 1.0 1 1

Aggregate (cost=6,296.71..6,296.72 rows=1 width=0) (actual time=6.220..6.220 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=3827
232. 0.001 6.218 ↓ 0.0 0 1

Append (cost=768.76..6,296.42 rows=117 width=0) (actual time=6.218..6.218 rows=0 loops=1)

  • Buffers: shared hit=3827
233. 0.001 0.006 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1_7 (cost=768.76..897.66 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: ((hashed SubPlan 25) OR (hashed SubPlan 26) OR (hashed SubPlan 27))
  • Buffers: shared hit=2
234. 0.001 0.005 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.57..129.46 rows=1 width=4) (actual time=0.005..0.005 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
235. 0.004 0.004 ↓ 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.004..0.004 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
236. 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
237.          

SubPlan (forSubquery Scan)

238. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.50..4.54 rows=1 width=4) (never executed)

  • Output: project55.id
  • Join Filter: (project55.id = project56.id)
239. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project55 (cost=0.25..2.26 rows=1 width=4) (never executed)

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

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project56 (cost=0.25..2.26 rows=1 width=4) (never executed)

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

Nested Loop Left Join (cost=0.41..11.78 rows=1 width=4) (never executed)

  • Output: project57.id
  • Filter: ((project57.projectleaderapproverid = 2) OR (projectsharingassignment58.userid = 2))
242. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project57 (cost=0.25..2.26 rows=1 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
243. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment58 (cost=0.15..9.35 rows=11 width=8) (never executed)

  • Output: projectsharingassignment58.projectid, projectsharingassignment58.userid
  • Index Cond: (projectsharingassignment58.projectid = project57.id)
  • Heap Fetches: 0
244. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=10.28..751.68 rows=70 width=4) (never executed)

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

Nested Loop Left Join (cost=0.54..738.06 rows=891 width=8) (never executed)

  • Output: project59.id, projectclient60.clientid
246. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project59 (cost=0.25..2.26 rows=1 width=4) (never executed)

  • Output: project59.id
  • Heap Fetches: 0
247. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient60 (cost=0.29..726.89 rows=891 width=8) (never executed)

  • Output: projectclient60.projectid, projectclient60.clientid, projectclient60.effectivedate, projectclient60.enddate
  • Index Cond: (projectclient60.projectid = project59.id)
  • Heap Fetches: 0
248. 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
249. 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
250. 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
251. 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)
252. 0.001 6.211 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_7 (cost=768.18..5,398.76 rows=116 width=0) (actual time=6.211..6.211 rows=0 loops=1)

  • Filter: ((hashed SubPlan 25) OR (hashed SubPlan 26) OR (hashed SubPlan 27))
  • Buffers: shared hit=3825
253. 6.210 6.210 ↓ 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=6.210..6.210 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
254.          

SubPlan (forSubquery Scan)

255. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.50..4.54 rows=1 width=4) (never executed)

  • Output: project55.id
  • Join Filter: (project55.id = project56.id)
256. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project55 (cost=0.25..2.26 rows=1 width=4) (never executed)

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

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project56 (cost=0.25..2.26 rows=1 width=4) (never executed)

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

Nested Loop Left Join (cost=0.41..11.78 rows=1 width=4) (never executed)

  • Output: project57.id
  • Filter: ((project57.projectleaderapproverid = 2) OR (projectsharingassignment58.userid = 2))
259. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project57 (cost=0.25..2.26 rows=1 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
260. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment58 (cost=0.15..9.35 rows=11 width=8) (never executed)

  • Output: projectsharingassignment58.projectid, projectsharingassignment58.userid
  • Index Cond: (projectsharingassignment58.projectid = project57.id)
  • Heap Fetches: 0
261. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=10.28..751.68 rows=70 width=4) (never executed)

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

Nested Loop Left Join (cost=0.54..738.06 rows=891 width=8) (never executed)

  • Output: project59.id, projectclient60.clientid
263. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project59 (cost=0.25..2.26 rows=1 width=4) (never executed)

  • Output: project59.id
  • Heap Fetches: 0
264. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient60 (cost=0.29..726.89 rows=891 width=8) (never executed)

  • Output: projectclient60.projectid, projectclient60.clientid, projectclient60.effectivedate, projectclient60.enddate
  • Index Cond: (projectclient60.projectid = project59.id)
  • Heap Fetches: 0
265. 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
266. 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
267. 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
268. 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)
269. 0.002 5.541 ↑ 1.0 1 1

Aggregate (cost=6,162.75..6,162.76 rows=1 width=0) (actual time=5.541..5.541 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=3827
270. 0.002 5.539 ↓ 0.0 0 1

Append (cost=768.76..6,162.45 rows=118 width=0) (actual time=5.539..5.539 rows=0 loops=1)

  • Buffers: shared hit=3827
271. 0.001 0.005 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1_8 (cost=768.76..897.55 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: ((hashed SubPlan 29) OR (hashed SubPlan 30) OR (hashed SubPlan 31))
  • Buffers: shared hit=2
272. 0.001 0.004 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.57..129.35 rows=1 width=4) (actual time=0.004..0.004 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
273. 0.003 0.003 ↓ 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.003..0.003 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
274. 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
275.          

SubPlan (forSubquery Scan)

276. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.50..4.54 rows=1 width=4) (never executed)

  • Output: project64.id
  • Join Filter: (project64.id = project65.id)
277. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project64 (cost=0.25..2.26 rows=1 width=4) (never executed)

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

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project65 (cost=0.25..2.26 rows=1 width=4) (never executed)

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

Nested Loop Left Join (cost=0.41..11.78 rows=1 width=4) (never executed)

  • Output: project66.id
  • Filter: ((project66.projectleaderapproverid = 2) OR (projectsharingassignment67.userid = 2))
280. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project66 (cost=0.25..2.26 rows=1 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
281. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment67 (cost=0.15..9.35 rows=11 width=8) (never executed)

  • Output: projectsharingassignment67.projectid, projectsharingassignment67.userid
  • Index Cond: (projectsharingassignment67.projectid = project66.id)
  • Heap Fetches: 0
282. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=10.28..751.68 rows=70 width=4) (never executed)

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

Nested Loop Left Join (cost=0.54..738.06 rows=891 width=8) (never executed)

  • Output: project68.id, projectclient69.clientid
284. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project68 (cost=0.25..2.26 rows=1 width=4) (never executed)

  • Output: project68.id
  • Heap Fetches: 0
285. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient69 (cost=0.29..726.89 rows=891 width=8) (never executed)

  • Output: projectclient69.projectid, projectclient69.clientid, projectclient69.effectivedate, projectclient69.enddate
  • Index Cond: (projectclient69.projectid = project68.id)
  • Heap Fetches: 0
286. 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
287. 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
288. 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
289. 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)
290. 0.000 5.532 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_8 (cost=768.18..5,264.90 rows=117 width=0) (actual time=5.532..5.532 rows=0 loops=1)

  • Filter: ((hashed SubPlan 29) OR (hashed SubPlan 30) OR (hashed SubPlan 31))
  • Buffers: shared hit=3825
291. 5.532 5.532 ↓ 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=5.532..5.532 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
292.          

SubPlan (forSubquery Scan)

293. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.50..4.54 rows=1 width=4) (never executed)

  • Output: project64.id
  • Join Filter: (project64.id = project65.id)
294. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project64 (cost=0.25..2.26 rows=1 width=4) (never executed)

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

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project65 (cost=0.25..2.26 rows=1 width=4) (never executed)

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

Nested Loop Left Join (cost=0.41..11.78 rows=1 width=4) (never executed)

  • Output: project66.id
  • Filter: ((project66.projectleaderapproverid = 2) OR (projectsharingassignment67.userid = 2))
297. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project66 (cost=0.25..2.26 rows=1 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
298. 0.000 0.000 ↓ 0.0 0

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment67 (cost=0.15..9.35 rows=11 width=8) (never executed)

  • Output: projectsharingassignment67.projectid, projectsharingassignment67.userid
  • Index Cond: (projectsharingassignment67.projectid = project66.id)
  • Heap Fetches: 0
299. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=10.28..751.68 rows=70 width=4) (never executed)

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

Nested Loop Left Join (cost=0.54..738.06 rows=891 width=8) (never executed)

  • Output: project68.id, projectclient69.clientid
301. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project68 (cost=0.25..2.26 rows=1 width=4) (never executed)

  • Output: project68.id
  • Heap Fetches: 0
302. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient69 (cost=0.29..726.89 rows=891 width=8) (never executed)

  • Output: projectclient69.projectid, projectclient69.clientid, projectclient69.effectivedate, projectclient69.enddate
  • Index Cond: (projectclient69.projectid = project68.id)
  • Heap Fetches: 0
303. 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
304. 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
305. 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
306. 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)
307. 450,774.931 450,786.119 ↑ 26,776.0 1 1

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

  • Output: $6, $14, $22, $30, $38, $46, $54, $62
  • Buffers: shared hit=400273003 read=2111 dirtied=26
308. 0.000 11.188 ↑ 26,776.0 1 1

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

  • Buffers: shared hit=11587
309. 0.002 11.188 ↑ 1.0 1 1

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

  • Buffers: shared hit=11587
310. 0.004 11.186 ↑ 1.0 1 1

Merge Anti Join (cost=0.57..5,735.85 rows=1 width=0) (actual time=11.186..11.186 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
311. 0.016 0.016 ↑ 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.016..0.016 rows=1 loops=1)

  • Output: dm_projectlist_facts.projectid
  • Heap Fetches: 1
  • Buffers: shared hit=3
312. 11.166 11.166 ↓ 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=11.166..11.166 rows=0 loops=1)

  • Output: dm_projectlist_realtime_facts.projectid
  • Heap Fetches: 12484
  • Buffers: shared hit=11584
313. 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)

314. 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 : 12.024 ms
Execution time : 450,788.708 ms