explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ML9co

Settings
# exclusive inclusive rows x rows loops node
1. 0.764 21.944 ↓ 56.0 56 1

Nested Loop Left Join (cost=9.22..241.18 rows=1 width=1,828) (actual time=1.004..21.944 rows=56 loops=1)

2. 0.148 17.148 ↓ 56.0 56 1

Nested Loop Left Join (cost=8.80..225.87 rows=1 width=2,413) (actual time=0.857..17.148 rows=56 loops=1)

3. 0.305 16.944 ↓ 56.0 56 1

Nested Loop Left Join (cost=8.39..217.15 rows=1 width=2,420) (actual time=0.830..16.944 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.173 16.247 ↓ 56.0 56 1

Nested Loop Left Join (cost=8.10..208.82 rows=1 width=2,426) (actual time=0.795..16.247 rows=56 loops=1)

5. 0.314 15.570 ↓ 56.0 56 1

Nested Loop Left Join (cost=7.82..200.49 rows=1 width=2,255) (actual time=0.760..15.570 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.162 14.192 ↓ 56.0 56 1

Nested Loop Left Join (cost=7.40..192.04 rows=1 width=2,227) (actual time=0.709..14.192 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.170 13.694 ↓ 56.0 56 1

Nested Loop Left Join (cost=7.13..183.72 rows=1 width=2,231) (actual time=0.676..13.694 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.198 13.076 ↓ 56.0 56 1

Nested Loop Left Join (cost=6.84..175.40 rows=1 width=2,217) (actual time=0.643..13.076 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.129 11.926 ↓ 56.0 56 1

Nested Loop Left Join (cost=6.84..171.16 rows=1 width=2,203) (actual time=0.608..11.926 rows=56 loops=1)

10. 0.000 11.741 ↓ 56.0 56 1

Nested Loop Left Join (cost=6.43..162.44 rows=1 width=2,189) (actual time=0.584..11.741 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.116 11.186 ↓ 56.0 56 1

Nested Loop Left Join (cost=6.14..154.12 rows=1 width=2,180) (actual time=0.549..11.186 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.151 10.790 ↓ 56.0 56 1

Nested Loop Left Join (cost=5.87..145.81 rows=1 width=2,168) (actual time=0.522..10.790 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.104 10.415 ↓ 56.0 56 1

Nested Loop Left Join (cost=5.60..137.50 rows=1 width=2,156) (actual time=0.501..10.415 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.166 9.583 ↓ 56.0 56 1

Nested Loop Left Join (cost=5.60..133.86 rows=1 width=2,138) (actual time=0.474..9.583 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.137 8.577 ↓ 56.0 56 1

Nested Loop Left Join (cost=5.60..128.31 rows=1 width=2,119) (actual time=0.443..8.577 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.385 8.160 ↓ 56.0 56 1

Nested Loop Left Join (cost=5.31..119.99 rows=1 width=2,107) (actual time=0.416..8.160 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.183 6.991 ↓ 56.0 56 1

Nested Loop Left Join (cost=5.03..111.67 rows=1 width=2,093) (actual time=0.375..6.991 rows=56 loops=1)

18. 0.175 6.416 ↓ 56.0 56 1

Nested Loop Left Join (cost=4.75..102.60 rows=1 width=1,990) (actual time=0.344..6.416 rows=56 loops=1)

19. 0.171 6.241 ↓ 56.0 56 1

Nested Loop Left Join (cost=4.33..93.88 rows=1 width=1,967) (actual time=0.326..6.241 rows=56 loops=1)

20. 0.161 5.622 ↓ 56.0 56 1

Nested Loop Left Join (cost=3.92..85.17 rows=1 width=1,944) (actual time=0.286..5.622 rows=56 loops=1)

21. 0.164 5.461 ↓ 56.0 56 1

Nested Loop Left Join (cost=3.51..76.45 rows=1 width=1,922) (actual time=0.266..5.461 rows=56 loops=1)

22. 0.177 5.297 ↓ 56.0 56 1

Nested Loop Left Join (cost=3.10..67.73 rows=1 width=1,899) (actual time=0.248..5.297 rows=56 loops=1)

23. 0.149 5.120 ↓ 56.0 56 1

Nested Loop (cost=2.68..59.02 rows=1 width=1,876) (actual time=0.232..5.120 rows=56 loops=1)

24. 0.185 4.355 ↓ 56.0 56 1

Nested Loop (cost=2.40..50.70 rows=1 width=945) (actual time=0.199..4.355 rows=56 loops=1)

25. 0.115 3.610 ↓ 56.0 56 1

Nested Loop (cost=1.98..42.25 rows=1 width=871) (actual time=0.166..3.610 rows=56 loops=1)

26. 0.159 2.823 ↓ 56.0 56 1

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

27. 0.222 2.160 ↓ 56.0 56 1

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

28. 0.275 1.490 ↓ 56.0 56 1

Nested Loop Left Join (cost=0.85..16.91 rows=1 width=397) (actual time=0.082..1.490 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.135 0.135 ↓ 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.036..0.135 rows=54 loops=1)

  • Index Cond: ((peo_id = 'rmi.corp'::text) AND (client_id = '909999'::text) AND (employee_id = 'Z00362'::text))
30. 1.080 1.080 ↓ 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.020 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. 0.672 0.672 ↑ 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.011..0.012 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.000 0.000 ↓ 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.000..0.000 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. 0.392 0.392 ↑ 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.007..0.007 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.784 0.784 ↓ 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.014 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.840 0.840 ↑ 3.0 1 56

Seq Scan on employee_status_codes t15_0 (cost=0.00..5.50 rows=3 width=28) (actual time=0.015..0.015 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.224 0.224 ↓ 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.004..0.004 rows=0 loops=56)

  • Index Cond: ((peo_id = 'rmi.corp'::text) AND (client_id = '909999'::text))
47. 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))
48. 0.000 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))
49. 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))
50. 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))
51. 0.392 0.392 ↑ 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.007..0.007 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))
52. 0.784 0.784 ↓ 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.014 rows=13 loops=56)

  • Index Cond: ((peo_id = 'rmi.corp'::text) AND (client_id = '909999'::text))
53. 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))
54. 0.840 0.840 ↑ 3.0 1 56

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

  • Filter: (peo_id = 'rmi.corp'::text)
  • Rows Removed by Filter: 107
55. 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
56. 0.224 0.224 ↓ 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.004..0.004 rows=0 loops=56)

  • Index Cond: ((peo_id = 'rmi.corp'::text) AND (client_id = '909999'::text))
57. 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))
58. 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))
59. 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))
60. 0.952 0.952 ↑ 1.0 6 56

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

  • Filter: (peo_id = 'rmi.corp'::text)
  • Rows Removed by Filter: 117
61. 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))
62. 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))
63. 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.011..0.019 rows=11 loops=56)

  • Index Cond: ((peo_id = 'rmi.corp'::text) AND (client_id = '909999'::text))
64. 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))
65. 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))
66. 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
67. 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))
68.          

SubPlan (for Nested Loop Left Join)

69. 0.112 1.848 ↑ 16.7 6 56

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

70. 1.736 1.736 ↑ 16.7 6 56

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

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

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

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

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

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

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

77. 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 : 41.992 ms
Execution time : 23.585 ms