explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AntZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 3,587.339 ↓ 0.0 0 1

Unique (cost=10,439.47..10,439.57 rows=21 width=334) (actual time=3,587.339..3,587.339 rows=0 loops=1)

2. 0.006 3,587.339 ↓ 0.0 0 1

Sort (cost=10,439.47..10,439.52 rows=21 width=334) (actual time=3,587.339..3,587.339 rows=0 loops=1)

  • Sort Key: slr_cumulative_register.employee_id
  • Sort Method: quicksort Memory: 25kB
3. 0.001 3,587.333 ↓ 0.0 0 1

Nested Loop (cost=2.26..10,439.01 rows=21 width=334) (actual time=3,587.333..3,587.333 rows=0 loops=1)

4. 0.000 3,587.332 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.97..10,432.11 rows=21 width=335) (actual time=3,587.332..3,587.332 rows=0 loops=1)

  • Join Filter: (slr_position.staff_cat_id = slr_dct_staff_category.id)
5. 0.000 3,587.332 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.97..10,419.00 rows=21 width=207) (actual time=3,587.332..3,587.332 rows=0 loops=1)

6. 0.001 3,587.332 ↓ 0.0 0 1

Nested Loop (cost=1.69..10,412.54 rows=21 width=207) (actual time=3,587.332..3,587.332 rows=0 loops=1)

7. 0.000 3,587.331 ↓ 0.0 0 1

Nested Loop (cost=1.26..10,400.11 rows=21 width=130) (actual time=3,587.331..3,587.331 rows=0 loops=1)

8. 0.000 3,587.331 ↓ 0.0 0 1

Nested Loop (cost=0.84..10,388.97 rows=21 width=26) (actual time=3,587.331..3,587.331 rows=0 loops=1)

9. 3,587.331 3,587.331 ↓ 0.0 0 1

Index Scan using slr_cumulative_register_period_date on slr_cumulative_register (cost=0.42..10,333.37 rows=21 width=4) (actual time=3,587.331..3,587.331 rows=0 loops=1)

  • Index Cond: (period_date <= '2018-12-01'::date)
  • Filter: ((ent_id = 5683) AND ((period_date >= '2018-12-01'::date) OR ((period_date <= '2018-12-01'::date) AND (date_next > '2018-12-01'::date))))
  • Rows Removed by Filter: 146084
10. 0.000 0.000 ↓ 0.0 0

Index Scan using slr_employee_pkey on slr_employee (cost=0.42..2.64 rows=1 width=26) (never executed)

  • Index Cond: (id = slr_cumulative_register.employee_id)
11. 0.000 0.000 ↓ 0.0 0

Index Scan using slr_candidate_pkey on slr_candidate (cost=0.42..0.52 rows=1 width=108) (never executed)

  • Index Cond: (id = slr_employee.candidate_id)
12. 0.000 0.000 ↓ 0.0 0

Index Scan using slr_local_position_pkey on slr_local_position (cost=0.42..0.58 rows=1 width=81) (never executed)

  • Index Cond: (id = slr_employee.position_id)
13. 0.000 0.000 ↓ 0.0 0

Index Scan using slr_position_pkey on slr_position (cost=0.28..0.30 rows=1 width=8) (never executed)

  • Index Cond: (slr_local_position.cloud_position_id = id)
14. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..1.56 rows=37 width=136) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Seq Scan on slr_dct_staff_category (cost=0.00..1.37 rows=37 width=136) (never executed)

16. 0.000 0.000 ↓ 0.0 0

Index Scan using slr_manning_table_pkey on slr_manning_table (cost=0.29..0.32 rows=1 width=7) (never executed)

  • Index Cond: (id = slr_employee.manning_table_id)