explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LhmW

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.107 ↑ 124.2 5 1

Nested Loop (cost=4,678.59..5,568.96 rows=621 width=187) (actual time=0.087..0.107 rows=5 loops=1)

  • Output: c.id, c.name
  • Inner Unique: true
  • Buffers: shared hit=52
2. 0.009 0.082 ↑ 124.2 5 1

HashAggregate (cost=4,678.17..4,684.38 rows=621 width=4) (actual time=0.079..0.082 rows=5 loops=1)

  • Output: part.case_id
  • Group Key: part.case_id
  • Buffers: shared hit=32
3. 0.006 0.073 ↑ 103.5 6 1

Nested Loop (cost=45.10..4,676.62 rows=621 width=4) (actual time=0.048..0.073 rows=6 loops=1)

  • Output: part.case_id
  • Buffers: shared hit=32
4. 0.011 0.043 ↑ 103.5 6 1

Bitmap Heap Scan on safekids.person per (cost=44.81..799.45 rows=621 width=4) (actual time=0.037..0.043 rows=6 loops=1)

  • 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
  • Recheck Cond: (fullname_vector(per.lastname, per.firstname, per.patrname) @@ '''кисел'' | ''юд'' | ''петровн'''::tsquery)
  • Heap Blocks: exact=4
  • Buffers: shared hit=14
5. 0.032 0.032 ↑ 103.5 6 1

Bitmap Index Scan on person_func_name_trgm_idx (cost=0.00..44.66 rows=621 width=0) (actual time=0.032..0.032 rows=6 loops=1)

  • Index Cond: (fullname_vector(per.lastname, per.firstname, per.patrname) @@ '''кисел'' | ''юд'' | ''петровн'''::tsquery)
  • Buffers: shared hit=10
6. 0.024 0.024 ↑ 1.0 1 6

Index Scan using participant_person_ix on safekids.participant part (cost=0.29..6.23 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=6)

  • Output: part.id, part.case_id, part.person_id, part.participant_type_id, part.participant_status_id, part.status_type_id
  • Index Cond: (part.person_id = per.id)
  • Buffers: shared hit=18
7. 0.020 0.020 ↑ 1.0 1 5

Index Scan using case_pkey on safekids."case" c (cost=0.41..1.44 rows=1 width=187) (actual time=0.004..0.004 rows=1 loops=5)

  • 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=20
Planning time : 0.982 ms
Execution time : 0.197 ms