explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XYQL

Settings
# exclusive inclusive rows x rows loops node
1. 0.248 0.248 ↓ 0.0 0 1

Index Scan using idx_cached_unit_space_periods_space_month on cached_unit_space_periods (cost=0.42..152.42 rows=51 width=597) (actual time=0.248..0.248 rows=0 loops=1)

  • Index Cond: ((property_id = 219,034) AND (post_month = '2019-09-01'::date))
  • Filter: ((cid = 224) AND (unit_space_status_type_id = 2))
  • Rows Removed by Filter: 70