explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WLvj

Settings
# exclusive inclusive rows x rows loops node
1. 73.761 487.990 ↓ 859.0 859 1

GroupAggregate (cost=664.05..664.44 rows=1 width=184) (actual time=389.422..487.990 rows=859 loops=1)

  • Group Key: cal.cid, cal.property_id, cal.application_id
2. 93.887 414.229 ↓ 52,706.0 52,706 1

Sort (cost=664.05..664.06 rows=1 width=656) (actual time=389.371..414.229 rows=52,706 loops=1)

  • Sort Key: cal.application_id
  • Sort Method: quicksort Memory: 63722kB
3. 102.391 320.342 ↓ 52,706.0 52,706 1

Nested Loop (cost=0.85..664.04 rows=1 width=656) (actual time=0.037..320.342 rows=52,706 loops=1)

4. 51.238 165.245 ↓ 52,706.0 52,706 1

Nested Loop (cost=0.85..663.02 rows=1 width=656) (actual time=0.032..165.245 rows=52,706 loops=1)

5. 0.619 0.619 ↓ 214.8 859 1

Index Scan using idx_temp_leads_effective_date on leads_temp l (cost=0.29..53.57 rows=4 width=12) (actual time=0.012..0.619 rows=859 loops=1)

  • Index Cond: (effective_date >= '2019-11-01'::date)
  • Filter: ((cid = 12881) AND (property_id = 219100))
6. 113.388 113.388 ↓ 61.0 61 859

Index Scan using idx_cached_application_logs_cid_app_opening_log on cached_application_logs cal (cost=0.56..152.35 rows=1 width=656) (actual time=0.008..0.132 rows=61 loops=859)

  • Index Cond: ((cid = 12881) AND (application_id = l.application_id))
  • Filter: ((effective_date <= '2019-11-30'::date) AND (occupancy_type_id <> 4) AND (property_id = 219100) AND (lease_interval_type_id = 1))
7. 52.706 52.706 ↑ 1.0 1 52,706

Seq Scan on load_prop (cost=0.00..1.01 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=52,706)

  • Filter: (property_id = 219100)
Planning time : 0.771 ms