explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xmWS

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 242.727 289.240 ↓ 265.6 66,412 1

Bitmap Heap Scan on catalogue_simple_product (cost=9,556.49..65,362.49 rows=250 width=148) (actual time=47.762..289.240 rows=66,412 loops=1)

  • Recheck Cond: (category_id = 5)
  • Filter: (attributes @> '{"sizes": ["M", "L"]}'::jsonb)
  • Rows Removed by Filter: 183588
  • Heap Blocks: exact=5962
  • Planning time: 0.223 ms
  • Execution time: 292.422 ms
2. 46.513 46.513 ↓ 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=46.513..46.513 rows=250,000 loops=1)

  • Index Cond: (category_id = 5)