explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6U9

Settings
# exclusive inclusive rows x rows loops node
1. 335.207 382.328 ↓ 49.8 124,995 1

Bitmap Heap Scan on catalogue_simple_product (cost=9,606.55..66,058.73 rows=2,509 width=148) (actual time=48.211..382.328 rows=124,995 loops=1)

  • Recheck Cond: (category_id = 7)
  • Filter: ((attributes -> 'speed'::text) = ANY ('{2200,2400}'::jsonb[]))
  • Rows Removed by Filter: 125005
  • Heap Blocks: exact=5139
2. 47.121 47.121 ↑ 1.0 250,000 1

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

  • Index Cond: (category_id = 7)