explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vCU3

Settings
# exclusive inclusive rows x rows loops node
1. 1.306 1.306 ↓ 2.1 1,093 1

Index Scan using idx_cached_unit_space_periods_space_month on cached_unit_space_periods (cost=0.56..1,347.89 rows=530 width=596) (actual time=0.180..1.306 rows=1,093 loops=1)

  • Index Cond: ((property_id = 18,462) AND (post_month = '2019-09-01'::date))
  • Filter: ((cid = 235) AND (unit_space_status_type_id = ANY ('{2,3,4,5,6,8,9}'::integer[])))
  • Rows Removed by Filter: 221