explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4VSe

Settings
# exclusive inclusive rows x rows loops node
1. 2,001.260 2,737.993 ↓ 1.1 318,755 1

Nested Loop (cost=13.29..1,388,436.30 rows=302,842 width=176) (actual time=0.145..2,737.993 rows=318,755 loops=1)

2. 0.065 0.065 ↑ 1.0 57 1

Seq Scan on property_weeks cpw (cost=0.00..1.71 rows=57 width=104) (actual time=0.008..0.065 rows=57 loops=1)

  • Filter: (cid = 15077)
3. 736.591 736.668 ↓ 2.2 5,592 57

Index Scan using idx_cached_application_logs_property_id_reporting_daterange on cached_application_logs cal (cost=13.29..22,977.80 rows=2,588 width=869) (actual time=0.014..12.924 rows=5,592 loops=57)

  • Index Cond: ((property_id = cpw.property_id) AND (cpw.end_date >= reporting_post_date) AND (cpw.end_date <= apply_through_post_date))
  • Filter: (CASE WHEN (cancellation_list_item_id IS NULL) THEN true WHEN (hashed SubPlan 1) THEN false ELSE true END AND (cid = 15077) AND (lease_interval_type_id = 1) AND (occupancy_type_id = ANY ('{1,2,6,9,10}'::integer[])))
  • Rows Removed by Filter: 792
4.          

SubPlan (for Index Scan)

5. 0.077 0.077 ↑ 1.2 6 1

Seq Scan on list_items li (cost=0.00..12.84 rows=7 width=4) (actual time=0.030..0.077 rows=6 loops=1)

  • Filter: ((cid = 15077) AND (default_list_item_id = ANY ('{66,65,90}'::integer[])))
  • Rows Removed by Filter: 292