explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YXbO

Settings
# exclusive inclusive rows x rows loops node
1. 0.044 4.102 ↓ 1.1 70 1

Bitmap Heap Scan on cached_unit_space_periods (cost=452.72..602.02 rows=64 width=597) (actual time=4.071..4.102 rows=70 loops=1)

  • Recheck Cond: ((post_month = '2019-09-01'::date) AND (property_id = 219,034))
  • Filter: ((cid = 224) AND (unit_space_status_type_id = ANY ('{2,3,4,5,6,8,9}'::integer[])))
  • Heap Blocks: exact=6
2. 0.016 4.058 ↓ 0.0 0 1

BitmapAnd (cost=452.72..452.72 rows=75 width=0) (actual time=4.058..4.058 rows=0 loops=1)

3. 0.147 0.147 ↓ 1.1 721 1

Bitmap Index Scan on idx_cached_unit_space_periods_post_month (cost=0.00..9.24 rows=643 width=0) (actual time=0.147..0.147 rows=721 loops=1)

  • Index Cond: (post_month = '2019-09-01'::date)
4. 3.895 3.895 ↑ 1.0 33,671 1

Bitmap Index Scan on idx_cached_unit_space_periods_property_id (cost=0.00..443.19 rows=33,969 width=0) (actual time=3.895..3.895 rows=33,671 loops=1)

  • Index Cond: (property_id = 219,034)