explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zQSr

Settings
# exclusive inclusive rows x rows loops node
1. 0.088 8.101 ↓ 0.0 0 1

Bitmap Heap Scan on cached_unit_space_periods (cost=937.19..949.24 rows=1 width=592) (actual time=8.101..8.101 rows=0 loops=1)

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

BitmapAnd (cost=937.19..937.19 rows=3 width=0) (actual time=8.013..8.013 rows=0 loops=1)

3. 3.237 3.237 ↓ 28.8 33,671 1

Bitmap Index Scan on idx_cached_unit_space_periods_cid_property_id (cost=0.00..28.11 rows=1,168 width=0) (actual time=3.237..3.237 rows=33,671 loops=1)

  • Index Cond: ((cid = 224) AND (property_id = 219,034))
4. 4.600 4.600 ↑ 1.1 46,461 1

Bitmap Index Scan on idx_cached_unit_space_periods_post_month (cost=0.00..908.83 rows=49,119 width=0) (actual time=4.600..4.600 rows=46,461 loops=1)

  • Index Cond: (post_month = '2019-09-01'::date)