explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yScK : WCG_Vacuum

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 40,287.203 ↑ 1.0 11 1

Limit (cost=48,800,568.07..48,800,568.09 rows=11 width=152) (actual time=40,287.195..40,287.203 rows=11 loops=1)

  • Output: ts.id, c.id, ((c.name)::character varying(255)), ((c.slug)::character varying(255)), ((c.code)::character varying(50)), p.id, ((p.name)::character varying(255)), ((p.slug)::character varying(255)), ((p.code)::character varying(50)), task.id, ((task.name)::character varying), ((task.name)::character varying), ((task.code)::character varying), ((0 + (((0 + (CASE WHEN (upper((c.name)::text) ~~ '%A%'::text) THEN true ELSE false END)::integer) + (CASE WHEN (upper((p.name)::text) ~~ '%A%'::text) THEN true ELSE false END)::integer) + (CASE WHEN (upper((task.name)::text) ~~ '%A%'::text) THEN true ELSE false END)::integer)))
  • Buffers: shared hit=4,458,551 read=12,020 written=166
2. 235.824 40,287.196 ↑ 72,621.5 11 1

Sort (cost=48,800,568.07..48,802,565.16 rows=798,836 width=152) (actual time=40,287.193..40,287.196 rows=11 loops=1)

  • Output: ts.id, c.id, ((c.name)::character varying(255)), ((c.slug)::character varying(255)), ((c.code)::character varying(50)), p.id, ((p.name)::character varying(255)), ((p.slug)::character varying(255)), ((p.code)::character varying(50)), task.id, ((task.name)::character varying), ((task.name)::character varying), ((task.code)::character varying), ((0 + (((0 + (CASE WHEN (upper((c.name)::text) ~~ '%A%'::text) THEN true ELSE false END)::integer) + (CASE WHEN (upper((p.name)::text) ~~ '%A%'::text) THEN true ELSE false END)::integer) + (CASE WHEN (upper((task.name)::text) ~~ '%A%'::text) THEN true ELSE false END)::integer)))
  • Sort Key: ((0 + (((0 + (CASE WHEN (upper((c.name)::text) ~~ '%A%'::text) THEN true ELSE false END)::integer) + (CASE WHEN (upper((p.name)::text) ~~ '%A%'::text) THEN true ELSE false END)::integer) + (CASE WHEN (upper((task.name)::text) ~~ '%A%'::text) THEN true ELSE false END)::integer))), ((c.name)::character varying(255)) COLLATE "en_US" NULLS FIRST, ((p.name)::character varying(255)) COLLATE "en_US" NULLS FIRST, ((task.name)::character varying) COLLATE "en_US" NULLS FIRST
  • Sort Method: top-N heapsort Memory: 27kB
  • Buffers: shared hit=4,458,551 read=12,020 written=166
3. 1,175.470 40,051.372 ↑ 3.3 245,076 1

Nested Loop (cost=0.70..48,782,756.29 rows=798,836 width=152) (actual time=21.075..40,051.372 rows=245,076 loops=1)

  • Output: ts.id, c.id, c.name, c.slug, c.code, p.id, p.name, p.slug, p.code, task.id, task.name, task.name, task.code, (0 + (((0 + (CASE WHEN (upper((c.name)::text) ~~ '%A%'::text) THEN true ELSE false END)::integer) + (CASE WHEN (upper((p.name)::text) ~~ '%A%'::text) THEN true ELSE false END)::integer) + (CASE WHEN (upper((task.name)::text) ~~ '%A%'::text) THEN true ELSE false END)::integer))
  • Join Filter: ((upper((c.name)::text) ~~ '%A%'::text) OR (upper((p.name)::text) ~~ '%A%'::text) OR (upper((task.name)::text) ~~ '%A%'::text))
  • Rows Removed by Join Filter: 16,021
  • Buffers: shared hit=4,458,545 read=12,020 written=166
4. 5.098 505.724 ↓ 1.7 1,442 1

Nested Loop Semi Join (cost=0.28..34,856.91 rows=862 width=126) (actual time=9.698..505.724 rows=1,442 loops=1)

  • Output: ts.id, p.id, p.name, p.slug, p.code, projectclient.projectid, c.id, c.name, c.slug, c.code
  • Join Filter: ((SubPlan 39) = projectstatuslabel3.id)
  • Rows Removed by Join Filter: 287
  • Buffers: shared hit=19,686 read=245
5. 11.999 497.168 ↓ 1.0 1,729 1

Nested Loop (cost=0.28..30,871.07 rows=1,725 width=126) (actual time=9.682..497.168 rows=1,729 loops=1)

  • Output: ts.id, p.id, p.name, p.slug, p.code, projectclient.projectid, c.id, c.name, c.slug, c.code
  • Join Filter: (((c.id IS NULL) AND (NOT (alternatives: SubPlan 1 or hashed SubPlan 2))) OR ((c.id IS NOT NULL) AND (SubPlan 3)))
  • Rows Removed by Join Filter: 1,721
  • Buffers: shared hit=14,488 read=245
6. 248.158 468.534 ↑ 1.0 3,450 1

Nested Loop Left Join (cost=0.00..17,308.69 rows=3,450 width=76) (actual time=9.647..468.534 rows=3,450 loops=1)

  • Output: ts.id, projectclient.projectid, c.id, c.name, c.slug, c.code
  • Join Filter: (c.id = projectclient.clientid)
  • Rows Removed by Join Filter: 1,022,928
  • Buffers: shared hit=645 read=245
7. 1.928 16.826 ↑ 1.0 3,450 1

Nested Loop (cost=0.00..1,926.23 rows=3,450 width=24) (actual time=9.624..16.826 rows=3,450 loops=1)

  • Output: ts.id, projectclient.projectid, projectclient.clientid
  • Buffers: shared hit=638 read=243
8. 11.178 11.178 ↑ 1.0 1 1

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".timesheet ts (cost=0.00..1,814.31 rows=1 width=16) (actual time=9.615..11.178 rows=1 loops=1)

  • Output: ts.id, ts.userid, ts.startdate, ts.enddate, ts.approvalstatus, ts.duedate, ts.autosubmitdatetimeutc, ts.lastautosubmitattemptdatetimeutc, ts.createdonutc
  • Filter: (ts.id = '484e44e6-7209-4c91-9351-961796dc98d2'::uuid)
  • Rows Removed by Filter: 77,384
  • Buffers: shared hit=604 read=243
9. 1.661 3.720 ↑ 1.0 3,450 1

Append (cost=0.00..77.42 rows=3,450 width=8) (actual time=0.005..3.720 rows=3,450 loops=1)

  • Buffers: shared hit=34
10. 1.365 1.365 ↑ 1.0 1,722 1

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".projectclient (cost=0.00..39.22 rows=1,722 width=8) (actual time=0.005..1.365 rows=1,722 loops=1)

  • Output: projectclient.projectid, projectclient.clientid
  • Buffers: shared hit=22
11. 0.694 0.694 ↑ 1.0 1,728 1

Index Only Scan using project_pkey on "17f7a637b83349e9b16ef4905eb64944".project project_1 (cost=0.28..38.20 rows=1,728 width=8) (actual time=0.010..0.694 rows=1,728 loops=1)

  • Output: project_1.id, NULL::integer
  • Heap Fetches: 0
  • Buffers: shared hit=12
12. 203.412 203.550 ↑ 1.0 297 3,450

Materialize (cost=0.00..13.46 rows=297 width=56) (actual time=0.000..0.059 rows=297 loops=3,450)

  • Output: c.id, c.name, c.slug, c.code
  • Buffers: shared hit=7 read=2
13. 0.138 0.138 ↑ 1.0 297 1

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".clients c (cost=0.00..11.97 rows=297 width=56) (actual time=0.003..0.138 rows=297 loops=1)

  • Output: c.id, c.name, c.slug, c.code
  • Buffers: shared hit=7 read=2
14. 10.350 10.350 ↑ 1.0 1 3,450

Index Scan using project_pkey on "17f7a637b83349e9b16ef4905eb64944".project p (cost=0.28..0.33 rows=1 width=66) (actual time=0.003..0.003 rows=1 loops=3,450)

  • Output: p.id, p.name, p.slug, p.code, p.programid
  • Index Cond: (p.id = projectclient.projectid)
  • Buffers: shared hit=10,370
15.          

SubPlan (for Nested Loop)

16. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix4pc_projectclienteffectiveend on "17f7a637b83349e9b16ef4905eb64944".projectclient projectclient1 (cost=0.28..2.30 rows=1 width=0) (never executed)

  • Index Cond: ((projectclient1.projectid = p.id) AND (projectclient1.effectivedate <= '2019-09-30'::date) AND (projectclient1.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
17. 1.119 1.119 ↑ 1.0 1,722 1

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".projectclient projectclient1_1 (cost=0.00..47.83 rows=1,722 width=4) (actual time=0.015..1.119 rows=1,722 loops=1)

  • Output: projectclient1_1.projectid
  • Filter: ((projectclient1_1.effectivedate <= '2019-09-30'::date) AND (projectclient1_1.enddate >= '2019-09-22'::date))
  • Buffers: shared hit=22
18. 5.166 5.166 ↑ 1.0 1 1,722

Index Only Scan using uix4pc_projectclienteffectiveend on "17f7a637b83349e9b16ef4905eb64944".projectclient projectclient1_2 (cost=0.28..2.30 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=1,722)

  • Output: projectclient1_2.clientid
  • Index Cond: ((projectclient1_2.projectid = p.id) AND (projectclient1_2.effectivedate <= '2019-09-30'::date) AND (projectclient1_2.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
  • Buffers: shared hit=3,451
19. 0.000 0.000 ↑ 1.0 1 1,729

Materialize (cost=0.00..1.09 rows=1 width=16) (actual time=0.000..0.000 rows=1 loops=1,729)

  • Output: projectstatuslabel3.id
  • Buffers: shared hit=1
20. 0.008 0.008 ↑ 1.0 1 1

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".projectstatuslabel projectstatuslabel3 (cost=0.00..1.09 rows=1 width=16) (actual time=0.005..0.008 rows=1 loops=1)

  • Output: projectstatuslabel3.id
  • Filter: (projectstatuslabel3.projectstatustype = 1)
  • Rows Removed by Filter: 6
  • Buffers: shared hit=1
21.          

SubPlan (for Nested Loop Semi Join)

22. 3.458 3.458 ↑ 1.0 1 1,729

Index Scan using project_pkey on "17f7a637b83349e9b16ef4905eb64944".project project2 (cost=0.28..2.29 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=1,729)

  • Output: project2.projectstatuslabelid
  • Index Cond: (project2.id = p.id)
  • Buffers: shared hit=5,197
23. 128.338 38,370.178 ↓ 1.7 181 1,442

Append (cost=0.42..56,519.27 rows=108 width=34) (actual time=1.276..26.609 rows=181 loops=1,442)

  • Buffers: shared hit=4,438,859 read=11,775 written=166
24. 720.385 38,223.094 ↓ 1.7 181 1,442

Index Scan using ixtkprojectid on "17f7a637b83349e9b16ef4905eb64944".task (cost=0.42..56,257.34 rows=107 width=34) (actual time=1.269..26.507 rows=181 loops=1,442)

  • Output: task.id, task.name, task.code, task.projectid
  • Index Cond: (task.projectid = p.id)
  • Filter: (((task.id IS NULL) AND (SubPlan 4) AND (alternatives: SubPlan 12 or hashed SubPlan 20)) OR ((task.id IS NOT NULL) AND (alternatives: SubPlan 29 or hashed SubPlan 38)))
  • Rows Removed by Filter: 21
  • Buffers: shared hit=4,425,669 read=11,775 written=166
25.          

SubPlan (for Index Scan)

26. 4.326 4.326 ↑ 1.0 1 1,442

Index Scan using project_pkey on "17f7a637b83349e9b16ef4905eb64944".project project4 (cost=0.28..2.29 rows=1 width=1) (actual time=0.003..0.003 rows=1 loops=1,442)

  • Output: project4.istimeentryallowed
  • Index Cond: (project4.id = p.id)
  • Buffers: shared hit=4,335
27. 5.098 5.178 ↓ 0.0 0 863

Index Scan using uix2ptm_projectemptypegrp on "17f7a637b83349e9b16ef4905eb64944".projectteammember projectteammember5 (cost=48.04..199.82 rows=321 width=0) (actual time=0.006..0.006 rows=0 loops=863)

  • Index Cond: (projectteammember5.projectid = p.id)
  • Filter: ((projectteammember5.userid = 376) OR (hashed SubPlan 5) OR (hashed SubPlan 6) OR (hashed SubPlan 7) OR (hashed SubPlan 8) OR (hashed SubPlan 9) OR (hashed SubPlan 10) OR (hashed SubPlan 11))
  • Rows Removed by Filter: 6
  • Buffers: shared hit=5,961
28.          

SubPlan (for Index Scan)

29. 0.008 0.023 ↑ 1.0 2 1

Nested Loop (cost=0.42..4.50 rows=2 width=4) (actual time=0.019..0.023 rows=2 loops=1)

  • Output: departmentflathierarchy6.parentid
  • Buffers: shared hit=5
30. 0.008 0.008 ↑ 1.0 1 1

Index Scan using ixduuserid on "17f7a637b83349e9b16ef4905eb64944".departmentusers departmentusers7 (cost=0.28..2.30 rows=1 width=4) (actual time=0.008..0.008 rows=1 loops=1)

  • Output: departmentusers7.departmentid, departmentusers7.userid, departmentusers7.isprimarydepartment
  • Index Cond: (departmentusers7.userid = 376)
  • Buffers: shared hit=3
31. 0.007 0.007 ↑ 1.0 2 1

Index Scan using ixdfhchildid on "17f7a637b83349e9b16ef4905eb64944".departmentflathierarchy departmentflathierarchy6 (cost=0.14..2.18 rows=2 width=8) (actual time=0.006..0.007 rows=2 loops=1)

  • Output: departmentflathierarchy6.parentid, departmentflathierarchy6.childid, departmentflathierarchy6.depth
  • Index Cond: (departmentflathierarchy6.childid = departmentusers7.departmentid)
  • Buffers: shared hit=2
32. 0.004 0.024 ↑ 1.0 1 1

Nested Loop (cost=0.56..5.63 rows=1 width=16) (actual time=0.022..0.024 rows=1 loops=1)

  • Output: locationflathierarchy8.parentid
  • Buffers: shared hit=6
33. 0.010 0.010 ↑ 1.0 1 1

Index Only Scan using ix4ul_userlocationstartend on "17f7a637b83349e9b16ef4905eb64944".userlocation userlocation9 (cost=0.28..2.30 rows=1 width=16) (actual time=0.009..0.010 rows=1 loops=1)

  • Output: userlocation9.userid, userlocation9.locationid, userlocation9.startdate, userlocation9.enddate
  • Index Cond: ((userlocation9.userid = 376) AND (userlocation9.startdate <= '2019-09-30'::date) AND (userlocation9.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
  • Buffers: shared hit=3
34. 0.010 0.010 ↑ 2.0 1 1

Index Scan using ixlfhchildid on "17f7a637b83349e9b16ef4905eb64944".locationflathierarchy locationflathierarchy8 (cost=0.28..3.31 rows=2 width=32) (actual time=0.009..0.010 rows=1 loops=1)

  • Output: locationflathierarchy8.parentid, locationflathierarchy8.childid, locationflathierarchy8.parentdepth
  • Index Cond: (locationflathierarchy8.childid = userlocation9.locationid)
  • Buffers: shared hit=3
35. 0.000 0.004 ↓ 0.0 0 1

Nested Loop (cost=0.30..8.55 rows=6 width=16) (actual time=0.004..0.004 rows=0 loops=1)

  • Output: divisionflathierarchy10.parentid
  • Buffers: shared hit=1
36. 0.004 0.004 ↓ 0.0 0 1

Index Only Scan using ix4ud_userdivisionstartend on "17f7a637b83349e9b16ef4905eb64944".userdivision userdivision11 (cost=0.15..2.24 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=1)

  • Output: userdivision11.userid, userdivision11.divisionid, userdivision11.startdate, userdivision11.enddate
  • Index Cond: ((userdivision11.userid = 376) AND (userdivision11.startdate <= '2019-09-30'::date) AND (userdivision11.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
  • Buffers: shared hit=1
37. 0.000 0.000 ↓ 0.0 0

Index Scan using ixdivfhchildid on "17f7a637b83349e9b16ef4905eb64944".divisionflathierarchy divisionflathierarchy10 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: divisionflathierarchy10.parentid, divisionflathierarchy10.childid, divisionflathierarchy10.parentdepth
  • Index Cond: (divisionflathierarchy10.childid = userdivision11.divisionid)
38. 0.001 0.004 ↓ 0.0 0 1

Nested Loop (cost=0.30..8.55 rows=6 width=16) (actual time=0.004..0.004 rows=0 loops=1)

  • Output: costcenterflathierarchy12.parentid
  • Buffers: shared hit=1
39. 0.003 0.003 ↓ 0.0 0 1

Index Only Scan using ix4ucc_usercostcenterstartend on "17f7a637b83349e9b16ef4905eb64944".usercostcenter usercostcenter13 (cost=0.15..2.24 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: usercostcenter13.userid, usercostcenter13.costcenterid, usercostcenter13.startdate, usercostcenter13.enddate
  • Index Cond: ((usercostcenter13.userid = 376) AND (usercostcenter13.startdate <= '2019-09-30'::date) AND (usercostcenter13.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
  • Buffers: shared hit=1
40. 0.000 0.000 ↓ 0.0 0

Index Scan using ixccfhchildid on "17f7a637b83349e9b16ef4905eb64944".costcenterflathierarchy costcenterflathierarchy12 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: costcenterflathierarchy12.parentid, costcenterflathierarchy12.childid, costcenterflathierarchy12.parentdepth
  • Index Cond: (costcenterflathierarchy12.childid = usercostcenter13.costcenterid)
41. 0.001 0.004 ↓ 0.0 0 1

Nested Loop (cost=0.30..8.55 rows=6 width=16) (actual time=0.004..0.004 rows=0 loops=1)

  • Output: servicecenterflathierarchy14.parentid
  • Buffers: shared hit=1
42. 0.003 0.003 ↓ 0.0 0 1

Index Only Scan using ix4usc_userservicecenterstartend on "17f7a637b83349e9b16ef4905eb64944".userservicecenter userservicecenter15 (cost=0.15..2.24 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: userservicecenter15.userid, userservicecenter15.servicecenterid, userservicecenter15.startdate, userservicecenter15.enddate
  • Index Cond: ((userservicecenter15.userid = 376) AND (userservicecenter15.startdate <= '2019-09-30'::date) AND (userservicecenter15.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
  • Buffers: shared hit=1
43. 0.000 0.000 ↓ 0.0 0

Index Scan using ixscfhchildid on "17f7a637b83349e9b16ef4905eb64944".servicecenterflathierarchy servicecenterflathierarchy14 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: servicecenterflathierarchy14.parentid, servicecenterflathierarchy14.childid, servicecenterflathierarchy14.parentdepth
  • Index Cond: (servicecenterflathierarchy14.childid = userservicecenter15.servicecenterid)
44. 0.012 0.018 ↓ 0.0 0 1

Nested Loop (cost=0.15..3.20 rows=1 width=16) (actual time=0.018..0.018 rows=0 loops=1)

  • Output: departmentgroupflathierarchy16.parentid
  • Buffers: shared hit=2
45. 0.003 0.003 ↑ 1.0 1 1

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".departmentgroupflathierarchy departmentgroupflathierarchy16 (cost=0.00..1.01 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=1)

  • Output: departmentgroupflathierarchy16.parentid, departmentgroupflathierarchy16.childid, departmentgroupflathierarchy16.parentdepth
  • Buffers: shared hit=1
46. 0.003 0.003 ↓ 0.0 0 1

Index Only Scan using ix4ucc_userdepartmentgroupstartend on "17f7a637b83349e9b16ef4905eb64944".userdepartmentgroup userdepartmentgroup17 (cost=0.15..2.18 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: userdepartmentgroup17.userid, userdepartmentgroup17.departmentgroupid, userdepartmentgroup17.startdate, userdepartmentgroup17.enddate
  • Index Cond: ((userdepartmentgroup17.userid = 376) AND (userdepartmentgroup17.departmentgroupid = departmentgroupflathierarchy16.childid) AND (userdepartmentgroup17.startdate <= '2019-09-30'::date) AND (userdepartmentgroup17.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
  • Buffers: shared hit=1
47. 0.000 0.003 ↓ 0.0 0 1

Nested Loop (cost=0.30..8.55 rows=6 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: ployeetypegroupflathierarchy18.parentid
  • Buffers: shared hit=1
48. 0.003 0.003 ↓ 0.0 0 1

Index Only Scan using ix4ucc_useremployeetypegroupstartend on "17f7a637b83349e9b16ef4905eb64944".useremployeetypegroup useremployeetypegroup19 (cost=0.15..2.24 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: useremployeetypegroup19.userid, useremployeetypegroup19.employeetypegroupid, useremployeetypegroup19.startdate, useremployeetypegroup19.enddate
  • Index Cond: ((useremployeetypegroup19.userid = 376) AND (useremployeetypegroup19.startdate <= '2019-09-30'::date) AND (useremployeetypegroup19.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
  • Buffers: shared hit=1
49. 0.000 0.000 ↓ 0.0 0

Index Scan using ixetgfhchildid on "17f7a637b83349e9b16ef4905eb64944".employeetypegroupflathierarchy ployeetypegroupflathierarchy18 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: ployeetypegroupflathierarchy18.parentid, ployeetypegroupflathierarchy18.childid, ployeetypegroupflathierarchy18.parentdepth
  • Index Cond: (ployeetypegroupflathierarchy18.childid = useremployeetypegroup19.employeetypegroupid)
50. 0.000 0.000 ↓ 0.0 0

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".projectteammember projectteammember5_1 (cost=47.61..17,484.08 rows=463,105 width=4) (never executed)

  • Output: projectteammember5_1.projectid
  • Filter: ((projectteammember5_1.userid = 376) OR (hashed SubPlan 13) OR (hashed SubPlan 14) OR (hashed SubPlan 15) OR (hashed SubPlan 16) OR (hashed SubPlan 17) OR (hashed SubPlan 18) OR (hashed SubPlan 19))
51.          

SubPlan (for Seq Scan)

52. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..4.50 rows=2 width=4) (never executed)

  • Output: departmentflathierarchy6_1.parentid
53. 0.000 0.000 ↓ 0.0 0

Index Scan using ixduuserid on "17f7a637b83349e9b16ef4905eb64944".departmentusers departmentusers7_1 (cost=0.28..2.30 rows=1 width=4) (never executed)

  • Output: departmentusers7_1.departmentid, departmentusers7_1.userid, departmentusers7_1.isprimarydepartment
  • Index Cond: (departmentusers7_1.userid = 376)
54. 0.000 0.000 ↓ 0.0 0

Index Scan using ixdfhchildid on "17f7a637b83349e9b16ef4905eb64944".departmentflathierarchy departmentflathierarchy6_1 (cost=0.14..2.18 rows=2 width=8) (never executed)

  • Output: departmentflathierarchy6_1.parentid, departmentflathierarchy6_1.childid, departmentflathierarchy6_1.depth
  • Index Cond: (departmentflathierarchy6_1.childid = departmentusers7_1.departmentid)
55. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..5.63 rows=1 width=16) (never executed)

  • Output: locationflathierarchy8_1.parentid
56. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix4ul_userlocationstartend on "17f7a637b83349e9b16ef4905eb64944".userlocation userlocation9_1 (cost=0.28..2.30 rows=1 width=16) (never executed)

  • Output: userlocation9_1.userid, userlocation9_1.locationid, userlocation9_1.startdate, userlocation9_1.enddate
  • Index Cond: ((userlocation9_1.userid = 376) AND (userlocation9_1.startdate <= '2019-09-30'::date) AND (userlocation9_1.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
57. 0.000 0.000 ↓ 0.0 0

Index Scan using ixlfhchildid on "17f7a637b83349e9b16ef4905eb64944".locationflathierarchy locationflathierarchy8_1 (cost=0.28..3.31 rows=2 width=32) (never executed)

  • Output: locationflathierarchy8_1.parentid, locationflathierarchy8_1.childid, locationflathierarchy8_1.parentdepth
  • Index Cond: (locationflathierarchy8_1.childid = userlocation9_1.locationid)
58. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.30..8.55 rows=6 width=16) (never executed)

  • Output: divisionflathierarchy10_1.parentid
59. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix4ud_userdivisionstartend on "17f7a637b83349e9b16ef4905eb64944".userdivision userdivision11_1 (cost=0.15..2.24 rows=1 width=16) (never executed)

  • Output: userdivision11_1.userid, userdivision11_1.divisionid, userdivision11_1.startdate, userdivision11_1.enddate
  • Index Cond: ((userdivision11_1.userid = 376) AND (userdivision11_1.startdate <= '2019-09-30'::date) AND (userdivision11_1.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
60. 0.000 0.000 ↓ 0.0 0

Index Scan using ixdivfhchildid on "17f7a637b83349e9b16ef4905eb64944".divisionflathierarchy divisionflathierarchy10_1 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: divisionflathierarchy10_1.parentid, divisionflathierarchy10_1.childid, divisionflathierarchy10_1.parentdepth
  • Index Cond: (divisionflathierarchy10_1.childid = userdivision11_1.divisionid)
61. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.30..8.55 rows=6 width=16) (never executed)

  • Output: costcenterflathierarchy12_1.parentid
62. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix4ucc_usercostcenterstartend on "17f7a637b83349e9b16ef4905eb64944".usercostcenter usercostcenter13_1 (cost=0.15..2.24 rows=1 width=16) (never executed)

  • Output: usercostcenter13_1.userid, usercostcenter13_1.costcenterid, usercostcenter13_1.startdate, usercostcenter13_1.enddate
  • Index Cond: ((usercostcenter13_1.userid = 376) AND (usercostcenter13_1.startdate <= '2019-09-30'::date) AND (usercostcenter13_1.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
63. 0.000 0.000 ↓ 0.0 0

Index Scan using ixccfhchildid on "17f7a637b83349e9b16ef4905eb64944".costcenterflathierarchy costcenterflathierarchy12_1 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: costcenterflathierarchy12_1.parentid, costcenterflathierarchy12_1.childid, costcenterflathierarchy12_1.parentdepth
  • Index Cond: (costcenterflathierarchy12_1.childid = usercostcenter13_1.costcenterid)
64. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.30..8.55 rows=6 width=16) (never executed)

  • Output: servicecenterflathierarchy14_1.parentid
65. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix4usc_userservicecenterstartend on "17f7a637b83349e9b16ef4905eb64944".userservicecenter userservicecenter15_1 (cost=0.15..2.24 rows=1 width=16) (never executed)

  • Output: userservicecenter15_1.userid, userservicecenter15_1.servicecenterid, userservicecenter15_1.startdate, userservicecenter15_1.enddate
  • Index Cond: ((userservicecenter15_1.userid = 376) AND (userservicecenter15_1.startdate <= '2019-09-30'::date) AND (userservicecenter15_1.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
66. 0.000 0.000 ↓ 0.0 0

Index Scan using ixscfhchildid on "17f7a637b83349e9b16ef4905eb64944".servicecenterflathierarchy servicecenterflathierarchy14_1 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: servicecenterflathierarchy14_1.parentid, servicecenterflathierarchy14_1.childid, servicecenterflathierarchy14_1.parentdepth
  • Index Cond: (servicecenterflathierarchy14_1.childid = userservicecenter15_1.servicecenterid)
67. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.15..3.20 rows=1 width=16) (never executed)

  • Output: departmentgroupflathierarchy16_1.parentid
68. 0.000 0.000 ↓ 0.0 0

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".departmentgroupflathierarchy departmentgroupflathierarchy16_1 (cost=0.00..1.01 rows=1 width=32) (never executed)

  • Output: departmentgroupflathierarchy16_1.parentid, departmentgroupflathierarchy16_1.childid, departmentgroupflathierarchy16_1.parentdepth
69. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix4ucc_userdepartmentgroupstartend on "17f7a637b83349e9b16ef4905eb64944".userdepartmentgroup userdepartmentgroup17_1 (cost=0.15..2.18 rows=1 width=16) (never executed)

  • Output: userdepartmentgroup17_1.userid, userdepartmentgroup17_1.departmentgroupid, userdepartmentgroup17_1.startdate, userdepartmentgroup17_1.enddate
  • Index Cond: ((userdepartmentgroup17_1.userid = 376) AND (userdepartmentgroup17_1.departmentgroupid = departmentgroupflathierarchy16_1.childid) AND (userdepartmentgroup17_1.startdate <= '2019-09-30'::date) AND (userdepartmentgroup17_1.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
70. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.30..8.55 rows=6 width=16) (never executed)

  • Output: ployeetypegroupflathierarchy18_1.parentid
71. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix4ucc_useremployeetypegroupstartend on "17f7a637b83349e9b16ef4905eb64944".useremployeetypegroup useremployeetypegroup19_1 (cost=0.15..2.24 rows=1 width=16) (never executed)

  • Output: useremployeetypegroup19_1.userid, useremployeetypegroup19_1.employeetypegroupid, useremployeetypegroup19_1.startdate, useremployeetypegroup19_1.enddate
  • Index Cond: ((useremployeetypegroup19_1.userid = 376) AND (useremployeetypegroup19_1.startdate <= '2019-09-30'::date) AND (useremployeetypegroup19_1.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
72. 0.000 0.000 ↓ 0.0 0

Index Scan using ixetgfhchildid on "17f7a637b83349e9b16ef4905eb64944".employeetypegroupflathierarchy ployeetypegroupflathierarchy18_1 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: ployeetypegroupflathierarchy18_1.parentid, ployeetypegroupflathierarchy18_1.childid, ployeetypegroupflathierarchy18_1.parentdepth
  • Index Cond: (ployeetypegroupflathierarchy18_1.childid = useremployeetypegroup19_1.employeetypegroupid)
73. 335.055 37,493.205 ↑ 1.0 1 290,645

Nested Loop (cost=53.78..210.83 rows=1 width=0) (actual time=0.129..0.129 rows=1 loops=290,645)

  • Buffers: shared hit=4,360,475 read=10,143 written=148
74.          

Initplan (for Nested Loop)

75. 2.922 2.922 ↓ 0.0 0 1

Index Scan using ixtspss2key on "17f7a637b83349e9b16ef4905eb64944".timesheetpolicysettingssnapshot esheetpolicysettingssnapshot37 (cost=0.68..3.72 rows=1 width=0) (actual time=2.922..2.922 rows=0 loops=1)

  • Index Cond: ((upper(esheetpolicysettingssnapshot37.key) = 'URN:REPLICON:POLICY:TIMESHEET:TASK-DATERANGE-ENTRY-OVERRIDE'::text) AND (upper(esheetpolicysettingssnapshot37.uri) = 'URN:REPLICON:POLICY:TIMESHEET:TASK-DATERANGE-ENTRY-OVERRIDE:OVERRIDE-TASK-DATERANGE-ENTRY'::text))
  • Filter: (esheetpolicysettingssnapshot37.timesheetid = '484e44e6-7209-4c91-9351-961796dc98d2'::uuid)
  • Buffers: shared read=5
76. 1,007.969 36,039.980 ↑ 1.0 1 290,645

Hash Join (cost=49.64..204.65 rows=1 width=4) (actual time=0.117..0.124 rows=1 loops=290,645)

  • Output: taskteammemberassignment21.taskid
  • Hash Cond: (projectteammember20.id = taskteammemberassignment21.projectteammemberid)
  • Buffers: shared hit=3,245,411 read=9,138 written=134
77. 32,123.881 32,125.561 ↑ 321.0 1 284,297

Index Scan using uix2ptm_projectemptypegrp on "17f7a637b83349e9b16ef4905eb64944".projectteammember projectteammember20 (cost=48.04..199.82 rows=321 width=16) (actual time=0.082..0.113 rows=1 loops=284,297)

  • Output: projectteammember20.id, projectteammember20.projectid, projectteammember20.userid, projectteammember20.departmentid, projectteammember20.placeholderprojectroleid, projectteammember20.index, projectteammember20.placeholderdisplayname, projectteammember20.locationid, projectteammember20.divisionid, projectteammember20.costcenterid, projectteammember20.servicecenterid, projectteammember20.departmentgroupid, projectteammember20.employeetypegroupid
  • Index Cond: (projectteammember20.projectid = p.id)
  • Filter: ((projectteammember20.userid = 376) OR (hashed SubPlan 21) OR (hashed SubPlan 22) OR (hashed SubPlan 23) OR (hashed SubPlan 24) OR (hashed SubPlan 25) OR (hashed SubPlan 26) OR (hashed SubPlan 27))
  • Rows Removed by Filter: 322
  • Buffers: shared hit=2,371,717 read=4,019 written=65
78.          

SubPlan (for Index Scan)

79. 0.005 0.049 ↑ 1.0 2 1

Nested Loop (cost=0.42..4.50 rows=2 width=4) (actual time=0.047..0.049 rows=2 loops=1)

  • Output: departmentflathierarchy23.parentid
  • Buffers: shared hit=1 read=4
80. 0.022 0.022 ↑ 1.0 1 1

Index Scan using ixduuserid on "17f7a637b83349e9b16ef4905eb64944".departmentusers departmentusers24 (cost=0.28..2.30 rows=1 width=4) (actual time=0.022..0.022 rows=1 loops=1)

  • Output: departmentusers24.departmentid, departmentusers24.userid, departmentusers24.isprimarydepartment
  • Index Cond: (departmentusers24.userid = 376)
  • Buffers: shared hit=1 read=2
81. 0.022 0.022 ↑ 1.0 2 1

Index Scan using ixdfhchildid on "17f7a637b83349e9b16ef4905eb64944".departmentflathierarchy departmentflathierarchy23 (cost=0.14..2.18 rows=2 width=8) (actual time=0.022..0.022 rows=2 loops=1)

  • Output: departmentflathierarchy23.parentid, departmentflathierarchy23.childid, departmentflathierarchy23.depth
  • Index Cond: (departmentflathierarchy23.childid = departmentusers24.departmentid)
  • Buffers: shared read=2
82. 0.005 1.100 ↑ 1.0 1 1

Nested Loop (cost=0.56..5.63 rows=1 width=16) (actual time=1.098..1.100 rows=1 loops=1)

  • Output: locationflathierarchy25.parentid
  • Buffers: shared hit=3 read=3
83. 1.080 1.080 ↑ 1.0 1 1

Index Only Scan using ix4ul_userlocationstartend on "17f7a637b83349e9b16ef4905eb64944".userlocation userlocation26 (cost=0.28..2.30 rows=1 width=16) (actual time=1.080..1.080 rows=1 loops=1)

  • Output: userlocation26.userid, userlocation26.locationid, userlocation26.startdate, userlocation26.enddate
  • Index Cond: ((userlocation26.userid = 376) AND (userlocation26.startdate <= '2019-09-30'::date) AND (userlocation26.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
  • Buffers: shared hit=1 read=2
84. 0.015 0.015 ↑ 2.0 1 1

Index Scan using ixlfhchildid on "17f7a637b83349e9b16ef4905eb64944".locationflathierarchy locationflathierarchy25 (cost=0.28..3.31 rows=2 width=32) (actual time=0.014..0.015 rows=1 loops=1)

  • Output: locationflathierarchy25.parentid, locationflathierarchy25.childid, locationflathierarchy25.parentdepth
  • Index Cond: (locationflathierarchy25.childid = userlocation26.locationid)
  • Buffers: shared hit=2 read=1
85. 0.000 0.003 ↓ 0.0 0 1

Nested Loop (cost=0.30..8.55 rows=6 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: divisionflathierarchy27.parentid
  • Buffers: shared hit=1
86. 0.003 0.003 ↓ 0.0 0 1

Index Only Scan using ix4ud_userdivisionstartend on "17f7a637b83349e9b16ef4905eb64944".userdivision userdivision28 (cost=0.15..2.24 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: userdivision28.userid, userdivision28.divisionid, userdivision28.startdate, userdivision28.enddate
  • Index Cond: ((userdivision28.userid = 376) AND (userdivision28.startdate <= '2019-09-30'::date) AND (userdivision28.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
  • Buffers: shared hit=1
87. 0.000 0.000 ↓ 0.0 0

Index Scan using ixdivfhchildid on "17f7a637b83349e9b16ef4905eb64944".divisionflathierarchy divisionflathierarchy27 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: divisionflathierarchy27.parentid, divisionflathierarchy27.childid, divisionflathierarchy27.parentdepth
  • Index Cond: (divisionflathierarchy27.childid = userdivision28.divisionid)
88. 0.000 0.002 ↓ 0.0 0 1

Nested Loop (cost=0.30..8.55 rows=6 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: costcenterflathierarchy29.parentid
  • Buffers: shared hit=1
89. 0.002 0.002 ↓ 0.0 0 1

Index Only Scan using ix4ucc_usercostcenterstartend on "17f7a637b83349e9b16ef4905eb64944".usercostcenter usercostcenter30 (cost=0.15..2.24 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: usercostcenter30.userid, usercostcenter30.costcenterid, usercostcenter30.startdate, usercostcenter30.enddate
  • Index Cond: ((usercostcenter30.userid = 376) AND (usercostcenter30.startdate <= '2019-09-30'::date) AND (usercostcenter30.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
  • Buffers: shared hit=1
90. 0.000 0.000 ↓ 0.0 0

Index Scan using ixccfhchildid on "17f7a637b83349e9b16ef4905eb64944".costcenterflathierarchy costcenterflathierarchy29 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: costcenterflathierarchy29.parentid, costcenterflathierarchy29.childid, costcenterflathierarchy29.parentdepth
  • Index Cond: (costcenterflathierarchy29.childid = usercostcenter30.costcenterid)
91. 0.000 0.002 ↓ 0.0 0 1

Nested Loop (cost=0.30..8.55 rows=6 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: servicecenterflathierarchy31.parentid
  • Buffers: shared hit=1
92. 0.002 0.002 ↓ 0.0 0 1

Index Only Scan using ix4usc_userservicecenterstartend on "17f7a637b83349e9b16ef4905eb64944".userservicecenter userservicecenter32 (cost=0.15..2.24 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: userservicecenter32.userid, userservicecenter32.servicecenterid, userservicecenter32.startdate, userservicecenter32.enddate
  • Index Cond: ((userservicecenter32.userid = 376) AND (userservicecenter32.startdate <= '2019-09-30'::date) AND (userservicecenter32.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
  • Buffers: shared hit=1
93. 0.000 0.000 ↓ 0.0 0

Index Scan using ixscfhchildid on "17f7a637b83349e9b16ef4905eb64944".servicecenterflathierarchy servicecenterflathierarchy31 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: servicecenterflathierarchy31.parentid, servicecenterflathierarchy31.childid, servicecenterflathierarchy31.parentdepth
  • Index Cond: (servicecenterflathierarchy31.childid = userservicecenter32.servicecenterid)
94. 0.006 0.521 ↓ 0.0 0 1

Nested Loop (cost=0.15..3.20 rows=1 width=16) (actual time=0.521..0.521 rows=0 loops=1)

  • Output: departmentgroupflathierarchy33.parentid
  • Buffers: shared hit=1 read=1
95. 0.513 0.513 ↑ 1.0 1 1

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".departmentgroupflathierarchy departmentgroupflathierarchy33 (cost=0.00..1.01 rows=1 width=32) (actual time=0.513..0.513 rows=1 loops=1)

  • Output: departmentgroupflathierarchy33.parentid, departmentgroupflathierarchy33.childid, departmentgroupflathierarchy33.parentdepth
  • Buffers: shared read=1
96. 0.002 0.002 ↓ 0.0 0 1

Index Only Scan using ix4ucc_userdepartmentgroupstartend on "17f7a637b83349e9b16ef4905eb64944".userdepartmentgroup userdepartmentgroup34 (cost=0.15..2.18 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: userdepartmentgroup34.userid, userdepartmentgroup34.departmentgroupid, userdepartmentgroup34.startdate, userdepartmentgroup34.enddate
  • Index Cond: ((userdepartmentgroup34.userid = 376) AND (userdepartmentgroup34.departmentgroupid = departmentgroupflathierarchy33.childid) AND (userdepartmentgroup34.startdate <= '2019-09-30'::date) AND (userdepartmentgroup34.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
  • Buffers: shared hit=1
97. 0.002 0.003 ↓ 0.0 0 1

Nested Loop (cost=0.30..8.55 rows=6 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: ployeetypegroupflathierarchy35.parentid
  • Buffers: shared hit=1
98. 0.001 0.001 ↓ 0.0 0 1

Index Only Scan using ix4ucc_useremployeetypegroupstartend on "17f7a637b83349e9b16ef4905eb64944".useremployeetypegroup useremployeetypegroup36 (cost=0.15..2.24 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: useremployeetypegroup36.userid, useremployeetypegroup36.employeetypegroupid, useremployeetypegroup36.startdate, useremployeetypegroup36.enddate
  • Index Cond: ((useremployeetypegroup36.userid = 376) AND (useremployeetypegroup36.startdate <= '2019-09-30'::date) AND (useremployeetypegroup36.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
  • Buffers: shared hit=1
99. 0.000 0.000 ↓ 0.0 0

Index Scan using ixetgfhchildid on "17f7a637b83349e9b16ef4905eb64944".employeetypegroupflathierarchy ployeetypegroupflathierarchy35 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: ployeetypegroupflathierarchy35.parentid, ployeetypegroupflathierarchy35.childid, ployeetypegroupflathierarchy35.parentdepth
  • Index Cond: (ployeetypegroupflathierarchy35.childid = useremployeetypegroup36.employeetypegroupid)
100. 290.645 2,906.450 ↑ 2.0 3 290,645

Hash (cost=1.53..1.53 rows=6 width=20) (actual time=0.010..0.010 rows=3 loops=290,645)

  • Output: taskteammemberassignment21.projectteammemberid, taskteammemberassignment21.taskid
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=873,694 read=5,119 written=69
101. 2,615.805 2,615.805 ↑ 2.0 3 290,645

Index Only Scan using uix2projectteammembertaskassignment on "17f7a637b83349e9b16ef4905eb64944".taskteammemberassignment taskteammemberassignment21 (cost=0.42..1.53 rows=6 width=20) (actual time=0.006..0.009 rows=3 loops=290,645)

  • Output: taskteammemberassignment21.projectteammemberid, taskteammemberassignment21.taskid
  • Index Cond: (taskteammemberassignment21.taskid = task.id)
  • Heap Fetches: 0
  • Buffers: shared hit=873,694 read=5,119 written=69
102. 1,115.248 1,115.248 ↑ 1.0 1 278,812

Index Scan using task_pkey on "17f7a637b83349e9b16ef4905eb64944".task task22 (cost=0.42..2.45 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=278,812)

  • Output: task22.id, task22.projectid, task22.parentid, task22.name, task22.code, task22.description, task22.isclosed, task22.orderindex, task22.percentcomplete, task22.istimeentryallowed, task22.estimatedhours, task22.timeentrystartdate, task22.timeentryenddate, task22.estimatedexpenses, task22.estimatedexpensescurrencyid, task22.expenseentrystartdate, task22.expenseentryenddate, task22.costtype, task22.estimatedcost, task22.estimatedcostcurrencyid, task22.timeandexpenseentrytype, task22.info1, task22.info2, task22.info3, task22.info4, task22.info5, task22.info6, task22.info7, task22.info8, task22.info9, task22.info10, task22.info11, task22.info12, task22.info13, task22.info14, task22.info15, task22.info16, task22.info17, task22.info18, task22.info19, task22.info20
  • Index Cond: (task22.id = task.id)
  • Filter: (task22.istimeentryallowed AND (NOT task22.isclosed) AND ($49 OR ((task22.timeentrystartdate <= '2019-09-30'::date) AND (task22.timeentryenddate >= '2019-09-22'::date))))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=1,115,064 read=1,005 written=14
103. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=38,029.96..76,406.35 rows=802,279 width=8) (never executed)

  • Output: projectteammember20_1.projectid, task22_1.id
  • Hash Cond: (taskteammemberassignment21_1.projectteammemberid = projectteammember20_1.id)
104.          

Initplan (for Hash Join)

105. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtspss2key on "17f7a637b83349e9b16ef4905eb64944".timesheetpolicysettingssnapshot esheetpolicysettingssnapshot37_1 (cost=0.68..3.72 rows=1 width=0) (never executed)

  • Index Cond: ((upper(esheetpolicysettingssnapshot37_1.key) = 'URN:REPLICON:POLICY:TIMESHEET:TASK-DATERANGE-ENTRY-OVERRIDE'::text) AND (upper(esheetpolicysettingssnapshot37_1.uri) = 'URN:REPLICON:POLICY:TIMESHEET:TASK-DATERANGE-ENTRY-OVERRIDE:OVERRIDE-TASK-DATERANGE-ENTRY'::text))
  • Filter: (esheetpolicysettingssnapshot37_1.timesheetid = '484e44e6-7209-4c91-9351-961796dc98d2'::uuid)
106. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=14,753.35..42,074.72 rows=808,592 width=20) (never executed)

  • Output: taskteammemberassignment21_1.projectteammemberid, task22_1.id
  • Hash Cond: (taskteammemberassignment21_1.taskid = task22_1.id)
107. 0.000 0.000 ↓ 0.0 0

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".taskteammemberassignment taskteammemberassignment21_1 (cost=0.00..15,969.15 rows=871,015 width=20) (never executed)

  • Output: taskteammemberassignment21_1.id, taskteammemberassignment21_1.taskid, taskteammemberassignment21_1.projectteammemberid, taskteammemberassignment21_1.taskallocationstartdate, taskteammemberassignment21_1.taskallocationenddate, taskteammemberassignment21_1.taskallocationduration
108. 0.000 0.000 ↓ 0.0 0

Hash (cost=10,458.15..10,458.15 rows=343,616 width=4) (never executed)

  • Output: task22_1.id
109. 0.000 0.000 ↓ 0.0 0

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".task task22_1 (cost=0.00..10,458.15 rows=343,616 width=4) (never executed)

  • Output: task22_1.id
  • Filter: (task22_1.istimeentryallowed AND (NOT task22_1.isclosed) AND ($68 OR ((task22_1.timeentrystartdate <= '2019-09-30'::date) AND (task22_1.timeentryenddate >= '2019-09-22'::date))))
110. 0.000 0.000 ↓ 0.0 0

Hash (cost=17,484.08..17,484.08 rows=463,105 width=20) (never executed)

  • Output: projectteammember20_1.projectid, projectteammember20_1.id
111. 0.000 0.000 ↓ 0.0 0

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".projectteammember projectteammember20_1 (cost=47.61..17,484.08 rows=463,105 width=20) (never executed)

  • Output: projectteammember20_1.projectid, projectteammember20_1.id
  • Filter: ((projectteammember20_1.userid = 376) OR (hashed SubPlan 30) OR (hashed SubPlan 31) OR (hashed SubPlan 32) OR (hashed SubPlan 33) OR (hashed SubPlan 34) OR (hashed SubPlan 35) OR (hashed SubPlan 36))
112.          

SubPlan (for Seq Scan)

113. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..4.50 rows=2 width=4) (never executed)

  • Output: departmentflathierarchy23_1.parentid
114. 0.000 0.000 ↓ 0.0 0

Index Scan using ixduuserid on "17f7a637b83349e9b16ef4905eb64944".departmentusers departmentusers24_1 (cost=0.28..2.30 rows=1 width=4) (never executed)

  • Output: departmentusers24_1.departmentid, departmentusers24_1.userid, departmentusers24_1.isprimarydepartment
  • Index Cond: (departmentusers24_1.userid = 376)
115. 0.000 0.000 ↓ 0.0 0

Index Scan using ixdfhchildid on "17f7a637b83349e9b16ef4905eb64944".departmentflathierarchy departmentflathierarchy23_1 (cost=0.14..2.18 rows=2 width=8) (never executed)

  • Output: departmentflathierarchy23_1.parentid, departmentflathierarchy23_1.childid, departmentflathierarchy23_1.depth
  • Index Cond: (departmentflathierarchy23_1.childid = departmentusers24_1.departmentid)
116. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..5.63 rows=1 width=16) (never executed)

  • Output: locationflathierarchy25_1.parentid
117. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix4ul_userlocationstartend on "17f7a637b83349e9b16ef4905eb64944".userlocation userlocation26_1 (cost=0.28..2.30 rows=1 width=16) (never executed)

  • Output: userlocation26_1.userid, userlocation26_1.locationid, userlocation26_1.startdate, userlocation26_1.enddate
  • Index Cond: ((userlocation26_1.userid = 376) AND (userlocation26_1.startdate <= '2019-09-30'::date) AND (userlocation26_1.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
118. 0.000 0.000 ↓ 0.0 0

Index Scan using ixlfhchildid on "17f7a637b83349e9b16ef4905eb64944".locationflathierarchy locationflathierarchy25_1 (cost=0.28..3.31 rows=2 width=32) (never executed)

  • Output: locationflathierarchy25_1.parentid, locationflathierarchy25_1.childid, locationflathierarchy25_1.parentdepth
  • Index Cond: (locationflathierarchy25_1.childid = userlocation26_1.locationid)
119. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.30..8.55 rows=6 width=16) (never executed)

  • Output: divisionflathierarchy27_1.parentid
120. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix4ud_userdivisionstartend on "17f7a637b83349e9b16ef4905eb64944".userdivision userdivision28_1 (cost=0.15..2.24 rows=1 width=16) (never executed)

  • Output: userdivision28_1.userid, userdivision28_1.divisionid, userdivision28_1.startdate, userdivision28_1.enddate
  • Index Cond: ((userdivision28_1.userid = 376) AND (userdivision28_1.startdate <= '2019-09-30'::date) AND (userdivision28_1.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
121. 0.000 0.000 ↓ 0.0 0

Index Scan using ixdivfhchildid on "17f7a637b83349e9b16ef4905eb64944".divisionflathierarchy divisionflathierarchy27_1 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: divisionflathierarchy27_1.parentid, divisionflathierarchy27_1.childid, divisionflathierarchy27_1.parentdepth
  • Index Cond: (divisionflathierarchy27_1.childid = userdivision28_1.divisionid)
122. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.30..8.55 rows=6 width=16) (never executed)

  • Output: costcenterflathierarchy29_1.parentid
123. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix4ucc_usercostcenterstartend on "17f7a637b83349e9b16ef4905eb64944".usercostcenter usercostcenter30_1 (cost=0.15..2.24 rows=1 width=16) (never executed)

  • Output: usercostcenter30_1.userid, usercostcenter30_1.costcenterid, usercostcenter30_1.startdate, usercostcenter30_1.enddate
  • Index Cond: ((usercostcenter30_1.userid = 376) AND (usercostcenter30_1.startdate <= '2019-09-30'::date) AND (usercostcenter30_1.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
124. 0.000 0.000 ↓ 0.0 0

Index Scan using ixccfhchildid on "17f7a637b83349e9b16ef4905eb64944".costcenterflathierarchy costcenterflathierarchy29_1 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: costcenterflathierarchy29_1.parentid, costcenterflathierarchy29_1.childid, costcenterflathierarchy29_1.parentdepth
  • Index Cond: (costcenterflathierarchy29_1.childid = usercostcenter30_1.costcenterid)
125. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.30..8.55 rows=6 width=16) (never executed)

  • Output: servicecenterflathierarchy31_1.parentid
126. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix4usc_userservicecenterstartend on "17f7a637b83349e9b16ef4905eb64944".userservicecenter userservicecenter32_1 (cost=0.15..2.24 rows=1 width=16) (never executed)

  • Output: userservicecenter32_1.userid, userservicecenter32_1.servicecenterid, userservicecenter32_1.startdate, userservicecenter32_1.enddate
  • Index Cond: ((userservicecenter32_1.userid = 376) AND (userservicecenter32_1.startdate <= '2019-09-30'::date) AND (userservicecenter32_1.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
127. 0.000 0.000 ↓ 0.0 0

Index Scan using ixscfhchildid on "17f7a637b83349e9b16ef4905eb64944".servicecenterflathierarchy servicecenterflathierarchy31_1 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: servicecenterflathierarchy31_1.parentid, servicecenterflathierarchy31_1.childid, servicecenterflathierarchy31_1.parentdepth
  • Index Cond: (servicecenterflathierarchy31_1.childid = userservicecenter32_1.servicecenterid)
128. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.15..3.20 rows=1 width=16) (never executed)

  • Output: departmentgroupflathierarchy33_1.parentid
129. 0.000 0.000 ↓ 0.0 0

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".departmentgroupflathierarchy departmentgroupflathierarchy33_1 (cost=0.00..1.01 rows=1 width=32) (never executed)

  • Output: departmentgroupflathierarchy33_1.parentid, departmentgroupflathierarchy33_1.childid, departmentgroupflathierarchy33_1.parentdepth
130. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix4ucc_userdepartmentgroupstartend on "17f7a637b83349e9b16ef4905eb64944".userdepartmentgroup userdepartmentgroup34_1 (cost=0.15..2.18 rows=1 width=16) (never executed)

  • Output: userdepartmentgroup34_1.userid, userdepartmentgroup34_1.departmentgroupid, userdepartmentgroup34_1.startdate, userdepartmentgroup34_1.enddate
  • Index Cond: ((userdepartmentgroup34_1.userid = 376) AND (userdepartmentgroup34_1.departmentgroupid = departmentgroupflathierarchy33_1.childid) AND (userdepartmentgroup34_1.startdate <= '2019-09-30'::date) AND (userdepartmentgroup34_1.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
131. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.30..8.55 rows=6 width=16) (never executed)

  • Output: ployeetypegroupflathierarchy35_1.parentid
132. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix4ucc_useremployeetypegroupstartend on "17f7a637b83349e9b16ef4905eb64944".useremployeetypegroup useremployeetypegroup36_1 (cost=0.15..2.24 rows=1 width=16) (never executed)

  • Output: useremployeetypegroup36_1.userid, useremployeetypegroup36_1.employeetypegroupid, useremployeetypegroup36_1.startdate, useremployeetypegroup36_1.enddate
  • Index Cond: ((useremployeetypegroup36_1.userid = 376) AND (useremployeetypegroup36_1.startdate <= '2019-09-30'::date) AND (useremployeetypegroup36_1.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
133. 0.000 0.000 ↓ 0.0 0

Index Scan using ixetgfhchildid on "17f7a637b83349e9b16ef4905eb64944".employeetypegroupflathierarchy ployeetypegroupflathierarchy35_1 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: ployeetypegroupflathierarchy35_1.parentid, ployeetypegroupflathierarchy35_1.childid, ployeetypegroupflathierarchy35_1.parentdepth
  • Index Cond: (ployeetypegroupflathierarchy35_1.childid = useremployeetypegroup36_1.employeetypegroupid)
134. 0.000 18.746 ↓ 0.0 0 1,442

Index Only Scan using project_pkey on "17f7a637b83349e9b16ef4905eb64944".project (cost=0.28..261.93 rows=1 width=72) (actual time=0.013..0.013 rows=0 loops=1,442)

  • Output: NULL::integer, NULL::character varying, NULL::character varying, project.id
  • Index Cond: (project.id = p.id)
  • Filter: (((NULL::integer IS NULL) AND (SubPlan 4) AND (alternatives: SubPlan 12 or hashed SubPlan 20)) OR ((NULL::integer IS NOT NULL) AND (alternatives: SubPlan 29 or hashed SubPlan 38)))
  • Rows Removed by Filter: 1
  • Heap Fetches: 0
  • Buffers: shared hit=13,190
135.          

SubPlan (for Index Only Scan)

136. 4.326 4.326 ↑ 1.0 1 1,442

Index Scan using project_pkey on "17f7a637b83349e9b16ef4905eb64944".project project4 (cost=0.28..2.29 rows=1 width=1) (actual time=0.003..0.003 rows=1 loops=1,442)

  • Output: project4.istimeentryallowed
  • Index Cond: (project4.id = p.id)
  • Buffers: shared hit=4,335
137. 5.098 5.178 ↓ 0.0 0 863

Index Scan using uix2ptm_projectemptypegrp on "17f7a637b83349e9b16ef4905eb64944".projectteammember projectteammember5 (cost=48.04..199.82 rows=321 width=0) (actual time=0.006..0.006 rows=0 loops=863)

  • Index Cond: (projectteammember5.projectid = p.id)
  • Filter: ((projectteammember5.userid = 376) OR (hashed SubPlan 5) OR (hashed SubPlan 6) OR (hashed SubPlan 7) OR (hashed SubPlan 8) OR (hashed SubPlan 9) OR (hashed SubPlan 10) OR (hashed SubPlan 11))
  • Rows Removed by Filter: 6
  • Buffers: shared hit=5,961
138.          

SubPlan (for Index Scan)

139. 0.008 0.023 ↑ 1.0 2 1

Nested Loop (cost=0.42..4.50 rows=2 width=4) (actual time=0.019..0.023 rows=2 loops=1)

  • Output: departmentflathierarchy6.parentid
  • Buffers: shared hit=5
140. 0.008 0.008 ↑ 1.0 1 1

Index Scan using ixduuserid on "17f7a637b83349e9b16ef4905eb64944".departmentusers departmentusers7 (cost=0.28..2.30 rows=1 width=4) (actual time=0.008..0.008 rows=1 loops=1)

  • Output: departmentusers7.departmentid, departmentusers7.userid, departmentusers7.isprimarydepartment
  • Index Cond: (departmentusers7.userid = 376)
  • Buffers: shared hit=3
141. 0.007 0.007 ↑ 1.0 2 1

Index Scan using ixdfhchildid on "17f7a637b83349e9b16ef4905eb64944".departmentflathierarchy departmentflathierarchy6 (cost=0.14..2.18 rows=2 width=8) (actual time=0.006..0.007 rows=2 loops=1)

  • Output: departmentflathierarchy6.parentid, departmentflathierarchy6.childid, departmentflathierarchy6.depth
  • Index Cond: (departmentflathierarchy6.childid = departmentusers7.departmentid)
  • Buffers: shared hit=2
142. 0.004 0.024 ↑ 1.0 1 1

Nested Loop (cost=0.56..5.63 rows=1 width=16) (actual time=0.022..0.024 rows=1 loops=1)

  • Output: locationflathierarchy8.parentid
  • Buffers: shared hit=6
143. 0.010 0.010 ↑ 1.0 1 1

Index Only Scan using ix4ul_userlocationstartend on "17f7a637b83349e9b16ef4905eb64944".userlocation userlocation9 (cost=0.28..2.30 rows=1 width=16) (actual time=0.009..0.010 rows=1 loops=1)

  • Output: userlocation9.userid, userlocation9.locationid, userlocation9.startdate, userlocation9.enddate
  • Index Cond: ((userlocation9.userid = 376) AND (userlocation9.startdate <= '2019-09-30'::date) AND (userlocation9.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
  • Buffers: shared hit=3
144. 0.010 0.010 ↑ 2.0 1 1

Index Scan using ixlfhchildid on "17f7a637b83349e9b16ef4905eb64944".locationflathierarchy locationflathierarchy8 (cost=0.28..3.31 rows=2 width=32) (actual time=0.009..0.010 rows=1 loops=1)

  • Output: locationflathierarchy8.parentid, locationflathierarchy8.childid, locationflathierarchy8.parentdepth
  • Index Cond: (locationflathierarchy8.childid = userlocation9.locationid)
  • Buffers: shared hit=3
145. 0.000 0.004 ↓ 0.0 0 1

Nested Loop (cost=0.30..8.55 rows=6 width=16) (actual time=0.004..0.004 rows=0 loops=1)

  • Output: divisionflathierarchy10.parentid
  • Buffers: shared hit=1
146. 0.004 0.004 ↓ 0.0 0 1

Index Only Scan using ix4ud_userdivisionstartend on "17f7a637b83349e9b16ef4905eb64944".userdivision userdivision11 (cost=0.15..2.24 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=1)

  • Output: userdivision11.userid, userdivision11.divisionid, userdivision11.startdate, userdivision11.enddate
  • Index Cond: ((userdivision11.userid = 376) AND (userdivision11.startdate <= '2019-09-30'::date) AND (userdivision11.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
  • Buffers: shared hit=1
147. 0.000 0.000 ↓ 0.0 0

Index Scan using ixdivfhchildid on "17f7a637b83349e9b16ef4905eb64944".divisionflathierarchy divisionflathierarchy10 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: divisionflathierarchy10.parentid, divisionflathierarchy10.childid, divisionflathierarchy10.parentdepth
  • Index Cond: (divisionflathierarchy10.childid = userdivision11.divisionid)
148. 0.001 0.004 ↓ 0.0 0 1

Nested Loop (cost=0.30..8.55 rows=6 width=16) (actual time=0.004..0.004 rows=0 loops=1)

  • Output: costcenterflathierarchy12.parentid
  • Buffers: shared hit=1
149. 0.003 0.003 ↓ 0.0 0 1

Index Only Scan using ix4ucc_usercostcenterstartend on "17f7a637b83349e9b16ef4905eb64944".usercostcenter usercostcenter13 (cost=0.15..2.24 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: usercostcenter13.userid, usercostcenter13.costcenterid, usercostcenter13.startdate, usercostcenter13.enddate
  • Index Cond: ((usercostcenter13.userid = 376) AND (usercostcenter13.startdate <= '2019-09-30'::date) AND (usercostcenter13.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
  • Buffers: shared hit=1
150. 0.000 0.000 ↓ 0.0 0

Index Scan using ixccfhchildid on "17f7a637b83349e9b16ef4905eb64944".costcenterflathierarchy costcenterflathierarchy12 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: costcenterflathierarchy12.parentid, costcenterflathierarchy12.childid, costcenterflathierarchy12.parentdepth
  • Index Cond: (costcenterflathierarchy12.childid = usercostcenter13.costcenterid)
151. 0.001 0.004 ↓ 0.0 0 1

Nested Loop (cost=0.30..8.55 rows=6 width=16) (actual time=0.004..0.004 rows=0 loops=1)

  • Output: servicecenterflathierarchy14.parentid
  • Buffers: shared hit=1
152. 0.003 0.003 ↓ 0.0 0 1

Index Only Scan using ix4usc_userservicecenterstartend on "17f7a637b83349e9b16ef4905eb64944".userservicecenter userservicecenter15 (cost=0.15..2.24 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: userservicecenter15.userid, userservicecenter15.servicecenterid, userservicecenter15.startdate, userservicecenter15.enddate
  • Index Cond: ((userservicecenter15.userid = 376) AND (userservicecenter15.startdate <= '2019-09-30'::date) AND (userservicecenter15.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
  • Buffers: shared hit=1
153. 0.000 0.000 ↓ 0.0 0

Index Scan using ixscfhchildid on "17f7a637b83349e9b16ef4905eb64944".servicecenterflathierarchy servicecenterflathierarchy14 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: servicecenterflathierarchy14.parentid, servicecenterflathierarchy14.childid, servicecenterflathierarchy14.parentdepth
  • Index Cond: (servicecenterflathierarchy14.childid = userservicecenter15.servicecenterid)
154. 0.012 0.018 ↓ 0.0 0 1

Nested Loop (cost=0.15..3.20 rows=1 width=16) (actual time=0.018..0.018 rows=0 loops=1)

  • Output: departmentgroupflathierarchy16.parentid
  • Buffers: shared hit=2
155. 0.003 0.003 ↑ 1.0 1 1

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".departmentgroupflathierarchy departmentgroupflathierarchy16 (cost=0.00..1.01 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=1)

  • Output: departmentgroupflathierarchy16.parentid, departmentgroupflathierarchy16.childid, departmentgroupflathierarchy16.parentdepth
  • Buffers: shared hit=1
156. 0.003 0.003 ↓ 0.0 0 1

Index Only Scan using ix4ucc_userdepartmentgroupstartend on "17f7a637b83349e9b16ef4905eb64944".userdepartmentgroup userdepartmentgroup17 (cost=0.15..2.18 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: userdepartmentgroup17.userid, userdepartmentgroup17.departmentgroupid, userdepartmentgroup17.startdate, userdepartmentgroup17.enddate
  • Index Cond: ((userdepartmentgroup17.userid = 376) AND (userdepartmentgroup17.departmentgroupid = departmentgroupflathierarchy16.childid) AND (userdepartmentgroup17.startdate <= '2019-09-30'::date) AND (userdepartmentgroup17.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
  • Buffers: shared hit=1
157. 0.000 0.003 ↓ 0.0 0 1

Nested Loop (cost=0.30..8.55 rows=6 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: ployeetypegroupflathierarchy18.parentid
  • Buffers: shared hit=1
158. 0.003 0.003 ↓ 0.0 0 1

Index Only Scan using ix4ucc_useremployeetypegroupstartend on "17f7a637b83349e9b16ef4905eb64944".useremployeetypegroup useremployeetypegroup19 (cost=0.15..2.24 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: useremployeetypegroup19.userid, useremployeetypegroup19.employeetypegroupid, useremployeetypegroup19.startdate, useremployeetypegroup19.enddate
  • Index Cond: ((useremployeetypegroup19.userid = 376) AND (useremployeetypegroup19.startdate <= '2019-09-30'::date) AND (useremployeetypegroup19.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
  • Buffers: shared hit=1
159. 0.000 0.000 ↓ 0.0 0

Index Scan using ixetgfhchildid on "17f7a637b83349e9b16ef4905eb64944".employeetypegroupflathierarchy ployeetypegroupflathierarchy18 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: ployeetypegroupflathierarchy18.parentid, ployeetypegroupflathierarchy18.childid, ployeetypegroupflathierarchy18.parentdepth
  • Index Cond: (ployeetypegroupflathierarchy18.childid = useremployeetypegroup19.employeetypegroupid)
160. 0.000 0.000 ↓ 0.0 0

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".projectteammember projectteammember5_1 (cost=47.61..17,484.08 rows=463,105 width=4) (never executed)

  • Output: projectteammember5_1.projectid
  • Filter: ((projectteammember5_1.userid = 376) OR (hashed SubPlan 13) OR (hashed SubPlan 14) OR (hashed SubPlan 15) OR (hashed SubPlan 16) OR (hashed SubPlan 17) OR (hashed SubPlan 18) OR (hashed SubPlan 19))
161.          

SubPlan (for Seq Scan)

162. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..4.50 rows=2 width=4) (never executed)

  • Output: departmentflathierarchy6_1.parentid
163. 0.000 0.000 ↓ 0.0 0

Index Scan using ixduuserid on "17f7a637b83349e9b16ef4905eb64944".departmentusers departmentusers7_1 (cost=0.28..2.30 rows=1 width=4) (never executed)

  • Output: departmentusers7_1.departmentid, departmentusers7_1.userid, departmentusers7_1.isprimarydepartment
  • Index Cond: (departmentusers7_1.userid = 376)
164. 0.000 0.000 ↓ 0.0 0

Index Scan using ixdfhchildid on "17f7a637b83349e9b16ef4905eb64944".departmentflathierarchy departmentflathierarchy6_1 (cost=0.14..2.18 rows=2 width=8) (never executed)

  • Output: departmentflathierarchy6_1.parentid, departmentflathierarchy6_1.childid, departmentflathierarchy6_1.depth
  • Index Cond: (departmentflathierarchy6_1.childid = departmentusers7_1.departmentid)
165. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..5.63 rows=1 width=16) (never executed)

  • Output: locationflathierarchy8_1.parentid
166. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix4ul_userlocationstartend on "17f7a637b83349e9b16ef4905eb64944".userlocation userlocation9_1 (cost=0.28..2.30 rows=1 width=16) (never executed)

  • Output: userlocation9_1.userid, userlocation9_1.locationid, userlocation9_1.startdate, userlocation9_1.enddate
  • Index Cond: ((userlocation9_1.userid = 376) AND (userlocation9_1.startdate <= '2019-09-30'::date) AND (userlocation9_1.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
167. 0.000 0.000 ↓ 0.0 0

Index Scan using ixlfhchildid on "17f7a637b83349e9b16ef4905eb64944".locationflathierarchy locationflathierarchy8_1 (cost=0.28..3.31 rows=2 width=32) (never executed)

  • Output: locationflathierarchy8_1.parentid, locationflathierarchy8_1.childid, locationflathierarchy8_1.parentdepth
  • Index Cond: (locationflathierarchy8_1.childid = userlocation9_1.locationid)
168. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.30..8.55 rows=6 width=16) (never executed)

  • Output: divisionflathierarchy10_1.parentid
169. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix4ud_userdivisionstartend on "17f7a637b83349e9b16ef4905eb64944".userdivision userdivision11_1 (cost=0.15..2.24 rows=1 width=16) (never executed)

  • Output: userdivision11_1.userid, userdivision11_1.divisionid, userdivision11_1.startdate, userdivision11_1.enddate
  • Index Cond: ((userdivision11_1.userid = 376) AND (userdivision11_1.startdate <= '2019-09-30'::date) AND (userdivision11_1.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
170. 0.000 0.000 ↓ 0.0 0

Index Scan using ixdivfhchildid on "17f7a637b83349e9b16ef4905eb64944".divisionflathierarchy divisionflathierarchy10_1 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: divisionflathierarchy10_1.parentid, divisionflathierarchy10_1.childid, divisionflathierarchy10_1.parentdepth
  • Index Cond: (divisionflathierarchy10_1.childid = userdivision11_1.divisionid)
171. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.30..8.55 rows=6 width=16) (never executed)

  • Output: costcenterflathierarchy12_1.parentid
172. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix4ucc_usercostcenterstartend on "17f7a637b83349e9b16ef4905eb64944".usercostcenter usercostcenter13_1 (cost=0.15..2.24 rows=1 width=16) (never executed)

  • Output: usercostcenter13_1.userid, usercostcenter13_1.costcenterid, usercostcenter13_1.startdate, usercostcenter13_1.enddate
  • Index Cond: ((usercostcenter13_1.userid = 376) AND (usercostcenter13_1.startdate <= '2019-09-30'::date) AND (usercostcenter13_1.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
173. 0.000 0.000 ↓ 0.0 0

Index Scan using ixccfhchildid on "17f7a637b83349e9b16ef4905eb64944".costcenterflathierarchy costcenterflathierarchy12_1 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: costcenterflathierarchy12_1.parentid, costcenterflathierarchy12_1.childid, costcenterflathierarchy12_1.parentdepth
  • Index Cond: (costcenterflathierarchy12_1.childid = usercostcenter13_1.costcenterid)
174. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.30..8.55 rows=6 width=16) (never executed)

  • Output: servicecenterflathierarchy14_1.parentid
175. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix4usc_userservicecenterstartend on "17f7a637b83349e9b16ef4905eb64944".userservicecenter userservicecenter15_1 (cost=0.15..2.24 rows=1 width=16) (never executed)

  • Output: userservicecenter15_1.userid, userservicecenter15_1.servicecenterid, userservicecenter15_1.startdate, userservicecenter15_1.enddate
  • Index Cond: ((userservicecenter15_1.userid = 376) AND (userservicecenter15_1.startdate <= '2019-09-30'::date) AND (userservicecenter15_1.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
176. 0.000 0.000 ↓ 0.0 0

Index Scan using ixscfhchildid on "17f7a637b83349e9b16ef4905eb64944".servicecenterflathierarchy servicecenterflathierarchy14_1 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: servicecenterflathierarchy14_1.parentid, servicecenterflathierarchy14_1.childid, servicecenterflathierarchy14_1.parentdepth
  • Index Cond: (servicecenterflathierarchy14_1.childid = userservicecenter15_1.servicecenterid)
177. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.15..3.20 rows=1 width=16) (never executed)

  • Output: departmentgroupflathierarchy16_1.parentid
178. 0.000 0.000 ↓ 0.0 0

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".departmentgroupflathierarchy departmentgroupflathierarchy16_1 (cost=0.00..1.01 rows=1 width=32) (never executed)

  • Output: departmentgroupflathierarchy16_1.parentid, departmentgroupflathierarchy16_1.childid, departmentgroupflathierarchy16_1.parentdepth
179. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix4ucc_userdepartmentgroupstartend on "17f7a637b83349e9b16ef4905eb64944".userdepartmentgroup userdepartmentgroup17_1 (cost=0.15..2.18 rows=1 width=16) (never executed)

  • Output: userdepartmentgroup17_1.userid, userdepartmentgroup17_1.departmentgroupid, userdepartmentgroup17_1.startdate, userdepartmentgroup17_1.enddate
  • Index Cond: ((userdepartmentgroup17_1.userid = 376) AND (userdepartmentgroup17_1.departmentgroupid = departmentgroupflathierarchy16_1.childid) AND (userdepartmentgroup17_1.startdate <= '2019-09-30'::date) AND (userdepartmentgroup17_1.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
180. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.30..8.55 rows=6 width=16) (never executed)

  • Output: ployeetypegroupflathierarchy18_1.parentid
181. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix4ucc_useremployeetypegroupstartend on "17f7a637b83349e9b16ef4905eb64944".useremployeetypegroup useremployeetypegroup19_1 (cost=0.15..2.24 rows=1 width=16) (never executed)

  • Output: useremployeetypegroup19_1.userid, useremployeetypegroup19_1.employeetypegroupid, useremployeetypegroup19_1.startdate, useremployeetypegroup19_1.enddate
  • Index Cond: ((useremployeetypegroup19_1.userid = 376) AND (useremployeetypegroup19_1.startdate <= '2019-09-30'::date) AND (useremployeetypegroup19_1.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
182. 0.000 0.000 ↓ 0.0 0

Index Scan using ixetgfhchildid on "17f7a637b83349e9b16ef4905eb64944".employeetypegroupflathierarchy ployeetypegroupflathierarchy18_1 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: ployeetypegroupflathierarchy18_1.parentid, ployeetypegroupflathierarchy18_1.childid, ployeetypegroupflathierarchy18_1.parentdepth
  • Index Cond: (ployeetypegroupflathierarchy18_1.childid = useremployeetypegroup19_1.employeetypegroupid)
183. 335.055 37,493.205 ↑ 1.0 1 290,645

Nested Loop (cost=53.78..210.83 rows=1 width=0) (actual time=0.129..0.129 rows=1 loops=290,645)

  • Buffers: shared hit=4,360,475 read=10,143 written=148
184.          

Initplan (for Nested Loop)

185. 2.922 2.922 ↓ 0.0 0 1

Index Scan using ixtspss2key on "17f7a637b83349e9b16ef4905eb64944".timesheetpolicysettingssnapshot esheetpolicysettingssnapshot37 (cost=0.68..3.72 rows=1 width=0) (actual time=2.922..2.922 rows=0 loops=1)

  • Index Cond: ((upper(esheetpolicysettingssnapshot37.key) = 'URN:REPLICON:POLICY:TIMESHEET:TASK-DATERANGE-ENTRY-OVERRIDE'::text) AND (upper(esheetpolicysettingssnapshot37.uri) = 'URN:REPLICON:POLICY:TIMESHEET:TASK-DATERANGE-ENTRY-OVERRIDE:OVERRIDE-TASK-DATERANGE-ENTRY'::text))
  • Filter: (esheetpolicysettingssnapshot37.timesheetid = '484e44e6-7209-4c91-9351-961796dc98d2'::uuid)
  • Buffers: shared read=5
186. 1,007.969 36,039.980 ↑ 1.0 1 290,645

Hash Join (cost=49.64..204.65 rows=1 width=4) (actual time=0.117..0.124 rows=1 loops=290,645)

  • Output: taskteammemberassignment21.taskid
  • Hash Cond: (projectteammember20.id = taskteammemberassignment21.projectteammemberid)
  • Buffers: shared hit=3,245,411 read=9,138 written=134
187. 32,123.881 32,125.561 ↑ 321.0 1 284,297

Index Scan using uix2ptm_projectemptypegrp on "17f7a637b83349e9b16ef4905eb64944".projectteammember projectteammember20 (cost=48.04..199.82 rows=321 width=16) (actual time=0.082..0.113 rows=1 loops=284,297)

  • Output: projectteammember20.id, projectteammember20.projectid, projectteammember20.userid, projectteammember20.departmentid, projectteammember20.placeholderprojectroleid, projectteammember20.index, projectteammember20.placeholderdisplayname, projectteammember20.locationid, projectteammember20.divisionid, projectteammember20.costcenterid, projectteammember20.servicecenterid, projectteammember20.departmentgroupid, projectteammember20.employeetypegroupid
  • Index Cond: (projectteammember20.projectid = p.id)
  • Filter: ((projectteammember20.userid = 376) OR (hashed SubPlan 21) OR (hashed SubPlan 22) OR (hashed SubPlan 23) OR (hashed SubPlan 24) OR (hashed SubPlan 25) OR (hashed SubPlan 26) OR (hashed SubPlan 27))
  • Rows Removed by Filter: 322
  • Buffers: shared hit=2,371,717 read=4,019 written=65
188.          

SubPlan (for Index Scan)

189. 0.005 0.049 ↑ 1.0 2 1

Nested Loop (cost=0.42..4.50 rows=2 width=4) (actual time=0.047..0.049 rows=2 loops=1)

  • Output: departmentflathierarchy23.parentid
  • Buffers: shared hit=1 read=4
190. 0.022 0.022 ↑ 1.0 1 1

Index Scan using ixduuserid on "17f7a637b83349e9b16ef4905eb64944".departmentusers departmentusers24 (cost=0.28..2.30 rows=1 width=4) (actual time=0.022..0.022 rows=1 loops=1)

  • Output: departmentusers24.departmentid, departmentusers24.userid, departmentusers24.isprimarydepartment
  • Index Cond: (departmentusers24.userid = 376)
  • Buffers: shared hit=1 read=2
191. 0.022 0.022 ↑ 1.0 2 1

Index Scan using ixdfhchildid on "17f7a637b83349e9b16ef4905eb64944".departmentflathierarchy departmentflathierarchy23 (cost=0.14..2.18 rows=2 width=8) (actual time=0.022..0.022 rows=2 loops=1)

  • Output: departmentflathierarchy23.parentid, departmentflathierarchy23.childid, departmentflathierarchy23.depth
  • Index Cond: (departmentflathierarchy23.childid = departmentusers24.departmentid)
  • Buffers: shared read=2
192. 0.005 1.100 ↑ 1.0 1 1

Nested Loop (cost=0.56..5.63 rows=1 width=16) (actual time=1.098..1.100 rows=1 loops=1)

  • Output: locationflathierarchy25.parentid
  • Buffers: shared hit=3 read=3
193. 1.080 1.080 ↑ 1.0 1 1

Index Only Scan using ix4ul_userlocationstartend on "17f7a637b83349e9b16ef4905eb64944".userlocation userlocation26 (cost=0.28..2.30 rows=1 width=16) (actual time=1.080..1.080 rows=1 loops=1)

  • Output: userlocation26.userid, userlocation26.locationid, userlocation26.startdate, userlocation26.enddate
  • Index Cond: ((userlocation26.userid = 376) AND (userlocation26.startdate <= '2019-09-30'::date) AND (userlocation26.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
  • Buffers: shared hit=1 read=2
194. 0.015 0.015 ↑ 2.0 1 1

Index Scan using ixlfhchildid on "17f7a637b83349e9b16ef4905eb64944".locationflathierarchy locationflathierarchy25 (cost=0.28..3.31 rows=2 width=32) (actual time=0.014..0.015 rows=1 loops=1)

  • Output: locationflathierarchy25.parentid, locationflathierarchy25.childid, locationflathierarchy25.parentdepth
  • Index Cond: (locationflathierarchy25.childid = userlocation26.locationid)
  • Buffers: shared hit=2 read=1
195. 0.000 0.003 ↓ 0.0 0 1

Nested Loop (cost=0.30..8.55 rows=6 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: divisionflathierarchy27.parentid
  • Buffers: shared hit=1
196. 0.003 0.003 ↓ 0.0 0 1

Index Only Scan using ix4ud_userdivisionstartend on "17f7a637b83349e9b16ef4905eb64944".userdivision userdivision28 (cost=0.15..2.24 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: userdivision28.userid, userdivision28.divisionid, userdivision28.startdate, userdivision28.enddate
  • Index Cond: ((userdivision28.userid = 376) AND (userdivision28.startdate <= '2019-09-30'::date) AND (userdivision28.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
  • Buffers: shared hit=1
197. 0.000 0.000 ↓ 0.0 0

Index Scan using ixdivfhchildid on "17f7a637b83349e9b16ef4905eb64944".divisionflathierarchy divisionflathierarchy27 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: divisionflathierarchy27.parentid, divisionflathierarchy27.childid, divisionflathierarchy27.parentdepth
  • Index Cond: (divisionflathierarchy27.childid = userdivision28.divisionid)
198. 0.000 0.002 ↓ 0.0 0 1

Nested Loop (cost=0.30..8.55 rows=6 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: costcenterflathierarchy29.parentid
  • Buffers: shared hit=1
199. 0.002 0.002 ↓ 0.0 0 1

Index Only Scan using ix4ucc_usercostcenterstartend on "17f7a637b83349e9b16ef4905eb64944".usercostcenter usercostcenter30 (cost=0.15..2.24 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: usercostcenter30.userid, usercostcenter30.costcenterid, usercostcenter30.startdate, usercostcenter30.enddate
  • Index Cond: ((usercostcenter30.userid = 376) AND (usercostcenter30.startdate <= '2019-09-30'::date) AND (usercostcenter30.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
  • Buffers: shared hit=1
200. 0.000 0.000 ↓ 0.0 0

Index Scan using ixccfhchildid on "17f7a637b83349e9b16ef4905eb64944".costcenterflathierarchy costcenterflathierarchy29 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: costcenterflathierarchy29.parentid, costcenterflathierarchy29.childid, costcenterflathierarchy29.parentdepth
  • Index Cond: (costcenterflathierarchy29.childid = usercostcenter30.costcenterid)
201. 0.000 0.002 ↓ 0.0 0 1

Nested Loop (cost=0.30..8.55 rows=6 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: servicecenterflathierarchy31.parentid
  • Buffers: shared hit=1
202. 0.002 0.002 ↓ 0.0 0 1

Index Only Scan using ix4usc_userservicecenterstartend on "17f7a637b83349e9b16ef4905eb64944".userservicecenter userservicecenter32 (cost=0.15..2.24 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: userservicecenter32.userid, userservicecenter32.servicecenterid, userservicecenter32.startdate, userservicecenter32.enddate
  • Index Cond: ((userservicecenter32.userid = 376) AND (userservicecenter32.startdate <= '2019-09-30'::date) AND (userservicecenter32.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
  • Buffers: shared hit=1
203. 0.000 0.000 ↓ 0.0 0

Index Scan using ixscfhchildid on "17f7a637b83349e9b16ef4905eb64944".servicecenterflathierarchy servicecenterflathierarchy31 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: servicecenterflathierarchy31.parentid, servicecenterflathierarchy31.childid, servicecenterflathierarchy31.parentdepth
  • Index Cond: (servicecenterflathierarchy31.childid = userservicecenter32.servicecenterid)
204. 0.006 0.521 ↓ 0.0 0 1

Nested Loop (cost=0.15..3.20 rows=1 width=16) (actual time=0.521..0.521 rows=0 loops=1)

  • Output: departmentgroupflathierarchy33.parentid
  • Buffers: shared hit=1 read=1
205. 0.513 0.513 ↑ 1.0 1 1

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".departmentgroupflathierarchy departmentgroupflathierarchy33 (cost=0.00..1.01 rows=1 width=32) (actual time=0.513..0.513 rows=1 loops=1)

  • Output: departmentgroupflathierarchy33.parentid, departmentgroupflathierarchy33.childid, departmentgroupflathierarchy33.parentdepth
  • Buffers: shared read=1
206. 0.002 0.002 ↓ 0.0 0 1

Index Only Scan using ix4ucc_userdepartmentgroupstartend on "17f7a637b83349e9b16ef4905eb64944".userdepartmentgroup userdepartmentgroup34 (cost=0.15..2.18 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: userdepartmentgroup34.userid, userdepartmentgroup34.departmentgroupid, userdepartmentgroup34.startdate, userdepartmentgroup34.enddate
  • Index Cond: ((userdepartmentgroup34.userid = 376) AND (userdepartmentgroup34.departmentgroupid = departmentgroupflathierarchy33.childid) AND (userdepartmentgroup34.startdate <= '2019-09-30'::date) AND (userdepartmentgroup34.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
  • Buffers: shared hit=1
207. 0.002 0.003 ↓ 0.0 0 1

Nested Loop (cost=0.30..8.55 rows=6 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: ployeetypegroupflathierarchy35.parentid
  • Buffers: shared hit=1
208. 0.001 0.001 ↓ 0.0 0 1

Index Only Scan using ix4ucc_useremployeetypegroupstartend on "17f7a637b83349e9b16ef4905eb64944".useremployeetypegroup useremployeetypegroup36 (cost=0.15..2.24 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: useremployeetypegroup36.userid, useremployeetypegroup36.employeetypegroupid, useremployeetypegroup36.startdate, useremployeetypegroup36.enddate
  • Index Cond: ((useremployeetypegroup36.userid = 376) AND (useremployeetypegroup36.startdate <= '2019-09-30'::date) AND (useremployeetypegroup36.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
  • Buffers: shared hit=1
209. 0.000 0.000 ↓ 0.0 0

Index Scan using ixetgfhchildid on "17f7a637b83349e9b16ef4905eb64944".employeetypegroupflathierarchy ployeetypegroupflathierarchy35 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: ployeetypegroupflathierarchy35.parentid, ployeetypegroupflathierarchy35.childid, ployeetypegroupflathierarchy35.parentdepth
  • Index Cond: (ployeetypegroupflathierarchy35.childid = useremployeetypegroup36.employeetypegroupid)
210. 290.645 2,906.450 ↑ 2.0 3 290,645

Hash (cost=1.53..1.53 rows=6 width=20) (actual time=0.010..0.010 rows=3 loops=290,645)

  • Output: taskteammemberassignment21.projectteammemberid, taskteammemberassignment21.taskid
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=873,694 read=5,119 written=69
211. 2,615.805 2,615.805 ↑ 2.0 3 290,645

Index Only Scan using uix2projectteammembertaskassignment on "17f7a637b83349e9b16ef4905eb64944".taskteammemberassignment taskteammemberassignment21 (cost=0.42..1.53 rows=6 width=20) (actual time=0.006..0.009 rows=3 loops=290,645)

  • Output: taskteammemberassignment21.projectteammemberid, taskteammemberassignment21.taskid
  • Index Cond: (taskteammemberassignment21.taskid = (NULL::integer))
  • Heap Fetches: 0
  • Buffers: shared hit=873,694 read=5,119 written=69
212. 1,115.248 1,115.248 ↑ 1.0 1 278,812

Index Scan using task_pkey on "17f7a637b83349e9b16ef4905eb64944".task task22 (cost=0.42..2.45 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=278,812)

  • Output: task22.id, task22.projectid, task22.parentid, task22.name, task22.code, task22.description, task22.isclosed, task22.orderindex, task22.percentcomplete, task22.istimeentryallowed, task22.estimatedhours, task22.timeentrystartdate, task22.timeentryenddate, task22.estimatedexpenses, task22.estimatedexpensescurrencyid, task22.expenseentrystartdate, task22.expenseentryenddate, task22.costtype, task22.estimatedcost, task22.estimatedcostcurrencyid, task22.timeandexpenseentrytype, task22.info1, task22.info2, task22.info3, task22.info4, task22.info5, task22.info6, task22.info7, task22.info8, task22.info9, task22.info10, task22.info11, task22.info12, task22.info13, task22.info14, task22.info15, task22.info16, task22.info17, task22.info18, task22.info19, task22.info20
  • Index Cond: (task22.id = (NULL::integer))
  • Filter: (task22.istimeentryallowed AND (NOT task22.isclosed) AND ($49 OR ((task22.timeentrystartdate <= '2019-09-30'::date) AND (task22.timeentryenddate >= '2019-09-22'::date))))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=1,115,064 read=1,005 written=14
213. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=38,029.96..76,406.35 rows=802,279 width=8) (never executed)

  • Output: projectteammember20_1.projectid, task22_1.id
  • Hash Cond: (taskteammemberassignment21_1.projectteammemberid = projectteammember20_1.id)
214.          

Initplan (for Hash Join)

215. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtspss2key on "17f7a637b83349e9b16ef4905eb64944".timesheetpolicysettingssnapshot esheetpolicysettingssnapshot37_1 (cost=0.68..3.72 rows=1 width=0) (never executed)

  • Index Cond: ((upper(esheetpolicysettingssnapshot37_1.key) = 'URN:REPLICON:POLICY:TIMESHEET:TASK-DATERANGE-ENTRY-OVERRIDE'::text) AND (upper(esheetpolicysettingssnapshot37_1.uri) = 'URN:REPLICON:POLICY:TIMESHEET:TASK-DATERANGE-ENTRY-OVERRIDE:OVERRIDE-TASK-DATERANGE-ENTRY'::text))
  • Filter: (esheetpolicysettingssnapshot37_1.timesheetid = '484e44e6-7209-4c91-9351-961796dc98d2'::uuid)
216. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=14,753.35..42,074.72 rows=808,592 width=20) (never executed)

  • Output: taskteammemberassignment21_1.projectteammemberid, task22_1.id
  • Hash Cond: (taskteammemberassignment21_1.taskid = task22_1.id)
217. 0.000 0.000 ↓ 0.0 0

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".taskteammemberassignment taskteammemberassignment21_1 (cost=0.00..15,969.15 rows=871,015 width=20) (never executed)

  • Output: taskteammemberassignment21_1.id, taskteammemberassignment21_1.taskid, taskteammemberassignment21_1.projectteammemberid, taskteammemberassignment21_1.taskallocationstartdate, taskteammemberassignment21_1.taskallocationenddate, taskteammemberassignment21_1.taskallocationduration
218. 0.000 0.000 ↓ 0.0 0

Hash (cost=10,458.15..10,458.15 rows=343,616 width=4) (never executed)

  • Output: task22_1.id
219. 0.000 0.000 ↓ 0.0 0

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".task task22_1 (cost=0.00..10,458.15 rows=343,616 width=4) (never executed)

  • Output: task22_1.id
  • Filter: (task22_1.istimeentryallowed AND (NOT task22_1.isclosed) AND ($68 OR ((task22_1.timeentrystartdate <= '2019-09-30'::date) AND (task22_1.timeentryenddate >= '2019-09-22'::date))))
220. 0.000 0.000 ↓ 0.0 0

Hash (cost=17,484.08..17,484.08 rows=463,105 width=20) (never executed)

  • Output: projectteammember20_1.projectid, projectteammember20_1.id
221. 0.000 0.000 ↓ 0.0 0

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".projectteammember projectteammember20_1 (cost=47.61..17,484.08 rows=463,105 width=20) (never executed)

  • Output: projectteammember20_1.projectid, projectteammember20_1.id
  • Filter: ((projectteammember20_1.userid = 376) OR (hashed SubPlan 30) OR (hashed SubPlan 31) OR (hashed SubPlan 32) OR (hashed SubPlan 33) OR (hashed SubPlan 34) OR (hashed SubPlan 35) OR (hashed SubPlan 36))
222.          

SubPlan (for Seq Scan)

223. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..4.50 rows=2 width=4) (never executed)

  • Output: departmentflathierarchy23_1.parentid
224. 0.000 0.000 ↓ 0.0 0

Index Scan using ixduuserid on "17f7a637b83349e9b16ef4905eb64944".departmentusers departmentusers24_1 (cost=0.28..2.30 rows=1 width=4) (never executed)

  • Output: departmentusers24_1.departmentid, departmentusers24_1.userid, departmentusers24_1.isprimarydepartment
  • Index Cond: (departmentusers24_1.userid = 376)
225. 0.000 0.000 ↓ 0.0 0

Index Scan using ixdfhchildid on "17f7a637b83349e9b16ef4905eb64944".departmentflathierarchy departmentflathierarchy23_1 (cost=0.14..2.18 rows=2 width=8) (never executed)

  • Output: departmentflathierarchy23_1.parentid, departmentflathierarchy23_1.childid, departmentflathierarchy23_1.depth
  • Index Cond: (departmentflathierarchy23_1.childid = departmentusers24_1.departmentid)
226. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..5.63 rows=1 width=16) (never executed)

  • Output: locationflathierarchy25_1.parentid
227. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix4ul_userlocationstartend on "17f7a637b83349e9b16ef4905eb64944".userlocation userlocation26_1 (cost=0.28..2.30 rows=1 width=16) (never executed)

  • Output: userlocation26_1.userid, userlocation26_1.locationid, userlocation26_1.startdate, userlocation26_1.enddate
  • Index Cond: ((userlocation26_1.userid = 376) AND (userlocation26_1.startdate <= '2019-09-30'::date) AND (userlocation26_1.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
228. 0.000 0.000 ↓ 0.0 0

Index Scan using ixlfhchildid on "17f7a637b83349e9b16ef4905eb64944".locationflathierarchy locationflathierarchy25_1 (cost=0.28..3.31 rows=2 width=32) (never executed)

  • Output: locationflathierarchy25_1.parentid, locationflathierarchy25_1.childid, locationflathierarchy25_1.parentdepth
  • Index Cond: (locationflathierarchy25_1.childid = userlocation26_1.locationid)
229. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.30..8.55 rows=6 width=16) (never executed)

  • Output: divisionflathierarchy27_1.parentid
230. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix4ud_userdivisionstartend on "17f7a637b83349e9b16ef4905eb64944".userdivision userdivision28_1 (cost=0.15..2.24 rows=1 width=16) (never executed)

  • Output: userdivision28_1.userid, userdivision28_1.divisionid, userdivision28_1.startdate, userdivision28_1.enddate
  • Index Cond: ((userdivision28_1.userid = 376) AND (userdivision28_1.startdate <= '2019-09-30'::date) AND (userdivision28_1.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
231. 0.000 0.000 ↓ 0.0 0

Index Scan using ixdivfhchildid on "17f7a637b83349e9b16ef4905eb64944".divisionflathierarchy divisionflathierarchy27_1 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: divisionflathierarchy27_1.parentid, divisionflathierarchy27_1.childid, divisionflathierarchy27_1.parentdepth
  • Index Cond: (divisionflathierarchy27_1.childid = userdivision28_1.divisionid)
232. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.30..8.55 rows=6 width=16) (never executed)

  • Output: costcenterflathierarchy29_1.parentid
233. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix4ucc_usercostcenterstartend on "17f7a637b83349e9b16ef4905eb64944".usercostcenter usercostcenter30_1 (cost=0.15..2.24 rows=1 width=16) (never executed)

  • Output: usercostcenter30_1.userid, usercostcenter30_1.costcenterid, usercostcenter30_1.startdate, usercostcenter30_1.enddate
  • Index Cond: ((usercostcenter30_1.userid = 376) AND (usercostcenter30_1.startdate <= '2019-09-30'::date) AND (usercostcenter30_1.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
234. 0.000 0.000 ↓ 0.0 0

Index Scan using ixccfhchildid on "17f7a637b83349e9b16ef4905eb64944".costcenterflathierarchy costcenterflathierarchy29_1 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: costcenterflathierarchy29_1.parentid, costcenterflathierarchy29_1.childid, costcenterflathierarchy29_1.parentdepth
  • Index Cond: (costcenterflathierarchy29_1.childid = usercostcenter30_1.costcenterid)
235. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.30..8.55 rows=6 width=16) (never executed)

  • Output: servicecenterflathierarchy31_1.parentid
236. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix4usc_userservicecenterstartend on "17f7a637b83349e9b16ef4905eb64944".userservicecenter userservicecenter32_1 (cost=0.15..2.24 rows=1 width=16) (never executed)

  • Output: userservicecenter32_1.userid, userservicecenter32_1.servicecenterid, userservicecenter32_1.startdate, userservicecenter32_1.enddate
  • Index Cond: ((userservicecenter32_1.userid = 376) AND (userservicecenter32_1.startdate <= '2019-09-30'::date) AND (userservicecenter32_1.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
237. 0.000 0.000 ↓ 0.0 0

Index Scan using ixscfhchildid on "17f7a637b83349e9b16ef4905eb64944".servicecenterflathierarchy servicecenterflathierarchy31_1 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: servicecenterflathierarchy31_1.parentid, servicecenterflathierarchy31_1.childid, servicecenterflathierarchy31_1.parentdepth
  • Index Cond: (servicecenterflathierarchy31_1.childid = userservicecenter32_1.servicecenterid)
238. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.15..3.20 rows=1 width=16) (never executed)

  • Output: departmentgroupflathierarchy33_1.parentid
239. 0.000 0.000 ↓ 0.0 0

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".departmentgroupflathierarchy departmentgroupflathierarchy33_1 (cost=0.00..1.01 rows=1 width=32) (never executed)

  • Output: departmentgroupflathierarchy33_1.parentid, departmentgroupflathierarchy33_1.childid, departmentgroupflathierarchy33_1.parentdepth
240. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix4ucc_userdepartmentgroupstartend on "17f7a637b83349e9b16ef4905eb64944".userdepartmentgroup userdepartmentgroup34_1 (cost=0.15..2.18 rows=1 width=16) (never executed)

  • Output: userdepartmentgroup34_1.userid, userdepartmentgroup34_1.departmentgroupid, userdepartmentgroup34_1.startdate, userdepartmentgroup34_1.enddate
  • Index Cond: ((userdepartmentgroup34_1.userid = 376) AND (userdepartmentgroup34_1.departmentgroupid = departmentgroupflathierarchy33_1.childid) AND (userdepartmentgroup34_1.startdate <= '2019-09-30'::date) AND (userdepartmentgroup34_1.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
241. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.30..8.55 rows=6 width=16) (never executed)

  • Output: ployeetypegroupflathierarchy35_1.parentid
242. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix4ucc_useremployeetypegroupstartend on "17f7a637b83349e9b16ef4905eb64944".useremployeetypegroup useremployeetypegroup36_1 (cost=0.15..2.24 rows=1 width=16) (never executed)

  • Output: useremployeetypegroup36_1.userid, useremployeetypegroup36_1.employeetypegroupid, useremployeetypegroup36_1.startdate, useremployeetypegroup36_1.enddate
  • Index Cond: ((useremployeetypegroup36_1.userid = 376) AND (useremployeetypegroup36_1.startdate <= '2019-09-30'::date) AND (useremployeetypegroup36_1.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
243. 0.000 0.000 ↓ 0.0 0

Index Scan using ixetgfhchildid on "17f7a637b83349e9b16ef4905eb64944".employeetypegroupflathierarchy ployeetypegroupflathierarchy35_1 (cost=0.15..6.26 rows=6 width=32) (never executed)

  • Output: ployeetypegroupflathierarchy35_1.parentid, ployeetypegroupflathierarchy35_1.childid, ployeetypegroupflathierarchy35_1.parentdepth
  • Index Cond: (ployeetypegroupflathierarchy35_1.childid = useremployeetypegroup36_1.employeetypegroupid)
Planning time : 56.248 ms
Execution time : 40,288.821 ms