explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5qvo : test

Settings
# exclusive inclusive rows x rows loops node
1. 1,097.614 100,755.193 ↓ 1.8 2,180,916 1

Nested Loop (cost=0.57..8,620,292.69 rows=1,220,005 width=25) (actual time=41.373..100,755.193 rows=2,180,916 loops=1)

2. 0.039 0.039 ↑ 1.0 27 1

Seq Scan on month_ends m (cost=0.00..1.27 rows=27 width=4) (actual time=0.003..0.039 rows=27 loops=1)

3. 99,657.540 99,657.540 ↓ 1.8 80,775 27

Index Scan using loan_status_archive_date_loan_id on loan_status_archive lsa (cost=0.57..316,333.01 rows=45,185 width=25) (actual time=28.513..3,691.020 rows=80,775 loops=27)

  • 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: 154871
Planning time : 0.369 ms