explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Mmr6

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.001 383.185 ↓ 0.0 0 1

Limit (cost=0.85..30,020.88 rows=1 width=380) (actual time=383.185..383.185 rows=0 loops=1)

2. 0.001 383.184 ↓ 0.0 0 1

Nested Loop (cost=0.85..30,020.88 rows=1 width=380) (actual time=383.184..383.184 rows=0 loops=1)

3. 383.183 383.183 ↓ 0.0 0 1

Index Scan using slr_past_periods_employees_employee_id on slr_past_periods_employees (cost=0.43..30,018.23 rows=1 width=199) (actual time=383.183..383.183 rows=0 loops=1)

  • Index Cond: (employee_id IS NOT NULL)
  • Filter: ((ent_id = 7696) AND ((name)::text = 'Барамыкова Альмира Шамильевна'::text) AND (job_type = 3) AND (((position_name)::text = 'Воспитатель'::text) OR ((position_name)::text = ''::text)) AND (((depa (...)
  • Rows Removed by Filter: 50960
4. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (id = slr_past_periods_employees.employee_id)
Planning time : 1.360 ms
Execution time : 383.294 ms