explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fOS8 : coverageStats

Settings
# exclusive inclusive rows x rows loops node
1. 989.714 118,869.262 ↓ 374.3 206,250 1

Hash Left Join (cost=37,542.46..54,874.62 rows=551 width=382) (actual time=99.107..118,869.262 rows=206,250 loops=1)

  • Hash Cond: (concat('DECISION', CASE WHEN (rtrim(("UADLIM"."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 rtrim(("UADLIM"."PRIM_CRD_LIM_DC_C")::text) 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 rtrim(("UADCLD"."CRD_LIM_DC_C")::text) ELSE NULL::text END) = rtrim(("IBDWRD"."ID_C_A")::text))
2. 301.877 117,788.597 ↓ 103,125.0 206,250 1

Nested Loop Left Join (cost=2.71..16,895.51 rows=2 width=362) (actual time=7.893..117,788.597 rows=206,250 loops=1)

3. 386.771 105,317.970 ↓ 103,125.0 206,250 1

Nested Loop Left Join (cost=2.14..16,880.78 rows=2 width=119) (actual time=6.669..105,317.970 rows=206,250 loops=1)

4. 326.642 73,993.699 ↓ 103,125.0 206,250 1

Nested Loop (cost=1.57..16,866.01 rows=2 width=115) (actual time=5.599..73,993.699 rows=206,250 loops=1)

5. 190.938 37,035.491 ↓ 1,343.9 206,958 1

Nested Loop (cost=1.00..15,713.83 rows=154 width=62) (actual time=3.903..37,035.491 rows=206,958 loops=1)

6. 2.028 2.028 ↑ 1.0 1 1

Index Scan using "DGDCTRS02" on "DGDCTR" (cost=0.43..8.45 rows=1 width=26) (actual time=2.025..2.028 rows=1 loops=1)

  • Index Cond: ((rtrim(("EGBU_C")::text) = 'SFAC'::text) AND (rtrim(("CONTR_N")::text) = '0014685401'::text))
7. 36,842.525 36,842.525 ↓ 38.4 206,958 1

Index Scan using "UADCLDS01" on "UADCLD" (cost=0.57..15,651.49 rows=5,389 width=36) (actual time=1.874..36,842.525 rows=206,958 loops=1)

  • Index Cond: ("CONTR_ID_N" = "DGDCTR"."CONTR_ID_N")
8. 36,631.566 36,631.566 ↑ 1.0 1 206,958

Index Scan using "UADLIMU01" on "UADLIM" (cost=0.57..7.47 rows=1 width=73) (actual time=0.177..0.177 rows=1 loops=206,958)

  • 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: (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 (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 "UADCLD"."CRD_LIM_DC_C" ELSE NULL::character varying END IS NOT NULL)
  • Rows Removed by Filter: 0
9. 30,937.500 30,937.500 ↓ 0.0 0 206,250

Index Scan using "UADR1BS02" on "UADR1B" (cost=0.57..7.39 rows=1 width=16) (actual time=0.150..0.150 rows=0 loops=206,250)

  • Index Cond: (("THD_ID_N" = "UADCLD"."THD_ID_N") AND ("REQT_ID_N" = "UADCLD"."REQT_ID_N") AND ("CONTR_ID_N" = "UADCLD"."CONTR_ID_N"))
10. 12,168.750 12,168.750 ↓ 0.0 0 206,250

Index Scan using "UADEIBU01" on "UADEIB" (cost=0.57..7.36 rows=1 width=263) (actual time=0.059..0.059 rows=0 loops=206,250)

  • Index Cond: (("CONTR_ID_N" = "UADCLD"."CONTR_ID_N") AND ("THD_ID_N" = "UADCLD"."THD_ID_N") AND ("REQT_ID_N" = "UADCLD"."REQT_ID_N"))
11. 30.185 90.951 ↑ 1.1 52,371 1

Hash (cost=36,851.10..36,851.10 rows=55,092 width=17) (actual time=90.950..90.951 rows=52,371 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3019kB
12. 0.000 60.766 ↑ 1.1 52,371 1

Gather (cost=1,000.00..36,851.10 rows=55,092 width=17) (actual time=0.299..60.766 rows=52,371 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
13. 61.651 61.651 ↑ 1.3 17,457 3

Parallel Seq Scan on "IBDWRD" (cost=0.00..30,341.90 rows=22,955 width=17) (actual time=0.007..61.651 rows=17,457 loops=3)

  • Filter: (("LANG_C")::text = 'EN'::text)
  • Rows Removed by Filter: 503561