explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pO2K

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 39,953.532 ↑ 1.0 11 1

Limit (cost=48,896,148.78..48,896,148.80 rows=11 width=152) (actual time=39,953.526..39,953.532 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, ((ta (...)
2. 249.389 39,953.526 ↑ 72,539.6 11 1

Sort (cost=48,896,148.78..48,898,143.62 rows=797,936 width=152) (actual time=39,953.525..39,953.526 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 (...)
  • 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%'::te (...)
  • Sort Method: top-N heapsort Memory: 27kB
3. 1,210.491 39,704.137 ↑ 3.3 245,076 1

Nested Loop (cost=0.70..48,878,357.07 rows=797,936 width=152) (actual time=68.464..39,704.137 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 (...)
  • 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
4. 5.295 543.090 ↓ 1.7 1,442 1

Nested Loop Semi Join (cost=0.28..34,770.90 rows=862 width=126) (actual time=22.280..543.090 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
5. 8.009 534.337 ↓ 1.0 1,729 1

Nested Loop (cost=0.28..30,789.68 rows=1,723 width=126) (actual time=22.269..534.337 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
6. 256.704 510.169 ↓ 1.0 3,450 1

Nested Loop Left Join (cost=0.00..17,242.89 rows=3,446 width=76) (actual time=22.244..510.169 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
7. 2.022 29.215 ↓ 1.0 3,450 1

Nested Loop (cost=0.00..1,929.95 rows=3,446 width=24) (actual time=22.226..29.215 rows=3,450 loops=1)

  • Output: ts.id, projectclient.projectid, projectclient.clientid
8. 23.335 23.335 ↑ 1.0 1 1

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".timesheet ts (cost=0.00..1,789.12 rows=1 width=16) (actual time=22.218..23.335 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: 76,394
9. 1.678 3.858 ↓ 1.0 3,450 1

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

10. 1.255 1.255 ↓ 1.0 1,722 1

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

  • Output: projectclient.projectid, projectclient.clientid
11. 0.925 0.925 ↓ 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.007..0.925 rows=1,728 loops=1)

  • Output: project_1.id, NULL::integer
  • Heap Fetches: 866
12. 224.141 224.250 ↓ 1.0 297 3,450

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

  • Output: c.id, c.name, c.slug, c.code
13. 0.109 0.109 ↓ 1.0 297 1

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

  • Output: c.id, c.name, c.slug, c.code
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.002..0.003 rows=1 loops=3,450)

  • Output: p.id, p.name, p.slug, p.code, p.programid
  • Index Cond: (p.id = projectclient.projectid)
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.643 0.643 ↓ 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.011..0.643 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))
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: 1,394
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
20. 0.004 0.004 ↑ 1.0 1 1

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

  • Output: projectstatuslabel3.id
  • Filter: (projectstatuslabel3.projectstatustype = 1)
  • Rows Removed by Filter: 6
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)
23. 147.084 37,950.556 ↓ 1.7 181 1,442

Append (cost=0.42..56,630.31 rows=108 width=34) (actual time=0.602..26.318 rows=181 loops=1,442)

24. 576.988 37,787.610 ↓ 1.7 181 1,442

Index Scan using ixtkprojectid on "17f7a637b83349e9b16ef4905eb64944".task (cost=0.42..56,367.85 rows=107 width=34) (actual time=0.595..26.205 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
25.          

SubPlan (for Index Scan)

26. 2.884 2.884 ↑ 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.002 rows=1 loops=1,442)

  • Output: project4.istimeentryallowed
  • Index Cond: (project4.id = p.id)
27. 5.135 5.178 ↓ 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.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
28.          

SubPlan (for Index Scan)

29. 0.006 0.013 ↑ 1.0 2 1

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

  • Output: departmentflathierarchy6.parentid
30. 0.004 0.004 ↑ 1.0 1 1

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

  • Output: departmentusers7.departmentid, departmentusers7.userid, departmentusers7.isprimarydepartment
  • Index Cond: (departmentusers7.userid = 376)
31. 0.003 0.003 ↑ 1.0 2 1

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

  • Output: departmentflathierarchy6.parentid, departmentflathierarchy6.childid, departmentflathierarchy6.depth
  • Index Cond: (departmentflathierarchy6.childid = departmentusers7.departmentid)
32. 0.004 0.014 ↑ 1.0 1 1

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

  • Output: locationflathierarchy8.parentid
33. 0.006 0.006 ↑ 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.005..0.006 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
34. 0.004 0.004 ↑ 2.0 1 1

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

  • Output: locationflathierarchy8.parentid, locationflathierarchy8.childid, locationflathierarchy8.parentdepth
  • Index Cond: (locationflathierarchy8.childid = userlocation9.locationid)
35. 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: divisionflathierarchy10.parentid
36. 0.002 0.002 ↓ 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.002..0.002 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
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.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: costcenterflathierarchy12.parentid
39. 0.002 0.002 ↓ 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.002..0.002 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
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.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: servicecenterflathierarchy14.parentid
42. 0.002 0.002 ↓ 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.002..0.002 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
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.005 0.007 ↓ 0.0 0 1

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

  • Output: departmentgroupflathierarchy16.parentid
  • -> Index Only Scan using ix4ucc_userdepartmentgroupstartend on "17f7a637b83349e9b16ef4905eb64944".userdepartmentgroup userdepartmentgroup17 (cost=0.15..2.18 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops (...)
45. 0.002 0.002 ↑ 1.0 1 1

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

  • Output: departmentgroupflathierarchy16.parentid, departmentgroupflathierarchy16.childid, departmentgroupflathierarchy16.parentdepth
  • 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 (userde (...)
  • Heap Fetches: 0
46. 0.003 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
  • -> Index Only Scan using ix4ucc_useremployeetypegroupstartend on "17f7a637b83349e9b16ef4905eb64944".useremployeetypegroup useremployeetypegroup19 (cost=0.15..2.24 rows=1 width=16) (actual time=0.002..0.002 rows=0 (...)
  • 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
47. 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)
48. 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))
49.          

SubPlan (for Seq Scan)

50. 0.000 0.000 ↓ 0.0 0

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

  • Output: departmentflathierarchy6_1.parentid
51. 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)
52. 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)
53. 0.000 0.000 ↓ 0.0 0

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

  • Output: locationflathierarchy8_1.parentid
54. 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
55. 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)
56. 0.000 0.000 ↓ 0.0 0

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

  • Output: divisionflathierarchy10_1.parentid
57. 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
58. 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)
59. 0.000 0.000 ↓ 0.0 0

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

  • Output: costcenterflathierarchy12_1.parentid
60. 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
61. 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)
62. 0.000 0.000 ↓ 0.0 0

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

  • Output: servicecenterflathierarchy14_1.parentid
63. 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
64. 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)
65. 0.000 0.000 ↓ 0.0 0

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

  • Output: departmentgroupflathierarchy16_1.parentid
66. 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
67. 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 (...)
  • Heap Fetches: 0
68. 0.000 0.000 ↓ 0.0 0

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

  • Output: ployeetypegroupflathierarchy18_1.parentid
69. 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
70. 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)
71. 326.060 37,202.560 ↑ 1.0 1 290,645

Nested Loop (cost=54.80..212.34 rows=1 width=0) (actual time=0.128..0.128 rows=1 loops=290,645)

72.          

Initplan (for Nested Loop)

73. 0.084 0.084 ↓ 0.0 0 1

Index Scan using ixtspss2key on "17f7a637b83349e9b16ef4905eb64944".timesheetpolicysettingssnapshot esheetpolicysettingssnapshot37 (cost=0.68..4.74 rows=1 width=0) (actual time=0.084..0.084 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-DA (...)
  • Filter: (esheetpolicysettingssnapshot37.timesheetid = '484e44e6-7209-4c91-9351-961796dc98d2'::uuid)
74. 1,039.709 36,039.980 ↑ 1.0 1 290,645

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

  • Output: taskteammemberassignment21.taskid
  • Hash Cond: (projectteammember20.id = taskteammemberassignment21.projectteammemberid)
75. 33,504.360 33,547.046 ↑ 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.086..0.118 rows=1 loops=284,297)

  • Output: projectteammember20.id, projectteammember20.projectid, projectteammember20.userid, projectteammember20.departmentid, projectteammember20.placeholderprojectroleid, projectteammember20.index, projectteamm (...)
  • 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
76.          

SubPlan (for Index Scan)

77. 0.007 42.639 ↑ 1.0 2 1

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

  • Output: departmentflathierarchy23.parentid
78. 42.627 42.627 ↑ 1.0 1 1

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

  • Output: departmentusers24.departmentid, departmentusers24.userid, departmentusers24.isprimarydepartment
  • Index Cond: (departmentusers24.userid = 376)
79. 0.005 0.005 ↑ 1.0 2 1

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

  • Output: departmentflathierarchy23.parentid, departmentflathierarchy23.childid, departmentflathierarchy23.depth
  • Index Cond: (departmentflathierarchy23.childid = departmentusers24.departmentid)
80. 0.004 0.029 ↑ 1.0 1 1

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

  • Output: locationflathierarchy25.parentid
81. 0.019 0.019 ↑ 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=0.018..0.019 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
82. 0.006 0.006 ↑ 2.0 1 1

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

  • Output: locationflathierarchy25.parentid, locationflathierarchy25.childid, locationflathierarchy25.parentdepth
  • Index Cond: (locationflathierarchy25.childid = userlocation26.locationid)
83. 0.001 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
84. 0.002 0.002 ↓ 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.002..0.002 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
85. 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)
86. 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: costcenterflathierarchy29.parentid
87. 0.001 0.001 ↓ 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.001..0.001 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
88. 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)
89. 0.002 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
  • -> 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 (...)
  • 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
90. 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)
91. 0.006 0.008 ↓ 0.0 0 1

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

  • Output: departmentgroupflathierarchy33.parentid
  • -> 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 (...)
92. 0.002 0.002 ↑ 1.0 1 1

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

  • Output: departmentgroupflathierarchy33.parentid, departmentgroupflathierarchy33.childid, departmentgroupflathierarchy33.parentdepth
  • 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) (...)
  • Heap Fetches: 0
93. 0.002 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: ployeetypegroupflathierarchy35.parentid
  • -> Index Only Scan using ix4ucc_useremployeetypegroupstartend on "17f7a637b83349e9b16ef4905eb64944".useremployeetypegroup useremployeetypegroup36 (cost=0.15..2.24 rows=1 width=16) (actual time=0.002.. (...)
  • 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
94. 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)
95. 1,453.225 1,453.225 ↑ 2.0 3 290,645

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

  • Output: taskteammemberassignment21.projectteammemberid, taskteammemberassignment21.taskid
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • -> Index Only Scan using uix2projectteammembertaskassignment on "17f7a637b83349e9b16ef4905eb64944".taskteammemberassignment taskteammemberassignment21 (cost=0.42..2.53 rows=6 width=20) (actual time=0.002..0.0 (...)
  • Output: taskteammemberassignment21.projectteammemberid, taskteammemberassignment21.taskid
  • Index Cond: (taskteammemberassignment21.taskid = task.id)
  • Heap Fetches: 23,389
96. 836.436 836.436 ↑ 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.003..0.003 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 (...)
  • 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
97. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=38,034.65..76,411.49 rows=802,320 width=8) (never executed)

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

Initplan (for Hash Join)

99. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtspss2key on "17f7a637b83349e9b16ef4905eb64944".timesheetpolicysettingssnapshot esheetpolicysettingssnapshot37_1 (cost=0.68..4.74 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:TAS (...)
  • Filter: (esheetpolicysettingssnapshot37_1.timesheetid = '484e44e6-7209-4c91-9351-961796dc98d2'::uuid)
100. 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)
101. 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 (...)
102. 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
103. 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))))
104. 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
105. 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))
106.          

SubPlan (for Seq Scan)

107. 0.000 0.000 ↓ 0.0 0

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

  • Output: departmentflathierarchy23_1.parentid
108. 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)
109. 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)
110. 0.000 0.000 ↓ 0.0 0

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

  • Output: locationflathierarchy25_1.parentid
111. 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
112. 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)
113. 0.000 0.000 ↓ 0.0 0

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

  • Output: divisionflathierarchy27_1.parentid
114. 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
115. 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)
116. 0.000 0.000 ↓ 0.0 0

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

  • Output: costcenterflathierarchy29_1.parentid
117. 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
118. 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)
119. 0.000 0.000 ↓ 0.0 0

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

  • Output: servicecenterflathierarchy31_1.parentid
120. 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
121. 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)
122. 0.000 0.000 ↓ 0.0 0

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

  • Output: departmentgroupflathierarchy33_1.parentid
123. 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
124. 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 (...)
  • Heap Fetches: 0
125. 0.000 0.000 ↓ 0.0 0

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

  • Output: ployeetypegroupflathierarchy35_1.parentid
126. 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
127. 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)
128. 0.000 15.862 ↓ 0.0 0 1,442

Index Only Scan using project_pkey on "17f7a637b83349e9b16ef4905eb64944".project (cost=0.28..262.46 rows=1 width=72) (actual time=0.011..0.011 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: 732
129.          

SubPlan (for Index Only Scan)

130. 2.884 2.884 ↑ 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.002 rows=1 loops=1,442)

  • Output: project4.istimeentryallowed
  • Index Cond: (project4.id = p.id)
131. 5.135 5.178 ↓ 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.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
132.          

SubPlan (for Index Scan)

133. 0.006 0.013 ↑ 1.0 2 1

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

  • Output: departmentflathierarchy6.parentid
134. 0.004 0.004 ↑ 1.0 1 1

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

  • Output: departmentusers7.departmentid, departmentusers7.userid, departmentusers7.isprimarydepartment
  • Index Cond: (departmentusers7.userid = 376)
135. 0.003 0.003 ↑ 1.0 2 1

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

  • Output: departmentflathierarchy6.parentid, departmentflathierarchy6.childid, departmentflathierarchy6.depth
  • Index Cond: (departmentflathierarchy6.childid = departmentusers7.departmentid)
136. 0.004 0.014 ↑ 1.0 1 1

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

  • Output: locationflathierarchy8.parentid
137. 0.006 0.006 ↑ 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.005..0.006 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
138. 0.004 0.004 ↑ 2.0 1 1

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

  • Output: locationflathierarchy8.parentid, locationflathierarchy8.childid, locationflathierarchy8.parentdepth
  • Index Cond: (locationflathierarchy8.childid = userlocation9.locationid)
139. 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: divisionflathierarchy10.parentid
140. 0.002 0.002 ↓ 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.002..0.002 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
141. 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)
142. 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: costcenterflathierarchy12.parentid
143. 0.002 0.002 ↓ 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.002..0.002 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
144. 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)
145. 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: servicecenterflathierarchy14.parentid
146. 0.002 0.002 ↓ 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.002..0.002 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
147. 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)
148. 0.005 0.007 ↓ 0.0 0 1

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

  • Output: departmentgroupflathierarchy16.parentid
  • -> Index Only Scan using ix4ucc_userdepartmentgroupstartend on "17f7a637b83349e9b16ef4905eb64944".userdepartmentgroup userdepartmentgroup17 (cost=0.15..2.18 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops (...)
149. 0.002 0.002 ↑ 1.0 1 1

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

  • Output: departmentgroupflathierarchy16.parentid, departmentgroupflathierarchy16.childid, departmentgroupflathierarchy16.parentdepth
  • 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 (userde (...)
  • Heap Fetches: 0
150. 0.003 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
  • -> Index Only Scan using ix4ucc_useremployeetypegroupstartend on "17f7a637b83349e9b16ef4905eb64944".useremployeetypegroup useremployeetypegroup19 (cost=0.15..2.24 rows=1 width=16) (actual time=0.002..0.002 rows=0 (...)
  • 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
151. 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)
152. 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))
153.          

SubPlan (for Seq Scan)

154. 0.000 0.000 ↓ 0.0 0

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

  • Output: departmentflathierarchy6_1.parentid
155. 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)
156. 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)
157. 0.000 0.000 ↓ 0.0 0

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

  • Output: locationflathierarchy8_1.parentid
158. 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
159. 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)
160. 0.000 0.000 ↓ 0.0 0

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

  • Output: divisionflathierarchy10_1.parentid
161. 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
162. 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)
163. 0.000 0.000 ↓ 0.0 0

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

  • Output: costcenterflathierarchy12_1.parentid
164. 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
165. 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)
166. 0.000 0.000 ↓ 0.0 0

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

  • Output: servicecenterflathierarchy14_1.parentid
167. 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
168. 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)
169. 0.000 0.000 ↓ 0.0 0

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

  • Output: departmentgroupflathierarchy16_1.parentid
170. 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
171. 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 (...)
  • Heap Fetches: 0
172. 0.000 0.000 ↓ 0.0 0

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

  • Output: ployeetypegroupflathierarchy18_1.parentid
173. 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
174. 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)
175. 326.060 37,202.560 ↑ 1.0 1 290,645

Nested Loop (cost=54.80..212.34 rows=1 width=0) (actual time=0.128..0.128 rows=1 loops=290,645)

176.          

Initplan (for Nested Loop)

177. 0.084 0.084 ↓ 0.0 0 1

Index Scan using ixtspss2key on "17f7a637b83349e9b16ef4905eb64944".timesheetpolicysettingssnapshot esheetpolicysettingssnapshot37 (cost=0.68..4.74 rows=1 width=0) (actual time=0.084..0.084 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-DA (...)
  • Filter: (esheetpolicysettingssnapshot37.timesheetid = '484e44e6-7209-4c91-9351-961796dc98d2'::uuid)
178. 1,039.709 36,039.980 ↑ 1.0 1 290,645

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

  • Output: taskteammemberassignment21.taskid
  • Hash Cond: (projectteammember20.id = taskteammemberassignment21.projectteammemberid)
179. 33,504.360 33,547.046 ↑ 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.086..0.118 rows=1 loops=284,297)

  • Output: projectteammember20.id, projectteammember20.projectid, projectteammember20.userid, projectteammember20.departmentid, projectteammember20.placeholderprojectroleid, projectteammember20.index, projectteamm (...)
  • 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
180.          

SubPlan (for Index Scan)

181. 0.007 42.639 ↑ 1.0 2 1

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

  • Output: departmentflathierarchy23.parentid
182. 42.627 42.627 ↑ 1.0 1 1

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

  • Output: departmentusers24.departmentid, departmentusers24.userid, departmentusers24.isprimarydepartment
  • Index Cond: (departmentusers24.userid = 376)
183. 0.005 0.005 ↑ 1.0 2 1

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

  • Output: departmentflathierarchy23.parentid, departmentflathierarchy23.childid, departmentflathierarchy23.depth
  • Index Cond: (departmentflathierarchy23.childid = departmentusers24.departmentid)
184. 0.004 0.029 ↑ 1.0 1 1

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

  • Output: locationflathierarchy25.parentid
185. 0.019 0.019 ↑ 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=0.018..0.019 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
186. 0.006 0.006 ↑ 2.0 1 1

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

  • Output: locationflathierarchy25.parentid, locationflathierarchy25.childid, locationflathierarchy25.parentdepth
  • Index Cond: (locationflathierarchy25.childid = userlocation26.locationid)
187. 0.001 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
188. 0.002 0.002 ↓ 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.002..0.002 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
189. 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)
190. 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: costcenterflathierarchy29.parentid
191. 0.001 0.001 ↓ 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.001..0.001 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
192. 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)
193. 0.002 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
  • -> 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 (...)
  • 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
194. 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)
195. 0.006 0.008 ↓ 0.0 0 1

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

  • Output: departmentgroupflathierarchy33.parentid
  • -> 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 (...)
196. 0.002 0.002 ↑ 1.0 1 1

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

  • Output: departmentgroupflathierarchy33.parentid, departmentgroupflathierarchy33.childid, departmentgroupflathierarchy33.parentdepth
  • 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) (...)
  • Heap Fetches: 0
197. 0.002 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: ployeetypegroupflathierarchy35.parentid
  • -> Index Only Scan using ix4ucc_useremployeetypegroupstartend on "17f7a637b83349e9b16ef4905eb64944".useremployeetypegroup useremployeetypegroup36 (cost=0.15..2.24 rows=1 width=16) (actual time=0.002.. (...)
  • 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
198. 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)
199. 1,453.225 1,453.225 ↑ 2.0 3 290,645

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

  • Output: taskteammemberassignment21.projectteammemberid, taskteammemberassignment21.taskid
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • -> Index Only Scan using uix2projectteammembertaskassignment on "17f7a637b83349e9b16ef4905eb64944".taskteammemberassignment taskteammemberassignment21 (cost=0.42..2.53 rows=6 width=20) (actual time=0.002..0.0 (...)
  • Output: taskteammemberassignment21.projectteammemberid, taskteammemberassignment21.taskid
  • Index Cond: (taskteammemberassignment21.taskid = (NULL::integer))
  • Heap Fetches: 23,389
200. 836.436 836.436 ↑ 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.003..0.003 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 (...)
  • 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
201. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=38,034.65..76,411.49 rows=802,320 width=8) (never executed)

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

Initplan (for Hash Join)

203. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtspss2key on "17f7a637b83349e9b16ef4905eb64944".timesheetpolicysettingssnapshot esheetpolicysettingssnapshot37_1 (cost=0.68..4.74 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:TAS (...)
  • Filter: (esheetpolicysettingssnapshot37_1.timesheetid = '484e44e6-7209-4c91-9351-961796dc98d2'::uuid)
204. 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)
205. 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 (...)
206. 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
207. 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))))
208. 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
209. 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))
210.          

SubPlan (for Seq Scan)

211. 0.000 0.000 ↓ 0.0 0

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

  • Output: departmentflathierarchy23_1.parentid
212. 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)
213. 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)
214. 0.000 0.000 ↓ 0.0 0

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

  • Output: locationflathierarchy25_1.parentid
215. 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
216. 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)
217. 0.000 0.000 ↓ 0.0 0

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

  • Output: divisionflathierarchy27_1.parentid
218. 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
219. 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)
220. 0.000 0.000 ↓ 0.0 0

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

  • Output: costcenterflathierarchy29_1.parentid
221. 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
222. 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)
223. 0.000 0.000 ↓ 0.0 0

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

  • Output: servicecenterflathierarchy31_1.parentid
224. 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
225. 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)
226. 0.000 0.000 ↓ 0.0 0

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

  • Output: departmentgroupflathierarchy33_1.parentid
227. 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
228. 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 (...)
  • Heap Fetches: 0
229. 0.000 0.000 ↓ 0.0 0

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

  • Output: ployeetypegroupflathierarchy35_1.parentid
230. 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
231. 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 : 11.506 ms
Execution time : 39,954.351 ms