explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0OBuW

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 0.083 ↑ 1.0 8 1

Hash Join (cost=10.07..48.48 rows=8 width=255) (actual time=0.077..0.083 rows=8 loops=1)

  • Hash Cond: (property_sku.sku_id = sku.id)
2. 0.013 0.022 ↑ 1.1 8 1

Bitmap Heap Scan on property_sku (cost=4.41..42.71 rows=9 width=255) (actual time=0.019..0.022 rows=8 loops=1)

  • Recheck Cond: ((property_id)::text = '0013487'::text)
  • Filter: ((saleable IS TRUE) AND (status = 'ACTIVE'::property_sku_status))
  • Rows Removed by Filter: 11
  • Heap Blocks: exact=4
3. 0.009 0.009 ↓ 1.1 19 1

Bitmap Index Scan on ix_property_sku_property_id (cost=0.00..4.41 rows=17 width=0) (actual time=0.009..0.009 rows=19 loops=1)

  • Index Cond: ((property_id)::text = '0013487'::text)
4. 0.022 0.051 ↑ 1.0 112 1

Hash (cost=4.26..4.26 rows=112 width=4) (actual time=0.051..0.051 rows=112 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
5. 0.029 0.029 ↑ 1.0 112 1

Seq Scan on sku (cost=0.00..4.26 rows=112 width=4) (actual time=0.004..0.029 rows=112 loops=1)

  • Filter: (is_modular IS FALSE)
  • Rows Removed by Filter: 14