explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uMNj

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 1,592.562 ↑ 1.0 20 1

Limit (cost=604,696.01..604,696.06 rows=20 width=236) (actual time=1,592.536..1,592.562 rows=20 loops=1)

  • Output: "*SELECT* 1".projectid, "*SELECT* 1".projectid, (("*SELECT* 1".name)::text), (("*SELECT* 1".slug)::text), (("*SELECT* 1".code)::text), (("*SELECT* 1".name)::text), "*SELECT* 1".statustype, (CASE WHEN (hashed SubPlan 3) THEN (SubPlan 4) ELSE NULL::character varying END), (CASE WHEN (hashed SubPlan 7) THEN (SubPlan 8) ELSE NULL::integer END), (CASE WHEN (hashed SubPlan 11) THEN (SubPlan 12) ELSE NULL::character varying END), "*SELECT* 1".projectleaderid, (("*SELECT* 1".projectleaderdisplayname)::text), (("*SELECT* 1".projectleaderslug)::text), "*SELECT* 1".startdate, "*SELECT* 1".enddate, "*SELECT* 1".totalactualhours, (CASE WHEN (hashed SubPlan 15) THEN "*SELECT* 1".totalactualcostinbasecurrency ELSE NULL::numeric END), (CASE WHEN (hashed SubPlan 18) THEN "*SELECT* 1".totalactualbillinginbasecurrency ELSE NULL::numeric END), (CASE WHEN (hashed SubPlan 21) THEN (SubPlan 22) ELSE NULL::bigint END), (CASE WHEN (hashed SubPlan 25) THEN (SubPlan 26) ELSE NULL::date END), (CASE WHEN (hashed SubPlan 29) THEN (SubPlan 30) ELSE NULL::integer END)
  • Buffers: shared hit=791617
2. 19.841 1,592.544 ↑ 1,165.7 20 1

Sort (cost=604,696.01..604,754.29 rows=23,313 width=236) (actual time=1,592.534..1,592.544 rows=20 loops=1)

  • Output: "*SELECT* 1".projectid, "*SELECT* 1".projectid, (("*SELECT* 1".name)::text), (("*SELECT* 1".slug)::text), (("*SELECT* 1".code)::text), (("*SELECT* 1".name)::text), "*SELECT* 1".statustype, (CASE WHEN (hashed SubPlan 3) THEN (SubPlan 4) ELSE NULL::character varying END), (CASE WHEN (hashed SubPlan 7) THEN (SubPlan 8) ELSE NULL::integer END), (CASE WHEN (hashed SubPlan 11) THEN (SubPlan 12) ELSE NULL::character varying END), "*SELECT* 1".projectleaderid, (("*SELECT* 1".projectleaderdisplayname)::text), (("*SELECT* 1".projectleaderslug)::text), "*SELECT* 1".startdate, "*SELECT* 1".enddate, "*SELECT* 1".totalactualhours, (CASE WHEN (hashed SubPlan 15) THEN "*SELECT* 1".totalactualcostinbasecurrency ELSE NULL::numeric END), (CASE WHEN (hashed SubPlan 18) THEN "*SELECT* 1".totalactualbillinginbasecurrency ELSE NULL::numeric END), (CASE WHEN (hashed SubPlan 21) THEN (SubPlan 22) ELSE NULL::bigint END), (CASE WHEN (hashed SubPlan 25) THEN (SubPlan 26) ELSE NULL::date END), (CASE WHEN (hashed SubPlan 29) THEN (SubPlan 30) ELSE NULL::integer END)
  • Sort Key: (("*SELECT* 1".name)::text) COLLATE "en_US", "*SELECT* 1".projectid
  • Sort Method: top-N heapsort Memory: 32kB
  • Buffers: shared hit=791617
3. 228.766 1,572.703 ↑ 1.5 15,150 1

Result (cost=98,081.46..604,075.66 rows=23,313 width=236) (actual time=781.652..1,572.703 rows=15,150 loops=1)

  • Output: "*SELECT* 1".projectid, "*SELECT* 1".projectid, "*SELECT* 1".name, "*SELECT* 1".slug, "*SELECT* 1".code, "*SELECT* 1".name, "*SELECT* 1".statustype, CASE WHEN (hashed SubPlan 3) THEN (SubPlan 4) ELSE NULL::character varying END, CASE WHEN (hashed SubPlan 7) THEN (SubPlan 8) ELSE NULL::integer END, CASE WHEN (hashed SubPlan 11) THEN (SubPlan 12) ELSE NULL::character varying END, "*SELECT* 1".projectleaderid, "*SELECT* 1".projectleaderdisplayname, "*SELECT* 1".projectleaderslug, "*SELECT* 1".startdate, "*SELECT* 1".enddate, "*SELECT* 1".totalactualhours, CASE WHEN (hashed SubPlan 15) THEN "*SELECT* 1".totalactualcostinbasecurrency ELSE NULL::numeric END, CASE WHEN (hashed SubPlan 18) THEN "*SELECT* 1".totalactualbillinginbasecurrency ELSE NULL::numeric END, CASE WHEN (hashed SubPlan 21) THEN (SubPlan 22) ELSE NULL::bigint END, CASE WHEN (hashed SubPlan 25) THEN (SubPlan 26) ELSE NULL::date END, CASE WHEN (hashed SubPlan 29) THEN (SubPlan 30) ELSE NULL::integer END
  • Buffers: shared hit=791617
4. 7.092 105.486 ↑ 1.5 15,150 1

Append (cost=9,318.80..29,353.52 rows=23,313 width=236) (actual time=46.301..105.486 rows=15,150 loops=1)

  • Buffers: shared hit=42417
5. 21.684 90.998 ↓ 15,150.0 15,150 1

Subquery Scan on *SELECT* 1 (cost=9,318.80..15,074.68 rows=1 width=236) (actual time=46.300..90.998 rows=15,150 loops=1)

  • Output: "*SELECT* 1".projectid, "*SELECT* 1".name, "*SELECT* 1".slug, "*SELECT* 1".code, "*SELECT* 1".statustype, "*SELECT* 1".projectleaderid, "*SELECT* 1".projectleaderdisplayname, "*SELECT* 1".projectleaderslug, "*SELECT* 1".startdate, "*SELECT* 1".enddate, "*SELECT* 1".totalactualhours, "*SELECT* 1".totalactualcostinbasecurrency, "*SELECT* 1".totalactualbillinginbasecurrency
  • Filter: ((hashed SubPlan 31) OR (hashed SubPlan 32) OR (hashed SubPlan 33))
  • Buffers: shared hit=38592
6. 15.139 39.976 ↓ 15,150.0 15,150 1

Merge Anti Join (cost=0.57..5,756.43 rows=1 width=236) (actual time=10.533..39.976 rows=15,150 loops=1)

  • Output: dm_projectlist_facts.projectid, dm_projectlist_facts.name, dm_projectlist_facts.slug, dm_projectlist_facts.code, dm_projectlist_facts.statustype, NULL::integer, dm_projectlist_facts.startdate, dm_projectlist_facts.enddate, dm_projectlist_facts.projectleaderid, dm_projectlist_facts.projectleaderdisplayname, dm_projectlist_facts.projectleaderslug, NULL::uuid, NULL::text, NULL::text, NULL::numeric(19,4), dm_projectlist_facts.totalactualbillinginbasecurrency, NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), dm_projectlist_facts.totalactualcostinbasecurrency, NULL::numeric(19,4), NULL::numeric(19,4), NULL::interval, dm_projectlist_facts.totalactualhours, NULL::numeric(19,4), NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::uuid, NULL::numeric(19,4)
  • Merge Cond: (dm_projectlist_facts.projectid = dm_projectlist_realtime_facts.projectid)
  • Buffers: shared hit=20848
7. 14.319 14.319 ↓ 1.8 15,150 1

Index Scan using dm_projectlist_facts_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".dm_projectlist_facts (cost=0.29..836.02 rows=8,400 width=236) (actual time=0.010..14.319 rows=15,150 loops=1)

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

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

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

SubPlan (forSubquery Scan)

10. 12.695 29.338 ↑ 1.0 15,150 1

Merge Semi Join (cost=0.57..3,192.32 rows=15,150 width=4) (actual time=0.038..29.338 rows=15,150 loops=1)

  • Output: project46.id
  • Merge Cond: (project46.id = project47.id)
  • Buffers: shared hit=17744
11. 9.340 9.340 ↑ 1.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project46 (cost=0.29..1,482.54 rows=15,150 width=4) (actual time=0.027..9.340 rows=15,150 loops=1)

  • Output: project46.id
  • Heap Fetches: 19840
  • Buffers: shared hit=8872
12. 7.303 7.303 ↑ 1.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project47 (cost=0.29..1,482.54 rows=15,150 width=4) (actual time=0.007..7.303 rows=15,150 loops=1)

  • Output: project47.id
  • Heap Fetches: 19839
  • Buffers: shared hit=8872
13. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

Hash Left Join (cost=376.57..3,870.63 rows=78 width=4) (never executed)

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

Merge Left Join (cost=0.57..3,202.32 rows=15,150 width=8) (never executed)

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

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

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

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient51 (cost=0.29..1,492.54 rows=15,150 width=8) (never executed)

  • Output: projectclient51.projectid, projectclient51.clientid, projectclient51.effectivedate, projectclient51.enddate
  • Heap Fetches: 0
20. 0.000 0.000 ↓ 0.0 0

Hash (cost=356.38..356.38 rows=1,570 width=12) (never executed)

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

Hash Right Join (cost=309.09..356.38 rows=1,570 width=12) (never executed)

  • Output: clients52.id, clients52.clientmanageruserid, clientsharingassignment53.userid
  • Hash Cond: (clientsharingassignment53.clientid = clients52.id)
22. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment53 (cost=0.00..25.70 rows=1,570 width=8) (never executed)

  • Output: clientsharingassignment53.id, clientsharingassignment53.clientid, clientsharingassignment53.userid
23. 0.000 0.000 ↓ 0.0 0

Hash (cost=290.15..290.15 rows=1,515 width=8) (never executed)

  • Output: clients52.id, clients52.clientmanageruserid
24. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients52 (cost=0.00..290.15 rows=1,515 width=8) (never executed)

  • Output: clients52.id, clients52.clientmanageruserid
25. 0.000 7.396 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=9,318.23..14,278.84 rows=23,312 width=236) (actual time=7.396..7.396 rows=0 loops=1)

  • Output: "*SELECT* 2".projectid, "*SELECT* 2".name, "*SELECT* 2".slug, "*SELECT* 2".code, "*SELECT* 2".statustype, "*SELECT* 2".projectleaderid, "*SELECT* 2".projectleaderdisplayname, "*SELECT* 2".projectleaderslug, "*SELECT* 2".startdate, "*SELECT* 2".enddate, "*SELECT* 2".totalactualhours, "*SELECT* 2".totalactualcostinbasecurrency, "*SELECT* 2".totalactualbillinginbasecurrency
  • Filter: ((hashed SubPlan 31) OR (hashed SubPlan 32) OR (hashed SubPlan 33))
  • Buffers: shared hit=3825
26. 7.394 7.394 ↓ 0.0 0 1

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

  • Output: dm_projectlist_realtime_facts_1.projectid, dm_projectlist_realtime_facts_1.name, dm_projectlist_realtime_facts_1.slug, dm_projectlist_realtime_facts_1.code, dm_projectlist_realtime_facts_1.statustype, NULL::integer, dm_projectlist_realtime_facts_1.startdate, dm_projectlist_realtime_facts_1.enddate, dm_projectlist_realtime_facts_1.projectleaderid, dm_projectlist_realtime_facts_1.projectleaderdisplayname, dm_projectlist_realtime_facts_1.projectleaderslug, NULL::uuid, NULL::text, NULL::text, NULL::numeric(19,4), dm_projectlist_realtime_facts_1.totalactualbillinginbasecurrency, NULL::numeric(19,4), NULL::numeric(19,4), NULL::numeric(19,4), dm_projectlist_realtime_facts_1.totalactualcostinbasecurrency, NULL::numeric(19,4), NULL::numeric(19,4), NULL::interval, dm_projectlist_realtime_facts_1.totalactualhours, NULL::numeric(19,4), NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::uuid, NULL::numeric(19,4)
  • Filter: ((NOT dm_projectlist_realtime_facts_1.deleted) AND ((dm_projectlist_realtime_facts_1.statustype <> 5) OR (dm_projectlist_realtime_facts_1.statustype IS NULL)))
  • Buffers: shared hit=3825
27.          

SubPlan (forSubquery Scan)

28. 12.695 29.338 ↑ 1.0 15,150 1

Merge Semi Join (cost=0.57..3,192.32 rows=15,150 width=4) (actual time=0.038..29.338 rows=15,150 loops=1)

  • Output: project46.id
  • Merge Cond: (project46.id = project47.id)
  • Buffers: shared hit=17744
29. 9.340 9.340 ↑ 1.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project46 (cost=0.29..1,482.54 rows=15,150 width=4) (actual time=0.027..9.340 rows=15,150 loops=1)

  • Output: project46.id
  • Heap Fetches: 19840
  • Buffers: shared hit=8872
30. 7.303 7.303 ↑ 1.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project47 (cost=0.29..1,482.54 rows=15,150 width=4) (actual time=0.007..7.303 rows=15,150 loops=1)

  • Output: project47.id
  • Heap Fetches: 19839
  • Buffers: shared hit=8872
31. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

Hash Left Join (cost=376.57..3,870.63 rows=78 width=4) (never executed)

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

Merge Left Join (cost=0.57..3,202.32 rows=15,150 width=8) (never executed)

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

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

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

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient51 (cost=0.29..1,492.54 rows=15,150 width=8) (never executed)

  • Output: projectclient51.projectid, projectclient51.clientid, projectclient51.effectivedate, projectclient51.enddate
  • Heap Fetches: 0
38. 0.000 0.000 ↓ 0.0 0

Hash (cost=356.38..356.38 rows=1,570 width=12) (never executed)

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

Hash Right Join (cost=309.09..356.38 rows=1,570 width=12) (never executed)

  • Output: clients52.id, clients52.clientmanageruserid, clientsharingassignment53.userid
  • Hash Cond: (clientsharingassignment53.clientid = clients52.id)
40. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment53 (cost=0.00..25.70 rows=1,570 width=8) (never executed)

  • Output: clientsharingassignment53.id, clientsharingassignment53.clientid, clientsharingassignment53.userid
41. 0.000 0.000 ↓ 0.0 0

Hash (cost=290.15..290.15 rows=1,515 width=8) (never executed)

  • Output: clients52.id, clients52.clientmanageruserid
42. 0.000 0.000 ↓ 0.0 0

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients52 (cost=0.00..290.15 rows=1,515 width=8) (never executed)

  • Output: clients52.id, clients52.clientmanageruserid
43.          

SubPlan (forResult)

44. 17.537 83.896 ↓ 1.9 15,150 1

Merge Left Join (cost=3,176.96..11,075.51 rows=7,928 width=4) (actual time=43.423..83.896 rows=15,150 loops=1)

  • Output: project1.id
  • Merge Cond: (project1.id = projectsharingassignment2.projectid)
  • Filter: ((alternatives: SubPlan 1 or hashed SubPlan 2) OR (project1.projectleaderapproverid = 2) OR (projectsharingassignment2.userid = 2) OR (clients4.clientmanageruserid = 2) OR (clientsharingassignment5.userid = 2))
  • Buffers: shared hit=38595
45. 14.059 56.436 ↑ 1.0 15,150 1

Merge Left Join (cost=3,176.80..5,544.43 rows=15,700 width=16) (actual time=26.851..56.436 rows=15,150 loops=1)

  • Output: project1.id, project1.projectleaderapproverid, clients4.clientmanageruserid, clientsharingassignment5.userid
  • Merge Cond: (project1.id = projectclient3.projectid)
  • Buffers: shared hit=29722
46. 10.939 10.939 ↑ 1.0 15,150 1

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project1 (cost=0.29..2,094.53 rows=15,150 width=8) (actual time=0.007..10.939 rows=15,150 loops=1)

  • Output: project1.id, project1.guidid, project1.name, project1.slug, project1.code, project1.clientid, project1.projectleaderapproverid, project1.projectstatuslabelid, project1.isprojectleaderapprovalrequired, project1.startdate, project1.enddate, project1.programid, project1.billingtype, project1.fixedbidamount, project1.fixedbidcurrencyid, project1.fixedbidfrequency, project1.timeentrycappercent, project1.costtype, project1.clientbillingallocationmethod, project1.description, project1.percentcomplete, project1.istimeentryallowed, project1.estimatedhours, project1.estimatedexpenses, project1.estimatedexpensescurrencyid, project1.estimatedcost, project1.estimatedcostcurrencyid, project1.timeandexpenseentrytype, project1.estimationmode, project1.billingratefrequencyid, project1.billingratefrequencyduration, project1.defaultbillingcurrencyid, project1.billingcontractid, project1.projecthealthstateid, project1.projecthealthstatedescription, project1.totalestimatedcontractamount, project1.totalestimatedcontractcurrencyid, project1.budgetedhours, project1.budgetedcost, project1.budgetedcostcurrencyid, project1.info1, project1.info2, project1.info3, project1.info4, project1.info5, project1.info6, project1.info7, project1.info8, project1.info9, project1.info10, project1.info11, project1.info12, project1.info13, project1.info14, project1.info15, project1.info16, project1.info17, project1.info18, project1.info19, project1.info20
  • Buffers: shared hit=13206
47. 9.493 31.438 ↑ 1.0 15,150 1

Sort (cost=3,176.52..3,215.77 rows=15,700 width=12) (actual time=26.837..31.438 rows=15,150 loops=1)

  • Output: projectclient3.projectid, clients4.clientmanageruserid, clientsharingassignment5.userid
  • Sort Key: projectclient3.projectid
  • Sort Method: quicksort Memory: 1095kB
  • Buffers: shared hit=16516
48. 9.048 21.945 ↑ 1.0 15,150 1

Hash Left Join (cost=376.29..2,082.35 rows=15,700 width=12) (actual time=2.283..21.945 rows=15,150 loops=1)

  • Output: projectclient3.projectid, clients4.clientmanageruserid, clientsharingassignment5.userid
  • Hash Cond: (projectclient3.clientid = clients4.id)
  • Buffers: shared hit=16516
49. 10.648 10.648 ↑ 1.0 15,150 1

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient3 (cost=0.29..1,492.54 rows=15,150 width=8) (actual time=0.020..10.648 rows=15,150 loops=1)

  • Output: projectclient3.projectid, projectclient3.clientid, projectclient3.effectivedate, projectclient3.enddate
  • Heap Fetches: 19876
  • Buffers: shared hit=16241
50. 0.438 2.249 ↑ 1.0 1,515 1

Hash (cost=356.38..356.38 rows=1,570 width=12) (actual time=2.249..2.249 rows=1,515 loops=1)

  • Output: clients4.id, clients4.clientmanageruserid, clientsharingassignment5.userid
  • Buckets: 2048 Batches: 1 Memory Usage: 70kB
  • Buffers: shared hit=275
51. 0.417 1.811 ↑ 1.0 1,515 1

Hash Right Join (cost=309.09..356.38 rows=1,570 width=12) (actual time=1.400..1.811 rows=1,515 loops=1)

  • Output: clients4.id, clients4.clientmanageruserid, clientsharingassignment5.userid
  • Hash Cond: (clientsharingassignment5.clientid = clients4.id)
  • Buffers: shared hit=275
52. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment5 (cost=0.00..25.70 rows=1,570 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: clientsharingassignment5.id, clientsharingassignment5.clientid, clientsharingassignment5.userid
53. 0.529 1.393 ↑ 1.0 1,515 1

Hash (cost=290.15..290.15 rows=1,515 width=8) (actual time=1.393..1.393 rows=1,515 loops=1)

  • Output: clients4.id, clients4.clientmanageruserid
  • Buckets: 2048 Batches: 1 Memory Usage: 70kB
  • Buffers: shared hit=275
54. 0.864 0.864 ↑ 1.0 1,515 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients4 (cost=0.00..290.15 rows=1,515 width=8) (actual time=0.004..0.864 rows=1,515 loops=1)

  • Output: clients4.id, clients4.clientmanageruserid
  • Buffers: shared hit=275
55. 0.003 0.003 ↓ 0.0 0 1

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment2 (cost=0.15..45.06 rows=2,260 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: projectsharingassignment2.projectid, projectsharingassignment2.userid
  • Heap Fetches: 0
  • Buffers: shared hit=1
56.          

SubPlan (forMerge Left Join)

57. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project6 (cost=0.29..2.30 rows=1 width=0) (never executed)

  • Index Cond: (project6.id = project1.id)
  • Heap Fetches: 0
58. 9.920 9.920 ↑ 1.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project6_1 (cost=0.29..1,482.54 rows=15,150 width=4) (actual time=0.010..9.920 rows=15,150 loops=1)

  • Output: project6_1.id
  • Heap Fetches: 19840
  • Buffers: shared hit=8872
59. 15.150 151.500 ↑ 1.0 1 15,150

Limit (cost=4.62..4.63 rows=1 width=27) (actual time=0.010..0.010 rows=1 loops=15,150)

  • Output: ((clients7.name)::character varying(255)), projectclient8.costallocationpercentage
  • Buffers: shared hit=99154
60. 30.300 136.350 ↑ 1.0 1 15,150

Sort (cost=4.62..4.63 rows=1 width=27) (actual time=0.009..0.009 rows=1 loops=15,150)

  • Output: ((clients7.name)::character varying(255)), projectclient8.costallocationpercentage
  • Sort Key: projectclient8.costallocationpercentage DESC, ((clients7.name)::character varying(255)) COLLATE "en_US
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=99154
61. 45.450 106.050 ↑ 1.0 1 15,150

Nested Loop (cost=0.56..4.61 rows=1 width=27) (actual time=0.005..0.007 rows=1 loops=15,150)

  • Output: clients7.name, projectclient8.costallocationpercentage
  • Buffers: shared hit=99154
62. 30.300 30.300 ↑ 1.0 1 15,150

Index Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient8 (cost=0.29..2.31 rows=1 width=9) (actual time=0.002..0.002 rows=1 loops=15,150)

  • Output: projectclient8.id, projectclient8.projectid, projectclient8.clientid, projectclient8.costallocationpercentage, projectclient8.effectivedate, projectclient8.enddate
  • Index Cond: ((projectclient8.projectid = "*SELECT* 1".projectid) AND (projectclient8.effectivedate <= '2019-08-08'::date) AND (projectclient8.enddate >= '2019-08-08'::date))
  • Buffers: shared hit=53634
63. 30.300 30.300 ↑ 1.0 1 15,150

Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients7 (cost=0.28..2.29 rows=1 width=26) (actual time=0.002..0.002 rows=1 loops=15,150)

  • 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
  • Index Cond: (clients7.id = projectclient8.clientid)
  • Buffers: shared hit=45520
64. 16.925 81.935 ↓ 1.9 15,150 1

Merge Left Join (cost=3,176.96..11,075.51 rows=7,928 width=4) (actual time=41.854..81.935 rows=15,150 loops=1)

  • Output: project1_1.id
  • Merge Cond: (project1_1.id = projectsharingassignment2_1.projectid)
  • Filter: ((alternatives: SubPlan 5 or hashed SubPlan 6) OR (project1_1.projectleaderapproverid = 2) OR (projectsharingassignment2_1.userid = 2) OR (clients4_1.clientmanageruserid = 2) OR (clientsharingassignment5_1.userid = 2))
  • Buffers: shared hit=38595
65. 14.055 55.710 ↑ 1.0 15,150 1

Merge Left Join (cost=3,176.80..5,544.43 rows=15,700 width=16) (actual time=26.344..55.710 rows=15,150 loops=1)

  • Output: project1_1.id, project1_1.projectleaderapproverid, clients4_1.clientmanageruserid, clientsharingassignment5_1.userid
  • Merge Cond: (project1_1.id = projectclient3_1.projectid)
  • Buffers: shared hit=29722
66. 10.854 10.854 ↑ 1.0 15,150 1

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project1_1 (cost=0.29..2,094.53 rows=15,150 width=8) (actual time=0.005..10.854 rows=15,150 loops=1)

  • Output: project1_1.id, project1_1.guidid, project1_1.name, project1_1.slug, project1_1.code, project1_1.clientid, project1_1.projectleaderapproverid, project1_1.projectstatuslabelid, project1_1.isprojectleaderapprovalrequired, project1_1.startdate, project1_1.enddate, project1_1.programid, project1_1.billingtype, project1_1.fixedbidamount, project1_1.fixedbidcurrencyid, project1_1.fixedbidfrequency, project1_1.timeentrycappercent, project1_1.costtype, project1_1.clientbillingallocationmethod, project1_1.description, project1_1.percentcomplete, project1_1.istimeentryallowed, project1_1.estimatedhours, project1_1.estimatedexpenses, project1_1.estimatedexpensescurrencyid, project1_1.estimatedcost, project1_1.estimatedcostcurrencyid, project1_1.timeandexpenseentrytype, project1_1.estimationmode, project1_1.billingratefrequencyid, project1_1.billingratefrequencyduration, project1_1.defaultbillingcurrencyid, project1_1.billingcontractid, project1_1.projecthealthstateid, project1_1.projecthealthstatedescription, project1_1.totalestimatedcontractamount, project1_1.totalestimatedcontractcurrencyid, project1_1.budgetedhours, project1_1.budgetedcost, project1_1.budgetedcostcurrencyid, project1_1.info1, project1_1.info2, project1_1.info3, project1_1.info4, project1_1.info5, project1_1.info6, project1_1.info7, project1_1.info8, project1_1.info9, project1_1.info10, project1_1.info11, project1_1.info12, project1_1.info13, project1_1.info14, project1_1.info15, project1_1.info16, project1_1.info17, project1_1.info18, project1_1.info19, project1_1.info20
  • Buffers: shared hit=13206
67. 9.328 30.801 ↑ 1.0 15,150 1

Sort (cost=3,176.52..3,215.77 rows=15,700 width=12) (actual time=26.333..30.801 rows=15,150 loops=1)

  • Output: projectclient3_1.projectid, clients4_1.clientmanageruserid, clientsharingassignment5_1.userid
  • Sort Key: projectclient3_1.projectid
  • Sort Method: quicksort Memory: 1095kB
  • Buffers: shared hit=16516
68. 8.801 21.473 ↑ 1.0 15,150 1

Hash Left Join (cost=376.29..2,082.35 rows=15,700 width=12) (actual time=2.191..21.473 rows=15,150 loops=1)

  • Output: projectclient3_1.projectid, clients4_1.clientmanageruserid, clientsharingassignment5_1.userid
  • Hash Cond: (projectclient3_1.clientid = clients4_1.id)
  • Buffers: shared hit=16516
69. 10.501 10.501 ↑ 1.0 15,150 1

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient3_1 (cost=0.29..1,492.54 rows=15,150 width=8) (actual time=0.006..10.501 rows=15,150 loops=1)

  • Output: projectclient3_1.projectid, projectclient3_1.clientid, projectclient3_1.effectivedate, projectclient3_1.enddate
  • Heap Fetches: 19876
  • Buffers: shared hit=16241
70. 0.443 2.171 ↑ 1.0 1,515 1

Hash (cost=356.38..356.38 rows=1,570 width=12) (actual time=2.171..2.171 rows=1,515 loops=1)

  • Output: clients4_1.id, clients4_1.clientmanageruserid, clientsharingassignment5_1.userid
  • Buckets: 2048 Batches: 1 Memory Usage: 70kB
  • Buffers: shared hit=275
71. 0.396 1.728 ↑ 1.0 1,515 1

Hash Right Join (cost=309.09..356.38 rows=1,570 width=12) (actual time=1.337..1.728 rows=1,515 loops=1)

  • Output: clients4_1.id, clients4_1.clientmanageruserid, clientsharingassignment5_1.userid
  • Hash Cond: (clientsharingassignment5_1.clientid = clients4_1.id)
  • Buffers: shared hit=275
72. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment5_1 (cost=0.00..25.70 rows=1,570 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: clientsharingassignment5_1.id, clientsharingassignment5_1.clientid, clientsharingassignment5_1.userid
73. 0.470 1.331 ↑ 1.0 1,515 1

Hash (cost=290.15..290.15 rows=1,515 width=8) (actual time=1.331..1.331 rows=1,515 loops=1)

  • Output: clients4_1.id, clients4_1.clientmanageruserid
  • Buckets: 2048 Batches: 1 Memory Usage: 70kB
  • Buffers: shared hit=275
74. 0.861 0.861 ↑ 1.0 1,515 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients4_1 (cost=0.00..290.15 rows=1,515 width=8) (actual time=0.004..0.861 rows=1,515 loops=1)

  • Output: clients4_1.id, clients4_1.clientmanageruserid
  • Buffers: shared hit=275
75. 0.002 0.002 ↓ 0.0 0 1

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment2_1 (cost=0.15..45.06 rows=2,260 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: projectsharingassignment2_1.projectid, projectsharingassignment2_1.userid
  • Heap Fetches: 0
  • Buffers: shared hit=1
76.          

SubPlan (forMerge Left Join)

77. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project6_2 (cost=0.29..2.30 rows=1 width=0) (never executed)

  • Index Cond: (project6_2.id = project1_1.id)
  • Heap Fetches: 0
78. 9.298 9.298 ↑ 1.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project6_3 (cost=0.29..1,482.54 rows=15,150 width=4) (actual time=0.008..9.298 rows=15,150 loops=1)

  • Output: project6_3.id
  • Heap Fetches: 19840
  • Buffers: shared hit=8872
79. 15.150 136.350 ↑ 1.0 1 15,150

Limit (cost=4.62..4.63 rows=1 width=31) (actual time=0.009..0.009 rows=1 loops=15,150)

  • Output: clients9.id, projectclient10.costallocationpercentage, ((clients9.name)::character varying(255))
  • Buffers: shared hit=99154
80. 30.300 121.200 ↑ 1.0 1 15,150

Sort (cost=4.62..4.63 rows=1 width=31) (actual time=0.008..0.008 rows=1 loops=15,150)

  • Output: clients9.id, projectclient10.costallocationpercentage, ((clients9.name)::character varying(255))
  • Sort Key: projectclient10.costallocationpercentage DESC, ((clients9.name)::character varying(255)) COLLATE "en_US
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=99154
81. 30.300 90.900 ↑ 1.0 1 15,150

Nested Loop (cost=0.56..4.61 rows=1 width=31) (actual time=0.004..0.006 rows=1 loops=15,150)

  • Output: clients9.id, projectclient10.costallocationpercentage, clients9.name
  • Buffers: shared hit=99154
82. 30.300 30.300 ↑ 1.0 1 15,150

Index Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient10 (cost=0.29..2.31 rows=1 width=9) (actual time=0.002..0.002 rows=1 loops=15,150)

  • Output: projectclient10.id, projectclient10.projectid, projectclient10.clientid, projectclient10.costallocationpercentage, projectclient10.effectivedate, projectclient10.enddate
  • Index Cond: ((projectclient10.projectid = "*SELECT* 1".projectid) AND (projectclient10.effectivedate <= '2019-08-08'::date) AND (projectclient10.enddate >= '2019-08-08'::date))
  • Buffers: shared hit=53634
83. 30.300 30.300 ↑ 1.0 1 15,150

Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients9 (cost=0.28..2.29 rows=1 width=26) (actual time=0.001..0.002 rows=1 loops=15,150)

  • Output: clients9.id, clients9.name, clients9.slug, clients9.code, clients9.comments, clients9.clientmanageruserid, clients9.disabled, clients9.address, clients9.city, clients9.stateprovince, clients9.zippostalcode, clients9.country, clients9.email, clients9.telephone, clients9.fax, clients9.website, clients9.billingcontact, clients9.billingaddress, clients9.billingcity, clients9.billingstateprovince, clients9.billingzippostalcode, clients9.billingcountry, clients9.billingemail, clients9.billingtelephone, clients9.billingfax, clients9.billingwebsite, clients9.info1, clients9.info2, clients9.info3, clients9.info4, clients9.info5, clients9.info6, clients9.info7, clients9.info8, clients9.info9, clients9.info10, clients9.info11, clients9.info12, clients9.defaultbillingcurrencyid
  • Index Cond: (clients9.id = projectclient10.clientid)
  • Buffers: shared hit=45520
84. 17.267 83.545 ↓ 1.9 15,150 1

Merge Left Join (cost=3,176.96..11,075.51 rows=7,928 width=4) (actual time=42.238..83.545 rows=15,150 loops=1)

  • Output: project1_2.id
  • Merge Cond: (project1_2.id = projectsharingassignment2_2.projectid)
  • Filter: ((alternatives: SubPlan 9 or hashed SubPlan 10) OR (project1_2.projectleaderapproverid = 2) OR (projectsharingassignment2_2.userid = 2) OR (clients4_2.clientmanageruserid = 2) OR (clientsharingassignment5_2.userid = 2))
  • Buffers: shared hit=38595
85. 14.426 57.079 ↑ 1.0 15,150 1

Merge Left Join (cost=3,176.80..5,544.43 rows=15,700 width=16) (actual time=26.868..57.079 rows=15,150 loops=1)

  • Output: project1_2.id, project1_2.projectleaderapproverid, clients4_2.clientmanageruserid, clientsharingassignment5_2.userid
  • Merge Cond: (project1_2.id = projectclient3_2.projectid)
  • Buffers: shared hit=29722
86. 11.274 11.274 ↑ 1.0 15,150 1

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project1_2 (cost=0.29..2,094.53 rows=15,150 width=8) (actual time=0.005..11.274 rows=15,150 loops=1)

  • Output: project1_2.id, project1_2.guidid, project1_2.name, project1_2.slug, project1_2.code, project1_2.clientid, project1_2.projectleaderapproverid, project1_2.projectstatuslabelid, project1_2.isprojectleaderapprovalrequired, project1_2.startdate, project1_2.enddate, project1_2.programid, project1_2.billingtype, project1_2.fixedbidamount, project1_2.fixedbidcurrencyid, project1_2.fixedbidfrequency, project1_2.timeentrycappercent, project1_2.costtype, project1_2.clientbillingallocationmethod, project1_2.description, project1_2.percentcomplete, project1_2.istimeentryallowed, project1_2.estimatedhours, project1_2.estimatedexpenses, project1_2.estimatedexpensescurrencyid, project1_2.estimatedcost, project1_2.estimatedcostcurrencyid, project1_2.timeandexpenseentrytype, project1_2.estimationmode, project1_2.billingratefrequencyid, project1_2.billingratefrequencyduration, project1_2.defaultbillingcurrencyid, project1_2.billingcontractid, project1_2.projecthealthstateid, project1_2.projecthealthstatedescription, project1_2.totalestimatedcontractamount, project1_2.totalestimatedcontractcurrencyid, project1_2.budgetedhours, project1_2.budgetedcost, project1_2.budgetedcostcurrencyid, project1_2.info1, project1_2.info2, project1_2.info3, project1_2.info4, project1_2.info5, project1_2.info6, project1_2.info7, project1_2.info8, project1_2.info9, project1_2.info10, project1_2.info11, project1_2.info12, project1_2.info13, project1_2.info14, project1_2.info15, project1_2.info16, project1_2.info17, project1_2.info18, project1_2.info19, project1_2.info20
  • Buffers: shared hit=13206
87. 9.414 31.379 ↑ 1.0 15,150 1

Sort (cost=3,176.52..3,215.77 rows=15,700 width=12) (actual time=26.859..31.379 rows=15,150 loops=1)

  • Output: projectclient3_2.projectid, clients4_2.clientmanageruserid, clientsharingassignment5_2.userid
  • Sort Key: projectclient3_2.projectid
  • Sort Method: quicksort Memory: 1095kB
  • Buffers: shared hit=16516
88. 9.057 21.965 ↑ 1.0 15,150 1

Hash Left Join (cost=376.29..2,082.35 rows=15,700 width=12) (actual time=2.271..21.965 rows=15,150 loops=1)

  • Output: projectclient3_2.projectid, clients4_2.clientmanageruserid, clientsharingassignment5_2.userid
  • Hash Cond: (projectclient3_2.clientid = clients4_2.id)
  • Buffers: shared hit=16516
89. 10.658 10.658 ↑ 1.0 15,150 1

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient3_2 (cost=0.29..1,492.54 rows=15,150 width=8) (actual time=0.008..10.658 rows=15,150 loops=1)

  • Output: projectclient3_2.projectid, projectclient3_2.clientid, projectclient3_2.effectivedate, projectclient3_2.enddate
  • Heap Fetches: 19876
  • Buffers: shared hit=16241
90. 0.489 2.250 ↑ 1.0 1,515 1

Hash (cost=356.38..356.38 rows=1,570 width=12) (actual time=2.250..2.250 rows=1,515 loops=1)

  • Output: clients4_2.id, clients4_2.clientmanageruserid, clientsharingassignment5_2.userid
  • Buckets: 2048 Batches: 1 Memory Usage: 70kB
  • Buffers: shared hit=275
91. 0.462 1.761 ↑ 1.0 1,515 1

Hash Right Join (cost=309.09..356.38 rows=1,570 width=12) (actual time=1.345..1.761 rows=1,515 loops=1)

  • Output: clients4_2.id, clients4_2.clientmanageruserid, clientsharingassignment5_2.userid
  • Hash Cond: (clientsharingassignment5_2.clientid = clients4_2.id)
  • Buffers: shared hit=275
92. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment5_2 (cost=0.00..25.70 rows=1,570 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: clientsharingassignment5_2.id, clientsharingassignment5_2.clientid, clientsharingassignment5_2.userid
93. 0.483 1.298 ↑ 1.0 1,515 1

Hash (cost=290.15..290.15 rows=1,515 width=8) (actual time=1.298..1.298 rows=1,515 loops=1)

  • Output: clients4_2.id, clients4_2.clientmanageruserid
  • Buckets: 2048 Batches: 1 Memory Usage: 70kB
  • Buffers: shared hit=275
94. 0.815 0.815 ↑ 1.0 1,515 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients4_2 (cost=0.00..290.15 rows=1,515 width=8) (actual time=0.003..0.815 rows=1,515 loops=1)

  • Output: clients4_2.id, clients4_2.clientmanageruserid
  • Buffers: shared hit=275
95. 0.002 0.002 ↓ 0.0 0 1

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment2_2 (cost=0.15..45.06 rows=2,260 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: projectsharingassignment2_2.projectid, projectsharingassignment2_2.userid
  • Heap Fetches: 0
  • Buffers: shared hit=1
96.          

SubPlan (forMerge Left Join)

97. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project6_4 (cost=0.29..2.30 rows=1 width=0) (never executed)

  • Index Cond: (project6_4.id = project1_2.id)
  • Heap Fetches: 0
98. 9.197 9.197 ↑ 1.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project6_5 (cost=0.29..1,482.54 rows=15,150 width=4) (actual time=0.008..9.197 rows=15,150 loops=1)

  • Output: project6_5.id
  • Heap Fetches: 19840
  • Buffers: shared hit=8872
99. 15.150 136.350 ↑ 1.0 1 15,150

Limit (cost=4.62..4.63 rows=1 width=49) (actual time=0.009..0.009 rows=1 loops=15,150)

  • Output: ((clients11.slug)::character varying(255)), projectclient12.costallocationpercentage, ((clients11.name)::character varying(255))
  • Buffers: shared hit=99154
100. 30.300 121.200 ↑ 1.0 1 15,150

Sort (cost=4.62..4.63 rows=1 width=49) (actual time=0.008..0.008 rows=1 loops=15,150)

  • Output: ((clients11.slug)::character varying(255)), projectclient12.costallocationpercentage, ((clients11.name)::character varying(255))
  • Sort Key: projectclient12.costallocationpercentage DESC, ((clients11.name)::character varying(255)) COLLATE "en_US
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=99154
101. 30.300 90.900 ↑ 1.0 1 15,150

Nested Loop (cost=0.56..4.61 rows=1 width=49) (actual time=0.004..0.006 rows=1 loops=15,150)

  • Output: clients11.slug, projectclient12.costallocationpercentage, clients11.name
  • Buffers: shared hit=99154
102. 30.300 30.300 ↑ 1.0 1 15,150

Index Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient12 (cost=0.29..2.31 rows=1 width=9) (actual time=0.002..0.002 rows=1 loops=15,150)

  • Output: projectclient12.id, projectclient12.projectid, projectclient12.clientid, projectclient12.costallocationpercentage, projectclient12.effectivedate, projectclient12.enddate
  • Index Cond: ((projectclient12.projectid = "*SELECT* 1".projectid) AND (projectclient12.effectivedate <= '2019-08-08'::date) AND (projectclient12.enddate >= '2019-08-08'::date))
  • Buffers: shared hit=53634
103. 30.300 30.300 ↑ 1.0 1 15,150

Index Scan using clients_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients11 (cost=0.28..2.29 rows=1 width=48) (actual time=0.001..0.002 rows=1 loops=15,150)

  • Output: clients11.id, clients11.name, clients11.slug, clients11.code, clients11.comments, clients11.clientmanageruserid, clients11.disabled, clients11.address, clients11.city, clients11.stateprovince, clients11.zippostalcode, clients11.country, clients11.email, clients11.telephone, clients11.fax, clients11.website, clients11.billingcontact, clients11.billingaddress, clients11.billingcity, clients11.billingstateprovince, clients11.billingzippostalcode, clients11.billingcountry, clients11.billingemail, clients11.billingtelephone, clients11.billingfax, clients11.billingwebsite, clients11.info1, clients11.info2, clients11.info3, clients11.info4, clients11.info5, clients11.info6, clients11.info7, clients11.info8, clients11.info9, clients11.info10, clients11.info11, clients11.info12, clients11.defaultbillingcurrencyid
  • Index Cond: (clients11.id = projectclient12.clientid)
  • Buffers: shared hit=45520
104. 22.373 104.740 ↓ 1.9 15,150 1

Merge Left Join (cost=3,176.96..11,075.51 rows=7,928 width=4) (actual time=58.715..104.740 rows=15,150 loops=1)

  • Output: project13.id
  • Merge Cond: (project13.id = projectsharingassignment14.projectid)
  • Filter: ((alternatives: SubPlan 13 or hashed SubPlan 14) OR (project13.projectleaderapproverid = 2) OR (projectsharingassignment14.userid = 2) OR (clients16.clientmanageruserid = 2) OR (clientsharingassignment17.userid = 2))
  • Buffers: shared hit=38595
105. 16.793 67.044 ↑ 1.0 15,150 1

Merge Left Join (cost=3,176.80..5,544.43 rows=15,700 width=16) (actual time=32.959..67.044 rows=15,150 loops=1)

  • Output: project13.id, project13.projectleaderapproverid, clients16.clientmanageruserid, clientsharingassignment17.userid
  • Merge Cond: (project13.id = projectclient15.projectid)
  • Buffers: shared hit=29722
106. 12.144 12.144 ↑ 1.0 15,150 1

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project13 (cost=0.29..2,094.53 rows=15,150 width=8) (actual time=0.006..12.144 rows=15,150 loops=1)

  • Output: project13.id, project13.guidid, project13.name, project13.slug, project13.code, project13.clientid, project13.projectleaderapproverid, project13.projectstatuslabelid, project13.isprojectleaderapprovalrequired, project13.startdate, project13.enddate, project13.programid, project13.billingtype, project13.fixedbidamount, project13.fixedbidcurrencyid, project13.fixedbidfrequency, project13.timeentrycappercent, project13.costtype, project13.clientbillingallocationmethod, project13.description, project13.percentcomplete, project13.istimeentryallowed, project13.estimatedhours, project13.estimatedexpenses, project13.estimatedexpensescurrencyid, project13.estimatedcost, project13.estimatedcostcurrencyid, project13.timeandexpenseentrytype, project13.estimationmode, project13.billingratefrequencyid, project13.billingratefrequencyduration, project13.defaultbillingcurrencyid, project13.billingcontractid, project13.projecthealthstateid, project13.projecthealthstatedescription, project13.totalestimatedcontractamount, project13.totalestimatedcontractcurrencyid, project13.budgetedhours, project13.budgetedcost, project13.budgetedcostcurrencyid, project13.info1, project13.info2, project13.info3, project13.info4, project13.info5, project13.info6, project13.info7, project13.info8, project13.info9, project13.info10, project13.info11, project13.info12, project13.info13, project13.info14, project13.info15, project13.info16, project13.info17, project13.info18, project13.info19, project13.info20
  • Buffers: shared hit=13206
107. 11.239 38.107 ↑ 1.0 15,150 1

Sort (cost=3,176.52..3,215.77 rows=15,700 width=12) (actual time=32.947..38.107 rows=15,150 loops=1)

  • Output: projectclient15.projectid, clients16.clientmanageruserid, clientsharingassignment17.userid
  • Sort Key: projectclient15.projectid
  • Sort Method: quicksort Memory: 1095kB
  • Buffers: shared hit=16516
108. 10.963 26.868 ↑ 1.0 15,150 1

Hash Left Join (cost=376.29..2,082.35 rows=15,700 width=12) (actual time=2.350..26.868 rows=15,150 loops=1)

  • Output: projectclient15.projectid, clients16.clientmanageruserid, clientsharingassignment17.userid
  • Hash Cond: (projectclient15.clientid = clients16.id)
  • Buffers: shared hit=16516
109. 13.574 13.574 ↑ 1.0 15,150 1

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient15 (cost=0.29..1,492.54 rows=15,150 width=8) (actual time=0.007..13.574 rows=15,150 loops=1)

  • Output: projectclient15.projectid, projectclient15.clientid, projectclient15.effectivedate, projectclient15.enddate
  • Heap Fetches: 19876
  • Buffers: shared hit=16241
110. 0.506 2.331 ↑ 1.0 1,515 1

Hash (cost=356.38..356.38 rows=1,570 width=12) (actual time=2.331..2.331 rows=1,515 loops=1)

  • Output: clients16.id, clients16.clientmanageruserid, clientsharingassignment17.userid
  • Buckets: 2048 Batches: 1 Memory Usage: 70kB
  • Buffers: shared hit=275
111. 0.445 1.825 ↑ 1.0 1,515 1

Hash Right Join (cost=309.09..356.38 rows=1,570 width=12) (actual time=1.386..1.825 rows=1,515 loops=1)

  • Output: clients16.id, clients16.clientmanageruserid, clientsharingassignment17.userid
  • Hash Cond: (clientsharingassignment17.clientid = clients16.id)
  • Buffers: shared hit=275
112. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment17 (cost=0.00..25.70 rows=1,570 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: clientsharingassignment17.id, clientsharingassignment17.clientid, clientsharingassignment17.userid
113. 0.525 1.379 ↑ 1.0 1,515 1

Hash (cost=290.15..290.15 rows=1,515 width=8) (actual time=1.379..1.379 rows=1,515 loops=1)

  • Output: clients16.id, clients16.clientmanageruserid
  • Buckets: 2048 Batches: 1 Memory Usage: 70kB
  • Buffers: shared hit=275
114. 0.854 0.854 ↑ 1.0 1,515 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients16 (cost=0.00..290.15 rows=1,515 width=8) (actual time=0.003..0.854 rows=1,515 loops=1)

  • Output: clients16.id, clients16.clientmanageruserid
  • Buffers: shared hit=275
115. 0.004 0.004 ↓ 0.0 0 1

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment14 (cost=0.15..45.06 rows=2,260 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Output: projectsharingassignment14.projectid, projectsharingassignment14.userid
  • Heap Fetches: 0
  • Buffers: shared hit=1
116.          

SubPlan (forMerge Left Join)

117. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project18 (cost=0.29..2.30 rows=1 width=0) (never executed)

  • Index Cond: (project18.id = project13.id)
  • Heap Fetches: 0
118. 15.319 15.319 ↑ 1.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project18_1 (cost=0.29..1,482.54 rows=15,150 width=4) (actual time=0.016..15.319 rows=15,150 loops=1)

  • Output: project18_1.id
  • Heap Fetches: 19840
  • Buffers: shared hit=8872
119. 16.546 80.848 ↓ 1.9 15,150 1

Merge Left Join (cost=3,176.96..11,075.51 rows=7,928 width=4) (actual time=41.435..80.848 rows=15,150 loops=1)

  • Output: project19.id
  • Merge Cond: (project19.id = projectsharingassignment20.projectid)
  • Filter: ((alternatives: SubPlan 16 or hashed SubPlan 17) OR (project19.projectleaderapproverid = 2) OR (projectsharingassignment20.userid = 2) OR (clients22.clientmanageruserid = 2) OR (clientsharingassignment23.userid = 2))
  • Buffers: shared hit=38595
120. 13.821 54.724 ↑ 1.0 15,150 1

Merge Left Join (cost=3,176.80..5,544.43 rows=15,700 width=16) (actual time=25.464..54.724 rows=15,150 loops=1)

  • Output: project19.id, project19.projectleaderapproverid, clients22.clientmanageruserid, clientsharingassignment23.userid
  • Merge Cond: (project19.id = projectclient21.projectid)
  • Buffers: shared hit=29722
121. 10.862 10.862 ↑ 1.0 15,150 1

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project19 (cost=0.29..2,094.53 rows=15,150 width=8) (actual time=0.006..10.862 rows=15,150 loops=1)

  • Output: project19.id, project19.guidid, project19.name, project19.slug, project19.code, project19.clientid, project19.projectleaderapproverid, project19.projectstatuslabelid, project19.isprojectleaderapprovalrequired, project19.startdate, project19.enddate, project19.programid, project19.billingtype, project19.fixedbidamount, project19.fixedbidcurrencyid, project19.fixedbidfrequency, project19.timeentrycappercent, project19.costtype, project19.clientbillingallocationmethod, project19.description, project19.percentcomplete, project19.istimeentryallowed, project19.estimatedhours, project19.estimatedexpenses, project19.estimatedexpensescurrencyid, project19.estimatedcost, project19.estimatedcostcurrencyid, project19.timeandexpenseentrytype, project19.estimationmode, project19.billingratefrequencyid, project19.billingratefrequencyduration, project19.defaultbillingcurrencyid, project19.billingcontractid, project19.projecthealthstateid, project19.projecthealthstatedescription, project19.totalestimatedcontractamount, project19.totalestimatedcontractcurrencyid, project19.budgetedhours, project19.budgetedcost, project19.budgetedcostcurrencyid, project19.info1, project19.info2, project19.info3, project19.info4, project19.info5, project19.info6, project19.info7, project19.info8, project19.info9, project19.info10, project19.info11, project19.info12, project19.info13, project19.info14, project19.info15, project19.info16, project19.info17, project19.info18, project19.info19, project19.info20
  • Buffers: shared hit=13206
122. 9.235 30.041 ↑ 1.0 15,150 1

Sort (cost=3,176.52..3,215.77 rows=15,700 width=12) (actual time=25.453..30.041 rows=15,150 loops=1)

  • Output: projectclient21.projectid, clients22.clientmanageruserid, clientsharingassignment23.userid
  • Sort Key: projectclient21.projectid
  • Sort Method: quicksort Memory: 1095kB
  • Buffers: shared hit=16516
123. 8.625 20.806 ↑ 1.0 15,150 1

Hash Left Join (cost=376.29..2,082.35 rows=15,700 width=12) (actual time=2.152..20.806 rows=15,150 loops=1)

  • Output: projectclient21.projectid, clients22.clientmanageruserid, clientsharingassignment23.userid
  • Hash Cond: (projectclient21.clientid = clients22.id)
  • Buffers: shared hit=16516
124. 10.050 10.050 ↑ 1.0 15,150 1

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient21 (cost=0.29..1,492.54 rows=15,150 width=8) (actual time=0.009..10.050 rows=15,150 loops=1)

  • Output: projectclient21.projectid, projectclient21.clientid, projectclient21.effectivedate, projectclient21.enddate
  • Heap Fetches: 19876
  • Buffers: shared hit=16241
125. 0.433 2.131 ↑ 1.0 1,515 1

Hash (cost=356.38..356.38 rows=1,570 width=12) (actual time=2.131..2.131 rows=1,515 loops=1)

  • Output: clients22.id, clients22.clientmanageruserid, clientsharingassignment23.userid
  • Buckets: 2048 Batches: 1 Memory Usage: 70kB
  • Buffers: shared hit=275
126. 0.403 1.698 ↑ 1.0 1,515 1

Hash Right Join (cost=309.09..356.38 rows=1,570 width=12) (actual time=1.300..1.698 rows=1,515 loops=1)

  • Output: clients22.id, clients22.clientmanageruserid, clientsharingassignment23.userid
  • Hash Cond: (clientsharingassignment23.clientid = clients22.id)
  • Buffers: shared hit=275
127. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment23 (cost=0.00..25.70 rows=1,570 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: clientsharingassignment23.id, clientsharingassignment23.clientid, clientsharingassignment23.userid
128. 0.495 1.294 ↑ 1.0 1,515 1

Hash (cost=290.15..290.15 rows=1,515 width=8) (actual time=1.294..1.294 rows=1,515 loops=1)

  • Output: clients22.id, clients22.clientmanageruserid
  • Buckets: 2048 Batches: 1 Memory Usage: 70kB
  • Buffers: shared hit=275
129. 0.799 0.799 ↑ 1.0 1,515 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients22 (cost=0.00..290.15 rows=1,515 width=8) (actual time=0.003..0.799 rows=1,515 loops=1)

  • Output: clients22.id, clients22.clientmanageruserid
  • Buffers: shared hit=275
130. 0.003 0.003 ↓ 0.0 0 1

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment20 (cost=0.15..45.06 rows=2,260 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: projectsharingassignment20.projectid, projectsharingassignment20.userid
  • Heap Fetches: 0
  • Buffers: shared hit=1
131.          

SubPlan (forMerge Left Join)

132. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project24 (cost=0.29..2.30 rows=1 width=0) (never executed)

  • Index Cond: (project24.id = project19.id)
  • Heap Fetches: 0
133. 9.575 9.575 ↑ 1.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project24_1 (cost=0.29..1,482.54 rows=15,150 width=4) (actual time=0.009..9.575 rows=15,150 loops=1)

  • Output: project24_1.id
  • Heap Fetches: 19840
  • Buffers: shared hit=8872
134. 16.072 79.584 ↓ 1.9 15,150 1

Merge Left Join (cost=3,176.96..11,075.51 rows=7,928 width=4) (actual time=39.793..79.584 rows=15,150 loops=1)

  • Output: project25.id
  • Merge Cond: (project25.id = projectsharingassignment26.projectid)
  • Filter: ((alternatives: SubPlan 19 or hashed SubPlan 20) OR (project25.projectleaderapproverid = 2) OR (projectsharingassignment26.userid = 2) OR (clients28.clientmanageruserid = 2) OR (clientsharingassignment29.userid = 2))
  • Buffers: shared hit=38595
135. 14.499 54.730 ↑ 1.0 15,150 1

Merge Left Join (cost=3,176.80..5,544.43 rows=15,700 width=16) (actual time=25.233..54.730 rows=15,150 loops=1)

  • Output: project25.id, project25.projectleaderapproverid, clients28.clientmanageruserid, clientsharingassignment29.userid
  • Merge Cond: (project25.id = projectclient27.projectid)
  • Buffers: shared hit=29722
136. 10.727 10.727 ↑ 1.0 15,150 1

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project25 (cost=0.29..2,094.53 rows=15,150 width=8) (actual time=0.007..10.727 rows=15,150 loops=1)

  • Output: project25.id, project25.guidid, project25.name, project25.slug, project25.code, project25.clientid, project25.projectleaderapproverid, project25.projectstatuslabelid, project25.isprojectleaderapprovalrequired, project25.startdate, project25.enddate, project25.programid, project25.billingtype, project25.fixedbidamount, project25.fixedbidcurrencyid, project25.fixedbidfrequency, project25.timeentrycappercent, project25.costtype, project25.clientbillingallocationmethod, project25.description, project25.percentcomplete, project25.istimeentryallowed, project25.estimatedhours, project25.estimatedexpenses, project25.estimatedexpensescurrencyid, project25.estimatedcost, project25.estimatedcostcurrencyid, project25.timeandexpenseentrytype, project25.estimationmode, project25.billingratefrequencyid, project25.billingratefrequencyduration, project25.defaultbillingcurrencyid, project25.billingcontractid, project25.projecthealthstateid, project25.projecthealthstatedescription, project25.totalestimatedcontractamount, project25.totalestimatedcontractcurrencyid, project25.budgetedhours, project25.budgetedcost, project25.budgetedcostcurrencyid, project25.info1, project25.info2, project25.info3, project25.info4, project25.info5, project25.info6, project25.info7, project25.info8, project25.info9, project25.info10, project25.info11, project25.info12, project25.info13, project25.info14, project25.info15, project25.info16, project25.info17, project25.info18, project25.info19, project25.info20
  • Buffers: shared hit=13206
137. 8.847 29.504 ↑ 1.0 15,150 1

Sort (cost=3,176.52..3,215.77 rows=15,700 width=12) (actual time=25.222..29.504 rows=15,150 loops=1)

  • Output: projectclient27.projectid, clients28.clientmanageruserid, clientsharingassignment29.userid
  • Sort Key: projectclient27.projectid
  • Sort Method: quicksort Memory: 1095kB
  • Buffers: shared hit=16516
138. 8.517 20.657 ↑ 1.0 15,150 1

Hash Left Join (cost=376.29..2,082.35 rows=15,700 width=12) (actual time=2.146..20.657 rows=15,150 loops=1)

  • Output: projectclient27.projectid, clients28.clientmanageruserid, clientsharingassignment29.userid
  • Hash Cond: (projectclient27.clientid = clients28.id)
  • Buffers: shared hit=16516
139. 10.015 10.015 ↑ 1.0 15,150 1

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient27 (cost=0.29..1,492.54 rows=15,150 width=8) (actual time=0.009..10.015 rows=15,150 loops=1)

  • Output: projectclient27.projectid, projectclient27.clientid, projectclient27.effectivedate, projectclient27.enddate
  • Heap Fetches: 19876
  • Buffers: shared hit=16241
140. 0.437 2.125 ↑ 1.0 1,515 1

Hash (cost=356.38..356.38 rows=1,570 width=12) (actual time=2.125..2.125 rows=1,515 loops=1)

  • Output: clients28.id, clients28.clientmanageruserid, clientsharingassignment29.userid
  • Buckets: 2048 Batches: 1 Memory Usage: 70kB
  • Buffers: shared hit=275
141. 0.399 1.688 ↑ 1.0 1,515 1

Hash Right Join (cost=309.09..356.38 rows=1,570 width=12) (actual time=1.296..1.688 rows=1,515 loops=1)

  • Output: clients28.id, clients28.clientmanageruserid, clientsharingassignment29.userid
  • Hash Cond: (clientsharingassignment29.clientid = clients28.id)
  • Buffers: shared hit=275
142. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment29 (cost=0.00..25.70 rows=1,570 width=8) (actual time=0.000..0.000 rows=0 loops=1)

  • Output: clientsharingassignment29.id, clientsharingassignment29.clientid, clientsharingassignment29.userid
143. 0.484 1.289 ↑ 1.0 1,515 1

Hash (cost=290.15..290.15 rows=1,515 width=8) (actual time=1.289..1.289 rows=1,515 loops=1)

  • Output: clients28.id, clients28.clientmanageruserid
  • Buckets: 2048 Batches: 1 Memory Usage: 70kB
  • Buffers: shared hit=275
144. 0.805 0.805 ↑ 1.0 1,515 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients28 (cost=0.00..290.15 rows=1,515 width=8) (actual time=0.002..0.805 rows=1,515 loops=1)

  • Output: clients28.id, clients28.clientmanageruserid
  • Buffers: shared hit=275
145. 0.002 0.002 ↓ 0.0 0 1

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment26 (cost=0.15..45.06 rows=2,260 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: projectsharingassignment26.projectid, projectsharingassignment26.userid
  • Heap Fetches: 0
  • Buffers: shared hit=1
146.          

SubPlan (forMerge Left Join)

147. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project30 (cost=0.29..2.30 rows=1 width=0) (never executed)

  • Index Cond: (project30.id = project25.id)
  • Heap Fetches: 0
148. 8.780 8.780 ↑ 1.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project30_1 (cost=0.29..1,482.54 rows=15,150 width=4) (actual time=0.008..8.780 rows=15,150 loops=1)

  • Output: project30_1.id
  • Heap Fetches: 19840
  • Buffers: shared hit=8872
149. 30.300 60.600 ↑ 1.0 1 15,150

Aggregate (cost=2.31..2.32 rows=1 width=0) (actual time=0.003..0.004 rows=1 loops=15,150)

  • Output: count(*)
  • Buffers: shared hit=48474
150. 30.300 30.300 ↑ 1.0 1 15,150

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient31 (cost=0.29..2.31 rows=1 width=0) (actual time=0.001..0.002 rows=1 loops=15,150)

  • Output: projectclient31.projectid, projectclient31.clientid, projectclient31.effectivedate, projectclient31.enddate
  • Index Cond: ((projectclient31.projectid = "*SELECT* 1".projectid) AND (projectclient31.effectivedate <= '2019-08-08'::date) AND (projectclient31.enddate >= '2019-08-08'::date))
  • Heap Fetches: 19876
  • Buffers: shared hit=48474
151. 16.463 80.296 ↓ 1.9 15,150 1

Merge Left Join (cost=3,176.96..11,075.51 rows=7,928 width=4) (actual time=40.531..80.296 rows=15,150 loops=1)

  • Output: project32.id
  • Merge Cond: (project32.id = projectsharingassignment33.projectid)
  • Filter: ((alternatives: SubPlan 23 or hashed SubPlan 24) OR (project32.projectleaderapproverid = 2) OR (projectsharingassignment33.userid = 2) OR (clients35.clientmanageruserid = 2) OR (clientsharingassignment36.userid = 2))
  • Buffers: shared hit=38595
152. 13.985 54.626 ↑ 1.0 15,150 1

Merge Left Join (cost=3,176.80..5,544.43 rows=15,700 width=16) (actual time=25.199..54.626 rows=15,150 loops=1)

  • Output: project32.id, project32.projectleaderapproverid, clients35.clientmanageruserid, clientsharingassignment36.userid
  • Merge Cond: (project32.id = projectclient34.projectid)
  • Buffers: shared hit=29722
153. 10.925 10.925 ↑ 1.0 15,150 1

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project32 (cost=0.29..2,094.53 rows=15,150 width=8) (actual time=0.006..10.925 rows=15,150 loops=1)

  • Output: project32.id, project32.guidid, project32.name, project32.slug, project32.code, project32.clientid, project32.projectleaderapproverid, project32.projectstatuslabelid, project32.isprojectleaderapprovalrequired, project32.startdate, project32.enddate, project32.programid, project32.billingtype, project32.fixedbidamount, project32.fixedbidcurrencyid, project32.fixedbidfrequency, project32.timeentrycappercent, project32.costtype, project32.clientbillingallocationmethod, project32.description, project32.percentcomplete, project32.istimeentryallowed, project32.estimatedhours, project32.estimatedexpenses, project32.estimatedexpensescurrencyid, project32.estimatedcost, project32.estimatedcostcurrencyid, project32.timeandexpenseentrytype, project32.estimationmode, project32.billingratefrequencyid, project32.billingratefrequencyduration, project32.defaultbillingcurrencyid, project32.billingcontractid, project32.projecthealthstateid, project32.projecthealthstatedescription, project32.totalestimatedcontractamount, project32.totalestimatedcontractcurrencyid, project32.budgetedhours, project32.budgetedcost, project32.budgetedcostcurrencyid, project32.info1, project32.info2, project32.info3, project32.info4, project32.info5, project32.info6, project32.info7, project32.info8, project32.info9, project32.info10, project32.info11, project32.info12, project32.info13, project32.info14, project32.info15, project32.info16, project32.info17, project32.info18, project32.info19, project32.info20
  • Buffers: shared hit=13206
154. 9.011 29.716 ↑ 1.0 15,150 1

Sort (cost=3,176.52..3,215.77 rows=15,700 width=12) (actual time=25.190..29.716 rows=15,150 loops=1)

  • Output: projectclient34.projectid, clients35.clientmanageruserid, clientsharingassignment36.userid
  • Sort Key: projectclient34.projectid
  • Sort Method: quicksort Memory: 1095kB
  • Buffers: shared hit=16516
155. 8.564 20.705 ↑ 1.0 15,150 1

Hash Left Join (cost=376.29..2,082.35 rows=15,700 width=12) (actual time=2.108..20.705 rows=15,150 loops=1)

  • Output: projectclient34.projectid, clients35.clientmanageruserid, clientsharingassignment36.userid
  • Hash Cond: (projectclient34.clientid = clients35.id)
  • Buffers: shared hit=16516
156. 10.050 10.050 ↑ 1.0 15,150 1

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient34 (cost=0.29..1,492.54 rows=15,150 width=8) (actual time=0.005..10.050 rows=15,150 loops=1)

  • Output: projectclient34.projectid, projectclient34.clientid, projectclient34.effectivedate, projectclient34.enddate
  • Heap Fetches: 19876
  • Buffers: shared hit=16241
157. 0.422 2.091 ↑ 1.0 1,515 1

Hash (cost=356.38..356.38 rows=1,570 width=12) (actual time=2.091..2.091 rows=1,515 loops=1)

  • Output: clients35.id, clients35.clientmanageruserid, clientsharingassignment36.userid
  • Buckets: 2048 Batches: 1 Memory Usage: 70kB
  • Buffers: shared hit=275
158. 0.405 1.669 ↑ 1.0 1,515 1

Hash Right Join (cost=309.09..356.38 rows=1,570 width=12) (actual time=1.271..1.669 rows=1,515 loops=1)

  • Output: clients35.id, clients35.clientmanageruserid, clientsharingassignment36.userid
  • Hash Cond: (clientsharingassignment36.clientid = clients35.id)
  • Buffers: shared hit=275
159. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment36 (cost=0.00..25.70 rows=1,570 width=8) (actual time=0.000..0.000 rows=0 loops=1)

  • Output: clientsharingassignment36.id, clientsharingassignment36.clientid, clientsharingassignment36.userid
160. 0.489 1.264 ↑ 1.0 1,515 1

Hash (cost=290.15..290.15 rows=1,515 width=8) (actual time=1.264..1.264 rows=1,515 loops=1)

  • Output: clients35.id, clients35.clientmanageruserid
  • Buckets: 2048 Batches: 1 Memory Usage: 70kB
  • Buffers: shared hit=275
161. 0.775 0.775 ↑ 1.0 1,515 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients35 (cost=0.00..290.15 rows=1,515 width=8) (actual time=0.003..0.775 rows=1,515 loops=1)

  • Output: clients35.id, clients35.clientmanageruserid
  • Buffers: shared hit=275
162. 0.002 0.002 ↓ 0.0 0 1

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment33 (cost=0.15..45.06 rows=2,260 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: projectsharingassignment33.projectid, projectsharingassignment33.userid
  • Heap Fetches: 0
  • Buffers: shared hit=1
163.          

SubPlan (forMerge Left Join)

164. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project37 (cost=0.29..2.30 rows=1 width=0) (never executed)

  • Index Cond: (project37.id = project32.id)
  • Heap Fetches: 0
165. 9.205 9.205 ↑ 1.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project37_1 (cost=0.29..1,482.54 rows=15,150 width=4) (actual time=0.009..9.205 rows=15,150 loops=1)

  • Output: project37_1.id
  • Heap Fetches: 19840
  • Buffers: shared hit=8872
166. 15.150 45.450 ↑ 1.0 1 15,150

HashAggregate (cost=2.31..2.32 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=15,150)

  • Output: projectclient38.effectivedate
  • Group Key: projectclient38.effectivedate
  • Buffers: shared hit=48474
167. 30.300 30.300 ↑ 1.0 1 15,150

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient38 (cost=0.29..2.31 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=15,150)

  • Output: projectclient38.effectivedate
  • Index Cond: ((projectclient38.projectid = "*SELECT* 1".projectid) AND (projectclient38.effectivedate <= '2019-08-08'::date) AND (projectclient38.enddate >= '2019-08-08'::date))
  • Heap Fetches: 19876
  • Buffers: shared hit=48474
168. 17.280 83.057 ↓ 1.9 15,150 1

Merge Left Join (cost=3,176.96..11,075.51 rows=7,928 width=4) (actual time=41.200..83.057 rows=15,150 loops=1)

  • Output: project39.id
  • Merge Cond: (project39.id = projectsharingassignment40.projectid)
  • Filter: ((alternatives: SubPlan 27 or hashed SubPlan 28) OR (project39.projectleaderapproverid = 2) OR (projectsharingassignment40.userid = 2) OR (clients42.clientmanageruserid = 2) OR (clientsharingassignment43.userid = 2))
  • Buffers: shared hit=38595
169. 14.668 56.549 ↑ 1.0 15,150 1

Merge Left Join (cost=3,176.80..5,544.43 rows=15,700 width=16) (actual time=25.663..56.549 rows=15,150 loops=1)

  • Output: project39.id, project39.projectleaderapproverid, clients42.clientmanageruserid, clientsharingassignment43.userid
  • Merge Cond: (project39.id = projectclient41.projectid)
  • Buffers: shared hit=29722
170. 11.573 11.573 ↑ 1.0 15,150 1

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project39 (cost=0.29..2,094.53 rows=15,150 width=8) (actual time=0.006..11.573 rows=15,150 loops=1)

  • 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
  • Buffers: shared hit=13206
171. 9.415 30.308 ↑ 1.0 15,150 1

Sort (cost=3,176.52..3,215.77 rows=15,700 width=12) (actual time=25.652..30.308 rows=15,150 loops=1)

  • Output: projectclient41.projectid, clients42.clientmanageruserid, clientsharingassignment43.userid
  • Sort Key: projectclient41.projectid
  • Sort Method: quicksort Memory: 1095kB
  • Buffers: shared hit=16516
172. 8.621 20.893 ↑ 1.0 15,150 1

Hash Left Join (cost=376.29..2,082.35 rows=15,700 width=12) (actual time=2.127..20.893 rows=15,150 loops=1)

  • Output: projectclient41.projectid, clients42.clientmanageruserid, clientsharingassignment43.userid
  • Hash Cond: (projectclient41.clientid = clients42.id)
  • Buffers: shared hit=16516
173. 10.168 10.168 ↑ 1.0 15,150 1

Index Only Scan using uix4pc_projectclienteffectiveend on "34e710cb4d124bfa8acf81ac5cefbe18".projectclient projectclient41 (cost=0.29..1,492.54 rows=15,150 width=8) (actual time=0.007..10.168 rows=15,150 loops=1)

  • Output: projectclient41.projectid, projectclient41.clientid, projectclient41.effectivedate, projectclient41.enddate
  • Heap Fetches: 19876
  • Buffers: shared hit=16241
174. 0.440 2.104 ↑ 1.0 1,515 1

Hash (cost=356.38..356.38 rows=1,570 width=12) (actual time=2.104..2.104 rows=1,515 loops=1)

  • Output: clients42.id, clients42.clientmanageruserid, clientsharingassignment43.userid
  • Buckets: 2048 Batches: 1 Memory Usage: 70kB
  • Buffers: shared hit=275
175. 0.398 1.664 ↑ 1.0 1,515 1

Hash Right Join (cost=309.09..356.38 rows=1,570 width=12) (actual time=1.277..1.664 rows=1,515 loops=1)

  • Output: clients42.id, clients42.clientmanageruserid, clientsharingassignment43.userid
  • Hash Cond: (clientsharingassignment43.clientid = clients42.id)
  • Buffers: shared hit=275
176. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".clientsharingassignment clientsharingassignment43 (cost=0.00..25.70 rows=1,570 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: clientsharingassignment43.id, clientsharingassignment43.clientid, clientsharingassignment43.userid
177. 0.474 1.265 ↑ 1.0 1,515 1

Hash (cost=290.15..290.15 rows=1,515 width=8) (actual time=1.265..1.265 rows=1,515 loops=1)

  • Output: clients42.id, clients42.clientmanageruserid
  • Buckets: 2048 Batches: 1 Memory Usage: 70kB
  • Buffers: shared hit=275
178. 0.791 0.791 ↑ 1.0 1,515 1

Seq Scan on "34e710cb4d124bfa8acf81ac5cefbe18".clients clients42 (cost=0.00..290.15 rows=1,515 width=8) (actual time=0.003..0.791 rows=1,515 loops=1)

  • Output: clients42.id, clients42.clientmanageruserid
  • Buffers: shared hit=275
179. 0.002 0.002 ↓ 0.0 0 1

Index Only Scan using projectsharingassignment_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".projectsharingassignment projectsharingassignment40 (cost=0.15..45.06 rows=2,260 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: projectsharingassignment40.projectid, projectsharingassignment40.userid
  • Heap Fetches: 0
  • Buffers: shared hit=1
180.          

SubPlan (forMerge Left Join)

181. 0.000 0.000 ↓ 0.0 0

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project44 (cost=0.29..2.30 rows=1 width=0) (never executed)

  • Index Cond: (project44.id = project39.id)
  • Heap Fetches: 0
182. 9.226 9.226 ↑ 1.0 15,150 1

Index Only Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project44_1 (cost=0.29..1,482.54 rows=15,150 width=4) (actual time=0.008..9.226 rows=15,150 loops=1)

  • Output: project44_1.id
  • Heap Fetches: 19840
  • Buffers: shared hit=8872
183. 30.300 30.300 ↑ 1.0 1 15,150

Index Scan using project_pkey on "34e710cb4d124bfa8acf81ac5cefbe18".project project45 (cost=0.29..2.30 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=15,150)

  • Output: project45.clientbillingallocationmethod
  • Index Cond: (project45.id = "*SELECT* 1".projectid)
  • Buffers: shared hit=46030
Planning time : 8.286 ms
Execution time : 1,593.607 ms