explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MzsL

Settings
# exclusive inclusive rows x rows loops node
1. 14.617 9,985.621 ↑ 13.5 5,429 1

Sort (cost=2,565,653.92..2,565,837.19 rows=73,308 width=84) (actual time=9,985.361..9,985.621 rows=5,429 loops=1)

  • Sort Key: (btrim((pn.lname)::text))
  • Sort Method: quicksort Memory: 618kB
2. 8.900 9,971.004 ↑ 13.5 5,429 1

Nested Loop Left Join (cost=1.41..2,559,730.01 rows=73,308 width=84) (actual time=1.441..9,971.004 rows=5,429 loops=1)

  • Join Filter: (pn.personid = pi.personid)
  • Rows Removed by Join Filter: 16286
3. 6.163 9,962.104 ↑ 13.2 5,429 1

Nested Loop (cost=1.12..2,558,471.54 rows=71,459 width=39) (actual time=1.411..9,962.104 rows=5,429 loops=1)

  • Join Filter: (pe.personid = pn.personid)
4. 7.689 9,923.361 ↓ 3.8 5,430 1

Nested Loop Semi Join (cost=0.83..2,557,891.93 rows=1,422 width=26) (actual time=1.395..9,923.361 rows=5,430 loops=1)

5. 11.568 9,882.768 ↓ 2.8 5,484 1

Index Scan using employmentcompanyideffdt on person_employment pe (cost=0.42..2,556,322.61 rows=1,983 width=13) (actual time=1.364..9,882.768 rows=5,484 loops=1)

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

SubPlan (for Index Scan)

7. 21.936 9,871.200 ↑ 27.0 1 5,484

Hash Join (cost=385.33..418.24 rows=27 width=0) (actual time=1.800..1.800 rows=1 loops=5,484)

  • Hash Cond: ("*SELECT* 1".rolename = rpa.rolename)
8. 10.968 197.424 ↑ 1.8 15 5,484

Append (cost=0.56..33.11 rows=27 width=10) (actual time=0.025..0.036 rows=15 loops=5,484)

9. 5.484 32.904 ↓ 0.0 0 5,484

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

10. 0.000 27.420 ↓ 0.0 0 5,484

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

11. 27.420 27.420 ↓ 0.0 0 5,484

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,484)

  • Index Cond: ((negative = false) AND ((domainobject)::text = 'PersonCompensationItem'::text) AND ((action)::text = 'Read'::text) AND (companyid = pe.companyid))
  • Filter: (NOT negative)
12. 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
13. 5.484 153.552 ↑ 1.7 15 5,484

Subquery Scan on *SELECT* 2 (cost=2.87..26.46 rows=26 width=9) (actual time=0.019..0.028 rows=15 loops=5,484)

14. 21.936 148.068 ↑ 1.7 15 5,484

Merge Anti Join (cost=2.87..26.20 rows=26 width=261) (actual time=0.018..0.027 rows=15 loops=5,484)

  • 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))
15. 43.872 93.228 ↑ 1.7 15 5,484

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

16. 49.356 49.356 ↑ 1.7 15 5,484

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,484)

  • Index Cond: ((domainobject = 'PersonCompensationItem'::text) AND (action = 'Read'::text))
  • Heap Fetches: 82120
17. 0.000 0.000 ↑ 1.0 1 82,120

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

18. 10.968 10.968 ↑ 1.0 1 5,484

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,484)

  • Index Cond: (companyid = pe.companyid)
  • Heap Fetches: 5484
19. 10.968 32.904 ↓ 0.0 0 5,484

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

  • Sort Key: sc3_1.rolename
  • Sort Method: quicksort Memory: 25kB
20. 21.936 21.936 ↓ 0.0 0 5,484

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,484)

  • Index Cond: ((negative = true) AND ((domainobject)::text = 'PersonCompensationItem'::text) AND ((action)::text = 'Read'::text) AND (companyid = pe.companyid))
  • Filter: negative
21. 10.968 9,651.840 ↑ 16.0 3 5,484

Hash (cost=384.17..384.17 rows=48 width=32) (actual time=1.760..1.760 rows=3 loops=5,484)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
22. 5.484 9,640.872 ↑ 16.0 3 5,484

Subquery Scan on rpa (cost=383.21..384.17 rows=48 width=32) (actual time=1.757..1.758 rows=3 loops=5,484)

23. 60.324 9,635.388 ↑ 16.0 3 5,484

HashAggregate (cost=383.21..383.69 rows=48 width=176) (actual time=1.757..1.757 rows=3 loops=5,484)

  • Group Key: ar.personid, p.personid, ar.rolename, (''::text), p.companyid, p.customerid
24. 32.904 9,575.064 ↑ 2.4 20 5,484

Append (cost=0.98..382.49 rows=48 width=176) (actual time=0.067..1.746 rows=20 loops=5,484)

25. 0.000 16.452 ↓ 0.0 0 5,484

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

26. 0.000 16.452 ↓ 0.0 0 5,484

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

27. 16.452 16.452 ↓ 0.0 0 5,484

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,484)

  • Index Cond: (personid = '27192'::bpchar)
  • Heap Fetches: 0
28. 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)))
29. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (personid = pe.personid)
30. 5.484 350.976 ↑ 2.0 1 5,484

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

31. 0.000 345.492 ↑ 2.0 1 5,484

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

32. 16.452 345.492 ↑ 2.0 1 5,484

Sort (cost=19.51..19.52 rows=2 width=148) (actual time=0.062..0.063 rows=1 loops=5,484)

  • Sort Key: pcr.personid, p_1.personid, wr.rolename, p_1.companyid, p_1.customerid
  • Sort Method: quicksort Memory: 25kB
33. 5.484 329.040 ↑ 2.0 1 5,484

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

34. 0.000 142.584 ↑ 1.0 1 5,484

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

35. 10.926 115.164 ↑ 1.0 1 5,484

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

36. 5.463 93.228 ↑ 1.0 1 5,484

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

37. 10.821 82.260 ↑ 1.0 1 5,484

Nested Loop (cost=0.70..4.78 rows=1 width=32) (actual time=0.013..0.015 rows=1 loops=5,484)

38. 32.904 32.904 ↑ 1.0 1 5,484

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

  • 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
39. 38.535 38.535 ↑ 1.0 1 5,505

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,505)

  • 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
40. 5.505 5.505 ↑ 1.0 1 5,505

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,505)

  • Index Cond: (personcompanyreltype = pcr.personcompanyreltype)
41. 11.010 11.010 ↑ 1.0 1 5,505

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,505)

  • Index Cond: (rolename = pcrt.rolename)
  • Heap Fetches: 5505
42. 27.525 27.525 ↑ 1.0 1 5,505

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

  • Index Cond: (personid = pe.personid)
43. 10.988 180.972 ↓ 0.0 0 5,484

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

  • Join Filter: (pe_3.personid = pp.personid)
44. 0.020 142.584 ↑ 1.0 1 5,484

Nested Loop (cost=1.43..8.62 rows=1 width=70) (actual time=0.024..0.026 rows=1 loops=5,484)

45. 10.972 115.164 ↑ 1.0 1 5,484

Nested Loop (cost=1.14..6.30 rows=1 width=62) (actual time=0.019..0.021 rows=1 loops=5,484)

46. 5.488 98.712 ↑ 1.0 1 5,484

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

47. 5.502 87.744 ↑ 1.0 1 5,484

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

48. 5.493 49.356 ↑ 1.0 1 5,484

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

49. 27.420 27.420 ↑ 1.0 1 5,484

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

  • 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
50. 16.443 16.443 ↑ 1.0 1 5,481

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,481)

  • 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
51. 32.886 32.886 ↑ 1.0 1 5,481

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,481)

  • 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
52. 5.480 5.480 ↑ 1.0 1 5,480

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,480)

  • Index Cond: (personcompanyreltype = pcr_1.personcompanyreltype)
53. 5.480 5.480 ↑ 1.0 1 5,480

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,480)

  • Index Cond: (rolename = pcrt_1.rolename)
  • Heap Fetches: 5480
54. 27.400 27.400 ↑ 1.0 1 5,480

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

  • Index Cond: (personid = pe.personid)
55. 27.400 27.400 ↑ 1.0 1 5,480

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,480)

  • 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
56. 5.484 126.132 ↓ 0.0 0 5,484

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

57. 0.000 120.648 ↓ 0.0 0 5,484

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

58. 0.000 60.324 ↓ 0.0 0 5,484

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

  • Join Filter: ((cpl.locationid <> lp.locationid) AND (cpl.personid = lp.personid))
59. 5.484 60.324 ↓ 0.0 0 5,484

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

60. 0.000 54.840 ↓ 0.0 0 5,484

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

61. 0.000 54.840 ↓ 0.0 0 5,484

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

  • Join Filter: (plr.personlocationreltype = plrt.personlocationreltype)
62. 5.538 54.840 ↓ 0.0 0 5,484

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

63. 32.904 32.904 ↑ 1.0 1 5,484

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

  • 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
64. 16.398 16.398 ↓ 0.0 0 5,466

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,466)

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

66. 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
67. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (personid = pe.personid)
68. 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))
69. 5.484 27.420 ↓ 0.0 0 5,484

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

70. 0.000 21.936 ↓ 0.0 0 5,484

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

  • Join Filter: (cl.companyid = pe_4.companyid)
71. 0.000 21.936 ↓ 0.0 0 5,484

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

72. 0.000 21.936 ↓ 0.0 0 5,484

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

73. 0.000 21.936 ↓ 0.0 0 5,484

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

  • Join Filter: (plr_1.personlocationreltype = plrt_1.personlocationreltype)
74. 21.936 21.936 ↓ 0.0 0 5,484

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,484)

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

76. 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
77. 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))
78. 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))
79. 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)
80. 5.484 32.904 ↓ 0.0 0 5,484

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

81. 0.000 27.420 ↓ 0.0 0 5,484

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

82. 0.000 27.420 ↓ 0.0 0 5,484

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

  • Join Filter: (plr_2.personlocationreltype = plrt_2.personlocationreltype)
83. 0.000 27.420 ↓ 0.0 0 5,484

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

84. 27.420 27.420 ↓ 0.0 0 5,484

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,484)

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

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.005..0.005 rows=0 loops=5)

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

87. 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
88. 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)
89. 0.000 230.328 ↓ 0.0 0 5,484

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

90. 10.968 230.328 ↓ 0.0 0 5,484

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

91. 0.000 76.776 ↓ 0.0 0 5,484

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

92. 0.000 76.776 ↓ 0.0 0 5,484

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

  • Join Filter: (pp_1.personorganizationreltype = port.personorganizationreltype)
93. 5.656 76.776 ↓ 0.0 0 5,484

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

  • Join Filter: (pr.organizationid = pp_1.organizationid)
94. 0.012 49.356 ↑ 1.0 1 5,484

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

95. 27.420 27.420 ↑ 1.0 1 5,484

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,484)

  • 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
96. 21.924 21.924 ↑ 1.0 1 5,481

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,481)

  • 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
97. 21.764 21.764 ↓ 0.0 0 5,441

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,441)

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

99. 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)
100. 0.000 38.388 ↓ 0.0 0 5,484

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

  • Join Filter: (((pe_5.effectivedate - 1) >= op_1.effectivedate) AND ((pe_5.effectivedate - 1) <= op_1.enddate))
101. 0.000 38.388 ↓ 0.0 0 5,484

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

102. 0.000 38.388 ↓ 0.0 0 5,484

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

103. 5.484 38.388 ↓ 0.0 0 5,484

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

  • Join Filter: (cor.organizationid = oc.organizationid)
104. 0.000 32.904 ↓ 0.0 0 5,484

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

  • Join Filter: (((pe_5.effectivedate - 1) >= pr_1.effectivedate) AND ((pe_5.effectivedate - 1) <= pr_1.enddate))
105. 5.484 32.904 ↓ 0.0 0 5,484

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

106. 27.420 27.420 ↓ 0.0 0 5,484

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,484)

  • 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
107. 0.000 0.000 ↓ 0.0 0

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

108. 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)
109. 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))
110. 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)

111. 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))
112. 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))
113. 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))
114. 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)
115. 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)
116. 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))
117. 0.000 54.840 ↓ 0.0 0 5,484

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

118. 0.000 54.840 ↓ 0.0 0 5,484

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

119. 0.000 54.840 ↓ 0.0 0 5,484

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

120. 5.476 54.840 ↓ 0.0 0 5,484

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

121. 27.420 27.420 ↑ 1.0 1 5,484

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,484)

  • 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
122. 5.486 21.944 ↓ 0.0 0 5,486

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

123. 0.000 16.458 ↓ 0.0 0 5,486

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

124. 0.000 16.458 ↓ 0.0 0 5,486

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

  • Join Filter: (por.personorganizationreltype = port_2.personorganizationreltype)
125. 16.458 16.458 ↓ 0.0 0 5,486

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,486)

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

127. 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
128. 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))
129. 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))
130. 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)
131. 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)
132. 0.000 49.356 ↓ 0.0 0 5,484

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

133. 5.484 49.356 ↓ 0.0 0 5,484

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

  • Join Filter: (pp_3.personorganizationreltype = port_3.personorganizationreltype)
134. 0.000 43.872 ↓ 0.0 0 5,484

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

  • Join Filter: (pr_2.organizationid = pp_3.organizationid)
135. 5.472 43.872 ↓ 0.0 0 5,484

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

136. 27.420 27.420 ↑ 1.0 1 5,484

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,484)

  • 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
137. 10.980 10.980 ↓ 0.0 0 5,490

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,490)

  • 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
138. 0.032 0.032 ↓ 0.0 0 8

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.004..0.004 rows=0 loops=8)

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

140. 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)
141. 0.000 109.680 ↓ 0.0 0 5,484

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

142. 5.484 109.680 ↓ 0.0 0 5,484

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

143. 0.000 71.292 ↓ 0.0 0 5,484

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

144. 0.000 71.292 ↓ 0.0 0 5,484

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

145. 0.000 71.292 ↓ 0.0 0 5,484

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

146. 5.484 71.292 ↓ 0.0 0 5,484

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

  • Join Filter: ((pp_4.personpayunitreltype)::text = (ppurt.personpayunitreltype)::text)
147. 5.598 65.808 ↓ 0.0 0 5,484

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

148. 0.076 43.872 ↑ 1.0 1 5,484

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

149. 32.904 32.904 ↑ 1.0 1 5,484

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

  • 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
150. 10.892 10.892 ↑ 1.0 1 5,446

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,446)

  • Index Cond: (payunitid = ep.payunitid)
  • Heap Fetches: 5446
151. 16.338 16.338 ↓ 0.0 0 5,446

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,446)

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

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

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,484)

156. 5.484 32.904 ↓ 0.0 0 5,484

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

157. 10.968 27.420 ↓ 0.0 0 5,484

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

  • Sort Key: wr_7.rolename, p_11.companyid, p_11.customerid
  • Sort Method: quicksort Memory: 25kB
158. 0.000 16.452 ↓ 0.0 0 5,484

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

159. 0.000 16.452 ↓ 0.0 0 5,484

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

  • Join Filter: (pu_1.companyid = pe_7.companyid)
160. 0.000 16.452 ↓ 0.0 0 5,484

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

161. 0.000 16.452 ↓ 0.0 0 5,484

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

  • Join Filter: ((pp_5.personpayunitreltype)::text = (ppurt_1.personpayunitreltype)::text)
162. 0.000 16.452 ↓ 0.0 0 5,484

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

163. 16.452 16.452 ↓ 0.0 0 5,484

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,484)

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

166. 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
167. 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))
168. 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)
169. 0.000 10.968 ↓ 0.0 0 5,484

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

170. 5.484 10.968 ↓ 0.0 0 5,484

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

171. 5.484 5.484 ↓ 0.0 0 5,484

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,484)

172. 0.000 0.000 ↓ 0.0 0 5,484

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

  • One-Time Filter: (pe.personid = '27192'::bpchar)
173. 0.001 0.027 ↑ 1.0 1 1

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

174. 0.011 0.011 ↑ 1.0 1 1

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

  • Index Cond: (personid = '27192'::bpchar)
175. 0.015 0.015 ↑ 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.015..0.015 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
176. 0.000 0.000 ↓ 0.0 0 5,484

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,484)

177. 0.000 0.000 ↓ 0.0 0 5,484

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

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

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

179. 0.001 0.047 ↓ 0.0 0 1

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

180. 0.011 0.011 ↑ 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.011..0.011 rows=1 loops=1)

  • Index Cond: (personid = '27192'::bpchar)
181. 0.004 0.035 ↑ 13.0 1 1

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

  • One-Time Filter: (pe.personid = '27192'::bpchar)
182. 0.031 0.031 ↑ 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.031..0.031 rows=1 loops=1)

  • Index Cond: ((personid = p_13.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
183. 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))
184. 0.000 0.000 ↓ 0.0 0 5,484

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

185. 0.000 0.000 ↓ 0.0 0 5,484

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

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

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

187. 0.002 0.026 ↓ 0.0 0 1

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

188. 0.011 0.011 ↑ 1.0 1 1

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

  • Index Cond: (personid = '27192'::bpchar)
189. 0.003 0.013 ↑ 2.0 1 1

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

  • One-Time Filter: (pe.personid = '27192'::bpchar)
190. 0.010 0.010 ↑ 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.010..0.010 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))
191. 0.000 0.000 ↓ 0.0 0

Index Scan using personemploymentenddate on person_employment p_14 (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))
192. 5.484 6,328.536 ↓ 0.0 0 5,484

Subquery Scan on r_personpeers (cost=36.29..36.34 rows=2 width=180) (actual time=1.154..1.154 rows=0 loops=5,484)

193. 0.000 6,323.052 ↓ 0.0 0 5,484

Unique (cost=36.29..36.32 rows=2 width=232) (actual time=1.153..1.153 rows=0 loops=5,484)

194. 10.968 6,323.052 ↓ 0.0 0 5,484

Sort (cost=36.29..36.29 rows=2 width=232) (actual time=1.153..1.153 rows=0 loops=5,484)

  • Sort Key: mypos.personid, p_15.personid, ('Peer '::character(8)), ('RoleEx_Peer '::character(20)), p_15.companyid, p_15.customerid
  • Sort Method: quicksort Memory: 25kB
195. 5.484 6,312.084 ↓ 0.0 0 5,484

Append (cost=1.59..36.28 rows=2 width=232) (actual time=1.151..1.151 rows=0 loops=5,484)

196. 5.474 6,251.760 ↓ 0.0 0 5,484

Nested Loop (cost=1.59..22.59 rows=1 width=154) (actual time=1.140..1.140 rows=0 loops=5,484)

197. 1,287.072 6,246.276 ↓ 0.0 0 5,484

Nested Loop (cost=1.30..20.27 rows=1 width=26) (actual time=1.139..1.139 rows=0 loops=5,484)

  • Join Filter: (mypos.positionid = manager.topositionid)
  • Rows Removed by Join Filter: 4392
198. 1.113 87.744 ↑ 5.0 1 5,484

Nested Loop (cost=1.00..16.49 rows=5 width=34) (actual time=0.016..0.016 rows=1 loops=5,484)

  • Join Filter: (peers.personid <> mypos.personid)
  • Rows Removed by Join Filter: 0
199. 10.976 49.356 ↑ 1.0 1 5,484

Nested Loop (cost=0.58..4.66 rows=1 width=17) (actual time=0.008..0.009 rows=1 loops=5,484)

200. 27.420 27.420 ↑ 1.0 1 5,484

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

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

Index Scan using pos_pos_topositionid on pos_pos manages (cost=0.29..2.33 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=5,480)

  • Index Cond: ((topositionid = peers.positionid) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: ((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
202. 37.275 37.275 ↑ 7.0 1 5,325

Index Scan using pers_pospersendeff on pers_pos mypos (cost=0.42..11.74 rows=7 width=17) (actual time=0.007..0.007 rows=1 loops=5,325)

  • Index Cond: ((personid = '27192'::bpchar) AND (CURRENT_DATE <= enddate) AND (CURRENT_DATE >= effectivedate))
  • Filter: ((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 2
203. 4,871.460 4,871.460 ↓ 452.4 4,524 5,324

Index Scan using pos_posposendeffendts on pos_pos manager (cost=0.29..0.63 rows=10 width=8) (actual time=0.008..0.915 rows=4,524 loops=5,324)

  • Index Cond: ((positionid = manages.positionid) AND (CURRENT_DATE <= enddate) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_TIMESTAMP <= endts))
  • Filter: (CURRENT_TIMESTAMP >= createts)
  • Rows Removed by Filter: 0
204. 0.010 0.010 ↑ 1.0 1 1

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

  • Index Cond: (personid = pe.personid)
205. 0.000 54.840 ↓ 0.0 0 5,484

Nested Loop (cost=1.17..13.67 rows=1 width=154) (actual time=0.010..0.010 rows=0 loops=5,484)

206. 5.436 54.840 ↓ 0.0 0 5,484

Nested Loop (cost=0.88..11.35 rows=1 width=26) (actual time=0.010..0.010 rows=0 loops=5,484)

207. 5.492 43.872 ↑ 1.0 1 5,484

Nested Loop (cost=0.58..10.97 rows=1 width=17) (actual time=0.008..0.008 rows=1 loops=5,484)

208. 27.420 27.420 ↑ 1.0 1 5,484

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

  • Index Cond: (personid = pe.personid)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
209. 10.960 10.960 ↑ 10.0 1 5,480

Index Scan using pos_posposendeffendts on pos_pos manager_1 (cost=0.29..8.54 rows=10 width=8) (actual time=0.001..0.002 rows=1 loops=5,480)

  • Index Cond: ((positionid = mgrpos.positionid) AND (CURRENT_DATE <= enddate) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_TIMESTAMP <= endts))
  • Filter: (CURRENT_TIMESTAMP >= createts)
  • Rows Removed by Filter: 0
210. 5.532 5.532 ↓ 0.0 0 5,532

Index Scan using pers_pos_positionid_idx on pers_pos mypos_1 (cost=0.29..0.37 rows=1 width=17) (actual time=0.001..0.001 rows=0 loops=5,532)

  • Index Cond: (positionid = manager_1.topositionid)
  • Filter: ((personid = '27192'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 1
211. 0.007 0.007 ↑ 1.0 1 1

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

  • Index Cond: (personid = pe.personid)
212. 0.000 115.164 ↓ 0.0 0 5,484

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

213. 5.484 115.164 ↓ 0.0 0 5,484

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

214. 0.000 60.324 ↓ 0.0 0 5,484

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

215. 5.428 60.324 ↓ 0.0 0 5,484

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

216. 0.318 54.840 ↓ 0.0 0 5,484

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

217. 5.492 43.872 ↑ 1.0 1 5,484

Nested Loop (cost=0.58..4.67 rows=1 width=17) (actual time=0.007..0.008 rows=1 loops=5,484)

218. 27.420 27.420 ↑ 1.0 1 5,484

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,484)

  • 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
219. 10.960 10.960 ↑ 1.0 1 5,480

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

  • 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
220. 10.650 10.650 ↓ 0.0 0 5,325

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

  • 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
221. 0.056 0.056 ↑ 1.0 1 14

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

  • Index Cond: (personid = pe.personid)
222. 0.000 5.484 ↓ 0.0 0 5,484

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,484)

223. 0.000 5.484 ↓ 0.0 0 5,484

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

224. 0.000 5.484 ↓ 0.0 0 5,484

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

225. 5.484 5.484 ↓ 0.0 0 5,484

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

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

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

  • Join Filter: (p_18.personid <> pp_9.personid)
227. 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)
228. 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)
229. 0.000 0.000 ↓ 0.0 0

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

230. 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)
231. 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
232. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (personid = '27192'::bpchar)
  • Heap Fetches: 0
233. 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))
234. 0.000 43.872 ↓ 0.0 0 5,484

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,484)

235. 0.000 43.872 ↓ 0.0 0 5,484

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

236. 5.484 43.872 ↓ 0.0 0 5,484

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

237. 5.488 38.388 ↓ 0.0 0 5,484

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

238. 27.420 27.420 ↑ 1.0 1 5,484

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,484)

  • 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
239. 5.480 5.480 ↓ 0.0 0 5,480

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

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

Index Scan using pers_pos_positionid_idx on pers_pos p_19 (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))
241. 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)
242. 5.484 241.296 ↓ 0.0 0 5,484

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

243. 5.484 235.812 ↓ 0.0 0 5,484

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

244. 0.000 71.292 ↓ 0.0 0 5,484

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,484)

245. 5.466 71.292 ↓ 0.0 0 5,484

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

246. 0.000 65.808 ↓ 0.0 0 5,484

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

247. 0.396 65.808 ↓ 0.0 0 5,484

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

248. 5.802 54.840 ↑ 1.0 1 5,484

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

249. 5.487 38.388 ↑ 1.0 1 5,484

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

250. 27.420 27.420 ↑ 1.0 1 5,484

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

  • 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
251. 5.481 5.481 ↑ 1.0 1 5,481

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,481)

  • 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
252. 10.650 10.650 ↑ 1.0 1 5,325

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,325)

  • 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
253. 10.572 10.572 ↓ 0.0 0 5,286

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,286)

  • 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
254. 0.090 0.090 ↑ 1.0 1 18

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

  • Index Cond: (personid = pe.personid)
255. 0.018 0.018 ↑ 1.0 2 18

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

256. 0.000 0.000 ↑ 1.0 1 18

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

257. 0.000 0.000 ↑ 1.0 1 18

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

258. 0.000 82.260 ↓ 0.0 0 5,484

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,484)

259. 0.000 82.260 ↓ 0.0 0 5,484

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

260. 0.000 82.260 ↓ 0.0 0 5,484

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

261. 6.016 82.260 ↓ 0.0 0 5,484

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

262. 5.880 65.808 ↑ 1.0 1 5,484

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

263. 5.643 49.356 ↑ 1.0 1 5,484

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

264. 5.487 38.388 ↑ 1.0 1 5,484

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

265. 27.420 27.420 ↑ 1.0 1 5,484

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,484)

  • 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
266. 5.481 5.481 ↑ 1.0 1 5,481

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,481)

  • 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
267. 5.325 5.325 ↑ 1.0 1 5,325

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,325)

  • 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
268. 10.572 10.572 ↑ 1.0 1 5,286

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,286)

  • 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
269. 10.436 10.436 ↓ 0.0 0 5,218

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

  • 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
270. 0.055 0.055 ↑ 1.0 1 11

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

  • Index Cond: (personid = pe.personid)
271. 0.011 0.011 ↑ 1.0 2 11

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

272. 0.000 0.000 ↑ 1.0 1 11

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

273. 0.000 0.000 ↑ 1.0 1 11

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

274. 0.000 76.776 ↓ 0.0 0 5,484

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,484)

275. 0.000 76.776 ↓ 0.0 0 5,484

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

276. 0.000 76.776 ↓ 0.0 0 5,484

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

277. 4.752 76.776 ↓ 0.0 0 5,484

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

278. 5.750 71.292 ↓ 0.0 0 5,484

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

279. 5.682 60.324 ↑ 1.0 1 5,484

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

280. 5.643 49.356 ↑ 1.0 1 5,484

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

281. 5.487 38.388 ↑ 1.0 1 5,484

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

282. 27.420 27.420 ↑ 1.0 1 5,484

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,484)

  • 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
283. 5.481 5.481 ↑ 1.0 1 5,481

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,481)

  • 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
284. 5.325 5.325 ↑ 1.0 1 5,325

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,325)

  • 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
285. 5.286 5.286 ↑ 1.0 1 5,286

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,286)

  • 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
286. 5.218 5.218 ↓ 0.0 0 5,218

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,218)

  • 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
287. 0.732 0.732 ↓ 0.0 0 244

Index Scan using pers_pos_positionid_idx on pers_pos p_22 (cost=0.29..0.37 rows=1 width=17) (actual time=0.003..0.003 rows=0 loops=244)

  • 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
288. 0.016 0.016 ↑ 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.008..0.008 rows=1 loops=2)

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

290. 0.002 0.002 ↑ 1.0 1 2

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

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

292. 0.000 49.356 ↓ 0.0 0 5,484

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

293. 0.000 49.356 ↓ 0.0 0 5,484

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

294. 49.356 49.356 ↓ 0.0 0 5,484

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.009..0.009 rows=0 loops=5,484)

  • Index Cond: ((name_)::text = 'originatorID'::text)
  • Filter: ((text_)::character(12) = '27192'::bpchar)
  • Rows Removed by Filter: 6
295. 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
296. 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)
297. 0.000 49.356 ↓ 0.0 0 5,484

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

298. 0.000 49.356 ↓ 0.0 0 5,484

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

299. 5.484 49.356 ↓ 0.0 0 5,484

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

300. 0.000 43.872 ↓ 0.0 0 5,484

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

301. 27.420 27.420 ↑ 1.0 1 5,484

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,484)

  • Index Cond: (personid = '27192'::bpchar)
  • Heap Fetches: 5484
302. 16.452 16.452 ↓ 0.0 0 5,484

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,484)

  • Index Cond: ((personid = '27192'::bpchar) AND (rolename = 'Onboard'::bpchar))
  • Heap Fetches: 0
303. 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))
304. 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)
305. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (personid = pe.personid)
306. 16.452 109.680 ↑ 1.0 18 5,484

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

307. 27.420 27.420 ↑ 1.0 1 5,484

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

  • Index Cond: (personid = pe.personid)
308. 65.808 65.808 ↑ 1.0 18 5,484

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,484)

  • Index Cond: (personid = '27192'::bpchar)
  • Heap Fetches: 98712
309. 5.484 1,793.268 ↑ 1.0 1 5,484

Subquery Scan on *SELECT* 13 (cost=1.12..22.86 rows=1 width=98) (actual time=0.106..0.327 rows=1 loops=5,484)

310. 5.476 1,787.784 ↑ 1.0 1 5,484

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

311. 10.342 1,760.364 ↑ 1.0 1 5,484

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

312. 32.904 32.904 ↑ 1.0 1 5,484

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

  • 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
313. 1,717.118 1,717.118 ↑ 1.0 1 5,486

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

  • 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
314. 21.944 21.944 ↑ 1.0 1 5,486

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

  • Index Cond: (personid = pe.personid)
315. 0.000 10.968 ↓ 0.0 0 5,484

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

  • Join Filter: (pcr_3.personcustomerreltype = pcrt_2.personcustomerreltype)
316. 0.000 10.968 ↓ 0.0 0 5,484

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

317. 0.000 10.968 ↓ 0.0 0 5,484

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

  • Join Filter: (cs.companyid = pe_12.companyid)
318. 0.000 10.968 ↓ 0.0 0 5,484

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

319. 10.968 10.968 ↓ 0.0 0 5,484

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,484)

  • Index Cond: (personid = '27192'::bpchar)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
320. 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))
321. 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)))
322. 0.000 0.000 ↓ 0.0 0

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

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

324. 32.904 32.904 ↑ 1.0 1 5,484

Index Scan using person_compensation_pkey on person_compensation pd (cost=0.41..0.87 rows=1 width=13) (actual time=0.006..0.006 rows=1 loops=5,484)

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

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

  • 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
326. 0.000 0.000 ↓ 3.0 3 5,429

Materialize (cost=0.28..3.32 rows=1 width=78) (actual time=0.000..0.000 rows=3 loops=5,429)

327. 0.003 0.018 ↓ 3.0 3 1

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

328. 0.006 0.006 ↓ 3.0 3 1

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

329. 0.009 0.009 ↑ 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.003..0.003 rows=1 loops=3)

  • Index Cond: (documentid = pi.documentid)
Planning time : 253.535 ms
Execution time : 9,988.603 ms