explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xrsX

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 1.195 ↑ 16.0 3 1

HashAggregate (cost=787.41..787.89 rows=48 width=176) (actual time=1.194..1.195 rows=3 loops=1)

  • Group Key: ar.personid, p.personid, ar.rolename, (''::text), p.companyid, p.customerid
2. 0.006 1.181 ↑ 2.4 20 1

Append (cost=0.83..786.69 rows=48 width=176) (actual time=0.375..1.181 rows=20 loops=1)

3. 0.000 0.025 ↓ 0.0 0 1

Nested Loop (cost=0.83..21.51 rows=1 width=75) (actual time=0.025..0.025 rows=0 loops=1)

4. 0.001 0.025 ↓ 0.0 0 1

Nested Loop (cost=0.42..13.06 rows=1 width=35) (actual time=0.025..0.025 rows=0 loops=1)

5. 0.024 0.024 ↓ 0.0 0 1

Seq Scan on assigned_roles ar (cost=0.00..4.60 rows=1 width=22) (actual time=0.024..0.024 rows=0 loops=1)

  • Filter: (personid = '27192'::bpchar)
  • Rows Removed by Filter: 208
6. 0.000 0.000 ↓ 0.0 0

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

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

Index Scan using person_pkey on person p (cost=0.41..8.43 rows=1 width=21) (never executed)

  • Index Cond: (personid = '304128'::bpchar)
8. 0.002 0.350 ↑ 2.0 1 1

Subquery Scan on r_personcompanyroles (cost=63.64..63.69 rows=2 width=180) (actual time=0.349..0.350 rows=1 loops=1)

9. 0.001 0.348 ↑ 2.0 1 1

Unique (cost=63.64..63.67 rows=2 width=148) (actual time=0.347..0.348 rows=1 loops=1)

10. 0.009 0.347 ↑ 2.0 1 1

Sort (cost=63.64..63.65 rows=2 width=148) (actual time=0.347..0.347 rows=1 loops=1)

  • Sort Key: pcr.personid, p_1.personid, wr.rolename, p_1.companyid, p_1.customerid
  • Sort Method: quicksort Memory: 25kB
11. 0.000 0.338 ↑ 2.0 1 1

Append (cost=1.25..63.63 rows=2 width=148) (actual time=0.066..0.338 rows=1 loops=1)

12. 0.001 0.069 ↑ 1.0 1 1

Nested Loop (cost=1.25..27.46 rows=1 width=43) (actual time=0.066..0.069 rows=1 loops=1)

13. 0.002 0.053 ↑ 1.0 1 1

Nested Loop (cost=0.84..19.02 rows=1 width=35) (actual time=0.050..0.053 rows=1 loops=1)

14. 0.001 0.044 ↑ 1.0 1 1

Nested Loop (cost=0.70..18.21 rows=1 width=62) (actual time=0.042..0.044 rows=1 loops=1)

  • Join Filter: (pcr.personcompanyreltype = pcrt.personcompanyreltype)
15. 0.000 0.039 ↑ 1.0 1 1

Nested Loop (cost=0.70..16.78 rows=1 width=32) (actual time=0.037..0.039 rows=1 loops=1)

16. 0.025 0.025 ↑ 1.0 1 1

Index Scan using personemploymentenddate on person_employment pe_1 (cost=0.42..8.45 rows=1 width=17) (actual time=0.024..0.025 rows=1 loops=1)

  • Index Cond: ((personid = '304128'::bpchar) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts)) OR (createts = endts)))
17. 0.014 0.014 ↑ 1.0 1 1

Index Scan using personcompanybycompany on person_company_rel pcr (cost=0.28..8.32 rows=1 width=23) (actual time=0.012..0.014 rows=1 loops=1)

  • Index Cond: ((companyid = pe_1.companyid) AND (personid = '27192'::bpchar))
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 6
18. 0.004 0.004 ↑ 19.0 1 1

Seq Scan on person_company_rel_type pcrt (cost=0.00..1.19 rows=19 width=60) (actual time=0.004..0.004 rows=1 loops=1)

19. 0.007 0.007 ↑ 1.0 1 1

Index Only Scan using web_role_pkey on web_role wr (cost=0.14..0.79 rows=1 width=9) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (rolename = pcrt.rolename)
  • Heap Fetches: 1
20. 0.015 0.015 ↑ 1.0 1 1

Index Scan using person_pkey on person p_1 (cost=0.41..8.43 rows=1 width=21) (actual time=0.014..0.015 rows=1 loops=1)

  • Index Cond: (personid = '304128'::bpchar)
21. 0.003 0.269 ↓ 0.0 0 1

Nested Loop Anti Join (cost=1.83..36.15 rows=1 width=43) (actual time=0.268..0.269 rows=0 loops=1)

  • Join Filter: (pe_2.personid = pp.personid)
22. 0.001 0.228 ↑ 1.0 1 1

Nested Loop (cost=1.42..27.69 rows=1 width=43) (actual time=0.175..0.228 rows=1 loops=1)

23. 0.003 0.212 ↑ 1.0 1 1

Nested Loop (cost=1.00..19.25 rows=1 width=35) (actual time=0.160..0.212 rows=1 loops=1)

24. 0.042 0.200 ↑ 1.0 1 1

Nested Loop (cost=0.86..18.44 rows=1 width=62) (actual time=0.148..0.200 rows=1 loops=1)

  • Join Filter: (pcr_1.personcompanyreltype = pcrt_1.personcompanyreltype)
25. 0.002 0.153 ↑ 1.0 1 1

Nested Loop (cost=0.86..17.01 rows=1 width=32) (actual time=0.141..0.153 rows=1 loops=1)

26. 0.002 0.040 ↑ 1.0 1 1

Nested Loop (cost=0.58..16.66 rows=1 width=17) (actual time=0.030..0.040 rows=1 loops=1)

27. 0.025 0.025 ↑ 1.0 1 1

Index Scan using pers_pos_personid_idx on pers_pos pp (cost=0.29..8.32 rows=1 width=17) (actual time=0.021..0.025 rows=1 loops=1)

  • Index Cond: (personid = '304128'::bpchar)
  • Filter: ((effectivedate <= enddate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 2
28. 0.013 0.013 ↑ 1.0 1 1

Index Scan using position_desc_positionid_idx on position_desc pd (cost=0.29..8.32 rows=1 width=8) (actual time=0.008..0.013 rows=1 loops=1)

  • Index Cond: (positionid = pp.positionid)
  • Filter: ((effectivedate <= enddate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 5
29. 0.111 0.111 ↑ 1.0 1 1

Index Scan using personcompanybycompany on person_company_rel pcr_1 (cost=0.28..0.34 rows=1 width=23) (actual time=0.109..0.111 rows=1 loops=1)

  • Index Cond: ((companyid = pd.companyid) AND (personid = '27192'::bpchar))
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 6
30. 0.005 0.005 ↑ 19.0 1 1

Seq Scan on person_company_rel_type pcrt_1 (cost=0.00..1.19 rows=19 width=60) (actual time=0.005..0.005 rows=1 loops=1)

31. 0.009 0.009 ↑ 1.0 1 1

Index Only Scan using web_role_pkey on web_role wr_1 (cost=0.14..0.79 rows=1 width=9) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (rolename = pcrt_1.rolename)
  • Heap Fetches: 1
32. 0.015 0.015 ↑ 1.0 1 1

Index Scan using person_pkey on person p_2 (cost=0.41..8.43 rows=1 width=21) (actual time=0.014..0.015 rows=1 loops=1)

  • Index Cond: (personid = '304128'::bpchar)
33. 0.038 0.038 ↑ 1.0 1 1

Index Scan using personemploymentenddate on person_employment pe_2 (cost=0.42..8.45 rows=1 width=13) (actual time=0.038..0.038 rows=1 loops=1)

  • Index Cond: ((personid = '304128'::bpchar) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
34. 0.001 0.098 ↓ 0.0 0 1

Result (cost=2.38..102.92 rows=3 width=75) (actual time=0.098..0.098 rows=0 loops=1)

35. 0.000 0.097 ↓ 0.0 0 1

Append (cost=2.38..102.89 rows=3 width=43) (actual time=0.097..0.097 rows=0 loops=1)

36. 0.001 0.066 ↓ 0.0 0 1

Nested Loop Anti Join (cost=2.38..36.54 rows=1 width=43) (actual time=0.066..0.066 rows=0 loops=1)

  • Join Filter: ((cpl.locationid <> lp.locationid) AND (cpl.personid = lp.personid))
37. 0.000 0.065 ↓ 0.0 0 1

Nested Loop (cost=2.09..28.20 rows=1 width=60) (actual time=0.065..0.065 rows=0 loops=1)

38. 0.000 0.065 ↓ 0.0 0 1

Nested Loop (cost=1.68..19.76 rows=1 width=39) (actual time=0.065..0.065 rows=0 loops=1)

  • Join Filter: (plr.personlocationreltype = plrt.personlocationreltype)
39. 0.002 0.065 ↓ 0.0 0 1

Nested Loop (cost=0.56..16.65 rows=1 width=39) (actual time=0.065..0.065 rows=0 loops=1)

40. 0.046 0.046 ↑ 1.0 1 1

Index Scan using person_locations_personid_idx on person_locations lp (cost=0.29..8.33 rows=1 width=17) (actual time=0.046..0.046 rows=1 loops=1)

  • Index Cond: (personid = '304128'::bpchar)
  • Filter: ((effectivedate <= enddate) AND (personlocationtype = 'P'::bpchar) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
41. 0.017 0.017 ↓ 0.0 0 1

Index Scan using pk_person_location_rel on person_location_rel plr (cost=0.28..8.31 rows=1 width=26) (actual time=0.017..0.017 rows=0 loops=1)

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

Hash Join (cost=1.11..3.04 rows=5 width=45) (never executed)

  • Hash Cond: (wr_2.rolename = plrt.rolename)
43. 0.000 0.000 ↓ 0.0 0

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

44. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.05..1.05 rows=5 width=72) (never executed)

45. 0.000 0.000 ↓ 0.0 0

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

46. 0.000 0.000 ↓ 0.0 0

Index Scan using person_pkey on person p_3 (cost=0.41..8.43 rows=1 width=21) (never executed)

  • Index Cond: (personid = '304128'::bpchar)
47. 0.000 0.000 ↓ 0.0 0

Index Scan using person_locations_personid_idx on person_locations cpl (cost=0.29..8.33 rows=1 width=17) (never executed)

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

Nested Loop (cost=6.52..38.13 rows=1 width=43) (actual time=0.012..0.012 rows=0 loops=1)

49. 0.001 0.012 ↓ 0.0 0 1

Nested Loop (cost=6.10..29.68 rows=1 width=35) (actual time=0.012..0.012 rows=0 loops=1)

  • Join Filter: (cl.companyid = pe_3.companyid)
50. 0.000 0.011 ↓ 0.0 0 1

Nested Loop (cost=5.69..21.22 rows=1 width=26) (actual time=0.011..0.011 rows=0 loops=1)

51. 0.000 0.011 ↓ 0.0 0 1

Nested Loop (cost=5.40..12.90 rows=1 width=26) (actual time=0.011..0.011 rows=0 loops=1)

  • Join Filter: (plrt_1.personlocationreltype = plr_1.personlocationreltype)
52. 0.004 0.011 ↓ 0.0 0 1

Bitmap Heap Scan on person_location_rel plr_1 (cost=4.29..9.80 rows=1 width=26) (actual time=0.011..0.011 rows=0 loops=1)

  • Recheck Cond: (personid = '27192'::bpchar)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=1
53. 0.007 0.007 ↑ 1.0 2 1

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

  • Index Cond: (personid = '27192'::bpchar)
54. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1.11..3.04 rows=5 width=45) (never executed)

  • Hash Cond: (wr_3.rolename = plrt_1.companyrolename)
55. 0.000 0.000 ↓ 0.0 0

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

56. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.05..1.05 rows=5 width=72) (never executed)

57. 0.000 0.000 ↓ 0.0 0

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

58. 0.000 0.000 ↓ 0.0 0

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

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

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

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

Index Scan using person_pkey on person p_4 (cost=0.41..8.43 rows=1 width=21) (never executed)

  • Index Cond: (personid = '304128'::bpchar)
61. 0.000 0.019 ↓ 0.0 0 1

Nested Loop (cost=2.09..28.19 rows=1 width=43) (actual time=0.019..0.019 rows=0 loops=1)

62. 0.001 0.019 ↓ 0.0 0 1

Nested Loop (cost=1.68..19.75 rows=1 width=35) (actual time=0.018..0.019 rows=0 loops=1)

  • Join Filter: (plr_2.personlocationreltype = plrt_2.personlocationreltype)
63. 0.000 0.018 ↓ 0.0 0 1

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

64. 0.018 0.018 ↓ 0.0 0 1

Index Scan using person_locations_personid_idx on person_locations lp_1 (cost=0.29..8.32 rows=1 width=17) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: (personid = '304128'::bpchar)
  • Filter: ((effectivedate <= enddate) AND (personlocationtype = 'P'::bpchar) AND (createts = endts) AND (CURRENT_DATE <= enddate))
  • Rows Removed by Filter: 1
65. 0.000 0.000 ↓ 0.0 0

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

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

Hash Join (cost=1.11..3.04 rows=5 width=45) (never executed)

  • Hash Cond: (wr_4.rolename = plrt_2.proposalrolename)
67. 0.000 0.000 ↓ 0.0 0

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

68. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.05..1.05 rows=5 width=72) (never executed)

69. 0.000 0.000 ↓ 0.0 0

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

70. 0.000 0.000 ↓ 0.0 0

Index Scan using person_pkey on person p_5 (cost=0.41..8.43 rows=1 width=21) (never executed)

  • Index Cond: (personid = '304128'::bpchar)
71. 0.000 0.129 ↓ 0.0 0 1

Result (cost=1.39..148.85 rows=4 width=95) (actual time=0.129..0.129 rows=0 loops=1)

72. 0.002 0.129 ↓ 0.0 0 1

Append (cost=1.39..148.81 rows=4 width=63) (actual time=0.129..0.129 rows=0 loops=1)

73. 0.000 0.048 ↓ 0.0 0 1

Nested Loop (cost=1.39..34.67 rows=1 width=70) (actual time=0.048..0.048 rows=0 loops=1)

74. 0.000 0.048 ↓ 0.0 0 1

Nested Loop (cost=0.98..26.23 rows=1 width=62) (actual time=0.048..0.048 rows=0 loops=1)

  • Join Filter: (pp_1.personorganizationreltype = port.personorganizationreltype)
75. 0.001 0.048 ↓ 0.0 0 1

Nested Loop (cost=0.98..25.11 rows=1 width=31) (actual time=0.048..0.048 rows=0 loops=1)

  • Join Filter: (pr.organizationid = pp_1.organizationid)
76. 0.002 0.033 ↑ 1.0 1 1

Nested Loop (cost=0.70..16.79 rows=1 width=17) (actual time=0.031..0.033 rows=1 loops=1)

77. 0.020 0.020 ↑ 1.0 1 1

Index Scan using pers_pos_personid_idx on pers_pos op (cost=0.29..8.33 rows=1 width=17) (actual time=0.018..0.020 rows=1 loops=1)

  • Index Cond: (personid = '304128'::bpchar)
  • Filter: ((effectivedate <= enddate) AND (persposrel = 'Occupies'::bpchar) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 2
78. 0.011 0.011 ↑ 1.0 1 1

Index Scan using posorgrelbyposition on pos_org_rel pr (cost=0.41..8.45 rows=1 width=8) (actual time=0.011..0.011 rows=1 loops=1)

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

Index Scan using person_organization_rel_pkey on person_organization_rel pp_1 (cost=0.27..8.31 rows=1 width=22) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (personid = '27192'::bpchar)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 1
80. 0.000 0.000 ↓ 0.0 0

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

81. 0.000 0.000 ↓ 0.0 0

Index Scan using person_pkey on person p_6 (cost=0.41..8.43 rows=1 width=21) (never executed)

  • Index Cond: (personid = '304128'::bpchar)
82. 0.000 0.020 ↓ 0.0 0 1

Nested Loop (cost=2.39..42.18 rows=1 width=70) (actual time=0.020..0.020 rows=0 loops=1)

  • Join Filter: (((pe_4.effectivedate - 1) >= op_1.effectivedate) AND ((pe_4.effectivedate - 1) <= op_1.enddate))
83. 0.000 0.020 ↓ 0.0 0 1

Nested Loop (cost=2.10..41.74 rows=1 width=91) (actual time=0.020..0.020 rows=0 loops=1)

84. 0.001 0.020 ↓ 0.0 0 1

Nested Loop (cost=1.68..33.30 rows=1 width=70) (actual time=0.019..0.020 rows=0 loops=1)

85. 0.000 0.019 ↓ 0.0 0 1

Nested Loop (cost=1.55..33.12 rows=1 width=81) (actual time=0.019..0.019 rows=0 loops=1)

  • Join Filter: (cor.organizationid = oc.organizationid)
86. 0.000 0.019 ↓ 0.0 0 1

Nested Loop (cost=1.26..32.77 rows=1 width=82) (actual time=0.019..0.019 rows=0 loops=1)

  • Join Filter: (((pe_4.effectivedate - 1) >= pr_1.effectivedate) AND ((pe_4.effectivedate - 1) <= pr_1.enddate))
87. 0.000 0.019 ↓ 0.0 0 1

Nested Loop (cost=0.97..26.22 rows=1 width=74) (actual time=0.019..0.019 rows=0 loops=1)

88. 0.019 0.019 ↓ 0.0 0 1

Index Scan using personemploymentenddate on person_employment pe_4 (cost=0.42..8.46 rows=1 width=21) (actual time=0.018..0.019 rows=0 loops=1)

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

Nested Loop (cost=0.55..17.75 rows=1 width=61) (never executed)

90. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.27..9.42 rows=1 width=53) (never executed)

  • Join Filter: (port_1.personorganizationreltype = pp_2.personorganizationreltype)
91. 0.000 0.000 ↓ 0.0 0

Index Scan using person_organization_rel_pkey on person_organization_rel pp_2 (cost=0.27..8.31 rows=1 width=22) (never executed)

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

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

93. 0.000 0.000 ↓ 0.0 0

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

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

Index Scan using pos_org_rel_organizationid_idx on pos_org_rel pr_1 (cost=0.29..5.41 rows=57 width=16) (never executed)

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

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

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

Index Scan using organization_type_pkey on organization_type ot (cost=0.14..0.16 rows=1 width=44) (never executed)

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

Index Scan using person_pkey on person p_7 (cost=0.41..8.43 rows=1 width=21) (never executed)

  • Index Cond: (personid = '304128'::bpchar)
98. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pos_positionid_idx on pers_pos op_1 (cost=0.29..0.42 rows=1 width=25) (never executed)

  • Index Cond: (positionid = pr_1.positionid)
  • Filter: ((personid = '304128'::bpchar) AND (persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
99. 0.000 0.031 ↓ 0.0 0 1

Nested Loop (cost=2.92..37.25 rows=1 width=43) (actual time=0.031..0.031 rows=0 loops=1)

100. 0.000 0.031 ↓ 0.0 0 1

Nested Loop (cost=2.50..28.81 rows=1 width=35) (actual time=0.031..0.031 rows=0 loops=1)

101. 0.001 0.031 ↓ 0.0 0 1

Nested Loop (cost=2.37..28.63 rows=1 width=46) (actual time=0.031..0.031 rows=0 loops=1)

102. 0.001 0.030 ↓ 0.0 0 1

Nested Loop (cost=2.08..28.21 rows=1 width=43) (actual time=0.030..0.030 rows=0 loops=1)

103. 0.016 0.016 ↑ 1.0 1 1

Index Scan using personemploymentenddate on person_employment pe_5 (cost=0.42..8.45 rows=1 width=17) (actual time=0.016..0.016 rows=1 loops=1)

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

Nested Loop (cost=1.67..19.75 rows=1 width=34) (actual time=0.013..0.013 rows=0 loops=1)

105. 0.001 0.013 ↓ 0.0 0 1

Nested Loop (cost=1.39..11.41 rows=1 width=26) (actual time=0.013..0.013 rows=0 loops=1)

  • Join Filter: (port_2.personorganizationreltype = por.personorganizationreltype)
106. 0.012 0.012 ↓ 0.0 0 1

Index Scan using person_organization_rel_pkey on person_organization_rel por (cost=0.27..8.31 rows=1 width=22) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (personid = '27192'::bpchar)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 1
107. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1.11..3.04 rows=5 width=29) (never executed)

  • Hash Cond: (wr_5.rolename = port_2.companyrolename)
108. 0.000 0.000 ↓ 0.0 0

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

109. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.05..1.05 rows=5 width=56) (never executed)

110. 0.000 0.000 ↓ 0.0 0

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

111. 0.000 0.000 ↓ 0.0 0

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

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

Index Scan using organizationcodeorganizationid on organization_code oc_1 (cost=0.28..0.41 rows=1 width=15) (never executed)

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

Index Scan using organization_type_pkey on organization_type ot_1 (cost=0.14..0.16 rows=1 width=44) (never executed)

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

Index Scan using person_pkey on person p_8 (cost=0.41..8.43 rows=1 width=21) (never executed)

  • Index Cond: (personid = '304128'::bpchar)
115. 0.000 0.028 ↓ 0.0 0 1

Nested Loop (cost=1.39..34.68 rows=1 width=70) (actual time=0.028..0.028 rows=0 loops=1)

116. 0.000 0.028 ↓ 0.0 0 1

Nested Loop (cost=0.98..26.23 rows=1 width=62) (actual time=0.028..0.028 rows=0 loops=1)

  • Join Filter: (pp_3.personorganizationreltype = port_3.personorganizationreltype)
117. 0.000 0.028 ↓ 0.0 0 1

Nested Loop (cost=0.98..25.12 rows=1 width=31) (actual time=0.028..0.028 rows=0 loops=1)

  • Join Filter: (pr_2.organizationid = pp_3.organizationid)
118. 0.001 0.028 ↓ 0.0 0 1

Nested Loop (cost=0.70..16.80 rows=1 width=17) (actual time=0.028..0.028 rows=0 loops=1)

119. 0.018 0.018 ↑ 1.0 1 1

Index Scan using pers_pos_personid_idx on pers_pos op_2 (cost=0.29..8.33 rows=1 width=33) (actual time=0.017..0.018 rows=1 loops=1)

  • Index Cond: (personid = '304128'::bpchar)
  • Filter: ((effectivedate <= enddate) AND (persposrel = 'Occupies'::bpchar) AND (CURRENT_DATE <= enddate) AND (((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts)) OR (createts = endts)))
  • Rows Removed by Filter: 2
120. 0.009 0.009 ↓ 0.0 0 1

Index Scan using posorgrelbyposition on pos_org_rel pr_2 (cost=0.41..8.46 rows=1 width=24) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((positionid = op_2.positionid) AND (posorgreltype = 'Member'::bpchar))
  • Filter: ((effectivedate <= enddate) AND (CURRENT_DATE <= enddate) AND ((op_2.createts = op_2.endts) OR (createts = endts)) AND (((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts)) OR (createts = endts)))
  • Rows Removed by Filter: 1
121. 0.000 0.000 ↓ 0.0 0

Index Scan using person_organization_rel_pkey on person_organization_rel pp_3 (cost=0.27..8.31 rows=1 width=22) (never executed)

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

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

123. 0.000 0.000 ↓ 0.0 0

Index Scan using person_pkey on person p_9 (cost=0.41..8.43 rows=1 width=21) (never executed)

  • Index Cond: (personid = '304128'::bpchar)
124. 0.000 0.067 ↓ 0.0 0 1

Result (cost=2.39..66.61 rows=2 width=75) (actual time=0.067..0.067 rows=0 loops=1)

125. 0.001 0.067 ↓ 0.0 0 1

Append (cost=2.39..66.59 rows=2 width=43) (actual time=0.067..0.067 rows=0 loops=1)

126. 0.000 0.047 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1 (cost=2.39..28.63 rows=1 width=43) (actual time=0.047..0.047 rows=0 loops=1)

127. 0.000 0.047 ↓ 0.0 0 1

Nested Loop (cost=2.39..28.62 rows=1 width=127) (actual time=0.047..0.047 rows=0 loops=1)

  • Join Filter: ((ppurt.personpayunitreltype)::text = (pp_4.personpayunitreltype)::text)
128. 0.001 0.047 ↓ 0.0 0 1

Nested Loop (cost=1.25..25.47 rows=1 width=40) (actual time=0.046..0.047 rows=0 loops=1)

129. 0.001 0.046 ↓ 0.0 0 1

Nested Loop (cost=0.84..17.02 rows=1 width=32) (actual time=0.046..0.046 rows=0 loops=1)

130. 0.001 0.031 ↑ 1.0 1 1

Nested Loop (cost=0.56..16.64 rows=1 width=21) (actual time=0.031..0.031 rows=1 loops=1)

131. 0.019 0.019 ↑ 1.0 1 1

Index Scan using person_payroll_personid_idx on person_payroll ep (cost=0.29..8.33 rows=1 width=17) (actual time=0.019..0.019 rows=1 loops=1)

  • Index Cond: (personid = '304128'::bpchar)
  • Filter: ((payunitrelationship = 'M'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
132. 0.011 0.011 ↑ 1.0 1 1

Index Only Scan using pay_unit_pkey on pay_unit pu (cost=0.28..8.29 rows=1 width=4) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: (payunitid = ep.payunitid)
  • Heap Fetches: 1
133. 0.014 0.014 ↓ 0.0 0 1

Index Scan using pk_person_pay_unit_rel on person_pay_unit_rel pp_4 (cost=0.28..0.38 rows=1 width=23) (actual time=0.014..0.014 rows=0 loops=1)

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

Index Scan using person_pkey on person p_10 (cost=0.41..8.43 rows=1 width=21) (never executed)

  • Index Cond: (personid = '304128'::bpchar)
135. 0.000 0.000 ↓ 0.0 0

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

  • Hash Cond: (wr_6.rolename = ppurt.rolename)
136. 0.000 0.000 ↓ 0.0 0

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

137. 0.000 0.000 ↓ 0.0 0

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

138. 0.000 0.000 ↓ 0.0 0

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

139. 0.001 0.019 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=37.94..37.96 rows=1 width=43) (actual time=0.019..0.019 rows=0 loops=1)

140. 0.000 0.018 ↓ 0.0 0 1

Unique (cost=37.94..37.95 rows=1 width=127) (actual time=0.018..0.018 rows=0 loops=1)

141. 0.008 0.018 ↓ 0.0 0 1

Sort (cost=37.94..37.94 rows=1 width=127) (actual time=0.018..0.018 rows=0 loops=1)

  • Sort Key: wr_7.rolename, p_11.companyid, p_11.customerid
  • Sort Method: quicksort Memory: 25kB
142. 0.000 0.010 ↓ 0.0 0 1

Nested Loop (cost=5.54..37.93 rows=1 width=127) (actual time=0.010..0.010 rows=0 loops=1)

143. 0.001 0.010 ↓ 0.0 0 1

Nested Loop (cost=5.40..35.71 rows=1 width=70) (actual time=0.009..0.010 rows=0 loops=1)

144. 0.000 0.009 ↓ 0.0 0 1

Nested Loop (cost=4.99..27.27 rows=1 width=62) (actual time=0.009..0.009 rows=0 loops=1)

  • Join Filter: (pu_1.companyid = pe_6.companyid)
145. 0.000 0.009 ↓ 0.0 0 1

Nested Loop (cost=4.57..18.80 rows=1 width=53) (actual time=0.009..0.009 rows=0 loops=1)

  • Join Filter: ((pp_5.personpayunitreltype)::text = (ppurt_1.personpayunitreltype)::text)
146. 0.000 0.009 ↓ 0.0 0 1

Nested Loop (cost=4.57..17.67 rows=1 width=23) (actual time=0.009..0.009 rows=0 loops=1)

147. 0.001 0.009 ↓ 0.0 0 1

Bitmap Heap Scan on person_pay_unit_rel pp_5 (cost=4.29..9.36 rows=1 width=23) (actual time=0.008..0.009 rows=0 loops=1)

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

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

  • Index Cond: (personid = '27192'::bpchar)
149. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (payunitid = pp_5.payunitid)
150. 0.000 0.000 ↓ 0.0 0

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

151. 0.000 0.000 ↓ 0.0 0

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

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

Index Scan using person_pkey on person p_11 (cost=0.41..8.43 rows=1 width=21) (never executed)

  • Index Cond: (personid = '304128'::bpchar)
153. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (rolename = ppurt_1.companyrolename)
  • Heap Fetches: 0
154. 0.000 0.000 ↓ 0.0 0 1

Result (cost=0.00..0.00 rows=0 width=180) (actual time=0.000..0.000 rows=0 loops=1)

  • One-Time Filter: false
155. 0.000 0.000 ↓ 0.0 0 1

Result (cost=0.00..0.01 rows=1 width=180) (actual time=0.000..0.000 rows=0 loops=1)

  • One-Time Filter: false
156. 0.000 0.078 ↓ 0.0 0 1

Result (cost=1.29..103.44 rows=3 width=102) (actual time=0.078..0.078 rows=0 loops=1)

157. 0.001 0.078 ↓ 0.0 0 1

Append (cost=1.29..103.41 rows=3 width=70) (actual time=0.078..0.078 rows=0 loops=1)

158. 0.000 0.041 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1_1 (cost=1.29..25.62 rows=1 width=70) (actual time=0.041..0.041 rows=0 loops=1)

159. 0.001 0.041 ↓ 0.0 0 1

Nested Loop (cost=1.29..25.61 rows=1 width=154) (actual time=0.041..0.041 rows=0 loops=1)

160. 0.000 0.040 ↓ 0.0 0 1

Nested Loop (cost=0.87..17.17 rows=1 width=26) (actual time=0.040..0.040 rows=0 loops=1)

161. 0.002 0.031 ↑ 1.0 1 1

Nested Loop (cost=0.58..16.66 rows=1 width=17) (actual time=0.029..0.031 rows=1 loops=1)

162. 0.019 0.019 ↑ 1.0 1 1

Index Scan using pers_pos_personid_idx on pers_pos pp_6 (cost=0.29..8.33 rows=1 width=17) (actual time=0.017..0.019 rows=1 loops=1)

  • Index Cond: (personid = '304128'::bpchar)
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 2
163. 0.010 0.010 ↑ 1.0 1 1

Index Scan using pos_pos_topositionid on pos_pos p_p (cost=0.29..8.32 rows=1 width=8) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: ((topositionid = pp_6.positionid) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: ((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
164. 0.009 0.009 ↓ 0.0 0 1

Index Scan using pers_pos_positionid_idx on pers_pos p_12 (cost=0.29..0.49 rows=1 width=17) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (positionid = p_p.positionid)
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '27192'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 1
165. 0.000 0.000 ↓ 0.0 0

Index Scan using person_pkey on person (cost=0.41..8.43 rows=1 width=21) (never executed)

  • Index Cond: (personid = '304128'::bpchar)
166. 0.000 0.007 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_1 (cost=1.69..45.87 rows=1 width=70) (actual time=0.007..0.007 rows=0 loops=1)

167. 0.001 0.007 ↓ 0.0 0 1

Nested Loop (cost=1.69..45.86 rows=1 width=154) (actual time=0.007..0.007 rows=0 loops=1)

168. 0.000 0.006 ↓ 0.0 0 1

Nested Loop (cost=1.55..37.68 rows=1 width=42) (actual time=0.006..0.006 rows=0 loops=1)

169. 0.006 0.006 ↓ 0.0 0 1

Index Scan using processcontroloriginator on process_control pc (cost=0.14..8.16 rows=1 width=60) (actual time=0.006..0.006 rows=0 loops=1)

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

Nested Loop (cost=1.41..29.51 rows=1 width=34) (never executed)

  • Join Filter: (p_13.personid <> pp_7.personid)
171. 0.000 0.000 ↓ 0.0 0

Nested Loop Anti Join (cost=0.99..25.07 rows=1 width=21) (never executed)

  • Join Filter: (pxp.personid = pp_7.personid)
172. 0.000 0.000 ↓ 0.0 0

Index Scan using person_pkey on person pp_7 (cost=0.41..8.43 rows=1 width=21) (never executed)

  • Index Cond: (personid = '304128'::bpchar)
173. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.58..16.62 rows=1 width=13) (never executed)

174. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pos_personid_idx on pers_pos pxp (cost=0.29..8.31 rows=1 width=17) (never executed)

  • Index Cond: (personid = '304128'::bpchar)
175. 0.000 0.000 ↓ 0.0 0

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

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

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

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

Index Scan using processlinkslogid on process_links pl (cost=0.14..8.17 rows=1 width=60) (never executed)

  • Index Cond: ((processid = pc.processid) AND (logid = pc.logid))
  • Filter: ((entitykey = '304128'::bpchar) AND (subjectid = 'PERSON'::bpchar))
178. 0.001 0.029 ↓ 0.0 0 1

Subquery Scan on *SELECT* 3 (cost=1.29..31.92 rows=1 width=70) (actual time=0.029..0.029 rows=0 loops=1)

179. 0.000 0.028 ↓ 0.0 0 1

Nested Loop (cost=1.29..31.91 rows=1 width=154) (actual time=0.028..0.028 rows=0 loops=1)

180. 0.000 0.028 ↓ 0.0 0 1

Nested Loop (cost=0.87..23.47 rows=1 width=26) (actual time=0.028..0.028 rows=0 loops=1)

181. 0.001 0.028 ↓ 0.0 0 1

Nested Loop (cost=0.58..16.66 rows=1 width=17) (actual time=0.028..0.028 rows=0 loops=1)

182. 0.018 0.018 ↑ 1.0 1 1

Index Scan using pers_pos_personid_idx on pers_pos pp_8 (cost=0.29..8.33 rows=1 width=17) (actual time=0.017..0.018 rows=1 loops=1)

  • Index Cond: (personid = '304128'::bpchar)
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 2
183. 0.009 0.009 ↓ 0.0 0 1

Index Scan using pos_pos_topositionid on pos_pos p_p_1 (cost=0.29..8.32 rows=1 width=8) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((topositionid = pp_8.positionid) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (createts > CURRENT_TIMESTAMP))
  • Rows Removed by Filter: 1
184. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pos_positionid_idx on pers_pos p_14 (cost=0.29..6.79 rows=1 width=17) (never executed)

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

Index Scan using person_pkey on person person_1 (cost=0.41..8.43 rows=1 width=21) (never executed)

  • Index Cond: (personid = '304128'::bpchar)
186. 0.000 0.169 ↓ 0.0 0 1

Result (cost=1.57..79.61 rows=6 width=102) (actual time=0.169..0.169 rows=0 loops=1)

187. 0.001 0.169 ↓ 0.0 0 1

Append (cost=1.57..79.55 rows=6 width=70) (actual time=0.169..0.169 rows=0 loops=1)

188. 0.001 0.048 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1_2 (cost=1.57..26.10 rows=2 width=70) (actual time=0.048..0.048 rows=0 loops=1)

189. 0.000 0.047 ↓ 0.0 0 1

Nested Loop (cost=1.57..26.08 rows=2 width=154) (actual time=0.047..0.047 rows=0 loops=1)

190. 0.000 0.047 ↓ 0.0 0 1

Nested Loop (cost=1.57..26.02 rows=1 width=34) (actual time=0.047..0.047 rows=0 loops=1)

191. 0.001 0.047 ↓ 0.0 0 1

Nested Loop (cost=1.16..17.57 rows=1 width=26) (actual time=0.047..0.047 rows=0 loops=1)

192. 0.002 0.035 ↑ 1.0 1 1

Nested Loop (cost=0.87..17.08 rows=1 width=17) (actual time=0.033..0.035 rows=1 loops=1)

193. 0.001 0.026 ↑ 1.0 1 1

Nested Loop (cost=0.58..16.66 rows=1 width=17) (actual time=0.024..0.026 rows=1 loops=1)

194. 0.018 0.018 ↑ 1.0 1 1

Index Scan using pers_pos_personid_idx on pers_pos p3 (cost=0.29..8.32 rows=1 width=17) (actual time=0.016..0.018 rows=1 loops=1)

  • Index Cond: (personid = '304128'::bpchar)
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_DATE < enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 2
195. 0.007 0.007 ↑ 1.0 1 1

Index Scan using pos_pos_topositionid on pos_pos p2 (cost=0.29..8.32 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: ((topositionid = p3.positionid) AND (CURRENT_DATE < enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
196. 0.007 0.007 ↑ 1.0 1 1

Index Scan using pos_pos_topositionid on pos_pos p1 (cost=0.29..0.41 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=1)

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

Index Scan using pers_pos_positionid_idx on pers_pos p_15 (cost=0.29..0.49 rows=1 width=17) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (positionid = p1.positionid)
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '27192'::bpchar) AND (CURRENT_DATE < enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 4
198. 0.000 0.000 ↓ 0.0 0

Index Scan using person_pkey on person person_2 (cost=0.41..8.43 rows=1 width=21) (never executed)

  • Index Cond: (personid = '304128'::bpchar)
199. 0.000 0.000 ↓ 0.0 0

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

200. 0.000 0.000 ↓ 0.0 0

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

201. 0.000 0.000 ↓ 0.0 0

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

202. 0.001 0.055 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2_2 (cost=1.86..26.52 rows=2 width=70) (actual time=0.055..0.055 rows=0 loops=1)

203. 0.000 0.054 ↓ 0.0 0 1

Nested Loop (cost=1.86..26.50 rows=2 width=154) (actual time=0.054..0.054 rows=0 loops=1)

204. 0.000 0.054 ↓ 0.0 0 1

Nested Loop (cost=1.86..26.44 rows=1 width=34) (actual time=0.054..0.054 rows=0 loops=1)

205. 0.001 0.054 ↓ 0.0 0 1

Nested Loop (cost=1.45..18.00 rows=1 width=26) (actual time=0.054..0.054 rows=0 loops=1)

206. 0.001 0.044 ↑ 1.0 1 1

Nested Loop (cost=1.16..17.49 rows=1 width=17) (actual time=0.042..0.044 rows=1 loops=1)

207. 0.002 0.035 ↑ 1.0 1 1

Nested Loop (cost=0.87..17.08 rows=1 width=17) (actual time=0.033..0.035 rows=1 loops=1)

208. 0.001 0.026 ↑ 1.0 1 1

Nested Loop (cost=0.58..16.66 rows=1 width=17) (actual time=0.024..0.026 rows=1 loops=1)

209. 0.018 0.018 ↑ 1.0 1 1

Index Scan using pers_pos_personid_idx on pers_pos p5 (cost=0.29..8.32 rows=1 width=17) (actual time=0.016..0.018 rows=1 loops=1)

  • Index Cond: (personid = '304128'::bpchar)
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_DATE < enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 2
210. 0.007 0.007 ↑ 1.0 1 1

Index Scan using pos_pos_topositionid on pos_pos p3_1 (cost=0.29..8.32 rows=1 width=8) (actual time=0.006..0.007 rows=1 loops=1)

  • Index Cond: ((topositionid = p5.positionid) AND (CURRENT_DATE < enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
211. 0.007 0.007 ↑ 1.0 1 1

Index Scan using pos_pos_topositionid on pos_pos p2_1 (cost=0.29..0.41 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: ((topositionid = p3_1.positionid) AND (CURRENT_DATE < enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
212. 0.008 0.008 ↑ 1.0 1 1

Index Scan using pos_pos_topositionid on pos_pos p1_1 (cost=0.29..0.41 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=1)

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

Index Scan using pers_pos_positionid_idx on pers_pos p_16 (cost=0.29..0.49 rows=1 width=17) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (positionid = p1_1.positionid)
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '27192'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 3
214. 0.000 0.000 ↓ 0.0 0

Index Scan using person_pkey on person person_3 (cost=0.41..8.43 rows=1 width=21) (never executed)

  • Index Cond: (personid = '304128'::bpchar)
215. 0.000 0.000 ↓ 0.0 0

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

216. 0.000 0.000 ↓ 0.0 0

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

217. 0.000 0.000 ↓ 0.0 0

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

218. 0.000 0.065 ↓ 0.0 0 1

Subquery Scan on *SELECT* 3_1 (cost=2.15..26.94 rows=2 width=70) (actual time=0.065..0.065 rows=0 loops=1)

219. 0.000 0.065 ↓ 0.0 0 1

Nested Loop (cost=2.15..26.92 rows=2 width=154) (actual time=0.065..0.065 rows=0 loops=1)

220. 0.001 0.065 ↓ 0.0 0 1

Nested Loop (cost=2.15..26.86 rows=1 width=34) (actual time=0.065..0.065 rows=0 loops=1)

221. 0.001 0.064 ↓ 0.0 0 1

Nested Loop (cost=1.74..18.42 rows=1 width=26) (actual time=0.064..0.064 rows=0 loops=1)

222. 0.002 0.052 ↑ 1.0 1 1

Nested Loop (cost=1.45..17.91 rows=1 width=17) (actual time=0.049..0.052 rows=1 loops=1)

223. 0.001 0.042 ↑ 1.0 1 1

Nested Loop (cost=1.16..17.49 rows=1 width=17) (actual time=0.040..0.042 rows=1 loops=1)

224. 0.001 0.034 ↑ 1.0 1 1

Nested Loop (cost=0.87..17.08 rows=1 width=17) (actual time=0.032..0.034 rows=1 loops=1)

225. 0.001 0.026 ↑ 1.0 1 1

Nested Loop (cost=0.58..16.66 rows=1 width=17) (actual time=0.024..0.026 rows=1 loops=1)

226. 0.018 0.018 ↑ 1.0 1 1

Index Scan using pers_pos_personid_idx on pers_pos p7 (cost=0.29..8.32 rows=1 width=17) (actual time=0.016..0.018 rows=1 loops=1)

  • Index Cond: (personid = '304128'::bpchar)
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_DATE < enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 2
227. 0.007 0.007 ↑ 1.0 1 1

Index Scan using pos_pos_topositionid on pos_pos p4 (cost=0.29..8.32 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: ((topositionid = p7.positionid) AND (CURRENT_DATE < enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
228. 0.007 0.007 ↑ 1.0 1 1

Index Scan using pos_pos_topositionid on pos_pos p3_2 (cost=0.29..0.41 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: ((topositionid = p4.positionid) AND (CURRENT_DATE < enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
229. 0.007 0.007 ↑ 1.0 1 1

Index Scan using pos_pos_topositionid on pos_pos p2_2 (cost=0.29..0.41 rows=1 width=8) (actual time=0.006..0.007 rows=1 loops=1)

  • Index Cond: ((topositionid = p3_2.positionid) AND (CURRENT_DATE < enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
230. 0.008 0.008 ↑ 1.0 1 1

Index Scan using pos_pos_topositionid on pos_pos p1_2 (cost=0.29..0.41 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: ((topositionid = p2_2.positionid) AND (CURRENT_DATE < enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
231. 0.011 0.011 ↓ 0.0 0 1

Index Scan using pers_pos_positionid_idx on pers_pos p_17 (cost=0.29..0.49 rows=1 width=17) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (positionid = p1_2.positionid)
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '27192'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 6
232. 0.000 0.000 ↓ 0.0 0

Index Scan using person_pkey on person person_4 (cost=0.41..8.43 rows=1 width=21) (never executed)

  • Index Cond: (personid = '304128'::bpchar)
233. 0.000 0.000 ↓ 0.0 0

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

234. 0.000 0.000 ↓ 0.0 0

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

235. 0.000 0.000 ↓ 0.0 0

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

236. 0.000 0.013 ↓ 0.0 0 1

Nested Loop (cost=4.98..26.25 rows=1 width=141) (actual time=0.013..0.013 rows=0 loops=1)

237. 0.000 0.013 ↓ 0.0 0 1

Nested Loop (cost=4.57..17.81 rows=1 width=20) (actual time=0.013..0.013 rows=0 loops=1)

238. 0.001 0.013 ↓ 0.0 0 1

Bitmap Heap Scan on act_ru_variable arv (cost=4.29..9.50 rows=1 width=19) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((name_)::text = 'originatorID'::text)
  • Filter: ((text_)::character(12) = '27192'::bpchar)
239. 0.012 0.012 ↓ 0.0 0 1

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

  • Index Cond: ((name_)::text = 'originatorID'::text)
240. 0.000 0.000 ↓ 0.0 0

Index Only Scan using act_ru_variable_name_text_exec_idx on act_ru_variable arv2 (cost=0.28..8.30 rows=1 width=19) (never executed)

  • Index Cond: ((execution_id_ = (arv.execution_id_)::text) AND (name_ = 'personID'::text))
  • Filter: ((text_)::character(12) = '304128'::bpchar)
  • Heap Fetches: 0
241. 0.000 0.000 ↓ 0.0 0

Index Scan using person_pkey on person p_18 (cost=0.41..8.43 rows=1 width=21) (never executed)

  • Index Cond: (personid = '304128'::bpchar)
242. 0.000 0.042 ↓ 0.0 0 1

Nested Loop (cost=1.25..37.81 rows=1 width=102) (actual time=0.042..0.042 rows=0 loops=1)

243. 0.001 0.042 ↓ 0.0 0 1

Nested Loop (cost=0.83..29.37 rows=1 width=26) (actual time=0.042..0.042 rows=0 loops=1)

  • Join Filter: (cp.companyid = pe_7.companyid)
244. 0.000 0.041 ↓ 0.0 0 1

Nested Loop (cost=0.41..20.91 rows=1 width=17) (actual time=0.041..0.041 rows=0 loops=1)

245. 0.000 0.041 ↓ 0.0 0 1

Nested Loop (cost=0.41..9.56 rows=1 width=13) (actual time=0.041..0.041 rows=0 loops=1)

246. 0.022 0.022 ↑ 1.0 1 1

Index Only Scan using person_pkey on person u (cost=0.41..4.43 rows=1 width=13) (actual time=0.021..0.022 rows=1 loops=1)

  • Index Cond: (personid = '27192'::bpchar)
  • Heap Fetches: 0
247. 0.019 0.019 ↓ 0.0 0 1

Seq Scan on assigned_roles ar_1 (cost=0.00..5.12 rows=1 width=13) (actual time=0.019..0.019 rows=0 loops=1)

  • Filter: ((personid = '27192'::bpchar) AND (rolename = 'Onboard'::bpchar))
  • Rows Removed by Filter: 208
248. 0.000 0.000 ↓ 0.0 0

Seq Scan on company_parameters cp (cost=0.00..11.34 rows=1 width=4) (never executed)

  • Filter: ((companyparametername = 'InOnboard'::bpchar) AND ((companyparametervalue)::text = 'Y'::text))
249. 0.000 0.000 ↓ 0.0 0

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

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

Index Scan using person_pkey on person p_19 (cost=0.41..8.43 rows=1 width=21) (never executed)

  • Index Cond: (personid = '304128'::bpchar)
251. 0.003 0.051 ↑ 1.2 18 1

Nested Loop (cost=0.83..87.27 rows=21 width=98) (actual time=0.039..0.051 rows=18 loops=1)

252. 0.017 0.017 ↑ 1.0 1 1

Index Scan using person_pkey on person p_20 (cost=0.41..8.43 rows=1 width=21) (actual time=0.016..0.017 rows=1 loops=1)

  • Index Cond: (personid = '304128'::bpchar)
253. 0.031 0.031 ↑ 1.2 18 1

Index Only Scan using person_identity_pkey on person_identity p1_3 (cost=0.42..78.63 rows=21 width=13) (actual time=0.021..0.031 rows=18 loops=1)

  • Index Cond: (personid = '27192'::bpchar)
  • Heap Fetches: 18
254. 0.001 0.063 ↑ 1.0 1 1

Subquery Scan on *SELECT* 13 (cost=1.25..25.37 rows=1 width=98) (actual time=0.062..0.063 rows=1 loops=1)

255. 0.001 0.062 ↑ 1.0 1 1

Nested Loop (cost=1.25..25.36 rows=1 width=98) (actual time=0.061..0.062 rows=1 loops=1)

256. 0.001 0.045 ↑ 1.0 1 1

Nested Loop (cost=0.83..16.92 rows=1 width=26) (actual time=0.045..0.045 rows=1 loops=1)

  • Join Filter: (pcr_2.companyid = pe_8.companyid)
257. 0.018 0.018 ↑ 1.0 1 1

Index Scan using personemploymentenddate on person_employment pcr_2 (cost=0.42..8.45 rows=1 width=17) (actual time=0.018..0.018 rows=1 loops=1)

  • Index Cond: ((personid = '304128'::bpchar) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
258. 0.026 0.026 ↑ 1.0 1 1

Index Scan using personemploymentenddate on person_employment pe_8 (cost=0.42..8.45 rows=1 width=17) (actual time=0.026..0.026 rows=1 loops=1)

  • Index Cond: ((personid = '27192'::bpchar) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (emplstatus <> ALL ('{T,E,R}'::bpchar[])) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 11
259. 0.016 0.016 ↑ 1.0 1 1

Index Scan using person_pkey on person p_21 (cost=0.41..8.43 rows=1 width=21) (actual time=0.015..0.016 rows=1 loops=1)

  • Index Cond: (personid = '304128'::bpchar)
260. 0.000 0.090 ↓ 0.0 0 1

Nested Loop (cost=9.02..22.87 rows=1 width=141) (actual time=0.090..0.090 rows=0 loops=1)

261. 0.000 0.090 ↓ 0.0 0 1

Nested Loop (cost=8.61..14.43 rows=1 width=101) (actual time=0.090..0.090 rows=0 loops=1)

  • Join Filter: (pcr_3.personcustomerreltype = pcrt_2.personcustomerreltype)
262. 0.001 0.090 ↓ 0.0 0 1

Nested Loop (cost=8.61..13.16 rows=1 width=89) (actual time=0.090..0.090 rows=0 loops=1)

263. 0.020 0.079 ↑ 1.0 1 1

Hash Join (cost=8.46..12.83 rows=1 width=17) (actual time=0.045..0.079 rows=1 loops=1)

  • Hash Cond: (cs.companyid = pe_9.companyid)
264. 0.038 0.038 ↑ 1.0 88 1

Seq Scan on customer_struct cs (cost=0.00..4.03 rows=88 width=8) (actual time=0.006..0.038 rows=88 loops=1)

  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 13
265. 0.004 0.021 ↑ 1.0 1 1

Hash (cost=8.45..8.45 rows=1 width=17) (actual time=0.021..0.021 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
266. 0.017 0.017 ↑ 1.0 1 1

Index Scan using personemploymentenddate on person_employment pe_9 (cost=0.42..8.45 rows=1 width=17) (actual time=0.017..0.017 rows=1 loops=1)

  • Index Cond: ((personid = '304128'::bpchar) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts)) OR (createts = endts)))
267. 0.010 0.010 ↓ 0.0 0 1

Index Scan using pk_person_customer_rel on person_customer_rel pcr_3 (cost=0.14..0.32 rows=1 width=80) (actual time=0.010..0.010 rows=0 loops=1)

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

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

269. 0.000 0.000 ↓ 0.0 0

Index Scan using person_pkey on person p_22 (cost=0.41..8.43 rows=1 width=21) (never executed)

  • Index Cond: (personid = '304128'::bpchar)
Planning time : 28.199 ms
Execution time : 2.435 ms