explain.depesz.com

A tool for finding a real cause for slow queries.

Result: sWe

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 2.890 5.440 ↓ 47.1 471 1

Bitmap Heap Scan on public.actors (cost=4.34..39.19 rows=10 width=228) (actual time=2.683..5.440 rows=471 loops=1)

  • Output: id, movies
  • Recheck Cond: (actors.movies @> '{1}'::integer[])
  • Buffers: shared hit=540
2. 2.550 2.550 ↓ 47.1 471 1

Bitmap Index Scan on actor_index (cost=0.00..4.34 rows=10 width=0) (actual time=2.550..2.550 rows=471 loops=1)

  • Index Cond: (actors.movies @> '{1}'::integer[])
  • Buffers: shared hit=293