explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mtef

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1.734 ↑ 3.0 2 1

Unique (cost=522,282.26..522,282.29 rows=6 width=22) (actual time=1.732..1.734 rows=2 loops=1)

  • Buffers: shared hit=138 read=10
2. 0.008 1.732 ↓ 1.5 9 1

Sort (cost=522,282.26..522,282.28 rows=6 width=22) (actual time=1.732..1.732 rows=9 loops=1)

  • Sort Key: this_.domainobject
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=138 read=10
3. 0.201 1.724 ↓ 1.5 9 1

Bitmap Heap Scan on security_control this_ (cost=5.25..522,282.18 rows=6 width=22) (actual time=1.492..1.724 rows=9 loops=1)

  • Filter: (((SubPlan 1) OR (SubPlan 6)) AND ((NOT (SubPlan 7)) OR (NOT (SubPlan 12))))
  • Buffers: shared hit=138 read=10
4. 0.001 0.497 ↓ 0.0 0 1

BitmapOr (cost=5.25..5.25 rows=10 width=0) (actual time=0.497..0.497 rows=0 loops=1)

  • Buffers: shared hit=6 read=2
5. 0.482 0.482 ↓ 2.0 4 1

Bitmap Index Scan on idx_sc_do_act (cost=0..1.3 rows=2 width=0) (actual time=0.482..0.482 rows=4 loops=1)

  • Index Cond: (((this_.domainobject)::text = 'PositionStructureItem'::text) AND ((this_.action)::text = 'Update'::text))
  • Buffers: shared read=2
6. 0.006 0.006 ↓ 2.0 4 1

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

  • Index Cond: (((this_.domainobject)::text = 'PositionStructureItem'::text) AND ((this_.action)::text = 'Update'::text))
  • Buffers: shared hit=2
7. 0.004 0.004 ↓ 1.7 5 1

Bitmap Index Scan on idx_sc_do_act (cost=0..1.31 rows=3 width=0) (actual time=0.004..0.004 rows=5 loops=1)

  • Index Cond: (((this_.domainobject)::text = 'PositionsList'::text) AND ((this_.action)::text = 'Update'::text))
  • Buffers: shared hit=2
8. 0.004 0.004 ↓ 1.7 5 1

Bitmap Index Scan on idx_sc_do_act (cost=0..1.31 rows=3 width=0) (actual time=0.004..0.004 rows=5 loops=1)

  • Index Cond: (((this_.domainobject)::text = 'PositionsList'::text) AND ((this_.action)::text = 'Update'::text))
  • Buffers: shared hit=2
9.          

SubPlan (forBitmap Heap Scan)

10. 0.000 0.891 ↑ 3.0 1 9

Nested Loop (cost=9.37..17.7 rows=3 width=0) (actual time=0.099..0.099 rows=1 loops=9)

  • Buffers: shared hit=69 read=7
11. 0.013 0.216 ↑ 1.0 3 9

Aggregate (cost=8.81..8.84 rows=3 width=168) (actual time=0.023..0.024 rows=3 loops=9)

  • Buffers: shared hit=16 read=2
12. 0.002 0.203 ↑ 1.0 3 1

Append (cost=0.14..8.78 rows=3 width=168) (actual time=0.009..0.203 rows=3 loops=1)

  • Buffers: shared hit=16 read=2
13. 0.010 0.010 ↓ 2.0 2 1

Index Only Scan using pk_assigned_roles on assigned_roles ar (cost=0.14..2.16 rows=1 width=67) (actual time=0.008..0.01 rows=2 loops=1)

  • Index Cond: (ar.personid = '5515'::bpchar)
  • Buffers: shared hit=4
14. 0.000 0.173 ↑ 1.0 1 1

Nested Loop (cost=0.84..2.88 rows=1 width=90) (actual time=0.173..0.173 rows=1 loops=1)

  • Buffers: shared hit=6 read=2
15. 0.167 0.167 ↑ 1.0 1 1

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

  • Index Cond: (p.personid = '5515'::bpchar)
  • Buffers: shared hit=2 read=2
16. 0.006 0.006 ↑ 1.0 1 1

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

  • Index Cond: (p2.personid = '5515'::bpchar)
  • Buffers: shared hit=4
17. 0.000 0.018 ↓ 0.0 0 1

Nested Loop (cost=1.5..3.7 rows=1 width=94) (actual time=0.018..0.018 rows=0 loops=1)

  • Buffers: shared hit=6
18. 0.005 0.005 ↑ 1.0 1 1

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

  • Index Cond: (p_1.personid = '5515'::bpchar)
  • Buffers: shared hit=4
19. 0.005 0.013 ↓ 0.0 0 1

Hash Join (cost=1.08..2.25 rows=1 width=13) (actual time=0.013..0.013 rows=0 loops=1)

  • Buffers: shared hit=2
20. 0.004 0.004 ↑ 12.0 1 1

Seq Scan on person_customer_rel_type pcrt (cost=0..1.12 rows=12 width=6) (actual time=0.004..0.004 rows=1 loops=1)

  • Filter: (pcrt.rolename IS NOT NULL)
  • Buffers: shared hit=1
21. 0.001 0.004 ↓ 0.0 0 1

Hash (cost=1.06..1.06 rows=1 width=19) (actual time=0.004..0.004 rows=0 loops=1)

  • Buffers: shared hit=1
22. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on person_customer_rel pcr (cost=0..1.06 rows=1 width=19) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((pcr.personid = '5515'::bpchar) AND (CURRENT_DATE >= pcr.effectivedate) AND (CURRENT_DATE <= pcr.enddate) AND (CURRENT_TIMESTAMP >= pcr.createts) AND (CURRENT_TIMESTAMP <= pcr.endts))
  • Buffers: shared hit=1
23. 0.018 0.675 ↓ 1.3 4 27

Materialize (cost=0.56..8.7 rows=3 width=9) (actual time=0.024..0.025 rows=4 loops=27)

  • Buffers: shared hit=53 read=5
24. 0.000 0.657 ↓ 1.7 5 9

Append (cost=0.56..8.69 rows=3 width=9) (actual time=0.07..0.073 rows=5 loops=9)

  • Buffers: shared hit=53 read=5
25. 0.009 0.351 ↓ 0.0 0 9

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

  • Buffers: shared hit=16 read=2
26. 0.000 0.342 ↓ 0.0 0 9

Nested Loop (cost=0.56..3.66 rows=1 width=261) (actual time=0.038..0.038 rows=0 loops=9)

  • Buffers: shared hit=16 read=2
27. 0.342 0.342 ↓ 0.0 0 9

Index Scan using idx_csc_neg_do_act on company_security_control sc1 (cost=0.28..2.3 rows=1 width=31) (actual time=0.038..0.038 rows=0 loops=9)

  • Index Cond: ((sc1.negative = false) AND ((sc1.domainobject)::text = (this_.domainobject)::text) AND ((sc1.action)::text = (this_.action)::text) AND (sc1.companyid = 1596))
  • Filter: (NOT sc1.negative)
  • Buffers: shared hit=16 read=2
28. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((sc3.domainobject = (this_.domainobject)::text) AND (sc3.action = (this_.action)::text))
29. 0.009 0.306 ↓ 2.5 5 9

Subquery Scan on *SELECT* 2 (cost=0.84..5.02 rows=2 width=9) (actual time=0.031..0.034 rows=5 loops=9)

  • Buffers: shared hit=37 read=3
30. 0.004 0.297 ↓ 2.5 5 9

Nested Loop (cost=0.84..5 rows=2 width=261) (actual time=0.031..0.033 rows=5 loops=9)

  • Buffers: shared hit=37 read=3
31. 0.000 0.252 ↓ 2.5 5 9

Nested Loop (cost=0.56..2.65 rows=2 width=35) (actual time=0.026..0.028 rows=5 loops=9)

  • Buffers: shared hit=20 read=2
32. 0.054 0.054 ↓ 2.5 5 9

Index Only Scan using pk_security_control on security_control sc2 (cost=0.29..1.33 rows=2 width=31) (actual time=0.006..0.006 rows=5 loops=9)

  • Index Cond: ((sc2.domainobject = (this_.domainobject)::text) AND (sc2.action = (this_.action)::text))
  • Buffers: shared hit=18 read=1
33. 0.025 0.205 ↑ 1.0 1 41

Materialize (cost=0.28..1.3 rows=1 width=4) (actual time=0.004..0.005 rows=1 loops=41)

  • Buffers: shared hit=2 read=1
34. 0.180 0.180 ↑ 1.0 1 1

Index Only Scan using pk_company on company c (cost=0.28..1.3 rows=1 width=4) (actual time=0.18..0.18 rows=1 loops=1)

  • Index Cond: (c.companyid = 1596)
  • Buffers: shared hit=2 read=1
35. 0.005 0.041 ↓ 0.0 0 41

Materialize (cost=0.28..2.31 rows=1 width=35) (actual time=0.001..0.001 rows=0 loops=41)

  • Buffers: shared hit=17 read=1
36. 0.036 0.036 ↓ 0.0 0 9

Index Scan using idx_csc_neg_do_act on company_security_control sc3_1 (cost=0.28..2.3 rows=1 width=35) (actual time=0.004..0.004 rows=0 loops=9)

  • Index Cond: ((sc3_1.negative = true) AND ((sc3_1.domainobject)::text = (this_.domainobject)::text) AND ((sc3_1.action)::text = (this_.action)::text) AND (sc3_1.companyid = 1596))
  • Filter: sc3_1.negative
  • Buffers: shared hit=17 read=1
37. 0.000 0.000 ↓ 0.0 0 0

Hash Join (cost=26,098.98..26,099.53 rows=3 width=0) (never executed)

38. 0.000 0.000 ↓ 0.0 0 0

Aggregate (cost=26,090.25..26,090.48 rows=23 width=120) (never executed)

39. 0.000 0.000 ↓ 0.0 0 0

Append (cost=0.56..26,090.02 rows=23 width=120) (never executed)

40. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.56..3.61 rows=1 width=58) (never executed)

41. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using pk_assigned_roles on assigned_roles u (cost=0.14..2.16 rows=1 width=22) (never executed)

  • Index Cond: ((u.personid = '5515'::bpchar) AND (u.rolename = 'HRAdmin'::bpchar))
42. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using pk_position on position pos (cost=0.42..1.44 rows=1 width=4) (never executed)

  • Index Cond: (pos.positionid = 215579)
43. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=5.96..7.36 rows=1 width=58) (never executed)

44. 0.000 0.000 ↓ 0.0 0 0

Hash Join (cost=5.82..7.09 rows=1 width=26) (never executed)

45. 0.000 0.000 ↓ 0.0 0 0

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

46. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=5.81..5.81 rows=1 width=23) (never executed)

47. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.7..5.81 rows=1 width=23) (never executed)

48. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_position_desc on position_desc pd (cost=0.42..3.48 rows=1 width=8) (never executed)

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

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

  • Index Cond: ((pcr_1.companyid = pd.companyid) AND (pcr_1.personid = '5515'::bpchar))
  • Filter: ((CURRENT_DATE >= pcr_1.effectivedate) AND (CURRENT_DATE <= pcr_1.enddate) AND (CURRENT_TIMESTAMP >= pcr_1.createts) AND (CURRENT_TIMESTAMP <= pcr_1.endts))
50. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (wr.rolename = pcrt_1.rolename)
51. 0.000 0.000 ↓ 0.0 0 0

Subquery Scan on r_positionlocationroles (cost=22.81..22.86 rows=2 width=124) (never executed)

52. 0.000 0.000 ↓ 0.0 0 0

Unique (cost=22.81..22.84 rows=2 width=176) (never executed)

53. 0.000 0.000 ↓ 0.0 0 0

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

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

Append (cost=0.84..22.8 rows=2 width=176) (never executed)

55. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..14.84 rows=1 width=110) (never executed)

56. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.42..3.95 rows=1 width=26) (never executed)

57. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.28..3.45 rows=1 width=26) (never executed)

58. 0.000 0.000 ↓ 0.0 0 0

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

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

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

60. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using pk_web_role on web_role wr_1 (cost=0.14..0.49 rows=1 width=9) (never executed)

  • Index Cond: (wr_1.rolename = plrt.rolename)
61. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_position_location on position_location pl (cost=0.42..10.88 rows=1 width=8) (never executed)

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

SubPlan (forIndex Scan)

63. 0.000 0.000 ↓ 0.0 0 0

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

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

Index Scan using pers_pospositionid on pers_pos pp_1 (cost=0.42..9,103.48 rows=23,859 width=4) (never executed)

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

Nested Loop (cost=0.85..5.95 rows=1 width=0) (never executed)

66. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

Gather (cost=1,000.42..16,566.32 rows=102 width=4) (never executed)

69. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.42..15,556.12 rows=42 width=4) (never executed)

70. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on person_employment pe_1 (cost=0..15,063.08 rows=219 width=13) (never executed)

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

Index Scan using pers_pospersendeff on pers_pos pp_3 (cost=0.42..2.24 rows=1 width=17) (never executed)

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

Nested Loop (cost=1.26..7.94 rows=1 width=110) (never executed)

73. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.12..7.44 rows=1 width=26) (never executed)

74. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.12..6.3 rows=1 width=26) (never executed)

75. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..5.97 rows=1 width=8) (never executed)

76. 0.000 0.000 ↓ 0.0 0 0

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

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

Index Scan using pk_person_locations on person_locations lp (cost=0.42..3.49 rows=1 width=17) (never executed)

  • Index Cond: (lp.personid = pp_4.personid)
  • Filter: ((lp.effectivedate <= lp.enddate) AND (lp.personlocationtype = 'P'::bpchar) AND (CURRENT_DATE <= lp.enddate) AND (CURRENT_TIMESTAMP >= lp.createts) AND (CURRENT_TIMESTAMP <= lp.endts))
78. 0.000 0.000 ↓ 0.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: ((plr_1.personid = '5515'::bpchar) AND (plr_1.locationid = lp.locationid))
  • Filter: ((CURRENT_DATE >= plr_1.effectivedate) AND (CURRENT_DATE <= plr_1.enddate) AND (CURRENT_TIMESTAMP >= plr_1.createts) AND (CURRENT_TIMESTAMP <= plr_1.endts))
79. 0.000 0.000 ↓ 0.0 0 0

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

80. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using pk_web_role on web_role wr_2 (cost=0.14..0.49 rows=1 width=9) (never executed)

  • Index Cond: (wr_2.rolename = plrt_1.rolename)
81. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.12..9.42 rows=1 width=58) (never executed)

82. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.7..5.92 rows=1 width=26) (never executed)

83. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.28..3.45 rows=1 width=26) (never executed)

84. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_person_organization_rel on person_organization_rel po (cost=0.28..2.31 rows=1 width=22) (never executed)

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

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

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

Index Scan using posorgrelbyposition on pos_org_rel op (cost=0.42..2.46 rows=1 width=8) (never executed)

  • Index Cond: ((op.positionid = 215579) AND (op.posorgreltype = 'Member'::bpchar))
  • Filter: ((op.effectivedate <= op.enddate) AND (CURRENT_DATE <= op.enddate) AND (CURRENT_TIMESTAMP >= op.createts) AND (CURRENT_TIMESTAMP <= op.endts))
87. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_position_desc on position_desc pd_1 (cost=0.42..3.49 rows=1 width=4) (never executed)

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

Result (cost=1.4..15.58 rows=2 width=58) (never executed)

89. 0.000 0.000 ↓ 0.0 0 0

Append (cost=1.4..15.56 rows=2 width=26) (never executed)

90. 0.000 0.000 ↓ 0.0 0 0

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

91. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.4..7.07 rows=1 width=110) (never executed)

92. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.26..6.57 rows=1 width=26) (never executed)

93. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.26..5.43 rows=1 width=23) (never executed)

94. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.12..5.24 rows=1 width=12) (never executed)

95. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.85..4.95 rows=1 width=8) (never executed)

96. 0.000 0.000 ↓ 0.0 0 0

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

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

Index Scan using pk_person_payroll on person_payroll ep (cost=0.42..2.46 rows=1 width=17) (never executed)

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

Index Only Scan using pk_pay_unit on pay_unit pu (cost=0.27..0.29 rows=1 width=4) (never executed)

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

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

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

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

101. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using pk_web_role on web_role wr_3 (cost=0.14..0.49 rows=1 width=9) (never executed)

  • Index Cond: (wr_3.rolename = ppurt.rolename)
102. 0.000 0.000 ↓ 0.0 0 0

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

103. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.98..8.47 rows=1 width=110) (never executed)

104. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..7.97 rows=1 width=26) (never executed)

105. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..6.83 rows=1 width=23) (never executed)

106. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.7..6.22 rows=3 width=8) (never executed)

107. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_position_desc on position_desc pd_2 (cost=0.42..3.48 rows=1 width=8) (never executed)

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

Index Scan using payunitcompany on pay_unit pu_1 (cost=0.27..2.72 rows=2 width=8) (never executed)

  • Index Cond: (pu_1.companyid = pd_2.companyid)
109. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_person_pay_unit_rel on person_pay_unit_rel pp_6 (cost=0.14..0.2 rows=1 width=23) (never executed)

  • Index Cond: ((pp_6.personid = '5515'::bpchar) AND (pp_6.payunitid = pu_1.payunitid))
  • Filter: ((CURRENT_DATE >= pp_6.effectivedate) AND (CURRENT_DATE <= pp_6.enddate) AND (CURRENT_TIMESTAMP >= pp_6.createts) AND (CURRENT_TIMESTAMP <= pp_6.endts))
110. 0.000 0.000 ↓ 0.0 0 0

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

111. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using pk_web_role on web_role wr_4 (cost=0.14..0.49 rows=1 width=9) (never executed)

  • Index Cond: (wr_4.rolename = ppurt_1.companyrolename)
112. 0.000 0.000 ↓ 0.0 0 0

Result (cost=0.85..30.45 rows=6 width=85) (never executed)

113. 0.000 0.000 ↓ 0.0 0 0

Append (cost=0.85..30.39 rows=6 width=53) (never executed)

114. 0.000 0.000 ↓ 0.0 0 0

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

115. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.85..4.93 rows=1 width=137) (never executed)

116. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pers_pospersendeff on pers_pos pp_7 (cost=0.42..2.46 rows=1 width=17) (never executed)

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

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

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

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

119. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_pers_pos on pers_pos pp_8 (cost=0.42..2.47 rows=1 width=137) (never executed)

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

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

121. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.85..4.93 rows=1 width=137) (never executed)

122. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pers_pospersendeff on pers_pos pp_9 (cost=0.42..2.46 rows=1 width=17) (never executed)

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

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

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

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

125. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.27..5.48 rows=1 width=137) (never executed)

126. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..4.94 rows=1 width=8) (never executed)

127. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

Index Scan using pk_pers_pos on pers_pos pp_10 (cost=0.42..0.53 rows=1 width=17) (never executed)

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

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

131. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.69..6 rows=1 width=137) (never executed)

132. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.27..5.46 rows=1 width=8) (never executed)

133. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..4.94 rows=1 width=8) (never executed)

134. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

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

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

Index Scan using pk_pers_pos on pers_pos pp_11 (cost=0.42..0.53 rows=1 width=17) (never executed)

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

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

139. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=2.11..6.52 rows=1 width=137) (never executed)

140. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.69..5.98 rows=1 width=8) (never executed)

141. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.27..5.46 rows=1 width=8) (never executed)

142. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..4.94 rows=1 width=8) (never executed)

143. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

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

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

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

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

Index Scan using pk_pers_pos on pers_pos pp_12 (cost=0.42..0.53 rows=1 width=17) (never executed)

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

Result (cost=1.27..18.06 rows=3 width=85) (never executed)

149. 0.000 0.000 ↓ 0.0 0 0

Append (cost=1.27..18.03 rows=3 width=53) (never executed)

150. 0.000 0.000 ↓ 0.0 0 0

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

151. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.27..5.48 rows=1 width=137) (never executed)

152. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..4.94 rows=1 width=8) (never executed)

153. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

Index Scan using pk_pers_pos on pers_pos pp_13 (cost=0.42..0.53 rows=1 width=17) (never executed)

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

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

157. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.69..6 rows=1 width=137) (never executed)

158. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.27..5.46 rows=1 width=8) (never executed)

159. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..4.94 rows=1 width=8) (never executed)

160. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

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

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

Index Scan using pk_pers_pos on pers_pos pp_14 (cost=0.42..0.53 rows=1 width=17) (never executed)

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

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

165. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=2.11..6.52 rows=1 width=137) (never executed)

166. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.69..5.98 rows=1 width=8) (never executed)

167. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.27..5.46 rows=1 width=8) (never executed)

168. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..4.94 rows=1 width=8) (never executed)

169. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

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

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

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

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

Index Scan using pk_pers_pos on pers_pos pp_15 (cost=0.42..0.53 rows=1 width=17) (never executed)

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

Result (cost=1.42..40.75 rows=2 width=89) (never executed)

175. 0.000 0.000 ↓ 0.0 0 0

Append (cost=1.42..40.73 rows=2 width=57) (never executed)

176. 0.000 0.000 ↓ 0.0 0 0

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

177. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.42..34.15 rows=1 width=137) (never executed)

178. 0.000 0.000 ↓ 0.0 0 0

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

179. 0.000 0.000 ↓ 0.0 0 0

Index Scan using persperstopersonid on pers_pers proxy (cost=0.15..2.19 rows=1 width=104) (never executed)

  • Index Cond: ((proxy.topersonid = '5515'::bpchar) AND (CURRENT_DATE >= proxy.effectivedate))
  • Filter: ((proxy.personreltype = 'ProxDMgr'::bpchar) AND (CURRENT_TIMESTAMP >= proxy.createts) AND (CURRENT_TIMESTAMP <= proxy.endts) AND (CURRENT_DATE <= proxy.enddate))
180. 0.000 0.000 ↓ 0.0 0 0

Append (cost=0.85..30.43 rows=6 width=53) (never executed)

181. 0.000 0.000 ↓ 0.0 0 0

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

182. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.85..4.94 rows=1 width=137) (never executed)

183. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

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

186. 0.000 0.000 ↓ 0.0 0 0

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

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

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

188. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.85..4.94 rows=1 width=137) (never executed)

189. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

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

192. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.27..5.48 rows=1 width=137) (never executed)

193. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..4.94 rows=1 width=8) (never executed)

194. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

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

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

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

198. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.69..6 rows=1 width=137) (never executed)

199. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.27..5.46 rows=1 width=8) (never executed)

200. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..4.94 rows=1 width=8) (never executed)

201. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

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

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

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

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

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

206. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=2.11..6.53 rows=1 width=137) (never executed)

207. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.69..5.98 rows=1 width=8) (never executed)

208. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.27..5.46 rows=1 width=8) (never executed)

209. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..4.94 rows=1 width=8) (never executed)

210. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (p_2.personid = '5515'::bpchar)
216. 0.000 0.000 ↓ 0.0 0 0

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

217. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.41..6.55 rows=1 width=105) (never executed)

218. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.99..5.08 rows=1 width=61) (never executed)

219. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.57..3.63 rows=1 width=57) (never executed)

220. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (p_3.personid = '5515'::bpchar)
221. 0.000 0.000 ↓ 0.0 0 0

Index Scan using persperstopersonid on pers_pers proxy_1 (cost=0.15..2.19 rows=1 width=96) (never executed)

  • Index Cond: ((proxy_1.topersonid = '5515'::bpchar) AND (CURRENT_DATE >= proxy_1.effectivedate))
  • Filter: ((proxy_1.personreltype = 'ProxDMgr1'::bpchar) AND (CURRENT_TIMESTAMP >= proxy_1.createts) AND (CURRENT_TIMESTAMP <= proxy_1.endts) AND (CURRENT_DATE <= proxy_1.enddate))
222. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using pk_position on position pos_1 (cost=0.42..1.44 rows=1 width=4) (never executed)

  • Index Cond: (pos_1.positionid = 215579)
223. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using pos_pos_topositionid on pos_pos pop (cost=0.42..1.45 rows=2 width=4) (never executed)

  • Index Cond: (pop.topositionid = 215579)
224. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=3.48..25,912.75 rows=1 width=85) (never executed)

225. 0.000 0.000 ↓ 0.0 0 0

Hash Join (cost=3.06..25,909.25 rows=1 width=17) (never executed)

226. 0.000 0.000 ↓ 0.0 0 0

Append (cost=0.57..25,508.75 rows=106,134 width=26) (never executed)

227. 0.000 0.000 ↓ 0.0 0 0

Subquery Scan on *SELECT* 1_7 (cost=0.57..13,042.15 rows=105,118 width=26) (never executed)

228. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.57..11,990.97 rows=105,118 width=146) (never executed)

229. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using pk_assigned_roles on assigned_roles ar_1 (cost=0.14..2.16 rows=1 width=13) (never executed)

  • Index Cond: ((ar_1.personid = '5515'::bpchar) AND (ar_1.rolename = 'HRGenLim'::bpchar))
230. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using personemploymentenddate on person_employment pe_2 (cost=0.42..10,412 rows=105,120 width=13) (never executed)

  • Index Cond: (pe_2.enddate >= CURRENT_DATE)
  • Filter: (pe_2.effectivedate <= pe_2.enddate)
231. 0.000 0.000 ↓ 0.0 0 0

Subquery Scan on *SELECT* 2_7 (cost=0.71..1,235.61 rows=571 width=26) (never executed)

232. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.71..1,229.9 rows=571 width=146) (never executed)

233. 0.000 0.000 ↓ 0.0 0 0

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

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

Index Scan using employmentcompanyideffdt on person_employment pe_3 (cost=0.42..1,223.04 rows=350 width=17) (never executed)

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

Subquery Scan on *SELECT* 3_3 (cost=8,168.77..8,173.54 rows=1 width=26) (never executed)

236. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=8,168.77..8,173.53 rows=1 width=146) (never executed)

237. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=8,168.35..8,173.07 rows=1 width=39) (never executed)

238. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (pl1.personid = '5515'::bpchar)
239. 0.000 0.000 ↓ 0.0 0 0

Aggregate (cost=8,167.93..8,169.78 rows=185 width=39) (never executed)

240. 0.000 0.000 ↓ 0.0 0 0

Gather (cost=1,002.75..8,167.01 rows=185 width=39) (never executed)

241. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=2.76..7,148.51 rows=109 width=39) (never executed)

242. 0.000 0.000 ↓ 0.0 0 0

Hash Join (cost=2.33..7,085.53 rows=126 width=26) (never executed)

243. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on person_locations lp_1 (cost=0..6,795.27 rows=76,361 width=17) (never executed)

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

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

245. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

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

  • Index Cond: (lp1.personid = pe_4.personid)
248. 0.000 0.000 ↓ 0.0 0 0

Subquery Scan on *SELECT* 4_2 (cost=2.13..391.54 rows=213 width=26) (never executed)

249. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=2.13..389.41 rows=213 width=146) (never executed)

250. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.7..263.11 rows=249 width=26) (never executed)

251. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.28..25.01 rows=446 width=17) (never executed)

252. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.85..4.52 rows=1 width=17) (never executed)

253. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pers_pospersendeff on pers_pos pp_23 (cost=0.43..2.45 rows=1 width=17) (never executed)

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

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

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

Index Scan using posorgrelorganization on pos_org_rel ro (cost=0.43..20.37 rows=11 width=8) (never executed)

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

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

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

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

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

Subquery Scan on *SELECT* 5_2 (cost=1.13..42.12 rows=20 width=26) (never executed)

259. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.13..41.92 rows=20 width=146) (never executed)

260. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.71..22.79 rows=36 width=17) (never executed)

261. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_person_organization_rel on person_organization_rel pp_24 (cost=0.28..2.31 rows=1 width=17) (never executed)

  • Index Cond: (pp_24.personid = '5515'::bpchar)
  • Filter: ((pp_24.personorganizationreltype = 'HRGL'::bpchar) AND (CURRENT_DATE >= pp_24.effectivedate) AND (CURRENT_DATE <= pp_24.enddate))
262. 0.000 0.000 ↓ 0.0 0 0

Index Scan using posorgrelorganization on pos_org_rel pr_2 (cost=0.43..20.37 rows=11 width=8) (never executed)

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

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

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

Subquery Scan on *SELECT* 6_2 (cost=2,620.62..2,623.79 rows=211 width=26) (never executed)

265. 0.000 0.000 ↓ 0.0 0 0

Unique (cost=2,620.62..2,621.68 rows=211 width=146) (never executed)

266. 0.000 0.000 ↓ 0.0 0 0

Sort (cost=2,620.62..2,621.15 rows=211 width=146) (never executed)

  • Sort Key: pe_6.personid
267. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.55..2,612.48 rows=211 width=146) (never executed)

268. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.13..1,854.73 rows=1,271 width=26) (never executed)

269. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.7..1,429.63 rows=764 width=17) (never executed)

270. 0.000 0.000 ↓ 0.0 0 0

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

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

Index Scan using positioncompany on position_desc pd_4 (cost=0.42..1,422.34 rows=394 width=8) (never executed)

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

Index Scan using pers_pospositionid on pers_pos pe_6 (cost=0.42..0.53 rows=2 width=17) (never executed)

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

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

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

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

275. 0.000 0.000 ↓ 0.0 0 0

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

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

Index Scan using pk_position_desc on position_desc pd_3 (cost=0.42..3.49 rows=1 width=4) (never executed)

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

Nested Loop (cost=1.69..10.92 rows=1 width=85) (never executed)

278. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.27..7.42 rows=1 width=17) (never executed)

279. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..4.95 rows=1 width=17) (never executed)

280. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (p_5.personid = '5515'::bpchar)
281. 0.000 0.000 ↓ 0.0 0 0

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

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

Index Scan using pers_pospersendeff on pers_pos ppos (cost=0.43..2.46 rows=1 width=13) (never executed)

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

Index Scan using pk_position_desc on position_desc pd_5 (cost=0.42..3.49 rows=1 width=8) (never executed)

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

Nested Loop (cost=1.27..9.46 rows=1 width=85) (never executed)

285. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.99..7.11 rows=1 width=21) (never executed)

286. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.56..3.61 rows=1 width=17) (never executed)

287. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using pk_assigned_roles on assigned_roles u_1 (cost=0.14..2.16 rows=1 width=13) (never executed)

  • Index Cond: ((u_1.personid = '5515'::bpchar) AND (u_1.rolename = 'Onboard'::bpchar))
288. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using pk_position on position pos_2 (cost=0.42..1.44 rows=1 width=4) (never executed)

  • Index Cond: (pos_2.positionid = 215579)
289. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_position_desc on position_desc pd_6 (cost=0.42..3.49 rows=1 width=8) (never executed)

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

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

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

Nested Loop (cost=2.79..6.1 rows=1 width=58) (never executed)

292. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_position_desc on position_desc pd_7 (cost=0.42..3.48 rows=1 width=8) (never executed)

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

Merge Join (cost=2.37..2.59 rows=3 width=26) (never executed)

294. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_customer_struct on customer_struct cs (cost=0.15..15.37 rows=282 width=8) (never executed)

  • Filter: ((CURRENT_DATE >= cs.effectivedate) AND (CURRENT_DATE <= cs.enddate) AND (CURRENT_TIMESTAMP >= cs.createts) AND (CURRENT_TIMESTAMP <= cs.endts))
295. 0.000 0.000 ↓ 0.0 0 0

Materialize (cost=2.22..2.23 rows=1 width=26) (never executed)

296. 0.000 0.000 ↓ 0.0 0 0

Sort (cost=2.22..2.23 rows=1 width=26) (never executed)

  • Sort Key: pcr_2.customerid
297. 0.000 0.000 ↓ 0.0 0 0

Hash Join (cost=1.04..2.21 rows=1 width=26) (never executed)

298. 0.000 0.000 ↓ 0.0 0 0

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

299. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=1.02..1.02 rows=1 width=23) (never executed)

300. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on person_customer_rel pcr_2 (cost=0..1.02 rows=1 width=23) (never executed)

  • Filter: (pcr_2.personid = '5515'::bpchar)
301. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_pers_pos on pers_pos pp_25 (cost=0.42..2.47 rows=1 width=85) (never executed)

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

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

303. 0.000 0.000 ↓ 0.0 0 0

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

304. 0.000 0.000 ↓ 0.0 0 0

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

305. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.56..3.66 rows=1 width=261) (never executed)

306. 0.000 0.000 ↓ 0.0 0 0

Index Scan using idx_csc_neg_do_act on company_security_control sc1_1 (cost=0.28..2.3 rows=1 width=31) (never executed)

  • Index Cond: ((sc1_1.negative = false) AND ((sc1_1.domainobject)::text = (this_.domainobject)::text) AND ((sc1_1.action)::text = (this_.action)::text) AND (sc1_1.companyid = 1596))
  • Filter: (NOT sc1_1.negative)
307. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((sc3_2.domainobject = (this_.domainobject)::text) AND (sc3_2.action = (this_.action)::text))
308. 0.000 0.000 ↓ 0.0 0 0

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

309. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..5 rows=2 width=261) (never executed)

310. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.56..2.65 rows=2 width=35) (never executed)

311. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((sc2_1.domainobject = (this_.domainobject)::text) AND (sc2_1.action = (this_.action)::text))
312. 0.000 0.000 ↓ 0.0 0 0

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

313. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (c_1.companyid = 1596)
314. 0.000 0.000 ↓ 0.0 0 0

Materialize (cost=0.28..2.31 rows=1 width=35) (never executed)

315. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((sc3_3.negative = true) AND ((sc3_3.domainobject)::text = (this_.domainobject)::text) AND ((sc3_3.action)::text = (this_.action)::text) AND (sc3_3.companyid = 1596))
  • Filter: sc3_3.negative
316. 0.000 0.135 ↓ 0.0 0 9

Nested Loop (cost=9.37..19.4 rows=2 width=0) (actual time=0.015..0.015 rows=0 loops=9)

  • Buffers: shared hit=63
317. 0.006 0.036 ↑ 1.0 3 9

Aggregate (cost=8.81..8.84 rows=3 width=168) (actual time=0.004..0.004 rows=3 loops=9)

  • Buffers: shared hit=18
318. 0.001 0.030 ↑ 1.0 3 1

Append (cost=0.14..8.78 rows=3 width=168) (actual time=0.004..0.03 rows=3 loops=1)

  • Buffers: shared hit=18
319. 0.005 0.005 ↓ 2.0 2 1

Index Only Scan using pk_assigned_roles on assigned_roles ar_2 (cost=0.14..2.16 rows=1 width=67) (actual time=0.004..0.005 rows=2 loops=1)

  • Index Cond: (ar_2.personid = '5515'::bpchar)
  • Buffers: shared hit=4
320. 0.001 0.012 ↑ 1.0 1 1

Nested Loop (cost=0.84..2.88 rows=1 width=90) (actual time=0.011..0.012 rows=1 loops=1)

  • Buffers: shared hit=8
321. 0.006 0.006 ↑ 1.0 1 1

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

  • Index Cond: (p_6.personid = '5515'::bpchar)
  • Buffers: shared hit=4
322. 0.005 0.005 ↑ 1.0 1 1

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

  • Index Cond: (p2_1.personid = '5515'::bpchar)
  • Buffers: shared hit=4
323. 0.000 0.012 ↓ 0.0 0 1

Nested Loop (cost=1.5..3.7 rows=1 width=94) (actual time=0.012..0.012 rows=0 loops=1)

  • Buffers: shared hit=6
324. 0.005 0.005 ↑ 1.0 1 1

Index Only Scan using person_pkey on person p_7 (cost=0.42..1.44 rows=1 width=13) (actual time=0.004..0.005 rows=1 loops=1)

  • Index Cond: (p_7.personid = '5515'::bpchar)
  • Buffers: shared hit=4
325. 0.003 0.007 ↓ 0.0 0 1

Hash Join (cost=1.08..2.25 rows=1 width=13) (actual time=0.007..0.007 rows=0 loops=1)

  • Buffers: shared hit=2
326. 0.002 0.002 ↑ 12.0 1 1

Seq Scan on person_customer_rel_type pcrt_3 (cost=0..1.12 rows=12 width=6) (actual time=0.002..0.002 rows=1 loops=1)

  • Filter: (pcrt_3.rolename IS NOT NULL)
  • Buffers: shared hit=1
327. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=1.06..1.06 rows=1 width=19) (actual time=0.002..0.002 rows=0 loops=1)

  • Buffers: shared hit=1
328. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on person_customer_rel pcr_3 (cost=0..1.06 rows=1 width=19) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((pcr_3.personid = '5515'::bpchar) AND (CURRENT_DATE >= pcr_3.effectivedate) AND (CURRENT_DATE <= pcr_3.enddate) AND (CURRENT_TIMESTAMP >= pcr_3.createts) AND (CURRENT_TIMESTAMP <= pcr_3.endts))
  • Buffers: shared hit=1
329. 0.018 0.108 ↓ 0.0 0 27

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

  • Buffers: shared hit=45
330. 0.000 0.090 ↓ 0.0 0 9

Append (cost=0.56..10.44 rows=2 width=9) (actual time=0.01..0.01 rows=0 loops=9)

  • Buffers: shared hit=45
331. 0.000 0.036 ↓ 0.0 0 9

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

  • Buffers: shared hit=18
332. 0.009 0.036 ↓ 0.0 0 9

Nested Loop (cost=0.56..3.67 rows=1 width=261) (actual time=0.004..0.004 rows=0 loops=9)

  • Buffers: shared hit=18
333. 0.027 0.027 ↓ 0.0 0 9

Index Scan using idx_csc_neg_do_act on company_security_control sc1_2 (cost=0.28..2.3 rows=1 width=31) (actual time=0.003..0.003 rows=0 loops=9)

  • Index Cond: ((sc1_2.negative = false) AND ((sc1_2.domainobject)::text = (this_.domainobject)::text) AND ((sc1_2.action)::text = (this_.action)::text) AND (sc1_2.companyid = 1596))
  • Filter: ((NOT sc1_2.negative) AND (sc1_2.roleinterest = 'X'::bpchar))
  • Buffers: shared hit=18
334. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((sc3_4.domainobject = (this_.domainobject)::text) AND (sc3_4.action = (this_.action)::text))
335. 0.009 0.054 ↓ 0.0 0 9

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

  • Buffers: shared hit=27
336. 0.000 0.045 ↓ 0.0 0 9

Nested Loop (cost=0.84..6.75 rows=1 width=261) (actual time=0.005..0.005 rows=0 loops=9)

  • Buffers: shared hit=27
337. 0.000 0.045 ↓ 0.0 0 9

Nested Loop (cost=0.56..4.43 rows=1 width=35) (actual time=0.005..0.005 rows=0 loops=9)

  • Buffers: shared hit=27
338. 0.045 0.045 ↓ 0.0 0 9

Index Scan using pk_security_control on security_control sc2_2 (cost=0.29..3.12 rows=1 width=31) (actual time=0.005..0.005 rows=0 loops=9)

  • Index Cond: (((sc2_2.domainobject)::text = (this_.domainobject)::text) AND ((sc2_2.action)::text = (this_.action)::text))
  • Filter: (sc2_2.roleinterest = 'X'::bpchar)
  • Buffers: shared hit=27
339. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (c_2.companyid = 1596)
340. 0.000 0.000 ↓ 0.0 0 0

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

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

Hash Join (cost=26,100.71..26,101.25 rows=2 width=0) (never executed)

342. 0.000 0.000 ↓ 0.0 0 0

Aggregate (cost=26,090.25..26,090.48 rows=23 width=120) (never executed)

343. 0.000 0.000 ↓ 0.0 0 0

Append (cost=0.56..26,090.02 rows=23 width=120) (never executed)

344. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.56..3.61 rows=1 width=58) (never executed)

345. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using pk_assigned_roles on assigned_roles u_2 (cost=0.14..2.16 rows=1 width=22) (never executed)

  • Index Cond: ((u_2.personid = '5515'::bpchar) AND (u_2.rolename = 'HRAdmin'::bpchar))
346. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using pk_position on position pos_3 (cost=0.42..1.44 rows=1 width=4) (never executed)

  • Index Cond: (pos_3.positionid = 215579)
347. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=5.96..7.36 rows=1 width=58) (never executed)

348. 0.000 0.000 ↓ 0.0 0 0

Hash Join (cost=5.82..7.09 rows=1 width=26) (never executed)

349. 0.000 0.000 ↓ 0.0 0 0

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

350. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=5.81..5.81 rows=1 width=23) (never executed)

351. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.7..5.81 rows=1 width=23) (never executed)

352. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_position_desc on position_desc pd_8 (cost=0.42..3.48 rows=1 width=8) (never executed)

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

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

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

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

  • Index Cond: (wr_5.rolename = pcrt_4.rolename)
355. 0.000 0.000 ↓ 0.0 0 0

Subquery Scan on r_positionlocationroles_1 (cost=22.81..22.86 rows=2 width=124) (never executed)

356. 0.000 0.000 ↓ 0.0 0 0

Unique (cost=22.81..22.84 rows=2 width=176) (never executed)

357. 0.000 0.000 ↓ 0.0 0 0

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

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

Append (cost=0.84..22.8 rows=2 width=176) (never executed)

359. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..14.84 rows=1 width=110) (never executed)

360. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.42..3.95 rows=1 width=26) (never executed)

361. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.28..3.45 rows=1 width=26) (never executed)

362. 0.000 0.000 ↓ 0.0 0 0

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

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

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

364. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using pk_web_role on web_role wr_6 (cost=0.14..0.49 rows=1 width=9) (never executed)

  • Index Cond: (wr_6.rolename = plrt_2.rolename)
365. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_position_location on position_location pl_2 (cost=0.42..10.88 rows=1 width=8) (never executed)

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

SubPlan (forIndex Scan)

367. 0.000 0.000 ↓ 0.0 0 0

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

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

Index Scan using pers_pospositionid on pers_pos pp_27 (cost=0.42..9,103.48 rows=23,859 width=4) (never executed)

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

Nested Loop (cost=0.85..5.95 rows=1 width=0) (never executed)

370. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

Gather (cost=1,000.42..16,566.32 rows=102 width=4) (never executed)

373. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.42..15,556.12 rows=42 width=4) (never executed)

374. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on person_employment pe_9 (cost=0..15,063.08 rows=219 width=13) (never executed)

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

Index Scan using pers_pospersendeff on pers_pos pp_29 (cost=0.42..2.24 rows=1 width=17) (never executed)

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

Nested Loop (cost=1.26..7.94 rows=1 width=110) (never executed)

377. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.12..7.44 rows=1 width=26) (never executed)

378. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.12..6.3 rows=1 width=26) (never executed)

379. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..5.97 rows=1 width=8) (never executed)

380. 0.000 0.000 ↓ 0.0 0 0

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

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

Index Scan using pk_person_locations on person_locations lp_2 (cost=0.42..3.49 rows=1 width=17) (never executed)

  • Index Cond: (lp_2.personid = pp_30.personid)
  • Filter: ((lp_2.effectivedate <= lp_2.enddate) AND (lp_2.personlocationtype = 'P'::bpchar) AND (CURRENT_DATE <= lp_2.enddate) AND (CURRENT_TIMESTAMP >= lp_2.createts) AND (CURRENT_TIMESTAMP <= lp_2.endts))
382. 0.000 0.000 ↓ 0.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: ((plr_3.personid = '5515'::bpchar) AND (plr_3.locationid = lp_2.locationid))
  • Filter: ((CURRENT_DATE >= plr_3.effectivedate) AND (CURRENT_DATE <= plr_3.enddate) AND (CURRENT_TIMESTAMP >= plr_3.createts) AND (CURRENT_TIMESTAMP <= plr_3.endts))
383. 0.000 0.000 ↓ 0.0 0 0

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

384. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using pk_web_role on web_role wr_7 (cost=0.14..0.49 rows=1 width=9) (never executed)

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

Nested Loop (cost=1.12..9.42 rows=1 width=58) (never executed)

386. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.7..5.92 rows=1 width=26) (never executed)

387. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.28..3.45 rows=1 width=26) (never executed)

388. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_person_organization_rel on person_organization_rel po_1 (cost=0.28..2.31 rows=1 width=22) (never executed)

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

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

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

Index Scan using posorgrelbyposition on pos_org_rel op_3 (cost=0.42..2.46 rows=1 width=8) (never executed)

  • Index Cond: ((op_3.positionid = 215579) AND (op_3.posorgreltype = 'Member'::bpchar))
  • Filter: ((op_3.effectivedate <= op_3.enddate) AND (CURRENT_DATE <= op_3.enddate) AND (CURRENT_TIMESTAMP >= op_3.createts) AND (CURRENT_TIMESTAMP <= op_3.endts))
391. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_position_desc on position_desc pd_9 (cost=0.42..3.49 rows=1 width=4) (never executed)

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

Result (cost=1.4..15.58 rows=2 width=58) (never executed)

393. 0.000 0.000 ↓ 0.0 0 0

Append (cost=1.4..15.56 rows=2 width=26) (never executed)

394. 0.000 0.000 ↓ 0.0 0 0

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

395. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.4..7.07 rows=1 width=110) (never executed)

396. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.26..6.57 rows=1 width=26) (never executed)

397. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.26..5.43 rows=1 width=23) (never executed)

398. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.12..5.24 rows=1 width=12) (never executed)

399. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.85..4.95 rows=1 width=8) (never executed)

400. 0.000 0.000 ↓ 0.0 0 0

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

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

Index Scan using pk_person_payroll on person_payroll ep_1 (cost=0.42..2.46 rows=1 width=17) (never executed)

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

Index Only Scan using pk_pay_unit on pay_unit pu_2 (cost=0.27..0.29 rows=1 width=4) (never executed)

  • Index Cond: (pu_2.payunitid = ep_1.payunitid)
403. 0.000 0.000 ↓ 0.0 0 0

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

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

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

405. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using pk_web_role on web_role wr_8 (cost=0.14..0.49 rows=1 width=9) (never executed)

  • Index Cond: (wr_8.rolename = ppurt_2.rolename)
406. 0.000 0.000 ↓ 0.0 0 0

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

407. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.98..8.47 rows=1 width=110) (never executed)

408. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..7.97 rows=1 width=26) (never executed)

409. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..6.83 rows=1 width=23) (never executed)

410. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.7..6.22 rows=3 width=8) (never executed)

411. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_position_desc on position_desc pd_10 (cost=0.42..3.48 rows=1 width=8) (never executed)

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

Index Scan using payunitcompany on pay_unit pu_3 (cost=0.27..2.72 rows=2 width=8) (never executed)

  • Index Cond: (pu_3.companyid = pd_10.companyid)
413. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_person_pay_unit_rel on person_pay_unit_rel pp_32 (cost=0.14..0.2 rows=1 width=23) (never executed)

  • Index Cond: ((pp_32.personid = '5515'::bpchar) AND (pp_32.payunitid = pu_3.payunitid))
  • Filter: ((CURRENT_DATE >= pp_32.effectivedate) AND (CURRENT_DATE <= pp_32.enddate) AND (CURRENT_TIMESTAMP >= pp_32.createts) AND (CURRENT_TIMESTAMP <= pp_32.endts))
414. 0.000 0.000 ↓ 0.0 0 0

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

415. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using pk_web_role on web_role wr_9 (cost=0.14..0.49 rows=1 width=9) (never executed)

  • Index Cond: (wr_9.rolename = ppurt_3.companyrolename)
416. 0.000 0.000 ↓ 0.0 0 0

Result (cost=0.85..30.45 rows=6 width=85) (never executed)

417. 0.000 0.000 ↓ 0.0 0 0

Append (cost=0.85..30.39 rows=6 width=53) (never executed)

418. 0.000 0.000 ↓ 0.0 0 0

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

419. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.85..4.93 rows=1 width=137) (never executed)

420. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pers_pospersendeff on pers_pos pp_33 (cost=0.42..2.46 rows=1 width=17) (never executed)

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

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

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

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

423. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_pers_pos on pers_pos pp_34 (cost=0.42..2.47 rows=1 width=137) (never executed)

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

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

425. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.85..4.93 rows=1 width=137) (never executed)

426. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pers_pospersendeff on pers_pos pp_35 (cost=0.42..2.46 rows=1 width=17) (never executed)

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

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

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

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

429. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.27..5.48 rows=1 width=137) (never executed)

430. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..4.94 rows=1 width=8) (never executed)

431. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

Index Scan using pk_pers_pos on pers_pos pp_36 (cost=0.42..0.53 rows=1 width=17) (never executed)

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

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

435. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.69..6 rows=1 width=137) (never executed)

436. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.27..5.46 rows=1 width=8) (never executed)

437. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..4.94 rows=1 width=8) (never executed)

438. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

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

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

Index Scan using pk_pers_pos on pers_pos pp_37 (cost=0.42..0.53 rows=1 width=17) (never executed)

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

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

443. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=2.11..6.52 rows=1 width=137) (never executed)

444. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.69..5.98 rows=1 width=8) (never executed)

445. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.27..5.46 rows=1 width=8) (never executed)

446. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..4.94 rows=1 width=8) (never executed)

447. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

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

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

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

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

Index Scan using pk_pers_pos on pers_pos pp_38 (cost=0.42..0.53 rows=1 width=17) (never executed)

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

Result (cost=1.27..18.06 rows=3 width=85) (never executed)

453. 0.000 0.000 ↓ 0.0 0 0

Append (cost=1.27..18.03 rows=3 width=53) (never executed)

454. 0.000 0.000 ↓ 0.0 0 0

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

455. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.27..5.48 rows=1 width=137) (never executed)

456. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..4.94 rows=1 width=8) (never executed)

457. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

Index Scan using pk_pers_pos on pers_pos pp_39 (cost=0.42..0.53 rows=1 width=17) (never executed)

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

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

461. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.69..6 rows=1 width=137) (never executed)

462. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.27..5.46 rows=1 width=8) (never executed)

463. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..4.94 rows=1 width=8) (never executed)

464. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

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

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

Index Scan using pk_pers_pos on pers_pos pp_40 (cost=0.42..0.53 rows=1 width=17) (never executed)

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

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

469. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=2.11..6.52 rows=1 width=137) (never executed)

470. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.69..5.98 rows=1 width=8) (never executed)

471. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.27..5.46 rows=1 width=8) (never executed)

472. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..4.94 rows=1 width=8) (never executed)

473. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

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

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

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

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

Index Scan using pk_pers_pos on pers_pos pp_41 (cost=0.42..0.53 rows=1 width=17) (never executed)

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

Result (cost=1.42..40.75 rows=2 width=89) (never executed)

479. 0.000 0.000 ↓ 0.0 0 0

Append (cost=1.42..40.73 rows=2 width=57) (never executed)

480. 0.000 0.000 ↓ 0.0 0 0

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

481. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.42..34.15 rows=1 width=137) (never executed)

482. 0.000 0.000 ↓ 0.0 0 0

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

483. 0.000 0.000 ↓ 0.0 0 0

Index Scan using persperstopersonid on pers_pers proxy_2 (cost=0.15..2.19 rows=1 width=104) (never executed)

  • Index Cond: ((proxy_2.topersonid = '5515'::bpchar) AND (CURRENT_DATE >= proxy_2.effectivedate))
  • Filter: ((proxy_2.personreltype = 'ProxDMgr'::bpchar) AND (CURRENT_TIMESTAMP >= proxy_2.createts) AND (CURRENT_TIMESTAMP <= proxy_2.endts) AND (CURRENT_DATE <= proxy_2.enddate))
484. 0.000 0.000 ↓ 0.0 0 0

Append (cost=0.85..30.43 rows=6 width=53) (never executed)

485. 0.000 0.000 ↓ 0.0 0 0

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

486. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.85..4.94 rows=1 width=137) (never executed)

487. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

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

490. 0.000 0.000 ↓ 0.0 0 0

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

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

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

492. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.85..4.94 rows=1 width=137) (never executed)

493. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

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

496. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.27..5.48 rows=1 width=137) (never executed)

497. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..4.94 rows=1 width=8) (never executed)

498. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

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

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

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

502. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.69..6 rows=1 width=137) (never executed)

503. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.27..5.46 rows=1 width=8) (never executed)

504. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..4.94 rows=1 width=8) (never executed)

505. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

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

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

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

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

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

510. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=2.11..6.53 rows=1 width=137) (never executed)

511. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.69..5.98 rows=1 width=8) (never executed)

512. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.27..5.46 rows=1 width=8) (never executed)

513. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..4.94 rows=1 width=8) (never executed)

514. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pos_pos_topositionid on pos_pos p_p3_3 (cost=0.42..2.46 rows=1 width=8) (never executed)

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

Index Scan using pos_pos_topositionid on pos_pos p_p2_7 (cost=0.42..2.46 rows=1 width=8) (never executed)

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

Index Scan using pos_pos_topositionid on pos_pos p_p1_11 (cost=0.42..0.51 rows=1 width=8) (never executed)

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

Index Scan using pos_pos_topositionid on pos_pos p_p_19 (cost=0.42..0.51 rows=1 width=8) (never executed)

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

Index Scan using pers_pospositionid on pers_pos pp_47 (cost=0.42..0.53 rows=1 width=17) (never executed)

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

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

  • Index Cond: (p_8.personid = '5515'::bpchar)
520. 0.000 0.000 ↓ 0.0 0 0

Subquery Scan on *SELECT* 2_13 (cost=1.41..6.56 rows=1 width=61) (never executed)

521. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.41..6.55 rows=1 width=105) (never executed)

522. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.99..5.08 rows=1 width=61) (never executed)

523. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.57..3.63 rows=1 width=57) (never executed)

524. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (p_9.personid = '5515'::bpchar)
525. 0.000 0.000 ↓ 0.0 0 0

Index Scan using persperstopersonid on pers_pers proxy_3 (cost=0.15..2.19 rows=1 width=96) (never executed)

  • Index Cond: ((proxy_3.topersonid = '5515'::bpchar) AND (CURRENT_DATE >= proxy_3.effectivedate))
  • Filter: ((proxy_3.personreltype = 'ProxDMgr1'::bpchar) AND (CURRENT_TIMESTAMP >= proxy_3.createts) AND (CURRENT_TIMESTAMP <= proxy_3.endts) AND (CURRENT_DATE <= proxy_3.enddate))
526. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using pk_position on position pos_4 (cost=0.42..1.44 rows=1 width=4) (never executed)

  • Index Cond: (pos_4.positionid = 215579)
527. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using pos_pos_topositionid on pos_pos pop_1 (cost=0.42..1.45 rows=2 width=4) (never executed)

  • Index Cond: (pop_1.topositionid = 215579)
528. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=3.48..25,912.75 rows=1 width=85) (never executed)

529. 0.000 0.000 ↓ 0.0 0 0

Hash Join (cost=3.06..25,909.25 rows=1 width=17) (never executed)

530. 0.000 0.000 ↓ 0.0 0 0

Append (cost=0.57..25,508.75 rows=106,134 width=26) (never executed)

531. 0.000 0.000 ↓ 0.0 0 0

Subquery Scan on *SELECT* 1_15 (cost=0.57..13,042.15 rows=105,118 width=26) (never executed)

532. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.57..11,990.97 rows=105,118 width=146) (never executed)

533. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using pk_assigned_roles on assigned_roles ar_3 (cost=0.14..2.16 rows=1 width=13) (never executed)

  • Index Cond: ((ar_3.personid = '5515'::bpchar) AND (ar_3.rolename = 'HRGenLim'::bpchar))
534. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using personemploymentenddate on person_employment pe_10 (cost=0.42..10,412 rows=105,120 width=13) (never executed)

  • Index Cond: (pe_10.enddate >= CURRENT_DATE)
  • Filter: (pe_10.effectivedate <= pe_10.enddate)
535. 0.000 0.000 ↓ 0.0 0 0

Subquery Scan on *SELECT* 2_15 (cost=0.71..1,235.61 rows=571 width=26) (never executed)

536. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.71..1,229.9 rows=571 width=146) (never executed)

537. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_person_company_rel on person_company_rel pr_3 (cost=0.28..3.36 rows=1 width=17) (never executed)

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

Index Scan using employmentcompanyideffdt on person_employment pe_11 (cost=0.42..1,223.04 rows=350 width=17) (never executed)

  • Index Cond: ((pe_11.companyid = pr_3.companyid) AND (CURRENT_DATE <= pe_11.enddate))
  • Filter: ((pe_11.effectivedate <= pe_11.enddate) AND (pr_3.personid <> pe_11.personid) AND (pr_3.personid <> pe_11.personid) AND (CURRENT_TIMESTAMP >= pe_11.createts) AND (CURRENT_TIMESTAMP <= pe_11.endts))
539. 0.000 0.000 ↓ 0.0 0 0

Subquery Scan on *SELECT* 3_7 (cost=8,168.77..8,173.54 rows=1 width=26) (never executed)

540. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=8,168.77..8,173.53 rows=1 width=146) (never executed)

541. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=8,168.35..8,173.07 rows=1 width=39) (never executed)

542. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (pl1_1.personid = '5515'::bpchar)
543. 0.000 0.000 ↓ 0.0 0 0

Aggregate (cost=8,167.93..8,169.78 rows=185 width=39) (never executed)

544. 0.000 0.000 ↓ 0.0 0 0

Gather (cost=1,002.75..8,167.01 rows=185 width=39) (never executed)

545. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=2.76..7,148.51 rows=109 width=39) (never executed)

546. 0.000 0.000 ↓ 0.0 0 0

Hash Join (cost=2.33..7,085.53 rows=126 width=26) (never executed)

547. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on person_locations lp_3 (cost=0..6,795.27 rows=76,361 width=17) (never executed)

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

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

549. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_person_location_rel on person_location_rel pl_3 (cost=0.28..2.32 rows=1 width=17) (never executed)

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

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

  • Index Cond: ((pe_12.personid = lp_3.personid) AND (pe_12.enddate >= CURRENT_DATE))
  • Filter: (pe_12.effectivedate <= pe_12.enddate)
551. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (lp1_1.personid = pe_12.personid)
552. 0.000 0.000 ↓ 0.0 0 0

Subquery Scan on *SELECT* 4_5 (cost=2.13..391.54 rows=213 width=26) (never executed)

553. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=2.13..389.41 rows=213 width=146) (never executed)

554. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.7..263.11 rows=249 width=26) (never executed)

555. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.28..25.01 rows=446 width=17) (never executed)

556. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.85..4.52 rows=1 width=17) (never executed)

557. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pers_pospersendeff on pers_pos pp_49 (cost=0.43..2.45 rows=1 width=17) (never executed)

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

Index Scan using posorgrelbyposition on pos_org_rel pr_4 (cost=0.42..2.06 rows=1 width=8) (never executed)

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

Index Scan using posorgrelorganization on pos_org_rel ro_1 (cost=0.43..20.37 rows=11 width=8) (never executed)

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

Index Scan using pers_pospositionid on pers_pos op_4 (cost=0.43..0.52 rows=1 width=17) (never executed)

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

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

  • Index Cond: ((pe_13.personid = op_4.personid) AND (pe_13.enddate >= CURRENT_DATE))
  • Filter: (pe_13.effectivedate <= pe_13.enddate)
562. 0.000 0.000 ↓ 0.0 0 0

Subquery Scan on *SELECT* 5_5 (cost=1.13..42.12 rows=20 width=26) (never executed)

563. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.13..41.92 rows=20 width=146) (never executed)

564. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.71..22.79 rows=36 width=17) (never executed)

565. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_person_organization_rel on person_organization_rel pp_50 (cost=0.28..2.31 rows=1 width=17) (never executed)

  • Index Cond: (pp_50.personid = '5515'::bpchar)
  • Filter: ((pp_50.personorganizationreltype = 'HRGL'::bpchar) AND (CURRENT_DATE >= pp_50.effectivedate) AND (CURRENT_DATE <= pp_50.enddate))
566. 0.000 0.000 ↓ 0.0 0 0

Index Scan using posorgrelorganization on pos_org_rel pr_5 (cost=0.43..20.37 rows=11 width=8) (never executed)

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

Index Scan using pers_pospositionid on pers_pos op_5 (cost=0.43..0.52 rows=1 width=17) (never executed)

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

Subquery Scan on *SELECT* 6_5 (cost=2,620.62..2,623.79 rows=211 width=26) (never executed)

569. 0.000 0.000 ↓ 0.0 0 0

Unique (cost=2,620.62..2,621.68 rows=211 width=146) (never executed)

570. 0.000 0.000 ↓ 0.0 0 0

Sort (cost=2,620.62..2,621.15 rows=211 width=146) (never executed)

  • Sort Key: pe_14.personid
571. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.55..2,612.48 rows=211 width=146) (never executed)

572. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.13..1,854.73 rows=1,271 width=26) (never executed)

573. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.7..1,429.63 rows=764 width=17) (never executed)

574. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_person_company_rel on person_company_rel p_10 (cost=0.28..3.36 rows=1 width=17) (never executed)

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

Index Scan using positioncompany on position_desc pd_12 (cost=0.42..1,422.34 rows=394 width=8) (never executed)

  • Index Cond: (pd_12.companyid = p_10.companyid)
  • Filter: ((pd_12.effectivedate <= pd_12.enddate) AND (CURRENT_TIMESTAMP >= pd_12.createts) AND (CURRENT_TIMESTAMP <= pd_12.endts))
576. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pers_pospositionid on pers_pos pe_14 (cost=0.42..0.53 rows=2 width=17) (never executed)

  • Index Cond: (pe_14.positionid = pd_12.positionid)
577. 0.000 0.000 ↓ 0.0 0 0

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

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

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

579. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pers_pospositionid on pers_pos pp_48 (cost=0.43..2.47 rows=1 width=17) (never executed)

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

Index Scan using pk_position_desc on position_desc pd_11 (cost=0.42..3.49 rows=1 width=4) (never executed)

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

Nested Loop (cost=1.69..10.92 rows=1 width=85) (never executed)

582. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.27..7.42 rows=1 width=17) (never executed)

583. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..4.95 rows=1 width=17) (never executed)

584. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (p_11.personid = '5515'::bpchar)
585. 0.000 0.000 ↓ 0.0 0 0

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

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

Index Scan using pers_pospersendeff on pers_pos ppos_1 (cost=0.43..2.46 rows=1 width=13) (never executed)

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

Index Scan using pk_position_desc on position_desc pd_13 (cost=0.42..3.49 rows=1 width=8) (never executed)

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

Nested Loop (cost=1.27..9.46 rows=1 width=85) (never executed)

589. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.99..7.11 rows=1 width=21) (never executed)

590. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.56..3.61 rows=1 width=17) (never executed)

591. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using pk_assigned_roles on assigned_roles u_3 (cost=0.14..2.16 rows=1 width=13) (never executed)

  • Index Cond: ((u_3.personid = '5515'::bpchar) AND (u_3.rolename = 'Onboard'::bpchar))
592. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using pk_position on position pos_5 (cost=0.42..1.44 rows=1 width=4) (never executed)

  • Index Cond: (pos_5.positionid = 215579)
593. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_position_desc on position_desc pd_14 (cost=0.42..3.49 rows=1 width=8) (never executed)

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

Index Scan using pk_company_parameters on company_parameters cp_1 (cost=0.28..2.3 rows=1 width=4) (never executed)

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

Nested Loop (cost=2.79..6.1 rows=1 width=58) (never executed)

596. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_position_desc on position_desc pd_15 (cost=0.42..3.48 rows=1 width=8) (never executed)

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

Merge Join (cost=2.37..2.59 rows=3 width=26) (never executed)

598. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_customer_struct on customer_struct cs_1 (cost=0.15..15.37 rows=282 width=8) (never executed)

  • Filter: ((CURRENT_DATE >= cs_1.effectivedate) AND (CURRENT_DATE <= cs_1.enddate) AND (CURRENT_TIMESTAMP >= cs_1.createts) AND (CURRENT_TIMESTAMP <= cs_1.endts))
599. 0.000 0.000 ↓ 0.0 0 0

Materialize (cost=2.22..2.23 rows=1 width=26) (never executed)

600. 0.000 0.000 ↓ 0.0 0 0

Sort (cost=2.22..2.23 rows=1 width=26) (never executed)

  • Sort Key: pcr_5.customerid
601. 0.000 0.000 ↓ 0.0 0 0

Hash Join (cost=1.04..2.21 rows=1 width=26) (never executed)

602. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on person_customer_rel_type pcrt_5 (cost=0..1.12 rows=12 width=15) (never executed)

603. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=1.02..1.02 rows=1 width=23) (never executed)

604. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on person_customer_rel pcr_5 (cost=0..1.02 rows=1 width=23) (never executed)

  • Filter: (pcr_5.personid = '5515'::bpchar)
605. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_pers_pos on pers_pos pp_51 (cost=0.42..2.47 rows=1 width=85) (never executed)

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

Hash (cost=10.44..10.44 rows=2 width=9) (never executed)

607. 0.000 0.000 ↓ 0.0 0 0

Append (cost=0.56..10.44 rows=2 width=9) (never executed)

608. 0.000 0.000 ↓ 0.0 0 0

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

609. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.56..3.67 rows=1 width=261) (never executed)

610. 0.000 0.000 ↓ 0.0 0 0

Index Scan using idx_csc_neg_do_act on company_security_control sc1_3 (cost=0.28..2.3 rows=1 width=31) (never executed)

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

Index Only Scan using pk_security_control on security_control sc3_6 (cost=0.29..1.33 rows=2 width=31) (never executed)

  • Index Cond: ((sc3_6.domainobject = (this_.domainobject)::text) AND (sc3_6.action = (this_.action)::text))
612. 0.000 0.000 ↓ 0.0 0 0

Subquery Scan on *SELECT* 2_9 (cost=0.84..6.76 rows=1 width=9) (never executed)

613. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..6.75 rows=1 width=261) (never executed)

614. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.56..4.43 rows=1 width=35) (never executed)

615. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_security_control on security_control sc2_3 (cost=0.29..3.12 rows=1 width=31) (never executed)

  • Index Cond: (((sc2_3.domainobject)::text = (this_.domainobject)::text) AND ((sc2_3.action)::text = (this_.action)::text))
  • Filter: (sc2_3.roleinterest = 'X'::bpchar)
616. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using pk_company on company c_3 (cost=0.28..1.3 rows=1 width=4) (never executed)

  • Index Cond: (c_3.companyid = 1596)
617. 0.000 0.000 ↓ 0.0 0 0

Index Scan using idx_csc_neg_do_act on company_security_control sc3_7 (cost=0.28..2.3 rows=1 width=35) (never executed)

  • Index Cond: ((sc3_7.negative = true) AND ((sc3_7.domainobject)::text = (this_.domainobject)::text) AND ((sc3_7.action)::text = (this_.action)::text) AND (sc3_7.companyid = 1596))
  • Filter: sc3_7.negative