#	exclusive	inclusive	rows x	rows	loops	node
1.	200.561	252.570	↓ 18,428.0	18,428	1	→ Bitmap Heap Scan on catalogue_simple_product (cost=9,556.43..66,610.43 rows=1 width=148) (actual time=53.312..252.570 rows=18,428 loops=1) Recheck Cond: (category_id = 5) Filter: ((attributes @> '{"model": "polo", "colors": ["red"]}'::jsonb) AND ((attributes -> 'sizes'::text) ?\| '{M,L}'::text[])) Rows Removed by Filter: 231572 Heap Blocks: exact=5962 Planning time: 0.240 ms Execution time: 253.871 ms
2.	52.009	52.009	↓ 1.0	250,000	1	→ Bitmap Index Scan on catalogue_simple_product_b583a629 (cost=0.00..9,556.42 rows=249,600 width=0) (actual time=52.009..52.009 rows=250,000 loops=1) Index Cond: (category_id = 5)

Bitmap Heap Scan on catalogue_simple_product  (cost=9556.43..66610.43 rows=1 width=148) (actual time=53.312..252.570 rows=18428 loops=1)
   Recheck Cond: (category_id = 5)
   Filter: ((attributes @> '{"model": "polo", "colors": ["red"]}'::jsonb) AND ((attributes -> 'sizes'::text) ?| '{M,L}'::text[]))
   Rows Removed by Filter: 231572
   Heap Blocks: exact=5962
   ->  Bitmap Index Scan on catalogue_simple_product_b583a629  (cost=0.00..9556.42 rows=249600 width=0) (actual time=52.009..52.009 rows=250000 loops=1)
         Index Cond: (category_id = 5)
 Planning time: 0.240 ms
 Execution time: 253.871 ms

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	200.561 ms	79.4 %
Bitmap Index Scan	1	52.009 ms	20.6 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
catalogue_simple_product	1	200.561 ms	79.4 %
Bitmap Heap Scan	1	200.561 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6SJ

Color mode:

Visible columns:

Per node type stats

Per table stats