explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l94o

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.183 ↓ 0.0 0 1

Nested Loop (cost=0.97..17.03 rows=1 width=381) (actual time=0.183..0.183 rows=0 loops=1)

2. 0.183 0.183 ↓ 0.0 0 1

Index Scan using slr_past_periods_employees_ent_id_job_type_name_idx on slr_past_periods_employees (cost=0.55..8.57 rows=1 width=200) (actual time=0.183..0.183 rows=0 loops=1)

  • Index Cond: ((ent_id = 5583) AND (job_type = 1) AND ((name)::text = 'Белякова Надежда Михайловна'::text))
3. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (id = slr_past_periods_employees.employee_id)