explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GxAn

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.030 ↓ 0.0 0 1

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

2. 0.001 0.030 ↓ 0.0 0 1

Bitmap Heap Scan on slr_past_periods_employees (cost=51.68..55.70 rows=1 width=200) (actual time=0.030..0.030 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 = 5583) AND (job_type = 1) AND (((position_name)::text = 'Младший воспитатель'::text) OR ((position_name)::text = ''::text)))
3. 0.001 0.029 ↓ 0.0 0 1

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

4. 0.028 0.028 ↓ 0.0 0 1

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

  • Index Cond: ((name)::text = 'Белякова Надежда Михайловна'::text)
5. 0.000 0.000 ↓ 0.0 0

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

6. 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)
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

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)