explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dbTG

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 0.793 ↓ 3.0 3 1

Nested Loop (cost=10.26..18.29 rows=1 width=187) (actual time=0.778..0.793 rows=3 loops=1)

  • Output: c.id, c.name
  • Inner Unique: true
  • Buffers: shared hit=142
2. 0.004 0.772 ↓ 3.0 3 1

HashAggregate (cost=9.85..9.86 rows=1 width=4) (actual time=0.771..0.772 rows=3 loops=1)

  • Output: part.case_id
  • Group Key: part.case_id
  • Buffers: shared hit=130
3. 0.025 0.768 ↓ 3.0 3 1

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

  • Output: part.case_id
  • Inner Unique: true
  • Buffers: shared hit=130
4. 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
5. 0.731 0.731 ↓ 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.017..0.017 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
6. 0.009 0.009 ↑ 1.0 1 3

Index Scan using case_pkey on safekids."case" c (cost=0.41..8.43 rows=1 width=187) (actual time=0.003..0.003 rows=1 loops=3)

  • Output: c.id, c.category_id, c.create_dt, c.steal_dt, c.state_id, c.direction_id, c.executor_id, c.country_id, c.central_authority_id, c.fabula, c.delete_dt, c.name
  • Index Cond: (c.id = part.case_id)
  • Buffers: shared hit=12
Planning time : 0.436 ms
Execution time : 0.833 ms