explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KLFq

Settings
# exclusive inclusive rows x rows loops node
1. 0.109 934.542 ↓ 42.0 42 1

Sort (cost=146,265.11..146,265.11 rows=1 width=128) (actual time=934.523..934.542 rows=42 loops=1)

  • Sort Key: gds.date_processed, fa.state_code
  • Sort Method: quicksort Memory: 36kB
2. 0.107 934.433 ↓ 42.0 42 1

Nested Loop (cost=0.42..146,265.10 rows=1 width=128) (actual time=0.181..934.433 rows=42 loops=1)

3. 934.074 934.074 ↓ 42.0 42 1

Seq Scan on fact_application_underwriting gds (cost=0.00..146,256.63 rows=1 width=39) (actual time=0.145..934.074 rows=42 loops=1)

  • Filter: ((dm_2_0_model_score_prod IS NOT NULL) AND (state <> ALL ('{CA,AL}'::text[])) AND (underwriting_group = ANY ('{"DM - Test","Organic - Test"}'::text[])) AND (claritycontrolfilename = ANY ('{Balance3,Balance1B}'::text[])) AND (date_processed < (CURRENT_TIMESTAMP - '06:00:00'::interval)) AND ((date_processed)::date >= (('now'::cstring)::date - 14)) AND (CASE WHEN (((dm_2_0_process_group = 'Approve'::text) AND (decision = 'PASS'::text) AND (NOT ev_flg)) OR ((dm_2_0_process_group = 'Approve-with-EV'::text) AND (decision = 'PASS'::text) AND ev_flg) OR ((dm_2_0_process_group = 'Decline'::text) AND (decision = 'FAIL'::text) AND (NOT ev_flg))) THEN 0 ELSE 1 END = 1))
  • Rows Removed by Filter: 974060
4. 0.252 0.252 ↑ 1.0 1 42

Index Scan using fact_application_bsf_application_id on fact_application fa (cost=0.42..8.44 rows=1 width=16) (actual time=0.005..0.006 rows=1 loops=42)

  • Index Cond: (bsf_application_id = gds.bsf_application_id)
Planning time : 1.288 ms