explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AMl4

Settings
# exclusive inclusive rows x rows loops node
1. 0.080 10.951 ↓ 23.3 70 1

Bitmap Heap Scan on cached_unit_space_periods (cost=937.19..949.26 rows=3 width=592) (actual time=10.899..10.951 rows=70 loops=1)

  • Recheck Cond: ((cid = 224) AND (property_id = 219,034) AND (post_month = '2019-09-01'::date))
  • Filter: (unit_space_status_type_id = ANY ('{2,3,4,5,6,8,9}'::integer[]))
  • Heap Blocks: exact=7
2. 0.185 10.871 ↓ 0.0 0 1

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

3. 4.213 4.213 ↓ 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=4.212..4.213 rows=33,671 loops=1)

  • Index Cond: ((cid = 224) AND (property_id = 219,034))
4. 6.473 6.473 ↑ 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=6.472..6.473 rows=46,461 loops=1)

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