explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Zbks

Settings
# exclusive inclusive rows x rows loops node
1. 0.077 12,378.640 ↑ 1.0 200 1

Limit (cost=6,907,339.73..6,907,340.23 rows=200 width=85) (actual time=12,378.552..12,378.640 rows=200 loops=1)

2. 18.481 12,378.563 ↑ 413.3 200 1

Sort (cost=6,907,339.73..6,907,546.40 rows=82,667 width=85) (actual time=12,378.551..12,378.563 rows=200 loops=1)

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

Hash Left Join (cost=523.33..6,903,766.92 rows=82,667 width=85) (actual time=6.080..12,360.082 rows=5,432 loops=1)

  • Hash Cond: (pi.documentid = dc.documentid)
4. 4.278 12,349.889 ↑ 14.8 5,432 1

Nested Loop Left Join (cost=1.27..6,901,004.94 rows=80,440 width=30) (actual time=2.501..12,349.889 rows=5,432 loops=1)

5. 3.922 12,329.315 ↑ 14.8 5,432 1

Nested Loop (cost=1.12..6,877,736.52 rows=80,440 width=39) (actual time=2.493..12,329.315 rows=5,432 loops=1)

  • Join Filter: (pe.personid = pn.personid)
6. 5.783 12,249.331 ↓ 3.4 5,433 1

Nested Loop Semi Join (cost=0.83..6,876,779.23 rows=1,591 width=26) (actual time=2.462..12,249.331 rows=5,433 loops=1)

7. 13.025 12,166.730 ↓ 2.8 5,487 1

Index Scan using employmentcompanyideffdt on person_employment pe (cost=0.42..6,872,718.95 rows=1,980 width=13) (actual time=2.320..12,166.730 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. 32.922 12,153.705 ↑ 25.0 1 5,487

Hash Join (cost=1,041.83..1,076.47 rows=25 width=0) (actual time=2.215..2.215 rows=1 loops=5,487)

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

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

11. 0.000 60.357 ↓ 0.0 0 5,487

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

12. 5.487 60.357 ↓ 0.0 0 5,487

Nested Loop Anti Join (cost=0.69..12.78 rows=1 width=261) (actual time=0.011..0.011 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 235.941 ↑ 1.6 15 5,487

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

16. 21.948 224.967 ↑ 1.6 15 5,487

Merge Anti Join (cost=8.99..21.95 rows=24 width=261) (actual time=0.031..0.041 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.016..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. 10.974 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. 43.896 43.896 ↓ 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.008..0.008 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. 10.974 11,813.511 ↑ 17.0 3 5,487

Hash (cost=1,040.51..1,040.51 rows=51 width=32) (actual time=2.153..2.153 rows=3 loops=5,487)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
24. 5.487 11,802.537 ↑ 17.0 3 5,487

Subquery Scan on rpa (cost=1,039.49..1,040.51 rows=51 width=32) (actual time=2.150..2.151 rows=3 loops=5,487)

25. 71.331 11,797.050 ↑ 17.0 3 5,487

HashAggregate (cost=1,039.49..1,040.00 rows=51 width=176) (actual time=2.149..2.150 rows=3 loops=5,487)

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

Append (cost=0.83..1,038.72 rows=51 width=176) (actual time=0.143..2.137 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 685.875 ↑ 2.0 1 5,487

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

33. 5.487 680.388 ↑ 2.0 1 5,487

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

34. 27.435 674.901 ↑ 2.0 1 5,487

Sort (cost=63.64..63.65 rows=2 width=148) (actual time=0.123..0.123 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. 0.000 647.466 ↑ 2.0 1 5,487

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

36. 5.214 285.324 ↑ 1.0 1 5,487

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

37. 10.869 208.506 ↑ 1.0 1 5,487

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

38. 16.440 170.097 ↑ 1.0 1 5,487

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

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

Nested Loop (cost=0.70..16.78 rows=1 width=32) (actual time=0.025..0.027 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.014..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.010..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. 71.604 71.604 ↑ 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.013 rows=1 loops=5,508)

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

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

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

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

47. 5.499 208.506 ↑ 1.0 1 5,487

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

48. 16.464 181.071 ↑ 1.0 1 5,487

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

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

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

50. 5.495 98.766 ↑ 1.0 1 5,487

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

51. 71.331 71.331 ↑ 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.013 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. 21.940 21.940 ↑ 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.004 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. 21.936 21.936 ↑ 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.004..0.004 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.012..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. 5.487 279.837 ↓ 0.0 0 5,487

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

59. 5.487 274.350 ↓ 0.0 0 5,487

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

60. 0.000 126.201 ↓ 0.0 0 5,487

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

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

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

62. 0.000 120.714 ↓ 0.0 0 5,487

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

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

Nested Loop (cost=0.56..16.65 rows=1 width=39) (actual time=0.022..0.022 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.013..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. 16.461 71.331 ↓ 0.0 0 5,487

Nested Loop (cost=6.52..38.13 rows=1 width=43) (actual time=0.013..0.013 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. 0.000 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. 16.461 54.870 ↓ 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.010..0.010 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. 0.000 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. 5.487 71.331 ↓ 0.0 0 5,487

Nested Loop (cost=1.68..19.75 rows=1 width=35) (actual time=0.013..0.013 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.035 0.035 ↓ 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.007..0.007 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. 5.487 466.395 ↓ 0.0 0 5,487

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

96. 5.487 460.908 ↓ 0.0 0 5,487

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

97. 0.000 153.636 ↓ 0.0 0 5,487

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

98. 5.487 153.636 ↓ 0.0 0 5,487

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

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

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

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

Nested Loop (cost=0.70..16.79 rows=1 width=17) (actual time=0.018..0.018 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. 27.425 27.425 ↑ 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.005..0.005 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. 0.000 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. 5.487 82.305 ↓ 0.0 0 5,487

Nested Loop (cost=1.68..33.30 rows=1 width=70) (actual time=0.015..0.015 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 120.714 ↓ 0.0 0 5,487

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

124. 0.000 120.714 ↓ 0.0 0 5,487

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

125. 5.487 120.714 ↓ 0.0 0 5,487

Nested Loop (cost=2.37..28.63 rows=1 width=46) (actual time=0.022..0.022 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. 0.000 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. 5.489 43.912 ↓ 0.0 0 5,489

Nested Loop (cost=1.39..11.41 rows=1 width=26) (actual time=0.008..0.008 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 98.766 ↓ 0.0 0 5,487

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

140. 0.000 93.279 ↓ 0.0 0 5,487

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

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

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

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

Nested Loop (cost=0.70..16.80 rows=1 width=17) (actual time=0.017..0.017 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. 21.976 21.976 ↓ 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.004..0.004 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 241.428 ↓ 0.0 0 5,487

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

149. 5.487 241.428 ↓ 0.0 0 5,487

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

150. 0.000 142.662 ↓ 0.0 0 5,487

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

151. 0.000 142.662 ↓ 0.0 0 5,487

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

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

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

153. 5.791 137.175 ↓ 0.0 0 5,487

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

154. 5.563 87.792 ↑ 1.0 1 5,487

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

155. 71.331 71.331 ↑ 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.013..0.013 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. 5.487 93.279 ↓ 0.0 0 5,487

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

164. 0.000 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 87.792 ↓ 0.0 0 5,487

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

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

Nested Loop (cost=5.54..37.93 rows=1 width=127) (actual time=0.013..0.013 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. 0.000 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. 49.383 49.383 ↓ 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.009..0.009 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. 5.487 16.461 ↓ 0.0 0 5,487

Result (cost=0.83..125.60 rows=3 width=102) (actual time=0.003..0.003 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.002 0.034 ↑ 1.0 1 1

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

183. 0.014 0.014 ↑ 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.014..0.014 rows=1 loops=1)

  • Index Cond: (personid = '27192'::bpchar)
184. 0.018 0.018 ↑ 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.018..0.018 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.000 0.033 ↓ 0.0 0 1

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

188. 0.002 0.033 ↓ 0.0 0 1

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

  • Join Filter: (pe_9.personid = p_13.personid)
189. 0.013 0.013 ↑ 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.013..0.013 rows=1 loops=1)

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

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

  • One-Time Filter: (pe.personid = '27192'::bpchar)
191. 0.017 0.017 ↑ 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.017..0.017 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.001 0.040 ↓ 0.0 0 1

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

197. 0.000 0.039 ↓ 0.0 0 1

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

198. 0.013 0.013 ↑ 1.0 1 1

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

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

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

  • One-Time Filter: (pe.personid = '27192'::bpchar)
200. 0.024 0.024 ↑ 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.024..0.024 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. 5.487 8,159.169 ↓ 0.0 0 5,487

Subquery Scan on r_personpeers (cost=126.35..126.40 rows=2 width=180) (actual time=1.487..1.487 rows=0 loops=5,487)

203. 5.487 8,153.682 ↓ 0.0 0 5,487

Unique (cost=126.35..126.38 rows=2 width=232) (actual time=1.486..1.486 rows=0 loops=5,487)

204. 16.461 8,148.195 ↓ 0.0 0 5,487

Sort (cost=126.35..126.35 rows=2 width=232) (actual time=1.485..1.485 rows=0 loops=5,487)

  • Sort Key: mypos.personid, p_15.personid, ('Peer '::character(8)), ('RoleEx_Peer '::character(20)), p_15.companyid, p_15.customerid
  • Sort Method: quicksort Memory: 25kB
205. 5.487 8,131.734 ↓ 0.0 0 5,487

Append (cost=5.85..126.34 rows=2 width=232) (actual time=1.482..1.482 rows=0 loops=5,487)

206. 5.474 8,016.507 ↓ 0.0 0 5,487

Nested Loop (cost=5.85..73.95 rows=1 width=154) (actual time=1.461..1.461 rows=0 loops=5,487)

207. 1,697.612 8,011.020 ↓ 0.0 0 5,487

Nested Loop (cost=5.44..65.51 rows=1 width=26) (actual time=1.460..1.460 rows=0 loops=5,487)

  • Join Filter: (mypos.positionid = manager.topositionid)
  • Rows Removed by Join Filter: 4392
208. 24.810 213.993 ↑ 5.0 1 5,487

Nested Loop (cost=5.14..61.09 rows=5 width=34) (actual time=0.036..0.039 rows=1 loops=5,487)

  • Join Filter: (peers.personid <> mypos.personid)
  • Rows Removed by Join Filter: 0
209. 5.496 93.279 ↑ 1.0 1 5,487

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

210. 71.331 71.331 ↑ 1.0 1 5,487

Index Scan using pers_pos_personid_idx on pers_pos peers (cost=0.29..8.33 rows=1 width=17) (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
211. 16.452 16.452 ↑ 1.0 1 5,484

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

  • Index Cond: ((topositionid = peers.positionid) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 0
212. 15.984 95.904 ↑ 8.0 1 5,328

Bitmap Heap Scan on pers_pos mypos (cost=4.56..44.33 rows=8 width=17) (actual time=0.016..0.018 rows=1 loops=5,328)

  • Recheck Cond: ((personid = '27192'::bpchar) AND (CURRENT_DATE <= enddate) AND (CURRENT_DATE >= effectivedate))
  • Filter: ((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=10656
213. 79.920 79.920 ↑ 3.7 3 5,328

Bitmap Index Scan on pers_pospersendeff (cost=0.00..4.56 rows=11 width=0) (actual time=0.015..0.015 rows=3 loops=5,328)

  • Index Cond: ((personid = '27192'::bpchar) AND (CURRENT_DATE <= enddate) AND (CURRENT_DATE >= effectivedate))
214. 6,099.415 6,099.415 ↓ 411.3 4,524 5,327

Index Scan using pos_posposendeffendts on pos_pos manager (cost=0.29..0.75 rows=11 width=8) (actual time=0.007..1.145 rows=4,524 loops=5,327)

  • Index Cond: ((positionid = manages.positionid) AND (CURRENT_DATE <= enddate) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_TIMESTAMP <= endts))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts))
  • Rows Removed by Filter: 0
215. 0.013 0.013 ↑ 1.0 1 1

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

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

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

217. 5.441 109.740 ↓ 0.0 0 5,487

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

218. 10.980 98.766 ↑ 1.0 1 5,487

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

219. 76.818 76.818 ↑ 1.0 1 5,487

Index Scan using pers_pos_personid_idx on pers_pos mgrpos (cost=0.29..8.33 rows=1 width=17) (actual time=0.014..0.014 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
220. 10.968 10.968 ↑ 11.0 1 5,484

Index Scan using pos_posposendeffendts on pos_pos manager_1 (cost=0.29..34.99 rows=11 width=8) (actual time=0.002..0.002 rows=1 loops=5,484)

  • Index Cond: ((positionid = mgrpos.positionid) AND (CURRENT_DATE <= enddate) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_TIMESTAMP <= endts))
  • Filter: ((posposrel = 'Manages'::bpchar) AND (CURRENT_TIMESTAMP >= createts))
  • Rows Removed by Filter: 0
221. 5.533 5.533 ↓ 0.0 0 5,533

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

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

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

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

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

224. 0.000 213.993 ↓ 0.0 0 5,487

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

225. 0.000 115.227 ↓ 0.0 0 5,487

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

226. 5.305 115.227 ↓ 0.0 0 5,487

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

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

228. 10.980 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)

229. 65.844 65.844 ↑ 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.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 ↑ 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
231. 15.984 15.984 ↓ 0.0 0 5,328

Index Scan using pers_pos_positionid_idx on pers_pos p_17 (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
232. 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.012..0.013 rows=1 loops=14)

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

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

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

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

236. 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))
237. 0.000 0.000 ↓ 0.0 0

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

  • Join Filter: (p_18.personid <> pp_9.personid)
238. 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)
239. 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)
240. 0.000 0.000 ↓ 0.0 0

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

241. 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)
242. 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
243. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (personid = '27192'::bpchar)
  • Heap Fetches: 0
244. 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))
245. 5.487 87.792 ↓ 0.0 0 5,487

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

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

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

248. 5.493 82.305 ↓ 0.0 0 5,487

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

249. 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
250. 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
251. 0.000 0.000 ↓ 0.0 0

Index Scan using pers_pos_positionid_idx on pers_pos p_19 (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))
252. 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)
253. 0.000 384.090 ↓ 0.0 0 5,487

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

254. 5.487 384.090 ↓ 0.0 0 5,487

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

255. 5.487 120.714 ↓ 0.0 0 5,487

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

256. 0.000 115.227 ↓ 0.0 0 5,487

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

257. 0.000 115.227 ↓ 0.0 0 5,487

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

258. 5.883 115.227 ↓ 0.0 0 5,487

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

259. 5.805 98.766 ↑ 1.0 1 5,487

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

260. 5.491 82.305 ↑ 1.0 1 5,487

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

261. 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.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
262. 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.002..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
263. 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
264. 10.578 10.578 ↓ 0.0 0 5,289

Index Scan using pers_pos_positionid_idx on pers_pos p_20 (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
265. 0.234 0.234 ↑ 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.012..0.013 rows=1 loops=18)

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

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

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

269. 0.000 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)

270. 0.000 131.688 ↓ 0.0 0 5,487

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

271. 0.000 131.688 ↓ 0.0 0 5,487

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

272. 6.291 131.688 ↓ 0.0 0 5,487

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

273. 5.883 109.740 ↑ 1.0 1 5,487

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

274. 0.318 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)

275. 5.491 82.305 ↑ 1.0 1 5,487

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

276. 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.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
277. 10.970 10.970 ↑ 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.002 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
278. 10.656 10.656 ↑ 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.002 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
279. 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
280. 15.657 15.657 ↓ 0.0 0 5,219

Index Scan using pers_pos_positionid_idx on pers_pos p_21 (cost=0.29..0.49 rows=1 width=17) (actual time=0.003..0.003 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
281. 0.132 0.132 ↑ 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.012..0.012 rows=1 loops=11)

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

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

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

285. 0.000 126.201 ↓ 0.0 0 5,487

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

286. 5.485 126.201 ↓ 0.0 0 5,487

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

287. 0.000 120.714 ↓ 0.0 0 5,487

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

288. 0.000 120.714 ↓ 0.0 0 5,487

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

289. 5.755 120.714 ↓ 0.0 0 5,487

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

290. 5.883 109.740 ↑ 1.0 1 5,487

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

291. 0.318 93.279 ↑ 1.0 1 5,487

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

292. 10.976 82.305 ↑ 1.0 1 5,487

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

293. 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
294. 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
295. 10.656 10.656 ↑ 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.002 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
296. 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
297. 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
298. 0.729 0.729 ↓ 0.0 0 243

Index Scan using pers_pos_positionid_idx on pers_pos p_22 (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
299. 0.026 0.026 ↑ 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.013..0.013 rows=1 loops=2)

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

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

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

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

303. 21.948 87.792 ↓ 0.0 0 5,487

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

304. 0.000 65.844 ↓ 0.0 0 5,487

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

305. 5.487 65.844 ↓ 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.012..0.012 rows=0 loops=5,487)

  • Recheck Cond: ((name_)::text = 'originatorID'::text)
  • Filter: ((text_)::character(12) = '27192'::bpchar)
306. 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)
307. 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
308. 0.000 0.000 ↓ 0.0 0

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

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

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

310. 0.000 181.071 ↓ 0.0 0 5,487

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

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

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

312. 10.974 181.071 ↓ 0.0 0 5,487

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

313. 76.818 76.818 ↑ 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.014 rows=1 loops=5,487)

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

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

  • Filter: ((personid = '27192'::bpchar) AND (rolename = 'Onboard'::bpchar))
  • Rows Removed by Filter: 208
315. 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))
316. 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))
317. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (personid = pe.personid)
318. 16.461 203.019 ↑ 1.2 18 5,487

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

319. 71.331 71.331 ↑ 1.0 1 5,487

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

  • Index Cond: (personid = pe.personid)
320. 115.227 115.227 ↑ 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.014..0.021 rows=18 loops=5,487)

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

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

322. 5.463 257.889 ↑ 1.0 1 5,487

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

323. 5.449 186.558 ↑ 1.0 1 5,487

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

  • Join Filter: (pcr_2.companyid = pe_11.companyid)
324. 76.818 76.818 ↑ 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.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))
  • Rows Removed by Filter: 0
325. 104.291 104.291 ↑ 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.019..0.019 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
326. 65.868 65.868 ↑ 1.0 1 5,489

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

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

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

328. 0.000 406.038 ↓ 0.0 0 5,487

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

  • Join Filter: (pcr_3.personcustomerreltype = pcrt_2.personcustomerreltype)
329. 21.843 406.038 ↓ 0.0 0 5,487

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

330. 65.844 356.655 ↑ 1.0 1 5,487

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

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

Seq Scan on customer_struct cs (cost=0.00..4.03 rows=88 width=8) (actual time=0.003..0.038 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
332. 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
333. 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
334. 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))
335. 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)

336. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (personid = pe.personid)
337. 76.818 76.818 ↑ 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.014..0.014 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
338. 76.062 76.062 ↑ 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.014 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
339. 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
340. 1.513 3.489 ↑ 1.0 6,980 1

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

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

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

Planning time : 42.138 ms
Execution time : 12,380.272 ms