explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fGbm

Settings
# exclusive inclusive rows x rows loops node
1. 723.668 1,822.094 ↓ 4.0 398,925 1

Hash Join (cost=20.16..629,917.29 rows=100,798 width=136) (actual time=0.213..1,822.094 rows=398,925 loops=1)

  • Hash Cond: (cal.property_id = load_prop.property_id)
2. 1,098.186 1,098.245 ↓ 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.022..1,098.245 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
3.          

SubPlan (for Index Scan)

4. 0.059 0.059 ↑ 1.2 6 1

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

  • Filter: ((cid = 15077) AND (default_list_item_id = ANY ('{66,65,90}'::integer[])))
  • Rows Removed by Filter: 292
5. 0.091 0.181 ↑ 1.0 172 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
6. 0.090 0.090 ↑ 1.0 172 1

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