explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cHk

Settings
# exclusive inclusive rows x rows loops node
1. 172.751 247.055 ↓ 265.6 66,412 1

Bitmap Heap Scan on catalogue_simple_product (cost=111.56..3,680.39 rows=250 width=148) (actual time=77.279..247.055 rows=66,412 loops=1)

  • Recheck Cond: (attributes @> '{"sizes": ["M", "L"]}'::jsonb)
  • Filter: (category_id = 5)
  • Rows Removed by Filter: 66788
  • Heap Blocks: exact=13215
  • Planning time: 0.404 ms
  • Execution time: 250.238 ms
2. 74.304 74.304 ↓ 133.2 133,200 1

Bitmap Index Scan on catalogue_product_attrs_gin (cost=0.00..111.50 rows=1,000 width=0) (actual time=74.304..74.304 rows=133,200 loops=1)

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