explain.depesz.com

PostgreSQL's explain analyze made readable

Result: evBf

Settings
# exclusive inclusive rows x rows loops node
1. 8.819 71.406 ↑ 97.3 435 1

HashAggregate (cost=50,372.21..51,642.59 rows=42,346 width=36) (actual time=71.106..71.406 rows=435 loops=1)

  • Group Key: cal_inner.cid, cal_inner.property_id, cal_inner.application_id
2. 7.686 62.587 ↑ 1.6 26,197 1

Nested Loop (cost=0.43..49,737.02 rows=42,346 width=28) (actual time=0.049..62.587 rows=26,197 loops=1)

3. 0.091 0.091 ↑ 1.0 435 1

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

4. 54.810 54.810 ↑ 1.6 60 435

Index Scan using idx_cached_application_logs_cid_app_opening_log on cached_application_logs cal_inner (cost=0.43..111.38 rows=97 width=28) (actual time=0.009..0.126 rows=60 loops=435)

  • Index Cond: ((cid = l.cid) AND (application_id = l.application_id))
  • Filter: (effective_date <= '2019-08-31'::date)
  • Rows Removed by Filter: 1
Planning time : 0.893 ms