explain.depesz.com

PostgreSQL's explain analyze made readable

Result: McjS : test

Settings
# exclusive inclusive rows x rows loops node
1. 193.747 1,908.182 ↓ 2.6 356,442 1

Nested Loop (cost=0.57..1,004,211.01 rows=135,556 width=25) (actual time=2.407..1,908.182 rows=356,442 loops=1)

2. 0.007 0.007 ↑ 1.0 3 1

Seq Scan on month_ends m (cost=0.00..1.03 rows=3 width=4) (actual time=0.004..0.007 rows=3 loops=1)

3. 1,714.428 1,714.428 ↓ 2.6 118,814 3

Index Scan using loan_status_archive_date_loan_id on loan_status_archive lsa (cost=0.57..331,799.62 rows=45,185 width=25) (actual time=1.934..571.476 rows=118,814 loops=3)

  • 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: 254128
Planning time : 0.430 ms