explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kFS5 : test

Settings
# exclusive inclusive rows x rows loops node
1. 236.318 2,339.726 ↓ 2.6 469,206 1

Nested Loop (cost=1.62..1,320,327.18 rows=180,741 width=28) (actual time=0.067..2,339.726 rows=469,206 loops=1)

2. 0.014 0.020 ↑ 1.0 4 1

HashAggregate (cost=1.05..1.09 rows=4 width=4) (actual time=0.012..0.020 rows=4 loops=1)

  • Group Key: month_ends.date
3. 0.006 0.006 ↑ 1.0 4 1

Seq Scan on month_ends (cost=0.00..1.04 rows=4 width=4) (actual time=0.004..0.006 rows=4 loops=1)

4. 2,103.388 2,103.388 ↓ 2.6 117,302 4

Index Scan using loan_status_archive_date_loan_id on loan_status_archive lsa (cost=0.57..329,629.67 rows=45,185 width=28) (actual time=0.039..525.847 rows=117,302 loops=4)

  • Index Cond: (date = month_ends.date)
  • Filter: (((loan_status_text)::text = ANY ('{Active,Closed}'::text[])) AND (loan_sub_status_id <> ALL ('{36,39}'::integer[])) AND (days_past_due <= 60))
  • Rows Removed by Filter: 250680
Planning time : 0.363 ms