explain.depesz.com

PostgreSQL's explain analyze made readable

Result: O1mA

Settings
# exclusive inclusive rows x rows loops node
1. 215.711 5,529.566 ↓ 98,218.0 98,218 1

Nested Loop Left Join (cost=2.14..16,815.18 rows=1 width=187) (actual time=0.169..5,529.566 rows=98,218 loops=1)

2. 124.136 5,313.855 ↓ 98,218.0 98,218 1

Nested Loop (cost=1.57..16,807.94 rows=1 width=53) (actual time=0.162..5,313.855 rows=98,218 loops=1)

  • Join Filter: ("DGDCTR"."CONTR_ID_N" = "UADLIM"."CONTR_ID_N")
3. 655.897 1,520.041 ↓ 8,265.0 1,223,226 1

Nested Loop (cost=1.00..15,725.04 rows=148 width=44) (actual time=0.034..1,520.041 rows=1,223,226 loops=1)

4. 0.019 0.019 ↑ 1.0 1 1

Index Scan using "DGDCTRS02" on "DGDCTR" (cost=0.43..8.45 rows=1 width=4) (actual time=0.018..0.019 rows=1 loops=1)

  • Index Cond: ((rtrim(("EGBU_C")::text) = 'CBAC'::text) AND (rtrim(("CONTR_N")::text) = '0000001008'::text))
5. 864.125 864.125 ↓ 236.9 1,223,226 1

Index Scan using "UADCLDS01" on "UADCLD" (cost=0.57..15,664.96 rows=5,163 width=40) (actual time=0.013..864.125 rows=1,223,226 loops=1)

  • Index Cond: ("CONTR_ID_N" = "DGDCTR"."CONTR_ID_N")
  • Filter: (("DECISION_STATE_C")::text = '01 '::text)
  • Rows Removed by Filter: 2
6. 3,669.678 3,669.678 ↓ 0.0 0 1,223,226

Index Scan using "UADLIMU01" on "UADLIM" (cost=0.57..7.30 rows=1 width=29) (actual time=0.003..0.003 rows=0 loops=1,223,226)

  • Index Cond: (("CONTR_ID_N" = "UADCLD"."CONTR_ID_N") AND ("THD_ID_N" = "UADCLD"."THD_ID_N") AND ("LIM_ID_N" = "UADCLD"."LIM_ID_N"))
  • Filter: ((("LIM_STATE_C")::text = 'CUR'::text) AND (CASE WHEN (rtrim(("PRIM_CRD_LIM_DC_C")::text) = ANY ('{AA,AC,AU,AW,BC,CA,CB,CL,CP,DC,DL,MA,ND,NO,OK,PA,PW,RE,RP,RW,SC,SW}'::text[])) THEN "PRIM_CRD_LIM_DC_C" WHEN (("UADCLD"."CRD_LIM_DC_C")::text = ANY ('{AA,AC,AU,AW,BC,CA,CB,CL,CP,DC,DL,MA,ND,NO,OK,PA,PW,RE,RP,RW,SC,SW}'::text[])) THEN "PRIM_CRD_LIM_DC_C" WHEN (rtrim(("UADCLD"."CRD_LIM_DC_C")::text) = ANY ('{AA,AC,AU,AW,BC,CA,CB,CL,CP,DC,DL,MA,ND,NO,OK,PA,PW,RE,RP,RW,SC,SW}'::text[])) THEN "PRIM_CRD_LIM_DC_C" WHEN (("UADCLD"."CRD_LIM_DC_C")::text = ANY ('{AA,AC,AU,AW,BC,CA,CB,CL,CP,DC,DL,MA,ND,NO,OK,PA,PW,RE,RP,RW,SC,SW}'::text[])) THEN "UADCLD"."CRD_LIM_DC_C" ELSE NULL::character varying END IS NOT NULL))
  • Rows Removed by Filter: 1
7. 0.000 0.000 ↓ 0.0 0 98,218

Index Scan using "UADEIBU01" on "UADEIB" (cost=0.57..7.12 rows=1 width=61) (actual time=0.000..0.000 rows=0 loops=98,218)

  • Index Cond: (("UADCLD"."CONTR_ID_N" = "CONTR_ID_N") AND ("UADCLD"."THD_ID_N" = "THD_ID_N") AND ("UADCLD"."REQT_ID_N" = "REQT_ID_N"))