explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Uu1l : Optimization for: plan #D0Ho

Settings

Optimization path:

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

Limit (cost=5.36..812.36 rows=1 width=4) (actual time=0.056..0.056 rows=0 loops=1)

2. 0.000 0.055 ↓ 0.0 0 1

Nested Loop (cost=5.36..812.36 rows=1 width=4) (actual time=0.055..0.055 rows=0 loops=1)

3. 0.003 0.055 ↓ 0.0 0 1

Bitmap Heap Scan on slr_employee (cost=4.94..253.03 rows=67 width=4) (actual time=0.055..0.055 rows=0 loops=1)

  • Recheck Cond: (ent_id = 1389)
  • Filter: (deleted_by_employee_id IS NULL)
4. 0.052 0.052 ↓ 0.0 0 1

Bitmap Index Scan on slr_employee_ent_id (cost=0.00..4.92 rows=67 width=0) (actual time=0.052..0.052 rows=0 loops=1)

  • Index Cond: (ent_id = 1389)
5. 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))
Planning time : 1.524 ms
Execution time : 0.153 ms