explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CRgn

Settings
# exclusive inclusive rows x rows loops node
1. 0.055 2.266 ↑ 1.3 70 1

Bitmap Heap Scan on cached_unit_space_periods (cost=451.48..655.54 rows=88 width=597) (actual time=2.222..2.266 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.006 2.211 ↓ 0.0 0 1

BitmapAnd (cost=451.48..451.48 rows=103 width=0) (actual time=2.211..2.211 rows=0 loops=1)

3. 0.086 0.086 ↑ 1.2 721 1

Bitmap Index Scan on idx_cached_unit_space_periods_post_month (cost=0.00..13.14 rows=896 width=0) (actual time=0.085..0.086 rows=721 loops=1)

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

Bitmap Index Scan on idx_cached_unit_space_periods_property_id (cost=0.00..438.05 rows=33,550 width=0) (actual time=2.119..2.119 rows=33,671 loops=1)

  • Index Cond: (property_id = 219,034)