explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jrwh

Settings
# exclusive inclusive rows x rows loops node
1. 418.776 2,436.188 ↓ 4.2 398,919 1

Hash Join (cost=28.67..631,533.14 rows=94,774 width=136) (actual time=0.291..2,436.188 rows=398,919 loops=1)

  • Hash Cond: (cal.property_id = load_prop.property_id)
2. 776.866 2,017.225 ↓ 4.3 403,199 1

Hash Join (cost=21.80..630,223.12 rows=94,774 width=112) (actual time=0.097..2,017.225 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,240.227 1,240.294 ↓ 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.024..1,240.294 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.067 0.067 ↑ 1.2 6 1

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

  • Filter: ((cid = 15077) AND (default_list_item_id = ANY ('{66,65,90}'::integer[])))
  • Rows Removed by Filter: 292
6. 0.011 0.065 ↓ 4.5 18 1

Hash (cost=8.44..8.44 rows=4 width=8) (actual time=0.064..0.065 rows=18 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.024 0.054 ↓ 4.5 18 1

HashAggregate (cost=8.40..8.44 rows=4 width=8) (actual time=0.044..0.054 rows=18 loops=1)

  • Group Key: ass.application_stage_id, ass.application_status_id
8. 0.030 0.030 ↓ 3.6 18 1

Seq Scan on application_stage_statuses ass (cost=0.00..8.38 rows=5 width=8) (actual time=0.005..0.030 rows=18 loops=1)

  • Filter: ((lease_interval_type_id = 1) AND (id = ANY ('{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18}'::integer[])))
  • Rows Removed by Filter: 50
9. 0.094 0.187 ↑ 1.0 172 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
10. 0.093 0.093 ↑ 1.0 172 1

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