explain.depesz.com

PostgreSQL's explain analyze made readable

Result: apSD

Settings
# exclusive inclusive rows x rows loops node
1. 4.932 4.932 ↓ 1.1 70 1

Index Scan using idx_cached_unit_space_periods_space_month on cached_unit_space_periods (cost=0.42..152.89 rows=64 width=597) (actual time=3.362..4.932 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[])))