explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D0Ho

Settings

Optimization(s) for this plan:

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

Limit (cost=0.42..10,720.71 rows=1 width=4) (actual time=114.794..114.794 rows=0 loops=1)

2. 0.001 114.793 ↓ 0.0 0 1

Nested Loop (cost=0.42..10,720.71 rows=1 width=4) (actual time=114.793..114.793 rows=0 loops=1)

3. 114.792 114.792 ↓ 0.0 0 1

Seq Scan on slr_employee (cost=0.00..10,161.39 rows=67 width=4) (actual time=114.792..114.792 rows=0 loops=1)

  • Filter: ((deleted_by_employee_id IS NULL) AND (ent_id = 1389))
  • Rows Removed by Filter: 309022
4. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (id = slr_employee.candidate_id)
  • Filter: ((birth_date = '1948-09-24'::date) AND (upper((fname)::text) = 'ВасильÐΜва'::text) AND (upper((iname)::text) = 'НадÐΜжда'::text) AND (upper((oname)::text) = 'ГригорьÐΜвна'::text))