explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SKva

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

Limit (cost=1,000.42..6,458.94 rows=1 width=4) (actual time=14.303..14.303 rows=0 loops=1)

2. 5.004 15.652 ↓ 0.0 0 1

Gather (cost=1,000.42..6,458.94 rows=1 width=4) (actual time=14.302..15.652 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.152 10.648 ↓ 0.0 0 3

Nested Loop (cost=0.42..5,458.84 rows=1 width=4) (actual time=10.648..10.648 rows=0 loops=3)

4. 10.493 10.493 ↑ 1.4 48 3

Parallel Seq Scan on slr_employee (cost=0.00..5,294.27 rows=65 width=4) (actual time=6.956..10.493 rows=48 loops=3)

  • Filter: ((deleted_by_employee_id IS NULL) AND (ent_id = 7391))
  • Rows Removed by Filter: 58944
5. 0.003 0.003 ↓ 0.0 0 144

Index Scan using slr_candidate_pkey on slr_candidate (cost=0.42..2.52 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=144)

  • Index Cond: (id = slr_employee.candidate_id)
  • Filter: ((birth_date = '1961-03-11'::date) AND (upper((fname)::text) = 'Музафарова'::text) AND (upper((iname)::text) = 'Гавхар'::text) AND (upper((oname)::text) = 'Магафуровна'::text))
  • Rows Removed by Filter: 1