explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YQO

Settings
# exclusive inclusive rows x rows loops node
1. 9.897 45.908 ↑ 2.6 10,536 1

Bitmap Heap Scan on catalogue_simple_product (cost=10,708.73..65,270.73 rows=27,874 width=148) (actual time=36.842..45.908 rows=10,536 loops=1)

  • Recheck Cond: (((attributes -> 'screen'::text) > '13'::jsonb) AND ((attributes -> 'speed'::text) > '2000'::jsonb))
  • Filter: (category_id = 7)
  • Heap Blocks: exact=4148
2. 36.011 36.011 ↑ 10.5 10,536 1

Bitmap Index Scan on attrs_screen_speed (cost=0.00..10,701.76 rows=111,111 width=0) (actual time=36.011..36.011 rows=10,536 loops=1)

  • Index Cond: (((attributes -> 'screen'::text) > '13'::jsonb) AND ((attributes -> 'speed'::text) > '2000'::jsonb))