explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Z8wF

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 11.749 ↑ 2.0 2 1

Unique (cost=126,078.81..126,078.83 rows=4 width=22) (actual time=11.747..11.749 rows=2 loops=1)

2. 0.018 11.747 ↓ 2.2 9 1

Sort (cost=126,078.81..126,078.82 rows=4 width=22) (actual time=11.746..11.747 rows=9 loops=1)

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

Bitmap Heap Scan on security_control this_ (cost=17.22..126,078.77 rows=4 width=22) (actual time=11.342..11.729 rows=9 loops=1)

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

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

5. 0.025 0.025 ↓ 4.0 4 1

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

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

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

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

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

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

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

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

SubPlan (forBitmap Heap Scan)

10. 0.009 6.048 ↑ 3.0 1 9

Nested Loop Semi Join (cost=643.50..691.35 rows=3 width=0) (actual time=0.672..0.672 rows=1 loops=9)

  • Join Filter: (ar.rolename = "*SELECT* 1".rolename)
  • Rows Removed by Join Filter: 10
11. 0.016 5.742 ↑ 1.7 3 9

HashAggregate (cost=642.94..642.99 rows=5 width=168) (actual time=0.638..0.638 rows=3 loops=9)

  • Group Key: ar.personid, ar.personid, ar.rolename, (''::text)
12. 0.002 5.726 ↑ 1.2 4 1

Append (cost=0.00..642.89 rows=5 width=168) (actual time=0.015..5.726 rows=4 loops=1)

13. 0.038 0.038 ↑ 1.0 2 1

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

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

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

15. 0.024 0.024 ↑ 1.0 1 1

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

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

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

  • Index Cond: (personid = '25992'::bpchar)
  • Heap Fetches: 1
17. 0.018 5.554 ↑ 1.0 1 1

Index Only Scan using person_pkey on person p_1 (cost=0.42..608.47 rows=1 width=94) (actual time=5.553..5.554 rows=1 loops=1)

  • Index Cond: (personid = '25992'::bpchar)
  • Filter: ((SubPlan 1) > 1)
  • Heap Fetches: 1
18.          

SubPlan (forIndex Only Scan)

19. 0.239 5.536 ↑ 1.0 1 1

Aggregate (cost=600.02..600.03 rows=1 width=8) (actual time=5.536..5.536 rows=1 loops=1)

20. 0.584 5.297 ↓ 1.2 1,238 1

Sort (cost=583.91..586.60 rows=1,074 width=65) (actual time=5.229..5.297 rows=1,238 loops=1)

  • Sort Key: co.companyid
  • Sort Method: quicksort Memory: 145kB
21. 0.089 4.713 ↓ 1.2 1,238 1

Append (cost=142.89..529.84 rows=1,074 width=65) (actual time=4.077..4.713 rows=1,238 loops=1)

22. 1.326 4.328 ↓ 1.2 1,238 1

HashAggregate (cost=142.89..153.47 rows=1,058 width=65) (actual time=4.077..4.328 rows=1,238 loops=1)

  • Group Key: co.companyid, co.companyid, sr.personid, 'Asgn '::character(10)
23. 0.309 3.002 ↓ 1.9 2,476 1

Nested Loop (cost=0.00..129.69 rows=1,320 width=65) (actual time=0.021..3.002 rows=2,476 loops=1)

24. 0.035 0.035 ↓ 2.0 2 1

Seq Scan on assigned_roles sr (cost=0.00..4.78 rows=1 width=13) (actual time=0.009..0.035 rows=2 loops=1)

  • Filter: (personid = p_1.personid)
  • Rows Removed by Filter: 220
25. 2.658 2.658 ↑ 1.1 1,238 2

Seq Scan on companyname co (cost=0.00..111.72 rows=1,320 width=4) (actual time=0.007..1.329 rows=1,238 loops=2)

  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 1086
26. 0.001 0.024 ↓ 0.0 0 1

Unique (cost=12.21..12.21 rows=1 width=65) (actual time=0.024..0.024 rows=0 loops=1)

27. 0.007 0.023 ↓ 0.0 0 1

Sort (cost=12.21..12.21 rows=1 width=65) (actual time=0.023..0.023 rows=0 loops=1)

  • Sort Key: pr.companyid
  • Sort Method: quicksort Memory: 25kB
28. 0.002 0.016 ↓ 0.0 0 1

Nested Loop (cost=4.30..12.20 rows=1 width=65) (actual time=0.016..0.016 rows=0 loops=1)

  • Join Filter: (pr.personcompanyreltype = person_company_rel_type.personcompanyreltype)
29. 0.003 0.014 ↓ 0.0 0 1

Bitmap Heap Scan on person_company_rel pr (cost=4.30..10.95 rows=1 width=23) (actual time=0.014..0.014 rows=0 loops=1)

  • Recheck Cond: (personid = p_1.personid)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
30. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on person_company_rel_pkey (cost=0.00..4.29 rows=2 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (personid = p_1.personid)
31. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_company_rel_type (cost=0.00..1.24 rows=1 width=24) (never executed)

  • Filter: (personcompanyrelclass = 'MC'::bpchar)
32. 0.000 0.023 ↓ 0.0 0 1

Unique (cost=20.73..20.73 rows=1 width=65) (actual time=0.023..0.023 rows=0 loops=1)

33. 0.006 0.023 ↓ 0.0 0 1

Sort (cost=20.73..20.73 rows=1 width=65) (actual time=0.023..0.023 rows=0 loops=1)

  • Sort Key: oo.companyid
  • Sort Method: quicksort Memory: 25kB
34. 0.002 0.017 ↓ 0.0 0 1

Nested Loop (cost=0.69..20.72 rows=1 width=65) (actual time=0.017..0.017 rows=0 loops=1)

35. 0.015 0.015 ↓ 0.0 0 1

Index Scan using person_employment_pkey on person_employment ep (cost=0.41..12.33 rows=1 width=17) (actual time=0.015..0.015 rows=0 loops=1)

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

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

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

Unique (cost=21.53..21.54 rows=1 width=65) (actual time=0.019..0.019 rows=0 loops=1)

38. 0.006 0.018 ↓ 0.0 0 1

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

  • Sort Key: ol.companyid
  • Sort Method: quicksort Memory: 25kB
39. 0.001 0.012 ↓ 0.0 0 1

Nested Loop (cost=4.59..21.52 rows=1 width=65) (actual time=0.012..0.012 rows=0 loops=1)

40. 0.004 0.011 ↓ 0.0 0 1

Bitmap Heap Scan on person_location_rel pl (cost=4.31..13.20 rows=1 width=17) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: (personid = p_1.personid)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
41. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on pk_person_location_rel (cost=0.00..4.31 rows=4 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (personid = p_1.personid)
42. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (locationid = pl.locationid)
  • Filter: ((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
43. 0.000 0.078 ↓ 0.0 0 1

Unique (cost=66.92..66.93 rows=1 width=65) (actual time=0.078..0.078 rows=0 loops=1)

44. 0.057 0.078 ↓ 0.0 0 1

Sort (cost=66.92..66.93 rows=1 width=65) (actual time=0.078..0.078 rows=0 loops=1)

  • Sort Key: oc.companyid
  • Sort Method: quicksort Memory: 25kB
45. 0.000 0.021 ↓ 0.0 0 1

Nested Loop (cost=1.11..66.91 rows=1 width=65) (actual time=0.021..0.021 rows=0 loops=1)

46. 0.006 0.021 ↓ 0.0 0 1

Nested Loop (cost=0.83..18.87 rows=1 width=17) (actual time=0.021..0.021 rows=0 loops=1)

47. 0.015 0.015 ↓ 0.0 0 1

Index Scan using pers_pos_pkey on pers_pos pc (cost=0.41..8.46 rows=1 width=17) (actual time=0.015..0.015 rows=0 loops=1)

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

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

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

Index Scan using company_organization_rel_pkey on company_organization_rel oc (cost=0.28..48.03 rows=1 width=8) (never executed)

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

Unique (cost=12.31..12.32 rows=2 width=65) (actual time=0.019..0.019 rows=0 loops=1)

51. 0.008 0.019 ↓ 0.0 0 1

Sort (cost=12.31..12.32 rows=2 width=65) (actual time=0.019..0.019 rows=0 loops=1)

  • Sort Key: pe.companyid
  • Sort Method: quicksort Memory: 25kB
52. 0.011 0.011 ↓ 0.0 0 1

Index Scan using person_employment_pkey on person_employment pe (cost=0.41..12.30 rows=2 width=65) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (personid = p_1.personid)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
53. 0.003 0.012 ↓ 0.0 0 1

Nested Loop (cost=0.70..16.79 rows=1 width=65) (actual time=0.012..0.012 rows=0 loops=1)

54. 0.009 0.009 ↓ 0.0 0 1

Index Scan using pers_pos_pkey on pers_pos pp (cost=0.41..8.45 rows=1 width=17) (actual time=0.009..0.009 rows=0 loops=1)

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

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

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

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

57. 0.006 0.017 ↓ 0.0 0 1

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

  • Sort Key: oc_1.companyid
  • Sort Method: quicksort Memory: 25kB
58. 0.001 0.011 ↓ 0.0 0 1

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

59. 0.003 0.010 ↓ 0.0 0 1

Bitmap Heap Scan on person_organization_rel pc_1 (cost=4.29..8.56 rows=1 width=17) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: (personid = p_1.personid)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
60. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on person_organization_rel_pkey (cost=0.00..4.29 rows=2 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (personid = p_1.personid)
61. 0.000 0.000 ↓ 0.0 0

Index Scan using company_organization_rel_pkey on company_organization_rel oc_1 (cost=0.28..154.91 rows=1 width=8) (never executed)

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

Unique (cost=28.56..28.57 rows=2 width=65) (actual time=0.065..0.065 rows=0 loops=1)

63. 0.053 0.065 ↓ 0.0 0 1

Sort (cost=28.56..28.57 rows=2 width=65) (actual time=0.065..0.065 rows=0 loops=1)

  • Sort Key: pu.companyid
  • Sort Method: quicksort Memory: 25kB
64. 0.002 0.012 ↓ 0.0 0 1

Nested Loop (cost=4.58..28.55 rows=2 width=65) (actual time=0.012..0.012 rows=0 loops=1)

65. 0.002 0.010 ↓ 0.0 0 1

Bitmap Heap Scan on person_pay_unit_rel ppur (cost=4.31..11.95 rows=2 width=17) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: (personid = p_1.personid)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
66. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on pk_person_pay_unit_rel (cost=0.00..4.31 rows=4 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (personid = p_1.personid)
67. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (payunitid = ppur.payunitid)
68. 0.000 0.022 ↓ 0.0 0 1

Unique (cost=8.46..8.47 rows=1 width=65) (actual time=0.022..0.022 rows=0 loops=1)

69. 0.008 0.022 ↓ 0.0 0 1

Sort (cost=8.46..8.46 rows=1 width=65) (actual time=0.022..0.022 rows=0 loops=1)

  • Sort Key: pe_1.companyid
  • Sort Method: quicksort Memory: 25kB
70. 0.014 0.014 ↓ 0.0 0 1

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

  • Index Cond: ((personid = p_1.personid) AND (CURRENT_DATE < effectivedate))
  • Filter: (effectivedate < enddate)
71. 0.000 0.017 ↓ 0.0 0 1

Nested Loop (cost=4.30..14.57 rows=5 width=65) (actual time=0.017..0.017 rows=0 loops=1)

72. 0.017 0.017 ↓ 0.0 0 1

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

  • Filter: ((personid = p_1.personid) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 64
73. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on customer_struct cs (cost=4.30..11.47 rows=2 width=8) (never executed)

  • Recheck Cond: (customerid = pcr.customerid)
  • Filter: ((companyid IS NOT NULL) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
74. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on pk_customer_struct (cost=0.00..4.30 rows=3 width=0) (never executed)

  • Index Cond: (customerid = pcr.customerid)
75. 0.001 0.041 ↓ 0.0 0 1

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

76. 0.013 0.013 ↑ 1.0 1 1

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

  • Index Cond: (personid = '25992'::bpchar)
  • Heap Fetches: 1
77. 0.010 0.027 ↓ 0.0 0 1

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

  • Hash Cond: (pcrt.personcustomerreltype = pcr_1.personcustomerreltype)
78. 0.004 0.004 ↑ 12.0 1 1

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

  • Filter: (rolename IS NOT NULL)
79. 0.001 0.013 ↓ 0.0 0 1

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

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

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

  • Filter: ((personid = '25992'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 64
81. 0.027 0.297 ↓ 1.3 4 27

Materialize (cost=0.56..48.09 rows=3 width=9) (actual time=0.009..0.011 rows=4 loops=27)

82. 0.009 0.270 ↓ 1.7 5 9

Append (cost=0.56..48.08 rows=3 width=9) (actual time=0.025..0.030 rows=5 loops=9)

83. 0.009 0.063 ↓ 0.0 0 9

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

84. 0.000 0.054 ↓ 0.0 0 9

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

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

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

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

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

  • Index Cond: ((domainobject = (this_.domainobject)::text) AND (action = (this_.action)::text))
  • Heap Fetches: 0
87. 0.009 0.198 ↓ 2.5 5 9

Subquery Scan on *SELECT* 2 (cost=0.84..28.20 rows=2 width=9) (actual time=0.017..0.022 rows=5 loops=9)

88. 0.031 0.189 ↓ 2.5 5 9

Nested Loop Anti Join (cost=0.84..28.18 rows=2 width=261) (actual time=0.017..0.021 rows=5 loops=9)

  • Join Filter: ((sc3_1.companyid = c.companyid) AND ((sc3_1.domainobject)::text = (sc2.domainobject)::text) AND ((sc3_1.action)::text = (sc2.action)::text) AND (sc3_1.rolename = sc2.rolename))
89. 0.036 0.117 ↓ 2.5 5 9

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

90. 0.081 0.081 ↓ 2.5 5 9

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

  • Index Cond: ((domainobject = (this_.domainobject)::text) AND (action = (this_.action)::text))
  • Heap Fetches: 41
91. 0.000 0.000 ↑ 1.0 1 41

Materialize (cost=0.28..8.30 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=41)

92. 0.010 0.010 ↑ 1.0 1 1

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

  • Index Cond: (companyid = 51786)
  • Heap Fetches: 1
93. 0.000 0.041 ↓ 0.0 0 41

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

94. 0.045 0.045 ↓ 0.0 0 9

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

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

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

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

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

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

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

98. 0.000 0.000 ↓ 0.0 0

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

99. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

102. 0.000 0.000 ↓ 0.0 0

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

  • Join Filter: (pcr_2.personcompanyreltype = pcrt_1.personcompanyreltype)
103. 0.000 0.000 ↓ 0.0 0

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

  • Join Filter: (pcr_2.companyid = pd_1.companyid)
104. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

107. 0.000 0.000 ↓ 0.0 0

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

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

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

109. 0.000 0.000 ↓ 0.0 0

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

110. 0.000 0.000 ↓ 0.0 0

Sort (cost=69.07..69.07 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

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

112. 0.000 0.000 ↓ 0.0 0

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

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

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

114. 0.000 0.000 ↓ 0.0 0

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

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

SubPlan (forIndex Scan)

116. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

119. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

122. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

127. 0.000 0.000 ↓ 0.0 0

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

128. 0.000 0.000 ↓ 0.0 0

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

129. 0.000 0.000 ↓ 0.0 0

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

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

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

131. 0.000 0.000 ↓ 0.0 0

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

132. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

137. 0.000 0.000 ↓ 0.0 0

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

138. 0.000 0.000 ↓ 0.0 0

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

139. 0.000 0.000 ↓ 0.0 0

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

140. 0.000 0.000 ↓ 0.0 0

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

141. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

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

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

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

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

148. 0.000 0.000 ↓ 0.0 0

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

149. 0.000 0.000 ↓ 0.0 0

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

150. 0.000 0.000 ↓ 0.0 0

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

  • Join Filter: ((ppurt.personpayunitreltype)::text = (pp_6.personpayunitreltype)::text)
151. 0.000 0.000 ↓ 0.0 0

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

  • Join Filter: (pu_1.payunitid = pp_6.payunitid)
152. 0.000 0.000 ↓ 0.0 0

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

153. 0.000 0.000 ↓ 0.0 0

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

154. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

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

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

160. 0.000 0.000 ↓ 0.0 0

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

161. 0.000 0.000 ↓ 0.0 0

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

162. 0.000 0.000 ↓ 0.0 0

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

163. 0.000 0.000 ↓ 0.0 0

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

  • Join Filter: ((ppurt_1.personpayunitreltype)::text = (pp_7.personpayunitreltype)::text)
164. 0.000 0.000 ↓ 0.0 0

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

165. 0.000 0.000 ↓ 0.0 0

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

166. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

  • Index Cond: (payunitid = pp_7.payunitid)
169. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

172. 0.000 0.000 ↓ 0.0 0

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

173. 0.000 0.000 ↓ 0.0 0

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

174. 0.000 0.000 ↓ 0.0 0

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

175. 0.000 0.000 ↓ 0.0 0

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

176. 0.000 0.000 ↓ 0.0 0

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

177. 0.000 0.000 ↓ 0.0 0

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

178. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

181. 0.000 0.000 ↓ 0.0 0

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

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

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

183. 0.000 0.000 ↓ 0.0 0

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

184. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

187. 0.000 0.000 ↓ 0.0 0

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

188. 0.000 0.000 ↓ 0.0 0

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

189. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

193. 0.000 0.000 ↓ 0.0 0

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

194. 0.000 0.000 ↓ 0.0 0

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

195. 0.000 0.000 ↓ 0.0 0

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

196. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

201. 0.000 0.000 ↓ 0.0 0

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

202. 0.000 0.000 ↓ 0.0 0

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

203. 0.000 0.000 ↓ 0.0 0

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

204. 0.000 0.000 ↓ 0.0 0

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

205. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

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

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

211. 0.000 0.000 ↓ 0.0 0

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

212. 0.000 0.000 ↓ 0.0 0

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

213. 0.000 0.000 ↓ 0.0 0

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

214. 0.000 0.000 ↓ 0.0 0

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

215. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

219. 0.000 0.000 ↓ 0.0 0

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

220. 0.000 0.000 ↓ 0.0 0

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

221. 0.000 0.000 ↓ 0.0 0

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

222. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

227. 0.000 0.000 ↓ 0.0 0

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

228. 0.000 0.000 ↓ 0.0 0

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

229. 0.000 0.000 ↓ 0.0 0

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

230. 0.000 0.000 ↓ 0.0 0

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

231. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

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

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

237. 0.000 0.000 ↓ 0.0 0

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

238. 0.000 0.000 ↓ 0.0 0

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

239. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

243. 0.000 0.000 ↓ 0.0 0

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

244. 0.000 0.000 ↓ 0.0 0

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

245. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

248. 0.000 0.000 ↓ 0.0 0

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

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

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

250. 0.000 0.000 ↓ 0.0 0

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

251. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

254. 0.000 0.000 ↓ 0.0 0

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

255. 0.000 0.000 ↓ 0.0 0

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

256. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

260. 0.000 0.000 ↓ 0.0 0

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

261. 0.000 0.000 ↓ 0.0 0

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

262. 0.000 0.000 ↓ 0.0 0

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

263. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

268. 0.000 0.000 ↓ 0.0 0

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

269. 0.000 0.000 ↓ 0.0 0

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

270. 0.000 0.000 ↓ 0.0 0

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

271. 0.000 0.000 ↓ 0.0 0

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

272. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

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

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

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

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

279. 0.000 0.000 ↓ 0.0 0

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

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

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

281. 0.000 0.000 ↓ 0.0 0

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

282. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

287. 0.000 0.000 ↓ 0.0 0

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

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

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

289. 0.000 0.000 ↓ 0.0 0

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

290. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

294. 0.000 0.000 ↓ 0.0 0

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

295. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

299. 0.000 0.000 ↓ 0.0 0

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

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

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

301. 0.000 0.000 ↓ 0.0 0

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

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

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

  • Group Key: pl_2.personid, lp_1.personid
303. 0.000 0.000 ↓ 0.0 0

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

304. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

307. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

311. 0.000 0.000 ↓ 0.0 0

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

312. 0.000 0.000 ↓ 0.0 0

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

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

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

314. 0.000 0.000 ↓ 0.0 0

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

315. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

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

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

321. 0.000 0.000 ↓ 0.0 0

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

  • Join Filter: (pp_25.personid <> op_2.personid)
322. 0.000 0.000 ↓ 0.0 0

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

323. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

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

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

329. 0.000 0.000 ↓ 0.0 0

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

  • Group Key: p_5.personid, pe_8.personid, 'HRGenLim'::character(8), 'RoleEx_HRGenLimPreHi'::character(20)
330. 0.000 0.000 ↓ 0.0 0

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

331. 0.000 0.000 ↓ 0.0 0

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

  • Join Filter: (p_5.personid <> pe_8.personid)
332. 0.000 0.000 ↓ 0.0 0

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

333. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

  • Index Cond: (companyid = p_5.companyid)
336. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (positionid = pd_5.positionid)
337. 0.000 0.000 ↓ 0.0 0

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

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

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

339. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

  • Join Filter: (pe_9.companyid = pd_6.companyid)
342. 0.000 0.000 ↓ 0.0 0

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

343. 0.000 0.000 ↓ 0.0 0

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

344. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

349. 0.000 0.000 ↓ 0.0 0

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

350. 0.000 0.000 ↓ 0.0 0

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

351. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

  • Join Filter: (pcr_3.personcustomerreltype = pcrt_2.personcustomerreltype)
356. 0.000 0.000 ↓ 0.0 0

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

357. 0.000 0.000 ↓ 0.0 0

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

358. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

362. 0.000 0.000 ↓ 0.0 0

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

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

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

364. 0.000 0.000 ↓ 0.0 0

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

365. 0.000 0.000 ↓ 0.0 0

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

366. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

370. 0.000 0.000 ↓ 0.0 0

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

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

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

372. 0.000 0.000 ↓ 0.0 0

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

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

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

374. 0.000 0.000 ↓ 0.0 0

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

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

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

376. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((negative = true) AND ((domainobject)::text = (this_.domainobject)::text) AND ((action)::text = (this_.action)::text) AND (companyid = 51786))
  • Filter: negative
377. 0.009 5.607 ↓ 0.0 0 9

Nested Loop Semi Join (cost=643.50..691.22 rows=2 width=0) (actual time=0.623..0.623 rows=0 loops=9)

  • Join Filter: (ar_2.rolename = "*SELECT* 1_8".rolename)
378. 0.016 5.382 ↑ 1.2 4 9

HashAggregate (cost=642.94..642.99 rows=5 width=168) (actual time=0.597..0.598 rows=4 loops=9)

  • Group Key: ar_2.personid, ar_2.personid, ar_2.rolename, (''::text)
379. 0.002 5.366 ↑ 1.2 4 1

Append (cost=0.00..642.89 rows=5 width=168) (actual time=0.007..5.366 rows=4 loops=1)

380. 0.027 0.027 ↑ 1.0 2 1

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

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

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

382. 0.013 0.013 ↑ 1.0 1 1

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

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

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

  • Index Cond: (personid = '25992'::bpchar)
  • Heap Fetches: 1
384. 0.015 5.224 ↑ 1.0 1 1

Index Only Scan using person_pkey on person p_8 (cost=0.42..608.47 rows=1 width=94) (actual time=5.223..5.224 rows=1 loops=1)

  • Index Cond: (personid = '25992'::bpchar)
  • Filter: ((SubPlan 8) > 1)
  • Heap Fetches: 1
385.          

SubPlan (forIndex Only Scan)

386. 0.185 5.209 ↑ 1.0 1 1

Aggregate (cost=600.02..600.03 rows=1 width=8) (actual time=5.209..5.209 rows=1 loops=1)

387. 0.581 5.024 ↓ 1.2 1,238 1

Sort (cost=583.91..586.60 rows=1,074 width=65) (actual time=4.955..5.024 rows=1,238 loops=1)

  • Sort Key: co_1.companyid
  • Sort Method: quicksort Memory: 145kB
388. 0.090 4.443 ↓ 1.2 1,238 1

Append (cost=142.89..529.84 rows=1,074 width=65) (actual time=3.854..4.443 rows=1,238 loops=1)

389. 1.310 4.090 ↓ 1.2 1,238 1

HashAggregate (cost=142.89..153.47 rows=1,058 width=65) (actual time=3.853..4.090 rows=1,238 loops=1)

  • Group Key: co_1.companyid, co_1.companyid, sr_1.personid, 'Asgn '::character(10)
390. 0.305 2.780 ↓ 1.9 2,476 1

Nested Loop (cost=0.00..129.69 rows=1,320 width=65) (actual time=0.013..2.780 rows=2,476 loops=1)

391. 0.029 0.029 ↓ 2.0 2 1

Seq Scan on assigned_roles sr_1 (cost=0.00..4.78 rows=1 width=13) (actual time=0.008..0.029 rows=2 loops=1)

  • Filter: (personid = p_8.personid)
  • Rows Removed by Filter: 220
392. 2.446 2.446 ↑ 1.1 1,238 2

Seq Scan on companyname co_1 (cost=0.00..111.72 rows=1,320 width=4) (actual time=0.003..1.223 rows=1,238 loops=2)

  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 1086
393. 0.001 0.018 ↓ 0.0 0 1

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

394. 0.006 0.017 ↓ 0.0 0 1

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

  • Sort Key: pr_4.companyid
  • Sort Method: quicksort Memory: 25kB
395. 0.002 0.011 ↓ 0.0 0 1

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

  • Join Filter: (pr_4.personcompanyreltype = person_company_rel_type_1.personcompanyreltype)
396. 0.001 0.009 ↓ 0.0 0 1

Bitmap Heap Scan on person_company_rel pr_4 (cost=4.30..10.95 rows=1 width=23) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: (personid = p_8.personid)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
397. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on person_company_rel_pkey (cost=0.00..4.29 rows=2 width=0) (actual time=0.008..0.008 rows=0 loops=1)

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

Seq Scan on person_company_rel_type person_company_rel_type_1 (cost=0.00..1.24 rows=1 width=24) (never executed)

  • Filter: (personcompanyrelclass = 'MC'::bpchar)
399. 0.000 0.016 ↓ 0.0 0 1

Unique (cost=20.73..20.73 rows=1 width=65) (actual time=0.016..0.016 rows=0 loops=1)

400. 0.004 0.016 ↓ 0.0 0 1

Sort (cost=20.73..20.73 rows=1 width=65) (actual time=0.016..0.016 rows=0 loops=1)

  • Sort Key: oo_1.companyid
  • Sort Method: quicksort Memory: 25kB
401. 0.002 0.012 ↓ 0.0 0 1

Nested Loop (cost=0.69..20.72 rows=1 width=65) (actual time=0.012..0.012 rows=0 loops=1)

402. 0.010 0.010 ↓ 0.0 0 1

Index Scan using person_employment_pkey on person_employment ep_2 (cost=0.41..12.33 rows=1 width=17) (actual time=0.010..0.010 rows=0 loops=1)

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

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

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

Unique (cost=21.53..21.54 rows=1 width=65) (actual time=0.016..0.016 rows=0 loops=1)

405. 0.006 0.015 ↓ 0.0 0 1

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

  • Sort Key: ol_1.companyid
  • Sort Method: quicksort Memory: 25kB
406. 0.001 0.009 ↓ 0.0 0 1

Nested Loop (cost=4.59..21.52 rows=1 width=65) (actual time=0.009..0.009 rows=0 loops=1)

407. 0.004 0.008 ↓ 0.0 0 1

Bitmap Heap Scan on person_location_rel pl_3 (cost=4.31..13.20 rows=1 width=17) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: (personid = p_8.personid)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
408. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on pk_person_location_rel (cost=0.00..4.31 rows=4 width=0) (actual time=0.004..0.004 rows=0 loops=1)

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

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

  • Index Cond: (locationid = pl_3.locationid)
  • Filter: ((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
410. 0.001 0.074 ↓ 0.0 0 1

Unique (cost=66.92..66.93 rows=1 width=65) (actual time=0.073..0.074 rows=0 loops=1)

411. 0.058 0.073 ↓ 0.0 0 1

Sort (cost=66.92..66.93 rows=1 width=65) (actual time=0.073..0.073 rows=0 loops=1)

  • Sort Key: oc_2.companyid
  • Sort Method: quicksort Memory: 25kB
412. 0.000 0.015 ↓ 0.0 0 1

Nested Loop (cost=1.11..66.91 rows=1 width=65) (actual time=0.015..0.015 rows=0 loops=1)

413. 0.003 0.015 ↓ 0.0 0 1

Nested Loop (cost=0.83..18.87 rows=1 width=17) (actual time=0.015..0.015 rows=0 loops=1)

414. 0.012 0.012 ↓ 0.0 0 1

Index Scan using pers_pos_pkey on pers_pos pc_2 (cost=0.41..8.46 rows=1 width=17) (actual time=0.012..0.012 rows=0 loops=1)

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

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

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

Index Scan using company_organization_rel_pkey on company_organization_rel oc_2 (cost=0.28..48.03 rows=1 width=8) (never executed)

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

Unique (cost=12.31..12.32 rows=2 width=65) (actual time=0.019..0.019 rows=0 loops=1)

418. 0.009 0.019 ↓ 0.0 0 1

Sort (cost=12.31..12.32 rows=2 width=65) (actual time=0.019..0.019 rows=0 loops=1)

  • Sort Key: pe_10.companyid
  • Sort Method: quicksort Memory: 25kB
419. 0.010 0.010 ↓ 0.0 0 1

Index Scan using person_employment_pkey on person_employment pe_10 (cost=0.41..12.30 rows=2 width=65) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (personid = p_8.personid)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
420. 0.002 0.011 ↓ 0.0 0 1

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

421. 0.009 0.009 ↓ 0.0 0 1

Index Scan using pers_pos_pkey on pers_pos pp_27 (cost=0.41..8.45 rows=1 width=17) (actual time=0.009..0.009 rows=0 loops=1)

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

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

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

Unique (cost=163.49..163.50 rows=1 width=65) (actual time=0.013..0.013 rows=0 loops=1)

424. 0.005 0.013 ↓ 0.0 0 1

Sort (cost=163.49..163.49 rows=1 width=65) (actual time=0.013..0.013 rows=0 loops=1)

  • Sort Key: oc_3.companyid
  • Sort Method: quicksort Memory: 25kB
425. 0.001 0.008 ↓ 0.0 0 1

Nested Loop (cost=4.57..163.48 rows=1 width=65) (actual time=0.008..0.008 rows=0 loops=1)

426. 0.003 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on person_organization_rel pc_3 (cost=4.29..8.56 rows=1 width=17) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: (personid = p_8.personid)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
427. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on person_organization_rel_pkey (cost=0.00..4.29 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

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

Index Scan using company_organization_rel_pkey on company_organization_rel oc_3 (cost=0.28..154.91 rows=1 width=8) (never executed)

  • Index Cond: (organizationid = pc_3.organizationid)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
429. 0.001 0.064 ↓ 0.0 0 1

Unique (cost=28.56..28.57 rows=2 width=65) (actual time=0.064..0.064 rows=0 loops=1)

430. 0.054 0.063 ↓ 0.0 0 1

Sort (cost=28.56..28.57 rows=2 width=65) (actual time=0.063..0.063 rows=0 loops=1)

  • Sort Key: pu_3.companyid
  • Sort Method: quicksort Memory: 25kB
431. 0.001 0.009 ↓ 0.0 0 1

Nested Loop (cost=4.58..28.55 rows=2 width=65) (actual time=0.009..0.009 rows=0 loops=1)

432. 0.003 0.008 ↓ 0.0 0 1

Bitmap Heap Scan on person_pay_unit_rel ppur_1 (cost=4.31..11.95 rows=2 width=17) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: (personid = p_8.personid)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
433. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on pk_person_pay_unit_rel (cost=0.00..4.31 rows=4 width=0) (actual time=0.005..0.005 rows=0 loops=1)

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

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

  • Index Cond: (payunitid = ppur_1.payunitid)
435. 0.000 0.018 ↓ 0.0 0 1

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

436. 0.007 0.018 ↓ 0.0 0 1

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

  • Sort Key: pe_11.companyid
  • Sort Method: quicksort Memory: 25kB
437. 0.011 0.011 ↓ 0.0 0 1

Index Scan using personemploymentenddate on person_employment pe_11 (cost=0.42..8.45 rows=1 width=65) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((personid = p_8.personid) AND (CURRENT_DATE < effectivedate))
  • Filter: (effectivedate < enddate)
438. 0.001 0.014 ↓ 0.0 0 1

Nested Loop (cost=4.30..14.57 rows=5 width=65) (actual time=0.014..0.014 rows=0 loops=1)

439. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on person_customer_rel pcr_4 (cost=0.00..3.08 rows=1 width=17) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: ((personid = p_8.personid) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 64
440. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on customer_struct cs_2 (cost=4.30..11.47 rows=2 width=8) (never executed)

  • Recheck Cond: (customerid = pcr_4.customerid)
  • Filter: ((companyid IS NOT NULL) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
441. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on pk_customer_struct (cost=0.00..4.30 rows=3 width=0) (never executed)

  • Index Cond: (customerid = pcr_4.customerid)
442. 0.000 0.035 ↓ 0.0 0 1

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

443. 0.013 0.013 ↑ 1.0 1 1

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

  • Index Cond: (personid = '25992'::bpchar)
  • Heap Fetches: 1
444. 0.007 0.022 ↓ 0.0 0 1

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

  • Hash Cond: (pcrt_3.personcustomerreltype = pcr_5.personcustomerreltype)
445. 0.003 0.003 ↑ 12.0 1 1

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

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

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

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

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

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

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

449. 0.018 0.207 ↓ 0.0 0 9

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

450. 0.000 0.108 ↓ 0.0 0 9

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

451. 0.009 0.108 ↓ 0.0 0 9

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

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

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

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

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

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

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

455. 0.000 0.081 ↓ 0.0 0 9

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

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

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

457. 0.072 0.072 ↓ 0.0 0 9

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

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

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

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

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

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

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

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

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

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

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

463. 0.000 0.000 ↓ 0.0 0

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

464. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

467. 0.000 0.000 ↓ 0.0 0

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

  • Join Filter: (pcr_6.personcompanyreltype = pcrt_4.personcompanyreltype)
468. 0.000 0.000 ↓ 0.0 0

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

  • Join Filter: (pcr_6.companyid = pd_10.companyid)
469. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

472. 0.000 0.000 ↓ 0.0 0

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

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

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

474. 0.000 0.000 ↓ 0.0 0

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

475. 0.000 0.000 ↓ 0.0 0

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

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

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

477. 0.000 0.000 ↓ 0.0 0

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

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

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

479. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (positionid = 13973)
  • Filter: ((effectivedate <= enddate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts) AND ((NOT (alternatives: SubPlan 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

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

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

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

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

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

484. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

487. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

492. 0.000 0.000 ↓ 0.0 0

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

493. 0.000 0.000 ↓ 0.0 0

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

494. 0.000 0.000 ↓ 0.0 0

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

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

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

496. 0.000 0.000 ↓ 0.0 0

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

497. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

502. 0.000 0.000 ↓ 0.0 0

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

503. 0.000 0.000 ↓ 0.0 0

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

504. 0.000 0.000 ↓ 0.0 0

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

505. 0.000 0.000 ↓ 0.0 0

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

506. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

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

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

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

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

513. 0.000 0.000 ↓ 0.0 0

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

514. 0.000 0.000 ↓ 0.0 0

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

515. 0.000 0.000 ↓ 0.0 0

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

  • Join Filter: ((ppurt_2.personpayunitreltype)::text = (pp_33.personpayunitreltype)::text)
516. 0.000 0.000 ↓ 0.0 0

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

  • Join Filter: (pu_4.payunitid = pp_33.payunitid)
517. 0.000 0.000 ↓ 0.0 0

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

518. 0.000 0.000 ↓ 0.0 0

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

519. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

  • Index Cond: (payunitid = ep_3.payunitid)
  • Heap Fetches: 0
522. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

525. 0.000 0.000 ↓ 0.0 0

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

526. 0.000 0.000 ↓ 0.0 0

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

527. 0.000 0.000 ↓ 0.0 0

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

528. 0.000 0.000 ↓ 0.0 0

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

  • Join Filter: ((ppurt_3.personpayunitreltype)::text = (pp_34.personpayunitreltype)::text)
529. 0.000 0.000 ↓ 0.0 0

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

530. 0.000 0.000 ↓ 0.0 0

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

531. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

  • Index Cond: (payunitid = pp_34.payunitid)
534. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

537. 0.000 0.000 ↓ 0.0 0

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

538. 0.000 0.000 ↓ 0.0 0

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

539. 0.000 0.000 ↓ 0.0 0

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

540. 0.000 0.000 ↓ 0.0 0

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

541. 0.000 0.000 ↓ 0.0 0

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

542. 0.000 0.000 ↓ 0.0 0

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

543. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

546. 0.000 0.000 ↓ 0.0 0

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

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

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

548. 0.000 0.000 ↓ 0.0 0

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

549. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

552. 0.000 0.000 ↓ 0.0 0

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

553. 0.000 0.000 ↓ 0.0 0

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

554. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

558. 0.000 0.000 ↓ 0.0 0

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

559. 0.000 0.000 ↓ 0.0 0

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

560. 0.000 0.000 ↓ 0.0 0

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

561. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

566. 0.000 0.000 ↓ 0.0 0

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

567. 0.000 0.000 ↓ 0.0 0

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

568. 0.000 0.000 ↓ 0.0 0

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

569. 0.000 0.000 ↓ 0.0 0

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

570. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

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

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

576. 0.000 0.000 ↓ 0.0 0

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

577. 0.000 0.000 ↓ 0.0 0

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

578. 0.000 0.000 ↓ 0.0 0

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

579. 0.000 0.000 ↓ 0.0 0

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

580. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

584. 0.000 0.000 ↓ 0.0 0

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

585. 0.000 0.000 ↓ 0.0 0

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

586. 0.000 0.000 ↓ 0.0 0

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

587. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

592. 0.000 0.000 ↓ 0.0 0

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

593. 0.000 0.000 ↓ 0.0 0

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

594. 0.000 0.000 ↓ 0.0 0

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

595. 0.000 0.000 ↓ 0.0 0

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

596. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

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

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

602. 0.000 0.000 ↓ 0.0 0

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

603. 0.000 0.000 ↓ 0.0 0

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

604. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

608. 0.000 0.000 ↓ 0.0 0

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

609. 0.000 0.000 ↓ 0.0 0

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

610. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

613. 0.000 0.000 ↓ 0.0 0

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

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

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

615. 0.000 0.000 ↓ 0.0 0

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

616. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

619. 0.000 0.000 ↓ 0.0 0

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

620. 0.000 0.000 ↓ 0.0 0

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

621. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

625. 0.000 0.000 ↓ 0.0 0

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

626. 0.000 0.000 ↓ 0.0 0

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

627. 0.000 0.000 ↓ 0.0 0

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

628. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

633. 0.000 0.000 ↓ 0.0 0

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

634. 0.000 0.000 ↓ 0.0 0

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

635. 0.000 0.000 ↓ 0.0 0

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

636. 0.000 0.000 ↓ 0.0 0

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

637. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

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

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

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

Subquery Scan on *SELECT* 2_13 (cost=0.99..27.00 rows=1 width=61) (never executed)

644. 0.000 0.000 ↓ 0.0 0

Nested Loop Anti Join (cost=0.99..26.99 rows=1 width=105) (never executed)

  • Join Filter: (pop_1.topositionid = pos_4.positionid)
645. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..18.67 rows=1 width=61) (never executed)

646. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..10.36 rows=1 width=57) (never executed)

647. 0.000 0.000 ↓ 0.0 0

Index Only Scan using person_pkey on person p_11 (cost=0.42..8.44 rows=1 width=13) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
  • Heap Fetches: 0
648. 0.000 0.000 ↓ 0.0 0

Seq Scan on pers_pers proxy_3 (cost=0.00..1.91 rows=1 width=96) (never executed)

  • Filter: ((topersonid = '25992'::bpchar) AND (personreltype = 'ProxDMgr1'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
649. 0.000 0.000 ↓ 0.0 0

Index Only Scan using position_pkey on "position" pos_4 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Index Cond: (positionid = 13973)
  • Heap Fetches: 0
650. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pos_pos_topositionid on pos_pos pop_1 (cost=0.29..8.30 rows=1 width=4) (never executed)

  • Index Cond: (topositionid = 13973)
  • Heap Fetches: 0
651. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=8.63..7,740.95 rows=1 width=85) (never executed)

652. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=8.34..7,732.61 rows=1 width=17) (never executed)

  • Hash Cond: ("*SELECT* 1_15".subjectid = pp_50.personid)
653. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..7,663.61 rows=16,172 width=26) (never executed)

654. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1_15 (cost=0.00..2,348.96 rows=14,311 width=26) (never executed)

655. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..2,205.85 rows=14,311 width=146) (never executed)

  • Join Filter: ((ar_3.personid <> pe_14.personid) AND (ar_3.personid <> pe_14.personid))
656. 0.000 0.000 ↓ 0.0 0

Seq Scan on assigned_roles ar_3 (cost=0.00..5.33 rows=1 width=13) (never executed)

  • Filter: ((rolename = 'HRGenLim'::bpchar) AND (personid = '25992'::bpchar))
657. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_employment pe_14 (cost=0.00..1,985.84 rows=14,312 width=13) (never executed)

  • Filter: ((effectivedate <= enddate) AND (CURRENT_DATE <= enddate))
658. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2_15 (cost=10.97..508.93 rows=421 width=26) (never executed)

659. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=10.97..504.72 rows=421 width=146) (never executed)

660. 0.000 0.000 ↓ 0.0 0

Index Scan using person_company_rel_pkey on person_company_rel pr_5 (cost=0.28..8.32 rows=1 width=17) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
  • Filter: ((personcompanyreltype = 'HRGL'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
661. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on person_employment pe_15 (cost=10.69..495.99 rows=41 width=17) (never executed)

  • Recheck Cond: ((companyid = pr_5.companyid) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (pr_5.personid <> personid) AND (pr_5.personid <> personid) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
662. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on employmentcompanyideffdt (cost=0.00..10.68 rows=185 width=0) (never executed)

  • Index Cond: ((companyid = pr_5.companyid) AND (CURRENT_DATE <= enddate))
663. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 3_7 (cost=1,755.15..1,801.35 rows=1 width=26) (never executed)

664. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1,755.15..1,801.34 rows=1 width=146) (never executed)

  • Join Filter: ((pl1_1.personid <> lp1_1.personid) AND (pe_16.personid = lp1_1.personid))
665. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1,754.74..1,800.55 rows=1 width=39) (never executed)

666. 0.000 0.000 ↓ 0.0 0

Index Only Scan using person_pkey on person pl1_1 (cost=0.42..8.44 rows=1 width=13) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
  • Heap Fetches: 0
667. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=1,754.32..1,773.22 rows=1,890 width=39) (never executed)

  • Group Key: pl_5.personid, lp_3.personid
668. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=8.27..1,744.87 rows=1,890 width=39) (never executed)

669. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=7.85..1,667.94 rows=108 width=26) (never executed)

  • Hash Cond: (lp_3.locationid = pl_5.locationid)
  • Join Filter: (pl_5.personid <> lp_3.personid)
670. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_locations lp_3 (cost=0.00..1,575.41 rows=22,220 width=17) (never executed)

  • Filter: ((personlocationtype = 'P'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
671. 0.000 0.000 ↓ 0.0 0

Hash (cost=7.84..7.84 rows=1 width=17) (never executed)

672. 0.000 0.000 ↓ 0.0 0

Index Scan using personlocationreltype on person_location_rel pl_5 (cost=0.28..7.84 rows=1 width=17) (never executed)

  • Index Cond: (personlocationreltype = 'HL'::bpchar)
  • Filter: ((personid = '25992'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
673. 0.000 0.000 ↓ 0.0 0

Index Only Scan using personemploymentenddate on person_employment pe_16 (cost=0.42..0.70 rows=1 width=13) (never executed)

  • Index Cond: ((personid = lp_3.personid) AND (enddate >= CURRENT_DATE))
  • Filter: (effectivedate <= enddate)
  • Heap Fetches: 0
674. 0.000 0.000 ↓ 0.0 0

Index Only Scan using person_pkey on person lp1_1 (cost=0.42..0.77 rows=1 width=13) (never executed)

  • Index Cond: (personid = lp_3.personid)
  • Heap Fetches: 0
675. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 4_5 (cost=1.96..1,501.39 rows=817 width=26) (never executed)

676. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.96..1,493.22 rows=817 width=146) (never executed)

677. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.54..643.24 rows=1,313 width=26) (never executed)

  • Join Filter: ((pp_51.personid <> op_4.personid) AND (pp_51.personid <> op_4.personid))
678. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.24..70.24 rows=1,270 width=17) (never executed)

679. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.90 rows=1 width=17) (never executed)

680. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pos_pkey on pers_pos pp_51 (cost=0.41..8.45 rows=1 width=17) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
681. 0.000 0.000 ↓ 0.0 0

Index Scan using posorgrelbyposition on pos_org_rel pr_6 (cost=0.41..8.44 rows=1 width=8) (never executed)

  • Index Cond: ((positionid = pp_51.positionid) AND (posorgreltype = 'HRGenLim'::bpchar))
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
682. 0.000 0.000 ↓ 0.0 0

Index Scan using pos_org_rel_pkey on pos_org_rel ro_1 (cost=0.41..53.11 rows=23 width=8) (never executed)

  • Index Cond: (organizationid = pr_6.organizationid)
  • Filter: ((posorgreltype = 'Member'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
683. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos op_4 (cost=0.29..0.44 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = ro_1.positionid) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: (persposrel = 'Occupies'::bpchar)
684. 0.000 0.000 ↓ 0.0 0

Index Only Scan using personemploymentenddate on person_employment pe_17 (cost=0.42..0.64 rows=1 width=13) (never executed)

  • Index Cond: ((personid = op_4.personid) AND (enddate >= CURRENT_DATE))
  • Filter: (effectivedate <= enddate)
  • Heap Fetches: 0
685. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 5_5 (cost=9.72..274.90 rows=200 width=26) (never executed)

686. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=9.72..272.90 rows=200 width=146) (never executed)

  • Join Filter: (pp_52.personid <> op_5.personid)
687. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=9.43..186.31 rows=193 width=17) (never executed)

688. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on person_organization_rel pp_52 (cost=4.29..8.54 rows=1 width=17) (never executed)

  • Recheck Cond: (personid = '25992'::bpchar)
  • Filter: ((personorganizationreltype = 'HRGL'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
689. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on person_organization_rel_pkey (cost=0.00..4.29 rows=2 width=0) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
690. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pos_org_rel pr_7 (cost=5.14..177.54 rows=23 width=8) (never executed)

  • Recheck Cond: ((organizationid = pp_52.organizationid) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: (posorgreltype = 'Member'::bpchar)
691. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on posorgrelorganization (cost=0.00..5.13 rows=53 width=0) (never executed)

  • Index Cond: ((organizationid = pp_52.organizationid) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
692. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos op_5 (cost=0.29..0.44 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = pr_7.positionid) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: (persposrel = 'Occupies'::bpchar)
693. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 6_5 (cost=1,219.65..1,228.09 rows=422 width=26) (never executed)

694. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=1,219.65..1,223.87 rows=422 width=146) (never executed)

  • Group Key: p_12.personid, pe_18.personid, 'HRGenLim'::character(8), 'RoleEx_HRGenLimPreHi'::character(20)
695. 0.000 0.000 ↓ 0.0 0

Nested Loop Anti Join (cost=6.46..1,215.43 rows=422 width=146) (never executed)

696. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=6.04..763.19 rows=740 width=26) (never executed)

  • Join Filter: (p_12.personid <> pe_18.personid)
697. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=5.75..430.16 rows=573 width=17) (never executed)

698. 0.000 0.000 ↓ 0.0 0

Index Scan using person_company_rel_pkey on person_company_rel p_12 (cost=0.28..8.32 rows=1 width=17) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
  • Filter: ((personcompanyreltype = 'HRGL'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
699. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on position_desc pd_14 (cost=5.47..421.36 rows=48 width=8) (never executed)

  • Recheck Cond: (companyid = p_12.companyid)
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
700. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on positioncompany (cost=0.00..5.46 rows=156 width=0) (never executed)

  • Index Cond: (companyid = p_12.companyid)
701. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pe_18 (cost=0.29..0.57 rows=1 width=17) (never executed)

  • Index Cond: (positionid = pd_14.positionid)
702. 0.000 0.000 ↓ 0.0 0

Index Scan using personemploymentenddate on person_employment pep_1 (cost=0.41..0.61 rows=1 width=13) (never executed)

  • Index Cond: (personid = pe_18.personid)
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
703. 0.000 0.000 ↓ 0.0 0

Hash (cost=8.33..8.33 rows=1 width=17) (never executed)

704. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_50 (cost=0.29..8.33 rows=1 width=17) (never executed)

  • Index Cond: ((positionid = 13973) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: ((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
705. 0.000 0.000 ↓ 0.0 0

Index Scan using position_desc_pkey on position_desc pd_13 (cost=0.29..8.33 rows=1 width=4) (never executed)

  • Index Cond: (positionid = 13973)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
706. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.54..33.70 rows=1 width=85) (never executed)

  • Join Filter: (pe_19.companyid = pd_15.companyid)
707. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.25..25.36 rows=1 width=17) (never executed)

708. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.90 rows=1 width=17) (never executed)

709. 0.000 0.000 ↓ 0.0 0

Index Only Scan using person_pkey on person p_13 (cost=0.42..8.44 rows=1 width=13) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
  • Heap Fetches: 0
710. 0.000 0.000 ↓ 0.0 0

Index Scan using personemploymentenddate on person_employment pe_19 (cost=0.42..8.46 rows=1 width=17) (never executed)

  • Index Cond: ((personid = '25992'::bpchar) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts) AND (emplstatus = ANY ('{A,L,P,C}'::bpchar[])))
711. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pos_pkey on pers_pos ppos_1 (cost=0.41..8.45 rows=1 width=13) (never executed)

  • Index Cond: (personid = '25992'::bpchar)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
712. 0.000 0.000 ↓ 0.0 0

Index Scan using position_desc_pkey on position_desc pd_15 (cost=0.29..8.33 rows=1 width=8) (never executed)

  • Index Cond: (positionid = 13973)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
713. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.85..35.63 rows=1 width=85) (never executed)

714. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..21.98 rows=1 width=21) (never executed)

715. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.29..13.65 rows=1 width=17) (never executed)

716. 0.000 0.000 ↓ 0.0 0

Seq Scan on assigned_roles u_3 (cost=0.00..5.33 rows=1 width=13) (never executed)

  • Filter: ((rolename = 'Onboard'::bpchar) AND (personid = '25992'::bpchar))
717. 0.000 0.000 ↓ 0.0 0

Index Only Scan using position_pkey on "position" pos_5 (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Index Cond: (positionid = 13973)
  • Heap Fetches: 0
718. 0.000 0.000 ↓ 0.0 0

Index Scan using position_desc_pkey on position_desc pd_16 (cost=0.29..8.33 rows=1 width=8) (never executed)

  • Index Cond: (positionid = 13973)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
719. 0.000 0.000 ↓ 0.0 0

Index Scan using company_parameters_pkey on company_parameters cp_1 (cost=0.28..8.30 rows=1 width=4) (never executed)

  • Index Cond: ((companyid = pd_16.companyid) AND (companyparametername = 'InOnboard'::bpchar))
  • Filter: ((companyparametervalue)::text = 'Y'::text)
720. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..18.10 rows=1 width=85) (never executed)

  • Join Filter: (pcr_7.personcustomerreltype = pcrt_5.personcustomerreltype)
721. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..16.83 rows=1 width=23) (never executed)

722. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..16.65 rows=1 width=8) (never executed)

723. 0.000 0.000 ↓ 0.0 0

Index Scan using position_desc_pkey on position_desc pd_17 (cost=0.29..8.32 rows=1 width=8) (never executed)

  • Index Cond: (positionid = 13973)
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
724. 0.000 0.000 ↓ 0.0 0

Index Scan using customercompany on customer_struct cs_3 (cost=0.28..8.31 rows=1 width=8) (never executed)

  • Index Cond: (companyid = pd_17.companyid)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
725. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_person_customer_rel on person_customer_rel pcr_7 (cost=0.14..0.17 rows=1 width=23) (never executed)

  • Index Cond: ((personid = '25992'::bpchar) AND (customerid = cs_3.customerid))
726. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_customer_rel_type pcrt_5 (cost=0.00..1.12 rows=12 width=60) (never executed)

727. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos pp_53 (cost=0.29..8.33 rows=1 width=85) (never executed)

  • Index Cond: ((positionid = 13973) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '25992'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
728. 0.000 0.000 ↓ 0.0 0

Hash (cost=48.03..48.03 rows=2 width=9) (never executed)

729. 0.000 0.000 ↓ 0.0 0

Append (cost=0.56..48.03 rows=2 width=9) (never executed)

730. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1_9 (cost=0.56..19.89 rows=1 width=9) (never executed)

731. 0.000 0.000 ↓ 0.0 0

Nested Loop Anti Join (cost=0.56..19.88 rows=1 width=261) (never executed)

  • Join Filter: (((sc1_3.action)::text = (sc3_6.action)::text) AND ((sc3_6.domainobject)::text = (sc1_3.domainobject)::text) AND (sc3_6.rolename = sc1_3.rolename))
732. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_company_security_control on company_security_control sc1_3 (cost=0.28..8.34 rows=1 width=32) (never executed)

  • Index Cond: (((domainobject)::text = (this_.domainobject)::text) AND ((action)::text = (this_.action)::text) AND (companyid = 51786))
  • Filter: ((NOT negative) AND (roleinterest = 'X'::bpchar))
733. 0.000 0.000 ↓ 0.0 0

Index Only Scan using security_control_pkey1 on security_control sc3_6 (cost=0.29..11.50 rows=2 width=31) (never executed)

  • Index Cond: ((domainobject = (this_.domainobject)::text) AND (action = (this_.action)::text))
  • Heap Fetches: 0
734. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2_9 (cost=0.84..28.15 rows=1 width=9) (never executed)

735. 0.000 0.000 ↓ 0.0 0

Nested Loop Anti Join (cost=0.84..28.14 rows=1 width=261) (never executed)

  • Join Filter: ((sc3_7.companyid = c_3.companyid) AND ((sc3_7.domainobject)::text = (sc2_3.domainobject)::text) AND ((sc3_7.action)::text = (sc2_3.action)::text) AND (sc3_7.rolename = sc2_3.rolename))
736. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..19.81 rows=1 width=35) (never executed)

737. 0.000 0.000 ↓ 0.0 0

Index Scan using security_control_pkey1 on security_control sc2_3 (cost=0.29..11.51 rows=1 width=31) (never executed)

  • Index Cond: (((domainobject)::text = (this_.domainobject)::text) AND ((action)::text = (this_.action)::text))
  • Filter: (roleinterest = 'X'::bpchar)
738. 0.000 0.000 ↓ 0.0 0

Index Only Scan using company_pkey on company c_3 (cost=0.28..8.30 rows=1 width=4) (never executed)

  • Index Cond: (companyid = 51786)
  • Heap Fetches: 0
739. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_csc_neg_do_act on company_security_control sc3_7 (cost=0.28..8.30 rows=1 width=36) (never executed)

  • Index Cond: ((negative = true) AND ((domainobject)::text = (this_.domainobject)::text) AND ((action)::text = (this_.action)::text) AND (companyid = 51786))
  • Filter: negative