explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JNnT

Settings
# exclusive inclusive rows x rows loops node
1. 1,187.344 5,585.340 ↓ 1.6 1,222,613 1

Hash Left Join (cost=2,633,055.22..5,132,833.03 rows=742,212 width=360) (actual time=1,326.035..5,585.340 rows=1,222,613 loops=1)

  • Hash Cond: (("UADCLD"."REQT_ID_N" = "UADEIB"."REQT_ID_N") AND ("UADCLD"."THD_ID_N" = "UADEIB"."THD_ID_N"))
2. 634.991 4,397.979 ↓ 1.6 1,222,613 1

Hash Left Join (cost=2,627,978.85..5,077,471.79 rows=742,212 width=93) (actual time=1,326.007..4,397.979 rows=1,222,613 loops=1)

  • Hash Cond: (("UADCLD"."REQT_ID_N" = "UADR1B"."REQT_ID_N") AND ("UADCLD"."THD_ID_N" = "UADR1B"."THD_ID_N"))
3. 1,843.776 3,762.930 ↓ 1.6 1,222,613 1

Hash Join (cost=2,617,074.75..5,062,671.08 rows=742,212 width=89) (actual time=1,325.935..3,762.930 rows=1,222,613 loops=1)

  • Hash Cond: (("UADCLD"."LIM_ID_N" = "UADLIM"."LIM_ID_N") AND ("UADCLD"."THD_ID_N" = "UADLIM"."THD_ID_N"))
  • Join Filter: (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 "UADLIM"."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 Join Filter: 615
4. 603.502 667.895 ↓ 1.1 1,223,228 1

Bitmap Heap Scan on "UADCLD" (cost=26,478.13..2,436,098.40 rows=1,143,427 width=32) (actual time=74.191..667.895 rows=1,223,228 loops=1)

  • Recheck Cond: ("CONTR_ID_N" = 12562)
  • Heap Blocks: exact=55533
5. 64.393 64.393 ↓ 1.1 1,223,228 1

Bitmap Index Scan on "UADCLDS01" (cost=0.00..26,192.27 rows=1,143,427 width=0) (actual time=64.393..64.393 rows=1,223,228 loops=1)

  • Index Cond: ("CONTR_ID_N" = 12562)
6. 572.362 1,251.259 ↑ 1.0 1,223,226 1

Hash (cost=2,557,904.67..2,557,904.67 rows=1,223,530 width=69) (actual time=1,251.259..1,251.259 rows=1,223,226 loops=1)

  • Buckets: 65536 Batches: 64 Memory Usage: 1923kB
7. 627.817 678.897 ↑ 1.0 1,223,226 1

Bitmap Heap Scan on "UADLIM" (cost=28,330.93..2,557,904.67 rows=1,223,530 width=69) (actual time=53.929..678.897 rows=1,223,226 loops=1)

  • Recheck Cond: ("CONTR_ID_N" = 12562)
  • Heap Blocks: exact=19117
8. 51.080 51.080 ↑ 1.0 1,223,226 1

Bitmap Index Scan on "UADLIMU01" (cost=0.00..28,025.04 rows=1,223,530 width=0) (actual time=51.080..51.080 rows=1,223,226 loops=1)

  • Index Cond: ("CONTR_ID_N" = 12562)
9. 0.018 0.058 ↑ 82.3 48 1

Hash (cost=10,844.83..10,844.83 rows=3,951 width=12) (actual time=0.058..0.058 rows=48 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 34kB
10. 0.040 0.040 ↑ 82.3 48 1

Index Scan using "UADR1BS11" on "UADR1B" (cost=0.57..10,844.83 rows=3,951 width=12) (actual time=0.017..0.040 rows=48 loops=1)

  • Index Cond: ("CONTR_ID_N" = 12562)
11. 0.004 0.017 ↑ 532.7 3 1

Hash (cost=5,052.40..5,052.40 rows=1,598 width=259) (actual time=0.017..0.017 rows=3 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 17kB
12. 0.013 0.013 ↑ 532.7 3 1

Index Scan using "UADEIBS01" on "UADEIB" (cost=0.57..5,052.40 rows=1,598 width=259) (actual time=0.010..0.013 rows=3 loops=1)

  • Index Cond: ("CONTR_ID_N" = 12562)