explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M664 : Production Swimlane

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 44,729.845 ↑ 1.0 11 1

Limit (cost=48,119,034.53..48,119,034.56 rows=11 width=152) (actual time=44,729.837..44,729.845 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. 284.927 44,729.840 ↑ 70,554.5 11 1

Sort (cost=48,119,034.53..48,120,974.78 rows=776,100 width=152) (actual time=44,729.836..44,729.840 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,328.512 44,444.913 ↑ 3.2 244,485 1

Nested Loop (cost=0.97..48,101,729.71 rows=776,100 width=152) (actual time=8.929..44,444.913 rows=244,485 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: 15,925
4. 10.594 57.521 ↓ 1.7 1,440 1

Nested Loop Left Join (cost=0.55..10,412.23 rows=848 width=126) (actual time=8.266..57.521 rows=1,440 loops=1)

  • Output: ts.id, p.id, p.name, p.slug, p.code, projectclient.projectid, c.id, c.name, c.slug, c.code
  • 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 Filter: 1,436
5. 3.926 37.464 ↓ 1.7 2,876 1

Nested Loop (cost=0.28..6,349.94 rows=1,695 width=74) (actual time=8.250..37.464 rows=2,876 loops=1)

  • Output: ts.id, p.id, p.name, p.slug, p.code, projectclient.projectid, projectclient.clientid
6. 4.408 20.587 ↓ 1.7 1,439 1

Nested Loop (cost=0.00..5,821.05 rows=849 width=66) (actual time=8.231..20.587 rows=1,439 loops=1)

  • Output: ts.id, p.id, p.name, p.slug, p.code
  • Join Filter: (projectstatuslabel3.id = (SubPlan 39))
  • Rows Removed by Join Filter: 286
7. 0.006 9.410 ↑ 1.0 1 1

Nested Loop (cost=0.00..1,781.94 rows=1 width=32) (actual time=8.216..9.410 rows=1 loops=1)

  • Output: ts.id, projectstatuslabel3.id
8. 9.394 9.394 ↑ 1.0 1 1

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".timesheet ts (cost=0.00..1,780.84 rows=1 width=16) (actual time=8.205..9.394 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,265
9. 0.010 0.010 ↑ 1.0 1 1

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

  • Output: projectstatuslabel3.id, projectstatuslabel3.name, projectstatuslabel3.description, projectstatuslabel3.projectstatustype, projectstatuslabel3.enabled
  • Filter: (projectstatuslabel3.projectstatustype = 1)
  • Rows Removed by Filter: 6
10. 1.594 1.594 ↓ 1.0 1,725 1

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".project p (cost=0.00..120.98 rows=1,698 width=66) (actual time=0.003..1.594 rows=1,725 loops=1)

  • Output: p.id, p.name, p.slug, p.code, p.programid
11.          

SubPlan (for Nested Loop)

12. 5.175 5.175 ↑ 1.0 1 1,725

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

  • Output: project2.projectstatuslabelid
  • Index Cond: (project2.id = p.id)
13. 4.317 12.951 ↑ 1.0 2 1,439

Append (cost=0.28..0.60 rows=2 width=8) (actual time=0.004..0.009 rows=2 loops=1,439)

14. 5.756 5.756 ↑ 1.0 1 1,439

Index Only Scan using uix4pc_projectclienteffectiveend on "17f7a637b83349e9b16ef4905eb64944".projectclient (cost=0.28..0.30 rows=1 width=8) (actual time=0.003..0.004 rows=1 loops=1,439)

  • Output: projectclient.projectid, projectclient.clientid
  • Index Cond: (projectclient.projectid = p.id)
  • Heap Fetches: 1,172
15. 2.878 2.878 ↑ 1.0 1 1,439

Index Only Scan using project_pkey on "17f7a637b83349e9b16ef4905eb64944".project project_1 (cost=0.28..0.30 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=1,439)

  • Output: project_1.id, NULL::integer
  • Index Cond: (project_1.id = p.id)
  • Heap Fetches: 724
16. 5.752 5.752 ↓ 0.0 0 2,876

Index Scan using clients_pkey on "17f7a637b83349e9b16ef4905eb64944".clients c (cost=0.27..0.29 rows=1 width=56) (actual time=0.002..0.002 rows=0 loops=2,876)

  • Output: c.id, c.name, c.slug, c.code, c.comments, c.clientmanageruserid, c.disabled, c.address, c.city, c.stateprovince, c.zippostalcode, c.country, c.email, c.telephone, c.fax, c.website, c.billingcontact, c.billingaddress, c.bil (...)
  • Index Cond: (c.id = projectclient.clientid)
17.          

SubPlan (for Nested Loop Left Join)

18. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uix4pc_projectclienteffectiveend on "17f7a637b83349e9b16ef4905eb64944".projectclient projectclient1 (cost=0.28..1.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
19. 0.837 0.837 ↓ 1.0 1,719 1

Index Only Scan using uix4pc_projectclienteffectiveend on "17f7a637b83349e9b16ef4905eb64944".projectclient projectclient1_1 (cost=0.28..44.12 rows=1,692 width=4) (actual time=0.020..0.837 rows=1,719 loops=1)

  • Output: projectclient1_1.projectid
  • Index Cond: ((projectclient1_1.effectivedate <= '2019-09-30'::date) AND (projectclient1_1.enddate >= '2019-09-22'::date))
  • Heap Fetches: 1,390
20. 2.874 2.874 ↑ 1.0 1 1,437

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

  • 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,173
21. 154.080 43,058.880 ↓ 1.7 181 1,440

Append (cost=0.42..56,678.99 rows=109 width=34) (actual time=1.902..29.902 rows=181 loops=1,440)

22. 1,426.304 42,886.080 ↓ 1.7 181 1,440

Index Scan using ixtkprojectid on "17f7a637b83349e9b16ef4905eb64944".task (cost=0.42..56,417.53 rows=108 width=34) (actual time=1.894..29.782 rows=181 loops=1,440)

  • 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
23.          

SubPlan (for Index Scan)

24. 4.320 4.320 ↑ 1.0 1 1,440

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,440)

  • Output: project4.istimeentryallowed
  • Index Cond: (project4.id = p.id)
25. 6.001 6.048 ↓ 0.0 0 864

Index Scan using uix2ptm_projectemptypegrp on "17f7a637b83349e9b16ef4905eb64944".projectteammember projectteammember5 (cost=47.04..198.35 rows=319 width=0) (actual time=0.007..0.007 rows=0 loops=864)

  • 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
26.          

SubPlan (for Index Scan)

27. 0.003 0.014 ↑ 1.0 2 1

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

  • Output: departmentflathierarchy6.parentid
28. 0.006 0.006 ↑ 1.0 1 1

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

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

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

  • Output: departmentflathierarchy6.parentid, departmentflathierarchy6.childid, departmentflathierarchy6.depth
  • Index Cond: (departmentflathierarchy6.childid = departmentusers7.departmentid)
30. 0.003 0.015 ↑ 1.0 1 1

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

  • Output: locationflathierarchy8.parentid
31. 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.006..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
32. 0.006 0.006 ↑ 2.0 1 1

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

  • Output: locationflathierarchy8.parentid, locationflathierarchy8.childid, locationflathierarchy8.parentdepth
  • Index Cond: (locationflathierarchy8.childid = userlocation9.locationid)
33. 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
34. 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
35. 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)
36. 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
37. 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
38. 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)
39. 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: servicecenterflathierarchy14.parentid
40. 0.001 0.001 ↓ 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.001..0.001 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
41. 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)
42. 0.007 0.009 ↓ 0.0 0 1

Nested Loop (cost=0.15..3.20 rows=1 width=16) (actual time=0.009..0.009 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 (...)
43. 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
44. 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: ployeetypegroupflathierarchy18.parentid
  • -> Index Only Scan using ix4ucc_useremployeetypegroupstartend on "17f7a637b83349e9b16ef4905eb64944".useremployeetypegroup useremployeetypegroup19 (cost=0.15..2.24 rows=1 width=16) (actual time=0.001..0.001 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
45. 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)
46. 0.000 0.000 ↓ 0.0 0

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".projectteammember projectteammember5_1 (cost=46.61..17,348.71 rows=459,554 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))
47.          

SubPlan (for Seq Scan)

48. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

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

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

  • Output: departmentgroupflathierarchy16_1.parentid
64. 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
65. 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
66. 0.000 0.000 ↓ 0.0 0

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

  • Output: ployeetypegroupflathierarchy18_1.parentid
67. 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
68. 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)
69. 615.064 41,449.408 ↑ 1.0 1 289,856

Nested Loop (cost=54.80..211.35 rows=1 width=0) (actual time=0.143..0.143 rows=1 loops=289,856)

70.          

Initplan (for Nested Loop)

71. 0.078 0.078 ↓ 0.0 0 1

Index Scan using ixtspss2key on "17f7a637b83349e9b16ef4905eb64944".timesheetpolicysettingssnapshot esheetpolicysettingssnapshot37 (cost=0.68..4.74 rows=1 width=0) (actual time=0.078..0.078 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)
72. 1,050.896 40,000.128 ↑ 1.0 1 289,856

Hash Join (cost=49.64..204.16 rows=1 width=4) (actual time=0.131..0.138 rows=1 loops=289,856)

  • Output: taskteammemberassignment21.taskid
  • Hash Cond: (projectteammember20.id = taskteammemberassignment21.projectteammemberid)
73. 34,021.619 34,021.680 ↑ 319.0 1 283,514

Index Scan using uix2ptm_projectemptypegrp on "17f7a637b83349e9b16ef4905eb64944".projectteammember projectteammember20 (cost=47.04..198.35 rows=319 width=16) (actual time=0.087..0.120 rows=1 loops=283,514)

  • 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
74.          

SubPlan (for Index Scan)

75. 0.006 0.013 ↑ 1.0 2 1

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

  • Output: departmentflathierarchy23.parentid
76. 0.004 0.004 ↑ 1.0 1 1

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

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

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

  • Output: departmentflathierarchy23.parentid, departmentflathierarchy23.childid, departmentflathierarchy23.depth
  • Index Cond: (departmentflathierarchy23.childid = departmentusers24.departmentid)
78. 0.003 0.027 ↑ 1.0 1 1

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

  • Output: locationflathierarchy25.parentid
79. 0.018 0.018 ↑ 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.018 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
80. 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)
81. 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: divisionflathierarchy27.parentid
82. 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
83. 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)
84. 0.000 0.002 ↓ 0.0 0 1

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

  • Output: costcenterflathierarchy29.parentid
85. 0.002 0.002 ↓ 0.0 0 1

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

  • Output: usercostcenter30.userid, usercostcenter30.costcenterid, usercostcenter30.startdate, usercostcenter30.enddate
  • Index Cond: ((usercostcenter30.userid = 376) AND (usercostcenter30.startdate <= '2019-09-30'::date) AND (usercostcenter30.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
86. 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)
87. 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.001..0.001 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
88. 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)
89. 0.007 0.013 ↓ 0.0 0 1

Nested Loop (cost=0.15..3.20 rows=1 width=16) (actual time=0.013..0.013 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 (...)
90. 0.006 0.006 ↑ 1.0 1 1

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".departmentgroupflathierarchy departmentgroupflathierarchy33 (cost=0.00..1.01 rows=1 width=32) (actual time=0.006..0.006 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
91. 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.001.. (...)
  • 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
92. 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)
93. 4,927.552 4,927.552 ↑ 2.0 3 289,856

Hash (cost=2.53..2.53 rows=6 width=20) (actual time=0.017..0.017 rows=3 loops=289,856)

  • 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.010..0.0 (...)
  • Output: taskteammemberassignment21.projectteammemberid, taskteammemberassignment21.taskid
  • Index Cond: (taskteammemberassignment21.taskid = task.id)
  • Heap Fetches: 18,571
94. 834.138 834.138 ↑ 1.0 1 278,046

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,046)

  • 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
95. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=37,728.31..75,904.37 rows=798,347 width=8) (never executed)

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

Initplan (for Hash Join)

97. 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)
98. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=14,630.43..41,805.67 rows=804,629 width=20) (never executed)

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

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".taskteammemberassignment taskteammemberassignment21_1 (cost=0.00..15,880.78 rows=866,178 width=20) (never executed)

  • Output: taskteammemberassignment21_1.id, taskteammemberassignment21_1.taskid, taskteammemberassignment21_1.projectteammemberid, taskteammemberassignment21_1.taskallocationstartdate, taskteammemberassignment21_1 (...)
100. 0.000 0.000 ↓ 0.0 0

Hash (cost=10,380.73..10,380.73 rows=339,976 width=4) (never executed)

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

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".task task22_1 (cost=0.00..10,380.73 rows=339,976 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))))
102. 0.000 0.000 ↓ 0.0 0

Hash (cost=17,348.71..17,348.71 rows=459,554 width=20) (never executed)

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

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".projectteammember projectteammember20_1 (cost=46.61..17,348.71 rows=459,554 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))
104.          

SubPlan (for Seq Scan)

105. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

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

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

  • Output: departmentgroupflathierarchy33_1.parentid
121. 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
122. 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
123. 0.000 0.000 ↓ 0.0 0

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

  • Output: ployeetypegroupflathierarchy35_1.parentid
124. 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
125. 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)
126. 0.000 18.720 ↓ 0.0 0 1,440

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

  • 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: 725
127.          

SubPlan (for Index Only Scan)

128. 4.320 4.320 ↑ 1.0 1 1,440

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,440)

  • Output: project4.istimeentryallowed
  • Index Cond: (project4.id = p.id)
129. 6.001 6.048 ↓ 0.0 0 864

Index Scan using uix2ptm_projectemptypegrp on "17f7a637b83349e9b16ef4905eb64944".projectteammember projectteammember5 (cost=47.04..198.35 rows=319 width=0) (actual time=0.007..0.007 rows=0 loops=864)

  • 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
130.          

SubPlan (for Index Scan)

131. 0.003 0.014 ↑ 1.0 2 1

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

  • Output: departmentflathierarchy6.parentid
132. 0.006 0.006 ↑ 1.0 1 1

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

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

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

  • Output: departmentflathierarchy6.parentid, departmentflathierarchy6.childid, departmentflathierarchy6.depth
  • Index Cond: (departmentflathierarchy6.childid = departmentusers7.departmentid)
134. 0.003 0.015 ↑ 1.0 1 1

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

  • Output: locationflathierarchy8.parentid
135. 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.006..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
136. 0.006 0.006 ↑ 2.0 1 1

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

  • Output: locationflathierarchy8.parentid, locationflathierarchy8.childid, locationflathierarchy8.parentdepth
  • Index Cond: (locationflathierarchy8.childid = userlocation9.locationid)
137. 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
138. 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
139. 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)
140. 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
141. 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
142. 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)
143. 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: servicecenterflathierarchy14.parentid
144. 0.001 0.001 ↓ 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.001..0.001 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
145. 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)
146. 0.007 0.009 ↓ 0.0 0 1

Nested Loop (cost=0.15..3.20 rows=1 width=16) (actual time=0.009..0.009 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 (...)
147. 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
148. 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: ployeetypegroupflathierarchy18.parentid
  • -> Index Only Scan using ix4ucc_useremployeetypegroupstartend on "17f7a637b83349e9b16ef4905eb64944".useremployeetypegroup useremployeetypegroup19 (cost=0.15..2.24 rows=1 width=16) (actual time=0.001..0.001 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
149. 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)
150. 0.000 0.000 ↓ 0.0 0

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".projectteammember projectteammember5_1 (cost=46.61..17,348.71 rows=459,554 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))
151.          

SubPlan (for Seq Scan)

152. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

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

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

  • Output: departmentgroupflathierarchy16_1.parentid
168. 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
169. 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
170. 0.000 0.000 ↓ 0.0 0

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

  • Output: ployeetypegroupflathierarchy18_1.parentid
171. 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
172. 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)
173. 615.064 41,449.408 ↑ 1.0 1 289,856

Nested Loop (cost=54.80..211.35 rows=1 width=0) (actual time=0.143..0.143 rows=1 loops=289,856)

174.          

Initplan (for Nested Loop)

175. 0.078 0.078 ↓ 0.0 0 1

Index Scan using ixtspss2key on "17f7a637b83349e9b16ef4905eb64944".timesheetpolicysettingssnapshot esheetpolicysettingssnapshot37 (cost=0.68..4.74 rows=1 width=0) (actual time=0.078..0.078 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)
176. 1,050.896 40,000.128 ↑ 1.0 1 289,856

Hash Join (cost=49.64..204.16 rows=1 width=4) (actual time=0.131..0.138 rows=1 loops=289,856)

  • Output: taskteammemberassignment21.taskid
  • Hash Cond: (projectteammember20.id = taskteammemberassignment21.projectteammemberid)
177. 34,021.619 34,021.680 ↑ 319.0 1 283,514

Index Scan using uix2ptm_projectemptypegrp on "17f7a637b83349e9b16ef4905eb64944".projectteammember projectteammember20 (cost=47.04..198.35 rows=319 width=16) (actual time=0.087..0.120 rows=1 loops=283,514)

  • 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
178.          

SubPlan (for Index Scan)

179. 0.006 0.013 ↑ 1.0 2 1

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

  • Output: departmentflathierarchy23.parentid
180. 0.004 0.004 ↑ 1.0 1 1

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

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

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

  • Output: departmentflathierarchy23.parentid, departmentflathierarchy23.childid, departmentflathierarchy23.depth
  • Index Cond: (departmentflathierarchy23.childid = departmentusers24.departmentid)
182. 0.003 0.027 ↑ 1.0 1 1

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

  • Output: locationflathierarchy25.parentid
183. 0.018 0.018 ↑ 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.018 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
184. 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)
185. 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: divisionflathierarchy27.parentid
186. 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
187. 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)
188. 0.000 0.002 ↓ 0.0 0 1

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

  • Output: costcenterflathierarchy29.parentid
189. 0.002 0.002 ↓ 0.0 0 1

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

  • Output: usercostcenter30.userid, usercostcenter30.costcenterid, usercostcenter30.startdate, usercostcenter30.enddate
  • Index Cond: ((usercostcenter30.userid = 376) AND (usercostcenter30.startdate <= '2019-09-30'::date) AND (usercostcenter30.enddate >= '2019-09-22'::date))
  • Heap Fetches: 0
190. 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)
191. 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.001..0.001 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
192. 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)
193. 0.007 0.013 ↓ 0.0 0 1

Nested Loop (cost=0.15..3.20 rows=1 width=16) (actual time=0.013..0.013 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 (...)
194. 0.006 0.006 ↑ 1.0 1 1

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".departmentgroupflathierarchy departmentgroupflathierarchy33 (cost=0.00..1.01 rows=1 width=32) (actual time=0.006..0.006 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
195. 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.001.. (...)
  • 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
196. 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)
197. 4,927.552 4,927.552 ↑ 2.0 3 289,856

Hash (cost=2.53..2.53 rows=6 width=20) (actual time=0.017..0.017 rows=3 loops=289,856)

  • 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.010..0.0 (...)
  • Output: taskteammemberassignment21.projectteammemberid, taskteammemberassignment21.taskid
  • Index Cond: (taskteammemberassignment21.taskid = (NULL::integer))
  • Heap Fetches: 18,571
198. 834.138 834.138 ↑ 1.0 1 278,046

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,046)

  • 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
199. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=37,728.31..75,904.37 rows=798,347 width=8) (never executed)

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

Initplan (for Hash Join)

201. 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)
202. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=14,630.43..41,805.67 rows=804,629 width=20) (never executed)

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

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".taskteammemberassignment taskteammemberassignment21_1 (cost=0.00..15,880.78 rows=866,178 width=20) (never executed)

  • Output: taskteammemberassignment21_1.id, taskteammemberassignment21_1.taskid, taskteammemberassignment21_1.projectteammemberid, taskteammemberassignment21_1.taskallocationstartdate, taskteammemberassignment21_1 (...)
204. 0.000 0.000 ↓ 0.0 0

Hash (cost=10,380.73..10,380.73 rows=339,976 width=4) (never executed)

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

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".task task22_1 (cost=0.00..10,380.73 rows=339,976 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))))
206. 0.000 0.000 ↓ 0.0 0

Hash (cost=17,348.71..17,348.71 rows=459,554 width=20) (never executed)

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

Seq Scan on "17f7a637b83349e9b16ef4905eb64944".projectteammember projectteammember20_1 (cost=46.61..17,348.71 rows=459,554 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))
208.          

SubPlan (for Seq Scan)

209. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

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

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

  • Output: departmentgroupflathierarchy33_1.parentid
225. 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
226. 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
227. 0.000 0.000 ↓ 0.0 0

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

  • Output: ployeetypegroupflathierarchy35_1.parentid
228. 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
229. 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)