explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1TQC : With R_PersonPeers

Settings
# exclusive inclusive rows x rows loops node
1. 15.181 11,132.863 ↓ 5.6 5,429 1

Sort (cost=1,099,788.28..1,099,790.69 rows=964 width=84) (actual time=11,132.616..11,132.863 rows=5,429 loops=1)

  • Sort Key: (btrim((pn.lname)::text))
  • Sort Method: quicksort Memory: 618kB
2. 7.261 11,117.682 ↓ 5.6 5,429 1

Hash Left Join (cost=2,473.25..1,099,740.50 rows=964 width=84) (actual time=24.776..11,117.682 rows=5,429 loops=1)

  • Hash Cond: (pn.personid = pi.personid)
3. 7.075 11,110.398 ↓ 5.8 5,429 1

Nested Loop (cost=2,469.92..1,099,731.22 rows=940 width=39) (actual time=24.729..11,110.398 rows=5,429 loops=1)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SubPlan (for Index Scan)

13. 32.574 10,955.722 ↑ 27.0 1 5,429

Hash Join (cost=385.48..418.39 rows=27 width=0) (actual time=2.018..2.018 rows=1 loops=5,429)

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

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

15. 0.000 32.574 ↓ 0.0 0 5,429

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

16. 0.000 32.574 ↓ 0.0 0 5,429

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

17. 32.574 32.574 ↓ 0.0 0 5,429

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

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

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

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

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

20. 21.716 157.441 ↑ 1.7 15 5,429

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

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

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

22. 54.290 54.290 ↑ 1.7 15 5,429

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

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

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

24. 10.858 10.858 ↑ 1.0 1 5,429

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

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

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

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

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

  • Index Cond: ((negative = true) AND ((domainobject)::text = 'PersonCompensationItem'::text) AND ((action)::text = 'Read'::text) AND (companyid = pe.companyid))
  • Filter: negative
27. 5.429 10,711.417 ↑ 16.0 3 5,429

Hash (cost=384.32..384.32 rows=48 width=32) (actual time=1.973..1.973 rows=3 loops=5,429)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
28. 10.858 10,705.988 ↑ 16.0 3 5,429

Subquery Scan on rpa (cost=383.36..384.32 rows=48 width=32) (actual time=1.971..1.972 rows=3 loops=5,429)

29. 65.148 10,695.130 ↑ 16.0 3 5,429

HashAggregate (cost=383.36..383.84 rows=48 width=176) (actual time=1.970..1.970 rows=3 loops=5,429)

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

Append (cost=0.98..382.64 rows=48 width=176) (actual time=0.076..1.958 rows=20 loops=5,429)

31. 5.429 21.716 ↓ 0.0 0 5,429

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

32. 0.000 16.287 ↓ 0.0 0 5,429

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

33. 16.287 16.287 ↓ 0.0 0 5,429

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

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

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

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

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

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

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

37. 0.000 385.459 ↑ 2.0 1 5,429

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

38. 21.716 385.459 ↑ 2.0 1 5,429

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

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

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

40. 0.000 157.441 ↑ 1.0 1 5,429

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

41. 10.832 119.438 ↑ 1.0 1 5,429

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

42. 5.403 97.722 ↑ 1.0 1 5,429

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

43. 5.325 81.435 ↑ 1.0 1 5,429

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

44. 32.574 32.574 ↑ 1.0 1 5,429

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

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

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

  • Index Cond: ((companyid = pe_2.companyid) AND (personid = '27192'::bpchar))
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 6
46. 10.884 10.884 ↑ 1.0 1 5,442

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

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

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

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

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

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

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

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

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

51. 0.000 130.296 ↑ 1.0 1 5,429

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

52. 5.429 119.438 ↑ 1.0 1 5,429

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

53. 10.852 108.580 ↑ 1.0 1 5,429

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

54. 5.425 65.148 ↑ 1.0 1 5,429

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

55. 38.003 38.003 ↑ 1.0 1 5,429

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

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

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

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

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

  • Index Cond: ((companyid = pd_1.companyid) AND (personid = '27192'::bpchar))
  • Filter: ((CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 6
58. 5.429 5.429 ↑ 1.0 1 5,429

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

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

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

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

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

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

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

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

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

63. 5.429 135.725 ↓ 0.0 0 5,429

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

64. 0.000 70.577 ↓ 0.0 0 5,429

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

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

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

66. 0.000 65.148 ↓ 0.0 0 5,429

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

67. 0.000 65.148 ↓ 0.0 0 5,429

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

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

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

69. 38.003 38.003 ↑ 1.0 1 5,429

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

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

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

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

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

72. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

76. 0.000 21.716 ↓ 0.0 0 5,429

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

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

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

78. 0.000 21.716 ↓ 0.0 0 5,429

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

79. 0.000 21.716 ↓ 0.0 0 5,429

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

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

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

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

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

82. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

87. 5.429 32.574 ↓ 0.0 0 5,429

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

88. 0.000 27.145 ↓ 0.0 0 5,429

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

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

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

90. 27.145 27.145 ↓ 0.0 0 5,429

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

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

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

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

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

93. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

96. 10.858 249.734 ↓ 0.0 0 5,429

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

97. 0.000 86.864 ↓ 0.0 0 5,429

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

98. 0.000 86.864 ↓ 0.0 0 5,429

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

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

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

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

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

101. 27.145 27.145 ↑ 1.0 1 5,429

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

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

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

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

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

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

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

105. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

108. 0.000 38.003 ↓ 0.0 0 5,429

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

109. 0.000 38.003 ↓ 0.0 0 5,429

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

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

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

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

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

112. 32.574 32.574 ↓ 0.0 0 5,429

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

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

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

114. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

117. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

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

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

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

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

124. 5.429 59.719 ↓ 0.0 0 5,429

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

125. 0.000 54.290 ↓ 0.0 0 5,429

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

126. 5.421 54.290 ↓ 0.0 0 5,429

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

127. 27.145 27.145 ↑ 1.0 1 5,429

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

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

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

129. 5.431 21.724 ↓ 0.0 0 5,431

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

130. 0.000 16.293 ↓ 0.0 0 5,431

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

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

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

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

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

133. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

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

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

139. 0.000 48.861 ↓ 0.0 0 5,429

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

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

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

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

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

142. 27.145 27.145 ↑ 1.0 1 5,429

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

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

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

  • Index Cond: ((positionid = op_2.positionid) AND (posorgreltype = 'Member'::bpchar))
  • Filter: ((effectivedate <= enddate) AND (CURRENT_DATE <= enddate) AND ((op_2.createts = op_2.endts) OR (createts = endts)) AND (((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts)) OR (createts = endts)))
  • Rows Removed by Filter: 1
144. 0.028 0.028 ↓ 0.0 0 7

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

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

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

146. 0.000 0.000 ↓ 0.0 0

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

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

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

148. 5.429 124.867 ↓ 0.0 0 5,429

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

149. 5.429 86.864 ↓ 0.0 0 5,429

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

150. 0.000 81.435 ↓ 0.0 0 5,429

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

151. 0.000 81.435 ↓ 0.0 0 5,429

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

152. 0.000 81.435 ↓ 0.0 0 5,429

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

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

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

154. 5.431 54.290 ↑ 1.0 1 5,429

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

155. 38.003 38.003 ↑ 1.0 1 5,429

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

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

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

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

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

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

Seq Scan on person_pay_unit_rel_type ppurt (cost=0.00..1.06 rows=6 width=70) (never executed)

159. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

162. 0.000 32.574 ↓ 0.0 0 5,429

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

163. 10.858 32.574 ↓ 0.0 0 5,429

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

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

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

165. 0.000 16.287 ↓ 0.0 0 5,429

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

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

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

167. 0.000 16.287 ↓ 0.0 0 5,429

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

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

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

169. 16.287 16.287 ↓ 0.0 0 5,429

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

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

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

  • Index Cond: (payunitid = pp_5.payunitid)
171. 0.000 0.000 ↓ 0.0 0

Seq Scan on person_pay_unit_rel_type ppurt_1 (cost=0.00..1.06 rows=6 width=70) (never executed)

172. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

176. 5.429 10.858 ↓ 0.0 0 5,429

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

177. 5.429 5.429 ↓ 0.0 0 5,429

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

178. 0.000 0.000 ↓ 0.0 0 5,429

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

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

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

180. 0.021 0.021 ↑ 1.0 1 1

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

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

Index Scan using personemploymentenddate on person_employment pe_8 (cost=0.42..21.48 rows=4 width=13) (actual time=0.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
182. 0.000 0.000 ↓ 0.0 0 5,429

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

183. 0.000 0.000 ↓ 0.0 0 5,429

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

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

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

185. 0.001 0.038 ↓ 0.0 0 1

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

186. 0.007 0.007 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

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

191. 0.000 0.000 ↓ 0.0 0 5,429

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

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

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

193. 0.002 0.014 ↓ 0.0 0 1

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

194. 0.005 0.005 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

Subquery Scan on r_personpeers (cost=36.44..36.49 rows=2 width=180) (actual time=1.313..1.313 rows=0 loops=5,429)

199. 5.429 7,128.277 ↓ 0.0 0 5,429

Unique (cost=36.44..36.47 rows=2 width=232) (actual time=1.313..1.313 rows=0 loops=5,429)

200. 10.858 7,122.848 ↓ 0.0 0 5,429

Sort (cost=36.44..36.44 rows=2 width=232) (actual time=1.312..1.312 rows=0 loops=5,429)

  • Sort Key: mypos.personid, p_16.personid, ('Peer '::character(8)), ('RoleEx_Peer '::character(20)), p_16.companyid, p_16.customerid
  • Sort Method: quicksort Memory: 25kB
201. 10.858 7,111.990 ↓ 0.0 0 5,429

Append (cost=1.59..36.43 rows=2 width=232) (actual time=1.310..1.310 rows=0 loops=5,429)

202. 0.000 7,035.984 ↓ 0.0 0 5,429

Nested Loop (cost=1.59..22.72 rows=1 width=154) (actual time=1.296..1.296 rows=0 loops=5,429)

203. 1,350.817 7,035.984 ↓ 0.0 0 5,429

Nested Loop (cost=1.30..20.40 rows=1 width=26) (actual time=1.296..1.296 rows=0 loops=5,429)

  • Join Filter: (mypos.positionid = manager.topositionid)
  • Rows Removed by Join Filter: 4435
204. 11.852 103.151 ↑ 5.0 1 5,429

Nested Loop (cost=1.00..16.49 rows=5 width=34) (actual time=0.018..0.019 rows=1 loops=5,429)

  • Join Filter: (peers.personid <> mypos.personid)
  • Rows Removed by Join Filter: 0
205. 10.858 54.290 ↑ 1.0 1 5,429

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

206. 27.145 27.145 ↑ 1.0 1 5,429

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

  • 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
207. 16.287 16.287 ↑ 1.0 1 5,429

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

  • 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
208. 37.009 37.009 ↑ 7.0 1 5,287

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

  • Index Cond: ((personid = '27192'::bpchar) AND (CURRENT_DATE <= enddate) AND (CURRENT_DATE >= effectivedate))
  • Filter: ((CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 2
209. 5,582.016 5,582.016 ↓ 455.5 4,555 5,286

Index Scan using pos_posposendeffendts on pos_pos manager (cost=0.29..0.66 rows=10 width=8) (actual time=0.008..1.056 rows=4,555 loops=5,286)

  • 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
210. 0.006 0.006 ↑ 1.0 1 1

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

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

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

212. 5.418 65.148 ↓ 0.0 0 5,429

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

213. 5.429 54.290 ↑ 1.0 1 5,429

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

214. 38.003 38.003 ↑ 1.0 1 5,429

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

  • 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
215. 10.858 10.858 ↑ 10.0 1 5,429

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

  • 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
216. 5.440 5.440 ↓ 0.0 0 5,440

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

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

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

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

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

219. 5.429 130.296 ↓ 0.0 0 5,429

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

220. 5.429 70.577 ↓ 0.0 0 5,429

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

221. 0.000 65.148 ↓ 0.0 0 5,429

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

222. 0.426 65.148 ↓ 0.0 0 5,429

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

223. 10.858 48.861 ↑ 1.0 1 5,429

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

224. 27.145 27.145 ↑ 1.0 1 5,429

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

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

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

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

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

  • Index Cond: (positionid = p_p.positionid)
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '27192'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 1
227. 0.072 0.072 ↑ 1.0 1 12

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

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

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

229. 0.000 5.429 ↓ 0.0 0 5,429

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

230. 0.000 5.429 ↓ 0.0 0 5,429

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

231. 5.429 5.429 ↓ 0.0 0 5,429

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

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

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

  • Join Filter: (p_19.personid <> pp_9.personid)
233. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

236. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

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

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

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

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

241. 0.000 43.432 ↓ 0.0 0 5,429

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

242. 0.000 43.432 ↓ 0.0 0 5,429

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

243. 10.858 43.432 ↓ 0.0 0 5,429

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

244. 27.145 27.145 ↑ 1.0 1 5,429

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

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

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

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

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

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

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

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

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

249. 0.000 255.163 ↓ 0.0 0 5,429

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

250. 5.429 81.435 ↓ 0.0 0 5,429

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

251. 0.000 76.006 ↓ 0.0 0 5,429

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

252. 0.000 76.006 ↓ 0.0 0 5,429

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

253. 5.787 76.006 ↓ 0.0 0 5,429

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

254. 11.142 59.719 ↑ 1.0 1 5,429

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

255. 5.428 38.003 ↑ 1.0 1 5,429

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

256. 27.145 27.145 ↑ 1.0 1 5,429

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

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

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

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

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

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

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

  • Index Cond: (positionid = p1_1.positionid)
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '27192'::bpchar) AND (CURRENT_DATE < enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 1
260. 0.085 0.085 ↑ 1.0 1 17

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

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

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

262. 0.017 0.017 ↑ 1.0 1 17

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

263. 0.017 0.017 ↑ 1.0 1 17

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

264. 0.000 92.293 ↓ 0.0 0 5,429

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

265. 5.419 92.293 ↓ 0.0 0 5,429

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

266. 0.000 86.864 ↓ 0.0 0 5,429

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

267. 0.720 86.864 ↓ 0.0 0 5,429

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

268. 5.787 70.577 ↑ 1.0 1 5,429

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

269. 5.571 54.290 ↑ 1.0 1 5,429

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

270. 10.857 43.432 ↑ 1.0 1 5,429

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

271. 27.145 27.145 ↑ 1.0 1 5,429

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

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

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

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

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

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

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

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

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

  • Index Cond: (positionid = p1_2.positionid)
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '27192'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 2
276. 0.050 0.050 ↑ 1.0 1 10

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

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

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

278. 0.000 0.000 ↑ 1.0 1 10

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

279. 0.000 0.000 ↑ 1.0 1 10

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

280. 0.000 81.435 ↓ 0.0 0 5,429

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

281. 0.000 81.435 ↓ 0.0 0 5,429

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

282. 0.000 81.435 ↓ 0.0 0 5,429

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

283. 4.319 81.435 ↓ 0.0 0 5,429

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

284. 5.669 76.006 ↓ 0.0 0 5,429

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

285. 5.608 65.148 ↑ 1.0 1 5,429

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

286. 5.571 54.290 ↑ 1.0 1 5,429

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

287. 10.857 43.432 ↑ 1.0 1 5,429

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

288. 27.145 27.145 ↑ 1.0 1 5,429

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (positionid = p1_3.positionid)
  • Filter: ((persposrel = 'Occupies'::bpchar) AND (personid = '27192'::bpchar) AND (CURRENT_DATE >= effectivedate) AND (CURRENT_DATE <= enddate) AND (CURRENT_TIMESTAMP >= createts) AND (CURRENT_TIMESTAMP <= endts))
  • Rows Removed by Filter: 3
294. 0.018 0.018 ↑ 1.0 1 2

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

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

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

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

297. 0.002 0.002 ↑ 1.0 1 2

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

298. 0.000 54.290 ↓ 0.0 0 5,429

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

299. 0.000 54.290 ↓ 0.0 0 5,429

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

300. 54.290 54.290 ↓ 0.0 0 5,429

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

  • Index Cond: ((name_)::text = 'originatorID'::text)
  • Filter: ((text_)::character(12) = '27192'::bpchar)
  • Rows Removed by Filter: 6
301. 0.000 0.000 ↓ 0.0 0

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

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

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

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

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

304. 5.429 92.293 ↓ 0.0 0 5,429

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

305. 0.000 86.864 ↓ 0.0 0 5,429

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

306. 38.003 86.864 ↓ 0.0 0 5,429

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

307. 32.574 32.574 ↑ 1.0 1 5,429

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

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

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

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

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

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

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

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

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

  • Index Cond: (personid = pe.personid)
312. 21.716 124.867 ↑ 1.0 18 5,429

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

313. 32.574 32.574 ↑ 1.0 1 5,429

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

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

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

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

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

316. 5.419 1,856.718 ↑ 1.0 1 5,429

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

317. 10.204 1,824.144 ↑ 1.0 1 5,429

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

318. 38.003 38.003 ↑ 1.0 1 5,429

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

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

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

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

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

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

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

  • Join Filter: (pcr_3.personcustomerreltype = pcrt_2.personcustomerreltype)
322. 5.429 16.287 ↓ 0.0 0 5,429

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

323. 0.000 10.858 ↓ 0.0 0 5,429

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

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

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

325. 10.858 10.858 ↓ 0.0 0 5,429

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

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

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

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

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

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

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

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

330. 0.003 0.023 ↓ 3.0 3 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
331. 0.004 0.020 ↓ 3.0 3 1

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

332. 0.004 0.004 ↓ 3.0 3 1

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

333. 0.012 0.012 ↑ 1.0 1 3

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

  • Index Cond: (documentid = pi.documentid)
Planning time : 237.232 ms
Execution time : 11,136.550 ms