explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6SJ

Settings
# exclusive inclusive rows x rows loops node
1. 200.561 252.570 ↓ 18,428.0 18,428 1

Bitmap Heap Scan on catalogue_simple_product (cost=9,556.43..66,610.43 rows=1 width=148) (actual time=53.312..252.570 rows=18,428 loops=1)

  • Recheck Cond: (category_id = 5)
  • Filter: ((attributes @> '{"model": "polo", "colors": ["red"]}'::jsonb) AND ((attributes -> 'sizes'::text) ?| '{M,L}'::text[]))
  • Rows Removed by Filter: 231572
  • Heap Blocks: exact=5962
  • Planning time: 0.240 ms
  • Execution time: 253.871 ms
2. 52.009 52.009 ↓ 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=52.009..52.009 rows=250,000 loops=1)

  • Index Cond: (category_id = 5)