explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qYN

Settings
# exclusive inclusive rows x rows loops node
1. 10.948 48.823 ↓ 14.9 3,737 1

Bitmap Heap Scan on catalogue_simple_product (cost=267.56..3,836.39 rows=250 width=148) (actual time=38.418..48.823 rows=3,737 loops=1)

  • Recheck Cond: (attributes @> '{"model": "poet", "sizes": ["M", "L"], "colors": ["white", "yellow"]}'::jsonb)
  • Filter: (category_id = 5)
  • Heap Blocks: exact=2778
  • Planning time: 0.305 ms
  • Execution time: 49.032 ms
2. 37.875 37.875 ↓ 3.7 3,737 1

Bitmap Index Scan on catalogue_product_attrs_gin (cost=0.00..267.50 rows=1,000 width=0) (actual time=37.875..37.875 rows=3,737 loops=1)

  • Index Cond: (attributes @> '{"model": "poet", "sizes": ["M", "L"], "colors": ["white", "yellow"]}'::jsonb)