explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6dSt : wcg_before

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 41,336.388 ↑ 1.0 11 1

Limit (cost=48,706,488.07..48,706,488.10 rows=11 width=152) (actual time=41,336.381..41,336.388 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,477,987 read=16,185 written=56
2. 253.918 41,336.384 ↑ 72,539.6 11 1

Sort (cost=48,706,488.07..48,708,482.91 rows=797,936 width=152) (actual time=41,336.380..41,336.384 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,477,987 read=16,185 written=56
3. 1,207.667 41,082.466 ↑ 3.3 245,076 1

Nested Loop (cost=0.70..48,688,696.36 rows=797,936 width=152) (actual time=64.974..41,082.466 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,477,977 read=16,185 written=56
4. 5.957 512.525 ↓ 1.7 1,442 1

Nested Loop Semi Join (cost=0.28..34,805.35 rows=862 width=126) (actual time=31.627..512.525 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=21,880 read=167
5. 11.329 503.110 ↓ 1.0 1,729 1

Nested Loop (cost=0.28..30,824.13 rows=1,723 width=126) (actual time=31.590..503.110 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=16,664 read=167
6. 237.705 473.934 ↓ 1.0 3,450 1

Nested Loop Left Join (cost=0.00..17,277.34 rows=3,446 width=76) (actual time=31.505..473.934 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=1,393 read=166
7. 1.964 39.579 ↓ 1.0 3,450 1

Nested Loop (cost=0.00..1,964.40 rows=3,446 width=24) (actual time=31.458..39.579 rows=3,450 loops=1)

  • Output: ts.id, projectclient.projectid, projectclient.clientid
  • Buffers: shared hit=1,388 read=162
8. 33.556 33.556 ↑ 1.0 1 1

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".timesheet ts (cost=0.00..1,823.58 rows=1 width=16) (actual time=31.427..33.556 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,389
  • Buffers: shared hit=685 read=162
9. 1.575 4.059 ↓ 1.0 3,450 1

Append (cost=0.00..106.37 rows=3,446 width=8) (actual time=0.020..4.059 rows=3,450 loops=1)

  • Buffers: shared hit=703
10. 1.541 1.541 ↓ 1.0 1,722 1

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".projectclient (cost=0.00..39.20 rows=1,720 width=8) (actual time=0.019..1.541 rows=1,722 loops=1)

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

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

  • Output: project_1.id, NULL::integer
  • Heap Fetches: 921
  • Buffers: shared hit=681
12. 196.383 196.650 ↓ 1.0 297 3,450

Materialize (cost=0.00..13.44 rows=296 width=56) (actual time=0.000..0.057 rows=297 loops=3,450)

  • Output: c.id, c.name, c.slug, c.code
  • Buffers: shared hit=5 read=4
13. 0.267 0.267 ↓ 1.0 297 1

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".clients c (cost=0.00..11.96 rows=296 width=56) (actual time=0.016..0.267 rows=297 loops=1)

  • Output: c.id, c.name, c.slug, c.code
  • Buffers: shared hit=5 read=4
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,406
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. 0.609 0.609 ↓ 1.0 1,722 1

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".projectclient projectclient1_1 (cost=0.00..47.80 rows=1,720 width=4) (actual time=0.013..0.609 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. 6.888 6.888 ↑ 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.004..0.004 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: 1,394
  • Buffers: shared hit=4,843 read=1
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.018 0.018 ↑ 1.0 1 1

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".projectstatuslabel projectstatuslabel3 (cost=0.00..1.09 rows=1 width=16) (actual time=0.016..0.018 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,215
23. 132.664 39,362.274 ↓ 1.7 181 1,442

Append (cost=0.42..56,410.24 rows=108 width=34) (actual time=1.620..27.297 rows=181 loops=1,442)

  • Buffers: shared hit=4,456,097 read=16,018 written=56
24. 1,705.850 39,209.422 ↓ 1.7 181 1,442

Index Scan using ixtkprojectid on "17f7a637b83349e9b16ef4905eb64944".task (cost=0.42..56,148.80 rows=107 width=34) (actual time=1.612..27.191 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,442,139 read=16,018 written=56
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.002..0.003 rows=1 loops=1,442)

  • Output: project4.istimeentryallowed
  • Index Cond: (project4.id = p.id)
  • Buffers: shared hit=4,353
27. 5.967 6.041 ↓ 0.0 0 863

Index Scan using uix2ptm_projectemptypegrp on "17f7a637b83349e9b16ef4905eb64944".projectteammember projectteammember5 (cost=47.04..199.31 rows=322 width=0) (actual time=0.007..0.007 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.006 0.020 ↑ 1.0 2 1

Nested Loop (cost=0.42..4.50 rows=2 width=4) (actual time=0.017..0.020 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.006 0.006 ↑ 1.0 2 1

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

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

Nested Loop (cost=0.56..4.63 rows=1 width=16) (actual time=0.021..0.023 rows=1 loops=1)

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

Index Only Scan using ix4ul_userlocationstartend on "17f7a637b83349e9b16ef4905eb64944".userlocation userlocation9 (cost=0.28..1.30 rows=1 width=16) (actual time=0.009..0.009 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.009 0.009 ↑ 2.0 1 1

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

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

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

  • Output: divisionflathierarchy10.parentid
  • Buffers: shared hit=1
36. 0.003 0.003 ↓ 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.003..0.003 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.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: servicecenterflathierarchy14.parentid
  • Buffers: shared hit=1
42. 0.004 0.004 ↓ 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.004..0.004 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.006 0.014 ↓ 0.0 0 1

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

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

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

  • Output: departmentgroupflathierarchy16.parentid, departmentgroupflathierarchy16.childid, departmentgroupflathierarchy16.parentdepth
  • Buffers: shared hit=1
46. 0.004 0.004 ↓ 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.004..0.004 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.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: ployeetypegroupflathierarchy18.parentid
  • Buffers: shared hit=1
48. 0.004 0.004 ↓ 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.004..0.004 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=46.61..17,485.84 rows=463,196 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..4.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..1.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. 333.415 37,493.205 ↑ 1.0 1 290,645

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

  • Buffers: shared hit=4,380,278 read=10,905 written=30
74.          

Initplan (for Nested Loop)

75. 4.562 4.562 ↓ 0.0 0 1

Index Scan using ixtspss2key on "17f7a637b83349e9b16ef4905eb64944".timesheetpolicysettingssnapshot esheetpolicysettingssnapshot37 (cost=0.68..3.72 rows=1 width=0) (actual time=4.562..4.562 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,001.621 36,039.980 ↑ 1.0 1 290,645

Hash Join (cost=49.64..205.14 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,265,126 read=9,811 written=19
77. 31,838.779 31,841.264 ↑ 322.0 1 284,297

Index Scan using uix2ptm_projectemptypegrp on "17f7a637b83349e9b16ef4905eb64944".projectteammember projectteammember20 (cost=47.04..199.31 rows=322 width=16) (actual time=0.081..0.112 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,239 read=4,497 written=2
78.          

SubPlan (for Index Scan)

79. 0.008 0.042 ↑ 1.0 2 1

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

  • Output: departmentflathierarchy23.parentid
  • Buffers: shared hit=5
80. 0.021 0.021 ↑ 1.0 1 1

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

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

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

  • Output: departmentflathierarchy23.parentid, departmentflathierarchy23.childid, departmentflathierarchy23.depth
  • Index Cond: (departmentflathierarchy23.childid = departmentusers24.departmentid)
  • Buffers: shared hit=2
82. 0.004 1.867 ↑ 1.0 1 1

Nested Loop (cost=0.56..4.63 rows=1 width=16) (actual time=1.865..1.867 rows=1 loops=1)

  • Output: locationflathierarchy25.parentid
  • Buffers: shared hit=2 read=4
83. 1.838 1.838 ↑ 1.0 1 1

Index Only Scan using ix4ul_userlocationstartend on "17f7a637b83349e9b16ef4905eb64944".userlocation userlocation26 (cost=0.28..1.30 rows=1 width=16) (actual time=1.837..1.838 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 read=3
84. 0.025 0.025 ↑ 2.0 1 1

Index Scan using ixlfhchildid on "17f7a637b83349e9b16ef4905eb64944".locationflathierarchy locationflathierarchy25 (cost=0.28..3.31 rows=2 width=32) (actual time=0.024..0.025 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.002 0.005 ↓ 0.0 0 1

Nested Loop (cost=0.30..8.55 rows=6 width=16) (actual time=0.005..0.005 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.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: costcenterflathierarchy29.parentid
  • Buffers: shared hit=1
89. 0.003 0.003 ↓ 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.003..0.003 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.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: servicecenterflathierarchy31.parentid
  • Buffers: shared hit=1
92. 0.003 0.003 ↓ 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.003..0.003 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.009 0.559 ↓ 0.0 0 1

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

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

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

  • Output: departmentgroupflathierarchy33.parentid, departmentgroupflathierarchy33.childid, departmentgroupflathierarchy33.parentdepth
  • Buffers: shared read=1
96. 0.005 0.005 ↓ 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.005..0.005 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.005 ↓ 0.0 0 1

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

  • Output: ployeetypegroupflathierarchy35.parentid
  • Buffers: shared hit=1
98. 0.003 0.003 ↓ 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.003..0.003 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. 581.290 3,197.095 ↑ 2.0 3 290,645

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

  • Output: taskteammemberassignment21.projectteammemberid, taskteammemberassignment21.taskid
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=893,887 read=5,314 written=17
101. 2,615.805 2,615.805 ↑ 2.0 3 290,645

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

  • Output: taskteammemberassignment21.projectteammemberid, taskteammemberassignment21.taskid
  • Index Cond: (taskteammemberassignment21.taskid = task.id)
  • Heap Fetches: 23,389
  • Buffers: shared hit=893,887 read=5,314 written=17
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,152 read=1,094 written=11
103. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=38,033.63..76,410.47 rows=802,320 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,754.12..42,075.40 rows=808,633 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,968.78 rows=870,978 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.35..10,458.35 rows=343,661 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.35 rows=343,661 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,485.84..17,485.84 rows=463,196 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=46.61..17,485.84 rows=463,196 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..4.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..1.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 20.188 ↓ 0.0 0 1,442

Index Only Scan using project_pkey on "17f7a637b83349e9b16ef4905eb64944".project (cost=0.28..261.44 rows=1 width=72) (actual time=0.014..0.014 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: 787
  • Buffers: shared hit=13,958
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.002..0.003 rows=1 loops=1,442)

  • Output: project4.istimeentryallowed
  • Index Cond: (project4.id = p.id)
  • Buffers: shared hit=4,353
137. 5.967 6.041 ↓ 0.0 0 863

Index Scan using uix2ptm_projectemptypegrp on "17f7a637b83349e9b16ef4905eb64944".projectteammember projectteammember5 (cost=47.04..199.31 rows=322 width=0) (actual time=0.007..0.007 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.006 0.020 ↑ 1.0 2 1

Nested Loop (cost=0.42..4.50 rows=2 width=4) (actual time=0.017..0.020 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.006 0.006 ↑ 1.0 2 1

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

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

Nested Loop (cost=0.56..4.63 rows=1 width=16) (actual time=0.021..0.023 rows=1 loops=1)

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

Index Only Scan using ix4ul_userlocationstartend on "17f7a637b83349e9b16ef4905eb64944".userlocation userlocation9 (cost=0.28..1.30 rows=1 width=16) (actual time=0.009..0.009 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.009 0.009 ↑ 2.0 1 1

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

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

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

  • Output: divisionflathierarchy10.parentid
  • Buffers: shared hit=1
146. 0.003 0.003 ↓ 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.003..0.003 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.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: servicecenterflathierarchy14.parentid
  • Buffers: shared hit=1
152. 0.004 0.004 ↓ 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.004..0.004 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.006 0.014 ↓ 0.0 0 1

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

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

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

  • Output: departmentgroupflathierarchy16.parentid, departmentgroupflathierarchy16.childid, departmentgroupflathierarchy16.parentdepth
  • Buffers: shared hit=1
156. 0.004 0.004 ↓ 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.004..0.004 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.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: ployeetypegroupflathierarchy18.parentid
  • Buffers: shared hit=1
158. 0.004 0.004 ↓ 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.004..0.004 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=46.61..17,485.84 rows=463,196 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..4.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..1.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. 333.415 37,493.205 ↑ 1.0 1 290,645

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

  • Buffers: shared hit=4,380,278 read=10,905 written=30
184.          

Initplan (for Nested Loop)

185. 4.562 4.562 ↓ 0.0 0 1

Index Scan using ixtspss2key on "17f7a637b83349e9b16ef4905eb64944".timesheetpolicysettingssnapshot esheetpolicysettingssnapshot37 (cost=0.68..3.72 rows=1 width=0) (actual time=4.562..4.562 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,001.621 36,039.980 ↑ 1.0 1 290,645

Hash Join (cost=49.64..205.14 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,265,126 read=9,811 written=19
187. 31,838.779 31,841.264 ↑ 322.0 1 284,297

Index Scan using uix2ptm_projectemptypegrp on "17f7a637b83349e9b16ef4905eb64944".projectteammember projectteammember20 (cost=47.04..199.31 rows=322 width=16) (actual time=0.081..0.112 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,239 read=4,497 written=2
188.          

SubPlan (for Index Scan)

189. 0.008 0.042 ↑ 1.0 2 1

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

  • Output: departmentflathierarchy23.parentid
  • Buffers: shared hit=5
190. 0.021 0.021 ↑ 1.0 1 1

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

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

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

  • Output: departmentflathierarchy23.parentid, departmentflathierarchy23.childid, departmentflathierarchy23.depth
  • Index Cond: (departmentflathierarchy23.childid = departmentusers24.departmentid)
  • Buffers: shared hit=2
192. 0.004 1.867 ↑ 1.0 1 1

Nested Loop (cost=0.56..4.63 rows=1 width=16) (actual time=1.865..1.867 rows=1 loops=1)

  • Output: locationflathierarchy25.parentid
  • Buffers: shared hit=2 read=4
193. 1.838 1.838 ↑ 1.0 1 1

Index Only Scan using ix4ul_userlocationstartend on "17f7a637b83349e9b16ef4905eb64944".userlocation userlocation26 (cost=0.28..1.30 rows=1 width=16) (actual time=1.837..1.838 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 read=3
194. 0.025 0.025 ↑ 2.0 1 1

Index Scan using ixlfhchildid on "17f7a637b83349e9b16ef4905eb64944".locationflathierarchy locationflathierarchy25 (cost=0.28..3.31 rows=2 width=32) (actual time=0.024..0.025 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.002 0.005 ↓ 0.0 0 1

Nested Loop (cost=0.30..8.55 rows=6 width=16) (actual time=0.005..0.005 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.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: costcenterflathierarchy29.parentid
  • Buffers: shared hit=1
199. 0.003 0.003 ↓ 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.003..0.003 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.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: servicecenterflathierarchy31.parentid
  • Buffers: shared hit=1
202. 0.003 0.003 ↓ 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.003..0.003 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.009 0.559 ↓ 0.0 0 1

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

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

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

  • Output: departmentgroupflathierarchy33.parentid, departmentgroupflathierarchy33.childid, departmentgroupflathierarchy33.parentdepth
  • Buffers: shared read=1
206. 0.005 0.005 ↓ 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.005..0.005 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.005 ↓ 0.0 0 1

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

  • Output: ployeetypegroupflathierarchy35.parentid
  • Buffers: shared hit=1
208. 0.003 0.003 ↓ 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.003..0.003 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. 581.290 3,197.095 ↑ 2.0 3 290,645

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

  • Output: taskteammemberassignment21.projectteammemberid, taskteammemberassignment21.taskid
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=893,887 read=5,314 written=17
211. 2,615.805 2,615.805 ↑ 2.0 3 290,645

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

  • Output: taskteammemberassignment21.projectteammemberid, taskteammemberassignment21.taskid
  • Index Cond: (taskteammemberassignment21.taskid = (NULL::integer))
  • Heap Fetches: 23,389
  • Buffers: shared hit=893,887 read=5,314 written=17
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,152 read=1,094 written=11
213. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=38,033.63..76,410.47 rows=802,320 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,754.12..42,075.40 rows=808,633 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,968.78 rows=870,978 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.35..10,458.35 rows=343,661 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.35 rows=343,661 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,485.84..17,485.84 rows=463,196 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=46.61..17,485.84 rows=463,196 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..4.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..1.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 : 105.881 ms
Execution time : 41,338.694 ms