explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lvYf

Settings
# exclusive inclusive rows x rows loops node
1. 0.051 10.070 ↑ 25,804.0 1 1

Nested Loop (cost=1,578.16..9,371.84 rows=25,804 width=223) (actual time=10.069..10.070 rows=1 loops=1)

  • Output: c.id, c.name, similarity(c.name, 'аргентина'::text), phraseto_tsquery(c.name)
  • Inner Unique: true
  • Buffers: shared hit=613
2. 0.004 10.006 ↑ 200.0 1 1

HashAggregate (cost=1,577.75..1,579.75 rows=200 width=4) (actual time=10.005..10.006 rows=1 loops=1)

  • Output: part.case_id
  • Group Key: part.case_id
  • Buffers: shared hit=609
3. 0.131 10.002 ↑ 1,570.0 1 1

Hash Join (cost=1,544.00..1,573.82 rows=1,570 width=4) (actual time=10.000..10.002 rows=1 loops=1)

  • Output: part.case_id
  • Inner Unique: true
  • Hash Cond: (part.person_id = per.id)
  • Buffers: shared hit=609
4. 0.010 0.010 ↑ 1,570.0 1 1

Seq Scan on safekids.participant part (cost=0.00..25.70 rows=1,570 width=8) (actual time=0.009..0.010 rows=1 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=1
5. 5.332 9.861 ↑ 1.0 41,600 1

Hash (cost=1,024.00..1,024.00 rows=41,600 width=4) (actual time=9.861..9.861 rows=41,600 loops=1)

  • Output: per.id
  • Buckets: 65536 Batches: 1 Memory Usage: 1975kB
  • Buffers: shared hit=608
6. 4.529 4.529 ↑ 1.0 41,600 1

Seq Scan on safekids.person per (cost=0.00..1,024.00 rows=41,600 width=4) (actual time=0.007..4.529 rows=41,600 loops=1)

  • Output: per.id
  • Buffers: shared hit=608
7. 0.013 0.013 ↑ 1.0 1 1

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

  • 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=4
Planning time : 0.290 ms
Execution time : 10.307 ms