explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8yiE : Optimization for: plan #Mmr6

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.002 0.108 ↓ 0.0 0 1

Limit (cost=52.13..64.18 rows=1 width=381) (actual time=0.108..0.108 rows=0 loops=1)

2. 0.000 0.106 ↓ 0.0 0 1

Nested Loop (cost=52.13..64.18 rows=1 width=381) (actual time=0.106..0.106 rows=0 loops=1)

3. 0.002 0.106 ↓ 0.0 0 1

Bitmap Heap Scan on slr_past_periods_employees (cost=51.71..55.73 rows=1 width=200) (actual time=0.106..0.106 rows=0 loops=1)

  • Recheck Cond: (((name)::text = 'Барамыкова Альмира Шамильевна'::text) AND (((department_name)::text = 'Мбдоу "детский сад №38 им.н.к.крупской" змр рт'::text) OR ((department_name):: (...)
  • 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.104 ↓ 0.0 0 1

BitmapAnd (cost=51.71..51.71 rows=1 width=0) (actual time=0.104..0.104 rows=0 loops=1)

5. 0.104 0.104 ↓ 0.0 0 1

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

  • Index Cond: ((name)::text = 'Барамыкова Альмира Шамильевна'::text)
6. 0.000 0.000 ↓ 0.0 0

BitmapOr (cost=46.58..46.58 rows=729 width=0) (never executed)

7. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((department_name)::text = 'Мбдоу "детский сад №38 им.н.к.крупской" змр рт'::text)
8. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on slr_dep (cost=0.00..23.29 rows=365 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)