explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3Bb

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

Unique (cost=550,594.47..550,594.5 rows=6 width=22) (actual time=5.446..5.448 rows=2 loops=1)

  • Buffers: shared hit=1036 read=4
2. 0.039 5.446 ↓ 1.5 9 1

Sort (cost=550,594.47..550,594.49 rows=6 width=22) (actual time=5.446..5.446 rows=9 loops=1)

  • Sort Key: this_.domainobject
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1036 read=4
3. 0.257 5.407 ↓ 1.5 9 1

Bitmap Heap Scan on security_control this_ (cost=5.25..550,594.39 rows=6 width=22) (actual time=5.157..5.407 rows=9 loops=1)

  • Filter: (((SubPlan 2) OR (SubPlan 7)) AND ((NOT (SubPlan 9)) OR (NOT (SubPlan 14))))
  • Buffers: shared hit=1033 read=4
4. 0.002 0.290 ↓ 0.0 0 1

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

  • Buffers: shared hit=7 read=1
5. 0.268 0.268 ↓ 2.0 4 1

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

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

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

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

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

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

Bitmap Index Scan on idx_sc_do_act (cost=0..1.31 rows=3 width=0) (actual time=0.006..0.006 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.027 4.725 ↑ 3.0 1 9

Hash Join (cost=1,427.96..1,428.08 rows=3 width=0) (actual time=0.525..0.525 rows=1 loops=9)

  • Buffers: shared hit=981 read=2
11. 0.009 4.149 ↑ 1.3 3 9

Aggregate (cost=1,419.23..1,419.27 rows=4 width=168) (actual time=0.461..0.461 rows=3 loops=9)

  • Buffers: shared hit=924 read=1
12. 0.002 4.140 ↑ 1.0 4 1

Append (cost=0.14..1,419.19 rows=4 width=168) (actual time=0.031..4.14 rows=4 loops=1)

  • Buffers: shared hit=924 read=1
13. 0.035 0.035 ↓ 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.03..0.035 rows=2 loops=1)

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

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

  • Buffers: shared hit=8
15. 0.039 0.039 ↑ 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.039..0.039 rows=1 loops=1)

  • Index Cond: (p.personid = '5515'::bpchar)
  • Buffers: shared hit=4
16. 0.011 0.011 ↑ 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.01..0.011 rows=1 loops=1)

  • Index Cond: (p2.personid = '5515'::bpchar)
  • Buffers: shared hit=4
17. 0.015 4.018 ↑ 1.0 1 1

Index Only Scan using person_pkey on person p_1 (cost=0.42..1,410.41 rows=1 width=94) (actual time=4.017..4.018 rows=1 loops=1)

  • Index Cond: (p_1.personid = '5515'::bpchar)
  • Filter: ((SubPlan 1) > 1)
  • Buffers: shared hit=906 read=1
18.          

SubPlan (forIndex Only Scan)

19. 0.221 4.003 ↑ 1.0 1 1

Aggregate (cost=1,408.96..1,408.97 rows=1 width=8) (actual time=4.003..4.003 rows=1 loops=1)

  • Buffers: shared hit=902 read=1
20. 0.126 3.782 ↓ 1.2 1,848 1

Merge Append (cost=1,146.84..1,389.47 rows=1,559 width=65) (actual time=0.576..3.782 rows=1,848 loops=1)

  • Buffers: shared hit=902 read=1
21. 0.405 3.141 ↓ 1.2 1,848 1

Unique (cost=0.43..196.53 rows=1,540 width=65) (actual time=0.057..3.141 rows=1,848 loops=1)

  • Buffers: shared hit=877
22. 0.762 2.736 ↓ 1.9 3,696 1

Nested Loop (cost=0.43..191.71 rows=1,930 width=65) (actual time=0.056..2.736 rows=3,696 loops=1)

  • Buffers: shared hit=877
23. 1.974 1.974 ↑ 1.0 1,848 1

Index Scan using pk_companyname on companyname co (cost=0.28..165.41 rows=1,930 width=4) (actual time=0.038..1.974 rows=1,848 loops=1)

  • Filter: ((CURRENT_DATE >= co.effectivedate) AND (CURRENT_DATE <= co.enddate) AND (CURRENT_TIMESTAMP >= co.createts) AND (CURRENT_TIMESTAMP <= co.endts))
  • Buffers: shared hit=873
24. 0.000 0.000 ↓ 2.0 2 1,848

Materialize (cost=0.14..2.17 rows=1 width=13) (actual time=0..0 rows=2 loops=1,848)

  • Buffers: shared hit=4
25. 0.014 0.014 ↓ 2.0 2 1

Index Only Scan using pk_assigned_roles on assigned_roles sr (cost=0.14..2.16 rows=1 width=13) (actual time=0.012..0.014 rows=2 loops=1)

  • Index Cond: (sr.personid = p_1.personid)
  • Buffers: shared hit=4
26. 0.001 0.265 ↓ 0.0 0 1

Unique (cost=6.8..6.81 rows=2 width=65) (actual time=0.265..0.265 rows=0 loops=1)

  • Buffers: shared hit=2 read=1
27. 0.013 0.264 ↓ 0.0 0 1

Sort (cost=6.8..6.81 rows=2 width=65) (actual time=0.264..0.264 rows=0 loops=1)

  • Sort Key: pr.companyid
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=2 read=1
28. 0.009 0.251 ↓ 0.0 0 1

Hash Join (cost=5.45..6.79 rows=2 width=65) (actual time=0.251..0.251 rows=0 loops=1)

  • Buffers: shared hit=2 read=1
29. 0.004 0.004 ↑ 18.0 1 1

Seq Scan on person_company_rel_type person_company_rel_type (cost=0..1.24 rows=18 width=6) (actual time=0.004..0.004 rows=1 loops=1)

  • Filter: (person_company_rel_type.personcompanyrelclass = 'MC'::bpchar)
  • Buffers: shared hit=1
30. 0.002 0.238 ↓ 0.0 0 1

Hash (cost=5.42..5.42 rows=2 width=23) (actual time=0.238..0.238 rows=0 loops=1)

  • Buffers: shared hit=1 read=1
31. 0.236 0.236 ↓ 0.0 0 1

Index Scan using pk_person_company_rel on person_company_rel pr (cost=0.28..5.42 rows=2 width=23) (actual time=0.236..0.236 rows=0 loops=1)

  • Index Cond: (pr.personid = p_1.personid)
  • Filter: ((CURRENT_DATE >= pr.effectivedate) AND (CURRENT_DATE <= pr.enddate) AND (CURRENT_TIMESTAMP >= pr.createts) AND (CURRENT_TIMESTAMP <= pr.endts))
  • Buffers: shared hit=1 read=1
32. 0.000 0.052 ↓ 0.0 0 1

Unique (cost=6.04..6.04 rows=1 width=65) (actual time=0.052..0.052 rows=0 loops=1)

  • Buffers: shared hit=3
33. 0.014 0.052 ↓ 0.0 0 1

Sort (cost=6.04..6.04 rows=1 width=65) (actual time=0.052..0.052 rows=0 loops=1)

  • Sort Key: oo.companyid
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=3
34. 0.004 0.038 ↓ 0.0 0 1

Nested Loop (cost=0.71..6.03 rows=1 width=65) (actual time=0.038..0.038 rows=0 loops=1)

  • Buffers: shared hit=3
35. 0.034 0.034 ↓ 0.0 0 1

Index Scan using personemploymentenddate on person_employment ep (cost=0.43..3.5 rows=1 width=17) (actual time=0.034..0.034 rows=0 loops=1)

  • Index Cond: ((ep.personid = p_1.personid) AND (CURRENT_DATE <= ep.enddate) AND (CURRENT_DATE >= ep.effectivedate))
  • Filter: ((ep.emplstatus = 'A'::bpchar) AND (CURRENT_TIMESTAMP >= ep.createts) AND (CURRENT_TIMESTAMP <= ep.endts))
  • Buffers: shared hit=3
36. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_company_company_rel on company_company_rel oo (cost=0.28..2.52 rows=1 width=4) (never executed)

  • Index Cond: ((oo.companyid = ep.companyid) AND (oo.companyreltype = 'Af'::bpchar))
  • Filter: ((CURRENT_DATE >= oo.effectivedate) AND (CURRENT_DATE <= oo.enddate) AND (CURRENT_TIMESTAMP >= oo.createts) AND (CURRENT_TIMESTAMP <= oo.endts))
37. 0.001 0.032 ↓ 0.0 0 1

Unique (cost=16.57..16.58 rows=3 width=65) (actual time=0.031..0.032 rows=0 loops=1)

  • Buffers: shared hit=2
38. 0.004 0.031 ↓ 0.0 0 1

Sort (cost=16.57..16.58 rows=3 width=65) (actual time=0.031..0.031 rows=0 loops=1)

  • Sort Key: ol.companyid
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=2
39. 0.002 0.027 ↓ 0.0 0 1

Nested Loop (cost=0.56..16.55 rows=3 width=65) (actual time=0.027..0.027 rows=0 loops=1)

  • Buffers: shared hit=2
40. 0.025 0.025 ↓ 0.0 0 1

Index Scan using pk_person_location_rel on person_location_rel pl (cost=0.28..9.59 rows=3 width=17) (actual time=0.025..0.025 rows=0 loops=1)

  • Index Cond: (pl.personid = p_1.personid)
  • Filter: ((CURRENT_DATE >= pl.effectivedate) AND (CURRENT_DATE <= pl.enddate) AND (CURRENT_TIMESTAMP >= pl.createts) AND (CURRENT_TIMESTAMP <= pl.endts))
  • Buffers: shared hit=2
41. 0.000 0.000 ↓ 0.0 0 0

Index Scan using locationcompanyid on company_location_rel ol (cost=0.28..2.31 rows=1 width=8) (never executed)

  • Index Cond: (ol.locationid = pl.locationid)
  • Filter: ((CURRENT_TIMESTAMP >= ol.createts) AND (CURRENT_TIMESTAMP <= ol.endts))
42. 0.001 0.041 ↓ 0.0 0 1

Unique (cost=239.55..239.56 rows=1 width=65) (actual time=0.041..0.041 rows=0 loops=1)

  • Buffers: shared hit=3
43. 0.007 0.040 ↓ 0.0 0 1

Sort (cost=239.55..239.56 rows=1 width=65) (actual time=0.04..0.04 rows=0 loops=1)

  • Sort Key: oc.companyid
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=3
44. 0.001 0.033 ↓ 0.0 0 1

Nested Loop (cost=1.14..239.54 rows=1 width=65) (actual time=0.033..0.033 rows=0 loops=1)

  • Buffers: shared hit=3
45. 0.004 0.032 ↓ 0.0 0 1

Nested Loop (cost=0.85..6.24 rows=1 width=17) (actual time=0.032..0.032 rows=0 loops=1)

  • Buffers: shared hit=3
46. 0.028 0.028 ↓ 0.0 0 1

Index Scan using pers_pospersendeff on pers_pos pc (cost=0.43..2.46 rows=1 width=17) (actual time=0.028..0.028 rows=0 loops=1)

  • Index Cond: ((pc.personid = p_1.personid) AND (CURRENT_DATE <= pc.enddate) AND (CURRENT_DATE >= pc.effectivedate))
  • Filter: ((pc.persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= pc.createts) AND (CURRENT_TIMESTAMP <= pc.endts))
  • Buffers: shared hit=3
47. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (por.positionid = pc.positionid)
  • Filter: ((CURRENT_DATE >= por.effectivedate) AND (CURRENT_DATE <= por.enddate) AND (CURRENT_TIMESTAMP >= por.createts) AND (CURRENT_TIMESTAMP <= por.endts) AND (por.posorgreltype = ANY ('{BAdmin,BenMgr,HRGen,PRMgr,PRSupr}'::bpchar[])))
48. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_company_organization_rel on company_organization_rel oc (cost=0.29..233.29 rows=1 width=8) (never executed)

  • Index Cond: (oc.organizationid = por.organizationid)
  • Filter: ((oc.companyorganizationreltype = 'Mem'::bpchar) AND (CURRENT_DATE >= oc.effectivedate) AND (CURRENT_DATE <= oc.enddate) AND (CURRENT_TIMESTAMP >= oc.createts) AND (CURRENT_TIMESTAMP <= oc.endts))
49. 0.001 0.015 ↓ 0.0 0 1

Unique (cost=3.48..3.49 rows=2 width=65) (actual time=0.015..0.015 rows=0 loops=1)

  • Buffers: shared hit=3
50. 0.006 0.014 ↓ 0.0 0 1

Sort (cost=3.48..3.49 rows=2 width=65) (actual time=0.014..0.014 rows=0 loops=1)

  • Sort Key: pe.companyid
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=3
51. 0.008 0.008 ↓ 0.0 0 1

Index Scan using personemploymentenddate on person_employment pe (cost=0.43..3.47 rows=2 width=65) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((pe.personid = p_1.personid) AND (CURRENT_DATE <= pe.enddate) AND (CURRENT_DATE >= pe.effectivedate))
  • Buffers: shared hit=3
52. 0.004 0.015 ↓ 0.0 0 1

Sort (cost=5.98..5.99 rows=1 width=65) (actual time=0.015..0.015 rows=0 loops=1)

  • Sort Key: pd.companyid
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=3
53. 0.003 0.011 ↓ 0.0 0 1

Nested Loop (cost=0.85..5.96 rows=1 width=65) (actual time=0.011..0.011 rows=0 loops=1)

  • Buffers: shared hit=3
54. 0.008 0.008 ↓ 0.0 0 1

Index Scan using pers_pospersendeff on pers_pos pp (cost=0.43..2.46 rows=1 width=17) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((pp.personid = p_1.personid) AND (CURRENT_DATE <= pp.enddate) AND (CURRENT_DATE >= pp.effectivedate))
  • Filter: ((CURRENT_TIMESTAMP >= pp.createts) AND (CURRENT_TIMESTAMP <= pp.endts))
  • Buffers: shared hit=3
55. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (pd.positionid = pp.positionid)
  • Filter: ((CURRENT_DATE >= pd.effectivedate) AND (CURRENT_DATE <= pd.enddate) AND (CURRENT_TIMESTAMP >= pd.createts) AND (CURRENT_TIMESTAMP <= pd.endts))
56. 0.000 0.026 ↓ 0.0 0 1

Unique (cost=858.29..858.31 rows=5 width=65) (actual time=0.026..0.026 rows=0 loops=1)

  • Buffers: shared hit=2
57. 0.006 0.026 ↓ 0.0 0 1

Sort (cost=858.29..858.3 rows=5 width=65) (actual time=0.026..0.026 rows=0 loops=1)

  • Sort Key: oc_1.companyid
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=2
58. 0.002 0.020 ↓ 0.0 0 1

Nested Loop (cost=0.56..858.23 rows=5 width=65) (actual time=0.02..0.02 rows=0 loops=1)

  • Buffers: shared hit=2
59. 0.018 0.018 ↓ 0.0 0 1

Index Scan using pk_person_organization_rel on person_organization_rel pc_1 (cost=0.28..11.73 rows=5 width=17) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: (pc_1.personid = p_1.personid)
  • Filter: ((CURRENT_DATE >= pc_1.effectivedate) AND (CURRENT_DATE <= pc_1.enddate) AND (CURRENT_TIMESTAMP >= pc_1.createts) AND (CURRENT_TIMESTAMP <= pc_1.endts))
  • Buffers: shared hit=2
60. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_company_organization_rel on company_organization_rel oc_1 (cost=0.29..169.29 rows=1 width=8) (never executed)

  • Index Cond: (oc_1.organizationid = pc_1.organizationid)
  • Filter: ((CURRENT_DATE >= oc_1.effectivedate) AND (CURRENT_DATE <= oc_1.enddate) AND (CURRENT_TIMESTAMP >= oc_1.createts) AND (CURRENT_TIMESTAMP <= oc_1.endts))
61. 0.000 0.018 ↓ 0.0 0 1

Unique (cost=5.57..5.57 rows=1 width=65) (actual time=0.018..0.018 rows=0 loops=1)

  • Buffers: shared hit=1
62. 0.004 0.018 ↓ 0.0 0 1

Sort (cost=5.57..5.57 rows=1 width=65) (actual time=0.018..0.018 rows=0 loops=1)

  • Sort Key: pu.companyid
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
63. 0.002 0.014 ↓ 0.0 0 1

Nested Loop (cost=0.42..5.56 rows=1 width=65) (actual time=0.014..0.014 rows=0 loops=1)

  • Buffers: shared hit=1
64. 0.012 0.012 ↓ 0.0 0 1

Index Scan using pk_person_pay_unit_rel on person_pay_unit_rel ppur (cost=0.14..3.26 rows=1 width=17) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (ppur.personid = p_1.personid)
  • Filter: ((CURRENT_DATE >= ppur.effectivedate) AND (CURRENT_DATE <= ppur.enddate) AND (CURRENT_TIMESTAMP >= ppur.createts) AND (CURRENT_TIMESTAMP <= ppur.endts))
  • Buffers: shared hit=1
65. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_pay_unit on pay_unit pu (cost=0.27..2.29 rows=1 width=8) (never executed)

  • Index Cond: (pu.payunitid = ppur.payunitid)
66. 0.000 0.017 ↓ 0.0 0 1

Unique (cost=2.49..2.49 rows=1 width=65) (actual time=0.017..0.017 rows=0 loops=1)

  • Buffers: shared hit=3
67. 0.008 0.017 ↓ 0.0 0 1

Sort (cost=2.49..2.49 rows=1 width=65) (actual time=0.017..0.017 rows=0 loops=1)

  • Sort Key: pe_1.companyid
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=3
68. 0.009 0.009 ↓ 0.0 0 1

Index Scan using personemploymentenddate on person_employment pe_1 (cost=0.42..2.48 rows=1 width=65) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((pe_1.personid = p_1.personid) AND (CURRENT_DATE < pe_1.effectivedate))
  • Filter: (pe_1.effectivedate < pe_1.enddate)
  • Buffers: shared hit=3
69. 0.006 0.034 ↓ 0.0 0 1

Sort (cost=1.45..1.46 rows=2 width=65) (actual time=0.034..0.034 rows=0 loops=1)

  • Sort Key: cs.companyid
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=3
70. 0.000 0.028 ↓ 0.0 0 1

Merge Join (cost=1.22..1.42 rows=2 width=65) (actual time=0.028..0.028 rows=0 loops=1)

  • Buffers: shared hit=3
71. 0.015 0.015 ↑ 188.0 1 1

Index Scan using pk_customer_struct on customer_struct cs (cost=0.15..15.37 rows=188 width=8) (actual time=0.015..0.015 rows=1 loops=1)

  • Filter: ((cs.companyid IS NOT NULL) AND (CURRENT_DATE >= cs.effectivedate) AND (CURRENT_DATE <= cs.enddate) AND (CURRENT_TIMESTAMP >= cs.createts) AND (CURRENT_TIMESTAMP <= cs.endts))
  • Buffers: shared hit=2
72. 0.004 0.013 ↓ 0.0 0 1

Sort (cost=1.07..1.08 rows=1 width=17) (actual time=0.013..0.013 rows=0 loops=1)

  • Sort Key: pcr.customerid
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
73. 0.009 0.009 ↓ 0.0 0 1

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

  • Filter: ((pcr.personid = p_1.personid) AND (CURRENT_DATE >= pcr.effectivedate) AND (CURRENT_DATE <= pcr.enddate) AND (CURRENT_TIMESTAMP >= pcr.createts) AND (CURRENT_TIMESTAMP <= pcr.endts))
  • Buffers: shared hit=1
74. 0.000 0.034 ↓ 0.0 0 1

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

  • Buffers: shared hit=6
75. 0.014 0.014 ↑ 1.0 1 1

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

  • Index Cond: (p_2.personid = '5515'::bpchar)
  • Buffers: shared hit=4
76. 0.005 0.020 ↓ 0.0 0 1

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

  • Buffers: shared hit=2
77. 0.010 0.010 ↑ 12.0 1 1

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

  • Filter: (pcrt.rolename IS NOT NULL)
  • Buffers: shared hit=1
78. 0.000 0.005 ↓ 0.0 0 1

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

  • Buffers: shared hit=1
79. 0.005 0.005 ↓ 0.0 0 1

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

  • Filter: ((pcr_1.personid = '5515'::bpchar) AND (CURRENT_DATE >= pcr_1.effectivedate) AND (CURRENT_DATE <= pcr_1.enddate) AND (CURRENT_TIMESTAMP >= pcr_1.createts) AND (CURRENT_TIMESTAMP <= pcr_1.endts))
  • Buffers: shared hit=1
80. 0.018 0.549 ↓ 1.7 5 9

Hash (cost=8.69..8.69 rows=3 width=9) (actual time=0.061..0.061 rows=5 loops=9)

  • Buffers: shared hit=57 read=1
81. 0.000 0.531 ↓ 1.7 5 9

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

  • Buffers: shared hit=57 read=1
82. 0.009 0.081 ↓ 0.0 0 9

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

  • Buffers: shared hit=18
83. 0.009 0.072 ↓ 0.0 0 9

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

  • Buffers: shared hit=18
84. 0.063 0.063 ↓ 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.007..0.007 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=18
85. 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))
86. 0.009 0.450 ↓ 2.5 5 9

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

  • Buffers: shared hit=39 read=1
87. 0.031 0.441 ↓ 2.5 5 9

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

  • Buffers: shared hit=39 read=1
88. 0.015 0.369 ↓ 2.5 5 9

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

  • Buffers: shared hit=21 read=1
89. 0.108 0.108 ↓ 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.011..0.012 rows=5 loops=9)

  • Index Cond: ((sc2.domainobject = (this_.domainobject)::text) AND (sc2.action = (this_.action)::text))
  • Buffers: shared hit=19
90. 0.004 0.246 ↑ 1.0 1 41

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

  • Buffers: shared hit=2 read=1
91. 0.242 0.242 ↑ 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.241..0.242 rows=1 loops=1)

  • Index Cond: (c.companyid = 1596)
  • Buffers: shared hit=2 read=1
92. 0.000 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=18
93. 0.045 0.045 ↓ 0.0 0 9

Index Scan using idx_csc_neg_do_act on company_security_control sc3_1 (cost=0.28..2.3 rows=1 width=35) (actual time=0.005..0.005 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=18
94. 0.000 0.000 ↓ 0.0 0 0

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

95. 0.000 0.000 ↓ 0.0 0 0

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

96. 0.000 0.000 ↓ 0.0 0 0

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

97. 0.000 0.000 ↓ 0.0 0 0

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

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

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

101. 0.000 0.000 ↓ 0.0 0 0

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

102. 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)

103. 0.000 0.000 ↓ 0.0 0 0

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

104. 0.000 0.000 ↓ 0.0 0 0

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

105. 0.000 0.000 ↓ 0.0 0 0

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

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

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

  • Index Cond: ((pcr_2.companyid = pd_1.companyid) AND (pcr_2.personid = '5515'::bpchar))
  • Filter: ((CURRENT_DATE >= pcr_2.effectivedate) AND (CURRENT_DATE <= pcr_2.enddate) AND (CURRENT_TIMESTAMP >= pcr_2.createts) AND (CURRENT_TIMESTAMP <= pcr_2.endts))
107. 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)
108. 0.000 0.000 ↓ 0.0 0 0

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

109. 0.000 0.000 ↓ 0.0 0 0

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

110. 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_1.positionid, wr_1.rolename, ('RoleEx_GenPosLocR '::character(20))
111. 0.000 0.000 ↓ 0.0 0 0

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

112. 0.000 0.000 ↓ 0.0 0 0

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

113. 0.000 0.000 ↓ 0.0 0 0

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

114. 0.000 0.000 ↓ 0.0 0 0

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

115. 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))
116. 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)

117. 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)
118. 0.000 0.000 ↓ 0.0 0 0

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

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

SubPlan (forIndex Scan)

120. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((pp_1.positionid = pl_1.positionid) AND (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))
121. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (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))
122. 0.000 0.000 ↓ 0.0 0 0

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

123. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((pp_3.positionid = pl_1.positionid) 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))
124. 0.000 0.000 ↓ 0.0 0 0

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

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

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

126. 0.000 0.000 ↓ 0.0 0 0

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

127. 0.000 0.000 ↓ 0.0 0 0

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

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

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

  • Index Cond: ((pp_4.personid = pe_3.personid) 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))
129. 0.000 0.000 ↓ 0.0 0 0

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

130. 0.000 0.000 ↓ 0.0 0 0

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

131. 0.000 0.000 ↓ 0.0 0 0

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

132. 0.000 0.000 ↓ 0.0 0 0

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

133. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((pp_5.positionid = 215579) AND (CURRENT_DATE <= pp_5.enddate))
  • Filter: ((pp_5.effectivedate <= pp_5.enddate) AND (pp_5.persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= pp_5.createts) AND (CURRENT_TIMESTAMP <= pp_5.endts))
134. 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_5.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))
135. 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))
136. 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)

137. 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)
138. 0.000 0.000 ↓ 0.0 0 0

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

139. 0.000 0.000 ↓ 0.0 0 0

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

140. 0.000 0.000 ↓ 0.0 0 0

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

141. 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))
142. 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)
143. 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))
144. 0.000 0.000 ↓ 0.0 0 0

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

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

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

146. 0.000 0.000 ↓ 0.0 0 0

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

147. 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)

148. 0.000 0.000 ↓ 0.0 0 0

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

149. 0.000 0.000 ↓ 0.0 0 0

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

150. 0.000 0.000 ↓ 0.0 0 0

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

151. 0.000 0.000 ↓ 0.0 0 0

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

152. 0.000 0.000 ↓ 0.0 0 0

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

153. 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))
154. 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.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))
155. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (pu_1.payunitid = ep_1.payunitid)
156. 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.19 rows=1 width=23) (never executed)

  • Index Cond: ((pp_6.personid = '5515'::bpchar) AND (pp_6.payunitid = ep_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))
157. 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)

158. 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)
159. 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)

160. 0.000 0.000 ↓ 0.0 0 0

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

161. 0.000 0.000 ↓ 0.0 0 0

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

162. 0.000 0.000 ↓ 0.0 0 0

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

163. 0.000 0.000 ↓ 0.0 0 0

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

164. 0.000 0.000 ↓ 0.0 0 0

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

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

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

  • Index Cond: (pu_2.companyid = pd_3.companyid)
166. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((pp_7.personid = '5515'::bpchar) AND (pp_7.payunitid = pu_2.payunitid))
  • Filter: ((CURRENT_DATE >= pp_7.effectivedate) AND (CURRENT_DATE <= pp_7.enddate) AND (CURRENT_TIMESTAMP >= pp_7.createts) AND (CURRENT_TIMESTAMP <= pp_7.endts))
167. 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)

168. 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)
169. 0.000 0.000 ↓ 0.0 0 0

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

170. 0.000 0.000 ↓ 0.0 0 0

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

171. 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)

172. 0.000 0.000 ↓ 0.0 0 0

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

173. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((pp_8.personid = '5515'::bpchar) AND (CURRENT_DATE <= pp_8.enddate))
  • Filter: ((pp_8.persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= pp_8.createts) AND (CURRENT_TIMESTAMP <= pp_8.endts))
174. 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))
175. 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)

176. 0.000 0.000 ↓ 0.0 0 0

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

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

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

178. 0.000 0.000 ↓ 0.0 0 0

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

179. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((pp_10.personid = '5515'::bpchar) AND (CURRENT_DATE <= pp_10.enddate))
  • Filter: ((pp_10.persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= pp_10.createts) AND (CURRENT_TIMESTAMP <= pp_10.endts))
180. 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))
181. 0.000 0.000 ↓ 0.0 0 0

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

182. 0.000 0.000 ↓ 0.0 0 0

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

183. 0.000 0.000 ↓ 0.0 0 0

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

184. 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))
185. 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))
186. 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_2.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))
187. 0.000 0.000 ↓ 0.0 0 0

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

188. 0.000 0.000 ↓ 0.0 0 0

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

189. 0.000 0.000 ↓ 0.0 0 0

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

190. 0.000 0.000 ↓ 0.0 0 0

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

191. 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))
192. 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))
193. 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))
194. 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_3.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))
195. 0.000 0.000 ↓ 0.0 0 0

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

196. 0.000 0.000 ↓ 0.0 0 0

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

197. 0.000 0.000 ↓ 0.0 0 0

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

198. 0.000 0.000 ↓ 0.0 0 0

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

199. 0.000 0.000 ↓ 0.0 0 0

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

200. 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))
201. 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))
202. 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))
203. 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))
204. 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 = p_p_4.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))
205. 0.000 0.000 ↓ 0.0 0 0

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

206. 0.000 0.000 ↓ 0.0 0 0

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

207. 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)

208. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.27..5.48 rows=1 width=137) (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 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))
211. 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))
212. 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.positionid))
  • Filter: ((pp_14.persposrel = 'Occupies'::bpchar) AND (CURRENT_DATE <= pp_14.enddate) AND (CURRENT_TIMESTAMP >= pp_14.createts) AND (CURRENT_TIMESTAMP <= pp_14.endts))
213. 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)

214. 0.000 0.000 ↓ 0.0 0 0

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

215. 0.000 0.000 ↓ 0.0 0 0

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

216. 0.000 0.000 ↓ 0.0 0 0

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

217. 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))
218. 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))
219. 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))
220. 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_1.positionid))
  • Filter: ((pp_15.persposrel = 'Occupies'::bpchar) AND (CURRENT_DATE >= pp_15.effectivedate) AND (CURRENT_TIMESTAMP >= pp_15.createts) AND (CURRENT_TIMESTAMP <= pp_15.endts) AND (CURRENT_DATE <= pp_15.enddate))
221. 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)

222. 0.000 0.000 ↓ 0.0 0 0

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

223. 0.000 0.000 ↓ 0.0 0 0

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

224. 0.000 0.000 ↓ 0.0 0 0

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

225. 0.000 0.000 ↓ 0.0 0 0

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

226. 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))
227. 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))
228. 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))
229. 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))
230. 0.000 0.000 ↓ 0.0 0 0

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

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

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

232. 0.000 0.000 ↓ 0.0 0 0

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

233. 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)

234. 0.000 0.000 ↓ 0.0 0 0

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

235. 0.000 0.000 ↓ 0.0 0 0

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

236. 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))
237. 0.000 0.000 ↓ 0.0 0 0

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

238. 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)

239. 0.000 0.000 ↓ 0.0 0 0

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

240. 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))
241. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((pp_17.positionid = p_p_5.positionid) AND (CURRENT_DATE <= pp_17.enddate))
  • Filter: ((pp_17.persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= pp_17.createts) AND (CURRENT_TIMESTAMP <= pp_17.endts))
242. 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)

243. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((pp_18.positionid = 215579) AND (CURRENT_DATE >= pp_18.effectivedate) AND (CURRENT_DATE <= pp_18.enddate))
  • Filter: ((pp_18.persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= pp_18.createts) AND (CURRENT_TIMESTAMP <= pp_18.endts))
244. 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)

245. 0.000 0.000 ↓ 0.0 0 0

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

246. 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))
247. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((pp_19.positionid = p_p_6.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))
248. 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)

249. 0.000 0.000 ↓ 0.0 0 0

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

250. 0.000 0.000 ↓ 0.0 0 0

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

251. 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))
252. 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))
253. 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_7.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))
254. 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)

255. 0.000 0.000 ↓ 0.0 0 0

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

256. 0.000 0.000 ↓ 0.0 0 0

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

257. 0.000 0.000 ↓ 0.0 0 0

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

258. 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))
259. 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))
260. 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))
261. 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_8.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))
262. 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)

263. 0.000 0.000 ↓ 0.0 0 0

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

264. 0.000 0.000 ↓ 0.0 0 0

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

265. 0.000 0.000 ↓ 0.0 0 0

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

266. 0.000 0.000 ↓ 0.0 0 0

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

267. 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))
268. 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))
269. 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))
270. 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))
271. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((pp_22.positionid = p_p_9.positionid) AND (CURRENT_DATE <= pp_22.enddate))
  • Filter: ((pp_22.persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= pp_22.createts) AND (CURRENT_TIMESTAMP <= pp_22.endts))
272. 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)
273. 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)

274. 0.000 0.000 ↓ 0.0 0 0

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

275. 0.000 0.000 ↓ 0.0 0 0

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

276. 0.000 0.000 ↓ 0.0 0 0

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

277. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (p_4.personid = '5515'::bpchar)
278. 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))
279. 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)
280. 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)
281. 0.000 0.000 ↓ 0.0 0 0

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

282. 0.000 0.000 ↓ 0.0 0 0

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

283. 0.000 0.000 ↓ 0.0 0 0

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

284. 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)

285. 0.000 0.000 ↓ 0.0 0 0

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

286. 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))
287. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (pe_4.enddate >= CURRENT_DATE)
  • Filter: (pe_4.effectivedate <= pe_4.enddate)
288. 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)

289. 0.000 0.000 ↓ 0.0 0 0

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

290. 0.000 0.000 ↓ 0.0 0 0

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

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

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

  • Index Cond: ((pe_5.companyid = pr_1.companyid) AND (CURRENT_DATE <= pe_5.enddate))
  • Filter: ((pe_5.effectivedate <= pe_5.enddate) AND (pr_1.personid <> pe_5.personid) AND (pr_1.personid <> pe_5.personid) AND (CURRENT_TIMESTAMP >= pe_5.createts) AND (CURRENT_TIMESTAMP <= pe_5.endts))
292. 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)

293. 0.000 0.000 ↓ 0.0 0 0

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

294. 0.000 0.000 ↓ 0.0 0 0

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

295. 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)
296. 0.000 0.000 ↓ 0.0 0 0

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

297. 0.000 0.000 ↓ 0.0 0 0

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

298. 0.000 0.000 ↓ 0.0 0 0

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

299. 0.000 0.000 ↓ 0.0 0 0

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

300. 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))
301. 0.000 0.000 ↓ 0.0 0 0

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

302. 0.000 0.000 ↓ 0.0 0 0

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

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

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

  • Index Cond: ((pe_6.personid = lp_1.personid) AND (pe_6.enddate >= CURRENT_DATE))
  • Filter: (pe_6.effectivedate <= pe_6.enddate)
304. 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_6.personid)
305. 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)

306. 0.000 0.000 ↓ 0.0 0 0

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

307. 0.000 0.000 ↓ 0.0 0 0

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

308. 0.000 0.000 ↓ 0.0 0 0

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

309. 0.000 0.000 ↓ 0.0 0 0

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

310. 0.000 0.000 ↓ 0.0 0 0

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

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

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

  • Index Cond: ((pr_2.positionid = pp_24.positionid) AND (pr_2.posorgreltype = 'HRGenLim'::bpchar))
  • Filter: ((CURRENT_DATE >= pr_2.effectivedate) AND (CURRENT_DATE <= pr_2.enddate))
312. 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_2.organizationid) AND (CURRENT_DATE >= ro.effectivedate) AND (CURRENT_DATE <= ro.enddate))
  • Filter: (ro.posorgreltype = 'Member'::bpchar)
313. 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)
314. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((pe_7.personid = op_1.personid) AND (pe_7.enddate >= CURRENT_DATE))
  • Filter: (pe_7.effectivedate <= pe_7.enddate)
315. 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)

316. 0.000 0.000 ↓ 0.0 0 0

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

317. 0.000 0.000 ↓ 0.0 0 0

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

318. 0.000 0.000 ↓ 0.0 0 0

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

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

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

  • Index Cond: ((pr_3.organizationid = pp_25.organizationid) AND (CURRENT_DATE >= pr_3.effectivedate) AND (CURRENT_DATE <= pr_3.enddate))
  • Filter: (pr_3.posorgreltype = 'Member'::bpchar)
320. 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_3.positionid) AND (CURRENT_DATE >= op_2.effectivedate) AND (CURRENT_DATE <= op_2.enddate))
  • Filter: (op_2.persposrel = 'Occupies'::bpchar)
321. 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)

322. 0.000 0.000 ↓ 0.0 0 0

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

323. 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_8.personid
324. 0.000 0.000 ↓ 0.0 0 0

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

325. 0.000 0.000 ↓ 0.0 0 0

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

326. 0.000 0.000 ↓ 0.0 0 0

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

327. 0.000 0.000 ↓ 0.0 0 0

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

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

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

  • Index Cond: (pd_5.companyid = p_5.companyid)
  • Filter: ((pd_5.effectivedate <= pd_5.enddate) AND (CURRENT_TIMESTAMP >= pd_5.createts) AND (CURRENT_TIMESTAMP <= pd_5.endts))
329. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (pe_8.positionid = pd_5.positionid)
330. 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_8.personid)
  • Filter: ((pep.effectivedate <= pep.enddate) AND (CURRENT_TIMESTAMP >= pep.createts) AND (CURRENT_TIMESTAMP <= pep.endts))
331. 0.000 0.000 ↓ 0.0 0 0

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

332. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

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

335. 0.000 0.000 ↓ 0.0 0 0

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

336. 0.000 0.000 ↓ 0.0 0 0

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

337. 0.000 0.000 ↓ 0.0 0 0

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

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

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

  • Index Cond: ((pe_9.personid = '5515'::bpchar) AND (CURRENT_DATE <= pe_9.enddate))
  • Filter: ((pe_9.effectivedate <= pe_9.enddate) AND (CURRENT_TIMESTAMP >= pe_9.createts) AND (CURRENT_TIMESTAMP <= pe_9.endts) AND (pe_9.emplstatus = ANY ('{A,L,P,C}'::bpchar[])))
339. 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))
340. 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))
341. 0.000 0.000 ↓ 0.0 0 0

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

342. 0.000 0.000 ↓ 0.0 0 0

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

343. 0.000 0.000 ↓ 0.0 0 0

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

344. 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))
345. 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)
346. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (pd_7.positionid = 215579)
  • Filter: ((CURRENT_DATE >= pd_7.effectivedate) AND (CURRENT_DATE <= pd_7.enddate) AND (CURRENT_TIMESTAMP >= pd_7.createts) AND (CURRENT_TIMESTAMP <= pd_7.endts))
347. 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_7.companyid) AND (cp.companyparametername = 'InOnboard'::bpchar))
  • Filter: ((cp.companyparametervalue)::text = 'Y'::text)
348. 0.000 0.000 ↓ 0.0 0 0

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

349. 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))
350. 0.000 0.000 ↓ 0.0 0 0

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

351. 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))
352. 0.000 0.000 ↓ 0.0 0 0

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

353. 0.000 0.000 ↓ 0.0 0 0

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

  • Sort Key: pcr_3.customerid
354. 0.000 0.000 ↓ 0.0 0 0

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

355. 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)

356. 0.000 0.000 ↓ 0.0 0 0

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

357. 0.000 0.000 ↓ 0.0 0 0

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

  • Filter: (pcr_3.personid = '5515'::bpchar)
358. 0.000 0.000 ↓ 0.0 0 0

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

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

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

360. 0.000 0.000 ↓ 0.0 0 0

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

361. 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)

362. 0.000 0.000 ↓ 0.0 0 0

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

363. 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)
364. 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))
365. 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)

366. 0.000 0.000 ↓ 0.0 0 0

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

367. 0.000 0.000 ↓ 0.0 0 0

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

368. 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))
369. 0.000 0.000 ↓ 0.0 0 0

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

370. 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)
371. 0.000 0.000 ↓ 0.0 0 0

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

372. 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
373. 0.018 0.135 ↓ 0.0 0 9

Hash Join (cost=1,429.69..1,429.81 rows=2 width=0) (actual time=0.015..0.015 rows=0 loops=9)

  • Buffers: shared hit=45
374. 0.000 0.000 ↓ 0.0 0 0

Aggregate (cost=1,419.23..1,419.27 rows=4 width=168) (never executed)

375. 0.000 0.000 ↓ 0.0 0 0

Append (cost=0.14..1,419.19 rows=4 width=168) (never executed)

376. 0.000 0.000 ↓ 0.0 0 0

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

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

Nested Loop (cost=0.84..2.88 rows=1 width=90) (never executed)

378. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

Index Only Scan using person_pkey on person p_8 (cost=0.42..1,410.41 rows=1 width=94) (never executed)

  • Index Cond: (p_8.personid = '5515'::bpchar)
  • Filter: ((SubPlan 8) > 1)
381.          

SubPlan (forIndex Only Scan)

382. 0.000 0.000 ↓ 0.0 0 0

Aggregate (cost=1,408.96..1,408.97 rows=1 width=8) (never executed)

383. 0.000 0.000 ↓ 0.0 0 0

Merge Append (cost=1,146.84..1,389.47 rows=1,559 width=65) (never executed)

384. 0.000 0.000 ↓ 0.0 0 0

Unique (cost=0.43..196.53 rows=1,540 width=65) (never executed)

385. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.43..191.71 rows=1,930 width=65) (never executed)

386. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_companyname on companyname co_1 (cost=0.28..165.41 rows=1,930 width=4) (never executed)

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

Materialize (cost=0.14..2.17 rows=1 width=13) (never executed)

388. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (sr_1.personid = p_8.personid)
389. 0.000 0.000 ↓ 0.0 0 0

Unique (cost=6.8..6.81 rows=2 width=65) (never executed)

390. 0.000 0.000 ↓ 0.0 0 0

Sort (cost=6.8..6.81 rows=2 width=65) (never executed)

  • Sort Key: pr_4.companyid
391. 0.000 0.000 ↓ 0.0 0 0

Hash Join (cost=5.45..6.79 rows=2 width=65) (never executed)

392. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on person_company_rel_type person_company_rel_type_1 (cost=0..1.24 rows=18 width=6) (never executed)

  • Filter: (person_company_rel_type_1.personcompanyrelclass = 'MC'::bpchar)
393. 0.000 0.000 ↓ 0.0 0 0

Hash (cost=5.42..5.42 rows=2 width=23) (never executed)

394. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_person_company_rel on person_company_rel pr_4 (cost=0.28..5.42 rows=2 width=23) (never executed)

  • Index Cond: (pr_4.personid = p_8.personid)
  • Filter: ((CURRENT_DATE >= pr_4.effectivedate) AND (CURRENT_DATE <= pr_4.enddate) AND (CURRENT_TIMESTAMP >= pr_4.createts) AND (CURRENT_TIMESTAMP <= pr_4.endts))
395. 0.000 0.000 ↓ 0.0 0 0

Unique (cost=6.04..6.04 rows=1 width=65) (never executed)

396. 0.000 0.000 ↓ 0.0 0 0

Sort (cost=6.04..6.04 rows=1 width=65) (never executed)

  • Sort Key: oo_1.companyid
397. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.71..6.03 rows=1 width=65) (never executed)

398. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((ep_2.personid = p_8.personid) AND (CURRENT_DATE <= ep_2.enddate) AND (CURRENT_DATE >= ep_2.effectivedate))
  • Filter: ((ep_2.emplstatus = 'A'::bpchar) AND (CURRENT_TIMESTAMP >= ep_2.createts) AND (CURRENT_TIMESTAMP <= ep_2.endts))
399. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_company_company_rel on company_company_rel oo_1 (cost=0.28..2.52 rows=1 width=4) (never executed)

  • Index Cond: ((oo_1.companyid = ep_2.companyid) AND (oo_1.companyreltype = 'Af'::bpchar))
  • Filter: ((CURRENT_DATE >= oo_1.effectivedate) AND (CURRENT_DATE <= oo_1.enddate) AND (CURRENT_TIMESTAMP >= oo_1.createts) AND (CURRENT_TIMESTAMP <= oo_1.endts))
400. 0.000 0.000 ↓ 0.0 0 0

Unique (cost=16.57..16.58 rows=3 width=65) (never executed)

401. 0.000 0.000 ↓ 0.0 0 0

Sort (cost=16.57..16.58 rows=3 width=65) (never executed)

  • Sort Key: ol_1.companyid
402. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.56..16.55 rows=3 width=65) (never executed)

403. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_person_location_rel on person_location_rel pl_3 (cost=0.28..9.59 rows=3 width=17) (never executed)

  • Index Cond: (pl_3.personid = p_8.personid)
  • Filter: ((CURRENT_DATE >= pl_3.effectivedate) AND (CURRENT_DATE <= pl_3.enddate) AND (CURRENT_TIMESTAMP >= pl_3.createts) AND (CURRENT_TIMESTAMP <= pl_3.endts))
404. 0.000 0.000 ↓ 0.0 0 0

Index Scan using locationcompanyid on company_location_rel ol_1 (cost=0.28..2.31 rows=1 width=8) (never executed)

  • Index Cond: (ol_1.locationid = pl_3.locationid)
  • Filter: ((CURRENT_TIMESTAMP >= ol_1.createts) AND (CURRENT_TIMESTAMP <= ol_1.endts))
405. 0.000 0.000 ↓ 0.0 0 0

Unique (cost=239.55..239.56 rows=1 width=65) (never executed)

406. 0.000 0.000 ↓ 0.0 0 0

Sort (cost=239.55..239.56 rows=1 width=65) (never executed)

  • Sort Key: oc_2.companyid
407. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.14..239.54 rows=1 width=65) (never executed)

408. 0.000 0.000 ↓ 0.0 0 0

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

409. 0.000 0.000 ↓ 0.0 0 0

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

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

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

  • Index Cond: (por_1.positionid = pc_2.positionid)
  • Filter: ((CURRENT_DATE >= por_1.effectivedate) AND (CURRENT_DATE <= por_1.enddate) AND (CURRENT_TIMESTAMP >= por_1.createts) AND (CURRENT_TIMESTAMP <= por_1.endts) AND (por_1.posorgreltype = ANY ('{BAdmin,BenMgr,HRGen,PRMgr,PRSupr}'::bpchar[])))
411. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_company_organization_rel on company_organization_rel oc_2 (cost=0.29..233.29 rows=1 width=8) (never executed)

  • Index Cond: (oc_2.organizationid = por_1.organizationid)
  • Filter: ((oc_2.companyorganizationreltype = 'Mem'::bpchar) AND (CURRENT_DATE >= oc_2.effectivedate) AND (CURRENT_DATE <= oc_2.enddate) AND (CURRENT_TIMESTAMP >= oc_2.createts) AND (CURRENT_TIMESTAMP <= oc_2.endts))
412. 0.000 0.000 ↓ 0.0 0 0

Unique (cost=3.48..3.49 rows=2 width=65) (never executed)

413. 0.000 0.000 ↓ 0.0 0 0

Sort (cost=3.48..3.49 rows=2 width=65) (never executed)

  • Sort Key: pe_10.companyid
414. 0.000 0.000 ↓ 0.0 0 0

Index Scan using personemploymentenddate on person_employment pe_10 (cost=0.43..3.47 rows=2 width=65) (never executed)

  • Index Cond: ((pe_10.personid = p_8.personid) AND (CURRENT_DATE <= pe_10.enddate) AND (CURRENT_DATE >= pe_10.effectivedate))
415. 0.000 0.000 ↓ 0.0 0 0

Sort (cost=5.98..5.99 rows=1 width=65) (never executed)

  • Sort Key: pd_9.companyid
416. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.85..5.96 rows=1 width=65) (never executed)

417. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((pp_27.personid = p_8.personid) AND (CURRENT_DATE <= pp_27.enddate) AND (CURRENT_DATE >= pp_27.effectivedate))
  • Filter: ((CURRENT_TIMESTAMP >= pp_27.createts) AND (CURRENT_TIMESTAMP <= pp_27.endts))
418. 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=8) (never executed)

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

Unique (cost=858.29..858.31 rows=5 width=65) (never executed)

420. 0.000 0.000 ↓ 0.0 0 0

Sort (cost=858.29..858.3 rows=5 width=65) (never executed)

  • Sort Key: oc_3.companyid
421. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.56..858.23 rows=5 width=65) (never executed)

422. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_person_organization_rel on person_organization_rel pc_3 (cost=0.28..11.73 rows=5 width=17) (never executed)

  • Index Cond: (pc_3.personid = p_8.personid)
  • Filter: ((CURRENT_DATE >= pc_3.effectivedate) AND (CURRENT_DATE <= pc_3.enddate) AND (CURRENT_TIMESTAMP >= pc_3.createts) AND (CURRENT_TIMESTAMP <= pc_3.endts))
423. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_company_organization_rel on company_organization_rel oc_3 (cost=0.29..169.29 rows=1 width=8) (never executed)

  • Index Cond: (oc_3.organizationid = pc_3.organizationid)
  • Filter: ((CURRENT_DATE >= oc_3.effectivedate) AND (CURRENT_DATE <= oc_3.enddate) AND (CURRENT_TIMESTAMP >= oc_3.createts) AND (CURRENT_TIMESTAMP <= oc_3.endts))
424. 0.000 0.000 ↓ 0.0 0 0

Unique (cost=5.57..5.57 rows=1 width=65) (never executed)

425. 0.000 0.000 ↓ 0.0 0 0

Sort (cost=5.57..5.57 rows=1 width=65) (never executed)

  • Sort Key: pu_3.companyid
426. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.42..5.56 rows=1 width=65) (never executed)

427. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_person_pay_unit_rel on person_pay_unit_rel ppur_1 (cost=0.14..3.26 rows=1 width=17) (never executed)

  • Index Cond: (ppur_1.personid = p_8.personid)
  • Filter: ((CURRENT_DATE >= ppur_1.effectivedate) AND (CURRENT_DATE <= ppur_1.enddate) AND (CURRENT_TIMESTAMP >= ppur_1.createts) AND (CURRENT_TIMESTAMP <= ppur_1.endts))
428. 0.000 0.000 ↓ 0.0 0 0

Index Scan using pk_pay_unit on pay_unit pu_3 (cost=0.27..2.29 rows=1 width=8) (never executed)

  • Index Cond: (pu_3.payunitid = ppur_1.payunitid)
429. 0.000 0.000 ↓ 0.0 0 0

Unique (cost=2.49..2.49 rows=1 width=65) (never executed)

430. 0.000 0.000 ↓ 0.0 0 0

Sort (cost=2.49..2.49 rows=1 width=65) (never executed)

  • Sort Key: pe_11.companyid
431. 0.000 0.000 ↓ 0.0 0 0

Index Scan using personemploymentenddate on person_employment pe_11 (cost=0.42..2.48 rows=1 width=65) (never executed)

  • Index Cond: ((pe_11.personid = p_8.personid) AND (CURRENT_DATE < pe_11.effectivedate))
  • Filter: (pe_11.effectivedate < pe_11.enddate)
432. 0.000 0.000 ↓ 0.0 0 0

Sort (cost=1.45..1.46 rows=2 width=65) (never executed)

  • Sort Key: cs_2.companyid
433. 0.000 0.000 ↓ 0.0 0 0

Merge Join (cost=1.22..1.42 rows=2 width=65) (never executed)

434. 0.000 0.000 ↓ 0.0 0 0

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

  • Filter: ((cs_2.companyid IS NOT NULL) AND (CURRENT_DATE >= cs_2.effectivedate) AND (CURRENT_DATE <= cs_2.enddate) AND (CURRENT_TIMESTAMP >= cs_2.createts) AND (CURRENT_TIMESTAMP <= cs_2.endts))
435. 0.000 0.000 ↓ 0.0 0 0

Sort (cost=1.07..1.08 rows=1 width=17) (never executed)

  • Sort Key: pcr_4.customerid
436. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on person_customer_rel pcr_4 (cost=0..1.06 rows=1 width=17) (never executed)

  • Filter: ((pcr_4.personid = p_8.personid) AND (CURRENT_DATE >= pcr_4.effectivedate) AND (CURRENT_DATE <= pcr_4.enddate) AND (CURRENT_TIMESTAMP >= pcr_4.createts) AND (CURRENT_TIMESTAMP <= pcr_4.endts))
437. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=1.5..3.7 rows=1 width=94) (never executed)

438. 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)
439. 0.000 0.000 ↓ 0.0 0 0

Hash Join (cost=1.08..2.25 rows=1 width=13) (never executed)

440. 0.000 0.000 ↓ 0.0 0 0

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

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

Hash (cost=1.06..1.06 rows=1 width=19) (never executed)

442. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on person_customer_rel pcr_5 (cost=0..1.06 rows=1 width=19) (never executed)

  • Filter: ((pcr_5.personid = '5515'::bpchar) AND (CURRENT_DATE >= pcr_5.effectivedate) AND (CURRENT_DATE <= pcr_5.enddate) AND (CURRENT_TIMESTAMP >= pcr_5.createts) AND (CURRENT_TIMESTAMP <= pcr_5.endts))
443. 0.009 0.117 ↓ 0.0 0 9

Hash (cost=10.44..10.44 rows=2 width=9) (actual time=0.013..0.013 rows=0 loops=9)

  • Buffers: shared hit=45
444. 0.000 0.108 ↓ 0.0 0 9

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

  • Buffers: shared hit=45
445. 0.000 0.045 ↓ 0.0 0 9

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

  • Buffers: shared hit=18
446. 0.009 0.045 ↓ 0.0 0 9

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

  • Buffers: shared hit=18
447. 0.036 0.036 ↓ 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.004..0.004 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
448. 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))
449. 0.000 0.063 ↓ 0.0 0 9

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

  • Buffers: shared hit=27
450. 0.009 0.063 ↓ 0.0 0 9

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

  • Buffers: shared hit=27
451. 0.000 0.054 ↓ 0.0 0 9

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

  • Buffers: shared hit=27
452. 0.054 0.054 ↓ 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.006..0.006 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
453. 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)
454. 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
455. 0.000 0.000 ↓ 0.0 0 0

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

456. 0.000 0.000 ↓ 0.0 0 0

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

457. 0.000 0.000 ↓ 0.0 0 0

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

458. 0.000 0.000 ↓ 0.0 0 0

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

459. 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))
460. 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)
461. 0.000 0.000 ↓ 0.0 0 0

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

462. 0.000 0.000 ↓ 0.0 0 0

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

463. 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)

464. 0.000 0.000 ↓ 0.0 0 0

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

465. 0.000 0.000 ↓ 0.0 0 0

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

466. 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))
467. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((pcr_6.companyid = pd_10.companyid) AND (pcr_6.personid = '5515'::bpchar))
  • Filter: ((CURRENT_DATE >= pcr_6.effectivedate) AND (CURRENT_DATE <= pcr_6.enddate) AND (CURRENT_TIMESTAMP >= pcr_6.createts) AND (CURRENT_TIMESTAMP <= pcr_6.endts))
468. 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)
469. 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)

470. 0.000 0.000 ↓ 0.0 0 0

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

471. 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_4.positionid, wr_6.rolename, ('RoleEx_GenPosLocR '::character(20))
472. 0.000 0.000 ↓ 0.0 0 0

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

473. 0.000 0.000 ↓ 0.0 0 0

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

474. 0.000 0.000 ↓ 0.0 0 0

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

475. 0.000 0.000 ↓ 0.0 0 0

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

476. 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))
477. 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)

478. 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)
479. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (pl_4.positionid = 215579)
  • Filter: ((pl_4.effectivedate <= pl_4.enddate) AND (CURRENT_DATE <= pl_4.enddate) AND (CURRENT_TIMESTAMP >= pl_4.createts) AND (CURRENT_TIMESTAMP <= pl_4.endts) AND ((NOT (alternatives: SubPlan 10 or hashed SubPlan 11)) OR (alternatives: SubPlan 12 or hashed SubPlan 13)))
480.          

SubPlan (forIndex Scan)

481. 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=0) (never executed)

  • Index Cond: ((pp_28.positionid = pl_4.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))
482. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (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))
483. 0.000 0.000 ↓ 0.0 0 0

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

484. 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=13) (never executed)

  • Index Cond: ((pp_30.positionid = pl_4.positionid) 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))
485. 0.000 0.000 ↓ 0.0 0 0

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

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

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

487. 0.000 0.000 ↓ 0.0 0 0

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

488. 0.000 0.000 ↓ 0.0 0 0

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

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

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

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

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

491. 0.000 0.000 ↓ 0.0 0 0

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

492. 0.000 0.000 ↓ 0.0 0 0

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

493. 0.000 0.000 ↓ 0.0 0 0

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

494. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((pp_32.positionid = 215579) AND (CURRENT_DATE <= pp_32.enddate))
  • Filter: ((pp_32.effectivedate <= pp_32.enddate) AND (pp_32.persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= pp_32.createts) AND (CURRENT_TIMESTAMP <= pp_32.endts))
495. 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_32.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))
496. 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))
497. 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)

498. 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)
499. 0.000 0.000 ↓ 0.0 0 0

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

500. 0.000 0.000 ↓ 0.0 0 0

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

501. 0.000 0.000 ↓ 0.0 0 0

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

502. 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))
503. 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)
504. 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))
505. 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: ((pd_11.effectivedate <= pd_11.enddate) AND (CURRENT_DATE <= pd_11.enddate) AND (CURRENT_TIMESTAMP >= pd_11.createts) AND (CURRENT_TIMESTAMP <= pd_11.endts))
506. 0.000 0.000 ↓ 0.0 0 0

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

507. 0.000 0.000 ↓ 0.0 0 0

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

508. 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)

509. 0.000 0.000 ↓ 0.0 0 0

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

510. 0.000 0.000 ↓ 0.0 0 0

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

511. 0.000 0.000 ↓ 0.0 0 0

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

512. 0.000 0.000 ↓ 0.0 0 0

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

513. 0.000 0.000 ↓ 0.0 0 0

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

514. 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))
515. 0.000 0.000 ↓ 0.0 0 0

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

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

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

  • Index Cond: (pu_4.payunitid = ep_3.payunitid)
517. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((pp_33.personid = '5515'::bpchar) AND (pp_33.payunitid = ep_3.payunitid))
  • Filter: ((CURRENT_DATE >= pp_33.effectivedate) AND (CURRENT_DATE <= pp_33.enddate) AND (CURRENT_TIMESTAMP >= pp_33.createts) AND (CURRENT_TIMESTAMP <= pp_33.endts))
518. 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)

519. 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)
520. 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)

521. 0.000 0.000 ↓ 0.0 0 0

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

522. 0.000 0.000 ↓ 0.0 0 0

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

523. 0.000 0.000 ↓ 0.0 0 0

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

524. 0.000 0.000 ↓ 0.0 0 0

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

525. 0.000 0.000 ↓ 0.0 0 0

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

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

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

  • Index Cond: (pu_5.companyid = pd_12.companyid)
527. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((pp_34.personid = '5515'::bpchar) AND (pp_34.payunitid = pu_5.payunitid))
  • Filter: ((CURRENT_DATE >= pp_34.effectivedate) AND (CURRENT_DATE <= pp_34.enddate) AND (CURRENT_TIMESTAMP >= pp_34.createts) AND (CURRENT_TIMESTAMP <= pp_34.endts))
528. 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)

529. 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)
530. 0.000 0.000 ↓ 0.0 0 0

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

531. 0.000 0.000 ↓ 0.0 0 0

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

532. 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)

533. 0.000 0.000 ↓ 0.0 0 0

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

534. 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))
535. 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))
536. 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)

537. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((pp_36.personid = '5515'::bpchar) AND (pp_36.positionid = 215579))
  • Filter: ((pp_36.persposrel = 'Occupies'::bpchar) AND (CURRENT_DATE >= pp_36.effectivedate) AND (CURRENT_DATE <= pp_36.enddate) AND (CURRENT_TIMESTAMP >= pp_36.createts) AND (CURRENT_TIMESTAMP <= pp_36.endts))
538. 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)

539. 0.000 0.000 ↓ 0.0 0 0

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

540. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((pp_37.personid = '5515'::bpchar) AND (CURRENT_DATE <= pp_37.enddate))
  • Filter: ((pp_37.persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= pp_37.createts) AND (CURRENT_TIMESTAMP <= pp_37.endts))
541. 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))
542. 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)

543. 0.000 0.000 ↓ 0.0 0 0

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

544. 0.000 0.000 ↓ 0.0 0 0

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

545. 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))
546. 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))
547. 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_12.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))
548. 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)

549. 0.000 0.000 ↓ 0.0 0 0

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

550. 0.000 0.000 ↓ 0.0 0 0

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

551. 0.000 0.000 ↓ 0.0 0 0

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

552. 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))
553. 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))
554. 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))
555. 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 = p_p_13.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))
556. 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)

557. 0.000 0.000 ↓ 0.0 0 0

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

558. 0.000 0.000 ↓ 0.0 0 0

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

559. 0.000 0.000 ↓ 0.0 0 0

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

560. 0.000 0.000 ↓ 0.0 0 0

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

561. 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))
562. 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))
563. 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))
564. 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))
565. 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 = p_p_14.positionid))
  • Filter: ((pp_40.persposrel = 'Occupies'::bpchar) AND (CURRENT_DATE <= pp_40.enddate) AND (CURRENT_TIMESTAMP >= pp_40.createts) AND (CURRENT_TIMESTAMP <= pp_40.endts))
566. 0.000 0.000 ↓ 0.0 0 0

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

567. 0.000 0.000 ↓ 0.0 0 0

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

568. 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)

569. 0.000 0.000 ↓ 0.0 0 0

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

570. 0.000 0.000 ↓ 0.0 0 0

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

571. 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))
572. 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))
573. 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_3.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))
574. 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)

575. 0.000 0.000 ↓ 0.0 0 0

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

576. 0.000 0.000 ↓ 0.0 0 0

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

577. 0.000 0.000 ↓ 0.0 0 0

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

578. 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))
579. 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))
580. 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))
581. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((pp_42.personid = '5515'::bpchar) AND (pp_42.positionid = px_4.positionid))
  • Filter: ((pp_42.persposrel = 'Occupies'::bpchar) AND (CURRENT_DATE >= pp_42.effectivedate) AND (CURRENT_TIMESTAMP >= pp_42.createts) AND (CURRENT_TIMESTAMP <= pp_42.endts) AND (CURRENT_DATE <= pp_42.enddate))
582. 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)

583. 0.000 0.000 ↓ 0.0 0 0

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

584. 0.000 0.000 ↓ 0.0 0 0

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

585. 0.000 0.000 ↓ 0.0 0 0

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

586. 0.000 0.000 ↓ 0.0 0 0

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

587. 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))
588. 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))
589. 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))
590. 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))
591. 0.000 0.000 ↓ 0.0 0 0

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

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

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

593. 0.000 0.000 ↓ 0.0 0 0

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

594. 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)

595. 0.000 0.000 ↓ 0.0 0 0

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

596. 0.000 0.000 ↓ 0.0 0 0

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

597. 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))
598. 0.000 0.000 ↓ 0.0 0 0

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

599. 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)

600. 0.000 0.000 ↓ 0.0 0 0

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

601. 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))
602. 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_15.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))
603. 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)

604. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((pp_45.positionid = 215579) AND (CURRENT_DATE >= pp_45.effectivedate) AND (CURRENT_DATE <= pp_45.enddate))
  • Filter: ((pp_45.persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= pp_45.createts) AND (CURRENT_TIMESTAMP <= pp_45.endts))
605. 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)

606. 0.000 0.000 ↓ 0.0 0 0

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

607. 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))
608. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((pp_46.positionid = p_p_16.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))
609. 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)

610. 0.000 0.000 ↓ 0.0 0 0

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

611. 0.000 0.000 ↓ 0.0 0 0

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

612. 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))
613. 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))
614. 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_17.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))
615. 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)

616. 0.000 0.000 ↓ 0.0 0 0

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

617. 0.000 0.000 ↓ 0.0 0 0

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

618. 0.000 0.000 ↓ 0.0 0 0

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

619. 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))
620. 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))
621. 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))
622. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((pp_48.positionid = p_p_18.positionid) AND (CURRENT_DATE <= pp_48.enddate))
  • Filter: ((pp_48.persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= pp_48.createts) AND (CURRENT_TIMESTAMP <= pp_48.endts))
623. 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)

624. 0.000 0.000 ↓ 0.0 0 0

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

625. 0.000 0.000 ↓ 0.0 0 0

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

626. 0.000 0.000 ↓ 0.0 0 0

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

627. 0.000 0.000 ↓ 0.0 0 0

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

628. 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))
629. 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))
630. 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))
631. 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))
632. 0.000 0.000 ↓ 0.0 0 0

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

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

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

  • Index Cond: (p_10.personid = '5515'::bpchar)
634. 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)

635. 0.000 0.000 ↓ 0.0 0 0

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

636. 0.000 0.000 ↓ 0.0 0 0

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

637. 0.000 0.000 ↓ 0.0 0 0

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

638. 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)
639. 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))
640. 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)
641. 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)
642. 0.000 0.000 ↓ 0.0 0 0

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

643. 0.000 0.000 ↓ 0.0 0 0

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

644. 0.000 0.000 ↓ 0.0 0 0

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

645. 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)

646. 0.000 0.000 ↓ 0.0 0 0

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

647. 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))
648. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (pe_14.enddate >= CURRENT_DATE)
  • Filter: (pe_14.effectivedate <= pe_14.enddate)
649. 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)

650. 0.000 0.000 ↓ 0.0 0 0

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

651. 0.000 0.000 ↓ 0.0 0 0

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

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

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

  • Index Cond: ((pe_15.companyid = pr_5.companyid) AND (CURRENT_DATE <= pe_15.enddate))
  • Filter: ((pe_15.effectivedate <= pe_15.enddate) AND (pr_5.personid <> pe_15.personid) AND (pr_5.personid <> pe_15.personid) AND (CURRENT_TIMESTAMP >= pe_15.createts) AND (CURRENT_TIMESTAMP <= pe_15.endts))
653. 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)

654. 0.000 0.000 ↓ 0.0 0 0

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

655. 0.000 0.000 ↓ 0.0 0 0

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

656. 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)
657. 0.000 0.000 ↓ 0.0 0 0

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

658. 0.000 0.000 ↓ 0.0 0 0

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

659. 0.000 0.000 ↓ 0.0 0 0

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

660. 0.000 0.000 ↓ 0.0 0 0

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

661. 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))
662. 0.000 0.000 ↓ 0.0 0 0

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

663. 0.000 0.000 ↓ 0.0 0 0

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

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

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

  • Index Cond: ((pe_16.personid = lp_3.personid) AND (pe_16.enddate >= CURRENT_DATE))
  • Filter: (pe_16.effectivedate <= pe_16.enddate)
665. 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_16.personid)
666. 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)

667. 0.000 0.000 ↓ 0.0 0 0

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

668. 0.000 0.000 ↓ 0.0 0 0

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

669. 0.000 0.000 ↓ 0.0 0 0

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

670. 0.000 0.000 ↓ 0.0 0 0

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

671. 0.000 0.000 ↓ 0.0 0 0

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

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

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

  • Index Cond: ((pr_6.positionid = pp_51.positionid) AND (pr_6.posorgreltype = 'HRGenLim'::bpchar))
  • Filter: ((CURRENT_DATE >= pr_6.effectivedate) AND (CURRENT_DATE <= pr_6.enddate))
673. 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_6.organizationid) AND (CURRENT_DATE >= ro_1.effectivedate) AND (CURRENT_DATE <= ro_1.enddate))
  • Filter: (ro_1.posorgreltype = 'Member'::bpchar)
674. 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)
675. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((pe_17.personid = op_4.personid) AND (pe_17.enddate >= CURRENT_DATE))
  • Filter: (pe_17.effectivedate <= pe_17.enddate)
676. 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)

677. 0.000 0.000 ↓ 0.0 0 0

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

678. 0.000 0.000 ↓ 0.0 0 0

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

679. 0.000 0.000 ↓ 0.0 0 0

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

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

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

  • Index Cond: ((pr_7.organizationid = pp_52.organizationid) AND (CURRENT_DATE >= pr_7.effectivedate) AND (CURRENT_DATE <= pr_7.enddate))
  • Filter: (pr_7.posorgreltype = 'Member'::bpchar)
681. 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_7.positionid) AND (CURRENT_DATE >= op_5.effectivedate) AND (CURRENT_DATE <= op_5.enddate))
  • Filter: (op_5.persposrel = 'Occupies'::bpchar)
682. 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)

683. 0.000 0.000 ↓ 0.0 0 0

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

684. 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_18.personid
685. 0.000 0.000 ↓ 0.0 0 0

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

686. 0.000 0.000 ↓ 0.0 0 0

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

687. 0.000 0.000 ↓ 0.0 0 0

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

688. 0.000 0.000 ↓ 0.0 0 0

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

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

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

  • Index Cond: (pd_14.companyid = p_12.companyid)
  • Filter: ((pd_14.effectivedate <= pd_14.enddate) AND (CURRENT_TIMESTAMP >= pd_14.createts) AND (CURRENT_TIMESTAMP <= pd_14.endts))
690. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (pe_18.positionid = pd_14.positionid)
691. 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_18.personid)
  • Filter: ((pep_1.effectivedate <= pep_1.enddate) AND (CURRENT_TIMESTAMP >= pep_1.createts) AND (CURRENT_TIMESTAMP <= pep_1.endts))
692. 0.000 0.000 ↓ 0.0 0 0

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

693. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: ((pp_50.positionid = 215579) AND (CURRENT_DATE >= pp_50.effectivedate) AND (CURRENT_DATE <= pp_50.enddate))
  • Filter: ((CURRENT_TIMESTAMP >= pp_50.createts) AND (CURRENT_TIMESTAMP <= pp_50.endts))
694. 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=4) (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))
695. 0.000 0.000 ↓ 0.0 0 0

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

696. 0.000 0.000 ↓ 0.0 0 0

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

697. 0.000 0.000 ↓ 0.0 0 0

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

698. 0.000 0.000 ↓ 0.0 0 0

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

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

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

  • Index Cond: ((pe_19.personid = '5515'::bpchar) AND (CURRENT_DATE <= pe_19.enddate))
  • Filter: ((pe_19.effectivedate <= pe_19.enddate) AND (CURRENT_TIMESTAMP >= pe_19.createts) AND (CURRENT_TIMESTAMP <= pe_19.endts) AND (pe_19.emplstatus = ANY ('{A,L,P,C}'::bpchar[])))
700. 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))
701. 0.000 0.000 ↓ 0.0 0 0

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

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

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

703. 0.000 0.000 ↓ 0.0 0 0

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

704. 0.000 0.000 ↓ 0.0 0 0

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

705. 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))
706. 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)
707. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (pd_16.positionid = 215579)
  • Filter: ((CURRENT_DATE >= pd_16.effectivedate) AND (CURRENT_DATE <= pd_16.enddate) AND (CURRENT_TIMESTAMP >= pd_16.createts) AND (CURRENT_TIMESTAMP <= pd_16.endts))
708. 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_16.companyid) AND (cp_1.companyparametername = 'InOnboard'::bpchar))
  • Filter: ((cp_1.companyparametervalue)::text = 'Y'::text)
709. 0.000 0.000 ↓ 0.0 0 0

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

710. 0.000 0.000 ↓ 0.0 0 0

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

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

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

712. 0.000 0.000 ↓ 0.0 0 0

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

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

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

714. 0.000 0.000 ↓ 0.0 0 0

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

  • Sort Key: pcr_7.customerid
715. 0.000 0.000 ↓ 0.0 0 0

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

716. 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)

717. 0.000 0.000 ↓ 0.0 0 0

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

718. 0.000 0.000 ↓ 0.0 0 0

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

  • Filter: (pcr_7.personid = '5515'::bpchar)
719. 0.000 0.000 ↓ 0.0 0 0

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

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

Hash (cost=10.44..10.44 rows=2 width=9) (never executed)

721. 0.000 0.000 ↓ 0.0 0 0

Append (cost=0.56..10.44 rows=2 width=9) (never executed)

722. 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)

723. 0.000 0.000 ↓ 0.0 0 0

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

724. 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))
725. 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))
726. 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)

727. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..6.75 rows=1 width=261) (never executed)

728. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.56..4.43 rows=1 width=35) (never executed)

729. 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)
730. 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)
731. 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