explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 88Ab

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.921 ↑ 2.0 2 1

Unique (cost=117,559.64..117,559.66 rows=4 width=22) (actual time=0.919..0.921 rows=2 loops=1)

2. 0.021 0.918 ↓ 2.2 9 1

Sort (cost=117,559.64..117,559.65 rows=4 width=22) (actual time=0.918..0.918 rows=9 loops=1)

  • Sort Key: this_.domainobject
  • Sort Method: quicksort Memory: 25kB
3. 0.035 0.897 ↓ 2.2 9 1

Bitmap Heap Scan on security_control this_ (cost=17.22..117,559.60 rows=4 width=22) (actual time=0.565..0.897 rows=9 loops=1)

  • Recheck Cond: ((((domainobject)::text = 'PositionStructureItem'::text) AND ((action)::text = 'Update'::text)) OR (((domainobject)::text = 'PositionStructureItem'::text) AND ((action)::text = 'Update'::text)) OR (((domainobject)::text = 'PositionsList'::text) AND ((action)::text = 'Update'::text)) OR (((domainobject)::text = 'PositionsList'::text) AND ((action)::text = 'Update'::text)))
  • Filter: (((SubPlan 1) OR (SubPlan 6)) AND ((NOT (SubPlan 7)) OR (NOT (SubPlan 12))))
  • Heap Blocks: exact=1
4. 0.002 0.043 ↓ 0.0 0 1

BitmapOr (cost=17.22..17.22 rows=7 width=0) (actual time=0.042..0.043 rows=0 loops=1)

5. 0.024 0.024 ↓ 4.0 4 1

Bitmap Index Scan on idx_sc_do_act (cost=0.00..4.29 rows=1 width=0) (actual time=0.024..0.024 rows=4 loops=1)

  • Index Cond: (((domainobject)::text = 'PositionStructureItem'::text) AND ((action)::text = 'Update'::text))
6. 0.006 0.006 ↓ 4.0 4 1

Bitmap Index Scan on idx_sc_do_act (cost=0.00..4.29 rows=1 width=0) (actual time=0.006..0.006 rows=4 loops=1)

  • Index Cond: (((domainobject)::text = 'PositionStructureItem'::text) AND ((action)::text = 'Update'::text))
7. 0.006 0.006 ↓ 1.7 5 1

Bitmap Index Scan on idx_sc_do_act (cost=0.00..4.32 rows=3 width=0) (actual time=0.006..0.006 rows=5 loops=1)

  • Index Cond: (((domainobject)::text = 'PositionsList'::text) AND ((action)::text = 'Update'::text))
8. 0.005 0.005 ↓ 1.7 5 1

Bitmap Index Scan on idx_sc_do_act (cost=0.00..4.32 rows=3 width=0) (actual time=0.005..0.005 rows=5 loops=1)

  • Index Cond: (((domainobject)::text = 'PositionsList'::text) AND ((action)::text = 'Update'::text))
9.          

SubPlan (forBitmap Heap Scan)

10. 0.009 0.495 ↑ 3.0 1 9

Nested Loop Semi Join (cost=35.01..82.79 rows=3 width=0) (actual time=0.055..0.055 rows=1 loops=9)

  • Join Filter: (ar.rolename = "*SELECT* 1".rolename)
  • Rows Removed by Join Filter: 1
11. 0.011 0.189 ↑ 4.0 1 9

HashAggregate (cost=34.45..34.49 rows=4 width=168) (actual time=0.021..0.021 rows=1 loops=9)

  • Group Key: ar.personid, ar.personid, ar.rolename, (''::text)
12. 0.001 0.178 ↑ 1.3 3 1

Append (cost=0.00..34.41 rows=4 width=168) (actual time=0.014..0.178 rows=3 loops=1)

13. 0.037 0.037 ↑ 1.0 2 1

Seq Scan on assigned_roles ar (cost=0.00..4.78 rows=2 width=67) (actual time=0.014..0.037 rows=2 loops=1)

  • Filter: (personid = '25992'::bpchar)
  • Rows Removed by Filter: 220
14. 0.003 0.092 ↑ 1.0 1 1

Nested Loop (cost=0.83..16.88 rows=1 width=90) (actual time=0.091..0.092 rows=1 loops=1)

15. 0.076 0.076 ↑ 1.0 1 1

Index Only Scan using person_pkey on person p (cost=0.42..8.44 rows=1 width=13) (actual time=0.076..0.076 rows=1 loops=1)

  • Index Cond: (personid = '25992'::bpchar)
  • Heap Fetches: 1
16. 0.013 0.013 ↑ 1.0 1 1

Index Only Scan using person_pkey on person p2 (cost=0.42..8.44 rows=1 width=13) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: (personid = '25992'::bpchar)
  • Heap Fetches: 1
17. 0.002 0.048 ↓ 0.0 0 1

Nested Loop Semi Join (cost=3.51..12.71 rows=1 width=94) (actual time=0.048..0.048 rows=0 loops=1)

18. 0.013 0.013 ↑ 1.0 1 1

Index Only Scan using person_pkey on person p_1 (cost=0.42..8.44 rows=1 width=13) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: (personid = '25992'::bpchar)
  • Heap Fetches: 1
19. 0.013 0.033 ↓ 0.0 0 1

Hash Join (cost=3.09..4.27 rows=1 width=13) (actual time=0.033..0.033 rows=0 loops=1)

  • Hash Cond: (pcrt.personcustomerreltype = pcr.personcustomerreltype)
20. 0.005 0.005 ↑ 12.0 1 1

Seq Scan on person_customer_rel_type pcrt (cost=0.00..1.12 rows=12 width=24) (actual time=0.005..0.005 rows=1 loops=1)

  • Filter: (rolename IS NOT NULL)
21. 0.000 0.015 ↓ 0.0 0 1

Hash (cost=3.08..3.08 rows=1 width=19) (actual time=0.015..0.015 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
22. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on person_customer_rel pcr (cost=0.00..3.08 rows=1 width=19) (actual time=0.015..0.015 rows=0 loops=1)

  • Filter: ((personid = '25992'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 64
23. 0.009 0.297 ↑ 1.5 2 9

Materialize (cost=0.56..48.09 rows=3 width=9) (actual time=0.032..0.033 rows=2 loops=9)

24. 0.009 0.288 ↑ 1.5 2 9

Append (cost=0.56..48.08 rows=3 width=9) (actual time=0.031..0.032 rows=2 loops=9)

25. 0.000 0.063 ↓ 0.0 0 9

Subquery Scan on *SELECT* 1 (cost=0.56..19.88 rows=1 width=9) (actual time=0.007..0.007 rows=0 loops=9)

26. 0.009 0.063 ↓ 0.0 0 9

Nested Loop Anti Join (cost=0.56..19.87 rows=1 width=261) (actual time=0.007..0.007 rows=0 loops=9)

  • Join Filter: (((sc1.action)::text = (sc3.action)::text) AND ((sc3.domainobject)::text = (sc1.domainobject)::text) AND (sc3.rolename = sc1.rolename))
27. 0.054 0.054 ↓ 0.0 0 9

Index Scan using pk_company_security_control on company_security_control sc1 (cost=0.28..8.34 rows=1 width=32) (actual time=0.006..0.006 rows=0 loops=9)

  • Index Cond: (((domainobject)::text = (this_.domainobject)::text) AND ((action)::text = (this_.action)::text) AND (companyid = 51786))
  • Filter: (NOT negative)
28. 0.000 0.000 ↓ 0.0 0

Index Only Scan using security_control_pkey1 on security_control sc3 (cost=0.29..11.50 rows=2 width=31) (never executed)

  • Index Cond: ((domainobject = (this_.domainobject)::text) AND (action = (this_.action)::text))
  • Heap Fetches: 0
29. 0.000 0.216 ↑ 1.0 2 9

Subquery Scan on *SELECT* 2 (cost=0.84..28.20 rows=2 width=9) (actual time=0.023..0.024 rows=2 loops=9)

30. 0.007 0.216 ↑ 1.0 2 9

Nested Loop Anti Join (cost=0.84..28.18 rows=2 width=261) (actual time=0.023..0.024 rows=2 loops=9)

  • Join Filter: ((sc3_1.companyid = c.companyid) AND ((sc3_1.domainobject)::text = (sc2.domainobject)::text) AND ((sc3_1.action)::text = (sc2.action)::text) AND (sc3_1.rolename = sc2.rolename))
31. 0.013 0.153 ↑ 1.0 2 9

Nested Loop (cost=0.57..19.83 rows=2 width=35) (actual time=0.017..0.017 rows=2 loops=9)

32. 0.126 0.126 ↑ 1.0 2 9

Index Only Scan using security_control_pkey1 on security_control sc2 (cost=0.29..11.50 rows=2 width=31) (actual time=0.014..0.014 rows=2 loops=9)

  • Index Cond: ((domainobject = (this_.domainobject)::text) AND (action = (this_.action)::text))
  • Heap Fetches: 14
33. 0.003 0.014 ↑ 1.0 1 14

Materialize (cost=0.28..8.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=14)

34. 0.011 0.011 ↑ 1.0 1 1

Index Only Scan using company_pkey on company c (cost=0.28..8.30 rows=1 width=4) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: (companyid = 51786)
  • Heap Fetches: 1
35. 0.011 0.056 ↓ 0.0 0 14

Materialize (cost=0.28..8.31 rows=1 width=36) (actual time=0.004..0.004 rows=0 loops=14)

36. 0.045 0.045 ↓ 0.0 0 9

Index Scan using idx_csc_neg_do_act on company_security_control sc3_1 (cost=0.28..8.30 rows=1 width=36) (actual time=0.005..0.005 rows=0 loops=9)

  • Index Cond: ((negative = true) AND ((domainobject)::text = (this_.domainobject)::text) AND ((action)::text = (this_.action)::text) AND (companyid = 51786))
  • Filter: negative
37. 0.000 0.000 ↓ 0.0 0

Hash Semi Join (cost=8,339.15..8,339.70 rows=3 width=0) (never executed)

  • Hash Cond: (u.rolename = "*SELECT* 1_1".rolename)
38. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=8,291.03..8,291.26 rows=23 width=120) (never executed)

  • Group Key: u.personid, pos.positionid, u.rolename, (''::text)
39. 0.000 0.000 ↓ 0.0 0

Append (cost=0.29..8,290.80 rows=23 width=120) (never executed)

40. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.29..13.65 rows=1 width=58) (never executed)

41. 0.000 0.000 ↓ 0.0 0

Seq Scan on assigned_roles u (cost=0.00..5.33 rows=1 width=22) (never executed)

  • Filter: ((rolename = 'HRAdmin'::bpchar) AND (personid = '25992'::bpchar))
42. 0.000 0.000 ↓ 0.0 0

Index Only Scan using position_pkey on "position" pos (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Index Cond: (positionid = 13973)
  • Heap Fetches: 0
43. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..18.89 rows=1 width=58) (never executed)

44. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..18.08 rows=1 width=53) (never executed)

  • Join Filter: (pcr_1.personcompanyreltype = pcrt_1.personcompanyreltype)
45. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..16.65 rows=1 width=23) (never executed)

  • Join Filter: (pcr_1.companyid = pd.companyid)
46. 0.000 0.000 ↓ 0.0 0

Index Scan using person_company_rel_pkey on person_company_rel pcr_1 (cost=0.28..8.32 rows=1 width=23) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
47. 0.000 0.000 ↓ 0.0 0

Index Scan using position_desc_pkey on position_desc pd (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: (positionid = 13973)
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
48. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_company_rel_type pcrt_1 (cost=0.00..1.19 rows=19 width=60) (never executed)

49. 0.000 0.000 ↓ 0.0 0

Index Only Scan using web_role_pkey on web_role wr (cost=0.14..0.79 rows=1 width=9) (never executed)

  • Index Cond: (rolename = pcrt_1.rolename)
  • Heap Fetches: 0
50. 0.000 0.000 ↓ 0.0 0

Subquery Scan on r_positionlocationroles (cost=69.07..69.11 rows=2 width=124) (never executed)

51. 0.000 0.000 ↓ 0.0 0

Unique (cost=69.07..69.09 rows=2 width=176) (never executed)

52. 0.000 0.000 ↓ 0.0 0

Sort (cost=69.07..69.07 rows=2 width=176) (never executed)

  • Sort Key: plr.personid, pl.positionid, wr_1.rolename, ('RoleEx_GenPosLocR '::character(20))
53. 0.000 0.000 ↓ 0.0 0

Append (cost=1.70..69.06 rows=2 width=176) (never executed)

54. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.70..48.76 rows=1 width=110) (never executed)

  • Join Filter: (plr.personlocationreltype = plrt.personlocationreltype)
55. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..45.61 rows=1 width=26) (never executed)

56. 0.000 0.000 ↓ 0.0 0

Index Scan using position_location_pkey on position_location pl (cost=0.29..37.29 rows=1 width=8) (never executed)

  • Index Cond: (positionid = 13973)
  • Filter: ((effectivedate <= enddate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts) AND ((NOT (alternatives: SubPlan 2 or hashed SubPlan 3)) OR (alternatives: SubPlan 4 or hashed SubPlan 5)))
57.          

SubPlan (forIndex Scan)

58. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp (cost=0.29..8.33 rows=1 width=0) (never executed)

  • Index Cond: ((positionid = pl.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
59. 0.000 0.000 ↓ 0.0 0

Seq Scan on pers_pos pp_1 (cost=0.00..1,773.86 rows=6,979 width=4) (never executed)

  • Filter: ((effectivedate <= enddate) AND (persposrel = 'Occupies'::bpchar) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
60. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..20.64 rows=1 width=0) (never executed)

61. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_2 (cost=0.29..8.33 rows=1 width=13) (never executed)

  • Index Cond: ((positionid = pl.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
62. 0.000 0.000 ↓ 0.0 0

Index Scan using personemploymentenddate on person_employment pe (cost=0.42..12.30 rows=1 width=13) (never executed)

  • Index Cond: ((personid = pp_2.personid) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (createts = endts))
63. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.41..2,670.12 rows=22 width=4) (never executed)

64. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_employment pe_1 (cost=0.00..2,116.82 rows=72 width=13) (never executed)

  • Filter: ((effectivedate <= enddate) AND (createts = endts) AND (CURRENT_DATE <= enddate))
65. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pos_pkey on pers_pos pp_3 (cost=0.41..7.67 rows=1 width=17) (never executed)

  • Index Cond: (personid = pe_1.personid)
  • Filter: ((effectivedate <= enddate) AND (persposrel = 'Occupies'::bpchar) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
66. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_person_location_rel on person_location_rel plr (cost=0.28..8.31 rows=1 width=26) (never executed)

  • Index Cond: ((personid = '25992'::bpchar) AND (locationid = pl.locationid))
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
67. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1.14..3.08 rows=6 width=45) (never executed)

  • Hash Cond: (wr_1.rolename = plrt.rolename)
68. 0.000 0.000 ↓ 0.0 0

Seq Scan on web_role wr_1 (cost=0.00..1.64 rows=64 width=9) (never executed)

69. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.06..1.06 rows=6 width=72) (never executed)

70. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_location_rel_type plrt (cost=0.00..1.06 rows=6 width=72) (never executed)

71. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.12..20.27 rows=1 width=110) (never executed)

  • Join Filter: (plrt_1.personlocationreltype = plr_1.personlocationreltype)
72. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.98..17.12 rows=1 width=26) (never executed)

73. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..16.79 rows=1 width=8) (never executed)

74. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_4 (cost=0.29..8.33 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = 13973) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
75. 0.000 0.000 ↓ 0.0 0

Index Scan using person_locations_pkey on person_locations lp (cost=0.41..8.45 rows=1 width=17) (never executed)

  • Index Cond: (personid = pp_4.personid)
  • Filter: ((effectivedate <= enddate) AND (personlocationtype = 'P'::bpchar) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
76. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_person_location_rel on person_location_rel plr_1 (cost=0.28..0.32 rows=1 width=26) (never executed)

  • Index Cond: ((personid = '25992'::bpchar) AND (locationid = lp.locationid))
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
77. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1.14..3.08 rows=6 width=45) (never executed)

  • Hash Cond: (wr_2.rolename = plrt_1.rolename)
78. 0.000 0.000 ↓ 0.0 0

Seq Scan on web_role wr_2 (cost=0.00..1.64 rows=64 width=9) (never executed)

79. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.06..1.06 rows=6 width=72) (never executed)

80. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_location_rel_type plrt_1 (cost=0.00..1.06 rows=6 width=72) (never executed)

81. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=4.99..26.49 rows=1 width=85) (never executed)

82. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=4.70..18.16 rows=1 width=53) (never executed)

83. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=4.29..9.69 rows=1 width=53) (never executed)

  • Join Filter: (port.personorganizationreltype = po.personorganizationreltype)
84. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on person_organization_rel po (cost=4.29..8.56 rows=1 width=22) (never executed)

  • Recheck Cond: (personid = '25992'::bpchar)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
85. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on person_organization_rel_pkey (cost=0.00..4.29 rows=2 width=0) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
86. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_organization_rel_type port (cost=0.00..1.06 rows=6 width=56) (never executed)

  • Filter: (rolename IS NOT NULL)
87. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_org_rel_pkey on pos_org_rel op (cost=0.41..8.45 rows=1 width=8) (never executed)

  • Index Cond: ((organizationid = po.organizationid) AND (positionid = 13973))
  • Filter: ((effectivedate <= enddate) AND (posorgreltype = 'Member'::bpchar) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
88. 0.000 0.000 ↓ 0.0 0

Index Scan using position_desc_pkey on position_desc pd_1 (cost=0.29..8.32 rows=1 width=4) (never executed)

  • Index Cond: (positionid = 13973)
  • Filter: ((effectivedate <= enddate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
89. 0.000 0.000 ↓ 0.0 0

Result (cost=2.27..46.01 rows=2 width=58) (never executed)

90. 0.000 0.000 ↓ 0.0 0

Append (cost=2.27..45.99 rows=2 width=26) (never executed)

91. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1_2 (cost=2.27..20.46 rows=1 width=26) (never executed)

92. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.27..20.45 rows=1 width=110) (never executed)

  • Join Filter: ((ppurt.personpayunitreltype)::text = (pp_5.personpayunitreltype)::text)
93. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.14..17.30 rows=1 width=23) (never executed)

  • Join Filter: (pu.payunitid = pp_5.payunitid)
94. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.86..16.97 rows=1 width=12) (never executed)

95. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.67 rows=1 width=8) (never executed)

96. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos persp (cost=0.29..8.33 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = 13973) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
97. 0.000 0.000 ↓ 0.0 0

Index Scan using person_payroll_pkey on person_payroll ep (cost=0.29..8.33 rows=1 width=17) (never executed)

  • Index Cond: (personid = persp.personid)
  • Filter: ((payunitrelationship = 'M'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
98. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pay_unit_pkey on pay_unit pu (cost=0.28..0.30 rows=1 width=4) (never executed)

  • Index Cond: (payunitid = ep.payunitid)
  • Heap Fetches: 0
99. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_person_pay_unit_rel on person_pay_unit_rel pp_5 (cost=0.28..0.32 rows=1 width=23) (never executed)

  • Index Cond: ((personid = '25992'::bpchar) AND (payunitid = ep.payunitid))
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
100. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1.14..3.08 rows=6 width=43) (never executed)

  • Hash Cond: (wr_3.rolename = ppurt.rolename)
101. 0.000 0.000 ↓ 0.0 0

Seq Scan on web_role wr_3 (cost=0.00..1.64 rows=64 width=9) (never executed)

102. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.06..1.06 rows=6 width=70) (never executed)

103. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_pay_unit_rel_type ppurt (cost=0.00..1.06 rows=6 width=70) (never executed)

104. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2_2 (cost=5.99..25.53 rows=1 width=26) (never executed)

105. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=5.99..25.52 rows=1 width=110) (never executed)

  • Join Filter: ((ppurt_1.personpayunitreltype)::text = (pp_6.personpayunitreltype)::text)
106. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=4.86..22.37 rows=1 width=23) (never executed)

107. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=4.57..17.66 rows=1 width=23) (never executed)

108. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on person_pay_unit_rel pp_6 (cost=4.29..9.36 rows=1 width=23) (never executed)

  • Recheck Cond: (personid = '25992'::bpchar)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
109. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on pk_person_pay_unit_rel (cost=0.00..4.29 rows=2 width=0) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
110. 0.000 0.000 ↓ 0.0 0

Index Scan using pay_unit_pkey on pay_unit pu_1 (cost=0.28..8.29 rows=1 width=8) (never executed)

  • Index Cond: (payunitid = pp_6.payunitid)
111. 0.000 0.000 ↓ 0.0 0

Index Scan using positioncompany on position_desc pd_2 (cost=0.29..4.70 rows=1 width=8) (never executed)

  • Index Cond: ((companyid = pu_1.companyid) AND (positionid = 13973))
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
112. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1.14..3.08 rows=6 width=43) (never executed)

  • Hash Cond: (wr_4.rolename = ppurt_1.companyrolename)
113. 0.000 0.000 ↓ 0.0 0

Seq Scan on web_role wr_4 (cost=0.00..1.64 rows=64 width=9) (never executed)

114. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.06..1.06 rows=6 width=70) (never executed)

115. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_pay_unit_rel_type ppurt_1 (cost=0.00..1.06 rows=6 width=70) (never executed)

116. 0.000 0.000 ↓ 0.0 0

Result (cost=0.58..94.68 rows=6 width=85) (never executed)

117. 0.000 0.000 ↓ 0.0 0

Append (cost=0.58..94.62 rows=6 width=53) (never executed)

118. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1_3 (cost=0.58..16.67 rows=1 width=53) (never executed)

119. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.66 rows=1 width=137) (never executed)

120. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = 13973) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
121. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_7 (cost=0.29..8.33 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = p_p.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '25992'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
122. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2_3 (cost=0.29..8.34 rows=1 width=53) (never executed)

123. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_8 (cost=0.29..8.33 rows=1 width=137) (never executed)

  • Index Cond: ((positionid = 13973) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '25992'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
124. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 3 (cost=0.58..16.67 rows=1 width=53) (never executed)

125. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.66 rows=1 width=137) (never executed)

126. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p_1 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = 13973) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
127. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_9 (cost=0.29..8.33 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = p_p_1.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '25992'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
128. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 4 (cost=0.87..17.23 rows=1 width=53) (never executed)

129. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.87..17.22 rows=1 width=137) (never executed)

130. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.66 rows=1 width=8) (never executed)

131. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p1 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = 13973) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
132. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p_2 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = p_p1.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
133. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_10 (cost=0.29..0.55 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = p_p_2.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '25992'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
134. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 5 (cost=1.16..17.64 rows=1 width=53) (never executed)

135. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.16..17.63 rows=1 width=137) (never executed)

136. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.87..17.07 rows=1 width=8) (never executed)

137. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.66 rows=1 width=8) (never executed)

138. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p2 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = 13973) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
139. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p1_1 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = p_p2.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
140. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p_3 (cost=0.29..0.41 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = p_p1_1.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
141. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_11 (cost=0.29..0.55 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = p_p_3.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '25992'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
142. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 6 (cost=1.45..18.06 rows=1 width=53) (never executed)

143. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.45..18.05 rows=1 width=137) (never executed)

144. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.16..17.49 rows=1 width=8) (never executed)

145. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.87..17.07 rows=1 width=8) (never executed)

146. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.66 rows=1 width=8) (never executed)

147. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p3 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = 13973) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
148. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p2_1 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = p_p3.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
149. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p1_2 (cost=0.29..0.41 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = p_p2_1.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
150. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p_4 (cost=0.29..0.41 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = p_p1_2.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
151. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_12 (cost=0.29..0.55 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = p_p_4.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '25992'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
152. 0.000 0.000 ↓ 0.0 0

Result (cost=0.87..52.97 rows=3 width=85) (never executed)

153. 0.000 0.000 ↓ 0.0 0

Append (cost=0.87..52.94 rows=3 width=53) (never executed)

154. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1_4 (cost=0.87..17.23 rows=1 width=53) (never executed)

155. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.87..17.22 rows=1 width=137) (never executed)

156. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.66 rows=1 width=8) (never executed)

157. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos py (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = 13973) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
158. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos px (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = py.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
159. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_13 (cost=0.29..0.55 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = px.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '25992'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
160. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2_4 (cost=1.16..17.65 rows=1 width=53) (never executed)

161. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.16..17.64 rows=1 width=137) (never executed)

162. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.87..17.07 rows=1 width=8) (never executed)

163. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.66 rows=1 width=8) (never executed)

164. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos pq (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = 13973) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
165. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos py_1 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = pq.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
166. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos px_1 (cost=0.29..0.41 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = py_1.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
167. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_14 (cost=0.29..0.56 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = px_1.positionid) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '25992'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
168. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 3_1 (cost=1.45..18.06 rows=1 width=53) (never executed)

169. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.45..18.05 rows=1 width=137) (never executed)

170. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.16..17.49 rows=1 width=8) (never executed)

171. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.87..17.07 rows=1 width=8) (never executed)

172. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.66 rows=1 width=8) (never executed)

173. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos pz (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = 13973) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
174. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos pq_1 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = pz.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
175. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos py_2 (cost=0.29..0.41 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = pq_1.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
176. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos px_2 (cost=0.29..0.41 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = py_2.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
177. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_15 (cost=0.29..0.55 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = px_2.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '25992'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
178. 0.000 0.000 ↓ 0.0 0

Result (cost=1.00..132.07 rows=2 width=89) (never executed)

179. 0.000 0.000 ↓ 0.0 0

Append (cost=1.00..132.05 rows=2 width=57) (never executed)

180. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1_5 (cost=1.00..105.05 rows=1 width=53) (never executed)

181. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.00..105.04 rows=1 width=137) (never executed)

  • Join Filter: (("*SELECT* 1_6".subjectid)::character(12) <> p_2.personid)
182. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..96.59 rows=1 width=92) (never executed)

  • Join Filter: (proxy.personid = "*SELECT* 1_6".userid)
183. 0.000 0.000 ↓ 0.0 0

Seq Scan on pers_pers proxy (cost=0.00..1.91 rows=1 width=104) (never executed)

  • Filter: ((topersonid = '25992'::bpchar) AND (personreltype = 'ProxDMgr'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
184. 0.000 0.000 ↓ 0.0 0

Append (cost=0.58..94.60 rows=6 width=53) (never executed)

185. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1_6 (cost=0.58..16.67 rows=1 width=53) (never executed)

186. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.66 rows=1 width=137) (never executed)

187. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p_5 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = 13973) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
188. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_16 (cost=0.29..8.33 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = p_p_5.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
189. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2_6 (cost=0.29..8.34 rows=1 width=53) (never executed)

190. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_17 (cost=0.29..8.33 rows=1 width=137) (never executed)

  • Index Cond: ((positionid = 13973) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
191. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 3_2 (cost=0.58..16.67 rows=1 width=53) (never executed)

192. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.66 rows=1 width=137) (never executed)

193. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p_6 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = 13973) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
194. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_18 (cost=0.29..8.33 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = p_p_6.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
195. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 4_1 (cost=0.87..17.23 rows=1 width=53) (never executed)

196. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.87..17.22 rows=1 width=137) (never executed)

197. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.66 rows=1 width=8) (never executed)

198. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p1_3 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = 13973) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
199. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p_7 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = p_p1_3.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
200. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_19 (cost=0.29..0.55 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = p_p_7.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
201. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 5_1 (cost=1.16..17.64 rows=1 width=53) (never executed)

202. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.16..17.63 rows=1 width=137) (never executed)

203. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.87..17.07 rows=1 width=8) (never executed)

204. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.66 rows=1 width=8) (never executed)

205. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p2_2 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = 13973) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
206. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p1_4 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = p_p2_2.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
207. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p_8 (cost=0.29..0.41 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = p_p1_4.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
208. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_20 (cost=0.29..0.55 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = p_p_8.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
209. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 6_1 (cost=1.45..18.06 rows=1 width=53) (never executed)

210. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.45..18.05 rows=1 width=137) (never executed)

211. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.16..17.49 rows=1 width=8) (never executed)

212. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.87..17.07 rows=1 width=8) (never executed)

213. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.66 rows=1 width=8) (never executed)

214. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p3_1 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = 13973) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
215. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p2_3 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = p_p3_1.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
216. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p1_5 (cost=0.29..0.41 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = p_p2_3.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
217. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p_9 (cost=0.29..0.41 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = p_p1_5.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
218. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_21 (cost=0.29..0.55 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = p_p_9.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
219. 0.000 0.000 ↓ 0.0 0

Index Only Scan using person_pkey on person p_2 (cost=0.42..8.44 rows=1 width=13) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
  • Heap Fetches: 0
220. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2_5 (cost=0.99..27.00 rows=1 width=61) (never executed)

221. 0.000 0.000 ↓ 0.0 0

Nested Loop Anti Join (cost=0.99..26.99 rows=1 width=105) (never executed)

  • Join Filter: (pop.topositionid = pos_1.positionid)
222. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..18.67 rows=1 width=61) (never executed)

223. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..10.36 rows=1 width=57) (never executed)

224. 0.000 0.000 ↓ 0.0 0

Index Only Scan using person_pkey on person p_3 (cost=0.42..8.44 rows=1 width=13) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
  • Heap Fetches: 0
225. 0.000 0.000 ↓ 0.0 0

Seq Scan on pers_pers proxy_1 (cost=0.00..1.91 rows=1 width=96) (never executed)

  • Filter: ((topersonid = '25992'::bpchar) AND (personreltype = 'ProxDMgr1'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
226. 0.000 0.000 ↓ 0.0 0

Index Only Scan using position_pkey on "position" pos_1 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Index Cond: (positionid = 13973)
  • Heap Fetches: 0
227. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pos_pos_topositionid on pos_pos pop (cost=0.29..8.30 rows=1 width=4) (never executed)

  • Index Cond: (topositionid = 13973)
  • Heap Fetches: 0
228. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=8.63..7,740.95 rows=1 width=85) (never executed)

229. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=8.34..7,732.61 rows=1 width=17) (never executed)

  • Hash Cond: ("*SELECT* 1_7".subjectid = pp_22.personid)
230. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..7,663.61 rows=16,172 width=26) (never executed)

231. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1_7 (cost=0.00..2,348.96 rows=14,311 width=26) (never executed)

232. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..2,205.85 rows=14,311 width=146) (never executed)

  • Join Filter: ((ar_1.personid <> pe_2.personid) AND (ar_1.personid <> pe_2.personid))
233. 0.000 0.000 ↓ 0.0 0

Seq Scan on assigned_roles ar_1 (cost=0.00..5.33 rows=1 width=13) (never executed)

  • Filter: ((rolename = 'HRGenLim'::bpchar) AND (personid = '25992'::bpchar))
234. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_employment pe_2 (cost=0.00..1,985.84 rows=14,312 width=13) (never executed)

  • Filter: ((effectivedate <= enddate) AND (CURRENT_DATE <= enddate))
235. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2_7 (cost=10.97..508.93 rows=421 width=26) (never executed)

236. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=10.97..504.72 rows=421 width=146) (never executed)

237. 0.000 0.000 ↓ 0.0 0

Index Scan using person_company_rel_pkey on person_company_rel pr (cost=0.28..8.32 rows=1 width=17) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
  • Filter: ((personcompanyreltype = 'HRGL'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
238. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on person_employment pe_3 (cost=10.69..495.99 rows=41 width=17) (never executed)

  • Recheck Cond: ((companyid = pr.companyid) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (pr.personid <> personid) AND (pr.personid <> personid) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
239. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on employmentcompanyideffdt (cost=0.00..10.68 rows=185 width=0) (never executed)

  • Index Cond: ((companyid = pr.companyid) AND (CURRENT_DATE <= enddate))
240. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 3_3 (cost=1,755.15..1,801.35 rows=1 width=26) (never executed)

241. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1,755.15..1,801.34 rows=1 width=146) (never executed)

  • Join Filter: ((pl1.personid <> lp1.personid) AND (pe_4.personid = lp1.personid))
242. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1,754.74..1,800.55 rows=1 width=39) (never executed)

243. 0.000 0.000 ↓ 0.0 0

Index Only Scan using person_pkey on person pl1 (cost=0.42..8.44 rows=1 width=13) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
  • Heap Fetches: 0
244. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=1,754.32..1,773.22 rows=1,890 width=39) (never executed)

  • Group Key: pl_1.personid, lp_1.personid
245. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=8.27..1,744.87 rows=1,890 width=39) (never executed)

246. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=7.85..1,667.94 rows=108 width=26) (never executed)

  • Hash Cond: (lp_1.locationid = pl_1.locationid)
  • Join Filter: (pl_1.personid <> lp_1.personid)
247. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_locations lp_1 (cost=0.00..1,575.41 rows=22,220 width=17) (never executed)

  • Filter: ((personlocationtype = 'P'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
248. 0.000 0.000 ↓ 0.0 0

Hash (cost=7.84..7.84 rows=1 width=17) (never executed)

249. 0.000 0.000 ↓ 0.0 0

Index Scan using personlocationreltype on person_location_rel pl_1 (cost=0.28..7.84 rows=1 width=17) (never executed)

  • Index Cond: (personlocationreltype = 'HL'::bpchar)
  • Filter: ((personid = '25992'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
250. 0.000 0.000 ↓ 0.0 0

Index Only Scan using personemploymentenddate on person_employment pe_4 (cost=0.42..0.70 rows=1 width=13) (never executed)

  • Index Cond: ((personid = lp_1.personid) AND (enddate >= CURRENT_DATE))
  • Filter: (effectivedate <= enddate)
  • Heap Fetches: 0
251. 0.000 0.000 ↓ 0.0 0

Index Only Scan using person_pkey on person lp1 (cost=0.42..0.77 rows=1 width=13) (never executed)

  • Index Cond: (personid = lp_1.personid)
  • Heap Fetches: 0
252. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 4_2 (cost=1.96..1,501.39 rows=817 width=26) (never executed)

253. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.96..1,493.22 rows=817 width=146) (never executed)

254. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.54..643.24 rows=1,313 width=26) (never executed)

  • Join Filter: ((pp_23.personid <> op_1.personid) AND (pp_23.personid <> op_1.personid))
255. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.24..70.24 rows=1,270 width=17) (never executed)

256. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.90 rows=1 width=17) (never executed)

257. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pos_pkey on pers_pos pp_23 (cost=0.41..8.45 rows=1 width=17) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
258. 0.000 0.000 ↓ 0.0 0

Index Scan using posorgrelbyposition on pos_org_rel pr_1 (cost=0.41..8.44 rows=1 width=8) (never executed)

  • Index Cond: ((positionid = pp_23.positionid) AND (posorgreltype = 'HRGenLim'::bpchar))
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
259. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_org_rel_pkey on pos_org_rel ro (cost=0.41..53.11 rows=23 width=8) (never executed)

  • Index Cond: (organizationid = pr_1.organizationid)
  • Filter: ((posorgreltype = 'Member'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
260. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos op_1 (cost=0.29..0.44 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = ro.positionid) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: (persposrel = 'Occupies'::bpchar)
261. 0.000 0.000 ↓ 0.0 0

Index Only Scan using personemploymentenddate on person_employment pe_5 (cost=0.42..0.64 rows=1 width=13) (never executed)

  • Index Cond: ((personid = op_1.personid) AND (enddate >= CURRENT_DATE))
  • Filter: (effectivedate <= enddate)
  • Heap Fetches: 0
262. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 5_2 (cost=9.72..274.90 rows=200 width=26) (never executed)

263. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=9.72..272.90 rows=200 width=146) (never executed)

  • Join Filter: (pp_24.personid <> op_2.personid)
264. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=9.43..186.31 rows=193 width=17) (never executed)

265. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on person_organization_rel pp_24 (cost=4.29..8.54 rows=1 width=17) (never executed)

  • Recheck Cond: (personid = '25992'::bpchar)
  • Filter: ((personorganizationreltype = 'HRGL'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
266. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on person_organization_rel_pkey (cost=0.00..4.29 rows=2 width=0) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
267. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pos_org_rel pr_2 (cost=5.14..177.54 rows=23 width=8) (never executed)

  • Recheck Cond: ((organizationid = pp_24.organizationid) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: (posorgreltype = 'Member'::bpchar)
268. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on posorgrelorganization (cost=0.00..5.13 rows=53 width=0) (never executed)

  • Index Cond: ((organizationid = pp_24.organizationid) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
269. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos op_2 (cost=0.29..0.44 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = pr_2.positionid) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: (persposrel = 'Occupies'::bpchar)
270. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 6_2 (cost=1,219.65..1,228.09 rows=422 width=26) (never executed)

271. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=1,219.65..1,223.87 rows=422 width=146) (never executed)

  • Group Key: p_4.personid, pe_6.personid, 'HRGenLim'::character(8), 'RoleEx_HRGenLimPreHi'::character(20)
272. 0.000 0.000 ↓ 0.0 0

Nested Loop Anti Join (cost=6.46..1,215.43 rows=422 width=146) (never executed)

273. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=6.04..763.19 rows=740 width=26) (never executed)

  • Join Filter: (p_4.personid <> pe_6.personid)
274. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=5.75..430.16 rows=573 width=17) (never executed)

275. 0.000 0.000 ↓ 0.0 0

Index Scan using person_company_rel_pkey on person_company_rel p_4 (cost=0.28..8.32 rows=1 width=17) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
  • Filter: ((personcompanyreltype = 'HRGL'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
276. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on position_desc pd_4 (cost=5.47..421.36 rows=48 width=8) (never executed)

  • Recheck Cond: (companyid = p_4.companyid)
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
277. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on positioncompany (cost=0.00..5.46 rows=156 width=0) (never executed)

  • Index Cond: (companyid = p_4.companyid)
278. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pe_6 (cost=0.29..0.57 rows=1 width=17) (never executed)

  • Index Cond: (positionid = pd_4.positionid)
279. 0.000 0.000 ↓ 0.0 0

Index Scan using personemploymentenddate on person_employment pep (cost=0.41..0.61 rows=1 width=13) (never executed)

  • Index Cond: (personid = pe_6.personid)
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
280. 0.000 0.000 ↓ 0.0 0

Hash (cost=8.33..8.33 rows=1 width=17) (never executed)

281. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_22 (cost=0.29..8.33 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = 13973) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: ((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
282. 0.000 0.000 ↓ 0.0 0

Index Scan using position_desc_pkey on position_desc pd_3 (cost=0.29..8.33 rows=1 width=4) (never executed)

  • Index Cond: (positionid = 13973)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
283. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.54..33.70 rows=1 width=85) (never executed)

  • Join Filter: (pe_7.companyid = pd_5.companyid)
284. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.25..25.36 rows=1 width=17) (never executed)

285. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.90 rows=1 width=17) (never executed)

286. 0.000 0.000 ↓ 0.0 0

Index Only Scan using person_pkey on person p_5 (cost=0.42..8.44 rows=1 width=13) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
  • Heap Fetches: 0
287. 0.000 0.000 ↓ 0.0 0

Index Scan using personemploymentenddate on person_employment pe_7 (cost=0.42..8.46 rows=1 width=17) (never executed)

  • Index Cond: ((personid = '25992'::bpchar) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts) AND (emplstatus = ANY ('{A,L,P,C}'::bpchar[])))
288. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pos_pkey on pers_pos ppos (cost=0.41..8.45 rows=1 width=13) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
289. 0.000 0.000 ↓ 0.0 0

Index Scan using position_desc_pkey on position_desc pd_5 (cost=0.29..8.33 rows=1 width=8) (never executed)

  • Index Cond: (positionid = 13973)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
290. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.85..35.63 rows=1 width=85) (never executed)

291. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..21.98 rows=1 width=21) (never executed)

292. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.29..13.65 rows=1 width=17) (never executed)

293. 0.000 0.000 ↓ 0.0 0

Seq Scan on assigned_roles u_1 (cost=0.00..5.33 rows=1 width=13) (never executed)

  • Filter: ((rolename = 'Onboard'::bpchar) AND (personid = '25992'::bpchar))
294. 0.000 0.000 ↓ 0.0 0

Index Only Scan using position_pkey on "position" pos_2 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Index Cond: (positionid = 13973)
  • Heap Fetches: 0
295. 0.000 0.000 ↓ 0.0 0

Index Scan using position_desc_pkey on position_desc pd_6 (cost=0.29..8.33 rows=1 width=8) (never executed)

  • Index Cond: (positionid = 13973)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
296. 0.000 0.000 ↓ 0.0 0

Index Scan using company_parameters_pkey on company_parameters cp (cost=0.28..8.30 rows=1 width=4) (never executed)

  • Index Cond: ((companyid = pd_6.companyid) AND (companyparametername = 'InOnboard'::bpchar))
  • Filter: ((companyparametervalue)::text = 'Y'::text)
297. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..18.10 rows=1 width=85) (never executed)

  • Join Filter: (pcr_2.personcustomerreltype = pcrt_2.personcustomerreltype)
298. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..16.83 rows=1 width=23) (never executed)

299. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..16.65 rows=1 width=8) (never executed)

300. 0.000 0.000 ↓ 0.0 0

Index Scan using position_desc_pkey on position_desc pd_7 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: (positionid = 13973)
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
301. 0.000 0.000 ↓ 0.0 0

Index Scan using customercompany on customer_struct cs (cost=0.28..8.31 rows=1 width=8) (never executed)

  • Index Cond: (companyid = pd_7.companyid)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
302. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_person_customer_rel on person_customer_rel pcr_2 (cost=0.14..0.17 rows=1 width=23) (never executed)

  • Index Cond: ((personid = '25992'::bpchar) AND (customerid = cs.customerid))
303. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_customer_rel_type pcrt_2 (cost=0.00..1.12 rows=12 width=60) (never executed)

304. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_25 (cost=0.29..8.33 rows=1 width=85) (never executed)

  • Index Cond: ((positionid = 13973) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '25992'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
305. 0.000 0.000 ↓ 0.0 0

Hash (cost=48.08..48.08 rows=3 width=9) (never executed)

306. 0.000 0.000 ↓ 0.0 0

Append (cost=0.56..48.08 rows=3 width=9) (never executed)

307. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1_1 (cost=0.56..19.88 rows=1 width=9) (never executed)

308. 0.000 0.000 ↓ 0.0 0

Nested Loop Anti Join (cost=0.56..19.87 rows=1 width=261) (never executed)

  • Join Filter: (((sc1_1.action)::text = (sc3_2.action)::text) AND ((sc3_2.domainobject)::text = (sc1_1.domainobject)::text) AND (sc3_2.rolename = sc1_1.rolename))
309. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_company_security_control on company_security_control sc1_1 (cost=0.28..8.34 rows=1 width=32) (never executed)

  • Index Cond: (((domainobject)::text = (this_.domainobject)::text) AND ((action)::text = (this_.action)::text) AND (companyid = 51786))
  • Filter: (NOT negative)
310. 0.000 0.000 ↓ 0.0 0

Index Only Scan using security_control_pkey1 on security_control sc3_2 (cost=0.29..11.50 rows=2 width=31) (never executed)

  • Index Cond: ((domainobject = (this_.domainobject)::text) AND (action = (this_.action)::text))
  • Heap Fetches: 0
311. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2_1 (cost=0.84..28.20 rows=2 width=9) (never executed)

312. 0.000 0.000 ↓ 0.0 0

Nested Loop Anti Join (cost=0.84..28.18 rows=2 width=261) (never executed)

  • Join Filter: ((sc3_3.companyid = c_1.companyid) AND ((sc3_3.domainobject)::text = (sc2_1.domainobject)::text) AND ((sc3_3.action)::text = (sc2_1.action)::text) AND (sc3_3.rolename = sc2_1.rolename))
313. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..19.83 rows=2 width=35) (never executed)

314. 0.000 0.000 ↓ 0.0 0

Index Only Scan using security_control_pkey1 on security_control sc2_1 (cost=0.29..11.50 rows=2 width=31) (never executed)

  • Index Cond: ((domainobject = (this_.domainobject)::text) AND (action = (this_.action)::text))
  • Heap Fetches: 0
315. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.28..8.30 rows=1 width=4) (never executed)

316. 0.000 0.000 ↓ 0.0 0

Index Only Scan using company_pkey on company c_1 (cost=0.28..8.30 rows=1 width=4) (never executed)

  • Index Cond: (companyid = 51786)
  • Heap Fetches: 0
317. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.28..8.31 rows=1 width=36) (never executed)

318. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_csc_neg_do_act on company_security_control sc3_3 (cost=0.28..8.30 rows=1 width=36) (never executed)

  • Index Cond: ((negative = true) AND ((domainobject)::text = (this_.domainobject)::text) AND ((action)::text = (this_.action)::text) AND (companyid = 51786))
  • Filter: negative
319. 0.000 0.324 ↓ 0.0 0 9

Nested Loop Semi Join (cost=35.01..82.68 rows=2 width=0) (actual time=0.036..0.036 rows=0 loops=9)

  • Join Filter: (ar_2.rolename = "*SELECT* 1_8".rolename)
320. 0.014 0.162 ↑ 1.3 3 9

HashAggregate (cost=34.45..34.49 rows=4 width=168) (actual time=0.017..0.018 rows=3 loops=9)

  • Group Key: ar_2.personid, ar_2.personid, ar_2.rolename, (''::text)
321. 0.001 0.148 ↑ 1.3 3 1

Append (cost=0.00..34.41 rows=4 width=168) (actual time=0.008..0.148 rows=3 loops=1)

322. 0.027 0.027 ↑ 1.0 2 1

Seq Scan on assigned_roles ar_2 (cost=0.00..4.78 rows=2 width=67) (actual time=0.008..0.027 rows=2 loops=1)

  • Filter: (personid = '25992'::bpchar)
  • Rows Removed by Filter: 220
323. 0.001 0.030 ↑ 1.0 1 1

Nested Loop (cost=0.83..16.88 rows=1 width=90) (actual time=0.030..0.030 rows=1 loops=1)

324. 0.018 0.018 ↑ 1.0 1 1

Index Only Scan using person_pkey on person p_6 (cost=0.42..8.44 rows=1 width=13) (actual time=0.018..0.018 rows=1 loops=1)

  • Index Cond: (personid = '25992'::bpchar)
  • Heap Fetches: 1
325. 0.011 0.011 ↑ 1.0 1 1

Index Only Scan using person_pkey on person p2_1 (cost=0.42..8.44 rows=1 width=13) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: (personid = '25992'::bpchar)
  • Heap Fetches: 1
326. 0.001 0.090 ↓ 0.0 0 1

Nested Loop Semi Join (cost=3.51..12.71 rows=1 width=94) (actual time=0.089..0.090 rows=0 loops=1)

327. 0.063 0.063 ↑ 1.0 1 1

Index Only Scan using person_pkey on person p_7 (cost=0.42..8.44 rows=1 width=13) (actual time=0.062..0.063 rows=1 loops=1)

  • Index Cond: (personid = '25992'::bpchar)
  • Heap Fetches: 1
328. 0.011 0.026 ↓ 0.0 0 1

Hash Join (cost=3.09..4.27 rows=1 width=13) (actual time=0.026..0.026 rows=0 loops=1)

  • Hash Cond: (pcrt_3.personcustomerreltype = pcr_3.personcustomerreltype)
329. 0.003 0.003 ↑ 12.0 1 1

Seq Scan on person_customer_rel_type pcrt_3 (cost=0.00..1.12 rows=12 width=24) (actual time=0.003..0.003 rows=1 loops=1)

  • Filter: (rolename IS NOT NULL)
330. 0.000 0.012 ↓ 0.0 0 1

Hash (cost=3.08..3.08 rows=1 width=19) (actual time=0.012..0.012 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
331. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on person_customer_rel pcr_3 (cost=0.00..3.08 rows=1 width=19) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: ((personid = '25992'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 64
332. 0.009 0.162 ↓ 0.0 0 27

Materialize (cost=0.56..48.04 rows=2 width=9) (actual time=0.006..0.006 rows=0 loops=27)

333. 0.009 0.153 ↓ 0.0 0 9

Append (cost=0.56..48.03 rows=2 width=9) (actual time=0.017..0.017 rows=0 loops=9)

334. 0.000 0.054 ↓ 0.0 0 9

Subquery Scan on *SELECT* 1_8 (cost=0.56..19.89 rows=1 width=9) (actual time=0.006..0.006 rows=0 loops=9)

335. 0.009 0.054 ↓ 0.0 0 9

Nested Loop Anti Join (cost=0.56..19.88 rows=1 width=261) (actual time=0.006..0.006 rows=0 loops=9)

  • Join Filter: (((sc1_2.action)::text = (sc3_4.action)::text) AND ((sc3_4.domainobject)::text = (sc1_2.domainobject)::text) AND (sc3_4.rolename = sc1_2.rolename))
336. 0.045 0.045 ↓ 0.0 0 9

Index Scan using pk_company_security_control on company_security_control sc1_2 (cost=0.28..8.34 rows=1 width=32) (actual time=0.005..0.005 rows=0 loops=9)

  • Index Cond: (((domainobject)::text = (this_.domainobject)::text) AND ((action)::text = (this_.action)::text) AND (companyid = 51786))
  • Filter: ((NOT negative) AND (roleinterest = 'X'::bpchar))
337. 0.000 0.000 ↓ 0.0 0

Index Only Scan using security_control_pkey1 on security_control sc3_4 (cost=0.29..11.50 rows=2 width=31) (never executed)

  • Index Cond: ((domainobject = (this_.domainobject)::text) AND (action = (this_.action)::text))
  • Heap Fetches: 0
338. 0.000 0.090 ↓ 0.0 0 9

Subquery Scan on *SELECT* 2_8 (cost=0.84..28.15 rows=1 width=9) (actual time=0.010..0.010 rows=0 loops=9)

339. 0.000 0.090 ↓ 0.0 0 9

Nested Loop Anti Join (cost=0.84..28.14 rows=1 width=261) (actual time=0.010..0.010 rows=0 loops=9)

  • Join Filter: ((sc3_5.companyid = c_2.companyid) AND ((sc3_5.domainobject)::text = (sc2_2.domainobject)::text) AND ((sc3_5.action)::text = (sc2_2.action)::text) AND (sc3_5.rolename = sc2_2.rolename))
340. 0.009 0.090 ↓ 0.0 0 9

Nested Loop (cost=0.57..19.81 rows=1 width=35) (actual time=0.009..0.010 rows=0 loops=9)

341. 0.081 0.081 ↓ 0.0 0 9

Index Scan using security_control_pkey1 on security_control sc2_2 (cost=0.29..11.51 rows=1 width=31) (actual time=0.009..0.009 rows=0 loops=9)

  • Index Cond: (((domainobject)::text = (this_.domainobject)::text) AND ((action)::text = (this_.action)::text))
  • Filter: (roleinterest = 'X'::bpchar)
  • Rows Removed by Filter: 5
342. 0.000 0.000 ↓ 0.0 0

Index Only Scan using company_pkey on company c_2 (cost=0.28..8.30 rows=1 width=4) (never executed)

  • Index Cond: (companyid = 51786)
  • Heap Fetches: 0
343. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_csc_neg_do_act on company_security_control sc3_5 (cost=0.28..8.30 rows=1 width=36) (never executed)

  • Index Cond: ((negative = true) AND ((domainobject)::text = (this_.domainobject)::text) AND ((action)::text = (this_.action)::text) AND (companyid = 51786))
  • Filter: negative
344. 0.000 0.000 ↓ 0.0 0

Hash Semi Join (cost=8,339.09..8,339.63 rows=2 width=0) (never executed)

  • Hash Cond: (u_2.rolename = "*SELECT* 1_9".rolename)
345. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=8,291.03..8,291.26 rows=23 width=120) (never executed)

  • Group Key: u_2.personid, pos_3.positionid, u_2.rolename, (''::text)
346. 0.000 0.000 ↓ 0.0 0

Append (cost=0.29..8,290.80 rows=23 width=120) (never executed)

347. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.29..13.65 rows=1 width=58) (never executed)

348. 0.000 0.000 ↓ 0.0 0

Seq Scan on assigned_roles u_2 (cost=0.00..5.33 rows=1 width=22) (never executed)

  • Filter: ((rolename = 'HRAdmin'::bpchar) AND (personid = '25992'::bpchar))
349. 0.000 0.000 ↓ 0.0 0

Index Only Scan using position_pkey on "position" pos_3 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Index Cond: (positionid = 13973)
  • Heap Fetches: 0
350. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..18.89 rows=1 width=58) (never executed)

351. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..18.08 rows=1 width=53) (never executed)

  • Join Filter: (pcr_4.personcompanyreltype = pcrt_4.personcompanyreltype)
352. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..16.65 rows=1 width=23) (never executed)

  • Join Filter: (pcr_4.companyid = pd_8.companyid)
353. 0.000 0.000 ↓ 0.0 0

Index Scan using person_company_rel_pkey on person_company_rel pcr_4 (cost=0.28..8.32 rows=1 width=23) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
354. 0.000 0.000 ↓ 0.0 0

Index Scan using position_desc_pkey on position_desc pd_8 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: (positionid = 13973)
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
355. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_company_rel_type pcrt_4 (cost=0.00..1.19 rows=19 width=60) (never executed)

356. 0.000 0.000 ↓ 0.0 0

Index Only Scan using web_role_pkey on web_role wr_5 (cost=0.14..0.79 rows=1 width=9) (never executed)

  • Index Cond: (rolename = pcrt_4.rolename)
  • Heap Fetches: 0
357. 0.000 0.000 ↓ 0.0 0

Subquery Scan on r_positionlocationroles_1 (cost=69.07..69.11 rows=2 width=124) (never executed)

358. 0.000 0.000 ↓ 0.0 0

Unique (cost=69.07..69.09 rows=2 width=176) (never executed)

359. 0.000 0.000 ↓ 0.0 0

Sort (cost=69.07..69.07 rows=2 width=176) (never executed)

  • Sort Key: plr_2.personid, pl_2.positionid, wr_6.rolename, ('RoleEx_GenPosLocR '::character(20))
360. 0.000 0.000 ↓ 0.0 0

Append (cost=1.70..69.06 rows=2 width=176) (never executed)

361. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.70..48.76 rows=1 width=110) (never executed)

  • Join Filter: (plr_2.personlocationreltype = plrt_2.personlocationreltype)
362. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..45.61 rows=1 width=26) (never executed)

363. 0.000 0.000 ↓ 0.0 0

Index Scan using position_location_pkey on position_location pl_2 (cost=0.29..37.29 rows=1 width=8) (never executed)

  • Index Cond: (positionid = 13973)
  • Filter: ((effectivedate <= enddate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts) AND ((NOT (alternatives: SubPlan 8 or hashed SubPlan 9)) OR (alternatives: SubPlan 10 or hashed SubPlan 11)))
364.          

SubPlan (forIndex Scan)

365. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_26 (cost=0.29..8.33 rows=1 width=0) (never executed)

  • Index Cond: ((positionid = pl_2.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
366. 0.000 0.000 ↓ 0.0 0

Seq Scan on pers_pos pp_27 (cost=0.00..1,773.86 rows=6,979 width=4) (never executed)

  • Filter: ((effectivedate <= enddate) AND (persposrel = 'Occupies'::bpchar) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
367. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..20.64 rows=1 width=0) (never executed)

368. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_28 (cost=0.29..8.33 rows=1 width=13) (never executed)

  • Index Cond: ((positionid = pl_2.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
369. 0.000 0.000 ↓ 0.0 0

Index Scan using personemploymentenddate on person_employment pe_8 (cost=0.42..12.30 rows=1 width=13) (never executed)

  • Index Cond: ((personid = pp_28.personid) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (createts = endts))
370. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.41..2,670.12 rows=22 width=4) (never executed)

371. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_employment pe_9 (cost=0.00..2,116.82 rows=72 width=13) (never executed)

  • Filter: ((effectivedate <= enddate) AND (createts = endts) AND (CURRENT_DATE <= enddate))
372. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pos_pkey on pers_pos pp_29 (cost=0.41..7.67 rows=1 width=17) (never executed)

  • Index Cond: (personid = pe_9.personid)
  • Filter: ((effectivedate <= enddate) AND (persposrel = 'Occupies'::bpchar) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
373. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_person_location_rel on person_location_rel plr_2 (cost=0.28..8.31 rows=1 width=26) (never executed)

  • Index Cond: ((personid = '25992'::bpchar) AND (locationid = pl_2.locationid))
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
374. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1.14..3.08 rows=6 width=45) (never executed)

  • Hash Cond: (wr_6.rolename = plrt_2.rolename)
375. 0.000 0.000 ↓ 0.0 0

Seq Scan on web_role wr_6 (cost=0.00..1.64 rows=64 width=9) (never executed)

376. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.06..1.06 rows=6 width=72) (never executed)

377. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_location_rel_type plrt_2 (cost=0.00..1.06 rows=6 width=72) (never executed)

378. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.12..20.27 rows=1 width=110) (never executed)

  • Join Filter: (plrt_3.personlocationreltype = plr_3.personlocationreltype)
379. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.98..17.12 rows=1 width=26) (never executed)

380. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..16.79 rows=1 width=8) (never executed)

381. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_30 (cost=0.29..8.33 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = 13973) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
382. 0.000 0.000 ↓ 0.0 0

Index Scan using person_locations_pkey on person_locations lp_2 (cost=0.41..8.45 rows=1 width=17) (never executed)

  • Index Cond: (personid = pp_30.personid)
  • Filter: ((effectivedate <= enddate) AND (personlocationtype = 'P'::bpchar) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
383. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_person_location_rel on person_location_rel plr_3 (cost=0.28..0.32 rows=1 width=26) (never executed)

  • Index Cond: ((personid = '25992'::bpchar) AND (locationid = lp_2.locationid))
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
384. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1.14..3.08 rows=6 width=45) (never executed)

  • Hash Cond: (wr_7.rolename = plrt_3.rolename)
385. 0.000 0.000 ↓ 0.0 0

Seq Scan on web_role wr_7 (cost=0.00..1.64 rows=64 width=9) (never executed)

386. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.06..1.06 rows=6 width=72) (never executed)

387. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_location_rel_type plrt_3 (cost=0.00..1.06 rows=6 width=72) (never executed)

388. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=4.99..26.49 rows=1 width=85) (never executed)

389. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=4.70..18.16 rows=1 width=53) (never executed)

390. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=4.29..9.69 rows=1 width=53) (never executed)

  • Join Filter: (port_1.personorganizationreltype = po_1.personorganizationreltype)
391. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on person_organization_rel po_1 (cost=4.29..8.56 rows=1 width=22) (never executed)

  • Recheck Cond: (personid = '25992'::bpchar)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
392. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on person_organization_rel_pkey (cost=0.00..4.29 rows=2 width=0) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
393. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_organization_rel_type port_1 (cost=0.00..1.06 rows=6 width=56) (never executed)

  • Filter: (rolename IS NOT NULL)
394. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_org_rel_pkey on pos_org_rel op_3 (cost=0.41..8.45 rows=1 width=8) (never executed)

  • Index Cond: ((organizationid = po_1.organizationid) AND (positionid = 13973))
  • Filter: ((effectivedate <= enddate) AND (posorgreltype = 'Member'::bpchar) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
395. 0.000 0.000 ↓ 0.0 0

Index Scan using position_desc_pkey on position_desc pd_9 (cost=0.29..8.32 rows=1 width=4) (never executed)

  • Index Cond: (positionid = 13973)
  • Filter: ((effectivedate <= enddate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
396. 0.000 0.000 ↓ 0.0 0

Result (cost=2.27..46.01 rows=2 width=58) (never executed)

397. 0.000 0.000 ↓ 0.0 0

Append (cost=2.27..45.99 rows=2 width=26) (never executed)

398. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1_10 (cost=2.27..20.46 rows=1 width=26) (never executed)

399. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.27..20.45 rows=1 width=110) (never executed)

  • Join Filter: ((ppurt_2.personpayunitreltype)::text = (pp_31.personpayunitreltype)::text)
400. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.14..17.30 rows=1 width=23) (never executed)

  • Join Filter: (pu_2.payunitid = pp_31.payunitid)
401. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.86..16.97 rows=1 width=12) (never executed)

402. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.67 rows=1 width=8) (never executed)

403. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos persp_1 (cost=0.29..8.33 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = 13973) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
404. 0.000 0.000 ↓ 0.0 0

Index Scan using person_payroll_pkey on person_payroll ep_1 (cost=0.29..8.33 rows=1 width=17) (never executed)

  • Index Cond: (personid = persp_1.personid)
  • Filter: ((payunitrelationship = 'M'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
405. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pay_unit_pkey on pay_unit pu_2 (cost=0.28..0.30 rows=1 width=4) (never executed)

  • Index Cond: (payunitid = ep_1.payunitid)
  • Heap Fetches: 0
406. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_person_pay_unit_rel on person_pay_unit_rel pp_31 (cost=0.28..0.32 rows=1 width=23) (never executed)

  • Index Cond: ((personid = '25992'::bpchar) AND (payunitid = ep_1.payunitid))
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
407. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1.14..3.08 rows=6 width=43) (never executed)

  • Hash Cond: (wr_8.rolename = ppurt_2.rolename)
408. 0.000 0.000 ↓ 0.0 0

Seq Scan on web_role wr_8 (cost=0.00..1.64 rows=64 width=9) (never executed)

409. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.06..1.06 rows=6 width=70) (never executed)

410. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_pay_unit_rel_type ppurt_2 (cost=0.00..1.06 rows=6 width=70) (never executed)

411. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2_10 (cost=5.99..25.53 rows=1 width=26) (never executed)

412. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=5.99..25.52 rows=1 width=110) (never executed)

  • Join Filter: ((ppurt_3.personpayunitreltype)::text = (pp_32.personpayunitreltype)::text)
413. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=4.86..22.37 rows=1 width=23) (never executed)

414. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=4.57..17.66 rows=1 width=23) (never executed)

415. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on person_pay_unit_rel pp_32 (cost=4.29..9.36 rows=1 width=23) (never executed)

  • Recheck Cond: (personid = '25992'::bpchar)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
416. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on pk_person_pay_unit_rel (cost=0.00..4.29 rows=2 width=0) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
417. 0.000 0.000 ↓ 0.0 0

Index Scan using pay_unit_pkey on pay_unit pu_3 (cost=0.28..8.29 rows=1 width=8) (never executed)

  • Index Cond: (payunitid = pp_32.payunitid)
418. 0.000 0.000 ↓ 0.0 0

Index Scan using positioncompany on position_desc pd_10 (cost=0.29..4.70 rows=1 width=8) (never executed)

  • Index Cond: ((companyid = pu_3.companyid) AND (positionid = 13973))
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
419. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1.14..3.08 rows=6 width=43) (never executed)

  • Hash Cond: (wr_9.rolename = ppurt_3.companyrolename)
420. 0.000 0.000 ↓ 0.0 0

Seq Scan on web_role wr_9 (cost=0.00..1.64 rows=64 width=9) (never executed)

421. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.06..1.06 rows=6 width=70) (never executed)

422. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_pay_unit_rel_type ppurt_3 (cost=0.00..1.06 rows=6 width=70) (never executed)

423. 0.000 0.000 ↓ 0.0 0

Result (cost=0.58..94.68 rows=6 width=85) (never executed)

424. 0.000 0.000 ↓ 0.0 0

Append (cost=0.58..94.62 rows=6 width=53) (never executed)

425. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1_11 (cost=0.58..16.67 rows=1 width=53) (never executed)

426. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.66 rows=1 width=137) (never executed)

427. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p_10 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = 13973) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
428. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_33 (cost=0.29..8.33 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = p_p_10.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '25992'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
429. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2_11 (cost=0.29..8.34 rows=1 width=53) (never executed)

430. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_34 (cost=0.29..8.33 rows=1 width=137) (never executed)

  • Index Cond: ((positionid = 13973) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '25992'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
431. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 3_4 (cost=0.58..16.67 rows=1 width=53) (never executed)

432. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.66 rows=1 width=137) (never executed)

433. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p_11 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = 13973) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
434. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_35 (cost=0.29..8.33 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = p_p_11.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '25992'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
435. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 4_3 (cost=0.87..17.23 rows=1 width=53) (never executed)

436. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.87..17.22 rows=1 width=137) (never executed)

437. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.66 rows=1 width=8) (never executed)

438. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p1_6 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = 13973) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
439. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p_12 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = p_p1_6.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
440. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_36 (cost=0.29..0.55 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = p_p_12.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '25992'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
441. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 5_3 (cost=1.16..17.64 rows=1 width=53) (never executed)

442. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.16..17.63 rows=1 width=137) (never executed)

443. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.87..17.07 rows=1 width=8) (never executed)

444. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.66 rows=1 width=8) (never executed)

445. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p2_4 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = 13973) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
446. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p1_7 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = p_p2_4.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
447. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p_13 (cost=0.29..0.41 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = p_p1_7.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
448. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_37 (cost=0.29..0.55 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = p_p_13.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '25992'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
449. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 6_3 (cost=1.45..18.06 rows=1 width=53) (never executed)

450. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.45..18.05 rows=1 width=137) (never executed)

451. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.16..17.49 rows=1 width=8) (never executed)

452. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.87..17.07 rows=1 width=8) (never executed)

453. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.66 rows=1 width=8) (never executed)

454. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p3_2 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = 13973) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
455. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p2_5 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = p_p3_2.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
456. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p1_8 (cost=0.29..0.41 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = p_p2_5.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
457. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p_14 (cost=0.29..0.41 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = p_p1_8.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
458. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_38 (cost=0.29..0.55 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = p_p_14.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '25992'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
459. 0.000 0.000 ↓ 0.0 0

Result (cost=0.87..52.97 rows=3 width=85) (never executed)

460. 0.000 0.000 ↓ 0.0 0

Append (cost=0.87..52.94 rows=3 width=53) (never executed)

461. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1_12 (cost=0.87..17.23 rows=1 width=53) (never executed)

462. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.87..17.22 rows=1 width=137) (never executed)

463. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.66 rows=1 width=8) (never executed)

464. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos py_3 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = 13973) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
465. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos px_3 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = py_3.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
466. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_39 (cost=0.29..0.55 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = px_3.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '25992'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
467. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2_12 (cost=1.16..17.65 rows=1 width=53) (never executed)

468. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.16..17.64 rows=1 width=137) (never executed)

469. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.87..17.07 rows=1 width=8) (never executed)

470. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.66 rows=1 width=8) (never executed)

471. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos pq_2 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = 13973) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
472. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos py_4 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = pq_2.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
473. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos px_4 (cost=0.29..0.41 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = py_4.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
474. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_40 (cost=0.29..0.56 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = px_4.positionid) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '25992'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
475. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 3_5 (cost=1.45..18.06 rows=1 width=53) (never executed)

476. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.45..18.05 rows=1 width=137) (never executed)

477. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.16..17.49 rows=1 width=8) (never executed)

478. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.87..17.07 rows=1 width=8) (never executed)

479. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.66 rows=1 width=8) (never executed)

480. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos pz_1 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = 13973) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
481. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos pq_3 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = pz_1.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
482. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos py_5 (cost=0.29..0.41 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = pq_3.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
483. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos px_5 (cost=0.29..0.41 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = py_5.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
484. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_41 (cost=0.29..0.55 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = px_5.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '25992'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
485. 0.000 0.000 ↓ 0.0 0

Result (cost=1.00..132.07 rows=2 width=89) (never executed)

486. 0.000 0.000 ↓ 0.0 0

Append (cost=1.00..132.05 rows=2 width=57) (never executed)

487. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1_13 (cost=1.00..105.05 rows=1 width=53) (never executed)

488. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.00..105.04 rows=1 width=137) (never executed)

  • Join Filter: (("*SELECT* 1_14".subjectid)::character(12) <> p_8.personid)
489. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..96.59 rows=1 width=92) (never executed)

  • Join Filter: (proxy_2.personid = "*SELECT* 1_14".userid)
490. 0.000 0.000 ↓ 0.0 0

Seq Scan on pers_pers proxy_2 (cost=0.00..1.91 rows=1 width=104) (never executed)

  • Filter: ((topersonid = '25992'::bpchar) AND (personreltype = 'ProxDMgr'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
491. 0.000 0.000 ↓ 0.0 0

Append (cost=0.58..94.60 rows=6 width=53) (never executed)

492. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1_14 (cost=0.58..16.67 rows=1 width=53) (never executed)

493. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.66 rows=1 width=137) (never executed)

494. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p_15 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = 13973) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
495. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_42 (cost=0.29..8.33 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = p_p_15.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
496. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2_14 (cost=0.29..8.34 rows=1 width=53) (never executed)

497. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_43 (cost=0.29..8.33 rows=1 width=137) (never executed)

  • Index Cond: ((positionid = 13973) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
498. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 3_6 (cost=0.58..16.67 rows=1 width=53) (never executed)

499. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.66 rows=1 width=137) (never executed)

500. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p_16 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = 13973) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
501. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_44 (cost=0.29..8.33 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = p_p_16.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
502. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 4_4 (cost=0.87..17.23 rows=1 width=53) (never executed)

503. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.87..17.22 rows=1 width=137) (never executed)

504. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.66 rows=1 width=8) (never executed)

505. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p1_9 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = 13973) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
506. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p_17 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = p_p1_9.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
507. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_45 (cost=0.29..0.55 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = p_p_17.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
508. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 5_4 (cost=1.16..17.64 rows=1 width=53) (never executed)

509. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.16..17.63 rows=1 width=137) (never executed)

510. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.87..17.07 rows=1 width=8) (never executed)

511. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.66 rows=1 width=8) (never executed)

512. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p2_6 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = 13973) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
513. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p1_10 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = p_p2_6.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
514. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p_18 (cost=0.29..0.41 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = p_p1_10.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
515. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_46 (cost=0.29..0.55 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = p_p_18.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
516. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 6_4 (cost=1.45..18.06 rows=1 width=53) (never executed)

517. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.45..18.05 rows=1 width=137) (never executed)

518. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.16..17.49 rows=1 width=8) (never executed)

519. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.87..17.07 rows=1 width=8) (never executed)

520. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.66 rows=1 width=8) (never executed)

521. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p3_3 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = 13973) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
522. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p2_7 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = p_p3_3.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
523. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p1_11 (cost=0.29..0.41 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = p_p2_7.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
524. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_pos_topositionid on pos_pos p_p_19 (cost=0.29..0.41 rows=1 width=8) (never executed)

  • Index Cond: ((topositionid = p_p1_11.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
525. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_47 (cost=0.29..0.55 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = p_p_19.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
526. 0.000 0.000 ↓ 0.0 0

Index Only Scan using person_pkey on person p_8 (cost=0.42..8.44 rows=1 width=13) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
  • Heap Fetches: 0
527. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2_13 (cost=0.99..27.00 rows=1 width=61) (never executed)

528. 0.000 0.000 ↓ 0.0 0

Nested Loop Anti Join (cost=0.99..26.99 rows=1 width=105) (never executed)

  • Join Filter: (pop_1.topositionid = pos_4.positionid)
529. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..18.67 rows=1 width=61) (never executed)

530. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..10.36 rows=1 width=57) (never executed)

531. 0.000 0.000 ↓ 0.0 0

Index Only Scan using person_pkey on person p_9 (cost=0.42..8.44 rows=1 width=13) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
  • Heap Fetches: 0
532. 0.000 0.000 ↓ 0.0 0

Seq Scan on pers_pers proxy_3 (cost=0.00..1.91 rows=1 width=96) (never executed)

  • Filter: ((topersonid = '25992'::bpchar) AND (personreltype = 'ProxDMgr1'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
533. 0.000 0.000 ↓ 0.0 0

Index Only Scan using position_pkey on "position" pos_4 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Index Cond: (positionid = 13973)
  • Heap Fetches: 0
534. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pos_pos_topositionid on pos_pos pop_1 (cost=0.29..8.30 rows=1 width=4) (never executed)

  • Index Cond: (topositionid = 13973)
  • Heap Fetches: 0
535. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=8.63..7,740.95 rows=1 width=85) (never executed)

536. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=8.34..7,732.61 rows=1 width=17) (never executed)

  • Hash Cond: ("*SELECT* 1_15".subjectid = pp_48.personid)
537. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..7,663.61 rows=16,172 width=26) (never executed)

538. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1_15 (cost=0.00..2,348.96 rows=14,311 width=26) (never executed)

539. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..2,205.85 rows=14,311 width=146) (never executed)

  • Join Filter: ((ar_3.personid <> pe_10.personid) AND (ar_3.personid <> pe_10.personid))
540. 0.000 0.000 ↓ 0.0 0

Seq Scan on assigned_roles ar_3 (cost=0.00..5.33 rows=1 width=13) (never executed)

  • Filter: ((rolename = 'HRGenLim'::bpchar) AND (personid = '25992'::bpchar))
541. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_employment pe_10 (cost=0.00..1,985.84 rows=14,312 width=13) (never executed)

  • Filter: ((effectivedate <= enddate) AND (CURRENT_DATE <= enddate))
542. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2_15 (cost=10.97..508.93 rows=421 width=26) (never executed)

543. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=10.97..504.72 rows=421 width=146) (never executed)

544. 0.000 0.000 ↓ 0.0 0

Index Scan using person_company_rel_pkey on person_company_rel pr_3 (cost=0.28..8.32 rows=1 width=17) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
  • Filter: ((personcompanyreltype = 'HRGL'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
545. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on person_employment pe_11 (cost=10.69..495.99 rows=41 width=17) (never executed)

  • Recheck Cond: ((companyid = pr_3.companyid) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (pr_3.personid <> personid) AND (pr_3.personid <> personid) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
546. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on employmentcompanyideffdt (cost=0.00..10.68 rows=185 width=0) (never executed)

  • Index Cond: ((companyid = pr_3.companyid) AND (CURRENT_DATE <= enddate))
547. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 3_7 (cost=1,755.15..1,801.35 rows=1 width=26) (never executed)

548. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1,755.15..1,801.34 rows=1 width=146) (never executed)

  • Join Filter: ((pl1_1.personid <> lp1_1.personid) AND (pe_12.personid = lp1_1.personid))
549. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1,754.74..1,800.55 rows=1 width=39) (never executed)

550. 0.000 0.000 ↓ 0.0 0

Index Only Scan using person_pkey on person pl1_1 (cost=0.42..8.44 rows=1 width=13) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
  • Heap Fetches: 0
551. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=1,754.32..1,773.22 rows=1,890 width=39) (never executed)

  • Group Key: pl_3.personid, lp_3.personid
552. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=8.27..1,744.87 rows=1,890 width=39) (never executed)

553. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=7.85..1,667.94 rows=108 width=26) (never executed)

  • Hash Cond: (lp_3.locationid = pl_3.locationid)
  • Join Filter: (pl_3.personid <> lp_3.personid)
554. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_locations lp_3 (cost=0.00..1,575.41 rows=22,220 width=17) (never executed)

  • Filter: ((personlocationtype = 'P'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
555. 0.000 0.000 ↓ 0.0 0

Hash (cost=7.84..7.84 rows=1 width=17) (never executed)

556. 0.000 0.000 ↓ 0.0 0

Index Scan using personlocationreltype on person_location_rel pl_3 (cost=0.28..7.84 rows=1 width=17) (never executed)

  • Index Cond: (personlocationreltype = 'HL'::bpchar)
  • Filter: ((personid = '25992'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
557. 0.000 0.000 ↓ 0.0 0

Index Only Scan using personemploymentenddate on person_employment pe_12 (cost=0.42..0.70 rows=1 width=13) (never executed)

  • Index Cond: ((personid = lp_3.personid) AND (enddate >= CURRENT_DATE))
  • Filter: (effectivedate <= enddate)
  • Heap Fetches: 0
558. 0.000 0.000 ↓ 0.0 0

Index Only Scan using person_pkey on person lp1_1 (cost=0.42..0.77 rows=1 width=13) (never executed)

  • Index Cond: (personid = lp_3.personid)
  • Heap Fetches: 0
559. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 4_5 (cost=1.96..1,501.39 rows=817 width=26) (never executed)

560. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.96..1,493.22 rows=817 width=146) (never executed)

561. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.54..643.24 rows=1,313 width=26) (never executed)

  • Join Filter: ((pp_49.personid <> op_4.personid) AND (pp_49.personid <> op_4.personid))
562. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.24..70.24 rows=1,270 width=17) (never executed)

563. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.90 rows=1 width=17) (never executed)

564. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pos_pkey on pers_pos pp_49 (cost=0.41..8.45 rows=1 width=17) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
565. 0.000 0.000 ↓ 0.0 0

Index Scan using posorgrelbyposition on pos_org_rel pr_4 (cost=0.41..8.44 rows=1 width=8) (never executed)

  • Index Cond: ((positionid = pp_49.positionid) AND (posorgreltype = 'HRGenLim'::bpchar))
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
566. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_org_rel_pkey on pos_org_rel ro_1 (cost=0.41..53.11 rows=23 width=8) (never executed)

  • Index Cond: (organizationid = pr_4.organizationid)
  • Filter: ((posorgreltype = 'Member'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
567. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos op_4 (cost=0.29..0.44 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = ro_1.positionid) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: (persposrel = 'Occupies'::bpchar)
568. 0.000 0.000 ↓ 0.0 0

Index Only Scan using personemploymentenddate on person_employment pe_13 (cost=0.42..0.64 rows=1 width=13) (never executed)

  • Index Cond: ((personid = op_4.personid) AND (enddate >= CURRENT_DATE))
  • Filter: (effectivedate <= enddate)
  • Heap Fetches: 0
569. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 5_5 (cost=9.72..274.90 rows=200 width=26) (never executed)

570. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=9.72..272.90 rows=200 width=146) (never executed)

  • Join Filter: (pp_50.personid <> op_5.personid)
571. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=9.43..186.31 rows=193 width=17) (never executed)

572. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on person_organization_rel pp_50 (cost=4.29..8.54 rows=1 width=17) (never executed)

  • Recheck Cond: (personid = '25992'::bpchar)
  • Filter: ((personorganizationreltype = 'HRGL'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
573. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on person_organization_rel_pkey (cost=0.00..4.29 rows=2 width=0) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
574. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pos_org_rel pr_5 (cost=5.14..177.54 rows=23 width=8) (never executed)

  • Recheck Cond: ((organizationid = pp_50.organizationid) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: (posorgreltype = 'Member'::bpchar)
575. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on posorgrelorganization (cost=0.00..5.13 rows=53 width=0) (never executed)

  • Index Cond: ((organizationid = pp_50.organizationid) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
576. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos op_5 (cost=0.29..0.44 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = pr_5.positionid) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: (persposrel = 'Occupies'::bpchar)
577. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 6_5 (cost=1,219.65..1,228.09 rows=422 width=26) (never executed)

578. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=1,219.65..1,223.87 rows=422 width=146) (never executed)

  • Group Key: p_10.personid, pe_14.personid, 'HRGenLim'::character(8), 'RoleEx_HRGenLimPreHi'::character(20)
579. 0.000 0.000 ↓ 0.0 0

Nested Loop Anti Join (cost=6.46..1,215.43 rows=422 width=146) (never executed)

580. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=6.04..763.19 rows=740 width=26) (never executed)

  • Join Filter: (p_10.personid <> pe_14.personid)
581. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=5.75..430.16 rows=573 width=17) (never executed)

582. 0.000 0.000 ↓ 0.0 0

Index Scan using person_company_rel_pkey on person_company_rel p_10 (cost=0.28..8.32 rows=1 width=17) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
  • Filter: ((personcompanyreltype = 'HRGL'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
583. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on position_desc pd_12 (cost=5.47..421.36 rows=48 width=8) (never executed)

  • Recheck Cond: (companyid = p_10.companyid)
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
584. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on positioncompany (cost=0.00..5.46 rows=156 width=0) (never executed)

  • Index Cond: (companyid = p_10.companyid)
585. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pe_14 (cost=0.29..0.57 rows=1 width=17) (never executed)

  • Index Cond: (positionid = pd_12.positionid)
586. 0.000 0.000 ↓ 0.0 0

Index Scan using personemploymentenddate on person_employment pep_1 (cost=0.41..0.61 rows=1 width=13) (never executed)

  • Index Cond: (personid = pe_14.personid)
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
587. 0.000 0.000 ↓ 0.0 0

Hash (cost=8.33..8.33 rows=1 width=17) (never executed)

588. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_48 (cost=0.29..8.33 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = 13973) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: ((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
589. 0.000 0.000 ↓ 0.0 0

Index Scan using position_desc_pkey on position_desc pd_11 (cost=0.29..8.33 rows=1 width=4) (never executed)

  • Index Cond: (positionid = 13973)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
590. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.54..33.70 rows=1 width=85) (never executed)

  • Join Filter: (pe_15.companyid = pd_13.companyid)
591. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.25..25.36 rows=1 width=17) (never executed)

592. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.90 rows=1 width=17) (never executed)

593. 0.000 0.000 ↓ 0.0 0

Index Only Scan using person_pkey on person p_11 (cost=0.42..8.44 rows=1 width=13) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
  • Heap Fetches: 0
594. 0.000 0.000 ↓ 0.0 0

Index Scan using personemploymentenddate on person_employment pe_15 (cost=0.42..8.46 rows=1 width=17) (never executed)

  • Index Cond: ((personid = '25992'::bpchar) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts) AND (emplstatus = ANY ('{A,L,P,C}'::bpchar[])))
595. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pos_pkey on pers_pos ppos_1 (cost=0.41..8.45 rows=1 width=13) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
596. 0.000 0.000 ↓ 0.0 0

Index Scan using position_desc_pkey on position_desc pd_13 (cost=0.29..8.33 rows=1 width=8) (never executed)

  • Index Cond: (positionid = 13973)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
597. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.85..35.63 rows=1 width=85) (never executed)

598. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..21.98 rows=1 width=21) (never executed)

599. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.29..13.65 rows=1 width=17) (never executed)

600. 0.000 0.000 ↓ 0.0 0

Seq Scan on assigned_roles u_3 (cost=0.00..5.33 rows=1 width=13) (never executed)

  • Filter: ((rolename = 'Onboard'::bpchar) AND (personid = '25992'::bpchar))
601. 0.000 0.000 ↓ 0.0 0

Index Only Scan using position_pkey on "position" pos_5 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Index Cond: (positionid = 13973)
  • Heap Fetches: 0
602. 0.000 0.000 ↓ 0.0 0

Index Scan using position_desc_pkey on position_desc pd_14 (cost=0.29..8.33 rows=1 width=8) (never executed)

  • Index Cond: (positionid = 13973)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
603. 0.000 0.000 ↓ 0.0 0

Index Scan using company_parameters_pkey on company_parameters cp_1 (cost=0.28..8.30 rows=1 width=4) (never executed)

  • Index Cond: ((companyid = pd_14.companyid) AND (companyparametername = 'InOnboard'::bpchar))
  • Filter: ((companyparametervalue)::text = 'Y'::text)
604. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..18.10 rows=1 width=85) (never executed)

  • Join Filter: (pcr_5.personcustomerreltype = pcrt_5.personcustomerreltype)
605. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..16.83 rows=1 width=23) (never executed)

606. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..16.65 rows=1 width=8) (never executed)

607. 0.000 0.000 ↓ 0.0 0

Index Scan using position_desc_pkey on position_desc pd_15 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: (positionid = 13973)
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
608. 0.000 0.000 ↓ 0.0 0

Index Scan using customercompany on customer_struct cs_1 (cost=0.28..8.31 rows=1 width=8) (never executed)

  • Index Cond: (companyid = pd_15.companyid)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
609. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_person_customer_rel on person_customer_rel pcr_5 (cost=0.14..0.17 rows=1 width=23) (never executed)

  • Index Cond: ((personid = '25992'::bpchar) AND (customerid = cs_1.customerid))
610. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_customer_rel_type pcrt_5 (cost=0.00..1.12 rows=12 width=60) (never executed)

611. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_51 (cost=0.29..8.33 rows=1 width=85) (never executed)

  • Index Cond: ((positionid = 13973) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '25992'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
612. 0.000 0.000 ↓ 0.0 0

Hash (cost=48.03..48.03 rows=2 width=9) (never executed)

613. 0.000 0.000 ↓ 0.0 0

Append (cost=0.56..48.03 rows=2 width=9) (never executed)

614. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1_9 (cost=0.56..19.89 rows=1 width=9) (never executed)

615. 0.000 0.000 ↓ 0.0 0

Nested Loop Anti Join (cost=0.56..19.88 rows=1 width=261) (never executed)

  • Join Filter: (((sc1_3.action)::text = (sc3_6.action)::text) AND ((sc3_6.domainobject)::text = (sc1_3.domainobject)::text) AND (sc3_6.rolename = sc1_3.rolename))
616. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_company_security_control on company_security_control sc1_3 (cost=0.28..8.34 rows=1 width=32) (never executed)

  • Index Cond: (((domainobject)::text = (this_.domainobject)::text) AND ((action)::text = (this_.action)::text) AND (companyid = 51786))
  • Filter: ((NOT negative) AND (roleinterest = 'X'::bpchar))
617. 0.000 0.000 ↓ 0.0 0

Index Only Scan using security_control_pkey1 on security_control sc3_6 (cost=0.29..11.50 rows=2 width=31) (never executed)

  • Index Cond: ((domainobject = (this_.domainobject)::text) AND (action = (this_.action)::text))
  • Heap Fetches: 0
618. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2_9 (cost=0.84..28.15 rows=1 width=9) (never executed)

619. 0.000 0.000 ↓ 0.0 0

Nested Loop Anti Join (cost=0.84..28.14 rows=1 width=261) (never executed)

  • Join Filter: ((sc3_7.companyid = c_3.companyid) AND ((sc3_7.domainobject)::text = (sc2_3.domainobject)::text) AND ((sc3_7.action)::text = (sc2_3.action)::text) AND (sc3_7.rolename = sc2_3.rolename))
620. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..19.81 rows=1 width=35) (never executed)

621. 0.000 0.000 ↓ 0.0 0

Index Scan using security_control_pkey1 on security_control sc2_3 (cost=0.29..11.51 rows=1 width=31) (never executed)

  • Index Cond: (((domainobject)::text = (this_.domainobject)::text) AND ((action)::text = (this_.action)::text))
  • Filter: (roleinterest = 'X'::bpchar)
622. 0.000 0.000 ↓ 0.0 0

Index Only Scan using company_pkey on company c_3 (cost=0.28..8.30 rows=1 width=4) (never executed)

  • Index Cond: (companyid = 51786)
  • Heap Fetches: 0
623. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_csc_neg_do_act on company_security_control sc3_7 (cost=0.28..8.30 rows=1 width=36) (never executed)

  • Index Cond: ((negative = true) AND ((domainobject)::text = (this_.domainobject)::text) AND ((action)::text = (this_.action)::text) AND (companyid = 51786))
  • Filter: negative
Planning time : 99.460 ms