explain.depesz.com

A tool for finding a real cause for slow queries.

Result: ehYO

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

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

  • Output: id, movies
  • Recheck Cond: (actors.movies @> '{1}'::integer[])
2. 0.882 0.882 ↓ 47.1 471 1

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

  • Index Cond: (actors.movies @> '{1}'::integer[])