explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DIWs

Settings
# exclusive inclusive rows x rows loops node
1. 0.054 4.575 ↓ 0.0 0 1

Bitmap Heap Scan on cached_unit_space_periods (cost=452.71..601.54 rows=51 width=597) (actual time=4.575..4.575 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.022 4.521 ↓ 0.0 0 1

BitmapAnd (cost=452.71..452.71 rows=75 width=0) (actual time=4.521..4.521 rows=0 loops=1)

3. 0.097 0.097 ↓ 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.097..0.097 rows=721 loops=1)

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

  • Index Cond: (property_id = 219,034)