explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QDz4

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 0.090 ↑ 1.0 8 1

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

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

Bitmap Heap Scan on property_sku (cost=4.41..42.71 rows=9 width=255) (actual time=0.019..0.023 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.017 0.048 ↑ 1.0 112 1

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

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

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

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