explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VRV8a

Settings
# exclusive inclusive rows x rows loops node
1. 0.177 0.177 ↓ 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=0.114..0.177 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[])))