explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EPCe

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.048 ↑ 103.5 6 1

Nested Loop (cost=45.10..3,108.62 rows=621 width=53) (actual time=0.030..0.048 rows=6 loops=1)

  • Output: per.id, per.firstname, per.lastname, per.patrname
  • Buffers: shared hit=33
2. 0.005 0.023 ↑ 103.5 6 1

Bitmap Heap Scan on safekids.person per (cost=44.81..799.45 rows=621 width=53) (actual time=0.021..0.023 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
3. 0.018 0.018 ↑ 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.018..0.018 rows=6 loops=1)

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

Index Only Scan using participant_person_ix on safekids.participant part (cost=0.29..3.71 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=6)

  • Output: part.person_id
  • Index Cond: (part.person_id = per.id)
  • Heap Fetches: 6
  • Buffers: shared hit=19
Planning time : 0.286 ms
Execution time : 0.075 ms