explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Tbf

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.002 ↓ 0.0 0 1

Nested Loop (cost=0.57..46,510.42 rows=13,145 width=537) (actual time=0.002..0.002 rows=0 loops=1)

2. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on stage_fact_loan_delinquency_updates stg (cost=0.00..24.30 rows=1,430 width=29) (actual time=0.001..0.001 rows=0 loops=1)

3. 0.000 0.000 ↓ 0.0 0

Index Scan using unique_row_col_set_fact_loan_daily_snapshot on fact_loan_daily_snapshot lds (cost=0.57..32.42 rows=9 width=508) (never executed)

  • Index Cond: ((loan_id = stg.loan_id) AND (report_date <= stg.report_date))
  • Filter: (((delinquency_status)::text IS DISTINCT FROM (stg.delinquency_status)::text) AND (report_date >= (stg.report_date - ((stg.days_delinquent - days_delinquent) - 1))))