explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rqXN

Settings
# exclusive inclusive rows x rows loops node
1. 0.449 0.706 ↑ 2.5 200 1

Bitmap Heap Scan on catalogue_simple_product (cost=135.25..6,878.74 rows=501 width=148) (actual time=0.286..0.706 rows=200 loops=1)

  • Recheck Cond: ((attributes @> '{"speed": 3200}'::jsonb) OR (attributes @> '{"speed": 3500}'::jsonb))
  • Filter: (category_id = 7)
  • Heap Blocks: exact=4
2. 0.001 0.257 ↓ 0.0 0 1

BitmapOr (cost=135.25..135.25 rows=2,000 width=0) (actual time=0.257..0.257 rows=0 loops=1)

3. 0.136 0.136 ↑ 10.0 100 1

Bitmap Index Scan on catalogue_product_attrs_gin (cost=0.00..67.50 rows=1,000 width=0) (actual time=0.136..0.136 rows=100 loops=1)

  • Index Cond: (attributes @> '{"speed": 3200}'::jsonb)
4. 0.120 0.120 ↑ 10.0 100 1

Bitmap Index Scan on catalogue_product_attrs_gin (cost=0.00..67.50 rows=1,000 width=0) (actual time=0.120..0.120 rows=100 loops=1)

  • Index Cond: (attributes @> '{"speed": 3500}'::jsonb)