explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Iy3d

Settings
# exclusive inclusive rows x rows loops node
1. 70,758.677 73,607.159 ↓ 4.7 398,919 1

Hash Join (cost=27.28..676,565.70 rows=85,517 width=172) (actual time=1.546..73,607.159 rows=398,919 loops=1)

  • Hash Cond: (cal.property_id = load_prop.property_id)
2. 1,012.035 2,848.285 ↓ 4.7 403,199 1

Hash Join (cost=20.41..632,410.68 rows=85,517 width=732) (actual time=0.079..2,848.285 rows=403,199 loops=1)

  • Hash Cond: ((cal.application_stage_id = ass.application_stage_id) AND (cal.application_status_id = ass.application_status_id))
3. 1,836.136 1,836.206 ↓ 4.0 403,206 1

Index Scan using idx_cached_application_logs_cid_aid_reporting_daterange on cached_application_logs cal (cost=13.29..628,524.45 rows=100,798 width=112) (actual time=0.026..1,836.206 rows=403,206 loops=1)

  • Index Cond: ((cid = 15077) AND (reporting_post_date < '2020-05-18 00:00:00'::timestamp without time zone) AND (apply_through_post_date >= '2020-05-17'::date))
  • Filter: (CASE WHEN (cancellation_list_item_id IS NULL) THEN true WHEN (hashed SubPlan 1) THEN false ELSE true END AND (occupancy_type_id <> 4) AND (lease_interval_type_id = 1))
  • Rows Removed by Filter: 56192
4.          

SubPlan (for Index Scan)

5. 0.070 0.070 ↑ 1.2 6 1

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

  • Filter: ((cid = 15077) AND (default_list_item_id = ANY ('{66,65,90}'::integer[])))
  • Rows Removed by Filter: 292
6. 0.016 0.044 ↑ 1.0 18 1

Hash (cost=6.85..6.85 rows=18 width=632) (actual time=0.044..0.044 rows=18 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
7. 0.028 0.028 ↑ 1.0 18 1

Seq Scan on application_stage_statuses ass (cost=0.00..6.85 rows=18 width=632) (actual time=0.005..0.028 rows=18 loops=1)

  • Filter: (lease_interval_type_id = 1)
  • Rows Removed by Filter: 50
8. 0.096 0.197 ↑ 1.0 172 1

Hash (cost=4.72..4.72 rows=172 width=28) (actual time=0.197..0.197 rows=172 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
9. 0.101 0.101 ↑ 1.0 172 1

Seq Scan on load_prop (cost=0.00..4.72 rows=172 width=28) (actual time=0.013..0.101 rows=172 loops=1)