#	exclusive	inclusive	rows x	rows	loops	node
1.	2.905	5.402	↓ 48.2	482	1	→ Bitmap Heap Scan on actors (cost=4.34..39.19 rows=10 width=228) (actual time=2.645..5.402 rows=482 loops=1) Recheck Cond: (movies @> '{1}'::integer[])
2.	2.497	2.497	↓ 48.2	482	1	→ Bitmap Index Scan on actor_index (cost=0.00..4.34 rows=10 width=0) (actual time=2.497..2.497 rows=482 loops=1) Index Cond: (movies @> '{1}'::integer[])

"Bitmap Heap Scan on actors  (cost=4.34..39.19 rows=10 width=228) (actual time=2.645..5.402 rows=482 loops=1)"
"  Recheck Cond: (movies @> '{1}'::integer[])"
"  ->  Bitmap Index Scan on actor_index  (cost=0.00..4.34 rows=10 width=0) (actual time=2.497..2.497 rows=482 loops=1)"
"        Index Cond: (movies @> '{1}'::integer[])"
"Total runtime: 5.546 ms"

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	2.905 ms	53.8 %
Bitmap Index Scan	1	2.497 ms	46.2 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
actors	1	2.905 ms	53.8 %
Bitmap Heap Scan	1	2.905 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: gbj

Colorize:

Columns visibility:

Per node type stats

Per table stats