explain.depesz.com

PostgreSQL's explain analyze made readable

Result: G9Xl

Settings
# exclusive inclusive rows x rows loops node
1. 7.219 532.725 ↓ 430.0 430 1

Unique (cost=566.91..567.96 rows=1 width=2,841) (actual time=524.698..532.725 rows=430 loops=1)

2. 5.846 525.506 ↓ 430.0 430 1

Sort (cost=566.91..566.91 rows=1 width=2,841) (actual time=524.697..525.506 rows=430 loops=1)

  • Sort Key: slr_employee.id, slr_employee.info_date_prev, slr_employee.info_date_next, slr_employee.created, slr_employee.modified, slr_employee.external_id, slr_employee.uuid, slr_employee.tab_num, slr_employee.tab_num_value, slr_employee.number, sl (...)
  • Sort Method: quicksort Memory: 893kB
3. 8.816 519.660 ↓ 430.0 430 1

Nested Loop Left Join (cost=3.53..566.90 rows=1 width=2,841) (actual time=7.731..519.660 rows=430 loops=1)

  • Join Filter: (slr_employee.territorial_id = slr_dct_territorial_cond.id)
  • Rows Removed by Join Filter: 4300
4. 3.785 503.104 ↓ 430.0 430 1

Nested Loop Left Join (cost=3.53..565.67 rows=1 width=2,723) (actual time=7.718..503.104 rows=430 loops=1)

  • Join Filter: (slr_employee.place_group_id = slr_dict_place_group.id)
  • Rows Removed by Join Filter: 1720
5. 2.135 483.839 ↓ 430.0 430 1

Nested Loop Left Join (cost=3.53..564.58 rows=1 width=2,486) (actual time=7.705..483.839 rows=430 loops=1)

  • Join Filter: (slr_employee.regional_factor_id = slr_regional_factor.id)
  • Rows Removed by Join Filter: 4730
6. 7.382 476.974 ↓ 430.0 430 1

Nested Loop Left Join (cost=3.53..563.33 rows=1 width=2,472) (actual time=7.688..476.974 rows=430 loops=1)

  • Join Filter: (slr_employee.job_character_id = slr_dct_job_character.id)
  • Rows Removed by Join Filter: 9890
7. 1.812 467.872 ↓ 430.0 430 1

Nested Loop Left Join (cost=3.53..561.97 rows=1 width=2,400) (actual time=7.670..467.872 rows=430 loops=1)

  • Join Filter: (slr_employee.trial_period_result_id = slr_dict_trial_period_result.id)
  • Rows Removed by Join Filter: 2150
8. 1.248 457.460 ↓ 430.0 430 1

Nested Loop (cost=3.53..560.86 rows=1 width=2,292) (actual time=7.656..457.460 rows=430 loops=1)

9. 1.293 449.332 ↓ 430.0 430 1

Nested Loop (cost=3.24..558.34 rows=1 width=2,194) (actual time=7.636..449.332 rows=430 loops=1)

10. 7.411 428.689 ↓ 430.0 430 1

Nested Loop Left Join (cost=2.81..555.69 rows=1 width=2,029) (actual time=7.621..428.689 rows=430 loops=1)

  • Join Filter: (slr_employee.dismissal_source_id = slr_dct_dismissal_source.id)
  • Rows Removed by Join Filter: 40271
11. 23.178 389.458 ↓ 430.0 430 1

Nested Loop Left Join (cost=2.81..548.71 rows=1 width=1,624) (actual time=7.564..389.458 rows=430 loops=1)

12. 1.214 318.980 ↓ 430.0 430 1

Nested Loop Left Join (cost=2.39..548.12 rows=1 width=1,459) (actual time=0.083..318.980 rows=430 loops=1)

13. 3.279 312.606 ↓ 430.0 430 1

Nested Loop Left Join (cost=1.97..547.63 rows=1 width=1,278) (actual time=0.076..312.606 rows=430 loops=1)

14. 1.117 241.387 ↓ 430.0 430 1

Nested Loop Left Join (cost=1.55..547.15 rows=1 width=1,097) (actual time=0.064..241.387 rows=430 loops=1)

15. 1.028 132.340 ↓ 430.0 430 1

Nested Loop (cost=1.13..544.50 rows=1 width=1,028) (actual time=0.053..132.340 rows=430 loops=1)

16. 16.590 76.702 ↓ 430.0 430 1

Nested Loop (cost=0.71..541.86 rows=1 width=525) (actual time=0.040..76.702 rows=430 loops=1)

17. 40.762 40.762 ↓ 430.0 430 1

Index Scan using slr_employee_department_id on slr_employee (cost=0.42..539.34 rows=1 width=181) (actual time=0.027..40.762 rows=430 loops=1)

  • Index Cond: (department_id = ANY ('{12295,17738,17739,17740,17741,17742,17743,17744,17745,17746,17747,17748,17749,17750,17751,17752,17753,17754,17755,17756,17 (...)
  • Filter: ((deleted_by_employee_id IS NULL) AND (admission_date <= '2019-03-31'::date) AND ((lay_off_date IS NULL) OR (lay_off_date >= '2018-12-31'::date)) AND (...)
18. 19.350 19.350 ↑ 1.0 1 430

Index Scan using slr_departmen_pkey on slr_departmen (cost=0.29..2.51 rows=1 width=344) (actual time=0.044..0.045 rows=1 loops=430)

  • Index Cond: (id = slr_employee.department_id)
19. 54.610 54.610 ↑ 1.0 1 430

Index Scan using slr_candidate_pkey on slr_candidate (cost=0.42..2.64 rows=1 width=503) (actual time=0.126..0.127 rows=1 loops=430)

  • Index Cond: (id = slr_employee.candidate_id)
20. 107.930 107.930 ↑ 1.0 1 430

Index Scan using slr_worker_pkey on slr_worker (cost=0.42..2.64 rows=1 width=69) (actual time=0.251..0.251 rows=1 loops=430)

  • Index Cond: (slr_employee.worker_id = id)
21. 67.940 67.940 ↑ 1.0 1 430

Index Scan using slr_employee_pkey on slr_employee t6 (cost=0.42..0.47 rows=1 width=181) (actual time=0.158..0.158 rows=1 loops=430)

  • Index Cond: (slr_worker.first_employee_id = id)
22. 5.160 5.160 ↑ 1.0 1 430

Index Scan using slr_employee_pkey on slr_employee t7 (cost=0.42..0.47 rows=1 width=181) (actual time=0.012..0.012 rows=1 loops=430)

  • Index Cond: (slr_worker.last_employee_id = id)
23. 47.300 47.300 ↑ 1.0 1 430

Index Scan using slr_local_position_pkey on slr_local_position (cost=0.42..0.58 rows=1 width=165) (actual time=0.110..0.110 rows=1 loops=430)

  • Index Cond: (t7.position_id = id)
24. 31.820 31.820 ↓ 1.1 94 430

Seq Scan on slr_dct_dismissal_source (cost=0.00..5.88 rows=88 width=405) (actual time=0.007..0.074 rows=94 loops=430)

25. 19.350 19.350 ↑ 1.0 1 430

Index Scan using slr_local_position_pkey on slr_local_position t10 (cost=0.42..2.64 rows=1 width=165) (actual time=0.045..0.045 rows=1 loops=430)

  • Index Cond: (id = slr_employee.position_id)
26. 6.880 6.880 ↑ 1.0 1 430

Index Scan using slr_manning_table_pkey on slr_manning_table (cost=0.29..2.51 rows=1 width=98) (actual time=0.015..0.016 rows=1 loops=430)

  • Index Cond: (id = slr_employee.manning_table_id)
27. 8.600 8.600 ↑ 1.0 5 430

Seq Scan on slr_dict_trial_period_result (cost=0.00..1.05 rows=5 width=108) (actual time=0.019..0.020 rows=5 loops=430)

28. 1.720 1.720 ↓ 1.4 23 430

Seq Scan on slr_dct_job_character (cost=0.00..1.16 rows=16 width=72) (actual time=0.001..0.004 rows=23 loops=430)

29. 4.730 4.730 ↑ 1.0 11 430

Seq Scan on slr_regional_factor (cost=0.00..1.11 rows=11 width=14) (actual time=0.010..0.011 rows=11 loops=430)

30. 15.480 15.480 ↑ 1.0 4 430

Seq Scan on slr_dict_place_group (cost=0.00..1.04 rows=4 width=237) (actual time=0.035..0.036 rows=4 loops=430)

31. 7.740 7.740 ↑ 1.0 10 430

Seq Scan on slr_dct_territorial_cond (cost=0.00..1.10 rows=10 width=118) (actual time=0.017..0.018 rows=10 loops=430)