explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R8qN : test

Settings
# exclusive inclusive rows x rows loops node
1. 1,335.324 10,965.902 ↓ 2.2 1,524,327 1

Nested Loop (cost=0.57..4,821,246.40 rows=677,781 width=25) (actual time=1.877..10,965.902 rows=1,524,327 loops=1)

2. 0.023 0.023 ↑ 1.0 15 1

Seq Scan on month_ends m (cost=0.00..1.15 rows=15 width=4) (actual time=0.004..0.023 rows=15 loops=1)

3. 9,630.555 9,630.555 ↓ 2.2 101,622 15

Index Scan using loan_status_archive_date_loan_id on loan_status_archive lsa (cost=0.57..318,479.30 rows=45,185 width=25) (actual time=1.461..642.037 rows=101,622 loops=15)

  • Index Cond: (date = m.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: 209057
Planning time : 0.610 ms