explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ewKA

Settings
# exclusive inclusive rows x rows loops node
1. 0.056 4.642 ↓ 0.0 0 1

Bitmap Heap Scan on cached_unit_space_periods (cost=451.48..654.89 rows=70 width=597) (actual time=4.642..4.642 rows=0 loops=1)

  • Recheck Cond: ((post_month = '2019-09-01'::date) AND (property_id = 219,034))
  • Filter: ((cid = 224) AND (unit_space_status_type_id = 2))
  • Rows Removed by Filter: 70
  • Heap Blocks: exact=6
2. 0.016 4.586 ↓ 0.0 0 1

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

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

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

  • Index Cond: (property_id = 219,034)