explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2nUk

Settings
# exclusive inclusive rows x rows loops node
1. 3.033 6.595 ↑ 103.5 6 1

Hash Join (cost=807.22..2,583.43 rows=621 width=4) (actual time=1.214..6.595 rows=6 loops=1)

  • Output: part.case_id
  • Inner Unique: true
  • Hash Cond: (part.person_id = per.id)
  • Buffers: shared hit=1265
2. 3.533 3.533 ↑ 1.0 41,600 1

Seq Scan on safekids.participant part (cost=0.00..1,667.00 rows=41,600 width=8) (actual time=0.910..3.533 rows=41,600 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=1251
3. 0.003 0.029 ↑ 103.5 6 1

Hash (cost=799.45..799.45 rows=621 width=4) (actual time=0.029..0.029 rows=6 loops=1)

  • Output: per.id
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=14
4. 0.006 0.026 ↑ 103.5 6 1

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

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

  • Index Cond: (fullname_vector(per.lastname, per.firstname, per.patrname) @@ '''кисел'' | ''юд'' | ''петровн'''::tsquery)
  • Buffers: shared hit=10
Planning time : 0.388 ms
Execution time : 6.645 ms