explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MoAk : test

Settings
# exclusive inclusive rows x rows loops node
1. 3,028.396 6,527.773 ↓ 3.1 7,062,196 1

Nested Loop (cost=0.57..435,211.91 rows=2,296,568 width=25) (actual time=17.023..6,527.773 rows=7,062,196 loops=1)

2. 1,916.471 1,916.471 ↓ 3.1 121,762 1

Index Scan using loan_status_archive_date_loan_id on loan_status_archive lsa (cost=0.57..280,191.85 rows=39,596 width=25) (actual time=17.002..1,916.471 rows=121,762 loops=1)

  • Index Cond: (date = '2019-09-30'::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: 260642
3. 1,582.885 1,582.906 ↑ 1.0 58 121,762

Materialize (cost=0.00..1.87 rows=58 width=0) (actual time=0.000..0.013 rows=58 loops=121,762)

4. 0.021 0.021 ↑ 1.0 58 1

Seq Scan on month_ends m (cost=0.00..1.58 rows=58 width=0) (actual time=0.008..0.021 rows=58 loops=1)

Planning time : 0.312 ms