#	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

"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"
"  ->  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"
"Total runtime: 5.582 ms"

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	2.890 ms	53.1 %
Bitmap Index Scan	1	2.550 ms	46.9 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
public.actors	1	2.890 ms	53.1 %
Bitmap Heap Scan	1	2.890 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: sWe

Colorize:

Columns visibility:

Per node type stats

Per table stats