explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Supn

Settings
# exclusive inclusive rows x rows loops node
1. 0.067 3,997.863 ↑ 1.0 200 1

Limit (cost=6,074,789.09..6,074,789.59 rows=200 width=85) (actual time=3,997.785..3,997.863 rows=200 loops=1)

2. 17.023 3,997.796 ↑ 413.3 200 1

Sort (cost=6,074,789.09..6,074,995.76 rows=82,667 width=85) (actual time=3,997.785..3,997.796 rows=200 loops=1)

  • Sort Key: (btrim((pn.lname)::text))
  • Sort Method: top-N heapsort Memory: 53kB
3. 4.492 3,980.773 ↑ 15.2 5,432 1

Hash Left Join (cost=523.33..6,071,216.28 rows=82,667 width=85) (actual time=7.416..3,980.773 rows=5,432 loops=1)

  • Hash Cond: (pi.documentid = dc.documentid)
4. 2.329 3,974.066 ↑ 14.8 5,432 1

Nested Loop Left Join (cost=1.27..6,068,454.30 rows=80,440 width=30) (actual time=5.194..3,974.066 rows=5,432 loops=1)

5. 4.316 3,955.441 ↑ 14.8 5,432 1

Nested Loop (cost=1.12..6,045,185.89 rows=80,440 width=39) (actual time=5.188..3,955.441 rows=5,432 loops=1)

  • Join Filter: (pe.personid = pn.personid)
6. 5.129 3,880.496 ↓ 3.4 5,433 1

Nested Loop Semi Join (cost=0.83..6,044,228.59 rows=1,591 width=26) (actual time=5.170..3,880.496 rows=5,433 loops=1)

7. 12.519 3,804.036 ↓ 2.8 5,487 1

Index Scan using employmentcompanyideffdt on person_employment pe (cost=0.42..6,040,168.32 rows=1,980 width=13) (actual time=5.139..3,804.036 rows=5,487 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: 1657
8.          

SubPlan (for Index Scan)

9. 27.435 3,791.517 ↑ 25.0 1 5,487

Hash Join (cost=915.38..950.02 rows=25 width=0) (actual time=0.691..0.691 rows=1 loops=5,487)

  • Hash Cond: ("*SELECT* 1".rolename = rpa.rolename)
10. 16.461 301.785 ↑ 1.7 15 5,487

Append (cost=0.69..34.98 rows=25 width=9) (actual time=0.042..0.055 rows=15 loops=5,487)

11. 0.000 54.870 ↓ 0.0 0 5,487

Subquery Scan on *SELECT* 1 (cost=0.69..12.79 rows=1 width=9) (actual time=0.010..0.010 rows=0 loops=5,487)

12. 0.000 54.870 ↓ 0.0 0 5,487

Nested Loop Anti Join (cost=0.69..12.78 rows=1 width=261) (actual time=0.010..0.010 rows=0 loops=5,487)

13. 54.870 54.870 ↓ 0.0 0 5,487

Index Scan using pk_company_security_control on company_security_control sc1 (cost=0.28..8.34 rows=1 width=32) (actual time=0.010..0.010 rows=0 loops=5,487)

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

Index Only Scan using security_control_pkey1 on security_control sc3 (cost=0.41..4.44 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
15. 10.974 230.454 ↑ 1.6 15 5,487

Subquery Scan on *SELECT* 2 (cost=8.99..22.19 rows=24 width=9) (actual time=0.031..0.042 rows=15 loops=5,487)

16. 16.461 219.480 ↑ 1.6 15 5,487

Merge Anti Join (cost=8.99..21.95 rows=24 width=261) (actual time=0.031..0.040 rows=15 loops=5,487)

  • 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))
17. 54.870 148.149 ↑ 1.7 15 5,487

Nested Loop (cost=0.68..13.55 rows=26 width=35) (actual time=0.019..0.027 rows=15 loops=5,487)

18. 93.279 93.279 ↑ 1.7 15 5,487

Index Only Scan using security_control_pkey1 on security_control sc2 (cost=0.41..4.93 rows=26 width=31) (actual time=0.015..0.017 rows=15 loops=5,487)

  • Index Cond: ((domainobject = 'PersonCompensationItem'::text) AND (action = 'Read'::text))
  • Heap Fetches: 0
19. 0.000 0.000 ↑ 1.0 1 82,165

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

20. 10.974 10.974 ↑ 1.0 1 5,487

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

  • Index Cond: (companyid = pe.companyid)
  • Heap Fetches: 5487
21. 16.461 54.870 ↓ 0.0 0 5,487

Sort (cost=8.31..8.32 rows=1 width=36) (actual time=0.010..0.010 rows=0 loops=5,487)

  • Sort Key: sc3_1.rolename
  • Sort Method: quicksort Memory: 25kB
22. 38.409 38.409 ↓ 0.0 0 5,487

Index Scan using idx_csc_neg_do_act on company_security_control sc3_1 (cost=0.28..8.30 rows=1 width=36) (actual time=0.007..0.007 rows=0 loops=5,487)

  • Index Cond: ((negative = true) AND ((domainobject)::text = 'PersonCompensationItem'::text) AND ((action)::text = 'Read'::text) AND (companyid = pe.companyid))
  • Filter: negative
23. 16.461 3,462.297 ↑ 16.7 3 5,487

Hash (cost=914.07..914.07 rows=50 width=32) (actual time=0.631..0.631 rows=3 loops=5,487)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
24. 5.487 3,445.836 ↑ 16.7 3 5,487

Subquery Scan on rpa (cost=913.07..914.07 rows=50 width=32) (actual time=0.627..0.628 rows=3 loops=5,487)

25. 65.844 3,440.349 ↑ 16.7 3 5,487

HashAggregate (cost=913.07..913.57 rows=50 width=176) (actual time=0.627..0.627 rows=3 loops=5,487)

  • Group Key: ar.personid, p.personid, ar.rolename, (''::text), p.companyid, p.customerid
26. 27.435 3,374.505 ↑ 2.5 20 5,487

Append (cost=0.83..912.32 rows=50 width=176) (actual time=0.137..0.615 rows=20 loops=5,487)

27. 16.461 98.766 ↓ 0.0 0 5,487

Nested Loop (cost=0.83..21.51 rows=1 width=75) (actual time=0.018..0.018 rows=0 loops=5,487)

28. 0.000 82.305 ↓ 0.0 0 5,487

Nested Loop (cost=0.42..13.06 rows=1 width=35) (actual time=0.015..0.015 rows=0 loops=5,487)

29. 82.305 82.305 ↓ 0.0 0 5,487

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

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

Index Scan using personemploymentenddate on person_employment pe_1 (cost=0.42..8.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)))
31. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (personid = pe.personid)
32. 5.487 658.440 ↑ 2.0 1 5,487

Subquery Scan on r_personcompanyroles (cost=63.64..63.69 rows=2 width=180) (actual time=0.119..0.120 rows=1 loops=5,487)

33. 5.487 652.953 ↑ 2.0 1 5,487

Unique (cost=63.64..63.67 rows=2 width=148) (actual time=0.119..0.119 rows=1 loops=5,487)

34. 21.948 647.466 ↑ 2.0 1 5,487

Sort (cost=63.64..63.65 rows=2 width=148) (actual time=0.118..0.118 rows=1 loops=5,487)

  • Sort Key: pcr.personid, p_1.personid, wr.rolename, p_1.companyid, p_1.customerid
  • Sort Method: quicksort Memory: 25kB
35. 5.487 625.518 ↑ 2.0 1 5,487

Append (cost=1.25..63.63 rows=2 width=148) (actual time=0.048..0.114 rows=1 loops=5,487)

36. 5.235 274.350 ↑ 1.0 1 5,487

Nested Loop (cost=1.25..27.46 rows=1 width=43) (actual time=0.047..0.050 rows=1 loops=5,487)

37. 10.869 203.019 ↑ 1.0 1 5,487

Nested Loop (cost=0.84..19.02 rows=1 width=35) (actual time=0.034..0.037 rows=1 loops=5,487)

38. 16.440 164.610 ↑ 1.0 1 5,487

Nested Loop (cost=0.70..18.21 rows=1 width=62) (actual time=0.028..0.030 rows=1 loops=5,487)

  • Join Filter: (pcr.personcompanyreltype = pcrt.personcompanyreltype)
39. 5.256 142.662 ↑ 1.0 1 5,487

Nested Loop (cost=0.70..16.78 rows=1 width=32) (actual time=0.024..0.026 rows=1 loops=5,487)

40. 76.818 76.818 ↑ 1.0 1 5,487

Index Scan using personemploymentenddate on person_employment pe_2 (cost=0.42..8.45 rows=1 width=17) (actual time=0.013..0.014 rows=1 loops=5,487)

  • 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
41. 60.588 60.588 ↑ 1.0 1 5,508

Index Scan using personcompanybycompany on person_company_rel pcr (cost=0.28..8.32 rows=1 width=23) (actual time=0.009..0.011 rows=1 loops=5,508)

  • 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
42. 5.508 5.508 ↑ 19.0 1 5,508

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

43. 27.540 27.540 ↑ 1.0 1 5,508

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

  • Index Cond: (rolename = pcrt.rolename)
  • Heap Fetches: 5508
44. 66.096 66.096 ↑ 1.0 1 5,508

Index Scan using person_pkey on person p_1 (cost=0.41..8.43 rows=1 width=21) (actual time=0.012..0.012 rows=1 loops=5,508)

  • Index Cond: (personid = pe.personid)
45. 5.526 345.681 ↓ 0.0 0 5,487

Nested Loop Anti Join (cost=1.83..36.15 rows=1 width=43) (actual time=0.063..0.063 rows=0 loops=5,487)

  • Join Filter: (pe_3.personid = pp.personid)
46. 5.523 268.863 ↑ 1.0 1 5,487

Nested Loop (cost=1.42..27.69 rows=1 width=43) (actual time=0.046..0.049 rows=1 loops=5,487)

47. 0.015 197.532 ↑ 1.0 1 5,487

Nested Loop (cost=1.00..19.25 rows=1 width=35) (actual time=0.034..0.036 rows=1 loops=5,487)

48. 16.464 170.097 ↑ 1.0 1 5,487

Nested Loop (cost=0.86..18.44 rows=1 width=62) (actual time=0.028..0.031 rows=1 loops=5,487)

  • Join Filter: (pcr_1.personcompanyreltype = pcrt_1.personcompanyreltype)
49. 5.507 148.149 ↑ 1.0 1 5,487

Nested Loop (cost=0.86..17.01 rows=1 width=32) (actual time=0.025..0.027 rows=1 loops=5,487)

50. 5.493 87.792 ↑ 1.0 1 5,487

Nested Loop (cost=0.58..16.66 rows=1 width=17) (actual time=0.016..0.016 rows=1 loops=5,487)

51. 65.844 65.844 ↑ 1.0 1 5,487

Index Scan using pers_pos_personid_idx on pers_pos pp (cost=0.29..8.32 rows=1 width=17) (actual time=0.012..0.012 rows=1 loops=5,487)

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

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

  • 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
53. 54.850 54.850 ↑ 1.0 1 5,485

Index Scan using personcompanybycompany on person_company_rel pcr_1 (cost=0.28..0.34 rows=1 width=23) (actual time=0.009..0.010 rows=1 loops=5,485)

  • 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
54. 5.484 5.484 ↑ 19.0 1 5,484

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

55. 27.420 27.420 ↑ 1.0 1 5,484

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

  • Index Cond: (rolename = pcrt_1.rolename)
  • Heap Fetches: 5484
56. 65.808 65.808 ↑ 1.0 1 5,484

Index Scan using person_pkey on person p_2 (cost=0.41..8.43 rows=1 width=21) (actual time=0.011..0.012 rows=1 loops=5,484)

  • Index Cond: (personid = pe.personid)
57. 71.292 71.292 ↑ 1.0 1 5,484

Index Scan using personemploymentenddate on person_employment pe_3 (cost=0.42..8.45 rows=1 width=13) (actual time=0.013..0.013 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
58. 0.000 263.376 ↓ 0.0 0 5,487

Result (cost=2.38..102.92 rows=3 width=75) (actual time=0.048..0.048 rows=0 loops=5,487)

59. 5.487 263.376 ↓ 0.0 0 5,487

Append (cost=2.38..102.89 rows=3 width=43) (actual time=0.048..0.048 rows=0 loops=5,487)

60. 5.487 120.714 ↓ 0.0 0 5,487

Nested Loop Anti Join (cost=2.38..36.54 rows=1 width=43) (actual time=0.022..0.022 rows=0 loops=5,487)

  • Join Filter: ((cpl.locationid <> lp.locationid) AND (cpl.personid = lp.personid))
61. 0.000 115.227 ↓ 0.0 0 5,487

Nested Loop (cost=2.09..28.20 rows=1 width=60) (actual time=0.021..0.021 rows=0 loops=5,487)

62. 0.000 115.227 ↓ 0.0 0 5,487

Nested Loop (cost=1.68..19.76 rows=1 width=39) (actual time=0.021..0.021 rows=0 loops=5,487)

  • Join Filter: (plr.personlocationreltype = plrt.personlocationreltype)
63. 0.144 115.227 ↓ 0.0 0 5,487

Nested Loop (cost=0.56..16.65 rows=1 width=39) (actual time=0.021..0.021 rows=0 loops=5,487)

64. 71.331 71.331 ↑ 1.0 1 5,487

Index Scan using person_locations_personid_idx on person_locations lp (cost=0.29..8.33 rows=1 width=17) (actual time=0.012..0.013 rows=1 loops=5,487)

  • 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
65. 43.752 43.752 ↓ 0.0 0 5,469

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

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

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

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

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

68. 0.000 0.000 ↓ 0.0 0

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

69. 0.000 0.000 ↓ 0.0 0

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

70. 0.000 0.000 ↓ 0.0 0

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

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

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

  • Index Cond: (personid = pe.personid)
  • Filter: ((personlocationtype = 'P'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
72. 10.974 65.844 ↓ 0.0 0 5,487

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

73. 0.000 54.870 ↓ 0.0 0 5,487

Nested Loop (cost=6.10..29.68 rows=1 width=35) (actual time=0.010..0.010 rows=0 loops=5,487)

  • Join Filter: (cl.companyid = pe_4.companyid)
74. 0.000 54.870 ↓ 0.0 0 5,487

Nested Loop (cost=5.69..21.22 rows=1 width=26) (actual time=0.010..0.010 rows=0 loops=5,487)

75. 5.487 54.870 ↓ 0.0 0 5,487

Nested Loop (cost=5.40..12.90 rows=1 width=26) (actual time=0.010..0.010 rows=0 loops=5,487)

  • Join Filter: (plrt_1.personlocationreltype = plr_1.personlocationreltype)
76. 10.974 49.383 ↓ 0.0 0 5,487

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

  • Recheck Cond: (personid = '27192'::bpchar)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=5487
77. 38.409 38.409 ↑ 1.0 2 5,487

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

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

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

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

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

80. 0.000 0.000 ↓ 0.0 0

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

81. 0.000 0.000 ↓ 0.0 0

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

82. 0.000 0.000 ↓ 0.0 0

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

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

Index Scan using personemploymentenddate on person_employment pe_4 (cost=0.42..8.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))
84. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (personid = pe.personid)
85. 5.487 71.331 ↓ 0.0 0 5,487

Nested Loop (cost=2.09..28.19 rows=1 width=43) (actual time=0.013..0.013 rows=0 loops=5,487)

86. 0.000 65.844 ↓ 0.0 0 5,487

Nested Loop (cost=1.68..19.75 rows=1 width=35) (actual time=0.012..0.012 rows=0 loops=5,487)

  • Join Filter: (plr_2.personlocationreltype = plrt_2.personlocationreltype)
87. 0.000 65.844 ↓ 0.0 0 5,487

Nested Loop (cost=0.56..16.65 rows=1 width=35) (actual time=0.012..0.012 rows=0 loops=5,487)

88. 65.844 65.844 ↓ 0.0 0 5,487

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

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

Index Scan using pk_person_location_rel on person_location_rel plr_2 (cost=0.28..8.31 rows=1 width=26) (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))
90. 0.000 0.000 ↓ 0.0 0

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

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

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

92. 0.000 0.000 ↓ 0.0 0

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

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

94. 0.000 0.000 ↓ 0.0 0

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

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

Result (cost=1.39..148.85 rows=4 width=95) (actual time=0.080..0.080 rows=0 loops=5,487)

96. 5.487 438.960 ↓ 0.0 0 5,487

Append (cost=1.39..148.81 rows=4 width=63) (actual time=0.080..0.080 rows=0 loops=5,487)

97. 0.000 142.662 ↓ 0.0 0 5,487

Nested Loop (cost=1.39..34.67 rows=1 width=70) (actual time=0.026..0.026 rows=0 loops=5,487)

98. 0.000 142.662 ↓ 0.0 0 5,487

Nested Loop (cost=0.98..26.23 rows=1 width=62) (actual time=0.026..0.026 rows=0 loops=5,487)

  • Join Filter: (pp_1.personorganizationreltype = port.personorganizationreltype)
99. 5.823 142.662 ↓ 0.0 0 5,487

Nested Loop (cost=0.98..25.11 rows=1 width=31) (actual time=0.026..0.026 rows=0 loops=5,487)

  • Join Filter: (pr.organizationid = pp_1.organizationid)
100. 5.495 93.279 ↑ 1.0 1 5,487

Nested Loop (cost=0.70..16.79 rows=1 width=17) (actual time=0.017..0.017 rows=1 loops=5,487)

101. 65.844 65.844 ↑ 1.0 1 5,487

Index Scan using pers_pos_personid_idx on pers_pos op (cost=0.29..8.33 rows=1 width=17) (actual time=0.012..0.012 rows=1 loops=5,487)

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

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

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

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

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

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

105. 0.000 0.000 ↓ 0.0 0

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

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

Nested Loop (cost=2.39..42.18 rows=1 width=70) (actual time=0.015..0.015 rows=0 loops=5,487)

  • Join Filter: (((pe_5.effectivedate - 1) >= op_1.effectivedate) AND ((pe_5.effectivedate - 1) <= op_1.enddate))
107. 5.487 82.305 ↓ 0.0 0 5,487

Nested Loop (cost=2.10..41.74 rows=1 width=91) (actual time=0.015..0.015 rows=0 loops=5,487)

108. 0.000 76.818 ↓ 0.0 0 5,487

Nested Loop (cost=1.68..33.30 rows=1 width=70) (actual time=0.014..0.014 rows=0 loops=5,487)

109. 0.000 76.818 ↓ 0.0 0 5,487

Nested Loop (cost=1.55..33.12 rows=1 width=81) (actual time=0.014..0.014 rows=0 loops=5,487)

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

Nested Loop (cost=1.26..32.77 rows=1 width=82) (actual time=0.014..0.014 rows=0 loops=5,487)

  • Join Filter: (((pe_5.effectivedate - 1) >= pr_1.effectivedate) AND ((pe_5.effectivedate - 1) <= pr_1.enddate))
111. 5.487 76.818 ↓ 0.0 0 5,487

Nested Loop (cost=0.97..26.22 rows=1 width=74) (actual time=0.014..0.014 rows=0 loops=5,487)

112. 71.331 71.331 ↓ 0.0 0 5,487

Index Scan using personemploymentenddate on person_employment pe_5 (cost=0.42..8.46 rows=1 width=21) (actual time=0.013..0.013 rows=0 loops=5,487)

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

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

114. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

117. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

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

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

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

Nested Loop (cost=2.92..37.25 rows=1 width=43) (actual time=0.021..0.021 rows=0 loops=5,487)

124. 0.000 115.227 ↓ 0.0 0 5,487

Nested Loop (cost=2.50..28.81 rows=1 width=35) (actual time=0.021..0.021 rows=0 loops=5,487)

125. 0.000 115.227 ↓ 0.0 0 5,487

Nested Loop (cost=2.37..28.63 rows=1 width=46) (actual time=0.021..0.021 rows=0 loops=5,487)

126. 5.471 115.227 ↓ 0.0 0 5,487

Nested Loop (cost=2.08..28.21 rows=1 width=43) (actual time=0.021..0.021 rows=0 loops=5,487)

127. 65.844 65.844 ↑ 1.0 1 5,487

Index Scan using personemploymentenddate on person_employment pe_6 (cost=0.42..8.45 rows=1 width=17) (actual time=0.012..0.012 rows=1 loops=5,487)

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

Nested Loop (cost=1.67..19.75 rows=1 width=34) (actual time=0.008..0.008 rows=0 loops=5,489)

129. 0.000 38.423 ↓ 0.0 0 5,489

Nested Loop (cost=1.39..11.41 rows=1 width=26) (actual time=0.007..0.007 rows=0 loops=5,489)

  • Join Filter: (port_2.personorganizationreltype = por.personorganizationreltype)
130. 38.423 38.423 ↓ 0.0 0 5,489

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

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

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

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

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

133. 0.000 0.000 ↓ 0.0 0

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

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

135. 0.000 0.000 ↓ 0.0 0

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

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

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

  • Index Cond: (organizationid = cor_1.organizationid)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
137. 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)
138. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (personid = pe.personid)
139. 5.487 93.279 ↓ 0.0 0 5,487

Nested Loop (cost=1.39..34.68 rows=1 width=70) (actual time=0.017..0.017 rows=0 loops=5,487)

140. 0.000 87.792 ↓ 0.0 0 5,487

Nested Loop (cost=0.98..26.23 rows=1 width=62) (actual time=0.016..0.016 rows=0 loops=5,487)

  • Join Filter: (pp_3.personorganizationreltype = port_3.personorganizationreltype)
141. 0.000 87.792 ↓ 0.0 0 5,487

Nested Loop (cost=0.98..25.12 rows=1 width=31) (actual time=0.016..0.016 rows=0 loops=5,487)

  • Join Filter: (pr_2.organizationid = pp_3.organizationid)
142. 5.466 87.792 ↓ 0.0 0 5,487

Nested Loop (cost=0.70..16.80 rows=1 width=17) (actual time=0.016..0.016 rows=0 loops=5,487)

143. 65.844 65.844 ↑ 1.0 1 5,487

Index Scan using pers_pos_personid_idx on pers_pos op_2 (cost=0.29..8.33 rows=1 width=33) (actual time=0.012..0.012 rows=1 loops=5,487)

  • 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
144. 16.482 16.482 ↓ 0.0 0 5,494

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

  • 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
145. 0.064 0.064 ↓ 0.0 0 8

Index Scan using person_organization_rel_pkey on person_organization_rel pp_3 (cost=0.27..8.31 rows=1 width=22) (actual time=0.008..0.008 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
146. 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)

147. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (personid = pe.personid)
148. 0.000 224.967 ↓ 0.0 0 5,487

Result (cost=2.39..66.61 rows=2 width=75) (actual time=0.041..0.041 rows=0 loops=5,487)

149. 5.487 224.967 ↓ 0.0 0 5,487

Append (cost=2.39..66.59 rows=2 width=43) (actual time=0.041..0.041 rows=0 loops=5,487)

150. 0.000 131.688 ↓ 0.0 0 5,487

Subquery Scan on *SELECT* 1_1 (cost=2.39..28.63 rows=1 width=43) (actual time=0.024..0.024 rows=0 loops=5,487)

151. 0.000 131.688 ↓ 0.0 0 5,487

Nested Loop (cost=2.39..28.62 rows=1 width=127) (actual time=0.024..0.024 rows=0 loops=5,487)

  • Join Filter: ((ppurt.personpayunitreltype)::text = (pp_4.personpayunitreltype)::text)
152. 0.000 131.688 ↓ 0.0 0 5,487

Nested Loop (cost=1.25..25.47 rows=1 width=40) (actual time=0.024..0.024 rows=0 loops=5,487)

153. 5.791 131.688 ↓ 0.0 0 5,487

Nested Loop (cost=0.84..17.02 rows=1 width=32) (actual time=0.024..0.024 rows=0 loops=5,487)

154. 5.563 82.305 ↑ 1.0 1 5,487

Nested Loop (cost=0.56..16.64 rows=1 width=21) (actual time=0.015..0.015 rows=1 loops=5,487)

155. 65.844 65.844 ↑ 1.0 1 5,487

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

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

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

  • Index Cond: (payunitid = ep.payunitid)
  • Heap Fetches: 5449
157. 43.592 43.592 ↓ 0.0 0 5,449

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

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

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

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

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

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

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

161. 0.000 0.000 ↓ 0.0 0

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

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

163. 0.000 87.792 ↓ 0.0 0 5,487

Subquery Scan on *SELECT* 2_1 (cost=37.94..37.96 rows=1 width=43) (actual time=0.016..0.016 rows=0 loops=5,487)

164. 5.487 87.792 ↓ 0.0 0 5,487

Unique (cost=37.94..37.95 rows=1 width=127) (actual time=0.016..0.016 rows=0 loops=5,487)

165. 16.461 82.305 ↓ 0.0 0 5,487

Sort (cost=37.94..37.94 rows=1 width=127) (actual time=0.015..0.015 rows=0 loops=5,487)

  • Sort Key: wr_7.rolename, p_11.companyid, p_11.customerid
  • Sort Method: quicksort Memory: 25kB
166. 0.000 65.844 ↓ 0.0 0 5,487

Nested Loop (cost=5.54..37.93 rows=1 width=127) (actual time=0.012..0.012 rows=0 loops=5,487)

167. 16.461 65.844 ↓ 0.0 0 5,487

Nested Loop (cost=5.40..35.71 rows=1 width=70) (actual time=0.012..0.012 rows=0 loops=5,487)

168. 0.000 49.383 ↓ 0.0 0 5,487

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

  • Join Filter: (pu_1.companyid = pe_7.companyid)
169. 0.000 49.383 ↓ 0.0 0 5,487

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

  • Join Filter: ((pp_5.personpayunitreltype)::text = (ppurt_1.personpayunitreltype)::text)
170. 0.000 49.383 ↓ 0.0 0 5,487

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

171. 5.487 49.383 ↓ 0.0 0 5,487

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

  • Recheck Cond: (personid = '27192'::bpchar)
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
172. 43.896 43.896 ↓ 0.0 0 5,487

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

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

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

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

175. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

  • Index Cond: (rolename = ppurt_1.companyrolename)
  • Heap Fetches: 0
178. 0.000 10.974 ↓ 0.0 0 5,487

Result (cost=0.83..125.60 rows=3 width=102) (actual time=0.002..0.002 rows=0 loops=5,487)

179. 5.487 10.974 ↓ 0.0 0 5,487

Append (cost=0.83..125.57 rows=3 width=70) (actual time=0.002..0.002 rows=0 loops=5,487)

180. 5.487 5.487 ↓ 0.0 0 5,487

Subquery Scan on *SELECT* 1_2 (cost=0.83..16.91 rows=1 width=70) (actual time=0.001..0.001 rows=0 loops=5,487)

181. 0.000 0.000 ↓ 0.0 0 5,487

Result (cost=0.83..16.90 rows=1 width=154) (actual time=0.000..0.000 rows=0 loops=5,487)

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

Nested Loop Semi Join (cost=0.83..16.90 rows=1 width=154) (actual time=0.030..0.031 rows=1 loops=1)

183. 0.013 0.013 ↑ 1.0 1 1

Index Scan using person_pkey on person p_12 (cost=0.41..8.43 rows=1 width=21) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: (personid = '27192'::bpchar)
184. 0.017 0.017 ↑ 1.0 1 1

Index Scan using personemploymentenddate on person_employment pe_8 (cost=0.42..8.46 rows=1 width=13) (actual time=0.017..0.017 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
185. 0.000 0.000 ↓ 0.0 0 5,487

Subquery Scan on *SELECT* 2_2 (cost=5.37..61.21 rows=1 width=70) (actual time=0.000..0.000 rows=0 loops=5,487)

186. 0.000 0.000 ↓ 0.0 0 5,487

Result (cost=5.37..61.20 rows=1 width=154) (actual time=0.000..0.000 rows=0 loops=5,487)

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

Nested Loop (cost=5.37..61.20 rows=1 width=154) (actual time=0.031..0.031 rows=0 loops=1)

188. 0.001 0.030 ↓ 0.0 0 1

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

  • Join Filter: (pe_9.personid = p_13.personid)
189. 0.012 0.012 ↑ 1.0 1 1

Index Scan using person_pkey on person p_13 (cost=0.41..8.43 rows=1 width=21) (actual time=0.011..0.012 rows=1 loops=1)

  • Index Cond: (personid = '27192'::bpchar)
190. 0.001 0.017 ↑ 1.0 1 1

Result (cost=0.42..8.46 rows=1 width=13) (actual time=0.017..0.017 rows=1 loops=1)

  • One-Time Filter: (pe.personid = '27192'::bpchar)
191. 0.016 0.016 ↑ 1.0 1 1

Index Scan using personemploymentenddate on person_employment pe_9 (cost=0.42..8.46 rows=1 width=13) (actual time=0.016..0.016 rows=1 loops=1)

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

Bitmap Heap Scan on pers_pos pp_6 (cost=4.53..44.27 rows=3 width=13) (never executed)

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

Bitmap Index Scan on pers_pospersendeff (cost=0.00..4.53 rows=11 width=0) (never executed)

  • Index Cond: ((personid = '27192'::bpchar) AND (CURRENT_DATE <= enddate))
194. 0.000 0.000 ↓ 0.0 0 5,487

Subquery Scan on *SELECT* 3 (cost=1.13..47.45 rows=1 width=70) (actual time=0.000..0.000 rows=0 loops=5,487)

195. 0.000 0.000 ↓ 0.0 0 5,487

Result (cost=1.13..47.44 rows=1 width=154) (actual time=0.000..0.000 rows=0 loops=5,487)

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

Nested Loop Semi Join (cost=1.13..47.44 rows=1 width=154) (actual time=0.024..0.024 rows=0 loops=1)

197. 0.000 0.024 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.70..38.97 rows=1 width=21) (actual time=0.024..0.024 rows=0 loops=1)

198. 0.012 0.012 ↑ 1.0 1 1

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

  • Index Cond: (personid = '27192'::bpchar)
199. 0.002 0.012 ↑ 3.0 1 1

Result (cost=0.29..60.75 rows=3 width=13) (actual time=0.011..0.012 rows=1 loops=1)

  • One-Time Filter: (pe.personid = '27192'::bpchar)
200. 0.010 0.010 ↑ 3.0 1 1

Index Scan using pers_pos_personid_idx on pers_pos pp_7 (cost=0.29..60.75 rows=3 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))
201. 0.000 0.000 ↓ 0.0 0

Index Scan using personemploymentenddate on person_employment p_14 (cost=0.42..8.46 rows=1 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))
202. 0.000 0.000 ↓ 0.0 0 5,487

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

  • One-Time Filter: false
203. 0.000 203.019 ↓ 0.0 0 5,487

Result (cost=1.29..103.44 rows=3 width=102) (actual time=0.037..0.037 rows=0 loops=5,487)

204. 5.487 203.019 ↓ 0.0 0 5,487

Append (cost=1.29..103.41 rows=3 width=70) (actual time=0.037..0.037 rows=0 loops=5,487)

205. 0.000 109.740 ↓ 0.0 0 5,487

Subquery Scan on *SELECT* 1_3 (cost=1.29..25.62 rows=1 width=70) (actual time=0.020..0.020 rows=0 loops=5,487)

206. 0.000 109.740 ↓ 0.0 0 5,487

Nested Loop (cost=1.29..25.61 rows=1 width=154) (actual time=0.020..0.020 rows=0 loops=5,487)

207. 5.964 109.740 ↓ 0.0 0 5,487

Nested Loop (cost=0.87..17.17 rows=1 width=26) (actual time=0.020..0.020 rows=0 loops=5,487)

208. 5.493 87.792 ↑ 1.0 1 5,487

Nested Loop (cost=0.58..16.66 rows=1 width=17) (actual time=0.016..0.016 rows=1 loops=5,487)

209. 71.331 71.331 ↑ 1.0 1 5,487

Index Scan using pers_pos_personid_idx on pers_pos pp_8 (cost=0.29..8.33 rows=1 width=17) (actual time=0.012..0.013 rows=1 loops=5,487)

  • 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
210. 10.968 10.968 ↑ 1.0 1 5,484

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

  • 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
211. 15.984 15.984 ↓ 0.0 0 5,328

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

  • 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
212. 0.182 0.182 ↑ 1.0 1 14

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

  • Index Cond: (personid = pe.personid)
213. 0.000 5.487 ↓ 0.0 0 5,487

Subquery Scan on *SELECT* 2_3 (cost=1.69..45.87 rows=1 width=70) (actual time=0.001..0.001 rows=0 loops=5,487)

214. 0.000 5.487 ↓ 0.0 0 5,487

Nested Loop (cost=1.69..45.86 rows=1 width=154) (actual time=0.001..0.001 rows=0 loops=5,487)

215. 0.000 5.487 ↓ 0.0 0 5,487

Nested Loop (cost=1.55..37.68 rows=1 width=42) (actual time=0.001..0.001 rows=0 loops=5,487)

216. 5.487 5.487 ↓ 0.0 0 5,487

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

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

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

  • Join Filter: (p_16.personid <> pp_9.personid)
218. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

221. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

Subquery Scan on *SELECT* 3_1 (cost=1.29..31.92 rows=1 width=70) (actual time=0.015..0.015 rows=0 loops=5,487)

226. 0.000 82.305 ↓ 0.0 0 5,487

Nested Loop (cost=1.29..31.91 rows=1 width=154) (actual time=0.015..0.015 rows=0 loops=5,487)

227. 5.487 82.305 ↓ 0.0 0 5,487

Nested Loop (cost=0.87..23.47 rows=1 width=26) (actual time=0.015..0.015 rows=0 loops=5,487)

228. 0.006 76.818 ↓ 0.0 0 5,487

Nested Loop (cost=0.58..16.66 rows=1 width=17) (actual time=0.014..0.014 rows=0 loops=5,487)

229. 65.844 65.844 ↑ 1.0 1 5,487

Index Scan using pers_pos_personid_idx on pers_pos pp_10 (cost=0.29..8.33 rows=1 width=17) (actual time=0.012..0.012 rows=1 loops=5,487)

  • 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
230. 10.968 10.968 ↓ 0.0 0 5,484

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

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

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

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

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

  • Index Cond: (personid = pe.personid)
233. 0.000 362.142 ↓ 0.0 0 5,487

Result (cost=1.57..79.61 rows=6 width=102) (actual time=0.066..0.066 rows=0 loops=5,487)

234. 5.487 362.142 ↓ 0.0 0 5,487

Append (cost=1.57..79.55 rows=6 width=70) (actual time=0.065..0.066 rows=0 loops=5,487)

235. 0.000 109.740 ↓ 0.0 0 5,487

Subquery Scan on *SELECT* 1_4 (cost=1.57..26.10 rows=2 width=70) (actual time=0.020..0.020 rows=0 loops=5,487)

236. 0.000 109.740 ↓ 0.0 0 5,487

Nested Loop (cost=1.57..26.08 rows=2 width=154) (actual time=0.020..0.020 rows=0 loops=5,487)

237. 5.217 109.740 ↓ 0.0 0 5,487

Nested Loop (cost=1.57..26.02 rows=1 width=34) (actual time=0.020..0.020 rows=0 loops=5,487)

238. 0.396 104.253 ↓ 0.0 0 5,487

Nested Loop (cost=1.16..17.57 rows=1 width=26) (actual time=0.019..0.019 rows=0 loops=5,487)

239. 5.805 93.279 ↑ 1.0 1 5,487

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

240. 0.004 76.818 ↑ 1.0 1 5,487

Nested Loop (cost=0.58..16.66 rows=1 width=17) (actual time=0.014..0.014 rows=1 loops=5,487)

241. 65.844 65.844 ↑ 1.0 1 5,487

Index Scan using pers_pos_personid_idx on pers_pos p3 (cost=0.29..8.32 rows=1 width=17) (actual time=0.011..0.012 rows=1 loops=5,487)

  • 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
242. 10.970 10.970 ↑ 1.0 1 5,485

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

  • 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
243. 10.656 10.656 ↑ 1.0 1 5,328

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

  • 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
244. 10.578 10.578 ↓ 0.0 0 5,289

Index Scan using pers_pos_positionid_idx on pers_pos p_18 (cost=0.29..0.49 rows=1 width=17) (actual time=0.002..0.002 rows=0 loops=5,289)

  • 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
245. 0.270 0.270 ↑ 1.0 1 18

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

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

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

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

249. 5.487 131.688 ↓ 0.0 0 5,487

Subquery Scan on *SELECT* 2_4 (cost=1.86..26.52 rows=2 width=70) (actual time=0.024..0.024 rows=0 loops=5,487)

250. 0.000 126.201 ↓ 0.0 0 5,487

Nested Loop (cost=1.86..26.50 rows=2 width=154) (actual time=0.023..0.023 rows=0 loops=5,487)

251. 0.053 126.201 ↓ 0.0 0 5,487

Nested Loop (cost=1.86..26.44 rows=1 width=34) (actual time=0.023..0.023 rows=0 loops=5,487)

252. 6.023 120.714 ↓ 0.0 0 5,487

Nested Loop (cost=1.45..18.00 rows=1 width=26) (actual time=0.022..0.022 rows=0 loops=5,487)

253. 0.396 104.253 ↑ 1.0 1 5,487

Nested Loop (cost=1.16..17.49 rows=1 width=17) (actual time=0.018..0.019 rows=1 loops=5,487)

254. 11.133 93.279 ↑ 1.0 1 5,487

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

255. 5.489 76.818 ↑ 1.0 1 5,487

Nested Loop (cost=0.58..16.66 rows=1 width=17) (actual time=0.014..0.014 rows=1 loops=5,487)

256. 65.844 65.844 ↑ 1.0 1 5,487

Index Scan using pers_pos_personid_idx on pers_pos p5 (cost=0.29..8.32 rows=1 width=17) (actual time=0.011..0.012 rows=1 loops=5,487)

  • 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
257. 5.485 5.485 ↑ 1.0 1 5,485

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

  • 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
258. 5.328 5.328 ↑ 1.0 1 5,328

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

  • 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
259. 10.578 10.578 ↑ 1.0 1 5,289

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

  • 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
260. 10.438 10.438 ↓ 0.0 0 5,219

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

  • 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
261. 5.434 5.434 ↑ 1.0 1 11

Index Scan using person_pkey on person person_3 (cost=0.41..8.43 rows=1 width=21) (actual time=0.494..0.494 rows=1 loops=11)

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

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

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

265. 0.000 115.227 ↓ 0.0 0 5,487

Subquery Scan on *SELECT* 3_2 (cost=2.15..26.94 rows=2 width=70) (actual time=0.021..0.021 rows=0 loops=5,487)

266. 0.000 115.227 ↓ 0.0 0 5,487

Nested Loop (cost=2.15..26.92 rows=2 width=154) (actual time=0.021..0.021 rows=0 loops=5,487)

267. 0.000 115.227 ↓ 0.0 0 5,487

Nested Loop (cost=2.15..26.86 rows=1 width=34) (actual time=0.021..0.021 rows=0 loops=5,487)

268. 4.758 115.227 ↓ 0.0 0 5,487

Nested Loop (cost=1.74..18.42 rows=1 width=26) (actual time=0.021..0.021 rows=0 loops=5,487)

269. 0.268 109.740 ↓ 0.0 0 5,487

Nested Loop (cost=1.45..17.91 rows=1 width=17) (actual time=0.020..0.020 rows=0 loops=5,487)

270. 5.883 104.253 ↑ 1.0 1 5,487

Nested Loop (cost=1.16..17.49 rows=1 width=17) (actual time=0.018..0.019 rows=1 loops=5,487)

271. 5.646 87.792 ↑ 1.0 1 5,487

Nested Loop (cost=0.87..17.08 rows=1 width=17) (actual time=0.016..0.016 rows=1 loops=5,487)

272. 5.489 76.818 ↑ 1.0 1 5,487

Nested Loop (cost=0.58..16.66 rows=1 width=17) (actual time=0.014..0.014 rows=1 loops=5,487)

273. 65.844 65.844 ↑ 1.0 1 5,487

Index Scan using pers_pos_personid_idx on pers_pos p7 (cost=0.29..8.32 rows=1 width=17) (actual time=0.012..0.012 rows=1 loops=5,487)

  • 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
274. 5.485 5.485 ↑ 1.0 1 5,485

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

  • 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
275. 5.328 5.328 ↑ 1.0 1 5,328

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

  • 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
276. 10.578 10.578 ↑ 1.0 1 5,289

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

  • 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
277. 5.219 5.219 ↓ 0.0 0 5,219

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

  • 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
278. 0.729 0.729 ↓ 0.0 0 243

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

  • 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
279. 0.028 0.028 ↑ 1.0 1 2

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

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

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

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

283. 16.461 76.818 ↓ 0.0 0 5,487

Nested Loop (cost=4.98..26.25 rows=1 width=141) (actual time=0.014..0.014 rows=0 loops=5,487)

284. 0.000 60.357 ↓ 0.0 0 5,487

Nested Loop (cost=4.57..17.81 rows=1 width=20) (actual time=0.011..0.011 rows=0 loops=5,487)

285. 0.000 60.357 ↓ 0.0 0 5,487

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

  • Recheck Cond: ((name_)::text = 'originatorID'::text)
  • Filter: ((text_)::character(12) = '27192'::bpchar)
286. 60.357 60.357 ↓ 0.0 0 5,487

Bitmap Index Scan on act_ru_variable_name__text__idx (cost=0.00..4.29 rows=2 width=0) (actual time=0.011..0.011 rows=0 loops=5,487)

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

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

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

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

  • Index Cond: (personid = pe.personid)
289. 0.000 175.584 ↓ 0.0 0 5,487

Nested Loop (cost=1.25..37.81 rows=1 width=102) (actual time=0.032..0.032 rows=0 loops=5,487)

290. 5.487 175.584 ↓ 0.0 0 5,487

Nested Loop (cost=0.83..29.37 rows=1 width=26) (actual time=0.032..0.032 rows=0 loops=5,487)

  • Join Filter: (cp.companyid = pe_10.companyid)
291. 0.000 170.097 ↓ 0.0 0 5,487

Nested Loop (cost=0.41..20.91 rows=1 width=17) (actual time=0.031..0.031 rows=0 loops=5,487)

292. 10.974 170.097 ↓ 0.0 0 5,487

Nested Loop (cost=0.41..9.56 rows=1 width=13) (actual time=0.031..0.031 rows=0 loops=5,487)

293. 71.331 71.331 ↑ 1.0 1 5,487

Index Only Scan using person_pkey on person u (cost=0.41..4.43 rows=1 width=13) (actual time=0.013..0.013 rows=1 loops=5,487)

  • Index Cond: (personid = '27192'::bpchar)
  • Heap Fetches: 0
294. 87.792 87.792 ↓ 0.0 0 5,487

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

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

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

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

Index Scan using personemploymentenddate on person_employment pe_10 (cost=0.42..8.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))
297. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (personid = pe.personid)
298. 21.948 192.045 ↑ 1.2 18 5,487

Nested Loop (cost=0.83..87.27 rows=21 width=98) (actual time=0.026..0.035 rows=18 loops=5,487)

299. 65.844 65.844 ↑ 1.0 1 5,487

Index Scan using person_pkey on person p_23 (cost=0.41..8.43 rows=1 width=21) (actual time=0.012..0.012 rows=1 loops=5,487)

  • Index Cond: (personid = pe.personid)
300. 104.253 104.253 ↑ 1.2 18 5,487

Index Only Scan using person_identity_pkey on person_identity p1_4 (cost=0.42..78.63 rows=21 width=13) (actual time=0.013..0.019 rows=18 loops=5,487)

  • Index Cond: (personid = '27192'::bpchar)
  • Heap Fetches: 98766
301. 5.487 246.915 ↑ 1.0 1 5,487

Subquery Scan on *SELECT* 13 (cost=1.25..25.37 rows=1 width=98) (actual time=0.044..0.045 rows=1 loops=5,487)

302. 0.000 241.428 ↑ 1.0 1 5,487

Nested Loop (cost=1.25..25.36 rows=1 width=98) (actual time=0.043..0.044 rows=1 loops=5,487)

303. 10.940 175.584 ↑ 1.0 1 5,487

Nested Loop (cost=0.83..16.92 rows=1 width=26) (actual time=0.031..0.032 rows=1 loops=5,487)

  • Join Filter: (pcr_2.companyid = pe_11.companyid)
304. 71.331 71.331 ↑ 1.0 1 5,487

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

  • 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
305. 93.313 93.313 ↑ 1.0 1 5,489

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

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

Index Scan using person_pkey on person p_24 (cost=0.41..8.43 rows=1 width=21) (actual time=0.011..0.012 rows=1 loops=5,489)

  • Index Cond: (personid = pe.personid)
307. 5.487 395.064 ↓ 0.0 0 5,487

Nested Loop (cost=9.02..22.87 rows=1 width=141) (actual time=0.072..0.072 rows=0 loops=5,487)

308. 0.000 389.577 ↓ 0.0 0 5,487

Nested Loop (cost=8.61..14.43 rows=1 width=101) (actual time=0.071..0.071 rows=0 loops=5,487)

  • Join Filter: (pcr_3.personcustomerreltype = pcrt_2.personcustomerreltype)
309. 16.356 389.577 ↓ 0.0 0 5,487

Nested Loop (cost=8.61..13.16 rows=1 width=89) (actual time=0.071..0.071 rows=0 loops=5,487)

310. 60.357 345.681 ↑ 1.0 1 5,487

Hash Join (cost=8.46..12.83 rows=1 width=17) (actual time=0.027..0.063 rows=1 loops=5,487)

  • Hash Cond: (cs.companyid = pe_12.companyid)
311. 203.019 203.019 ↑ 1.0 88 5,487

Seq Scan on customer_struct cs (cost=0.00..4.03 rows=88 width=8) (actual time=0.002..0.037 rows=88 loops=5,487)

  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 13
312. 10.974 82.305 ↑ 1.0 1 5,487

Hash (cost=8.45..8.45 rows=1 width=17) (actual time=0.015..0.015 rows=1 loops=5,487)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
313. 71.331 71.331 ↑ 1.0 1 5,487

Index Scan using personemploymentenddate on person_employment pe_12 (cost=0.42..8.45 rows=1 width=17) (actual time=0.013..0.013 rows=1 loops=5,487)

  • 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
314. 27.540 27.540 ↓ 0.0 0 5,508

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

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

316. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (personid = pe.personid)
317. 71.331 71.331 ↑ 1.0 1 5,487

Index Scan using person_compensation_pkey on person_compensation pd (cost=0.41..2.15 rows=1 width=13) (actual time=0.013..0.013 rows=1 loops=5,487)

  • 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
318. 70.629 70.629 ↑ 1.0 1 5,433

Index Scan using person_names_personid_idx on person_names pn (cost=0.29..0.59 rows=1 width=26) (actual time=0.013..0.013 rows=1 loops=5,433)

  • 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
319. 16.296 16.296 ↓ 0.0 0 5,432

Index Only Scan using pk_person_image on person_image pi (cost=0.15..0.24 rows=5 width=56) (actual time=0.003..0.003 rows=0 loops=5,432)

  • Index Cond: (personid = pn.personid)
  • Heap Fetches: 4
320. 0.890 2.215 ↑ 1.0 6,980 1

Hash (cost=434.80..434.80 rows=6,980 width=31) (actual time=2.215..2.215 rows=6,980 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 494kB
321. 1.325 1.325 ↑ 1.0 6,980 1

Seq Scan on document_content dc (cost=0.00..434.80 rows=6,980 width=31) (actual time=0.006..1.325 rows=6,980 loops=1)

Planning time : 91.215 ms
Execution time : 3,999.310 ms