explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R0M

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

Limit (cost=52.10..64.15 rows=1 width=381) (actual time=0.034..0.034 rows=0 loops=1)

2. 0.001 0.033 ↓ 0.0 0 1

Nested Loop (cost=52.10..64.15 rows=1 width=381) (actual time=0.033..0.033 rows=0 loops=1)

3. 0.000 0.032 ↓ 0.0 0 1

Bitmap Heap Scan on slr_past_periods_employees (cost=51.68..55.70 rows=1 width=200) (actual time=0.032..0.032 rows=0 loops=1)

  • Recheck Cond: (((name)::text = 'врач'::text) AND (((department_name)::text = 'главео'::text) OR ((department_name)::text = ''::text)))
  • Filter: ((employee_id IS NOT NULL) AND (ent_id = 7696) AND (job_type = 3) AND (((position_name)::text = 'врач'::text) OR ((position_name)::text = ''::text)))
4. 0.000 0.032 ↓ 0.0 0 1

BitmapAnd (cost=51.68..51.68 rows=1 width=0) (actual time=0.032..0.032 rows=0 loops=1)

5. 0.032 0.032 ↓ 0.0 0 1

Bitmap Index Scan on slr_name (cost=0.00..4.88 rows=43 width=0) (actual time=0.032..0.032 rows=0 loops=1)

  • Index Cond: ((name)::text = 'врач'::text)
6. 0.000 0.000 ↓ 0.0 0

BitmapOr (cost=46.55..46.55 rows=725 width=0) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on slr_dep (cost=0.00..23.27 rows=363 width=0) (never executed)

  • Index Cond: ((department_name)::text = 'главео'::text)
8. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on slr_dep (cost=0.00..23.27 rows=363 width=0) (never executed)

  • Index Cond: ((department_name)::text = ''::text)
9. 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)