explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OXiY

Settings
# exclusive inclusive rows x rows loops node
1. 3.013 6.106 ↑ 103.5 6 1

Hash Join (cost=807.22..2,583.43 rows=621 width=53) (actual time=1.022..6.106 rows=6 loops=1)

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

Seq Scan on safekids.participant part (cost=0.00..1,667.00 rows=41,600 width=4) (actual time=0.723..3.051 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.042 ↑ 103.5 6 1

Hash (cost=799.45..799.45 rows=621 width=53) (actual time=0.041..0.042 rows=6 loops=1)

  • Output: per.id, per.firstname, per.lastname, per.patrname
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=14
4. 0.021 0.039 ↑ 103.5 6 1

Bitmap Heap Scan on safekids.person per (cost=44.81..799.45 rows=621 width=53) (actual time=0.020..0.039 rows=6 loops=1)

  • Output: per.id, per.firstname, per.lastname, per.patrname
  • Recheck Cond: (fullname_vector(per.lastname, per.firstname, per.patrname) @@ '''кисел'' | ''юд'' | ''петровн'''::tsquery)
  • Heap Blocks: exact=4
  • Buffers: shared hit=14
5. 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
Planning time : 0.231 ms
Execution time : 6.152 ms