explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aomE : No peers

Settings
# exclusive inclusive rows x rows loops node
1. 14.146 3,665.533 ↓ 5.6 5,429 1

Sort (cost=996,411.64..996,414.05 rows=964 width=84) (actual time=3,665.283..3,665.533 rows=5,429 loops=1)

  • Sort Key: (btrim((pn.lname)::text))
  • Sort Method: quicksort Memory: 618kB
2. 5.529 3,651.387 ↓ 5.6 5,429 1

Hash Left Join (cost=2,473.25..996,363.86 rows=964 width=84) (actual time=21.422..3,651.387 rows=5,429 loops=1)

  • Hash Cond: (pn.personid = pi.personid)
3. 8.265 3,645.833 ↓ 5.8 5,429 1

Nested Loop (cost=2,469.92..996,354.58 rows=940 width=39) (actual time=21.377..3,645.833 rows=5,429 loops=1)

  • Join Filter: (p.personid = pe.personid)
4. 3.435 81.770 ↓ 1.9 5,437 1

Nested Loop (cost=2,469.50..4,308.36 rows=2,829 width=52) (actual time=20.008..81.770 rows=5,437 loops=1)

  • Join Filter: (p.personid = pn.personid)
5. 8.662 34.759 ↓ 1.5 5,447 1

Hash Join (cost=2,469.21..2,805.14 rows=3,688 width=26) (actual time=19.984..34.759 rows=5,447 loops=1)

  • Hash Cond: (pd.personid = p.personid)
6. 10.872 23.825 ↓ 1.2 20,687 1

HashAggregate (cost=1,692.40..1,866.91 rows=17,451 width=13) (actual time=17.675..23.825 rows=20,687 loops=1)

  • Group Key: pd.personid
7. 12.953 12.953 ↓ 1.0 21,251 1

Seq Scan on person_compensation pd (cost=0.00..1,639.52 rows=21,153 width=13) (actual time=0.012..12.953 rows=21,251 loops=1)

  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 12733
8. 0.923 2.272 ↑ 1.0 6,193 1

Hash (cost=699.39..699.39 rows=6,193 width=13) (actual time=2.272..2.272 rows=6,193 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 337kB
9. 1.349 1.349 ↑ 1.0 6,193 1

Index Scan using fki_person_companyid_fkey on person p (cost=0.29..699.39 rows=6,193 width=13) (actual time=0.011..1.349 rows=6,193 loops=1)

  • Index Cond: (companyid = 51888)
10. 43.576 43.576 ↑ 1.0 1 5,447

Index Scan using person_names_personid_idx on person_names pn (cost=0.29..0.40 rows=1 width=26) (actual time=0.007..0.008 rows=1 loops=5,447)

  • Index Cond: (personid = pd.personid)
  • Filter: ((nametype = 'Legal'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
11. 43.235 3,555.798 ↑ 1.0 1 5,437

Index Scan using personemploymentenddate on person_employment pe (cost=0.42..350.66 rows=1 width=13) (actual time=0.654..0.654 rows=1 loops=5,437)

  • Index Cond: ((personid = pn.personid) AND (CURRENT_DATE <= enddate) AND (CURRENT_DATE >= effectivedate))
  • Filter: ((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts) AND (emplstatus = ANY ('{A,C,L,P}'::bpchar[])) AND (SubPlan 1))
  • Rows Removed by Filter: 0
12.          

SubPlan (for Index Scan)

13. 21.716 3,512.563 ↑ 27.0 1 5,429

Hash Join (cost=348.94..381.85 rows=27 width=0) (actual time=0.647..0.647 rows=1 loops=5,429)

  • Hash Cond: ("*SELECT* 1".rolename = rpa.rolename)
14. 10.858 190.015 ↑ 1.8 15 5,429

Append (cost=0.56..33.11 rows=27 width=10) (actual time=0.024..0.035 rows=15 loops=5,429)

15. 5.429 32.574 ↓ 0.0 0 5,429

Subquery Scan on *SELECT* 1 (cost=0.56..6.65 rows=1 width=36) (actual time=0.006..0.006 rows=0 loops=5,429)

16. 0.000 27.145 ↓ 0.0 0 5,429

Nested Loop Anti Join (cost=0.56..6.64 rows=1 width=288) (actual time=0.005..0.005 rows=0 loops=5,429)

17. 27.145 27.145 ↓ 0.0 0 5,429

Index Scan using idx_csc_neg_do_act on company_security_control sc1 (cost=0.28..2.30 rows=1 width=192) (actual time=0.005..0.005 rows=0 loops=5,429)

  • Index Cond: ((negative = false) AND ((domainobject)::text = 'PersonCompensationItem'::text) AND ((action)::text = 'Read'::text) AND (companyid = pe.companyid))
  • Filter: (NOT negative)
18. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((domainobject = (sc1.domainobject)::text) AND (domainobject = 'PersonCompensationItem'::text) AND (action = (sc1.action)::text) AND (action = 'Read'::text) AND (rolename = sc1.rolename))
  • Heap Fetches: 0
19. 5.429 146.583 ↑ 1.7 15 5,429

Subquery Scan on *SELECT* 2 (cost=2.87..26.46 rows=26 width=9) (actual time=0.018..0.027 rows=15 loops=5,429)

20. 16.287 141.154 ↑ 1.7 15 5,429

Merge Anti Join (cost=2.87..26.20 rows=26 width=261) (actual time=0.017..0.026 rows=15 loops=5,429)

  • Merge Cond: (sc2.rolename = sc3_1.rolename)
  • Join Filter: ((sc3_1.companyid = c.companyid) AND ((sc3_1.domainobject)::text = (sc2.domainobject)::text) AND ((sc3_1.action)::text = (sc2.action)::text))
21. 43.432 92.293 ↑ 1.7 15 5,429

Nested Loop (cost=0.56..23.80 rows=26 width=35) (actual time=0.010..0.017 rows=15 loops=5,429)

22. 48.861 48.861 ↑ 1.7 15 5,429

Index Only Scan using security_control_pkey1 on security_control sc2 (cost=0.29..21.18 rows=26 width=31) (actual time=0.007..0.009 rows=15 loops=5,429)

  • Index Cond: ((domainobject = 'PersonCompensationItem'::text) AND (action = 'Read'::text))
  • Heap Fetches: 81315
23. 0.000 0.000 ↑ 1.0 1 81,315

Materialize (cost=0.27..2.29 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=81,315)

24. 10.858 10.858 ↑ 1.0 1 5,429

Index Only Scan using company_pkey on company c (cost=0.27..2.29 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=5,429)

  • Index Cond: (companyid = pe.companyid)
  • Heap Fetches: 5429
25. 10.858 32.574 ↓ 0.0 0 5,429

Sort (cost=2.31..2.31 rows=1 width=196) (actual time=0.006..0.006 rows=0 loops=5,429)

  • Sort Key: sc3_1.rolename
  • Sort Method: quicksort Memory: 25kB
26. 21.716 21.716 ↓ 0.0 0 5,429

Index Scan using idx_csc_neg_do_act on company_security_control sc3_1 (cost=0.28..2.30 rows=1 width=196) (actual time=0.004..0.004 rows=0 loops=5,429)

  • Index Cond: ((negative = true) AND ((domainobject)::text = 'PersonCompensationItem'::text) AND ((action)::text = 'Read'::text) AND (companyid = pe.companyid))
  • Filter: negative
27. 10.858 3,300.832 ↑ 15.7 3 5,429

Hash (cost=347.79..347.79 rows=47 width=32) (actual time=0.608..0.608 rows=3 loops=5,429)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
28. 5.429 3,289.974 ↑ 15.7 3 5,429

Subquery Scan on rpa (cost=346.85..347.79 rows=47 width=32) (actual time=0.605..0.606 rows=3 loops=5,429)

29. 54.290 3,284.545 ↑ 15.7 3 5,429

HashAggregate (cost=346.85..347.32 rows=47 width=176) (actual time=0.605..0.605 rows=3 loops=5,429)

  • Group Key: ar.personid, p_1.personid, ar.rolename, (''::text), p_1.companyid, p_1.customerid
30. 21.716 3,230.255 ↑ 2.4 20 5,429

Append (cost=0.98..346.14 rows=47 width=176) (actual time=0.068..0.595 rows=20 loops=5,429)

31. 0.000 16.287 ↓ 0.0 0 5,429

Nested Loop (cost=0.98..7.07 rows=1 width=141) (actual time=0.003..0.003 rows=0 loops=5,429)

32. 0.000 16.287 ↓ 0.0 0 5,429

Nested Loop (cost=0.69..4.75 rows=1 width=101) (actual time=0.003..0.003 rows=0 loops=5,429)

33. 16.287 16.287 ↓ 0.0 0 5,429

Index Only Scan using assigned_roles_pkey on assigned_roles ar (cost=0.27..2.29 rows=1 width=88) (actual time=0.003..0.003 rows=0 loops=5,429)

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

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

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

Index Scan using person_pkey on person p_1 (cost=0.29..2.31 rows=1 width=21) (never executed)

  • Index Cond: (personid = pe.personid)
36. 5.429 352.885 ↑ 2.0 1 5,429

Subquery Scan on r_personcompanyroles (cost=19.51..19.56 rows=2 width=180) (actual time=0.065..0.065 rows=1 loops=5,429)

37. 0.000 347.456 ↑ 2.0 1 5,429

Unique (cost=19.51..19.54 rows=2 width=148) (actual time=0.064..0.064 rows=1 loops=5,429)

38. 16.287 347.456 ↑ 2.0 1 5,429

Sort (cost=19.51..19.52 rows=2 width=148) (actual time=0.064..0.064 rows=1 loops=5,429)

  • Sort Key: pcr.personid, p_2.personid, wr.rolename, p_2.companyid, p_2.customerid
  • Sort Method: quicksort Memory: 25kB
39. 5.429 331.169 ↑ 2.0 1 5,429

Append (cost=1.26..19.50 rows=2 width=148) (actual time=0.025..0.061 rows=1 loops=5,429)

40. 5.351 141.154 ↑ 1.0 1 5,429

Nested Loop (cost=1.26..8.40 rows=1 width=70) (actual time=0.024..0.026 rows=1 loops=5,429)

41. 5.403 103.151 ↑ 1.0 1 5,429

Nested Loop (cost=0.97..6.09 rows=1 width=62) (actual time=0.018..0.019 rows=1 loops=5,429)

42. 5.416 86.864 ↑ 1.0 1 5,429

Nested Loop (cost=0.83..5.76 rows=1 width=62) (actual time=0.015..0.016 rows=1 loops=5,429)

43. 10.767 76.006 ↑ 1.0 1 5,429

Nested Loop (cost=0.70..4.78 rows=1 width=32) (actual time=0.012..0.014 rows=1 loops=5,429)

44. 27.145 27.145 ↑ 1.0 1 5,429

Index Scan using personemploymentenddate on person_employment pe_2 (cost=0.42..2.45 rows=1 width=17) (actual time=0.005..0.005 rows=1 loops=5,429)

  • Index Cond: ((personid = pe.personid) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts)) OR (createts = endts)))
  • Rows Removed by Filter: 0
45. 38.094 38.094 ↑ 1.0 1 5,442

Index Scan using personcompanybycompany on person_company_rel pcr (cost=0.28..2.32 rows=1 width=23) (actual time=0.006..0.007 rows=1 loops=5,442)

  • Index Cond: ((companyid = pe_2.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
46. 5.442 5.442 ↑ 1.0 1 5,442

Index Scan using person_company_rel_type_pkey on person_company_rel_type pcrt (cost=0.14..0.90 rows=1 width=60) (actual time=0.001..0.001 rows=1 loops=5,442)

  • Index Cond: (personcompanyreltype = pcr.personcompanyreltype)
47. 10.884 10.884 ↑ 1.0 1 5,442

Index Only Scan using web_role_pkey on web_role wr (cost=0.14..0.32 rows=1 width=36) (actual time=0.002..0.002 rows=1 loops=5,442)

  • Index Cond: (rolename = pcrt.rolename)
  • Heap Fetches: 5442
48. 32.652 32.652 ↑ 1.0 1 5,442

Index Scan using person_pkey on person p_2 (cost=0.29..2.31 rows=1 width=21) (actual time=0.006..0.006 rows=1 loops=5,442)

  • Index Cond: (personid = pe.personid)
49. 5.429 184.586 ↓ 0.0 0 5,429

Nested Loop Anti Join (cost=1.85..11.08 rows=1 width=70) (actual time=0.034..0.034 rows=0 loops=5,429)

  • Join Filter: (pe_3.personid = pp.personid)
50. 5.429 152.012 ↑ 1.0 1 5,429

Nested Loop (cost=1.43..8.62 rows=1 width=70) (actual time=0.025..0.028 rows=1 loops=5,429)

51. 5.429 119.438 ↑ 1.0 1 5,429

Nested Loop (cost=1.14..6.30 rows=1 width=62) (actual time=0.020..0.022 rows=1 loops=5,429)

52. 5.429 108.580 ↑ 1.0 1 5,429

Nested Loop (cost=1.00..5.98 rows=1 width=62) (actual time=0.018..0.020 rows=1 loops=5,429)

53. 5.423 97.722 ↑ 1.0 1 5,429

Nested Loop (cost=0.86..5.00 rows=1 width=32) (actual time=0.016..0.018 rows=1 loops=5,429)

54. 10.855 59.719 ↑ 1.0 1 5,429

Nested Loop (cost=0.58..4.66 rows=1 width=17) (actual time=0.010..0.011 rows=1 loops=5,429)

55. 32.574 32.574 ↑ 1.0 1 5,429

Index Scan using pers_pos_personid_idx on pers_pos pp (cost=0.29..2.33 rows=1 width=17) (actual time=0.006..0.006 rows=1 loops=5,429)

  • Index Cond: (personid = pe.personid)
  • Filter: ((effectivedate <= enddate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
56. 16.290 16.290 ↑ 1.0 1 5,430

Index Scan using position_desc_positionid_idx on position_desc pd_1 (cost=0.29..2.33 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=5,430)

  • Index Cond: (positionid = pp.positionid)
  • Filter: ((effectivedate <= enddate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
57. 32.580 32.580 ↑ 1.0 1 5,430

Index Scan using personcompanybycompany on person_company_rel pcr_1 (cost=0.28..0.33 rows=1 width=23) (actual time=0.005..0.006 rows=1 loops=5,430)

  • Index Cond: ((companyid = pd_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
58. 5.429 5.429 ↑ 1.0 1 5,429

Index Scan using person_company_rel_type_pkey on person_company_rel_type pcrt_1 (cost=0.14..0.90 rows=1 width=60) (actual time=0.001..0.001 rows=1 loops=5,429)

  • Index Cond: (personcompanyreltype = pcr_1.personcompanyreltype)
59. 5.429 5.429 ↑ 1.0 1 5,429

Index Only Scan using web_role_pkey on web_role wr_1 (cost=0.14..0.32 rows=1 width=36) (actual time=0.001..0.001 rows=1 loops=5,429)

  • Index Cond: (rolename = pcrt_1.rolename)
  • Heap Fetches: 5429
60. 27.145 27.145 ↑ 1.0 1 5,429

Index Scan using person_pkey on person p_3 (cost=0.29..2.31 rows=1 width=21) (actual time=0.004..0.005 rows=1 loops=5,429)

  • Index Cond: (personid = pe.personid)
61. 27.145 27.145 ↑ 1.0 1 5,429

Index Scan using personemploymentenddate on person_employment pe_3 (cost=0.42..2.45 rows=1 width=13) (actual time=0.005..0.005 rows=1 loops=5,429)

  • Index Cond: ((personid = pe.personid) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
62. 0.000 124.867 ↓ 0.0 0 5,429

Result (cost=1.28..35.57 rows=3 width=141) (actual time=0.023..0.023 rows=0 loops=5,429)

63. 0.000 124.867 ↓ 0.0 0 5,429

Append (cost=1.28..35.54 rows=3 width=109) (actual time=0.023..0.023 rows=0 loops=5,429)

64. 5.429 65.148 ↓ 0.0 0 5,429

Nested Loop Anti Join (cost=1.28..11.20 rows=1 width=109) (actual time=0.012..0.012 rows=0 loops=5,429)

  • Join Filter: ((cpl.locationid <> lp.locationid) AND (cpl.personid = lp.personid))
65. 0.000 59.719 ↓ 0.0 0 5,429

Nested Loop (cost=0.99..8.86 rows=1 width=126) (actual time=0.011..0.011 rows=0 loops=5,429)

66. 0.000 59.719 ↓ 0.0 0 5,429

Nested Loop (cost=0.70..6.54 rows=1 width=105) (actual time=0.011..0.011 rows=0 loops=5,429)

67. 0.000 59.719 ↓ 0.0 0 5,429

Nested Loop (cost=0.56..5.77 rows=1 width=105) (actual time=0.011..0.011 rows=0 loops=5,429)

  • Join Filter: (plr.personlocationreltype = plrt.personlocationreltype)
68. 5.432 59.719 ↓ 0.0 0 5,429

Nested Loop (cost=0.56..4.65 rows=1 width=105) (actual time=0.011..0.011 rows=0 loops=5,429)

69. 38.003 38.003 ↑ 1.0 1 5,429

Index Scan using person_locations_personid_idx on person_locations lp (cost=0.29..2.33 rows=1 width=17) (actual time=0.007..0.007 rows=1 loops=5,429)

  • Index Cond: (personid = pe.personid)
  • Filter: ((effectivedate <= enddate) AND (personlocationtype = 'P'::bpchar) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
70. 16.284 16.284 ↓ 0.0 0 5,428

Index Scan using pk_person_location_rel on person_location_rel plr (cost=0.28..2.31 rows=1 width=92) (actual time=0.003..0.003 rows=0 loops=5,428)

  • 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))
  • Rows Removed by Filter: 0
71. 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)

72. 0.000 0.000 ↓ 0.0 0

Index Only Scan using web_role_pkey on web_role wr_2 (cost=0.14..0.76 rows=1 width=36) (never executed)

  • Index Cond: (rolename = plrt.rolename)
  • Heap Fetches: 0
73. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (personid = pe.personid)
74. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (personid = pe.personid)
  • Filter: ((personlocationtype = 'P'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
75. 5.429 27.145 ↓ 0.0 0 5,429

Nested Loop (cost=1.41..15.45 rows=1 width=109) (actual time=0.005..0.005 rows=0 loops=5,429)

76. 0.000 21.716 ↓ 0.0 0 5,429

Nested Loop (cost=1.11..13.13 rows=1 width=101) (actual time=0.004..0.004 rows=0 loops=5,429)

  • Join Filter: (cl.companyid = pe_4.companyid)
77. 0.000 21.716 ↓ 0.0 0 5,429

Nested Loop (cost=0.70..10.67 rows=1 width=92) (actual time=0.004..0.004 rows=0 loops=5,429)

78. 0.000 21.716 ↓ 0.0 0 5,429

Nested Loop (cost=0.42..8.35 rows=1 width=92) (actual time=0.004..0.004 rows=0 loops=5,429)

79. 0.000 21.716 ↓ 0.0 0 5,429

Nested Loop (cost=0.28..7.58 rows=1 width=92) (actual time=0.004..0.004 rows=0 loops=5,429)

  • Join Filter: (plr_1.personlocationreltype = plrt_1.personlocationreltype)
80. 21.716 21.716 ↓ 0.0 0 5,429

Index Scan using pk_person_location_rel on person_location_rel plr_1 (cost=0.28..6.46 rows=1 width=92) (actual time=0.004..0.004 rows=0 loops=5,429)

  • 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: 2
81. 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)

82. 0.000 0.000 ↓ 0.0 0

Index Only Scan using web_role_pkey on web_role wr_3 (cost=0.14..0.76 rows=1 width=36) (never executed)

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

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

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

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

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

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

  • Index Cond: (personid = pe.personid)
86. 5.429 32.574 ↓ 0.0 0 5,429

Nested Loop (cost=0.99..8.85 rows=1 width=109) (actual time=0.006..0.006 rows=0 loops=5,429)

87. 0.000 27.145 ↓ 0.0 0 5,429

Nested Loop (cost=0.70..6.53 rows=1 width=101) (actual time=0.005..0.005 rows=0 loops=5,429)

88. 0.000 27.145 ↓ 0.0 0 5,429

Nested Loop (cost=0.56..5.76 rows=1 width=101) (actual time=0.005..0.005 rows=0 loops=5,429)

  • Join Filter: (plr_2.personlocationreltype = plrt_2.personlocationreltype)
89. 0.000 27.145 ↓ 0.0 0 5,429

Nested Loop (cost=0.56..4.64 rows=1 width=101) (actual time=0.005..0.005 rows=0 loops=5,429)

90. 27.145 27.145 ↓ 0.0 0 5,429

Index Scan using person_locations_personid_idx on person_locations lp_1 (cost=0.29..2.32 rows=1 width=17) (actual time=0.005..0.005 rows=0 loops=5,429)

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

Index Scan using pk_person_location_rel on person_location_rel plr_2 (cost=0.28..2.31 rows=1 width=92) (actual time=0.007..0.007 rows=0 loops=2)

  • 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))
92. 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)

93. 0.000 0.000 ↓ 0.0 0

Index Only Scan using web_role_pkey on web_role wr_4 (cost=0.14..0.76 rows=1 width=36) (never executed)

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

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

  • Index Cond: (personid = pe.personid)
95. 0.000 228.018 ↓ 0.0 0 5,429

Result (cost=1.27..53.64 rows=4 width=141) (actual time=0.042..0.042 rows=0 loops=5,429)

96. 10.858 228.018 ↓ 0.0 0 5,429

Append (cost=1.27..53.60 rows=4 width=109) (actual time=0.042..0.042 rows=0 loops=5,429)

97. 0.000 81.435 ↓ 0.0 0 5,429

Nested Loop (cost=1.27..11.58 rows=1 width=109) (actual time=0.015..0.015 rows=0 loops=5,429)

98. 5.429 81.435 ↓ 0.0 0 5,429

Nested Loop (cost=0.98..9.26 rows=1 width=101) (actual time=0.015..0.015 rows=0 loops=5,429)

  • Join Filter: (pp_1.personorganizationreltype = port.personorganizationreltype)
99. 0.148 76.006 ↓ 0.0 0 5,429

Nested Loop (cost=0.98..8.15 rows=1 width=85) (actual time=0.014..0.014 rows=0 loops=5,429)

  • Join Filter: (pr.organizationid = pp_1.organizationid)
100. 5.425 54.290 ↑ 1.0 1 5,429

Nested Loop (cost=0.70..4.79 rows=1 width=17) (actual time=0.010..0.010 rows=1 loops=5,429)

101. 27.145 27.145 ↑ 1.0 1 5,429

Index Scan using pers_pos_personid_idx on pers_pos op (cost=0.29..2.33 rows=1 width=17) (actual time=0.005..0.005 rows=1 loops=5,429)

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

Index Scan using posorgrelbyposition on pos_org_rel pr (cost=0.41..2.45 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=5,430)

  • Index Cond: ((positionid = op.positionid) AND (posorgreltype = 'Member'::bpchar))
  • Filter: ((effectivedate <= enddate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
103. 21.568 21.568 ↓ 0.0 0 5,392

Index Scan using person_organization_rel_pkey on person_organization_rel pp_1 (cost=0.27..3.35 rows=1 width=76) (actual time=0.004..0.004 rows=0 loops=5,392)

  • 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
104. 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)

105. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (personid = pe.personid)
106. 0.000 38.003 ↓ 0.0 0 5,429

Nested Loop (cost=2.26..17.51 rows=1 width=109) (actual time=0.007..0.007 rows=0 loops=5,429)

  • Join Filter: (((pe_5.effectivedate - 1) >= op_1.effectivedate) AND ((pe_5.effectivedate - 1) <= op_1.enddate))
107. 0.000 38.003 ↓ 0.0 0 5,429

Nested Loop (cost=1.97..17.14 rows=1 width=130) (actual time=0.007..0.007 rows=0 loops=5,429)

108. 0.000 38.003 ↓ 0.0 0 5,429

Nested Loop (cost=1.68..14.83 rows=1 width=109) (actual time=0.007..0.007 rows=0 loops=5,429)

109. 5.429 38.003 ↓ 0.0 0 5,429

Nested Loop (cost=1.55..14.65 rows=1 width=120) (actual time=0.007..0.007 rows=0 loops=5,429)

  • Join Filter: (cor.organizationid = oc.organizationid)
110. 0.000 32.574 ↓ 0.0 0 5,429

Nested Loop (cost=1.26..14.31 rows=1 width=121) (actual time=0.006..0.006 rows=0 loops=5,429)

  • Join Filter: (((pe_5.effectivedate - 1) >= pr_1.effectivedate) AND ((pe_5.effectivedate - 1) <= pr_1.enddate))
111. 5.429 32.574 ↓ 0.0 0 5,429

Nested Loop (cost=0.97..9.26 rows=1 width=113) (actual time=0.006..0.006 rows=0 loops=5,429)

112. 27.145 27.145 ↓ 0.0 0 5,429

Index Scan using personemploymentenddate on person_employment pe_5 (cost=0.42..2.46 rows=1 width=21) (actual time=0.005..0.005 rows=0 loops=5,429)

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

Nested Loop (cost=0.55..6.79 rows=1 width=100) (never executed)

114. 0.000 0.000 ↓ 0.0 0

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

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

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

  • Index Cond: (personid = '27192'::bpchar)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
116. 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)

117. 0.000 0.000 ↓ 0.0 0

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

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

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

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

Index Scan using organizationcodeorganizationid on organization_code oc (cost=0.28..0.32 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))
120. 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)
121. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (personid = pe.personid)
122. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (positionid = pr_1.positionid)
  • Filter: ((personid = pe.personid) AND (persposrel = 'Occupies'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
123. 0.000 54.290 ↓ 0.0 0 5,429

Nested Loop (cost=1.82..12.88 rows=1 width=109) (actual time=0.010..0.010 rows=0 loops=5,429)

124. 0.000 54.290 ↓ 0.0 0 5,429

Nested Loop (cost=1.53..10.56 rows=1 width=101) (actual time=0.010..0.010 rows=0 loops=5,429)

125. 5.429 54.290 ↓ 0.0 0 5,429

Nested Loop (cost=1.40..10.38 rows=1 width=112) (actual time=0.010..0.010 rows=0 loops=5,429)

126. 5.423 48.861 ↓ 0.0 0 5,429

Nested Loop (cost=1.11..10.03 rows=1 width=109) (actual time=0.009..0.009 rows=0 loops=5,429)

127. 27.145 27.145 ↑ 1.0 1 5,429

Index Scan using personemploymentenddate on person_employment pe_6 (cost=0.42..2.45 rows=1 width=17) (actual time=0.005..0.005 rows=1 loops=5,429)

  • Index Cond: ((personid = pe.personid) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
128. 0.000 16.293 ↓ 0.0 0 5,431

Nested Loop (cost=0.70..7.57 rows=1 width=100) (actual time=0.003..0.003 rows=0 loops=5,431)

129. 0.000 16.293 ↓ 0.0 0 5,431

Nested Loop (cost=0.41..5.24 rows=1 width=92) (actual time=0.003..0.003 rows=0 loops=5,431)

130. 0.000 16.293 ↓ 0.0 0 5,431

Nested Loop (cost=0.27..4.46 rows=1 width=92) (actual time=0.003..0.003 rows=0 loops=5,431)

  • Join Filter: (por.personorganizationreltype = port_2.personorganizationreltype)
131. 16.293 16.293 ↓ 0.0 0 5,431

Index Scan using person_organization_rel_pkey on person_organization_rel por (cost=0.27..3.35 rows=1 width=76) (actual time=0.003..0.003 rows=0 loops=5,431)

  • 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
132. 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)

133. 0.000 0.000 ↓ 0.0 0

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

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

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

  • Index Cond: ((companyid = pe_6.companyid) AND (organizationid = por.organizationid))
  • 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 organizationcodeorganizationid on organization_code oc_1 (cost=0.28..0.34 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))
136. 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)
137. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (personid = pe.personid)
138. 0.000 43.432 ↓ 0.0 0 5,429

Nested Loop (cost=1.27..11.59 rows=1 width=109) (actual time=0.008..0.008 rows=0 loops=5,429)

139. 0.000 43.432 ↓ 0.0 0 5,429

Nested Loop (cost=0.98..9.27 rows=1 width=101) (actual time=0.008..0.008 rows=0 loops=5,429)

  • Join Filter: (pp_3.personorganizationreltype = port_3.personorganizationreltype)
140. 0.000 43.432 ↓ 0.0 0 5,429

Nested Loop (cost=0.98..8.16 rows=1 width=85) (actual time=0.008..0.008 rows=0 loops=5,429)

  • Join Filter: (pr_2.organizationid = pp_3.organizationid)
141. 5.413 43.432 ↓ 0.0 0 5,429

Nested Loop (cost=0.70..4.80 rows=1 width=17) (actual time=0.008..0.008 rows=0 loops=5,429)

142. 27.145 27.145 ↑ 1.0 1 5,429

Index Scan using pers_pos_personid_idx on pers_pos op_2 (cost=0.29..2.33 rows=1 width=33) (actual time=0.005..0.005 rows=1 loops=5,429)

  • Index Cond: (personid = pe.personid)
  • 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: 0
143. 10.874 10.874 ↓ 0.0 0 5,437

Index Scan using posorgrelbyposition on pos_org_rel pr_2 (cost=0.41..2.46 rows=1 width=24) (actual time=0.002..0.002 rows=0 loops=5,437)

  • 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
144. 0.035 0.035 ↓ 0.0 0 7

Index Scan using person_organization_rel_pkey on person_organization_rel pp_3 (cost=0.27..3.35 rows=1 width=76) (actual time=0.005..0.005 rows=0 loops=7)

  • 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
145. 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)

146. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (personid = pe.personid)
147. 0.000 114.009 ↓ 0.0 0 5,429

Result (cost=1.27..23.47 rows=2 width=141) (actual time=0.021..0.021 rows=0 loops=5,429)

148. 5.429 114.009 ↓ 0.0 0 5,429

Append (cost=1.27..23.45 rows=2 width=109) (actual time=0.021..0.021 rows=0 loops=5,429)

149. 0.000 76.006 ↓ 0.0 0 5,429

Subquery Scan on *SELECT* 1_1 (cost=1.27..9.10 rows=1 width=109) (actual time=0.014..0.014 rows=0 loops=5,429)

150. 0.000 76.006 ↓ 0.0 0 5,429

Nested Loop (cost=1.27..9.09 rows=1 width=193) (actual time=0.014..0.014 rows=0 loops=5,429)

151. 5.429 76.006 ↓ 0.0 0 5,429

Nested Loop (cost=0.98..6.77 rows=1 width=101) (actual time=0.014..0.014 rows=0 loops=5,429)

152. 0.000 70.577 ↓ 0.0 0 5,429

Nested Loop (cost=0.84..6.10 rows=1 width=101) (actual time=0.013..0.013 rows=0 loops=5,429)

  • Join Filter: ((pp_4.personpayunitreltype)::text = (ppurt.personpayunitreltype)::text)
153. 5.432 70.577 ↓ 0.0 0 5,429

Nested Loop (cost=0.84..4.96 rows=1 width=99) (actual time=0.013..0.013 rows=0 loops=5,429)

154. 0.002 48.861 ↑ 1.0 1 5,429

Nested Loop (cost=0.56..4.62 rows=1 width=21) (actual time=0.009..0.009 rows=1 loops=5,429)

155. 38.003 38.003 ↑ 1.0 1 5,429

Index Scan using person_payroll_personid_idx on person_payroll ep (cost=0.29..2.33 rows=1 width=17) (actual time=0.007..0.007 rows=1 loops=5,429)

  • Index Cond: (personid = pe.personid)
  • Filter: ((payunitrelationship = 'M'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
156. 10.856 10.856 ↑ 1.0 1 5,428

Index Only Scan using pay_unit_pkey on pay_unit pu (cost=0.28..2.29 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=5,428)

  • Index Cond: (payunitid = ep.payunitid)
  • Heap Fetches: 5428
157. 16.284 16.284 ↓ 0.0 0 5,428

Index Scan using pk_person_pay_unit_rel on person_pay_unit_rel pp_4 (cost=0.28..0.33 rows=1 width=90) (actual time=0.003..0.003 rows=0 loops=5,428)

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

159. 0.000 0.000 ↓ 0.0 0

Index Only Scan using web_role_pkey on web_role wr_6 (cost=0.14..0.66 rows=1 width=36) (never executed)

  • Index Cond: (rolename = ppurt.rolename)
  • Heap Fetches: 0
160. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (personid = pe.personid)
161. 0.000 32.574 ↓ 0.0 0 5,429

Subquery Scan on *SELECT* 2_1 (cost=14.32..14.35 rows=1 width=109) (actual time=0.006..0.006 rows=0 loops=5,429)

162. 5.429 32.574 ↓ 0.0 0 5,429

Unique (cost=14.32..14.34 rows=1 width=193) (actual time=0.006..0.006 rows=0 loops=5,429)

163. 5.429 27.145 ↓ 0.0 0 5,429

Sort (cost=14.32..14.33 rows=1 width=193) (actual time=0.005..0.005 rows=0 loops=5,429)

  • Sort Key: wr_7.rolename, p_12.companyid, p_12.customerid
  • Sort Method: quicksort Memory: 25kB
164. 5.429 21.716 ↓ 0.0 0 5,429

Nested Loop (cost=1.40..14.31 rows=1 width=193) (actual time=0.004..0.004 rows=0 loops=5,429)

165. 0.000 16.287 ↓ 0.0 0 5,429

Nested Loop (cost=1.11..12.00 rows=1 width=101) (actual time=0.003..0.003 rows=0 loops=5,429)

  • Join Filter: (pu_1.companyid = pe_7.companyid)
166. 0.000 16.287 ↓ 0.0 0 5,429

Nested Loop (cost=0.69..9.53 rows=1 width=92) (actual time=0.003..0.003 rows=0 loops=5,429)

167. 0.000 16.287 ↓ 0.0 0 5,429

Nested Loop (cost=0.55..8.86 rows=1 width=92) (actual time=0.003..0.003 rows=0 loops=5,429)

  • Join Filter: ((pp_5.personpayunitreltype)::text = (ppurt_1.personpayunitreltype)::text)
168. 0.000 16.287 ↓ 0.0 0 5,429

Nested Loop (cost=0.55..7.72 rows=1 width=90) (actual time=0.003..0.003 rows=0 loops=5,429)

169. 16.287 16.287 ↓ 0.0 0 5,429

Index Scan using pk_person_pay_unit_rel on person_pay_unit_rel pp_5 (cost=0.28..5.42 rows=1 width=90) (actual time=0.003..0.003 rows=0 loops=5,429)

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

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

  • Index Cond: (payunitid = pp_5.payunitid)
171. 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)

172. 0.000 0.000 ↓ 0.0 0

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

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

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

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

Index Scan using person_pkey on person p_12 (cost=0.29..2.31 rows=1 width=21) (never executed)

  • Index Cond: (personid = pe.personid)
175. 0.000 10.858 ↓ 0.0 0 5,429

Result (cost=0.71..74.59 rows=3 width=102) (actual time=0.002..0.002 rows=0 loops=5,429)

176. 5.429 10.858 ↓ 0.0 0 5,429

Append (cost=0.71..74.56 rows=3 width=70) (actual time=0.002..0.002 rows=0 loops=5,429)

177. 5.429 5.429 ↓ 0.0 0 5,429

Subquery Scan on *SELECT* 1_2 (cost=0.71..23.82 rows=1 width=70) (actual time=0.001..0.001 rows=0 loops=5,429)

178. 0.000 0.000 ↓ 0.0 0 5,429

Result (cost=0.71..23.81 rows=1 width=154) (actual time=0.000..0.000 rows=0 loops=5,429)

  • One-Time Filter: (pe.personid = '27192'::bpchar)
179. 0.002 0.034 ↑ 1.0 1 1

Nested Loop Semi Join (cost=0.71..23.81 rows=1 width=154) (actual time=0.033..0.034 rows=1 loops=1)

180. 0.006 0.006 ↑ 1.0 1 1

Index Scan using person_pkey on person p_13 (cost=0.29..2.31 rows=1 width=21) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (personid = '27192'::bpchar)
181. 0.026 0.026 ↑ 4.0 1 1

Index Scan using personemploymentenddate on person_employment pe_8 (cost=0.42..21.48 rows=4 width=13) (actual time=0.025..0.026 rows=1 loops=1)

  • Index Cond: ((personid = '27192'::bpchar) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts) AND (emplstatus = ANY ('{A,L,P,C}'::bpchar[])))
  • Rows Removed by Filter: 11
182. 0.000 0.000 ↓ 0.0 0 5,429

Subquery Scan on *SELECT* 2_2 (cost=1.00..17.69 rows=1 width=70) (actual time=0.000..0.000 rows=0 loops=5,429)

183. 0.000 0.000 ↓ 0.0 0 5,429

Result (cost=1.00..17.68 rows=1 width=154) (actual time=0.000..0.000 rows=0 loops=5,429)

  • One-Time Filter: (pe.personid = '27192'::bpchar)
184. 0.000 0.043 ↓ 0.0 0 1

Nested Loop (cost=1.00..17.68 rows=1 width=154) (actual time=0.043..0.043 rows=0 loops=1)

185. 0.002 0.043 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.58..5.92 rows=1 width=21) (actual time=0.043..0.043 rows=0 loops=1)

186. 0.009 0.009 ↑ 1.0 1 1

Index Scan using person_pkey on person p_14 (cost=0.29..2.31 rows=1 width=21) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (personid = '27192'::bpchar)
187. 0.003 0.032 ↑ 13.0 1 1

Result (cost=0.29..23.43 rows=13 width=13) (actual time=0.032..0.032 rows=1 loops=1)

  • One-Time Filter: (pe.personid = '27192'::bpchar)
188. 0.029 0.029 ↑ 13.0 1 1

Index Scan using person_employment_personid_idx on person_employment pe_9 (cost=0.29..23.43 rows=13 width=13) (actual time=0.029..0.029 rows=1 loops=1)

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

Index Scan using pers_pospersendeff on pers_pos pp_6 (cost=0.42..11.74 rows=2 width=13) (never executed)

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

Subquery Scan on *SELECT* 3 (cost=1.00..33.05 rows=1 width=70) (actual time=0.000..0.000 rows=0 loops=5,429)

191. 0.000 0.000 ↓ 0.0 0 5,429

Result (cost=1.00..33.04 rows=1 width=154) (actual time=0.000..0.000 rows=0 loops=5,429)

  • One-Time Filter: (pe.personid = '27192'::bpchar)
192. 0.001 0.016 ↓ 0.0 0 1

Nested Loop Semi Join (cost=1.00..33.04 rows=1 width=154) (actual time=0.016..0.016 rows=0 loops=1)

193. 0.001 0.015 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.58..11.57 rows=1 width=21) (actual time=0.015..0.015 rows=0 loops=1)

194. 0.005 0.005 ↑ 1.0 1 1

Index Scan using person_pkey on person p1 (cost=0.29..2.31 rows=1 width=21) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (personid = '27192'::bpchar)
195. 0.001 0.009 ↑ 2.0 1 1

Result (cost=0.29..13.73 rows=2 width=13) (actual time=0.009..0.009 rows=1 loops=1)

  • One-Time Filter: (pe.personid = '27192'::bpchar)
196. 0.008 0.008 ↑ 2.0 1 1

Index Scan using pers_pos_personid_idx on pers_pos pp_7 (cost=0.29..13.73 rows=2 width=13) (actual time=0.007..0.008 rows=1 loops=1)

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

Index Scan using personemploymentenddate on person_employment p_15 (cost=0.42..21.46 rows=2 width=13) (never executed)

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

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

  • One-Time Filter: false
199. 0.000 124.867 ↓ 0.0 0 5,429

Result (cost=1.16..29.99 rows=3 width=102) (actual time=0.023..0.023 rows=0 loops=5,429)

200. 5.429 124.867 ↓ 0.0 0 5,429

Append (cost=1.16..29.96 rows=3 width=70) (actual time=0.023..0.023 rows=0 loops=5,429)

201. 5.429 70.577 ↓ 0.0 0 5,429

Subquery Scan on *SELECT* 1_3 (cost=1.16..7.38 rows=1 width=70) (actual time=0.013..0.013 rows=0 loops=5,429)

202. 0.000 65.148 ↓ 0.0 0 5,429

Nested Loop (cost=1.16..7.37 rows=1 width=154) (actual time=0.012..0.012 rows=0 loops=5,429)

203. 5.713 65.148 ↓ 0.0 0 5,429

Nested Loop (cost=0.87..5.05 rows=1 width=26) (actual time=0.012..0.012 rows=0 loops=5,429)

204. 5.429 48.861 ↑ 1.0 1 5,429

Nested Loop (cost=0.58..4.67 rows=1 width=17) (actual time=0.009..0.009 rows=1 loops=5,429)

205. 27.145 27.145 ↑ 1.0 1 5,429

Index Scan using pers_pos_personid_idx on pers_pos pp_8 (cost=0.29..2.33 rows=1 width=17) (actual time=0.005..0.005 rows=1 loops=5,429)

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

Index Scan using pos_pos_topositionid on pos_pos p_p (cost=0.29..2.33 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=5,429)

  • Index Cond: ((topositionid = pp_8.positionid) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: ((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
207. 10.574 10.574 ↓ 0.0 0 5,287

Index Scan using pers_pos_positionid_idx on pers_pos p_16 (cost=0.29..0.37 rows=1 width=17) (actual time=0.002..0.002 rows=0 loops=5,287)

  • 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
208. 0.060 0.060 ↑ 1.0 1 12

Index Scan using person_pkey on person (cost=0.29..2.31 rows=1 width=21) (actual time=0.005..0.005 rows=1 loops=12)

  • Index Cond: (personid = pe.personid)
209. 0.000 5.429 ↓ 0.0 0 5,429

Subquery Scan on *SELECT* 2_3 (cost=1.44..13.62 rows=1 width=70) (actual time=0.001..0.001 rows=0 loops=5,429)

210. 0.000 5.429 ↓ 0.0 0 5,429

Nested Loop (cost=1.44..13.61 rows=1 width=154) (actual time=0.001..0.001 rows=0 loops=5,429)

211. 5.429 5.429 ↓ 0.0 0 5,429

Nested Loop (cost=1.30..11.44 rows=1 width=42) (actual time=0.001..0.001 rows=0 loops=5,429)

212. 0.000 0.000 ↓ 0.0 0 5,429

Index Scan using processcontroloriginator on process_control pc (cost=0.14..2.16 rows=1 width=60) (actual time=0.000..0.000 rows=0 loops=5,429)

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

Nested Loop (cost=1.16..9.26 rows=1 width=34) (never executed)

  • Join Filter: (p_17.personid <> pp_9.personid)
214. 0.000 0.000 ↓ 0.0 0

Nested Loop Anti Join (cost=0.87..6.94 rows=1 width=21) (never executed)

  • Join Filter: (pxp.personid = pp_9.personid)
215. 0.000 0.000 ↓ 0.0 0

Index Scan using person_pkey on person pp_9 (cost=0.29..2.31 rows=1 width=21) (never executed)

  • Index Cond: (personid = pe.personid)
216. 0.000 0.000 ↓ 0.0 0

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

217. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (personid = pe.personid)
218. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

  • Index Cond: ((processid = pc.processid) AND (logid = pc.logid))
  • Filter: ((entitykey = pe.personid) AND (subjectid = 'PERSON'::bpchar))
221. 0.000 43.432 ↓ 0.0 0 5,429

Subquery Scan on *SELECT* 3_1 (cost=1.16..8.96 rows=1 width=70) (actual time=0.008..0.008 rows=0 loops=5,429)

222. 0.000 43.432 ↓ 0.0 0 5,429

Nested Loop (cost=1.16..8.95 rows=1 width=154) (actual time=0.008..0.008 rows=0 loops=5,429)

223. 5.429 43.432 ↓ 0.0 0 5,429

Nested Loop (cost=0.87..6.63 rows=1 width=26) (actual time=0.008..0.008 rows=0 loops=5,429)

224. 0.000 38.003 ↓ 0.0 0 5,429

Nested Loop (cost=0.58..4.66 rows=1 width=17) (actual time=0.007..0.007 rows=0 loops=5,429)

225. 27.145 27.145 ↑ 1.0 1 5,429

Index Scan using pers_pos_personid_idx on pers_pos pp_10 (cost=0.29..2.33 rows=1 width=17) (actual time=0.005..0.005 rows=1 loops=5,429)

  • Index Cond: (personid = pe.personid)
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
226. 10.858 10.858 ↓ 0.0 0 5,429

Index Scan using pos_pos_topositionid on pos_pos p_p_1 (cost=0.29..2.32 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=5,429)

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

Index Scan using pers_pos_positionid_idx on pers_pos p_18 (cost=0.29..1.96 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))
228. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (personid = pe.personid)
229. 0.000 233.447 ↓ 0.0 0 5,429

Result (cost=1.45..24.87 rows=6 width=102) (actual time=0.043..0.043 rows=0 loops=5,429)

230. 5.429 233.447 ↓ 0.0 0 5,429

Append (cost=1.45..24.81 rows=6 width=70) (actual time=0.043..0.043 rows=0 loops=5,429)

231. 0.000 70.577 ↓ 0.0 0 5,429

Subquery Scan on *SELECT* 1_4 (cost=1.45..7.79 rows=2 width=70) (actual time=0.013..0.013 rows=0 loops=5,429)

232. 5.412 70.577 ↓ 0.0 0 5,429

Nested Loop (cost=1.45..7.77 rows=2 width=154) (actual time=0.013..0.013 rows=0 loops=5,429)

233. 0.000 65.148 ↓ 0.0 0 5,429

Nested Loop (cost=1.45..7.71 rows=1 width=34) (actual time=0.012..0.012 rows=0 loops=5,429)

234. 0.358 65.148 ↓ 0.0 0 5,429

Nested Loop (cost=1.16..5.39 rows=1 width=26) (actual time=0.012..0.012 rows=0 loops=5,429)

235. 5.713 54.290 ↑ 1.0 1 5,429

Nested Loop (cost=0.87..5.01 rows=1 width=17) (actual time=0.009..0.010 rows=1 loops=5,429)

236. 5.428 38.003 ↑ 1.0 1 5,429

Nested Loop (cost=0.58..4.66 rows=1 width=17) (actual time=0.007..0.007 rows=1 loops=5,429)

237. 27.145 27.145 ↑ 1.0 1 5,429

Index Scan using pers_pos_personid_idx on pers_pos p3 (cost=0.29..2.33 rows=1 width=17) (actual time=0.005..0.005 rows=1 loops=5,429)

  • Index Cond: (personid = pe.personid)
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_DATE < enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
238. 5.430 5.430 ↑ 1.0 1 5,430

Index Scan using pos_pos_topositionid on pos_pos p2 (cost=0.29..2.32 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=5,430)

  • Index Cond: ((topositionid = p3.positionid) AND (CURRENT_DATE < enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
239. 10.574 10.574 ↑ 1.0 1 5,287

Index Scan using pos_pos_topositionid on pos_pos p1_1 (cost=0.29..0.34 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=5,287)

  • Index Cond: ((topositionid = p2.positionid) AND (CURRENT_DATE < enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
240. 10.500 10.500 ↓ 0.0 0 5,250

Index Scan using pers_pos_positionid_idx on pers_pos p_19 (cost=0.29..0.37 rows=1 width=17) (actual time=0.002..0.002 rows=0 loops=5,250)

  • Index Cond: (positionid = p1_1.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: 1
241. 0.085 0.085 ↑ 1.0 1 17

Index Scan using person_pkey on person person_2 (cost=0.29..2.31 rows=1 width=21) (actual time=0.005..0.005 rows=1 loops=17)

  • Index Cond: (personid = pe.personid)
242. 0.017 0.017 ↑ 1.0 2 17

Append (cost=0.00..0.04 rows=2 width=36) (actual time=0.000..0.001 rows=2 loops=17)

243. 0.000 0.000 ↑ 1.0 1 17

Result (cost=0.00..0.01 rows=1 width=36) (actual time=0.000..0.000 rows=1 loops=17)

244. 0.000 0.000 ↑ 1.0 1 17

Result (cost=0.00..0.01 rows=1 width=36) (actual time=0.000..0.000 rows=1 loops=17)

245. 0.000 81.435 ↓ 0.0 0 5,429

Subquery Scan on *SELECT* 2_4 (cost=1.74..8.14 rows=2 width=70) (actual time=0.015..0.015 rows=0 loops=5,429)

246. 0.000 81.435 ↓ 0.0 0 5,429

Nested Loop (cost=1.74..8.12 rows=2 width=154) (actual time=0.015..0.015 rows=0 loops=5,429)

247. 0.000 81.435 ↓ 0.0 0 5,429

Nested Loop (cost=1.74..8.06 rows=1 width=34) (actual time=0.015..0.015 rows=0 loops=5,429)

248. 5.909 81.435 ↓ 0.0 0 5,429

Nested Loop (cost=1.45..5.75 rows=1 width=26) (actual time=0.015..0.015 rows=0 loops=5,429)

249. 5.787 65.148 ↑ 1.0 1 5,429

Nested Loop (cost=1.16..5.36 rows=1 width=17) (actual time=0.011..0.012 rows=1 loops=5,429)

250. 5.571 48.861 ↑ 1.0 1 5,429

Nested Loop (cost=0.87..5.01 rows=1 width=17) (actual time=0.009..0.009 rows=1 loops=5,429)

251. 5.428 38.003 ↑ 1.0 1 5,429

Nested Loop (cost=0.58..4.66 rows=1 width=17) (actual time=0.007..0.007 rows=1 loops=5,429)

252. 27.145 27.145 ↑ 1.0 1 5,429

Index Scan using pers_pos_personid_idx on pers_pos p5 (cost=0.29..2.33 rows=1 width=17) (actual time=0.005..0.005 rows=1 loops=5,429)

  • Index Cond: (personid = pe.personid)
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_DATE < enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
253. 5.430 5.430 ↑ 1.0 1 5,430

Index Scan using pos_pos_topositionid on pos_pos p3_1 (cost=0.29..2.32 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=5,430)

  • Index Cond: ((topositionid = p5.positionid) AND (CURRENT_DATE < enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
254. 5.287 5.287 ↑ 1.0 1 5,287

Index Scan using pos_pos_topositionid on pos_pos p2_1 (cost=0.29..0.34 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=5,287)

  • Index Cond: ((topositionid = p3_1.positionid) AND (CURRENT_DATE < enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
255. 10.500 10.500 ↑ 1.0 1 5,250

Index Scan using pos_pos_topositionid on pos_pos p1_2 (cost=0.29..0.34 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=5,250)

  • Index Cond: ((topositionid = p2_1.positionid) AND (CURRENT_DATE < enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
256. 10.378 10.378 ↓ 0.0 0 5,189

Index Scan using pers_pos_positionid_idx on pers_pos p_20 (cost=0.29..0.37 rows=1 width=17) (actual time=0.002..0.002 rows=0 loops=5,189)

  • 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: 2
257. 0.050 0.050 ↑ 1.0 1 10

Index Scan using person_pkey on person person_3 (cost=0.29..2.31 rows=1 width=21) (actual time=0.005..0.005 rows=1 loops=10)

  • Index Cond: (personid = pe.personid)
258. 0.010 0.010 ↑ 1.0 2 10

Append (cost=0.00..0.04 rows=2 width=36) (actual time=0.000..0.001 rows=2 loops=10)

259. 0.000 0.000 ↑ 1.0 1 10

Result (cost=0.00..0.01 rows=1 width=36) (actual time=0.000..0.000 rows=1 loops=10)

260. 0.000 0.000 ↑ 1.0 1 10

Result (cost=0.00..0.01 rows=1 width=36) (actual time=0.000..0.000 rows=1 loops=10)

261. 0.000 76.006 ↓ 0.0 0 5,429

Subquery Scan on *SELECT* 3_2 (cost=2.03..8.88 rows=2 width=70) (actual time=0.014..0.014 rows=0 loops=5,429)

262. 0.000 76.006 ↓ 0.0 0 5,429

Nested Loop (cost=2.03..8.86 rows=2 width=154) (actual time=0.014..0.014 rows=0 loops=5,429)

263. 5.419 76.006 ↓ 0.0 0 5,429

Nested Loop (cost=2.03..8.80 rows=1 width=34) (actual time=0.014..0.014 rows=0 loops=5,429)

264. 0.000 70.577 ↓ 0.0 0 5,429

Nested Loop (cost=1.74..6.48 rows=1 width=26) (actual time=0.013..0.013 rows=0 loops=5,429)

265. 5.669 70.577 ↓ 0.0 0 5,429

Nested Loop (cost=1.45..5.72 rows=2 width=17) (actual time=0.013..0.013 rows=0 loops=5,429)

266. 5.608 59.719 ↑ 1.0 1 5,429

Nested Loop (cost=1.16..5.36 rows=1 width=17) (actual time=0.010..0.011 rows=1 loops=5,429)

267. 5.571 48.861 ↑ 1.0 1 5,429

Nested Loop (cost=0.87..5.01 rows=1 width=17) (actual time=0.009..0.009 rows=1 loops=5,429)

268. 5.428 38.003 ↑ 1.0 1 5,429

Nested Loop (cost=0.58..4.66 rows=1 width=17) (actual time=0.007..0.007 rows=1 loops=5,429)

269. 27.145 27.145 ↑ 1.0 1 5,429

Index Scan using pers_pos_personid_idx on pers_pos p7 (cost=0.29..2.33 rows=1 width=17) (actual time=0.005..0.005 rows=1 loops=5,429)

  • Index Cond: (personid = pe.personid)
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (CURRENT_DATE < enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
270. 5.430 5.430 ↑ 1.0 1 5,430

Index Scan using pos_pos_topositionid on pos_pos p4 (cost=0.29..2.32 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=5,430)

  • Index Cond: ((topositionid = p7.positionid) AND (CURRENT_DATE < enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
271. 5.287 5.287 ↑ 1.0 1 5,287

Index Scan using pos_pos_topositionid on pos_pos p3_2 (cost=0.29..0.34 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=5,287)

  • Index Cond: ((topositionid = p4.positionid) AND (CURRENT_DATE < enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
272. 5.250 5.250 ↑ 1.0 1 5,250

Index Scan using pos_pos_topositionid on pos_pos p2_2 (cost=0.29..0.34 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=5,250)

  • Index Cond: ((topositionid = p3_2.positionid) AND (CURRENT_DATE < enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
273. 5.189 5.189 ↓ 0.0 0 5,189

Index Scan using pos_pos_topositionid on pos_pos p1_3 (cost=0.29..0.34 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=5,189)

  • Index Cond: ((topositionid = p2_2.positionid) AND (CURRENT_DATE < enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
274. 0.888 0.888 ↓ 0.0 0 222

Index Scan using pers_pos_positionid_idx on pers_pos p_21 (cost=0.29..0.37 rows=1 width=17) (actual time=0.004..0.004 rows=0 loops=222)

  • Index Cond: (positionid = p1_3.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
275. 0.010 0.010 ↑ 1.0 1 2

Index Scan using person_pkey on person person_4 (cost=0.29..2.31 rows=1 width=21) (actual time=0.005..0.005 rows=1 loops=2)

  • Index Cond: (personid = pe.personid)
276. 0.000 0.002 ↑ 1.0 2 2

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

277. 0.002 0.002 ↑ 1.0 1 2

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

278. 0.000 0.000 ↑ 1.0 1 2

Result (cost=0.00..0.01 rows=1 width=36) (actual time=0.000..0.000 rows=1 loops=2)

279. 0.000 48.861 ↓ 0.0 0 5,429

Nested Loop (cost=0.86..10.01 rows=1 width=141) (actual time=0.009..0.009 rows=0 loops=5,429)

280. 5.429 48.861 ↓ 0.0 0 5,429

Nested Loop (cost=0.57..7.69 rows=1 width=20) (actual time=0.009..0.009 rows=0 loops=5,429)

281. 43.432 43.432 ↓ 0.0 0 5,429

Index Scan using act_ru_variable_name__text__idx on act_ru_variable arv (cost=0.29..5.37 rows=1 width=19) (actual time=0.008..0.008 rows=0 loops=5,429)

  • Index Cond: ((name_)::text = 'originatorID'::text)
  • Filter: ((text_)::character(12) = '27192'::bpchar)
  • Rows Removed by Filter: 6
282. 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.29..2.31 rows=1 width=19) (never executed)

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

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

  • Index Cond: (personid = pe.personid)
284. 5.429 48.861 ↓ 0.0 0 5,429

Nested Loop (cost=1.54..13.70 rows=1 width=102) (actual time=0.009..0.009 rows=0 loops=5,429)

285. 0.000 43.432 ↓ 0.0 0 5,429

Nested Loop (cost=1.25..11.39 rows=1 width=26) (actual time=0.008..0.008 rows=0 loops=5,429)

286. 0.000 43.432 ↓ 0.0 0 5,429

Nested Loop (cost=0.98..7.07 rows=1 width=30) (actual time=0.008..0.008 rows=0 loops=5,429)

287. 0.000 43.432 ↓ 0.0 0 5,429

Nested Loop (cost=0.56..4.61 rows=1 width=13) (actual time=0.008..0.008 rows=0 loops=5,429)

288. 27.145 27.145 ↑ 1.0 1 5,429

Index Only Scan using person_pkey on person u (cost=0.29..2.31 rows=1 width=13) (actual time=0.005..0.005 rows=1 loops=5,429)

  • Index Cond: (personid = '27192'::bpchar)
  • Heap Fetches: 5429
289. 16.287 16.287 ↓ 0.0 0 5,429

Index Only Scan using assigned_roles_pkey on assigned_roles ar_1 (cost=0.27..2.29 rows=1 width=52) (actual time=0.003..0.003 rows=0 loops=5,429)

  • Index Cond: ((personid = '27192'::bpchar) AND (rolename = 'Onboard'::bpchar))
  • Heap Fetches: 0
290. 0.000 0.000 ↓ 0.0 0

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

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

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

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

Index Scan using person_pkey on person p_23 (cost=0.29..2.31 rows=1 width=21) (never executed)

  • Index Cond: (personid = pe.personid)
293. 16.287 108.580 ↑ 1.0 18 5,429

Nested Loop (cost=0.71..19.93 rows=18 width=98) (actual time=0.012..0.020 rows=18 loops=5,429)

294. 27.145 27.145 ↑ 1.0 1 5,429

Index Scan using person_pkey on person p_24 (cost=0.29..2.31 rows=1 width=21) (actual time=0.004..0.005 rows=1 loops=5,429)

  • Index Cond: (personid = pe.personid)
295. 65.148 65.148 ↑ 1.0 18 5,429

Index Only Scan using person_identity_pkey on person_identity p1_4 (cost=0.42..17.45 rows=18 width=13) (actual time=0.006..0.012 rows=18 loops=5,429)

  • Index Cond: (personid = '27192'::bpchar)
  • Heap Fetches: 97722
296. 5.429 1,780.712 ↑ 1.0 1 5,429

Subquery Scan on *SELECT* 13 (cost=1.12..22.86 rows=1 width=98) (actual time=0.105..0.328 rows=1 loops=5,429)

297. 5.419 1,775.283 ↑ 1.0 1 5,429

Nested Loop (cost=1.12..22.85 rows=1 width=98) (actual time=0.105..0.327 rows=1 loops=5,429)

298. 4.799 1,742.709 ↑ 1.0 1 5,429

Nested Loop (cost=0.83..20.53 rows=1 width=26) (actual time=0.100..0.321 rows=1 loops=5,429)

299. 27.145 27.145 ↑ 1.0 1 5,429

Index Scan using personemploymentenddate on person_employment pcr_2 (cost=0.42..2.45 rows=1 width=17) (actual time=0.005..0.005 rows=1 loops=5,429)

  • Index Cond: ((personid = pe.personid) AND (CURRENT_DATE <= enddate))
  • Filter: ((effectivedate <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
300. 1,710.765 1,710.765 ↑ 1.0 1 5,431

Index Scan using employmentcompanyideffdt on person_employment pe_11 (cost=0.42..18.07 rows=1 width=17) (actual time=0.093..0.315 rows=1 loops=5,431)

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

Index Scan using person_pkey on person p_25 (cost=0.29..2.31 rows=1 width=21) (actual time=0.004..0.005 rows=1 loops=5,431)

  • Index Cond: (personid = pe.personid)
302. 5.429 16.287 ↓ 0.0 0 5,429

Nested Loop (cost=0.99..10.42 rows=1 width=141) (actual time=0.003..0.003 rows=0 loops=5,429)

  • Join Filter: (pcr_3.personcustomerreltype = pcrt_2.personcustomerreltype)
303. 0.000 10.858 ↓ 0.0 0 5,429

Nested Loop (cost=0.99..9.15 rows=1 width=97) (actual time=0.002..0.002 rows=0 loops=5,429)

304. 0.000 10.858 ↓ 0.0 0 5,429

Nested Loop (cost=0.70..6.83 rows=1 width=89) (actual time=0.002..0.002 rows=0 loops=5,429)

  • Join Filter: (cs.companyid = pe_12.companyid)
305. 0.000 10.858 ↓ 0.0 0 5,429

Nested Loop (cost=0.28..4.37 rows=1 width=80) (actual time=0.002..0.002 rows=0 loops=5,429)

306. 10.858 10.858 ↓ 0.0 0 5,429

Index Scan using pk_person_customer_rel on person_customer_rel pcr_3 (cost=0.14..2.18 rows=1 width=80) (actual time=0.002..0.002 rows=0 loops=5,429)

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

Index Scan using pk_customer_struct on customer_struct cs (cost=0.14..2.18 rows=1 width=8) (never executed)

  • Index Cond: (customerid = pcr_3.customerid)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
308. 0.000 0.000 ↓ 0.0 0

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

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

Index Scan using person_pkey on person p_26 (cost=0.29..2.31 rows=1 width=21) (never executed)

  • Index Cond: (personid = pe.personid)
310. 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)

311. 0.004 0.025 ↓ 3.0 3 1

Hash (cost=3.32..3.32 rows=1 width=78) (actual time=0.025..0.025 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
312. 0.005 0.021 ↓ 3.0 3 1

Nested Loop Left Join (cost=0.28..3.32 rows=1 width=78) (actual time=0.017..0.021 rows=3 loops=1)

313. 0.004 0.004 ↓ 3.0 3 1

Seq Scan on person_image pi (cost=0.00..1.01 rows=1 width=56) (actual time=0.004..0.004 rows=3 loops=1)

314. 0.012 0.012 ↑ 1.0 1 3

Index Scan using document_content_pkey on document_content dc (cost=0.28..2.30 rows=1 width=30) (actual time=0.004..0.004 rows=1 loops=3)

  • Index Cond: (documentid = pi.documentid)
Planning time : 202.673 ms
Execution time : 3,667.921 ms