explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a2oA

Settings
# exclusive inclusive rows x rows loops node
1. 6.831 68.007 ↑ 33.6 406 1

HashAggregate (cost=49,293.23..49,701.95 rows=13,624 width=36) (actual time=67.876..68.007 rows=406 loops=1)

  • Group Key: cal_inner.cid, cal_inner.property_id, cal_inner.application_id
2. 5.836 61.176 ↓ 1.5 19,757 1

Nested Loop (cost=0.43..49,088.87 rows=13,624 width=28) (actual time=0.044..61.176 rows=19,757 loops=1)

3. 0.095 0.095 ↑ 1.0 435 1

Seq Scan on leads l (cost=0.00..23.05 rows=435 width=8) (actual time=0.010..0.095 rows=435 loops=1)

4. 55.245 55.245 ↓ 1.5 45 435

Index Scan using idx_cached_application_logs_cid_app_opening_log on cached_application_logs cal_inner (cost=0.43..111.86 rows=31 width=28) (actual time=0.013..0.127 rows=45 loops=435)

  • Index Cond: ((cid = l.cid) AND (application_id = l.application_id))
  • Filter: ((effective_date <= '2019-08-31'::date) AND (application_status_id = ANY ('{3,4}'::integer[])) AND (application_stage_id = 4))
  • Rows Removed by Filter: 16
Planning time : 1.029 ms