explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Sdq

Settings
# exclusive inclusive rows x rows loops node
1. 266.868 328.868 ↓ 249.5 124,995 1

Bitmap Heap Scan on catalogue_simple_product (cost=135.25..6,878.74 rows=501 width=148) (actual time=64.148..328.868 rows=124,995 loops=1)

  • Recheck Cond: ((attributes @> '{"speed": 2200}'::jsonb) OR (attributes @> '{"speed": 2400}'::jsonb))
  • Filter: (category_id = 7)
  • Rows Removed by Filter: 100124
  • Heap Blocks: exact=9794
2. 0.002 62.000 ↓ 0.0 0 1

BitmapOr (cost=135.25..135.25 rows=2,000 width=0) (actual time=62.000..62.000 rows=0 loops=1)

3. 34.708 34.708 ↓ 51.1 112,410 1

Bitmap Index Scan on catalogue_product_attrs_gin (cost=0.00..67.50 rows=2,200 width=0) (actual time=34.708..34.708 rows=112,410 loops=1)

  • Index Cond: (attributes @> '{"speed": 2200}'::jsonb)
4. 27.290 27.290 ↓ 51.2 112,709 1

Bitmap Index Scan on catalogue_product_attrs_gin (cost=0.00..67.50 rows=2,200 width=0) (actual time=27.290..27.290 rows=112,709 loops=1)

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