explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lgb

Settings
# exclusive inclusive rows x rows loops node
1. 57.201 78.024 ↓ 18,428.0 18,428 1

Bitmap Heap Scan on catalogue_simple_product (cost=111.50..3,685.32 rows=1 width=148) (actual time=22.106..78.024 rows=18,428 loops=1)

  • Recheck Cond: (attributes @> '{"model": "polo", "colors": ["red"]}'::jsonb)
  • Filter: ((category_id = 5) AND ((attributes -> 'sizes'::text) ?| '{M,L}'::text[]))
  • Rows Removed by Filter: 6734
  • Heap Blocks: exact=5887
2. 20.823 20.823 ↓ 25.2 25,162 1

Bitmap Index Scan on catalogue_product_attrs_gin (cost=0.00..111.50 rows=1,000 width=0) (actual time=20.823..20.823 rows=25,162 loops=1)

  • Index Cond: (attributes @> '{"model": "polo", "colors": ["red"]}'::jsonb)