explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dJFi

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.785 ↓ 3.0 3 1

Nested Loop (cost=0.29..9.85 rows=1 width=4) (actual time=0.197..0.785 rows=3 loops=1)

  • Output: part.case_id
  • Inner Unique: true
  • Buffers: shared hit=130
2. 0.012 0.012 ↓ 43.0 43 1

Seq Scan on safekids.participant part (cost=0.00..1.01 rows=1 width=8) (actual time=0.009..0.012 rows=43 loops=1)

  • Output: part.id, part.case_id, part.person_id, part.participant_type_id, part.participant_status_id, part.status_type_id
  • Buffers: shared hit=1
3. 0.774 0.774 ↓ 0.0 0 43

Index Scan using person_pkey on safekids.person per (cost=0.29..8.81 rows=1 width=4) (actual time=0.018..0.018 rows=0 loops=43)

  • Output: per.id, per.gender_id, per.firstname, per.lastname, per.patrname, per.birth_dt, per.birth_year, per.citizenship_id, per.birthplace, per.address_reg, per.address_fact, per.employment_type_id, per.employment_place, per.phone, per.email, per.social_links, per.mother_initials, per.father_initials, per.employment_existence, per.employment_status, per.employment_dt, per.contacts
  • Index Cond: (per.id = part.person_id)
  • Filter: (fullname_vector(per.lastname, per.firstname, per.patrname) @@ to_tsquery('Киселев | Юдит | Петровна'::text))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=129
Planning time : 0.236 ms
Execution time : 0.802 ms