explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wKfK

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 6.465 ↑ 124.2 5 1

Nested Loop (cost=2,585.39..3,475.77 rows=621 width=187) (actual time=6.449..6.465 rows=5 loops=1)

  • Output: c.id, c.name
  • Inner Unique: true
  • Buffers: shared hit=1285
2. 0.011 6.439 ↑ 124.2 5 1

HashAggregate (cost=2,584.98..2,591.19 rows=621 width=4) (actual time=6.435..6.439 rows=5 loops=1)

  • Output: part.case_id
  • Group Key: part.case_id
  • Buffers: shared hit=1265
3. 3.069 6.428 ↑ 103.5 6 1

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

  • Output: part.case_id
  • Inner Unique: true
  • Hash Cond: (part.person_id = per.id)
  • Buffers: shared hit=1265
4. 3.331 3.331 ↑ 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.846..3.331 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
5. 0.003 0.028 ↑ 103.5 6 1

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

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

Bitmap Heap Scan on safekids.person per (cost=44.81..799.45 rows=621 width=4) (actual time=0.021..0.025 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
7. 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
8. 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.423 ms
Execution time : 6.512 ms