explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ik8E

Settings
# exclusive inclusive rows x rows loops node
1. 18.190 33.771 ↓ 41.4 10,389 1

Bitmap Heap Scan on catalogue_simple_product (cost=111.56..3,680.39 rows=251 width=148) (actual time=16.463..33.771 rows=10,389 loops=1)

  • Recheck Cond: (attributes @> '{"speed": 2400, "screen": 12.2}'::jsonb)
  • Filter: (category_id = 7)
  • Heap Blocks: exact=4126
  • Planning time: 0.182 ms
  • Execution time: 34.344 ms
2. 15.581 15.581 ↓ 10.4 10,389 1

Bitmap Index Scan on catalogue_product_attrs_gin (cost=0.00..111.50 rows=1,000 width=0) (actual time=15.581..15.581 rows=10,389 loops=1)

  • Index Cond: (attributes @> '{"speed": 2400, "screen": 12.2}'::jsonb)