explain.depesz.com

PostgreSQL's explain analyze made readable

Result: V8dz : test

Settings
# exclusive inclusive rows x rows loops node
1. 267.609 30,308.893 ↓ 2.6 469,206 1

Nested Loop (cost=1.62..1,320,327.18 rows=180,741 width=28) (actual time=0.816..30,308.893 rows=469,206 loops=1)

2. 0.018 0.024 ↑ 1.0 4 1

HashAggregate (cost=1.05..1.09 rows=4 width=4) (actual time=0.014..0.024 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. 30,041.260 30,041.260 ↓ 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=31.061..7,510.315 rows=117,302 loops=4)

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