explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QLZy

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

Index Scan using idx_cached_unit_space_periods_space_month on cached_unit_space_periods (cost=0.56..125.32 rows=3 width=592) (actual time=7.833..8.259 rows=70 loops=1)

  • Index Cond: ((property_id = 219,034) AND (post_month = '2019-09-01'::date))
  • Filter: ((cid = 224) AND (unit_space_status_type_id = ANY ('{2,3,4,5,6,8,9}'::integer[])))