explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OMxy

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 70.632 ↓ 0.0 0 1

Limit (cost=1,112.91..46,779.35 rows=1 width=378) (actual time=70.632..70.632 rows=0 loops=1)

2. 0.001 70.630 ↓ 0.0 0 1

Nested Loop (cost=1,112.91..46,779.35 rows=1 width=378) (actual time=70.630..70.630 rows=0 loops=1)

3. 57.580 70.629 ↓ 0.0 0 1

Bitmap Heap Scan on slr_past_periods_employees (cost=1,112.49..46,774.90 rows=1 width=197) (actual time=70.629..70.629 rows=0 loops=1)

  • Recheck Cond: (employee_id IS NOT NULL)
  • Filter: ((ent_id = 1400) AND ((name)::text = '1231231'::text) AND (job_type = 1) AND (((position_name)::text = 'asdasds'::text) OR ((position_name)::text = 'dojfhsdjf'::text)) AND (((department_name)::text = 'asdasd'::text) OR ((department_na (...)
  • Rows Removed by Filter: 55360
  • Heap Blocks: exact=3808
4. 13.049 13.049 ↓ 1.0 55,914 1

Bitmap Index Scan on slr_past_periods_employees_employee_id (cost=0.00..1,112.48 rows=53,341 width=0) (actual time=13.049..13.049 rows=55,914 loops=1)

  • Index Cond: (employee_id IS NOT NULL)
5. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (id = slr_past_periods_employees.employee_id)
Planning time : 1.624 ms
Execution time : 70.725 ms