explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GWNM

Settings
# exclusive inclusive rows x rows loops node
1. 303.215 352.308 ↑ 2.6 10,536 1

Bitmap Heap Scan on catalogue_simple_product (cost=9,612.90..67,319.40 rows=27,874 width=148) (actual time=50.207..352.308 rows=10,536 loops=1)

  • Recheck Cond: (category_id = 7)
  • Filter: (((attributes -> 'screen'::text) > '13'::jsonb) AND ((attributes -> 'speed'::text) > '2000'::jsonb))
  • Rows Removed by Filter: 239464
  • Heap Blocks: exact=5139
2. 49.093 49.093 ↑ 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=49.093..49.093 rows=250,000 loops=1)

  • Index Cond: (category_id = 7)