explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fITQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1.092 ↓ 4.0 4 1

Nested Loop (cost=0.29..10.48 rows=1 width=53) (actual time=0.088..1.092 rows=4 loops=1)

  • Output: part.case_id, per.firstname, per.lastname, per.patrname
  • Inner Unique: true
  • Buffers: shared hit=130
2. 0.015 0.015 ↓ 43.0 43 1

Seq Scan on safekids.participant part (cost=0.00..1.01 rows=1 width=8) (actual time=0.011..0.015 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. 1.075 1.075 ↓ 0.0 0 43

Index Scan using person_pkey on safekids.person per (cost=0.29..9.06 rows=1 width=53) (actual time=0.025..0.025 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(per.lastname, per.firstname, per.patrname) @@ to_tsquery('Киселев | Юдита | Петровна'::text))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=129
Planning time : 0.171 ms
Execution time : 1.117 ms