explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ThI

Settings
# exclusive inclusive rows x rows loops node
1. 343.968 391.806 ↑ 12.5 200 1

Bitmap Heap Scan on catalogue_simple_product (cost=9,606.55..66,058.73 rows=2,509 width=148) (actual time=391.499..391.806 rows=200 loops=1)

  • Recheck Cond: (category_id = 7)
  • Filter: ((attributes -> 'speed'::text) = ANY ('{3200,3500}'::jsonb[]))
  • Rows Removed by Filter: 250000
  • Heap Blocks: exact=5143
2. 47.838 47.838 ↑ 1.0 250,200 1

Bitmap Index Scan on catalogue_simple_product_b583a629 (cost=0.00..9,605.93 rows=250,867 width=0) (actual time=47.838..47.838 rows=250,200 loops=1)

  • Index Cond: (category_id = 7)