explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9tk : Optimization for: Optimization for: plan #Mmr6; plan #8yiE

Settings

Optimization path:

# 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.000 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.002 0.033 ↓ 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.033 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.001 0.031 ↓ 0.0 0 1

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

5. 0.030 0.030 ↓ 0.0 0 1

Bitmap Index Scan on slr_name (cost=0.00..4.88 rows=43 width=0) (actual time=0.030..0.030 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 = 'Мбдоу "детский сад №38 им.н.к.крупской" змр рт'::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)