explain.depesz.com

A tool for finding a real cause for slow queries.

Result: eov : books with subselect

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 34.826 99.478 ↑ 1.0 7144 1

HashAggregate (cost=2287.70..2360.08 rows=7238 width=17) (actual time=96.086..99.478 rows=7144 loops=1)

  • Output: author.name
  • Buffers: shared hit=756
2. 0.000 64.652 ↑ 1.0 7144 1

Hash Semi Join (cost=1062.47..2269.60 rows=7238 width=17) (actual time=52.067..64.652 rows=7144 loops=1)

  • Output: author.name
  • Hash Cond: ((author.title)::text = (book.title)::text)
  • Buffers: shared hit=756
3. 18.720 18.720 ↑ 1.0 50000 1

Seq Scan on stuff.author (cost=0.00..909.00 rows=50000 width=34) (actual time=0.009..18.720 rows=50000 loops=1)

  • Output: author.title, author.name
  • Buffers: shared hit=409
4. 0.000 52.022 ↑ 1.0 7144 1

Hash (cost=972.00..972.00 rows=7238 width=17) (actual time=52.022..52.022 rows=7144 loops=1)

  • Output: book.title
  • Buckets: 1024 Batches: 1 Memory Usage: 291kB
  • Buffers: shared hit=347
5. 95.623 95.623 ↑ 1.0 7144 1

Seq Scan on stuff.book (cost=0.00..972.00 rows=7238 width=17) (actual time=0.017..95.623 rows=7144 loops=1)

  • Output: book.title
  • Filter: ((book.genre)::text = 'romance'::text)
  • Buffers: shared hit=347