explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DqJE

Settings
# exclusive inclusive rows x rows loops node
1. 4.749 46.192 ↓ 56.0 56 1

Nested Loop Left Join (cost=9.22..241.19 rows=1 width=1,828) (actual time=5.051..46.192 rows=56 loops=1)

2. 0.138 33.323 ↓ 56.0 56 1

Nested Loop Left Join (cost=8.80..225.88 rows=1 width=2,413) (actual time=4.907..33.323 rows=56 loops=1)

3. 0.217 33.129 ↓ 56.0 56 1

Nested Loop Left Join (cost=8.39..217.16 rows=1 width=2,420) (actual time=4.882..33.129 rows=56 loops=1)

  • Join Filter: ((t4_0.peo_id = t26_0.peo_id) AND (t4_0.client_id = t26_0.client_id) AND (t4_0.location_code = t26_0.location_code))
4. 0.182 32.520 ↓ 56.0 56 1

Nested Loop Left Join (cost=8.10..208.84 rows=1 width=2,426) (actual time=4.842..32.520 rows=56 loops=1)

5. 0.345 31.834 ↓ 56.0 56 1

Nested Loop Left Join (cost=7.82..200.50 rows=1 width=2,255) (actual time=4.799..31.834 rows=56 loops=1)

  • Join Filter: ((t4_0.peo_id = t24_0.peo_id) AND (t4_0.client_id = t24_0.client_id) AND (t4_0.job_code = t24_0.job_code))
  • Rows Removed by Join Filter: 560
6. 0.163 30.425 ↓ 56.0 56 1

Nested Loop Left Join (cost=7.40..192.05 rows=1 width=2,227) (actual time=4.746..30.425 rows=56 loops=1)

  • Join Filter: ((t5_0.peo_id = t23_0.peo_id) AND (t5_0.client_id = t23_0.client_id) AND (t5_0.work_shift = t23_0.shift_code))
  • Rows Removed by Join Filter: 56
7. 0.172 29.926 ↓ 56.0 56 1

Nested Loop Left Join (cost=7.13..183.74 rows=1 width=2,231) (actual time=4.711..29.926 rows=56 loops=1)

  • Join Filter: ((t5_0.peo_id = t22_0.peo_id) AND (t5_0.client_id = t22_0.client_id) AND (t5_0.pay_group = t22_0.pay_group))
  • Rows Removed by Join Filter: 56
8. 0.149 29.306 ↓ 56.0 56 1

Nested Loop Left Join (cost=6.84..175.41 rows=1 width=2,217) (actual time=4.679..29.306 rows=56 loops=1)

  • Join Filter: ((t3_0.peo_id = t21_0.peo_id) AND (t3_0.ethnic_code = t21_0.eeo_ethnic_code))
  • Rows Removed by Join Filter: 280
9. 0.140 28.149 ↓ 56.0 56 1

Nested Loop Left Join (cost=6.84..171.17 rows=1 width=2,203) (actual time=4.644..28.149 rows=56 loops=1)

10. 0.169 27.953 ↓ 56.0 56 1

Nested Loop Left Join (cost=6.43..162.46 rows=1 width=2,189) (actual time=4.619..27.953 rows=56 loops=1)

  • Join Filter: ((t4_0.peo_id = t19_0.peo_id) AND (t4_0.client_id = t19_0.client_id) AND (t4_0.benefit_group = t19_0.group_id))
11. 0.127 27.392 ↓ 56.0 56 1

Nested Loop Left Join (cost=6.14..154.14 rows=1 width=2,180) (actual time=4.585..27.392 rows=56 loops=1)

  • Join Filter: ((t4_0.client_id = t18_0.client_id) AND (t4_0.peo_id = t18_0.peo_id) AND (t4_0.work_group_code = t18_0.work_group))
12. 0.000 26.985 ↓ 56.0 56 1

Nested Loop Left Join (cost=5.87..145.82 rows=1 width=2,168) (actual time=4.560..26.985 rows=56 loops=1)

  • Join Filter: ((t4_0.peo_id = t17_0.peo_id) AND (t4_0.client_id = t17_0.client_id) AND (t4_0.union_code = t17_0.union_code))
13. 0.118 22.590 ↓ 56.0 56 1

Nested Loop Left Join (cost=5.60..137.51 rows=1 width=2,156) (actual time=4.535..22.590 rows=56 loops=1)

  • Join Filter: ((t4_0.peo_id = t16_0.peo_id) AND (t4_0.type_code = t16_0.type_code))
14. 0.132 21.744 ↓ 56.0 56 1

Nested Loop Left Join (cost=5.60..133.87 rows=1 width=2,138) (actual time=4.505..21.744 rows=56 loops=1)

  • Join Filter: ((t4_0.peo_id = t15_0.peo_id) AND (t4_0.status_code = t15_0.status_code))
15. 0.135 20.716 ↓ 56.0 56 1

Nested Loop Left Join (cost=5.60..128.33 rows=1 width=2,119) (actual time=4.473..20.716 rows=56 loops=1)

  • Join Filter: ((t4_0.peo_id = t14_0.peo_id) AND (t4_0.client_id = t14_0.client_id) AND (t4_0.division_code = t14_0.division_code))
16. 0.336 20.301 ↓ 56.0 56 1

Nested Loop Left Join (cost=5.31..120.01 rows=1 width=2,107) (actual time=4.446..20.301 rows=56 loops=1)

  • Join Filter: ((t4_0.peo_id = t13_0.peo_id) AND (t4_0.client_id = t13_0.client_id) AND (t4_0.dept_code = t13_0.dept_code))
  • Rows Removed by Join Filter: 672
17. 0.223 19.125 ↓ 56.0 56 1

Nested Loop Left Join (cost=5.03..111.68 rows=1 width=2,093) (actual time=4.402..19.125 rows=56 loops=1)

18. 0.173 14.534 ↓ 56.0 56 1

Nested Loop Left Join (cost=4.75..102.61 rows=1 width=1,990) (actual time=4.373..14.534 rows=56 loops=1)

19. 0.165 14.361 ↓ 56.0 56 1

Nested Loop Left Join (cost=4.33..93.90 rows=1 width=1,967) (actual time=4.355..14.361 rows=56 loops=1)

20. 0.179 13.748 ↓ 56.0 56 1

Nested Loop Left Join (cost=3.92..85.18 rows=1 width=1,944) (actual time=4.322..13.748 rows=56 loops=1)

21. 0.168 13.569 ↓ 56.0 56 1

Nested Loop Left Join (cost=3.51..76.46 rows=1 width=1,922) (actual time=4.298..13.569 rows=56 loops=1)

22. 0.126 13.401 ↓ 56.0 56 1

Nested Loop Left Join (cost=3.10..67.75 rows=1 width=1,899) (actual time=4.281..13.401 rows=56 loops=1)

23. 0.157 13.219 ↓ 56.0 56 1

Nested Loop (cost=2.68..59.03 rows=1 width=1,876) (actual time=4.262..13.219 rows=56 loops=1)

24. 0.193 12.446 ↓ 56.0 56 1

Nested Loop Left Join (cost=2.40..50.72 rows=1 width=945) (actual time=4.228..12.446 rows=56 loops=1)

  • Join Filter: ((t0_0.employee_id = t5_0.employee_id) AND (t0_0.peo_id = t5_0.peo_id) AND (t0_0.client_id = t5_0.client_id))
25. 0.161 11.693 ↓ 56.0 56 1

Nested Loop Left Join (cost=1.98..42.25 rows=1 width=871) (actual time=4.193..11.693 rows=56 loops=1)

  • Join Filter: ((t0_0.employee_id = t4_0.employee_id) AND (t0_0.peo_id = t4_0.peo_id) AND (t0_0.client_id = t4_0.client_id))
26. 0.169 6.884 ↓ 56.0 56 1

Nested Loop (cost=1.55..33.79 rows=1 width=663) (actual time=0.139..6.884 rows=56 loops=1)

27. 0.222 6.211 ↓ 56.0 56 1

Nested Loop (cost=1.13..25.34 rows=1 width=496) (actual time=0.112..6.211 rows=56 loops=1)

28. 0.268 5.541 ↓ 56.0 56 1

Nested Loop Left Join (cost=0.85..16.91 rows=1 width=397) (actual time=0.085..5.541 rows=56 loops=1)

  • Join Filter: ((t0_0.employee_id = t1_0.employee_id) AND (t0_0.client_id = t1_0.client_id) AND (t0_0.peo_id = t1_0.peo_id) AND (t0_0.plan_id = t1_0.plan_id))
  • Rows Removed by Join Filter: 424
29. 0.143 0.143 ↓ 54.0 54 1

Index Scan using pk_employee_ben on employee_ben t0_0 (cost=0.42..8.45 rows=1 width=301) (actual time=0.038..0.143 rows=54 loops=1)

  • Index Cond: ((peo_id = 'rmi.corp'::text) AND (client_id = '909999'::text) AND (employee_id = 'Z00362'::text))
30. 5.130 5.130 ↓ 8.0 8 54

Index Scan using pk_employee_ben_detail on employee_ben_detail t1_0 (cost=0.42..8.45 rows=1 width=122) (actual time=0.014..0.095 rows=8 loops=54)

  • Index Cond: ((peo_id = 'rmi.corp'::text) AND (client_id = '909999'::text) AND (employee_id = 'Z00362'::text))
31. 0.448 0.448 ↑ 1.0 1 56

Index Scan using pk_benefit_plans on benefit_plans t2_0 (cost=0.28..8.30 rows=1 width=115) (actual time=0.008..0.008 rows=1 loops=56)

  • Index Cond: ((peo_id = 'rmi.corp'::text) AND (plan_id = t0_0.plan_id))
32. 0.504 0.504 ↑ 1.0 1 56

Index Scan using pk_employee_per on employee_per t3_0 (cost=0.42..8.44 rows=1 width=174) (actual time=0.009..0.009 rows=1 loops=56)

  • Index Cond: ((peo_id = 'rmi.corp'::text) AND (employee_id = 'Z00362'::text))
33. 4.648 4.648 ↑ 1.0 1 56

Index Scan using pk_employee_com on employee_com t4_0 (cost=0.42..8.44 rows=1 width=215) (actual time=0.083..0.083 rows=1 loops=56)

  • Index Cond: ((peo_id = 'rmi.corp'::text) AND (client_id = '909999'::text) AND (employee_id = 'Z00362'::text))
34. 0.560 0.560 ↑ 1.0 1 56

Index Scan using pk_employee_pay on employee_pay t5_0 (cost=0.42..8.44 rows=1 width=81) (actual time=0.010..0.010 rows=1 loops=56)

  • Index Cond: ((peo_id = 'rmi.corp'::text) AND (client_id = '909999'::text) AND (employee_id = 'Z00362'::text))
35. 0.616 0.616 ↑ 1.0 1 56

Index Scan using pk_client_master on client_master t6_0 (cost=0.29..8.30 rows=1 width=936) (actual time=0.011..0.011 rows=1 loops=56)

  • Index Cond: ((peo_id = 'rmi.corp'::text) AND (client_id = '909999'::text))
36. 0.056 0.056 ↓ 0.0 0 56

Index Scan using pk_hrp_users on hrp_users t7_0 (cost=0.41..8.43 rows=1 width=37) (actual time=0.001..0.001 rows=0 loops=56)

  • Index Cond: ((t6_0.peo_id = peo_id) AND (peo_id = 'rmi.corp'::text) AND (t6_0.ben_rep = user_id))
37. 0.000 0.000 ↓ 0.0 0 56

Index Scan using pk_hrp_users on hrp_users t8_0 (cost=0.41..8.43 rows=1 width=37) (actual time=0.000..0.000 rows=0 loops=56)

  • Index Cond: ((t6_0.peo_id = peo_id) AND (peo_id = 'rmi.corp'::text) AND (t6_0.broker = user_id))
38. 0.000 0.000 ↓ 0.0 0 56

Index Scan using pk_hrp_users on hrp_users t9_0 (cost=0.41..8.43 rows=1 width=37) (actual time=0.000..0.000 rows=0 loops=56)

  • Index Cond: ((t6_0.peo_id = peo_id) AND (peo_id = 'rmi.corp'::text) AND (t6_0.consultant = user_id))
39. 0.448 0.448 ↑ 1.0 1 56

Index Scan using pk_hrp_users on hrp_users t10_0 (cost=0.41..8.43 rows=1 width=37) (actual time=0.008..0.008 rows=1 loops=56)

  • Index Cond: ((t6_0.peo_id = peo_id) AND (peo_id = 'rmi.corp'::text) AND (t6_0.payroll_rep = user_id))
40. 0.000 0.000 ↓ 0.0 0 56

Index Scan using pk_hrp_users on hrp_users t11_0 (cost=0.41..8.43 rows=1 width=37) (actual time=0.000..0.000 rows=0 loops=56)

  • Index Cond: ((t6_0.peo_id = peo_id) AND (peo_id = 'rmi.corp'::text) AND (t6_0.salesperson = user_id))
41. 4.368 4.368 ↑ 1.0 1 56

Index Scan using pk_employer_master on employer_master t12_0 (cost=0.28..8.30 rows=1 width=113) (actual time=0.078..0.078 rows=1 loops=56)

  • Index Cond: ((t6_0.peo_id = peo_id) AND (peo_id = 'rmi.corp'::text) AND (t6_0.employer_id = employer_id))
42. 0.840 0.840 ↓ 13.0 13 56

Index Scan using pk_dept_codes on dept_codes t13_0 (cost=0.29..8.31 rows=1 width=29) (actual time=0.011..0.015 rows=13 loops=56)

  • Index Cond: ((peo_id = 'rmi.corp'::text) AND (client_id = '909999'::text))
43. 0.280 0.280 ↓ 0.0 0 56

Index Scan using pk_division_codes on division_codes t14_0 (cost=0.28..8.30 rows=1 width=26) (actual time=0.005..0.005 rows=0 loops=56)

  • Index Cond: ((peo_id = 'rmi.corp'::text) AND (client_id = '909999'::text))
44. 0.896 0.896 ↑ 3.0 1 56

Seq Scan on employee_status_codes t15_0 (cost=0.00..5.50 rows=3 width=28) (actual time=0.016..0.016 rows=1 loops=56)

  • Filter: (peo_id = 'rmi.corp'::text)
  • Rows Removed by Filter: 107
45. 0.728 0.728 ↑ 2.0 1 56

Seq Scan on employee_type_codes t16_0 (cost=0.00..3.61 rows=2 width=26) (actual time=0.013..0.013 rows=1 loops=56)

  • Filter: (peo_id = 'rmi.corp'::text)
  • Rows Removed by Filter: 85
46. 0.000 4.256 ↓ 0.0 0 56

Index Scan using pk_union_codes on union_codes t17_0 (cost=0.27..8.29 rows=1 width=28) (actual time=0.076..0.076 rows=0 loops=56)

  • Index Cond: ((peo_id = 'rmi.corp'::text) AND (client_id = '909999'::text))
47. 0.448 0.448 ↑ 1.0 1 56

Index Scan using pk_hrp_users on hrp_users t10_0 (cost=0.41..8.43 rows=1 width=37) (actual time=0.008..0.008 rows=1 loops=56)

  • Index Cond: ((t6_0.peo_id = peo_id) AND (peo_id = 'rmi.corp'::text) AND (t6_0.payroll_rep = user_id))
48. 0.000 0.000 ↓ 0.0 0 56

Index Scan using pk_hrp_users on hrp_users t11_0 (cost=0.41..8.43 rows=1 width=37) (actual time=0.000..0.000 rows=0 loops=56)

  • Index Cond: ((t6_0.peo_id = peo_id) AND (peo_id = 'rmi.corp'::text) AND (t6_0.salesperson = user_id))
49. 4.368 4.368 ↑ 1.0 1 56

Index Scan using pk_employer_master on employer_master t12_0 (cost=0.28..8.30 rows=1 width=113) (actual time=0.078..0.078 rows=1 loops=56)

  • Index Cond: ((t6_0.peo_id = peo_id) AND (peo_id = 'rmi.corp'::text) AND (t6_0.employer_id = employer_id))
50. 0.840 0.840 ↓ 13.0 13 56

Index Scan using pk_dept_codes on dept_codes t13_0 (cost=0.29..8.31 rows=1 width=29) (actual time=0.011..0.015 rows=13 loops=56)

  • Index Cond: ((peo_id = 'rmi.corp'::text) AND (client_id = '909999'::text))
51. 0.280 0.280 ↓ 0.0 0 56

Index Scan using pk_division_codes on division_codes t14_0 (cost=0.28..8.30 rows=1 width=26) (actual time=0.005..0.005 rows=0 loops=56)

  • Index Cond: ((peo_id = 'rmi.corp'::text) AND (client_id = '909999'::text))
52. 0.896 0.896 ↑ 3.0 1 56

Seq Scan on employee_status_codes t15_0 (cost=0.00..5.50 rows=3 width=28) (actual time=0.016..0.016 rows=1 loops=56)

  • Filter: (peo_id = 'rmi.corp'::text)
  • Rows Removed by Filter: 107
53. 0.728 0.728 ↑ 2.0 1 56

Seq Scan on employee_type_codes t16_0 (cost=0.00..3.61 rows=2 width=26) (actual time=0.013..0.013 rows=1 loops=56)

  • Filter: (peo_id = 'rmi.corp'::text)
  • Rows Removed by Filter: 85
54. 4.256 4.256 ↓ 0.0 0 56

Index Scan using pk_union_codes on union_codes t17_0 (cost=0.27..8.29 rows=1 width=28) (actual time=0.076..0.076 rows=0 loops=56)

  • Index Cond: ((peo_id = 'rmi.corp'::text) AND (client_id = '909999'::text))
55. 0.280 0.280 ↓ 0.0 0 56

Index Scan using pk_work_groups on work_groups t18_0 (cost=0.28..8.29 rows=1 width=29) (actual time=0.005..0.005 rows=0 loops=56)

  • Index Cond: ((peo_id = 'rmi.corp'::text) AND (client_id = '909999'::text))
56. 0.392 0.392 ↑ 1.0 1 56

Index Scan using pk_benefit_groups on benefit_groups t19_0 (cost=0.29..8.30 rows=1 width=21) (actual time=0.007..0.007 rows=1 loops=56)

  • Index Cond: ((peo_id = 'rmi.corp'::text) AND (client_id = '909999'::text))
57. 0.056 0.056 ↓ 0.0 0 56

Index Scan using pk_hrp_users on hrp_users t20_0 (cost=0.41..8.43 rows=1 width=28) (actual time=0.001..0.001 rows=0 loops=56)

  • Index Cond: ((t4_0.peo_id = peo_id) AND (peo_id = 'rmi.corp'::text) AND (t4_0.reports_to = user_id))
58. 1.008 1.008 ↑ 1.0 6 56

Seq Scan on eeo_ethnic_codes t21_0 (cost=0.00..4.15 rows=6 width=28) (actual time=0.017..0.018 rows=6 loops=56)

  • Filter: (peo_id = 'rmi.corp'::text)
  • Rows Removed by Filter: 117
59. 0.448 0.448 ↓ 2.0 2 56

Index Scan using pk_pay_groups on pay_groups t22_0 (cost=0.29..8.30 rows=1 width=27) (actual time=0.007..0.008 rows=2 loops=56)

  • Index Cond: ((peo_id = 'rmi.corp'::text) AND (client_id = '909999'::text))
60. 0.336 0.336 ↑ 1.0 1 56

Index Scan using pk_shift_codes on shift_codes t23_0 (cost=0.28..8.30 rows=1 width=20) (actual time=0.006..0.006 rows=1 loops=56)

  • Index Cond: ((peo_id = 'rmi.corp'::text) AND (client_id = '909999'::text))
61. 1.064 1.064 ↓ 11.0 11 56

Index Scan using pk_job_codes on job_codes t24_0 (cost=0.41..8.43 rows=1 width=40) (actual time=0.012..0.019 rows=11 loops=56)

  • Index Cond: ((peo_id = 'rmi.corp'::text) AND (client_id = '909999'::text))
62. 0.504 0.504 ↑ 1.0 1 56

Index Scan using pk_job_code_master on job_code_master t25_0 (cost=0.28..8.30 rows=1 width=186) (actual time=0.009..0.009 rows=1 loops=56)

  • Index Cond: ((t24_0.peo_id = peo_id) AND (peo_id = 'rmi.corp'::text) AND (t24_0.job_class = pos_class))
63. 0.392 0.392 ↑ 1.0 1 56

Index Scan using pk_location_codes on location_codes t26_0 (cost=0.29..8.31 rows=1 width=17) (actual time=0.007..0.007 rows=1 loops=56)

  • Index Cond: ((peo_id = 'rmi.corp'::text) AND (client_id = '909999'::text))
64. 0.056 0.056 ↓ 0.0 0 56

Index Only Scan using pk_hrp_users on hrp_users t27_0 (cost=0.41..8.43 rows=1 width=14) (actual time=0.001..0.001 rows=0 loops=56)

  • Index Cond: ((peo_id = t6_0.peo_id) AND (peo_id = 'rmi.corp'::text) AND (user_id = t6_0.cl_coor))
  • Heap Fetches: 0
65. 1.288 1.288 ↑ 1.0 1 56

Index Scan using pk_company_benefits on company_benefits t28_0 (cost=0.41..8.48 rows=1 width=26) (actual time=0.019..0.023 rows=1 loops=56)

  • Index Cond: ((t0_0.peo_id = peo_id) AND (peo_id = 'rmi.corp'::text) AND (t0_0.client_id = client_id) AND (client_id = '909999'::text) AND (t0_0.plan_id = plan_id))
66.          

SubPlan (for Nested Loop Left Join)

67. 0.168 5.880 ↑ 16.7 6 56

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.102..0.105 rows=6 loops=56)

68. 5.712 5.712 ↑ 16.7 6 56

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.101..0.102 rows=6 loops=56)

69. 0.000 0.000 ↑ 1.0 1 56

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=56)

70. 0.280 0.504 ↑ 14.3 7 56

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.004..0.009 rows=7 loops=56)

71. 0.224 0.224 ↑ 14.3 7 56

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.003..0.004 rows=7 loops=56)

72. 0.000 0.000 ↑ 1.0 1 56

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=56)

73. 0.224 0.448 ↑ 14.3 7 56

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.004..0.008 rows=7 loops=56)

74. 0.224 0.224 ↑ 14.3 7 56

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.003..0.004 rows=7 loops=56)

75. 0.000 0.000 ↑ 1.0 1 56

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=56)

Planning time : 104.613 ms
Execution time : 47.858 ms