explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BaUq

Settings
# exclusive inclusive rows x rows loops node
1. 1,043.159 42,413.215 ↓ 236.7 21,543 1

GroupAggregate (cost=17,709.05..17,744.08 rows=91 width=184) (actual time=40,962.062..42,413.215 rows=21,543 loops=1)

  • Group Key: cal.cid, cal.property_id, cal.application_id
2. 15,352.452 41,370.056 ↓ 7,289.2 663,318 1

Sort (cost=17,709.05..17,709.28 rows=91 width=656) (actual time=40,961.989..41,370.056 rows=663,318 loops=1)

  • Sort Key: cal.application_id
  • Sort Method: external merge Disk: 413664kB
3. 533.264 26,017.604 ↓ 7,289.2 663,318 1

Nested Loop (cost=0.85..17,706.09 rows=91 width=656) (actual time=2.578..26,017.604 rows=663,318 loops=1)

4. 0.008 0.008 ↑ 1.0 1 1

Seq Scan on load_prop (cost=0.00..1.01 rows=1 width=4) (actual time=0.006..0.008 rows=1 loops=1)

  • Filter: (property_id = 219102)
5. 644.351 25,484.332 ↓ 7,289.2 663,318 1

Nested Loop (cost=0.85..17,704.17 rows=91 width=660) (actual time=2.569..25,484.332 rows=663,318 loops=1)

6. 22.445 22.445 ↓ 199.5 21,543 1

Index Scan using idx_temp_leads_effective_date on leads_temp l (cost=0.29..1,252.85 rows=108 width=12) (actual time=0.022..22.445 rows=21,543 loops=1)

  • Index Cond: (effective_date >= '2019-11-11'::date)
  • Filter: ((cid = 12881) AND (property_id = 219102))
7. 24,817.536 24,817.536 ↓ 31.0 31 21,543

Index Scan using idx_cached_application_logs_cid_app_opening_log on cached_application_logs cal (cost=0.56..152.32 rows=1 width=656) (actual time=0.165..1.152 rows=31 loops=21,543)

  • Index Cond: ((cid = 12881) AND (application_id = l.application_id))
  • Filter: ((effective_date <= '2019-11-17'::date) AND (occupancy_type_id <> 4) AND (property_id = 219102) AND (lease_interval_type_id = 1))
  • Rows Removed by Filter: 0
Planning time : 1.181 ms