explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GI8s

Settings
# exclusive inclusive rows x rows loops node
1. 0.592 2,421.653 ↓ 12.0 4,024 1

Result (cost=363,774.38..1,661,742.54 rows=334 width=764) (actual time=2,416.056..2,421.653 rows=4,024 loops=1)

  • One-Time Filter: (NOT $11)
2.          

Initplan (forResult)

3. 0.000 1.990 ↓ 0.0 0 1

Nested Loop Semi Join (cost=1,203.40..1,215.90 rows=2 width=0) (actual time=1.990..1.990 rows=0 loops=1)

  • Join Filter: (ar_2.rolename = "*SELECT* 1_8".rolename)
4. 0.007 1.948 ↑ 4.0 1 1

HashAggregate (cost=1,202.72..1,202.76 rows=4 width=168) (actual time=1.948..1.948 rows=1 loops=1)

  • Group Key: ar_2.personid, ar_2.personid, ar_2.rolename, (''::text)
5. 0.000 1.941 ↑ 4.0 1 1

Append (cost=0.14..1,202.68 rows=4 width=168) (actual time=0.060..1.941 rows=1 loops=1)

6. 0.015 0.015 ↓ 0.0 0 1

Index Only Scan using pk_assigned_roles on assigned_roles ar_2 (cost=0.14..1.16 rows=1 width=67) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (personid = '127288'::bpchar)
  • Heap Fetches: 0
7. 0.003 0.045 ↑ 1.0 1 1

Nested Loop (cost=0.84..4.88 rows=1 width=90) (actual time=0.045..0.045 rows=1 loops=1)

8. 0.021 0.021 ↑ 1.0 1 1

Index Only Scan using person_pkey on person p_10 (cost=0.42..2.44 rows=1 width=13) (actual time=0.021..0.021 rows=1 loops=1)

  • Index Cond: (personid = '127288'::bpchar)
  • Heap Fetches: 1
9. 0.021 0.021 ↑ 1.0 1 1

Index Only Scan using person_pkey on person p2_4 (cost=0.42..2.44 rows=1 width=13) (actual time=0.021..0.021 rows=1 loops=1)

  • Index Cond: (personid = '127288'::bpchar)
  • Heap Fetches: 1
10. 0.015 1.851 ↓ 0.0 0 1

Index Only Scan using person_pkey on person p_11 (cost=0.42..1,191.89 rows=1 width=94) (actual time=1.851..1.851 rows=0 loops=1)

  • Index Cond: (personid = '127288'::bpchar)
  • Filter: ((SubPlan 1) > 1)
  • Rows Removed by Filter: 1
  • Heap Fetches: 1
11.          

SubPlan (forIndex Only Scan)

12. 0.011 1.836 ↑ 1.0 1 1

Aggregate (cost=1,189.44..1,189.45 rows=1 width=8) (actual time=1.836..1.836 rows=1 loops=1)

13. 0.005 1.825 ↑ 502.3 3 1

Merge Append (cost=947.58..1,170.60 rows=1,507 width=65) (actual time=1.824..1.825 rows=3 loops=1)

  • Sort Key: co.companyid
14. 0.000 1.496 ↓ 0.0 0 1

Unique (cost=0.42..178.47 rows=1,489 width=65) (actual time=1.496..1.496 rows=0 loops=1)

15. 0.194 1.496 ↓ 0.0 0 1

Nested Loop (cost=0.42..173.93 rows=1,817 width=65) (actual time=1.496..1.496 rows=0 loops=1)

16. 1.302 1.302 ↑ 1.1 1,705 1

Index Scan using pk_companyname on companyname co (cost=0.28..150.06 rows=1,817 width=4) (actual time=0.017..1.302 rows=1,705 loops=1)

  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 890
17. 0.000 0.000 ↓ 0.0 0 1,705

Materialize (cost=0.14..1.17 rows=1 width=13) (actual time=0.000..0.000 rows=0 loops=1,705)

18. 0.013 0.013 ↓ 0.0 0 1

Index Only Scan using pk_assigned_roles on assigned_roles sr (cost=0.14..1.16 rows=1 width=13) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (personid = p_11.personid)
  • Heap Fetches: 0
19. 0.001 0.058 ↑ 2.0 1 1

Unique (cost=6.72..6.73 rows=2 width=65) (actual time=0.058..0.058 rows=1 loops=1)

20. 0.012 0.057 ↑ 1.0 2 1

Sort (cost=6.72..6.73 rows=2 width=65) (actual time=0.057..0.057 rows=2 loops=1)

  • Sort Key: pr_3.companyid
  • Sort Method: quicksort Memory: 25kB
21. 0.016 0.045 ↑ 1.0 2 1

Hash Join (cost=5.40..6.71 rows=2 width=65) (actual time=0.042..0.045 rows=2 loops=1)

  • Hash Cond: (person_company_rel_type.personcompanyreltype = pr_3.personcompanyreltype)
22. 0.008 0.008 ↑ 1.0 16 1

Seq Scan on person_company_rel_type (cost=0.00..1.21 rows=16 width=6) (actual time=0.006..0.008 rows=16 loops=1)

  • Filter: (personcompanyrelclass = 'MC'::bpchar)
  • Rows Removed by Filter: 1
23. 0.006 0.021 ↑ 1.0 2 1

Hash (cost=5.38..5.38 rows=2 width=23) (actual time=0.021..0.021 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
24. 0.015 0.015 ↑ 1.0 2 1

Index Scan using pk_person_company_rel on person_company_rel pr_3 (cost=0.28..5.38 rows=2 width=23) (actual time=0.015..0.015 rows=2 loops=1)

  • Index Cond: (personid = p_11.personid)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
25. 0.000 0.045 ↓ 0.0 0 1

Unique (cost=7.07..7.08 rows=1 width=65) (actual time=0.045..0.045 rows=0 loops=1)

26. 0.005 0.045 ↓ 0.0 0 1

Sort (cost=7.07..7.08 rows=1 width=65) (actual time=0.045..0.045 rows=0 loops=1)

  • Sort Key: oo.companyid
  • Sort Method: quicksort Memory: 25kB
27. 0.004 0.040 ↓ 0.0 0 1

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

28. 0.025 0.025 ↑ 1.0 1 1

Index Scan using personemploymentenddate on person_employment ep_1 (cost=0.43..4.52 rows=1 width=17) (actual time=0.025..0.025 rows=1 loops=1)

  • Index Cond: ((personid = p_11.personid) AND (CURRENT_DATE <= enddate) AND (CURRENT_DATE >= effectivedate))
  • Filter: ((emplstatus = 'A'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
29. 0.011 0.011 ↓ 0.0 0 1

Index Scan using pk_company_company_rel on company_company_rel oo (cost=0.28..2.53 rows=1 width=4) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((companyid = ep_1.companyid) AND (companyreltype = 'Af'::bpchar))
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
30. 0.000 0.020 ↓ 0.0 0 1

Unique (cost=12.13..12.14 rows=2 width=65) (actual time=0.020..0.020 rows=0 loops=1)

31. 0.007 0.020 ↓ 0.0 0 1

Sort (cost=12.13..12.14 rows=2 width=65) (actual time=0.020..0.020 rows=0 loops=1)

  • Sort Key: ol.companyid
  • Sort Method: quicksort Memory: 25kB
32. 0.002 0.013 ↓ 0.0 0 1

Nested Loop (cost=0.56..12.12 rows=2 width=65) (actual time=0.013..0.013 rows=0 loops=1)

33. 0.011 0.011 ↓ 0.0 0 1

Index Scan using pk_person_location_rel on person_location_rel pl_2 (cost=0.28..7.48 rows=2 width=17) (actual time=0.011..0.011 rows=0 loops=1)

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

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

  • Index Cond: (locationid = pl_2.locationid)
  • Filter: ((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
35. 0.001 0.053 ↓ 0.0 0 1

Unique (cost=232.50..232.51 rows=1 width=65) (actual time=0.053..0.053 rows=0 loops=1)

36. 0.007 0.052 ↓ 0.0 0 1

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

  • Sort Key: oc_3.companyid
  • Sort Method: quicksort Memory: 25kB
37. 0.000 0.045 ↓ 0.0 0 1

Nested Loop (cost=1.13..232.49 rows=1 width=65) (actual time=0.045..0.045 rows=0 loops=1)

38. 0.004 0.045 ↓ 0.0 0 1

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

39. 0.024 0.024 ↑ 1.0 1 1

Index Scan using pers_pospersendeff on pers_pos pc_1 (cost=0.42..2.46 rows=1 width=17) (actual time=0.024..0.024 rows=1 loops=1)

  • Index Cond: ((personid = p_11.personid) AND (CURRENT_DATE <= enddate) AND (CURRENT_DATE >= effectivedate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
40. 0.017 0.017 ↓ 0.0 0 1

Index Scan using posorgrelbyposition on pos_org_rel por_2 (cost=0.42..5.10 rows=1 width=8) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (positionid = pc_1.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[])))
  • Rows Removed by Filter: 3
41. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (organizationid = por_2.organizationid)
  • Filter: ((companyorganizationreltype = 'Mem'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
42. 0.000 0.022 ↑ 3.0 1 1

Unique (cost=4.51..4.52 rows=3 width=65) (actual time=0.022..0.022 rows=1 loops=1)

43. 0.011 0.022 ↑ 3.0 1 1

Sort (cost=4.51..4.51 rows=3 width=65) (actual time=0.022..0.022 rows=1 loops=1)

  • Sort Key: pe_15.companyid
  • Sort Method: quicksort Memory: 25kB
44. 0.011 0.011 ↑ 3.0 1 1

Index Scan using personemploymentenddate on person_employment pe_15 (cost=0.43..4.48 rows=3 width=65) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: ((personid = p_11.personid) AND (CURRENT_DATE <= enddate) AND (CURRENT_DATE >= effectivedate))
45. 0.007 0.036 ↑ 1.0 1 1

Sort (cost=6.91..6.92 rows=1 width=65) (actual time=0.036..0.036 rows=1 loops=1)

  • Sort Key: pd_4.companyid
  • Sort Method: quicksort Memory: 25kB
46. 0.004 0.029 ↑ 1.0 1 1

Nested Loop (cost=0.85..6.89 rows=1 width=65) (actual time=0.029..0.029 rows=1 loops=1)

47. 0.010 0.010 ↑ 1.0 1 1

Index Scan using pers_pospersendeff on pers_pos pp_13 (cost=0.42..2.46 rows=1 width=17) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: ((personid = p_11.personid) AND (CURRENT_DATE <= enddate) AND (CURRENT_DATE >= effectivedate))
  • Filter: ((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
48. 0.015 0.015 ↑ 1.0 1 1

Index Scan using pk_position_desc on position_desc pd_4 (cost=0.42..4.42 rows=1 width=8) (actual time=0.015..0.015 rows=1 loops=1)

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

Unique (cost=667.66..667.68 rows=4 width=65) (actual time=0.021..0.021 rows=0 loops=1)

50. 0.008 0.021 ↓ 0.0 0 1

Sort (cost=667.66..667.67 rows=4 width=65) (actual time=0.021..0.021 rows=0 loops=1)

  • Sort Key: oc_4.companyid
  • Sort Method: quicksort Memory: 25kB
51. 0.002 0.013 ↓ 0.0 0 1

Nested Loop (cost=0.56..667.62 rows=4 width=65) (actual time=0.013..0.013 rows=0 loops=1)

52. 0.011 0.011 ↓ 0.0 0 1

Index Scan using pk_person_organization_rel on person_organization_rel pc_2 (cost=0.28..7.96 rows=4 width=17) (actual time=0.011..0.011 rows=0 loops=1)

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

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

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

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

55. 0.005 0.018 ↓ 0.0 0 1

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

  • Sort Key: pu_2.companyid
  • Sort Method: quicksort Memory: 25kB
56. 0.002 0.013 ↓ 0.0 0 1

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

57. 0.011 0.011 ↓ 0.0 0 1

Index Scan using pk_person_pay_unit_rel on person_pay_unit_rel ppur (cost=0.27..3.32 rows=1 width=17) (actual time=0.010..0.011 rows=0 loops=1)

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

Index Scan using pk_pay_unit on pay_unit pu_2 (cost=0.15..2.17 rows=1 width=8) (never executed)

  • Index Cond: (payunitid = ppur.payunitid)
59. 0.000 0.024 ↓ 0.0 0 1

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

60. 0.014 0.024 ↓ 0.0 0 1

Sort (cost=2.50..2.50 rows=1 width=65) (actual time=0.024..0.024 rows=0 loops=1)

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

Index Scan using personemploymentenddate on person_employment pe_16 (cost=0.42..2.49 rows=1 width=65) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((personid = p_11.personid) AND (CURRENT_DATE < effectivedate))
  • Filter: (effectivedate < enddate)
62. 0.005 0.027 ↓ 0.0 0 1

Sort (cost=1.47..1.48 rows=2 width=65) (actual time=0.027..0.027 rows=0 loops=1)

  • Sort Key: cs_1.companyid
  • Sort Method: quicksort Memory: 25kB
63. 0.001 0.022 ↓ 0.0 0 1

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

  • Merge Cond: (cs_1.customerid = pcr_4.customerid)
64. 0.012 0.012 ↑ 173.0 1 1

Index Scan using pk_customer_struct on customer_struct cs_1 (cost=0.15..15.88 rows=173 width=8) (actual time=0.012..0.012 rows=1 loops=1)

  • Filter: ((companyid IS NOT NULL) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
65. 0.005 0.009 ↓ 0.0 0 1

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

  • Sort Key: pcr_4.customerid
  • Sort Method: quicksort Memory: 25kB
66. 0.004 0.004 ↓ 0.0 0 1

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

  • Filter: ((personid = p_11.personid) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 2
67. 0.001 0.030 ↓ 0.0 0 1

Nested Loop Semi Join (cost=1.50..4.70 rows=1 width=94) (actual time=0.030..0.030 rows=0 loops=1)

68. 0.012 0.012 ↑ 1.0 1 1

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

  • Index Cond: (personid = '127288'::bpchar)
  • Heap Fetches: 1
69. 0.010 0.017 ↓ 0.0 0 1

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

  • Hash Cond: (pcrt_3.personcustomerreltype = pcr_5.personcustomerreltype)
70. 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=6) (actual time=0.003..0.003 rows=1 loops=1)

  • Filter: (rolename IS NOT NULL)
71. 0.000 0.004 ↓ 0.0 0 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
72. 0.004 0.004 ↓ 0.0 0 1

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

  • Filter: ((personid = '127288'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 2
73. 0.002 0.042 ↓ 0.0 0 1

Materialize (cost=0.69..12.99 rows=2 width=9) (actual time=0.042..0.042 rows=0 loops=1)

74. 0.001 0.040 ↓ 0.0 0 1

Append (cost=0.69..12.98 rows=2 width=9) (actual time=0.040..0.040 rows=0 loops=1)

75. 0.000 0.015 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1_8 (cost=0.69..3.76 rows=1 width=9) (actual time=0.015..0.015 rows=0 loops=1)

76. 0.000 0.015 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.69..3.75 rows=1 width=261) (actual time=0.015..0.015 rows=0 loops=1)

77. 0.015 0.015 ↓ 0.0 0 1

Index Scan using idx_csc_neg_do_act on company_security_control sc1_1 (cost=0.28..2.30 rows=1 width=31) (actual time=0.014..0.015 rows=0 loops=1)

  • Index Cond: ((negative = false) AND ((domainobject)::text = 'CompanyStaffItem'::text) AND ((action)::text = 'Read'::text) AND (companyid = 876))
  • Filter: ((NOT negative) AND (roleinterest = 'X'::bpchar))
78. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_security_control on security_control sc3_2 (cost=0.41..1.44 rows=1 width=31) (never executed)

  • Index Cond: ((domainobject = (sc1_1.domainobject)::text) AND (domainobject = 'CompanyStaffItem'::text) AND (action = (sc1_1.action)::text) AND (action = 'Read'::text) AND (rolename = sc1_1.rolename))
  • Heap Fetches: 0
79. 0.000 0.024 ↓ 0.0 0 1

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

80. 0.000 0.024 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.84..9.21 rows=1 width=261) (actual time=0.024..0.024 rows=0 loops=1)

  • 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))
81. 0.001 0.024 ↓ 0.0 0 1

Nested Loop (cost=0.56..6.89 rows=1 width=35) (actual time=0.024..0.024 rows=0 loops=1)

82. 0.023 0.023 ↓ 0.0 0 1

Index Scan using idx_sc_do_act on security_control sc2_1 (cost=0.29..5.58 rows=1 width=31) (actual time=0.023..0.023 rows=0 loops=1)

  • Index Cond: (((domainobject)::text = 'CompanyStaffItem'::text) AND ((action)::text = 'Read'::text))
  • Filter: (roleinterest = 'X'::bpchar)
  • Rows Removed by Filter: 19
83. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (companyid = 876)
  • Heap Fetches: 0
84. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((negative = true) AND ((domainobject)::text = 'CompanyStaffItem'::text) AND ((action)::text = 'Read'::text) AND (companyid = 876))
  • Filter: negative
85. 0.000 0.000 ↓ 0.0 0

Hash Semi Join (cost=1,211.80..1,211.93 rows=4 width=0) (never executed)

  • Hash Cond: (ar_7.rolename = "*SELECT* 1_19".rolename)
86. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=1,202.72..1,202.76 rows=4 width=168) (never executed)

  • Group Key: ar_7.personid, ar_7.personid, ar_7.rolename, (''::text)
87. 0.000 0.000 ↓ 0.0 0

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

88. 0.000 0.000 ↓ 0.0 0

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

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

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

90. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

  • Index Cond: (personid = '127288'::bpchar)
  • Filter: ((SubPlan 5) > 1)
  • Heap Fetches: 0
93.          

SubPlan (forIndex Only Scan)

94. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=1,189.44..1,189.45 rows=1 width=8) (never executed)

95. 0.000 0.000 ↓ 0.0 0

Merge Append (cost=947.58..1,170.60 rows=1,507 width=65) (never executed)

  • Sort Key: co_1.companyid
96. 0.000 0.000 ↓ 0.0 0

Unique (cost=0.42..178.47 rows=1,489 width=65) (never executed)

97. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..173.93 rows=1,817 width=65) (never executed)

98. 0.000 0.000 ↓ 0.0 0

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

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

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

100. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (personid = p_34.personid)
  • Heap Fetches: 0
101. 0.000 0.000 ↓ 0.0 0

Unique (cost=6.72..6.73 rows=2 width=65) (never executed)

102. 0.000 0.000 ↓ 0.0 0

Sort (cost=6.72..6.73 rows=2 width=65) (never executed)

  • Sort Key: pr_10.companyid
103. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=5.40..6.71 rows=2 width=65) (never executed)

  • Hash Cond: (person_company_rel_type_1.personcompanyreltype = pr_10.personcompanyreltype)
104. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_company_rel_type person_company_rel_type_1 (cost=0.00..1.21 rows=16 width=6) (never executed)

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

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

106. 0.000 0.000 ↓ 0.0 0

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

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

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

108. 0.000 0.000 ↓ 0.0 0

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

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

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

110. 0.000 0.000 ↓ 0.0 0

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

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

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

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

Unique (cost=12.13..12.14 rows=2 width=65) (never executed)

113. 0.000 0.000 ↓ 0.0 0

Sort (cost=12.13..12.14 rows=2 width=65) (never executed)

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

Nested Loop (cost=0.56..12.12 rows=2 width=65) (never executed)

115. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

118. 0.000 0.000 ↓ 0.0 0

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

  • Sort Key: oc_9.companyid
119. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.13..232.49 rows=1 width=65) (never executed)

120. 0.000 0.000 ↓ 0.0 0

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

121. 0.000 0.000 ↓ 0.0 0

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

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

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

  • Index Cond: (positionid = pc_5.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[])))
123. 0.000 0.000 ↓ 0.0 0

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

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

Unique (cost=4.51..4.52 rows=3 width=65) (never executed)

125. 0.000 0.000 ↓ 0.0 0

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

  • Sort Key: pe_41.companyid
126. 0.000 0.000 ↓ 0.0 0

Index Scan using personemploymentenddate on person_employment pe_41 (cost=0.43..4.48 rows=3 width=65) (never executed)

  • Index Cond: ((personid = p_34.personid) AND (CURRENT_DATE <= enddate) AND (CURRENT_DATE >= effectivedate))
127. 0.000 0.000 ↓ 0.0 0

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

  • Sort Key: pd_7.companyid
128. 0.000 0.000 ↓ 0.0 0

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

129. 0.000 0.000 ↓ 0.0 0

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

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

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

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

Unique (cost=667.66..667.68 rows=4 width=65) (never executed)

132. 0.000 0.000 ↓ 0.0 0

Sort (cost=667.66..667.67 rows=4 width=65) (never executed)

  • Sort Key: oc_10.companyid
133. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..667.62 rows=4 width=65) (never executed)

134. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_person_organization_rel on person_organization_rel pc_6 (cost=0.28..7.96 rows=4 width=17) (never executed)

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

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

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

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

137. 0.000 0.000 ↓ 0.0 0

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

  • Sort Key: pu_7.companyid
138. 0.000 0.000 ↓ 0.0 0

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

139. 0.000 0.000 ↓ 0.0 0

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

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

Index Scan using pk_pay_unit on pay_unit pu_7 (cost=0.15..2.17 rows=1 width=8) (never executed)

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

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

142. 0.000 0.000 ↓ 0.0 0

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

  • Sort Key: pe_42.companyid
143. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((personid = p_34.personid) AND (CURRENT_DATE < effectivedate))
  • Filter: (effectivedate < enddate)
144. 0.000 0.000 ↓ 0.0 0

Sort (cost=1.47..1.48 rows=2 width=65) (never executed)

  • Sort Key: cs_4.companyid
145. 0.000 0.000 ↓ 0.0 0

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

  • Merge Cond: (cs_4.customerid = pcr_14.customerid)
146. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_customer_struct on customer_struct cs_4 (cost=0.15..15.88 rows=173 width=8) (never executed)

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

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

  • Sort Key: pcr_14.customerid
148. 0.000 0.000 ↓ 0.0 0

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

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

Nested Loop Semi Join (cost=1.50..4.70 rows=1 width=94) (never executed)

150. 0.000 0.000 ↓ 0.0 0

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

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

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

  • Hash Cond: (pcrt_10.personcustomerreltype = pcr_15.personcustomerreltype)
152. 0.000 0.000 ↓ 0.0 0

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

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

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

154. 0.000 0.000 ↓ 0.0 0

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

  • Filter: ((personid = '127288'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
155. 0.000 0.000 ↓ 0.0 0

Hash (cost=9.02..9.02 rows=5 width=9) (never executed)

156. 0.000 0.000 ↓ 0.0 0

Append (cost=0.69..9.02 rows=5 width=9) (never executed)

157. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1_19 (cost=0.69..3.76 rows=1 width=9) (never executed)

158. 0.000 0.000 ↓ 0.0 0

Nested Loop Anti Join (cost=0.69..3.75 rows=1 width=261) (never executed)

159. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((negative = false) AND ((domainobject)::text = 'CompanyStaffItem'::text) AND ((action)::text = 'Read'::text) AND (companyid = 876))
  • Filter: (NOT negative)
160. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_security_control on security_control sc3_8 (cost=0.41..1.44 rows=1 width=31) (never executed)

  • Index Cond: ((domainobject = (sc1_4.domainobject)::text) AND (domainobject = 'CompanyStaffItem'::text) AND (action = (sc1_4.action)::text) AND (action = 'Read'::text) AND (rolename = sc1_4.rolename))
  • Heap Fetches: 0
161. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2_19 (cost=3.00..5.26 rows=4 width=9) (never executed)

162. 0.000 0.000 ↓ 0.0 0

Merge Anti Join (cost=3.00..5.22 rows=4 width=261) (never executed)

  • Merge Cond: (sc2_4.rolename = sc3_9.rolename)
  • Join Filter: ((sc3_9.companyid = c_4.companyid) AND ((sc3_9.domainobject)::text = (sc2_4.domainobject)::text) AND ((sc3_9.action)::text = (sc2_4.action)::text))
163. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.69..2.87 rows=5 width=35) (never executed)

164. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_security_control on security_control sc2_4 (cost=0.41..1.51 rows=5 width=31) (never executed)

  • Index Cond: ((domainobject = 'CompanyStaffItem'::text) AND (action = 'Read'::text))
  • Heap Fetches: 0
165. 0.000 0.000 ↓ 0.0 0

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

166. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (companyid = 876)
  • Heap Fetches: 0
167. 0.000 0.000 ↓ 0.0 0

Sort (cost=2.31..2.32 rows=1 width=35) (never executed)

  • Sort Key: sc3_9.rolename
168. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((negative = true) AND ((domainobject)::text = 'CompanyStaffItem'::text) AND ((action)::text = 'Read'::text) AND (companyid = 876))
  • Filter: negative
169. 4.735 2,419.071 ↓ 12.0 4,024 1

Hash Anti Join (cost=363,774.38..1,661,742.54 rows=334 width=764) (actual time=2,414.060..2,419.071 rows=4,024 loops=1)

  • Hash Cond: (this_.personid = pe_3.personid)
170. 11.769 2,414.218 ↓ 6.0 4,024 1

Subquery Scan on this_ (cost=125,077.43..1,423,032.20 rows=668 width=751) (actual time=2,411.699..2,414.218 rows=4,024 loops=1)

  • Filter: ((alternatives: SubPlan 3 or hashed SubPlan 4) OR $157)
171. 12.088 811.816 ↓ 4.5 4,024 1

Sort (cost=125,077.43..125,079.66 rows=891 width=959) (actual time=810.747..811.816 rows=4,024 loops=1)

  • Sort Key: pn.lname
  • Sort Method: quicksort Memory: 2515kB
172. 13.619 799.728 ↓ 4.5 4,024 1

Hash Left Join (cost=82,120.20..125,033.78 rows=891 width=959) (actual time=574.150..799.728 rows=4,024 loops=1)

  • Hash Cond: (COALESCE(ppm.positionid, ppm2.positionid) = matrixorg.positionid)
173. 1.925 625.462 ↓ 4.5 4,024 1

Hash Left Join (cost=66,009.94..88,510.40 rows=891 width=484) (actual time=481.696..625.462 rows=4,024 loops=1)

  • Hash Cond: (COALESCE(ppm.positionid, ppm2.positionid) = budgetorg.positionid)
174. 1.178 398.980 ↓ 4.5 4,024 1

Hash Left Join (cost=39,068.04..61,566.16 rows=891 width=441) (actual time=256.823..398.980 rows=4,024 loops=1)

  • Hash Cond: (COALESCE(ppm.positionid, ppm2.positionid) = po_1.topositionid)
  • Join Filter: (NOT (SubPlan 15))
175. 3.205 390.103 ↓ 4.5 4,024 1

Nested Loop Left Join (cost=34,713.60..57,092.64 rows=891 width=428) (actual time=249.097..390.103 rows=4,024 loops=1)

176. 3.222 386.898 ↓ 4.5 4,024 1

Nested Loop Left Join (cost=34,713.18..55,087.45 rows=891 width=432) (actual time=249.090..386.898 rows=4,024 loops=1)

177. 3.088 383.676 ↓ 4.5 4,024 1

Nested Loop Left Join (cost=34,712.75..54,533.35 rows=891 width=425) (actual time=249.082..383.676 rows=4,024 loops=1)

178. 3.089 368.516 ↓ 4.5 4,024 1

Nested Loop Left Join (cost=34,710.63..48,252.57 rows=891 width=361) (actual time=249.066..368.516 rows=4,024 loops=1)

179. 3.203 345.307 ↓ 4.5 4,024 1

Nested Loop Left Join (cost=34,710.21..46,506.56 rows=891 width=338) (actual time=249.042..345.307 rows=4,024 loops=1)

  • Join Filter: ((CASE WHEN (ppm.effectivedate IS NULL) THEN ppm2.effectivedate ELSE CURRENT_DATE END >= oc.effectivedate) AND (CASE WHEN (ppm.effectivedate IS NULL) THEN ppm2.effectivedate ELSE CURRENT_DATE END <= oc.enddate))
  • Rows Removed by Join Filter: 89
180. 1.281 342.104 ↓ 4.5 4,024 1

Nested Loop Left Join (cost=34,709.92..46,203.66 rows=891 width=304) (actual time=249.033..342.104 rows=4,024 loops=1)

  • Join Filter: (((CURRENT_DATE >= pd.effectivedate) AND (CURRENT_DATE <= pd.enddate)) OR ((pe.effectivedate >= pd.effectivedate) AND (pe.effectivedate <= pd.enddate) AND (pd.enddate >= CURRENT_DATE)))
181. 3.250 336.799 ↓ 4.5 4,024 1

Nested Loop Left Join (cost=34,709.50..42,342.15 rows=891 width=272) (actual time=249.022..336.799 rows=4,024 loops=1)

182. 2.184 333.549 ↓ 4.5 4,024 1

Nested Loop Left Join (cost=34,709.22..42,049.43 rows=891 width=221) (actual time=249.019..333.549 rows=4,024 loops=1)

  • Join Filter: ((CASE WHEN (ppm.effectivedate IS NULL) THEN ppm2.effectivedate ELSE CURRENT_DATE END >= pl.effectivedate) AND (CASE WHEN (ppm.effectivedate IS NULL) THEN ppm2.effectivedate ELSE CURRENT_DATE END <= pl.enddate))
  • Rows Removed by Join Filter: 3350
183. 3.626 311.245 ↓ 4.5 4,024 1

Hash Left Join (cost=34,708.80..39,716.28 rows=891 width=214) (actual time=248.994..311.245 rows=4,024 loops=1)

  • Hash Cond: (COALESCE(ppm.positionid, ppm2.positionid) = por.positionid)
  • Join Filter: ((CASE WHEN (ppm.effectivedate IS NULL) THEN ppm2.effectivedate ELSE CURRENT_DATE END >= por.effectivedate) AND (CASE WHEN (ppm.effectivedate IS NULL) THEN ppm2.effectivedate ELSE CURRENT_DATE END <= por.enddate))
  • Rows Removed by Join Filter: 10
184. 2.967 143.449 ↓ 4.5 4,024 1

Nested Loop (cost=15,281.38..19,073.84 rows=891 width=210) (actual time=83.732..143.449 rows=4,024 loops=1)

185. 5.685 116.338 ↓ 3.7 4,024 1

Nested Loop Left Join (cost=15,280.96..16,863.55 rows=1,099 width=121) (actual time=83.703..116.338 rows=4,024 loops=1)

  • Join Filter: ((COALESCE(pec.emplstatus, pe.emplstatus))::text = "*SELECT* 1_1".emplstatus)
  • Rows Removed by Join Filter: 20120
186. 0.931 110.653 ↓ 3.7 4,024 1

Merge Left Join (cost=15,280.96..16,748.02 rows=1,099 width=91) (actual time=83.694..110.653 rows=4,024 loops=1)

  • Merge Cond: (pe.personid = ppm2.personid)
  • Join Filter: ((ppm.positionid IS NULL) AND (ppm2.perspospid = (SubPlan 14)))
187. 1.294 103.361 ↓ 3.7 4,024 1

Nested Loop (cost=11,738.81..13,191.48 rows=1,099 width=79) (actual time=77.569..103.361 rows=4,024 loops=1)

188. 0.000 102.067 ↓ 3.7 4,024 1

Gather Merge (cost=11,738.53..13,175.43 rows=1,099 width=79) (actual time=77.551..102.067 rows=4,024 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
189. 1.726 165.876 ↓ 3.1 2,012 2

Nested Loop Left Join (cost=10,738.52..12,051.78 rows=646 width=79) (actual time=65.063..82.938 rows=2,012 loops=2)

190. 7.142 140.006 ↓ 3.1 2,012 2

Merge Left Join (cost=10,738.09..10,804.25 rows=646 width=67) (actual time=65.014..70.003 rows=2,012 loops=2)

  • Merge Cond: (pe.personid = pi.personid)
191. 9.736 67.338 ↓ 3.1 2,012 2

Sort (cost=9,669.41..9,671.03 rows=646 width=63) (actual time=33.304..33.669 rows=2,012 loops=2)

  • Sort Key: pe.personid
  • Sort Method: quicksort Memory: 473kB
192. 0.298 57.602 ↓ 3.1 2,012 2

Nested Loop Left Join (cost=1.27..9,639.26 rows=646 width=63) (actual time=0.097..28.801 rows=2,012 loops=2)

193. 1.275 33.160 ↓ 3.1 2,012 2

Nested Loop Anti Join (cost=0.85..7,278.35 rows=646 width=54) (actual time=0.078..16.580 rows=2,012 loops=2)

194. 11.760 11.760 ↓ 2.1 2,012 2

Parallel Index Scan using employmentcompanyideffdt on person_employment pe (cost=0.42..4,480.39 rows=969 width=54) (actual time=0.041..5.880 rows=2,012 loops=2)

  • Index Cond: ((companyid = 876) AND (enddate >= CURRENT_DATE))
  • Filter: ((effectivedate < enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 2122
195. 20.125 20.125 ↓ 0.0 0 4,025

Index Scan using personemploymentenddate on person_employment fper (cost=0.42..2.96 rows=1 width=17) (actual time=0.005..0.005 rows=0 loops=4,025)

  • Index Cond: ((pe.personid = personid) AND (effectivedate > pe.effectivedate))
  • Filter: ((effectivedate < enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
196. 24.144 24.144 ↑ 1.0 1 4,024

Index Scan using personemploymentenddate on person_employment pec (cost=0.43..3.64 rows=1 width=26) (actual time=0.005..0.006 rows=1 loops=4,024)

  • Index Cond: ((pe.personid = personid) AND (CURRENT_DATE <= enddate) AND (CURRENT_DATE >= effectivedate))
  • Filter: ((companyid = 876) AND (pe.companyid = companyid) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 1
197. 62.370 65.526 ↓ 1.0 12,628 2

Sort (cost=1,068.68..1,099.69 rows=12,407 width=17) (actual time=31.650..32.763 rows=12,628 loops=2)

  • Sort Key: pi.personid
  • Sort Method: quicksort Memory: 1372kB
198. 3.156 3.156 ↓ 1.0 12,637 2

Seq Scan on person_image pi (cost=0.00..225.07 rows=12,407 width=17) (actual time=0.020..1.578 rows=12,637 loops=2)

199. 24.144 24.144 ↓ 0.0 0 4,024

Index Scan using pers_pospersendeff on pers_pos ppm (cost=0.42..1.92 rows=1 width=25) (actual time=0.006..0.006 rows=0 loops=4,024)

  • Index Cond: ((personid = pe.personid) AND (CURRENT_DATE <= enddate) AND (CURRENT_DATE >= effectivedate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
200. 0.000 0.000 ↑ 1.0 1 4,024

Materialize (cost=0.28..2.32 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=4,024)

201. 0.019 0.019 ↑ 1.0 1 1

Index Scan using pk_companyname on companyname cnam (cost=0.28..2.32 rows=1 width=4) (actual time=0.014..0.019 rows=1 loops=1)

  • Index Cond: (companyid = 876)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
202. 0.382 6.145 ↑ 1.7 197 1

Sort (cost=3,542.13..3,542.95 rows=328 width=29) (actual time=6.121..6.145 rows=197 loops=1)

  • Sort Key: ppm2.personid
  • Sort Method: quicksort Memory: 40kB
203. 5.763 5.763 ↑ 1.7 197 1

Index Scan using pers_pospositionid on pers_pos ppm2 (cost=0.42..3,528.43 rows=328 width=29) (actual time=1.211..5.763 rows=197 loops=1)

  • Index Cond: (CURRENT_DATE < effectivedate)
  • Filter: ((effectivedate < enddate) AND (persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 83
204.          

SubPlan (forMerge Left Join)

205. 0.027 0.216 ↑ 1.0 1 27

Aggregate (cost=2.48..2.49 rows=1 width=4) (actual time=0.008..0.008 rows=1 loops=27)

206. 0.189 0.189 ↑ 1.0 1 27

Index Scan using pers_pospersendeff on pers_pos ppm3 (cost=0.42..2.48 rows=1 width=4) (actual time=0.007..0.007 rows=1 loops=27)

  • Index Cond: ((personid = pe.personid) AND (CURRENT_DATE < effectivedate))
  • Filter: ((effectivedate < enddate) AND (persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
207. 0.000 0.000 ↑ 1.0 6 4,024

Materialize (cost=0.00..0.15 rows=6 width=32) (actual time=0.000..0.000 rows=6 loops=4,024)

208. 0.007 0.021 ↑ 1.0 6 1

Append (cost=0.00..0.12 rows=6 width=32) (actual time=0.002..0.021 rows=6 loops=1)

209. 0.001 0.002 ↑ 1.0 1 1

Subquery Scan on *SELECT* 1_1 (cost=0.00..0.02 rows=1 width=32) (actual time=0.001..0.002 rows=1 loops=1)

210. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=164) (actual time=0.001..0.001 rows=1 loops=1)

211. 0.001 0.002 ↑ 1.0 1 1

Subquery Scan on *SELECT* 2_1 (cost=0.00..0.02 rows=1 width=32) (actual time=0.001..0.002 rows=1 loops=1)

212. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=164) (actual time=0.001..0.001 rows=1 loops=1)

213. 0.001 0.002 ↑ 1.0 1 1

Subquery Scan on *SELECT* 3 (cost=0.00..0.02 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=1)

214. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=164) (actual time=0.001..0.001 rows=1 loops=1)

215. 0.001 0.002 ↑ 1.0 1 1

Subquery Scan on *SELECT* 4 (cost=0.00..0.02 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=1)

216. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=164) (actual time=0.001..0.001 rows=1 loops=1)

217. 0.001 0.003 ↑ 1.0 1 1

Subquery Scan on *SELECT* 5 (cost=0.00..0.02 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=1)

218. 0.002 0.002 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=164) (actual time=0.001..0.002 rows=1 loops=1)

219. 0.001 0.003 ↑ 1.0 1 1

Subquery Scan on *SELECT* 6 (cost=0.00..0.02 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=1)

220. 0.002 0.002 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=164) (actual time=0.002..0.002 rows=1 loops=1)

221. 24.144 24.144 ↑ 1.0 1 4,024

Index Scan using personnamepersonidnametype on person_names pn (cost=0.42..2.00 rows=1 width=102) (actual time=0.006..0.006 rows=1 loops=4,024)

  • Index Cond: ((personid = pe.personid) AND (nametype = 'Legal'::bpchar))
  • Filter: ((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts) AND (enddate = to_date('12/31/2199'::text, 'mm/dd/yyyy'::text)))
  • Rows Removed by Filter: 0
222. 31.268 164.170 ↓ 1.1 162,345 1

Hash (cost=17,651.85..17,651.85 rows=142,046 width=16) (actual time=164.170..164.170 rows=162,345 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 9658kB
223. 25.895 132.902 ↓ 1.1 162,345 1

Hash Join (cost=971.87..17,651.85 rows=142,046 width=16) (actual time=7.754..132.902 rows=162,345 loops=1)

  • Hash Cond: (por.organizationid = corf.organizationid)
224. 99.288 99.288 ↓ 1.1 162,516 1

Index Scan using posorgrelbyposition on pos_org_rel por (cost=0.42..12,960.21 rows=153,315 width=16) (actual time=0.016..99.288 rows=162,516 loops=1)

  • Index Cond: (posorgreltype = 'Member'::bpchar)
  • Filter: ((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 10984
225. 1.729 7.719 ↑ 1.0 14,978 1

Hash (cost=777.35..777.35 rows=15,528 width=4) (actual time=7.719..7.719 rows=14,978 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 655kB
226. 5.990 5.990 ↑ 1.0 14,978 1

Seq Scan on company_organization_rel corf (cost=0.00..777.35 rows=15,528 width=4) (actual time=0.008..5.990 rows=14,978 loops=1)

  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 3726
227. 20.120 20.120 ↑ 2.0 1 4,024

Index Scan using pk_person_locations on person_locations pl (cost=0.42..2.58 rows=2 width=28) (actual time=0.005..0.005 rows=1 loops=4,024)

  • Index Cond: (personid = pe.personid)
  • Filter: ((personlocationtype = 'P'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
228. 0.000 0.000 ↓ 0.0 0 4,024

Index Scan using locationcodeslocationid on location_codes lc (cost=0.28..0.32 rows=1 width=55) (actual time=0.000..0.000 rows=0 loops=4,024)

  • Index Cond: (locationid = pl.locationid)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
229. 4.024 4.024 ↓ 0.0 0 4,024

Index Scan using pk_position_desc on position_desc pd (cost=0.42..4.30 rows=1 width=40) (actual time=0.001..0.001 rows=0 loops=4,024)

  • Index Cond: (positionid = COALESCE(ppm.positionid, ppm2.positionid))
  • Filter: ((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts) AND (((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate)) OR (enddate >= CURRENT_DATE)))
  • Rows Removed by Filter: 0
230. 0.000 0.000 ↓ 0.0 0 4,024

Index Scan using organizationcodeorganizationid on organization_code oc (cost=0.29..0.32 rows=1 width=46) (actual time=0.000..0.000 rows=0 loops=4,024)

  • Index Cond: (organizationid = por.organizationid)
  • Filter: ((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
231. 20.120 20.120 ↓ 0.0 0 4,024

Index Scan using pk_person_net_contacts on person_net_contacts pnc (cost=0.42..1.95 rows=1 width=36) (actual time=0.005..0.005 rows=0 loops=4,024)

  • Index Cond: (personid = pe.personid)
  • Filter: ((netcontacttype = 'Email'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Rows Removed by Filter: 1
232. 0.000 12.072 ↓ 0.0 0 4,024

Nested Loop Left Join (cost=2.12..7.03 rows=2 width=76) (actual time=0.003..0.003 rows=0 loops=4,024)

233. 3.756 12.072 ↓ 0.0 0 4,024

Nested Loop Left Join (cost=1.70..6.29 rows=1 width=58) (actual time=0.003..0.003 rows=0 loops=4,024)

  • Join Filter: (pp.createts = "*SELECT* 1_2".createts)
  • Rows Removed by Join Filter: 0
234. 0.000 8.048 ↓ 0.0 0 4,024

Nested Loop (cost=1.70..6.22 rows=1 width=66) (actual time=0.002..0.002 rows=0 loops=4,024)

235. 0.004 8.048 ↓ 0.0 0 4,024

Nested Loop Left Join (cost=1.27..4.69 rows=1 width=51) (actual time=0.002..0.002 rows=0 loops=4,024)

236. 4.024 4.024 ↓ 0.0 0 4,024

Index Scan using pos_pos_topositionid on pos_pos po (cost=0.43..2.25 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=4,024)

  • Index Cond: ((COALESCE(ppm.positionid, ppm2.positionid) = topositionid) AND (CASE WHEN (ppm.effectivedate IS NULL) THEN ppm2.effectivedate ELSE CURRENT_DATE END >= effectivedate) AND (CASE WHEN (ppm.effectivedate IS NULL) THEN ppm2.effectivedate ELSE CURRENT_DATE END <= enddate) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
237. 0.268 4.020 ↑ 1.0 1 268

Nested Loop Left Join (cost=0.85..2.43 rows=1 width=39) (actual time=0.014..0.015 rows=1 loops=268)

238. 1.072 1.072 ↑ 1.0 1 268

Index Scan using pers_pospositionid on pers_pos pp (cost=0.42..0.71 rows=1 width=25) (actual time=0.003..0.004 rows=1 loops=268)

  • Index Cond: ((positionid = po.positionid) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
239. 0.536 2.680 ↑ 1.0 1 268

Nested Loop (cost=0.42..1.71 rows=1 width=27) (actual time=0.010..0.010 rows=1 loops=268)

240. 1.876 1.876 ↑ 1.0 1 268

Index Scan using personnamepersonidnametype on person_names pn_1 (cost=0.42..0.61 rows=1 width=33) (actual time=0.007..0.007 rows=1 loops=268)

  • Index Cond: ((pp.personid = personid) AND (nametype = 'Legal'::bpchar))
  • Filter: ((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts) AND (enddate = to_date('12/31/2199'::text, 'mm/dd/yyyy'::text)))
  • Rows Removed by Filter: 0
241. 0.268 0.268 ↑ 1.0 1 268

Seq Scan on name_type (cost=0.00..1.09 rows=1 width=6) (actual time=0.001..0.001 rows=1 loops=268)

  • Filter: (nametype = 'Legal'::bpchar)
  • Rows Removed by Filter: 6
242. 1.072 1.072 ↑ 1.0 1 268

Index Scan using pk_position_desc on position_desc pd_1 (cost=0.42..1.53 rows=1 width=23) (actual time=0.003..0.004 rows=1 loops=268)

  • Index Cond: (positionid = po.positionid)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
243. 0.000 0.268 ↑ 1.0 2 268

Append (cost=0.00..0.04 rows=2 width=4) (actual time=0.001..0.001 rows=2 loops=268)

244. 0.000 0.268 ↑ 1.0 1 268

Subquery Scan on *SELECT* 1_2 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=268)

245. 0.268 0.268 ↑ 1.0 1 268

Result (cost=0.00..0.01 rows=1 width=112) (actual time=0.000..0.001 rows=1 loops=268)

246. 0.000 0.000 ↑ 1.0 1 268

Subquery Scan on *SELECT* 2_2 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=268)

247. 0.000 0.000 ↑ 1.0 1 268

Result (cost=0.00..0.01 rows=1 width=112) (actual time=0.000..0.000 rows=1 loops=268)

248. 2.144 2.144 ↑ 2.0 1 268

Index Scan using personemploymentenddate on person_employment pe_1 (cost=0.43..0.72 rows=2 width=13) (actual time=0.007..0.008 rows=1 loops=268)

  • Index Cond: ((personid = pp.personid) AND (CURRENT_DATE <= enddate) AND (CURRENT_DATE >= effectivedate))
  • Filter: ((emplstatus <> 'T'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
249. 0.000 0.000 ↓ 0.0 0 4,024

Index Scan using personnamepersonidnametype on person_names mn (cost=0.42..0.61 rows=1 width=20) (actual time=0.000..0.000 rows=0 loops=4,024)

  • Index Cond: ((pp.personid = personid) AND (nametype = 'Legal'::bpchar))
  • Filter: ((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts) AND (enddate = to_date('12/31/2199'::text, 'mm/dd/yyyy'::text)))
  • Rows Removed by Filter: 0
250. 0.000 0.000 ↓ 0.0 0 4,024

Index Scan using pos_pos_topositionid on pos_pos mpp (cost=0.42..2.24 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=4,024)

  • Index Cond: ((topositionid = COALESCE(ppm.positionid, ppm2.positionid)) AND (CASE WHEN (ppm.effectivedate IS NULL) THEN ppm2.effectivedate ELSE CURRENT_DATE END >= effectivedate) AND (CASE WHEN (ppm.effectivedate IS NULL) THEN ppm2.effectivedate ELSE CURRENT_DATE END <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
251. 0.042 7.699 ↑ 1.7 113 1

Hash (cost=4,351.99..4,351.99 rows=196 width=21) (actual time=7.699..7.699 rows=113 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
252. 0.050 7.657 ↑ 1.7 113 1

Nested Loop Left Join (cost=2.12..4,351.99 rows=196 width=21) (actual time=1.468..7.657 rows=113 loops=1)

253. 0.069 6.025 ↑ 1.1 113 1

Nested Loop Left Join (cost=1.69..4,256.90 rows=129 width=21) (actual time=1.434..6.025 rows=113 loops=1)

  • Join Filter: (pp_1.createts = "*SELECT* 1_3".createts)
  • Rows Removed by Join Filter: 226
254. 0.082 5.956 ↑ 1.1 113 1

Nested Loop Left Join (cost=1.69..4,252.98 rows=129 width=29) (actual time=1.418..5.956 rows=113 loops=1)

255. 0.013 5.083 ↑ 1.1 113 1

Nested Loop (cost=0.85..3,721.68 rows=129 width=12) (actual time=1.353..5.083 rows=113 loops=1)

256. 4.505 4.505 ↑ 1.4 113 1

Index Scan using pos_pos_topositionid on pos_pos po_1 (cost=0.42..3,039.88 rows=156 width=12) (actual time=1.330..4.505 rows=113 loops=1)

  • Index Cond: ((CURRENT_DATE < effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 5
257. 0.565 0.565 ↑ 1.0 1 113

Index Scan using pk_position_desc on position_desc pd_2 (cost=0.42..4.36 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=113)

  • Index Cond: (positionid = po_1.positionid)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 2
258. 0.000 0.791 ↓ 0.0 0 113

Nested Loop Left Join (cost=0.85..4.11 rows=1 width=25) (actual time=0.007..0.007 rows=0 loops=113)

259. 0.339 0.339 ↓ 0.0 0 113

Index Scan using pers_pospositionid on pers_pos pp_1 (cost=0.42..2.39 rows=1 width=25) (actual time=0.002..0.003 rows=0 loops=113)

  • Index Cond: ((positionid = po_1.positionid) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
260. 0.040 0.480 ↑ 1.0 1 40

Nested Loop (cost=0.42..1.71 rows=1 width=13) (actual time=0.011..0.012 rows=1 loops=40)

261. 0.400 0.400 ↑ 1.0 1 40

Index Scan using personnamepersonidnametype on person_names pn_2 (cost=0.42..0.61 rows=1 width=19) (actual time=0.009..0.010 rows=1 loops=40)

  • Index Cond: ((pp_1.personid = personid) AND (nametype = 'Legal'::bpchar))
  • Filter: ((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts) AND (enddate = to_date('12/31/2199'::text, 'mm/dd/yyyy'::text)))
  • Rows Removed by Filter: 0
262. 0.040 0.040 ↑ 1.0 1 40

Seq Scan on name_type name_type_1 (cost=0.00..1.09 rows=1 width=6) (actual time=0.001..0.001 rows=1 loops=40)

  • Filter: (nametype = 'Legal'::bpchar)
  • Rows Removed by Filter: 6
263. 0.000 0.000 ↑ 1.0 2 113

Materialize (cost=0.00..0.06 rows=2 width=4) (actual time=0.000..0.000 rows=2 loops=113)

264. 0.001 0.008 ↑ 1.0 2 1

Append (cost=0.00..0.04 rows=2 width=4) (actual time=0.004..0.008 rows=2 loops=1)

265. 0.001 0.004 ↑ 1.0 1 1

Subquery Scan on *SELECT* 1_3 (cost=0.00..0.02 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=1)

266. 0.003 0.003 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=112) (actual time=0.003..0.003 rows=1 loops=1)

267. 0.000 0.003 ↑ 1.0 1 1

Subquery Scan on *SELECT* 2_3 (cost=0.00..0.02 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=1)

268. 0.003 0.003 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=112) (actual time=0.003..0.003 rows=1 loops=1)

269. 1.582 1.582 ↓ 0.0 0 113

Index Scan using personemploymentenddate on person_employment pe_2 (cost=0.43..0.72 rows=2 width=13) (actual time=0.014..0.014 rows=0 loops=113)

  • Index Cond: ((personid = pp_1.personid) AND (CURRENT_DATE <= enddate) AND (CURRENT_DATE >= effectivedate))
  • Filter: ((emplstatus <> 'T'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
270.          

SubPlan (forHash Left Join)

271. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=2.12..11.91 rows=2 width=0) (never executed)

272. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.69..11.17 rows=1 width=13) (never executed)

  • Join Filter: (pp_37.createts = "*SELECT* 1_20".createts)
273. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.69..11.10 rows=1 width=21) (never executed)

274. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.27..6.67 rows=1 width=25) (never executed)

275. 0.000 0.000 ↓ 0.0 0

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

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

Nested Loop Left Join (cost=0.85..4.19 rows=1 width=25) (never executed)

277. 0.000 0.000 ↓ 0.0 0

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

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

Nested Loop (cost=0.42..1.71 rows=1 width=13) (never executed)

279. 0.000 0.000 ↓ 0.0 0

Index Scan using personnamepersonidnametype on person_names pn_3 (cost=0.42..0.61 rows=1 width=19) (never executed)

  • Index Cond: ((pp_37.personid = personid) AND (nametype = 'Legal'::bpchar))
  • Filter: ((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts) AND (enddate = to_date('12/31/2199'::text, 'mm/dd/yyyy'::text)))
280. 0.000 0.000 ↓ 0.0 0

Seq Scan on name_type name_type_2 (cost=0.00..1.09 rows=1 width=6) (never executed)

  • Filter: (nametype = 'Legal'::bpchar)
281. 0.000 0.000 ↓ 0.0 0

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

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

Append (cost=0.00..0.04 rows=2 width=4) (never executed)

283. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1_20 (cost=0.00..0.02 rows=1 width=4) (never executed)

284. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=112) (never executed)

285. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2_20 (cost=0.00..0.02 rows=1 width=4) (never executed)

286. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=112) (never executed)

287. 0.000 0.000 ↓ 0.0 0

Index Scan using personemploymentenddate on person_employment pe_43 (cost=0.43..0.72 rows=2 width=13) (never executed)

  • Index Cond: ((personid = pp_37.personid) AND (CURRENT_DATE <= enddate) AND (CURRENT_DATE >= effectivedate))
  • Filter: ((emplstatus <> 'T'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
288. 16.230 224.557 ↓ 1.3 72,145 1

Hash (cost=26,244.81..26,244.81 rows=55,767 width=47) (actual time=224.557..224.557 rows=72,145 loops=1)

  • Buckets: 131072 (originally 65536) Batches: 1 (originally 1) Memory Usage: 6507kB
289. 6.605 208.327 ↓ 1.3 72,145 1

Subquery Scan on budgetorg (cost=25,344.11..26,244.81 rows=55,767 width=47) (actual time=184.124..208.327 rows=72,145 loops=1)

290. 11.068 201.722 ↓ 1.3 72,145 1

Unique (cost=25,344.11..25,687.14 rows=55,767 width=47) (actual time=184.121..201.722 rows=72,145 loops=1)

291. 35.586 190.654 ↓ 1.1 76,402 1

Sort (cost=25,344.11..25,515.63 rows=68,605 width=47) (actual time=184.119..190.654 rows=76,402 loops=1)

  • Sort Key: ccorg.positionid, ccorg.posorgpercent DESC
  • Sort Method: quicksort Memory: 10509kB
292. 8.314 155.068 ↓ 1.1 76,402 1

Merge Join (cost=1,859.14..19,833.07 rows=68,605 width=47) (actual time=9.478..155.068 rows=76,402 loops=1)

  • Merge Cond: (cc.organizationid = ccorg.organizationid)
293. 3.219 20.607 ↓ 1.1 13,690 1

Merge Join (cost=1,858.60..3,322.89 rows=12,984 width=42) (actual time=9.225..20.607 rows=13,690 loops=1)

  • Merge Cond: (cc.organizationid = corb.organizationid)
294. 7.076 7.076 ↓ 1.0 13,703 1

Index Scan using organizatincodeeffective on organization_code cc (cost=0.29..1,243.30 rows=13,646 width=38) (actual time=0.028..7.076 rows=13,703 loops=1)

  • Index Cond: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: ((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 1132
295. 4.105 10.312 ↑ 1.0 14,876 1

Sort (cost=1,858.30..1,897.12 rows=15,528 width=4) (actual time=9.186..10.312 rows=14,876 loops=1)

  • Sort Key: corb.organizationid
  • Sort Method: quicksort Memory: 1087kB
296. 6.207 6.207 ↑ 1.0 14,978 1

Seq Scan on company_organization_rel corb (cost=0.00..777.35 rows=15,528 width=4) (actual time=0.012..6.207 rows=14,978 loops=1)

  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 3726
297. 126.147 126.147 ↑ 1.1 77,072 1

Index Scan using posorgrelorganization on pos_org_rel ccorg (cost=0.43..15,596.62 rows=81,985 width=13) (actual time=0.246..126.147 rows=77,072 loops=1)

  • Index Cond: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: ((posorgreltype = 'Budget'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 125089
298. 3.662 92.239 ↑ 1.1 19,769 1

Hash (cost=15,844.33..15,844.33 rows=21,274 width=47) (actual time=92.239..92.239 rows=19,769 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1683kB
299. 1.806 88.577 ↑ 1.1 19,769 1

Subquery Scan on matrixorg (cost=15,525.22..15,844.33 rows=21,274 width=47) (actual time=84.012..88.577 rows=19,769 loops=1)

300. 2.044 86.771 ↑ 1.1 19,769 1

Unique (cost=15,525.22..15,631.59 rows=21,274 width=47) (actual time=84.008..86.771 rows=19,769 loops=1)

301. 4.814 84.727 ↑ 1.1 19,770 1

Sort (cost=15,525.22..15,578.41 rows=21,274 width=47) (actual time=84.008..84.727 rows=19,770 loops=1)

  • Sort Key: ccorg_1.positionid, ccorg_1.posorgpercent DESC
  • Sort Method: quicksort Memory: 2482kB
302. 3.437 79.913 ↑ 1.1 19,770 1

Hash Join (cost=2,712.01..13,995.96 rows=21,274 width=47) (actual time=20.790..79.913 rows=19,770 loops=1)

  • Hash Cond: (ccorg_1.organizationid = cc_1.organizationid)
303. 56.247 56.247 ↑ 1.3 19,781 1

Index Scan using posorgrelbyposition on pos_org_rel ccorg_1 (cost=0.42..10,690.29 rows=25,423 width=13) (actual time=0.541..56.247 rows=19,781 loops=1)

  • Index Cond: (posorgreltype = 'Matrix'::bpchar)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 36984
304. 2.804 20.229 ↓ 1.1 13,792 1

Hash (cost=2,549.28..2,549.28 rows=12,984 width=42) (actual time=20.228..20.229 rows=13,792 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 1164kB
305. 2.897 17.425 ↓ 1.1 13,792 1

Hash Join (cost=971.74..2,549.28 rows=12,984 width=42) (actual time=7.968..17.425 rows=13,792 loops=1)

  • Hash Cond: (cc_1.organizationid = corm.organizationid)
306. 6.660 6.660 ↓ 1.0 13,805 1

Index Scan using organizatincodeeffective on organization_code cc_1 (cost=0.29..1,243.30 rows=13,646 width=38) (actual time=0.019..6.660 rows=13,805 loops=1)

  • Index Cond: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: ((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 1132
307. 1.728 7.868 ↑ 1.0 14,978 1

Hash (cost=777.35..777.35 rows=15,528 width=4) (actual time=7.868..7.868 rows=14,978 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 655kB
308. 6.140 6.140 ↑ 1.0 14,978 1

Seq Scan on company_organization_rel corm (cost=0.00..777.35 rows=15,528 width=4) (actual time=0.011..6.140 rows=14,978 loops=1)

  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 3726
309.          

SubPlan (forHash Left Join)

310. 0.000 20.120 ↑ 1.0 1 4,024

Aggregate (cost=4.52..4.53 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=4,024)

311. 20.120 20.120 ↓ 0.0 0 4,024

Index Scan using pk_person_locations on person_locations futurepl (cost=0.42..4.52 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=4,024)

  • Index Cond: (personid = pe.personid)
  • Filter: ((effectivedate <= enddate) AND (personlocationtype = 'P'::bpchar) AND (CURRENT_DATE < effectivedate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 1
312. 0.000 4.024 ↑ 1.0 1 4,024

Aggregate (cost=3.12..3.13 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=4,024)

313. 4.024 4.024 ↓ 0.0 0 4,024

Index Scan using posorgrelbyposition on pos_org_rel futurepor (cost=0.42..3.11 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=4,024)

  • Index Cond: ((positionid = COALESCE(ppm.positionid, ppm2.positionid)) AND (posorgreltype = 'Member'::bpchar))
  • Filter: ((effectivedate <= enddate) AND (CURRENT_DATE < effectivedate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
314. 0.000 4.024 ↑ 1.0 1 4,024

Aggregate (cost=5.43..5.44 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=4,024)

315. 0.000 4.024 ↓ 0.0 0 4,024

Nested Loop (cost=0.71..5.42 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=4,024)

316. 4.024 4.024 ↓ 0.0 0 4,024

Index Scan using posorgrelbyposition on pos_org_rel ccorg_2 (cost=0.42..3.09 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=4,024)

  • Index Cond: ((positionid = COALESCE(ppm.positionid, ppm2.positionid)) AND (posorgreltype = 'Budget'::bpchar))
  • Filter: (CURRENT_DATE < effectivedate)
  • Rows Removed by Filter: 0
317. 0.081 0.081 ↑ 1.0 1 27

Index Scan using organizationcodeorganizationid on organization_code cc_2 (cost=0.29..2.33 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=27)

  • Index Cond: (organizationid = ccorg_2.organizationid)
  • Filter: ((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Rows Removed by Filter: 1
318. 20.120 20.120 ↓ 0.0 0 4,024

Index Scan using personemploymentenddate on person_employment pef (cost=0.42..2.50 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=4,024)

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

Index Scan using personemploymentenddate on person_employment pef_1 (cost=0.42..7,237.07 rows=335 width=13) (never executed)

  • Index Cond: (effectivedate > CURRENT_DATE)
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
320. 16.096 16.096 ↓ 0.0 0 4,024

Index Scan using personemploymentenddate on person_employment pefs (cost=0.42..2.50 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=4,024)

  • Index Cond: ((personid = pe.personid) AND (effectivedate > CURRENT_DATE))
  • Filter: ((effectivedate <= enddate) AND ((emplstatus)::text <> "*SELECT* 1_1".emplstatus) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
321. 0.000 4.024 ↑ 1.0 1 4,024

Aggregate (cost=4.79..4.79 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=4,024)

322. 0.000 4.024 ↓ 0.0 0 4,024

Nested Loop (cost=0.71..4.78 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=4,024)

323. 4.024 4.024 ↓ 0.0 0 4,024

Index Scan using posorgrelbyposition on pos_org_rel ccorg_3 (cost=0.42..2.45 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=4,024)

  • Index Cond: ((positionid = COALESCE(ppm.positionid, ppm2.positionid)) AND (posorgreltype = 'Matrix'::bpchar))
  • Filter: (CURRENT_DATE < effectivedate)
  • Rows Removed by Filter: 0
324. 0.087 0.087 ↑ 1.0 1 29

Index Scan using organizationcodeorganizationid on organization_code cc_3 (cost=0.29..2.33 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=29)

  • Index Cond: (organizationid = ccorg_3.organizationid)
  • Filter: ((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Rows Removed by Filter: 1
325.          

SubPlan (forSubquery Scan)

326. 0.000 0.000 ↓ 0.0 0

Hash Semi Join (cost=1,456.50..1,457.62 rows=5 width=0) (never executed)

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

HashAggregate (cost=1,447.42..1,447.89 rows=47 width=168) (never executed)

  • Group Key: ar_3.personid, pe_17.personid, ar_3.rolename, (''::text)
328. 0.000 0.000 ↓ 0.0 0

Append (cost=0.57..1,446.95 rows=47 width=168) (never executed)

329. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..5.69 rows=1 width=67) (never executed)

330. 0.000 0.000 ↓ 0.0 0

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

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

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

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

Subquery Scan on r_personcompanyroles_1 (cost=22.06..22.10 rows=2 width=172) (never executed)

333. 0.000 0.000 ↓ 0.0 0

Unique (cost=22.06..22.08 rows=2 width=140) (never executed)

334. 0.000 0.000 ↓ 0.0 0

Sort (cost=22.06..22.07 rows=2 width=140) (never executed)

  • Sort Key: pcr_6.personid, pe_18.personid, wr_8.rolename
335. 0.000 0.000 ↓ 0.0 0

Append (cost=7.00..22.05 rows=2 width=140) (never executed)

336. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=7.00..8.51 rows=1 width=35) (never executed)

337. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=6.86..8.11 rows=1 width=35) (never executed)

  • Hash Cond: (pcrt_4.personcompanyreltype = pcr_6.personcompanyreltype)
338. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_company_rel_type pcrt_4 (cost=0.00..1.17 rows=17 width=15) (never executed)

339. 0.000 0.000 ↓ 0.0 0

Hash (cost=6.85..6.85 rows=1 width=32) (never executed)

340. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..6.85 rows=1 width=32) (never executed)

341. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

Nested Loop (cost=1.69..13.52 rows=1 width=35) (never executed)

345. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.55..13.12 rows=1 width=35) (never executed)

  • Join Filter: (pcr_7.personcompanyreltype = pcrt_5.personcompanyreltype)
346. 0.000 0.000 ↓ 0.0 0

Nested Loop Anti Join (cost=1.55..11.74 rows=1 width=32) (never executed)

  • Join Filter: (pe_19.personid = pp_14.personid)
347. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.13..7.22 rows=1 width=32) (never executed)

348. 0.000 0.000 ↓ 0.0 0

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

349. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

Seq Scan on person_company_rel_type pcrt_5 (cost=0.00..1.17 rows=17 width=15) (never executed)

354. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (rolename = pcrt_5.rolename)
  • Heap Fetches: 0
355. 0.000 0.000 ↓ 0.0 0

Result (cost=0.84..30.21 rows=3 width=67) (never executed)

356. 0.000 0.000 ↓ 0.0 0

Append (cost=0.84..30.18 rows=3 width=35) (never executed)

357. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.84..8.94 rows=1 width=35) (never executed)

358. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.70..7.96 rows=1 width=35) (never executed)

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

Nested Loop (cost=0.70..6.84 rows=1 width=35) (never executed)

360. 0.000 0.000 ↓ 0.0 0

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

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

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

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

Seq Scan on person_location_rel_type plrt_3 (cost=0.00..1.05 rows=5 width=18) (never executed)

363. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (rolename = plrt_3.rolename)
  • Heap Fetches: 0
364. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.12..12.29 rows=1 width=35) (never executed)

  • Join Filter: (cl_1.companyid = pe_20.companyid)
365. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.70..7.77 rows=1 width=26) (never executed)

366. 0.000 0.000 ↓ 0.0 0

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

367. 0.000 0.000 ↓ 0.0 0

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

  • Join Filter: (plr_4.personlocationreltype = plrt_4.personlocationreltype)
368. 0.000 0.000 ↓ 0.0 0

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

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

Seq Scan on person_location_rel_type plrt_4 (cost=0.00..1.05 rows=5 width=18) (never executed)

370. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (rolename = plrt_4.companyrolename)
  • Heap Fetches: 0
371. 0.000 0.000 ↓ 0.0 0

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

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

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

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

Nested Loop (cost=0.84..8.92 rows=1 width=35) (never executed)

374. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.70..7.93 rows=1 width=62) (never executed)

  • Join Filter: (plr_5.personlocationreltype = plrt_5.personlocationreltype)
375. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.70..6.82 rows=1 width=35) (never executed)

376. 0.000 0.000 ↓ 0.0 0

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

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

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

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

Seq Scan on person_location_rel_type plrt_5 (cost=0.00..1.05 rows=5 width=45) (never executed)

379. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (rolename = plrt_5.proposalrolename)
  • Heap Fetches: 0
380. 0.000 0.000 ↓ 0.0 0

Result (cost=1.12..48.05 rows=4 width=74) (never executed)

381. 0.000 0.000 ↓ 0.0 0

Append (cost=1.12..48.01 rows=4 width=42) (never executed)

382. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.12..9.30 rows=1 width=35) (never executed)

383. 0.000 0.000 ↓ 0.0 0

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

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

Nested Loop (cost=0.70..6.83 rows=1 width=26) (never executed)

385. 0.000 0.000 ↓ 0.0 0

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

  • Join Filter: (port_4.personorganizationreltype = pp_15.personorganizationreltype)
386. 0.000 0.000 ↓ 0.0 0

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

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

Seq Scan on person_organization_rel_type port_4 (cost=0.00..1.05 rows=5 width=14) (never executed)

388. 0.000 0.000 ↓ 0.0 0

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

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

Nested Loop (cost=2.26..16.61 rows=1 width=35) (never executed)

  • Join Filter: (((pe_21.effectivedate - 1) >= op_4.effectivedate) AND ((pe_21.effectivedate - 1) <= op_4.enddate))
390. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.84..16.10 rows=1 width=43) (never executed)

391. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.70..15.94 rows=1 width=54) (never executed)

  • Join Filter: (cor_2.organizationid = oc_5.organizationid)
392. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.41..15.60 rows=1 width=55) (never executed)

  • Join Filter: (((pe_21.effectivedate - 1) >= pr_5.effectivedate) AND ((pe_21.effectivedate - 1) <= pr_5.enddate))
393. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.99..11.23 rows=1 width=47) (never executed)

394. 0.000 0.000 ↓ 0.0 0

Index Scan using personemploymentenddate on person_employment pe_21 (cost=0.43..4.52 rows=1 width=21) (never executed)

  • Index Cond: ((personid = this_.personid) AND (CURRENT_DATE <= enddate) AND (CURRENT_DATE >= effectivedate))
  • Filter: ((emplstatus = ANY ('{T,R,E}'::bpchar[])) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
395. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..6.70 rows=1 width=34) (never executed)

396. 0.000 0.000 ↓ 0.0 0

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

  • Join Filter: (port_5.personorganizationreltype = pp_16.personorganizationreltype)
397. 0.000 0.000 ↓ 0.0 0

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

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

Seq Scan on person_organization_rel_type port_5 (cost=0.00..1.05 rows=5 width=14) (never executed)

399. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((companyid = pe_21.companyid) AND (organizationid = pp_16.organizationid))
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
400. 0.000 0.000 ↓ 0.0 0

Index Scan using posorgrelorganization on pos_org_rel pr_5 (cost=0.42..3.68 rows=34 width=16) (never executed)

  • Index Cond: (organizationid = cor_2.organizationid)
  • Filter: ((posorgreltype = 'Member'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
401. 0.000 0.000 ↓ 0.0 0

Index Scan using organizationcodeorganizationid on organization_code oc_5 (cost=0.29..0.33 rows=1 width=15) (never executed)

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

Index Scan using pk_organization_type on organization_type ot_2 (cost=0.14..0.16 rows=1 width=11) (never executed)

  • Index Cond: (organizationtype = oc_5.organizationtype)
  • Filter: (organizationtypeclass = 'F'::bpchar)
403. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_pers_pos on pers_pos op_4 (cost=0.42..0.49 rows=1 width=25) (never executed)

  • Index Cond: ((personid = this_.personid) AND (positionid = pr_5.positionid))
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
404. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.55..12.75 rows=1 width=35) (never executed)

405. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.42..12.59 rows=1 width=46) (never executed)

406. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.13..12.20 rows=1 width=43) (never executed)

407. 0.000 0.000 ↓ 0.0 0

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

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

Nested Loop (cost=0.70..7.68 rows=1 width=34) (never executed)

409. 0.000 0.000 ↓ 0.0 0

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

410. 0.000 0.000 ↓ 0.0 0

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

  • Join Filter: (por_3.personorganizationreltype = port_6.personorganizationreltype)
411. 0.000 0.000 ↓ 0.0 0

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

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

Seq Scan on person_organization_rel_type port_6 (cost=0.00..1.05 rows=5 width=14) (never executed)

413. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (rolename = port_6.companyrolename)
  • Heap Fetches: 0
414. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((companyid = pe_22.companyid) AND (organizationid = por_3.organizationid))
  • Filter: ((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 organizationcodeorganizationid on organization_code oc_6 (cost=0.29..0.37 rows=1 width=15) (never executed)

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

Index Scan using pk_organization_type on organization_type ot_3 (cost=0.14..0.16 rows=1 width=11) (never executed)

  • Index Cond: (organizationtype = oc_6.organizationtype)
  • Filter: (organizationtypeclass = 'F'::bpchar)
417. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.12..9.31 rows=1 width=62) (never executed)

418. 0.000 0.000 ↓ 0.0 0

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

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

Nested Loop (cost=0.70..6.84 rows=1 width=69) (never executed)

420. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.28..4.36 rows=1 width=53) (never executed)

  • Join Filter: (port_7.personorganizationreltype = pp_17.personorganizationreltype)
421. 0.000 0.000 ↓ 0.0 0

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

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

Seq Scan on person_organization_rel_type port_7 (cost=0.00..1.05 rows=5 width=41) (never executed)

423. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_pos_org_rel on pos_org_rel pr_6 (cost=0.42..2.47 rows=1 width=24) (never executed)

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

Result (cost=0.97..18.02 rows=2 width=67) (never executed)

425. 0.000 0.000 ↓ 0.0 0

Append (cost=0.97..18.00 rows=2 width=35) (never executed)

426. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1_10 (cost=0.97..6.98 rows=1 width=35) (never executed)

427. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.97..6.97 rows=1 width=119) (never executed)

428. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..6.12 rows=1 width=35) (never executed)

  • Join Filter: ((pp_18.personpayunitreltype)::text = (ppurt_2.personpayunitreltype)::text)
429. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..4.98 rows=1 width=32) (never executed)

430. 0.000 0.000 ↓ 0.0 0

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

431. 0.000 0.000 ↓ 0.0 0

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

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

Index Only Scan using pk_pay_unit on pay_unit pu_3 (cost=0.15..2.17 rows=1 width=4) (never executed)

  • Index Cond: (payunitid = ep_2.payunitid)
  • Heap Fetches: 0
433. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_person_pay_unit_rel on person_pay_unit_rel pp_18 (cost=0.27..0.34 rows=1 width=23) (never executed)

  • Index Cond: ((personid = '127288'::bpchar) AND (payunitid = pu_3.payunitid))
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
434. 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=15) (never executed)

435. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (rolename = ppurt_2.rolename)
  • Heap Fetches: 0
436. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2_10 (cost=11.01..11.03 rows=1 width=35) (never executed)

437. 0.000 0.000 ↓ 0.0 0

Unique (cost=11.01..11.02 rows=1 width=119) (never executed)

438. 0.000 0.000 ↓ 0.0 0

Sort (cost=11.01..11.02 rows=1 width=119) (never executed)

  • Sort Key: wr_15.rolename
439. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.98..11.00 rows=1 width=119) (never executed)

  • Join Filter: (pu_4.companyid = pe_23.companyid)
440. 0.000 0.000 ↓ 0.0 0

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

441. 0.000 0.000 ↓ 0.0 0

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

  • Join Filter: ((pp_19.personpayunitreltype)::text = (ppurt_3.personpayunitreltype)::text)
442. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..4.48 rows=1 width=23) (never executed)

443. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_person_pay_unit_rel on person_pay_unit_rel pp_19 (cost=0.27..2.31 rows=1 width=23) (never executed)

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

Index Scan using pk_pay_unit on pay_unit pu_4 (cost=0.15..2.17 rows=1 width=8) (never executed)

  • Index Cond: (payunitid = pp_19.payunitid)
445. 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=15) (never executed)

446. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (rolename = ppurt_3.companyrolename)
  • Heap Fetches: 0
447. 0.000 0.000 ↓ 0.0 0

Index Scan using personemploymentenddate on person_employment pe_23 (cost=0.43..4.51 rows=2 width=17) (never executed)

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

Result (cost=0.85..25.92 rows=3 width=94) (never executed)

449. 0.000 0.000 ↓ 0.0 0

Append (cost=0.85..25.89 rows=3 width=62) (never executed)

450. 0.000 0.000 ↓ 0.0 0

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

451. 0.000 0.000 ↓ 0.0 0

Result (cost=0.85..6.98 rows=1 width=146) (never executed)

  • One-Time Filter: (this_.personid = '127288'::bpchar)
452. 0.000 0.000 ↓ 0.0 0

Nested Loop Semi Join (cost=0.85..6.98 rows=1 width=146) (never executed)

453. 0.000 0.000 ↓ 0.0 0

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

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

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

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

Subquery Scan on *SELECT* 2_11 (cost=1.27..9.46 rows=1 width=62) (never executed)

456. 0.000 0.000 ↓ 0.0 0

Result (cost=1.27..9.45 rows=1 width=146) (never executed)

  • One-Time Filter: (this_.personid = '127288'::bpchar)
457. 0.000 0.000 ↓ 0.0 0

Nested Loop Anti Join (cost=1.27..9.45 rows=1 width=146) (never executed)

  • Join Filter: (pe_25.personid = p_14.personid)
458. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.84..4.90 rows=1 width=13) (never executed)

459. 0.000 0.000 ↓ 0.0 0

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

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

Index Scan using pers_pospersendeff on pers_pos pp_20 (cost=0.42..2.45 rows=1 width=13) (never executed)

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

Result (cost=0.43..4.53 rows=1 width=13) (never executed)

  • One-Time Filter: (this_.personid = '127288'::bpchar)
462. 0.000 0.000 ↓ 0.0 0

Index Scan using personemploymentenddate on person_employment pe_25 (cost=0.43..4.53 rows=1 width=13) (never executed)

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

Subquery Scan on *SELECT* 3_4 (cost=1.27..9.45 rows=1 width=62) (never executed)

464. 0.000 0.000 ↓ 0.0 0

Result (cost=1.27..9.44 rows=1 width=146) (never executed)

  • One-Time Filter: (this_.personid = '127288'::bpchar)
465. 0.000 0.000 ↓ 0.0 0

Nested Loop Anti Join (cost=1.27..9.44 rows=1 width=146) (never executed)

  • Join Filter: (pp_21.personid = p1_4.personid)
466. 0.000 0.000 ↓ 0.0 0

Nested Loop Semi Join (cost=0.85..6.97 rows=1 width=13) (never executed)

467. 0.000 0.000 ↓ 0.0 0

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

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

Index Scan using personemploymentenddate on person_employment p_15 (cost=0.43..4.52 rows=1 width=13) (never executed)

  • Index Cond: ((personid = '127288'::bpchar) AND (CURRENT_DATE <= enddate) AND (CURRENT_DATE >= effectivedate))
  • Filter: ((emplstatus = ANY ('{T,E,R}'::bpchar[])) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
469. 0.000 0.000 ↓ 0.0 0

Result (cost=0.42..2.45 rows=1 width=13) (never executed)

  • One-Time Filter: (this_.personid = '127288'::bpchar)
470. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospersendeff on pers_pos pp_21 (cost=0.42..2.45 rows=1 width=13) (never executed)

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

Subquery Scan on r_personpeers_1 (cost=13.87..13.92 rows=2 width=172) (never executed)

472. 0.000 0.000 ↓ 0.0 0

Unique (cost=13.87..13.90 rows=2 width=224) (never executed)

473. 0.000 0.000 ↓ 0.0 0

Sort (cost=13.87..13.88 rows=2 width=224) (never executed)

  • Sort Key: mypos_2.personid, peers_1.personid, ('Peer '::character(8)), ('RoleEx_Peer '::character(20))
474. 0.000 0.000 ↓ 0.0 0

Append (cost=1.70..13.86 rows=2 width=224) (never executed)

475. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.70..8.34 rows=1 width=146) (never executed)

  • Join Filter: (peers_1.positionid = manages_1.topositionid)
476. 0.000 0.000 ↓ 0.0 0

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

  • Join Filter: (peers_1.personid <> mypos_2.personid)
477. 0.000 0.000 ↓ 0.0 0

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

478. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

Index Scan using pos_posposendeffendts on pos_pos manages_1 (cost=0.43..0.80 rows=9 width=8) (never executed)

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

Nested Loop (cost=1.27..5.51 rows=1 width=146) (never executed)

483. 0.000 0.000 ↓ 0.0 0

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

484. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

  • Index Cond: ((personid = this_.personid) AND (positionid = manager_3.positionid))
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
487. 0.000 0.000 ↓ 0.0 0

Result (cost=1.27..37.98 rows=4 width=114) (never executed)

488. 0.000 0.000 ↓ 0.0 0

Append (cost=1.27..37.94 rows=4 width=82) (never executed)

489. 0.000 0.000 ↓ 0.0 0

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

490. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.27..5.51 rows=1 width=146) (never executed)

491. 0.000 0.000 ↓ 0.0 0

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

492. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

Subquery Scan on *SELECT* 2_12 (cost=2.25..22.82 rows=1 width=62) (never executed)

496. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.25..22.81 rows=1 width=146) (never executed)

497. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.96..20.49 rows=1 width=34) (never executed)

498. 0.000 0.000 ↓ 0.0 0

Index Scan using processcontroloriginator on process_control pc_3 (cost=0.28..5.25 rows=1 width=21) (never executed)

  • Index Cond: (originator = '127288'::bpchar)
  • Filter: ((processstate = 'A'::bpchar) AND (processname = 'Hire'::bpchar))
499. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.68..15.23 rows=1 width=26) (never executed)

  • Join Filter: (p_17.personid <> pp_23.personid)
500. 0.000 0.000 ↓ 0.0 0

Nested Loop Anti Join (cost=1.26..12.78 rows=1 width=13) (never executed)

  • Join Filter: (pxp_1.personid = pp_23.personid)
501. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (personid = this_.personid)
  • Heap Fetches: 0
502. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.84..10.32 rows=6 width=13) (never executed)

503. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_pers_pos on pers_pos pxp_1 (cost=0.42..2.47 rows=3 width=17) (never executed)

  • Index Cond: (personid = this_.personid)
  • Heap Fetches: 0
504. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (topositionid = pxp_1.positionid)
  • Heap Fetches: 0
505. 0.000 0.000 ↓ 0.0 0

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

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

Index Scan using processlinkslogid on process_links pl_3 (cost=0.29..2.31 rows=1 width=21) (never executed)

  • Index Cond: ((processid = pc_3.processid) AND (logid = pc_3.logid))
  • Filter: ((entitykey = this_.personid) AND (subjectid = 'PERSON'::bpchar))
507. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 3_5 (cost=1.27..7.41 rows=1 width=62) (never executed)

508. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.27..7.40 rows=1 width=146) (never executed)

509. 0.000 0.000 ↓ 0.0 0

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

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

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

511. 0.000 0.000 ↓ 0.0 0

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

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

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

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

Subquery Scan on *SELECT* 4_2 (cost=0.15..2.19 rows=1 width=140) (never executed)

514. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_pers_pers on pers_pers pr_pr_1 (cost=0.15..2.18 rows=1 width=224) (never executed)

  • Index Cond: ((personid = this_.personid) AND (topersonid = '127288'::bpchar))
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (btrim((personreltype)::text) = 'PMgr'::text))
515. 0.000 0.000 ↓ 0.0 0

Result (cost=1.69..19.98 rows=6 width=94) (never executed)

516. 0.000 0.000 ↓ 0.0 0

Append (cost=1.69..19.92 rows=6 width=62) (never executed)

517. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1_13 (cost=1.69..6.10 rows=2 width=62) (never executed)

518. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.69..6.08 rows=2 width=146) (never executed)

519. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.69..6.02 rows=1 width=26) (never executed)

520. 0.000 0.000 ↓ 0.0 0

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

521. 0.000 0.000 ↓ 0.0 0

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

522. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

Append (cost=0.00..0.04 rows=2 width=36) (never executed)

527. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=36) (never executed)

528. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=36) (never executed)

529. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2_13 (cost=2.11..6.64 rows=2 width=62) (never executed)

530. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.11..6.62 rows=2 width=146) (never executed)

531. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.11..6.56 rows=1 width=26) (never executed)

532. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.69..6.01 rows=1 width=17) (never executed)

533. 0.000 0.000 ↓ 0.0 0

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

534. 0.000 0.000 ↓ 0.0 0

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

535. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

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

Append (cost=0.00..0.04 rows=2 width=36) (never executed)

541. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=36) (never executed)

542. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=36) (never executed)

543. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 3_6 (cost=2.53..7.18 rows=2 width=62) (never executed)

544. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.53..7.16 rows=2 width=146) (never executed)

545. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.53..7.10 rows=1 width=26) (never executed)

546. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.11..6.54 rows=1 width=17) (never executed)

547. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.69..6.01 rows=1 width=17) (never executed)

548. 0.000 0.000 ↓ 0.0 0

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

549. 0.000 0.000 ↓ 0.0 0

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

550. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

  • Index Cond: ((topositionid = p2_7.positionid) 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 pk_pers_pos on pers_pos p_21 (cost=0.42..0.55 rows=1 width=17) (never executed)

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

Append (cost=0.00..0.04 rows=2 width=36) (never executed)

557. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=36) (never executed)

558. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=36) (never executed)

559. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.98..1,192.68 rows=1 width=172) (never executed)

560. 0.000 0.000 ↓ 0.0 0

Index Scan using act_idx_var_nametext on act_ru_variable arv_1 (cost=0.55..1,027.09 rows=5 width=21) (never executed)

  • Index Cond: ((name_)::text = 'originatorID'::text)
  • Filter: ((text_)::character(12) = '127288'::bpchar)
561. 0.000 0.000 ↓ 0.0 0

Index Scan using act_idx_var_exe on act_ru_variable arv2_1 (cost=0.43..33.11 rows=1 width=21) (never executed)

  • Index Cond: ((execution_id_)::text = (arv_1.execution_id_)::text)
  • Filter: (((name_)::text = 'personID'::text) AND ((text_)::character(12) = this_.personid))
562. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.27..10.49 rows=1 width=94) (never executed)

563. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.99..8.13 rows=1 width=30) (never executed)

564. 0.000 0.000 ↓ 0.0 0

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

565. 0.000 0.000 ↓ 0.0 0

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

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

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

  • Index Cond: ((personid = '127288'::bpchar) AND (rolename = 'Onboard'::bpchar))
  • Heap Fetches: 0
567. 0.000 0.000 ↓ 0.0 0

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

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

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

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

Subquery Scan on *SELECT* 12_1 (cost=0.85..5.36 rows=16 width=90) (never executed)

570. 0.000 0.000 ↓ 0.0 0

Unique (cost=0.85..5.20 rows=16 width=90) (never executed)

571. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.85..5.20 rows=16 width=90) (never executed)

572. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_person_identity on person_identity p_22 (cost=0.42..2.50 rows=4 width=13) (never executed)

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

Materialize (cost=0.42..2.52 rows=4 width=13) (never executed)

574. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_person_identity on person_identity p2_8 (cost=0.42..2.50 rows=4 width=13) (never executed)

  • Index Cond: (personid = this_.personid)
  • Heap Fetches: 0
575. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 13_1 (cost=0.85..9.05 rows=1 width=90) (never executed)

576. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.85..9.04 rows=1 width=90) (never executed)

  • Join Filter: (pcr_8.companyid = pe_27.companyid)
577. 0.000 0.000 ↓ 0.0 0

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

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

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

  • Index Cond: ((personid = '127288'::bpchar) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (emplstatus <> ALL ('{T,E,R}'::bpchar[])) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
579. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.83..7.20 rows=1 width=67) (never executed)

  • Join Filter: (cs_2.companyid = pe_28.companyid)
580. 0.000 0.000 ↓ 0.0 0

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

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

Merge Join (cost=2.41..2.64 rows=3 width=26) (never executed)

  • Merge Cond: (cs_2.customerid = pcr_9.customerid)
582. 0.000 0.000 ↓ 0.0 0

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

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

Materialize (cost=2.26..2.27 rows=1 width=26) (never executed)

584. 0.000 0.000 ↓ 0.0 0

Sort (cost=2.26..2.27 rows=1 width=26) (never executed)

  • Sort Key: pcr_9.customerid
585. 0.000 0.000 ↓ 0.0 0

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

  • Hash Cond: (pcrt_6.personcustomerreltype = pcr_9.personcustomerreltype)
586. 0.000 0.000 ↓ 0.0 0

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

587. 0.000 0.000 ↓ 0.0 0

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

588. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_customer_rel pcr_9 (cost=0.00..1.06 rows=1 width=23) (never executed)

  • Filter: ((personid = '127288'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
589. 0.000 0.000 ↓ 0.0 0

Hash (cost=9.02..9.02 rows=5 width=9) (never executed)

590. 0.000 0.000 ↓ 0.0 0

Append (cost=0.69..9.02 rows=5 width=9) (never executed)

591. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 1_9 (cost=0.69..3.76 rows=1 width=9) (never executed)

592. 0.000 0.000 ↓ 0.0 0

Nested Loop Anti Join (cost=0.69..3.75 rows=1 width=261) (never executed)

593. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((negative = false) AND ((domainobject)::text = 'CompanyStaffItem'::text) AND ((action)::text = 'Read'::text) AND (companyid = 876))
  • Filter: (NOT negative)
594. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_security_control on security_control sc3_4 (cost=0.41..1.44 rows=1 width=31) (never executed)

  • Index Cond: ((domainobject = (sc1_2.domainobject)::text) AND (domainobject = 'CompanyStaffItem'::text) AND (action = (sc1_2.action)::text) AND (action = 'Read'::text) AND (rolename = sc1_2.rolename))
  • Heap Fetches: 0
595. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2_9 (cost=3.00..5.26 rows=4 width=9) (never executed)

596. 0.000 0.000 ↓ 0.0 0

Merge Anti Join (cost=3.00..5.22 rows=4 width=261) (never executed)

  • Merge Cond: (sc2_2.rolename = sc3_5.rolename)
  • 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))
597. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.69..2.87 rows=5 width=35) (never executed)

598. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_security_control on security_control sc2_2 (cost=0.41..1.51 rows=5 width=31) (never executed)

  • Index Cond: ((domainobject = 'CompanyStaffItem'::text) AND (action = 'Read'::text))
  • Heap Fetches: 0
599. 0.000 0.000 ↓ 0.0 0

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

600. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (companyid = 876)
  • Heap Fetches: 0
601. 0.000 0.000 ↓ 0.0 0

Sort (cost=2.31..2.32 rows=1 width=35) (never executed)

  • Sort Key: sc3_5.rolename
602. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((negative = true) AND ((domainobject)::text = 'CompanyStaffItem'::text) AND ((action)::text = 'Read'::text) AND (companyid = 876))
  • Filter: negative
603. 16.783 1,590.633 ↑ 42.3 8,311 1

Hash Semi Join (cost=210,286.03..231,874.66 rows=351,750 width=52) (actual time=1,532.560..1,590.633 rows=8,311 loops=1)

  • Hash Cond: (ar_5.rolename = "*SELECT* 1_14".rolename)
604. 36.569 1,573.714 ↑ 3.4 209,414 1

Unique (cost=210,276.95..219,070.69 rows=703,499 width=168) (actual time=1,529.446..1,573.714 rows=209,414 loops=1)

605. 857.635 1,537.145 ↑ 3.4 209,415 1

Sort (cost=210,276.95..212,035.70 rows=703,499 width=168) (actual time=1,529.438..1,537.145 rows=209,415 loops=1)

  • Sort Key: ar_5.personid, pe_29.personid, ar_5.rolename, (''::text)
  • Sort Method: quicksort Memory: 22505kB
606. 9.608 679.510 ↑ 3.4 209,415 1

Append (cost=0.57..108,974.46 rows=703,499 width=168) (actual time=36.633..679.510 rows=209,415 loops=1)

607. 0.003 0.019 ↓ 0.0 0 1

Nested Loop (cost=0.57..22,041.46 rows=58,551 width=67) (actual time=0.019..0.019 rows=0 loops=1)

608. 0.016 0.016 ↓ 0.0 0 1

Index Only Scan using pk_assigned_roles on assigned_roles ar_5 (cost=0.14..1.16 rows=1 width=22) (actual time=0.016..0.016 rows=0 loops=1)

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

Index Scan using employmentcompanyideffdt on person_employment pe_29 (cost=0.42..21,454.79 rows=58,551 width=13) (never executed)

  • Index Cond: (CURRENT_DATE <= enddate)
  • Filter: ((effectivedate <= enddate) AND (((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts)) OR (createts = endts)))
610. 0.549 38.586 ↓ 15.9 8,048 1

Subquery Scan on r_personcompanyroles_2 (cost=2,413.18..2,423.32 rows=507 width=172) (actual time=36.610..38.586 rows=8,048 loops=1)

611. 4.320 38.037 ↓ 15.9 8,048 1

HashAggregate (cost=2,413.18..2,418.25 rows=507 width=140) (actual time=36.606..38.037 rows=8,048 loops=1)

  • Group Key: pcr_10.personid, pe_30.personid, wr_16.rolename
612. 0.369 33.717 ↓ 16.0 8,104 1

Append (cost=3.92..2,409.38 rows=507 width=140) (actual time=0.134..33.717 rows=8,104 loops=1)

613. 0.570 14.491 ↓ 16.4 8,104 1

Nested Loop (cost=3.92..1,273.76 rows=494 width=35) (actual time=0.132..14.491 rows=8,104 loops=1)

614. 0.010 0.097 ↓ 2.0 2 1

Nested Loop (cost=3.49..5.00 rows=1 width=26) (actual time=0.083..0.097 rows=2 loops=1)

615. 0.025 0.065 ↓ 2.0 2 1

Hash Join (cost=3.35..4.59 rows=1 width=26) (actual time=0.059..0.065 rows=2 loops=1)

  • Hash Cond: (pcrt_7.personcompanyreltype = pcr_10.personcompanyreltype)
616. 0.010 0.010 ↑ 1.0 17 1

Seq Scan on person_company_rel_type pcrt_7 (cost=0.00..1.17 rows=17 width=15) (actual time=0.007..0.010 rows=17 loops=1)

617. 0.004 0.030 ↓ 2.0 2 1

Hash (cost=3.34..3.34 rows=1 width=23) (actual time=0.030..0.030 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
618. 0.026 0.026 ↓ 2.0 2 1

Index Scan using pk_person_company_rel on person_company_rel pcr_10 (cost=0.28..3.34 rows=1 width=23) (actual time=0.025..0.026 rows=2 loops=1)

  • Index Cond: (personid = '127288'::bpchar)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
619. 0.022 0.022 ↑ 1.0 1 2

Index Only Scan using pk_web_role on web_role wr_16 (cost=0.14..0.39 rows=1 width=9) (actual time=0.011..0.011 rows=1 loops=2)

  • Index Cond: (rolename = pcrt_7.rolename)
  • Heap Fetches: 2
620. 13.824 13.824 ↓ 11.3 4,052 2

Index Scan using employmentcompanyideffdt on person_employment pe_30 (cost=0.42..1,265.18 rows=359 width=17) (actual time=0.031..6.912 rows=4,052 loops=2)

  • Index Cond: ((companyid = pcr_10.companyid) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts)) OR (createts = endts)))
  • Rows Removed by Filter: 4217
621. 0.000 18.857 ↓ 0.0 0 1

Nested Loop (cost=1.83..1,130.54 rows=13 width=35) (actual time=18.857..18.857 rows=0 loops=1)

  • Join Filter: (pcrt_8.personcompanyreltype = pcr_11.personcompanyreltype)
622. 0.008 0.073 ↑ 1.0 17 1

Nested Loop (cost=0.28..10.08 rows=17 width=15) (actual time=0.031..0.073 rows=17 loops=1)

623. 0.014 0.014 ↑ 1.0 17 1

Index Scan using pk_person_company_rel_type on person_company_rel_type pcrt_8 (cost=0.14..3.39 rows=17 width=15) (actual time=0.010..0.014 rows=17 loops=1)

624. 0.051 0.051 ↑ 1.0 1 17

Index Only Scan using pk_web_role on web_role wr_17 (cost=0.14..0.39 rows=1 width=9) (actual time=0.003..0.003 rows=1 loops=17)

  • Index Cond: (rolename = pcrt_8.rolename)
  • Heap Fetches: 17
625. 0.008 18.785 ↓ 0.0 0 17

Materialize (cost=1.55..1,117.18 rows=13 width=32) (actual time=1.105..1.105 rows=0 loops=17)

626. 0.624 18.777 ↓ 0.0 0 1

Nested Loop Anti Join (cost=1.55..1,117.12 rows=13 width=32) (actual time=18.777..18.777 rows=0 loops=1)

627. 0.564 8.601 ↓ 27.4 1,592 1

Nested Loop (cost=1.13..1,054.41 rows=58 width=32) (actual time=0.073..8.601 rows=1,592 loops=1)

628. 0.154 2.871 ↓ 4.7 1,722 1

Nested Loop (cost=0.71..824.88 rows=367 width=23) (actual time=0.045..2.871 rows=1,722 loops=1)

629. 0.023 0.023 ↓ 2.0 2 1

Index Scan using pk_person_company_rel on person_company_rel pcr_11 (cost=0.28..3.34 rows=1 width=23) (actual time=0.019..0.023 rows=2 loops=1)

  • Index Cond: (personid = '127288'::bpchar)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
630. 2.694 2.694 ↓ 4.0 861 2

Index Scan using positioncompany on position_desc pd_6 (cost=0.42..819.40 rows=214 width=8) (actual time=0.014..1.347 rows=861 loops=2)

  • Index Cond: ((companyid = pcr_11.companyid) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 489
631. 5.166 5.166 ↑ 1.0 1 1,722

Index Scan using pers_pospositionid on pers_pos pp_25 (cost=0.42..0.62 rows=1 width=17) (actual time=0.003..0.003 rows=1 loops=1,722)

  • Index Cond: ((positionid = pd_6.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
632. 9.552 9.552 ↑ 1.0 1 1,592

Index Scan using personemploymentenddate on person_employment pe_31 (cost=0.42..1.07 rows=1 width=13) (actual time=0.006..0.006 rows=1 loops=1,592)

  • Index Cond: ((personid = pp_25.personid) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 1
633. 0.001 35.358 ↓ 0.0 0 1

Result (cost=1,005.46..13,113.74 rows=619 width=67) (actual time=35.358..35.358 rows=0 loops=1)

634. 0.000 35.357 ↓ 0.0 0 1

Append (cost=1,005.46..13,107.55 rows=619 width=35) (actual time=35.357..35.357 rows=0 loops=1)

635. 18.621 18.735 ↓ 0.0 0 1

Gather (cost=1,005.46..6,973.12 rows=60 width=35) (actual time=18.658..18.735 rows=0 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
636. 0.069 0.114 ↓ 0.0 0 2

Hash Join (cost=5.46..5,967.12 rows=35 width=35) (actual time=0.114..0.114 rows=0 loops=2)

  • Hash Cond: (lp_4.locationid = plr_6.locationid)
637. 0.015 0.015 ↑ 22,552.0 1 2

Parallel Seq Scan on person_locations lp_4 (cost=0.00..5,876.75 rows=22,552 width=17) (actual time=0.015..0.015 rows=1 loops=2)

  • Filter: ((effectivedate <= enddate) AND (personlocationtype = 'P'::bpchar) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
638. 0.001 0.030 ↓ 0.0 0 2

Hash (cost=5.45..5.45 rows=1 width=26) (actual time=0.030..0.030 rows=0 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
639. 0.000 0.029 ↓ 0.0 0 2

Nested Loop (cost=0.42..5.45 rows=1 width=26) (actual time=0.029..0.029 rows=0 loops=2)

640. 0.000 0.029 ↓ 0.0 0 2

Nested Loop (cost=0.28..4.46 rows=1 width=26) (actual time=0.029..0.029 rows=0 loops=2)

  • Join Filter: (plr_6.personlocationreltype = plrt_6.personlocationreltype)
641. 0.029 0.029 ↓ 0.0 0 2

Index Scan using pk_person_location_rel on person_location_rel plr_6 (cost=0.28..3.35 rows=1 width=26) (actual time=0.029..0.029 rows=0 loops=2)

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

Seq Scan on person_location_rel_type plrt_6 (cost=0.00..1.05 rows=5 width=18) (never executed)

643. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (rolename = plrt_6.rolename)
  • Heap Fetches: 0
644. 0.001 0.014 ↓ 0.0 0 1

Nested Loop (cost=1.12..79.83 rows=558 width=35) (actual time=0.014..0.014 rows=0 loops=1)

645. 0.003 0.013 ↓ 0.0 0 1

Nested Loop (cost=0.70..7.77 rows=1 width=26) (actual time=0.013..0.013 rows=0 loops=1)

646. 0.001 0.010 ↓ 0.0 0 1

Nested Loop (cost=0.42..5.45 rows=1 width=26) (actual time=0.010..0.010 rows=0 loops=1)

647. 0.002 0.009 ↓ 0.0 0 1

Nested Loop (cost=0.28..4.46 rows=1 width=26) (actual time=0.009..0.009 rows=0 loops=1)

  • Join Filter: (plr_7.personlocationreltype = plrt_7.personlocationreltype)
648. 0.007 0.007 ↓ 0.0 0 1

Index Scan using pk_person_location_rel on person_location_rel plr_7 (cost=0.28..3.35 rows=1 width=26) (actual time=0.007..0.007 rows=0 loops=1)

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

Seq Scan on person_location_rel_type plrt_7 (cost=0.00..1.05 rows=5 width=18) (never executed)

650. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (rolename = plrt_7.companyrolename)
  • Heap Fetches: 0
651. 0.000 0.000 ↓ 0.0 0

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

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

Index Scan using employmentcompanyideffdt on person_employment pe_32 (cost=0.42..68.48 rows=358 width=17) (never executed)

  • Index Cond: ((companyid = cl_2.companyid) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
653. 0.001 16.680 ↓ 0.0 0 1

Nested Loop (cost=1,003.50..6,048.41 rows=1 width=35) (actual time=16.680..16.680 rows=0 loops=1)

654. 0.000 16.679 ↓ 0.0 0 1

Nested Loop (cost=1,003.36..6,047.42 rows=1 width=62) (actual time=16.679..16.679 rows=0 loops=1)

  • Join Filter: (plr_8.personlocationreltype = plrt_8.personlocationreltype)
655. 15.868 16.749 ↓ 0.0 0 1

Gather (cost=1,003.36..6,046.31 rows=1 width=35) (actual time=16.677..16.749 rows=0 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
656. 0.070 0.881 ↓ 0.0 0 2

Hash Join (cost=3.36..5,046.21 rows=1 width=35) (actual time=0.881..0.881 rows=0 loops=2)

  • Hash Cond: (lp_5.locationid = plr_8.locationid)
657. 0.785 0.785 ↑ 141.0 1 2

Parallel Seq Scan on person_locations lp_5 (cost=0.00..5,042.31 rows=141 width=17) (actual time=0.785..0.785 rows=1 loops=2)

  • Filter: ((effectivedate <= enddate) AND (personlocationtype = 'P'::bpchar) AND (createts = endts) AND (CURRENT_DATE <= enddate))
  • Rows Removed by Filter: 5298
658. 0.000 0.026 ↓ 0.0 0 2

Hash (cost=3.35..3.35 rows=1 width=26) (actual time=0.026..0.026 rows=0 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
659. 0.026 0.026 ↓ 0.0 0 2

Index Scan using pk_person_location_rel on person_location_rel plr_8 (cost=0.28..3.35 rows=1 width=26) (actual time=0.026..0.026 rows=0 loops=2)

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

Seq Scan on person_location_rel_type plrt_8 (cost=0.00..1.05 rows=5 width=45) (never executed)

661. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (rolename = plrt_8.proposalrolename)
  • Heap Fetches: 0
662. 0.002 0.100 ↓ 0.0 0 1

Result (cost=1.12..416.83 rows=671 width=67) (actual time=0.100..0.100 rows=0 loops=1)

663. 0.021 0.098 ↓ 0.0 0 1

Append (cost=1.12..410.12 rows=671 width=35) (actual time=0.098..0.098 rows=0 loops=1)

664. 0.001 0.022 ↓ 0.0 0 1

Nested Loop (cost=1.12..44.51 rows=2 width=35) (actual time=0.022..0.022 rows=0 loops=1)

665. 0.001 0.021 ↓ 0.0 0 1

Nested Loop (cost=0.70..39.59 rows=7 width=26) (actual time=0.021..0.021 rows=0 loops=1)

666. 0.003 0.020 ↓ 0.0 0 1

Nested Loop (cost=0.28..4.36 rows=1 width=26) (actual time=0.020..0.020 rows=0 loops=1)

  • Join Filter: (port_8.personorganizationreltype = pp_26.personorganizationreltype)
667. 0.017 0.017 ↓ 0.0 0 1

Index Scan using pk_person_organization_rel on person_organization_rel pp_26 (cost=0.28..3.25 rows=1 width=22) (actual time=0.017..0.017 rows=0 loops=1)

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

Seq Scan on person_organization_rel_type port_8 (cost=0.00..1.05 rows=5 width=14) (never executed)

669. 0.000 0.000 ↓ 0.0 0

Index Scan using posorgrelorganization on pos_org_rel pr_7 (cost=0.42..35.18 rows=5 width=8) (never executed)

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

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

  • Index Cond: ((positionid = pr_7.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
671. 0.003 0.020 ↓ 0.0 0 1

Nested Loop (cost=2.25..91.54 rows=1 width=35) (actual time=0.019..0.020 rows=0 loops=1)

672. 0.002 0.017 ↓ 0.0 0 1

Nested Loop (cost=2.12..91.37 rows=1 width=46) (actual time=0.017..0.017 rows=0 loops=1)

  • Join Filter: (pp_27.organizationid = cor_4.organizationid)
673. 0.002 0.015 ↓ 0.0 0 1

Nested Loop (cost=1.83..91.03 rows=1 width=62) (actual time=0.015..0.015 rows=0 loops=1)

  • Join Filter: (((pe_33.effectivedate - 1) >= pr_8.effectivedate) AND ((pe_33.effectivedate - 1) <= pr_8.enddate))
674. 0.003 0.013 ↓ 0.0 0 1

Nested Loop (cost=1.41..35.54 rows=85 width=74) (actual time=0.013..0.013 rows=0 loops=1)

675. 0.001 0.010 ↓ 0.0 0 1

Nested Loop (cost=0.98..10.87 rows=46 width=57) (actual time=0.010..0.010 rows=0 loops=1)

  • Join Filter: (pp_27.organizationid = pr_8.organizationid)
676. 0.001 0.009 ↓ 0.0 0 1

Nested Loop (cost=0.56..6.69 rows=1 width=41) (actual time=0.009..0.009 rows=0 loops=1)

677. 0.002 0.008 ↓ 0.0 0 1

Nested Loop (cost=0.28..4.36 rows=1 width=26) (actual time=0.008..0.008 rows=0 loops=1)

  • Join Filter: (port_9.personorganizationreltype = pp_27.personorganizationreltype)
678. 0.006 0.006 ↓ 0.0 0 1

Index Scan using pk_person_organization_rel on person_organization_rel pp_27 (cost=0.28..3.25 rows=1 width=22) (actual time=0.006..0.006 rows=0 loops=1)

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

Seq Scan on person_organization_rel_type port_9 (cost=0.00..1.05 rows=5 width=14) (never executed)

680. 0.000 0.000 ↓ 0.0 0

Index Scan using organizationcodeorganizationid on organization_code oc_7 (cost=0.29..2.33 rows=1 width=15) (never executed)

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

Index Scan using posorgrelorganization on pos_org_rel pr_8 (cost=0.42..3.75 rows=34 width=16) (never executed)

  • Index Cond: (organizationid = oc_7.organizationid)
  • Filter: ((posorgreltype = 'Member'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
682. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos op_7 (cost=0.42..0.52 rows=2 width=25) (never executed)

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

Index Scan using personemploymentenddate on person_employment pe_33 (cost=0.43..0.63 rows=1 width=21) (never executed)

  • Index Cond: ((personid = op_7.personid) AND (CURRENT_DATE <= enddate) AND (CURRENT_DATE >= effectivedate))
  • Filter: ((emplstatus = ANY ('{T,R,E}'::bpchar[])) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts) AND ((effectivedate - 1) >= op_7.effectivedate) AND ((effectivedate - 1) <= op_7.enddate))
684. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((companyid = pe_33.companyid) AND (organizationid = pr_8.organizationid))
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
685. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_organization_type on organization_type ot_4 (cost=0.14..0.16 rows=1 width=11) (never executed)

  • Index Cond: (organizationtype = oc_7.organizationtype)
  • Filter: (organizationtypeclass = 'F'::bpchar)
686. 0.003 0.018 ↓ 0.0 0 1

Nested Loop (cost=1.42..222.70 rows=667 width=35) (actual time=0.018..0.018 rows=0 loops=1)

687. 0.002 0.015 ↓ 0.0 0 1

Nested Loop (cost=0.99..152.82 rows=1 width=26) (actual time=0.015..0.015 rows=0 loops=1)

  • Join Filter: (oc_8.organizationtype = ot_5.organizationtype)
688. 0.002 0.013 ↓ 0.0 0 1

Nested Loop (cost=0.99..151.62 rows=1 width=37) (actual time=0.013..0.013 rows=0 loops=1)

  • Join Filter: (por_4.organizationid = cor_5.organizationid)
689. 0.002 0.011 ↓ 0.0 0 1

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

690. 0.001 0.009 ↓ 0.0 0 1

Nested Loop (cost=0.42..5.34 rows=1 width=26) (actual time=0.009..0.009 rows=0 loops=1)

691. 0.001 0.008 ↓ 0.0 0 1

Nested Loop (cost=0.28..4.36 rows=1 width=26) (actual time=0.008..0.008 rows=0 loops=1)

  • Join Filter: (por_4.personorganizationreltype = port_10.personorganizationreltype)
692. 0.007 0.007 ↓ 0.0 0 1

Index Scan using pk_person_organization_rel on person_organization_rel por_4 (cost=0.28..3.25 rows=1 width=22) (actual time=0.007..0.007 rows=0 loops=1)

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

Seq Scan on person_organization_rel_type port_10 (cost=0.00..1.05 rows=5 width=14) (never executed)

694. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (rolename = port_10.companyrolename)
  • Heap Fetches: 0
695. 0.000 0.000 ↓ 0.0 0

Index Scan using organizationcodeorganizationid on organization_code oc_8 (cost=0.29..2.33 rows=1 width=15) (never executed)

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

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

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

Seq Scan on organization_type ot_5 (cost=0.00..1.14 rows=5 width=11) (never executed)

  • Filter: (organizationtypeclass = 'F'::bpchar)
698. 0.000 0.000 ↓ 0.0 0

Index Scan using employmentcompanyideffdt on person_employment pe_34 (cost=0.42..66.30 rows=358 width=17) (never executed)

  • Index Cond: ((companyid = cor_5.companyid) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
699. 0.002 0.017 ↓ 0.0 0 1

Nested Loop (cost=1.12..44.67 rows=1 width=62) (actual time=0.017..0.017 rows=0 loops=1)

700. 0.001 0.015 ↓ 0.0 0 1

Nested Loop (cost=0.70..39.71 rows=7 width=69) (actual time=0.015..0.015 rows=0 loops=1)

701. 0.002 0.014 ↓ 0.0 0 1

Nested Loop (cost=0.28..4.36 rows=1 width=53) (actual time=0.013..0.014 rows=0 loops=1)

  • Join Filter: (port_11.personorganizationreltype = pp_28.personorganizationreltype)
702. 0.012 0.012 ↓ 0.0 0 1

Index Scan using pk_person_organization_rel on person_organization_rel pp_28 (cost=0.28..3.25 rows=1 width=22) (actual time=0.012..0.012 rows=0 loops=1)

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

Seq Scan on person_organization_rel_type port_11 (cost=0.00..1.05 rows=5 width=41) (never executed)

704. 0.000 0.000 ↓ 0.0 0

Index Scan using posorgrelorganization on pos_org_rel pr_9 (cost=0.42..35.30 rows=5 width=24) (never executed)

  • Index Cond: ((organizationid = pp_28.organizationid) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (posorgreltype = 'Member'::bpchar) AND (((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts)) OR (createts = endts)))
705. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospositionid on pers_pos op_8 (cost=0.42..0.70 rows=1 width=33) (never executed)

  • Index Cond: ((positionid = pr_9.positionid) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (persposrel = 'Occupies'::bpchar) AND ((createts = endts) OR (pr_9.createts = pr_9.endts)) AND (((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts)) OR (createts = endts)))
706. 0.001 0.058 ↓ 0.0 0 1

Result (cost=0.85..215.08 rows=1,742 width=67) (actual time=0.058..0.058 rows=0 loops=1)

707. 0.002 0.057 ↓ 0.0 0 1

Append (cost=0.85..197.66 rows=1,742 width=35) (actual time=0.056..0.057 rows=0 loops=1)

708. 0.000 0.018 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1_15 (cost=0.85..35.66 rows=290 width=35) (actual time=0.018..0.018 rows=0 loops=1)

709. 0.002 0.018 ↓ 0.0 0 1

Nested Loop (cost=0.85..32.76 rows=290 width=119) (actual time=0.018..0.018 rows=0 loops=1)

710. 0.002 0.016 ↓ 0.0 0 1

Nested Loop (cost=0.56..6.46 rows=1 width=30) (actual time=0.016..0.016 rows=0 loops=1)

711. 0.001 0.014 ↓ 0.0 0 1

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

  • Join Filter: ((pp_29.personpayunitreltype)::text = (ppurt_4.personpayunitreltype)::text)
712. 0.001 0.013 ↓ 0.0 0 1

Nested Loop (cost=0.42..4.48 rows=1 width=27) (actual time=0.013..0.013 rows=0 loops=1)

713. 0.012 0.012 ↓ 0.0 0 1

Index Scan using pk_person_pay_unit_rel on person_pay_unit_rel pp_29 (cost=0.27..2.31 rows=1 width=23) (actual time=0.012..0.012 rows=0 loops=1)

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

Index Only Scan using pk_pay_unit on pay_unit pu_5 (cost=0.15..2.17 rows=1 width=4) (never executed)

  • Index Cond: (payunitid = pp_29.payunitid)
  • Heap Fetches: 0
715. 0.000 0.000 ↓ 0.0 0

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

716. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (rolename = ppurt_4.rolename)
  • Heap Fetches: 0
717. 0.000 0.000 ↓ 0.0 0

Index Scan using personpayrollpayunitid on person_payroll ep_3 (cost=0.29..22.75 rows=355 width=17) (never executed)

  • Index Cond: (payunitid = pu_5.payunitid)
  • Filter: ((payunitrelationship = 'M'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
718. 0.003 0.037 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_15 (cost=132.95..161.99 rows=1,452 width=35) (actual time=0.037..0.037 rows=0 loops=1)

719. 0.022 0.034 ↓ 0.0 0 1

HashAggregate (cost=132.95..147.47 rows=1,452 width=119) (actual time=0.034..0.034 rows=0 loops=1)

  • Group Key: pp_30.personid, pe_35.personid, wr_23.rolename, 'CompanyPayUnitRoles '::character(20)
720. 0.003 0.012 ↓ 0.0 0 1

Nested Loop (cost=0.98..118.43 rows=1,452 width=119) (actual time=0.012..0.012 rows=0 loops=1)

721. 0.001 0.009 ↓ 0.0 0 1

Nested Loop (cost=0.56..6.46 rows=1 width=26) (actual time=0.009..0.009 rows=0 loops=1)

722. 0.002 0.008 ↓ 0.0 0 1

Nested Loop (cost=0.42..5.62 rows=1 width=26) (actual time=0.008..0.008 rows=0 loops=1)

  • Join Filter: ((pp_30.personpayunitreltype)::text = (ppurt_5.personpayunitreltype)::text)
723. 0.001 0.006 ↓ 0.0 0 1

Nested Loop (cost=0.42..4.48 rows=1 width=23) (actual time=0.006..0.006 rows=0 loops=1)

724. 0.005 0.005 ↓ 0.0 0 1

Index Scan using pk_person_pay_unit_rel on person_pay_unit_rel pp_30 (cost=0.27..2.31 rows=1 width=23) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (personid = '127288'::bpchar)
  • 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_pay_unit on pay_unit pu_6 (cost=0.15..2.17 rows=1 width=8) (never executed)

  • Index Cond: (payunitid = pp_30.payunitid)
726. 0.000 0.000 ↓ 0.0 0

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

727. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (rolename = ppurt_5.companyrolename)
  • Heap Fetches: 0
728. 0.000 0.000 ↓ 0.0 0

Index Scan using employmentcompanyideffdt on person_employment pe_35 (cost=0.43..101.26 rows=1,071 width=17) (never executed)

  • Index Cond: ((companyid = pu_6.companyid) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: ((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
729. 0.001 0.183 ↑ 3.0 1 1

Result (cost=0.84..25.91 rows=3 width=94) (actual time=0.069..0.183 rows=1 loops=1)

730. 0.005 0.182 ↑ 3.0 1 1

Append (cost=0.84..25.88 rows=3 width=62) (actual time=0.068..0.182 rows=1 loops=1)

731. 0.002 0.067 ↑ 1.0 1 1

Subquery Scan on *SELECT* 1_16 (cost=0.84..6.98 rows=1 width=62) (actual time=0.067..0.067 rows=1 loops=1)

732. 0.010 0.065 ↑ 1.0 1 1

Nested Loop Semi Join (cost=0.84..6.97 rows=1 width=146) (actual time=0.065..0.065 rows=1 loops=1)

733. 0.028 0.028 ↑ 1.0 1 1

Index Only Scan using person_pkey on person p_23 (cost=0.42..2.44 rows=1 width=13) (actual time=0.027..0.028 rows=1 loops=1)

  • Index Cond: (personid = '127288'::bpchar)
  • Heap Fetches: 1
734. 0.027 0.027 ↑ 1.0 1 1

Index Scan using personemploymentenddate on person_employment pe_36 (cost=0.42..4.53 rows=1 width=13) (actual time=0.027..0.027 rows=1 loops=1)

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

Subquery Scan on *SELECT* 2_16 (cost=1.27..9.45 rows=1 width=62) (actual time=0.071..0.071 rows=0 loops=1)

736. 0.007 0.070 ↓ 0.0 0 1

Nested Loop Anti Join (cost=1.27..9.44 rows=1 width=146) (actual time=0.070..0.070 rows=0 loops=1)

  • Join Filter: (pe_37.personid = p_24.personid)
737. 0.008 0.045 ↑ 1.0 1 1

Nested Loop (cost=0.84..4.90 rows=1 width=13) (actual time=0.044..0.045 rows=1 loops=1)

738. 0.014 0.014 ↑ 1.0 1 1

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

  • Index Cond: (personid = '127288'::bpchar)
  • Heap Fetches: 1
739. 0.023 0.023 ↑ 1.0 1 1

Index Scan using pers_pospersendeff on pers_pos pp_31 (cost=0.42..2.45 rows=1 width=13) (actual time=0.023..0.023 rows=1 loops=1)

  • Index Cond: ((personid = '127288'::bpchar) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
740. 0.018 0.018 ↑ 1.0 1 1

Index Scan using personemploymentenddate on person_employment pe_37 (cost=0.43..4.53 rows=1 width=13) (actual time=0.018..0.018 rows=1 loops=1)

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

Subquery Scan on *SELECT* 3_7 (cost=1.27..9.45 rows=1 width=62) (actual time=0.039..0.039 rows=0 loops=1)

742. 0.002 0.038 ↓ 0.0 0 1

Nested Loop Anti Join (cost=1.27..9.44 rows=1 width=146) (actual time=0.038..0.038 rows=0 loops=1)

  • Join Filter: (pp_32.personid = p1_8.personid)
743. 0.005 0.036 ↓ 0.0 0 1

Nested Loop Semi Join (cost=0.85..6.97 rows=1 width=13) (actual time=0.036..0.036 rows=0 loops=1)

744. 0.017 0.017 ↑ 1.0 1 1

Index Only Scan using person_pkey on person p1_8 (cost=0.42..2.44 rows=1 width=13) (actual time=0.017..0.017 rows=1 loops=1)

  • Index Cond: (personid = '127288'::bpchar)
  • Heap Fetches: 1
745. 0.014 0.014 ↓ 0.0 0 1

Index Scan using personemploymentenddate on person_employment p_25 (cost=0.43..4.52 rows=1 width=13) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: ((personid = '127288'::bpchar) AND (CURRENT_DATE <= enddate) AND (CURRENT_DATE >= effectivedate))
  • Filter: ((emplstatus = ANY ('{T,E,R}'::bpchar[])) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 1
746. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pospersendeff on pers_pos pp_32 (cost=0.42..2.45 rows=1 width=13) (never executed)

  • Index Cond: ((personid = '127288'::bpchar) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
747. 0.002 0.183 ↑ 32.0 1 1

Subquery Scan on r_personpeers_2 (cost=37.84..38.48 rows=32 width=172) (actual time=0.183..0.183 rows=1 loops=1)

748. 0.008 0.181 ↑ 32.0 1 1

HashAggregate (cost=37.84..38.16 rows=32 width=224) (actual time=0.181..0.181 rows=1 loops=1)

  • Group Key: mypos_4.personid, peers_2.personid, ('Peer '::character(8)), ('RoleEx_Peer '::character(20))
749. 0.001 0.173 ↑ 32.0 1 1

Append (cost=1.70..37.52 rows=32 width=224) (actual time=0.172..0.173 rows=1 loops=1)

750. 0.008 0.110 ↓ 0.0 0 1