explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hDbo : No Peers

Settings
# exclusive inclusive rows x rows loops node
1. 22.462 6,357.730 ↑ 13.5 5,429 1

Sort (cost=2,325,120.90..2,325,304.17 rows=73,308 width=84) (actual time=6,357.139..6,357.730 rows=5,429 loops=1)

  • Sort Key: (btrim((pn.lname)::text))
  • Sort Method: quicksort Memory: 618kB
2. 10.527 6,335.268 ↑ 13.5 5,429 1

Nested Loop Left Join (cost=1.41..2,319,196.99 rows=73,308 width=84) (actual time=1.882..6,335.268 rows=5,429 loops=1)

  • Join Filter: (pn.personid = pi.personid)
  • Rows Removed by Join Filter: 16286
3. 8.702 6,319.312 ↑ 13.2 5,429 1

Nested Loop (cost=1.12..2,317,938.52 rows=71,459 width=39) (actual time=1.846..6,319.312 rows=5,429 loops=1)

  • Join Filter: (pe.personid = pn.personid)
4. 6.730 6,256.310 ↓ 3.8 5,430 1

Nested Loop Semi Join (cost=0.83..2,317,358.91 rows=1,422 width=26) (actual time=1.808..6,256.310 rows=5,430 loops=1)

5. 14.272 6,189.256 ↓ 2.8 5,484 1

Index Scan using employmentcompanyideffdt on person_employment pe (cost=0.42..2,315,789.59 rows=1,983 width=13) (actual time=1.755..6,189.256 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. 38.388 6,174.984 ↑ 27.0 1 5,484

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

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

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

9. 0.000 49.356 ↓ 0.0 0 5,484

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

10. 5.484 49.356 ↓ 0.0 0 5,484

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

11. 43.872 43.872 ↓ 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.008..0.008 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. 16.452 246.780 ↑ 1.7 15 5,484

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

14. 27.420 230.328 ↑ 1.7 15 5,484

Merge Anti Join (cost=2.87..26.20 rows=26 width=261) (actual time=0.029..0.042 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. 65.808 148.068 ↑ 1.7 15 5,484

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

16. 82.260 82.260 ↑ 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.011..0.015 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. 16.452 16.452 ↑ 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.003..0.003 rows=1 loops=5,484)

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

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

  • Sort Key: sc3_1.rolename
  • Sort Method: quicksort Memory: 25kB
20. 38.388 38.388 ↓ 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.007..0.007 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 5,829.492 ↑ 15.7 3 5,484

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
22. 10.968 5,818.524 ↑ 15.7 3 5,484

Subquery Scan on rpa (cost=346.85..347.79 rows=47 width=32) (actual time=1.060..1.061 rows=3 loops=5,484)

23. 98.712 5,807.556 ↑ 15.7 3 5,484

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

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

Append (cost=0.98..346.14 rows=47 width=176) (actual time=0.110..1.041 rows=20 loops=5,484)

25. 0.000 27.420 ↓ 0.0 0 5,484

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

26. 5.484 27.420 ↓ 0.0 0 5,484

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

27. 21.936 21.936 ↓ 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.004..0.004 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 570.336 ↑ 2.0 1 5,484

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

31. 5.484 564.852 ↑ 2.0 1 5,484

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

32. 21.936 559.368 ↑ 2.0 1 5,484

Sort (cost=19.51..19.52 rows=2 width=148) (actual time=0.102..0.102 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 537.432 ↑ 2.0 1 5,484

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

34. 10.800 230.328 ↑ 1.0 1 5,484

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

35. 10.905 175.488 ↑ 1.0 1 5,484

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

36. 5.442 148.068 ↑ 1.0 1 5,484

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

37. 10.716 131.616 ↑ 1.0 1 5,484

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

38. 54.840 54.840 ↑ 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.009..0.010 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. 66.060 66.060 ↑ 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.010..0.012 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. 11.010 11.010 ↑ 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.002..0.002 rows=1 loops=5,505)

  • Index Cond: (personcompanyreltype = pcr.personcompanyreltype)
41. 16.515 16.515 ↑ 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.003..0.003 rows=1 loops=5,505)

  • Index Cond: (rolename = pcrt.rolename)
  • Heap Fetches: 5505
42. 44.040 44.040 ↑ 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.008..0.008 rows=1 loops=5,505)

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

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

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

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

45. 5.492 180.972 ↑ 1.0 1 5,484

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

46. 5.492 164.520 ↑ 1.0 1 5,484

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

47. 11.001 148.068 ↑ 1.0 1 5,484

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

48. 5.496 76.776 ↑ 1.0 1 5,484

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

49. 49.356 49.356 ↑ 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.008..0.009 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. 21.924 21.924 ↑ 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.004..0.004 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. 60.291 60.291 ↑ 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.009..0.011 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. 10.960 10.960 ↑ 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.002..0.002 rows=1 loops=5,480)

  • Index Cond: (personcompanyreltype = pcr_1.personcompanyreltype)
53. 10.960 10.960 ↑ 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.002..0.002 rows=1 loops=5,480)

  • Index Cond: (rolename = pcrt_1.rolename)
  • Heap Fetches: 5480
54. 43.840 43.840 ↑ 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.008..0.008 rows=1 loops=5,480)

  • Index Cond: (personid = pe.personid)
55. 54.800 54.800 ↑ 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.010..0.010 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 191.940 ↓ 0.0 0 5,484

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

57. 10.968 186.456 ↓ 0.0 0 5,484

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

58. 0.000 87.744 ↓ 0.0 0 5,484

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

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

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

60. 5.484 87.744 ↓ 0.0 0 5,484

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

61. 0.000 82.260 ↓ 0.0 0 5,484

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

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

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

63. 49.356 49.356 ↑ 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.009..0.009 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. 27.330 27.330 ↓ 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.005..0.005 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. 0.000 38.388 ↓ 0.0 0 5,484

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

70. 0.000 38.388 ↓ 0.0 0 5,484

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

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

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

72. 0.000 32.904 ↓ 0.0 0 5,484

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

73. 0.000 32.904 ↓ 0.0 0 5,484

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

  • Join Filter: (plr_1.personlocationreltype = plrt_1.personlocationreltype)
74. 32.904 32.904 ↓ 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.006..0.006 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. 0.000 49.356 ↓ 0.0 0 5,484

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

81. 5.484 49.356 ↓ 0.0 0 5,484

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

82. 0.000 43.872 ↓ 0.0 0 5,484

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

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

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

84. 43.872 43.872 ↓ 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.008..0.008 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.045 0.045 ↓ 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.009..0.009 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. 5.484 378.396 ↓ 0.0 0 5,484

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

90. 10.968 372.912 ↓ 0.0 0 5,484

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

91. 0.000 126.132 ↓ 0.0 0 5,484

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

92. 0.000 126.132 ↓ 0.0 0 5,484

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

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

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

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

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

95. 49.356 49.356 ↑ 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.009..0.009 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. 27.405 27.405 ↑ 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.005..0.005 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. 32.646 32.646 ↓ 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.006..0.006 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. 5.484 65.808 ↓ 0.0 0 5,484

Nested Loop (cost=2.26..17.51 rows=1 width=109) (actual time=0.012..0.012 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 60.324 ↓ 0.0 0 5,484

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

102. 0.000 60.324 ↓ 0.0 0 5,484

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

103. 5.484 60.324 ↓ 0.0 0 5,484

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

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

Nested Loop (cost=1.26..14.31 rows=1 width=121) (actual time=0.010..0.010 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 54.840 ↓ 0.0 0 5,484

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

106. 49.356 49.356 ↓ 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.009..0.009 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 93.228 ↓ 0.0 0 5,484

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

118. 0.000 93.228 ↓ 0.0 0 5,484

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

119. 5.484 93.228 ↓ 0.0 0 5,484

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

120. 10.956 87.744 ↓ 0.0 0 5,484

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

121. 43.872 43.872 ↑ 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.008..0.008 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. 0.000 32.916 ↓ 0.0 0 5,486

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

123. 0.000 32.916 ↓ 0.0 0 5,486

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

124. 5.486 32.916 ↓ 0.0 0 5,486

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

  • Join Filter: (por.personorganizationreltype = port_2.personorganizationreltype)
125. 27.430 27.430 ↓ 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.005..0.005 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 76.776 ↓ 0.0 0 5,484

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

133. 5.484 76.776 ↓ 0.0 0 5,484

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

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

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

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

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

136. 43.872 43.872 ↑ 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.008..0.008 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. 21.960 21.960 ↓ 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.004..0.004 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.048 0.048 ↓ 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.006..0.006 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. 5.484 175.488 ↓ 0.0 0 5,484

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

142. 0.000 170.004 ↓ 0.0 0 5,484

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

143. 5.484 120.648 ↓ 0.0 0 5,484

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

144. 5.484 115.164 ↓ 0.0 0 5,484

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

145. 0.000 109.680 ↓ 0.0 0 5,484

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

146. 5.484 109.680 ↓ 0.0 0 5,484

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

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

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

148. 11.082 76.776 ↑ 1.0 1 5,484

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

149. 49.356 49.356 ↑ 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.009..0.009 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. 16.338 16.338 ↑ 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.003..0.003 rows=1 loops=5,446)

  • Index Cond: (payunitid = ep.payunitid)
  • Heap Fetches: 5446
151. 27.230 27.230 ↓ 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.005..0.005 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 49.356 ↓ 0.0 0 5,484

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

156. 5.484 49.356 ↓ 0.0 0 5,484

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

157. 10.968 43.872 ↓ 0.0 0 5,484

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

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

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

159. 0.000 27.420 ↓ 0.0 0 5,484

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

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

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

161. 0.000 21.936 ↓ 0.0 0 5,484

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

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

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

163. 21.936 21.936 ↓ 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.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))
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 16.452 ↓ 0.0 0 5,484

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

170. 5.484 16.452 ↓ 0.0 0 5,484

Append (cost=0.71..74.56 rows=3 width=70) (actual time=0.003..0.003 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.002 0.051 ↑ 1.0 1 1

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

174. 0.023 0.023 ↑ 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.023..0.023 rows=1 loops=1)

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

Subquery Scan on *SELECT* 2_2 (cost=1.00..17.69 rows=1 width=70) (actual time=0.001..0.001 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.002 0.089 ↓ 0.0 0 1

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

179. 0.000 0.087 ↓ 0.0 0 1

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

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

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

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

  • One-Time Filter: (pe.personid = '27192'::bpchar)
182. 0.069 0.069 ↑ 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.069..0.069 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.001 0.031 ↓ 0.0 0 1

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

187. 0.002 0.030 ↓ 0.0 0 1

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

188. 0.012 0.012 ↑ 1.0 1 1

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

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

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

  • One-Time Filter: (pe.personid = '27192'::bpchar)
190. 0.013 0.013 ↑ 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.013..0.013 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. 0.000 0.000 ↓ 0.0 0 5,484

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

  • One-Time Filter: false
193. 0.000 197.424 ↓ 0.0 0 5,484

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

194. 5.484 197.424 ↓ 0.0 0 5,484

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

195. 5.484 104.196 ↓ 0.0 0 5,484

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

196. 0.000 98.712 ↓ 0.0 0 5,484

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

197. 0.636 98.712 ↓ 0.0 0 5,484

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

198. 10.984 76.776 ↑ 1.0 1 5,484

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

199. 43.872 43.872 ↑ 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.008..0.008 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
200. 21.920 21.920 ↑ 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.003..0.004 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
201. 21.300 21.300 ↓ 0.0 0 5,325

Index Scan using pers_pos_positionid_idx on pers_pos p_15 (cost=0.29..0.37 rows=1 width=17) (actual time=0.004..0.004 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
202. 0.112 0.112 ↑ 1.0 1 14

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

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

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

204. 5.484 10.968 ↓ 0.0 0 5,484

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

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

206. 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))
207. 0.000 0.000 ↓ 0.0 0

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

  • Join Filter: (p_16.personid <> pp_9.personid)
208. 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)
209. 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)
210. 0.000 0.000 ↓ 0.0 0

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

211. 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)
212. 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
213. 0.000 0.000 ↓ 0.0 0

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

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

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

216. 0.000 76.776 ↓ 0.0 0 5,484

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

217. 5.484 76.776 ↓ 0.0 0 5,484

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

218. 5.496 71.292 ↓ 0.0 0 5,484

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

219. 49.356 49.356 ↑ 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.009..0.009 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
220. 16.440 16.440 ↓ 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.003..0.003 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
221. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pos_positionid_idx on pers_pos p_17 (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))
222. 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)
223. 5.484 405.816 ↓ 0.0 0 5,484

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

224. 5.484 400.332 ↓ 0.0 0 5,484

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

225. 0.000 115.164 ↓ 0.0 0 5,484

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

226. 5.466 115.164 ↓ 0.0 0 5,484

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

227. 0.000 109.680 ↓ 0.0 0 5,484

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

228. 6.078 109.680 ↓ 0.0 0 5,484

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

229. 5.961 87.744 ↑ 1.0 1 5,484

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

230. 10.974 65.808 ↑ 1.0 1 5,484

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

231. 43.872 43.872 ↑ 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.008..0.008 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
232. 10.962 10.962 ↑ 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.002..0.002 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
233. 15.975 15.975 ↑ 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.003..0.003 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
234. 15.858 15.858 ↓ 0.0 0 5,286

Index Scan using pers_pos_positionid_idx on pers_pos p_18 (cost=0.29..0.37 rows=1 width=17) (actual time=0.003..0.003 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
235. 0.144 0.144 ↑ 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.008..0.008 rows=1 loops=18)

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

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

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

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

239. 5.484 142.584 ↓ 0.0 0 5,484

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

240. 5.473 137.100 ↓ 0.0 0 5,484

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

241. 0.000 131.616 ↓ 0.0 0 5,484

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

242. 1.064 131.616 ↓ 0.0 0 5,484

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

243. 6.078 109.680 ↑ 1.0 1 5,484

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

244. 11.286 87.744 ↑ 1.0 1 5,484

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

245. 10.974 65.808 ↑ 1.0 1 5,484

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

246. 43.872 43.872 ↑ 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.007..0.008 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
247. 10.962 10.962 ↑ 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.002..0.002 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
248. 10.650 10.650 ↑ 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.002..0.002 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
249. 15.858 15.858 ↑ 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.003..0.003 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
250. 20.872 20.872 ↓ 0.0 0 5,218

Index Scan using pers_pos_positionid_idx on pers_pos p_19 (cost=0.29..0.37 rows=1 width=17) (actual time=0.004..0.004 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
251. 0.088 0.088 ↑ 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.008..0.008 rows=1 loops=11)

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

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

253. 0.011 0.011 ↑ 1.0 1 11

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

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

255. 0.000 137.100 ↓ 0.0 0 5,484

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

256. 0.000 137.100 ↓ 0.0 0 5,484

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

257. 5.462 137.100 ↓ 0.0 0 5,484

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

258. 0.116 131.616 ↓ 0.0 0 5,484

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

259. 6.016 126.132 ↓ 0.0 0 5,484

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

260. 5.880 109.680 ↑ 1.0 1 5,484

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

261. 5.961 93.228 ↑ 1.0 1 5,484

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

262. 5.493 71.292 ↑ 1.0 1 5,484

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

263. 49.356 49.356 ↑ 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.008..0.009 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
264. 16.443 16.443 ↑ 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.003..0.003 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
265. 15.975 15.975 ↑ 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.002..0.003 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
266. 10.572 10.572 ↑ 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.002..0.002 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
267. 10.436 10.436 ↓ 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.002..0.002 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
268. 5.368 5.368 ↓ 0.0 0 244

Index Scan using pers_pos_positionid_idx on pers_pos p_20 (cost=0.29..0.37 rows=1 width=17) (actual time=0.022..0.022 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
269. 0.022 0.022 ↑ 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.011..0.011 rows=1 loops=2)

  • Index Cond: (personid = pe.personid)
270. 0.002 0.004 ↑ 1.0 2 2

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

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

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

273. 0.000 82.260 ↓ 0.0 0 5,484

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

274. 5.484 82.260 ↓ 0.0 0 5,484

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

275. 76.776 76.776 ↓ 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.014..0.014 rows=0 loops=5,484)

  • Index Cond: ((name_)::text = 'originatorID'::text)
  • Filter: ((text_)::character(12) = '27192'::bpchar)
  • Rows Removed by Filter: 6
276. 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
277. 0.000 0.000 ↓ 0.0 0

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

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

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

279. 5.484 76.776 ↓ 0.0 0 5,484

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

280. 0.000 71.292 ↓ 0.0 0 5,484

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

281. 5.484 71.292 ↓ 0.0 0 5,484

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

282. 43.872 43.872 ↑ 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.008..0.008 rows=1 loops=5,484)

  • Index Cond: (personid = '27192'::bpchar)
  • Heap Fetches: 5484
283. 21.936 21.936 ↓ 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.004..0.004 rows=0 loops=5,484)

  • Index Cond: ((personid = '27192'::bpchar) AND (rolename = 'Onboard'::bpchar))
  • Heap Fetches: 0
284. 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))
285. 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)
286. 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)
287. 21.936 180.972 ↑ 1.0 18 5,484

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

288. 43.872 43.872 ↑ 1.0 1 5,484

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

  • Index Cond: (personid = pe.personid)
289. 115.164 115.164 ↑ 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.011..0.021 rows=18 loops=5,484)

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

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

291. 10.952 3,328.788 ↑ 1.0 1 5,484

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

292. 9.796 3,273.948 ↑ 1.0 1 5,484

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

293. 49.356 49.356 ↑ 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.009..0.009 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
294. 3,214.796 3,214.796 ↑ 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.164..0.586 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
295. 43.888 43.888 ↑ 1.0 1 5,486

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

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

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

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

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

298. 5.484 21.936 ↓ 0.0 0 5,484

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

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

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

300. 16.452 16.452 ↓ 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.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))
301. 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))
302. 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)))
303. 0.000 0.000 ↓ 0.0 0

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

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

305. 60.324 60.324 ↑ 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.011..0.011 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
306. 54.300 54.300 ↑ 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.010..0.010 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
307. 5.403 5.429 ↓ 3.0 3 5,429

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

308. 0.002 0.026 ↓ 3.0 3 1

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

309. 0.009 0.009 ↓ 3.0 3 1

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

310. 0.015 0.015 ↑ 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.005 rows=1 loops=3)

  • Index Cond: (documentid = pi.documentid)
Planning time : 417.728 ms
Execution time : 6,361.105 ms