explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8IjC

Settings
# exclusive inclusive rows x rows loops node
1. 0.035 1.999 ↑ 1.3 70 1

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

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

3. 0.104 0.104 ↑ 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.104..0.104 rows=721 loops=1)

  • Index Cond: (post_month = '2019-09-01'::date)
4. 1.854 1.854 ↓ 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=1.854..1.854 rows=33,671 loops=1)

  • Index Cond: (property_id = 219,034)