explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mzH2

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 594.487 ↓ 2.0 2 1

Nested Loop Left Join (cost=88,889.08..94,300.46 rows=1 width=42) (actual time=594.432..594.487 rows=2 loops=1)

  • Join Filter: (cssplhdg_t.dcps_case_uid = dcpscase_t.dcps_case_uid)
2. 4.310 594.462 ↓ 2.0 2 1

Merge Left Join (cost=88,888.66..94,291.79 rows=1 width=43) (actual time=594.411..594.462 rows=2 loops=1)

  • Merge Cond: (caseclm_t.dcps_clm_uid = clmdetn_t_1.dcps_clm_uid)
3. 0.006 0.073 ↓ 2.0 2 1

Nested Loop (cost=44,797.97..47,503.56 rows=1 width=22) (actual time=0.062..0.073 rows=2 loops=1)

4. 0.021 0.021 ↓ 2.0 2 1

Index Only Scan using ixpk_caseclm_t on caseclm_t (cost=0.42..8.44 rows=1 width=8) (actual time=0.018..0.021 rows=2 loops=1)

  • Index Cond: (dcps_case_uid = 15299)
  • Heap Fetches: 0
5. 0.006 0.046 ↑ 1.0 1 2

Merge Left Join (cost=44,797.55..47,495.11 rows=1 width=18) (actual time=0.022..0.023 rows=1 loops=2)

  • Merge Cond: (caseclm_t_1.dcps_clm_uid = clmdetn_t.dcps_clm_uid)
6. 0.006 0.040 ↑ 1.0 1 2

Sort (cost=17.37..17.37 rows=1 width=8) (actual time=0.020..0.020 rows=1 loops=2)

  • Sort Key: caseclm_t_1.dcps_clm_uid
  • Sort Method: quicksort Memory: 25kB
7. 0.003 0.034 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.26..17.36 rows=1 width=8) (actual time=0.032..0.034 rows=1 loops=1)

8. 0.008 0.029 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.84..16.89 rows=1 width=8) (actual time=0.027..0.029 rows=1 loops=1)

  • Join Filter: ((dcpscase_t.adjulvl_cd)::text = '2'::text)
  • Rows Removed by Join Filter: 1
9. 0.010 0.010 ↑ 1.0 1 1

Index Scan using ixpk_dcpscase_t on dcpscase_t (cost=0.42..8.44 rows=1 width=10) (actual time=0.009..0.010 rows=1 loops=1)

  • Index Cond: (dcps_case_uid = 15299)
10. 0.011 0.011 ↑ 1.0 1 1

Index Scan using ixn01_dcpscase_t on dcpscase_t dcpscase_t_1 (cost=0.42..8.44 rows=1 width=8) (actual time=0.010..0.011 rows=1 loops=1)

  • Index Cond: (dcpscase_t.fldr_num = fldr_num)
  • Filter: ((adjulvl_cd)::text = '1'::text)
11. 0.002 0.002 ↓ 0.0 0 1

Index Only Scan using ixpk_caseclm_t on caseclm_t caseclm_t_1 (cost=0.42..0.46 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (dcps_case_uid = dcpscase_t_1.dcps_case_uid)
  • Heap Fetches: 0
12. 0.000 0.000 ↓ 0.0 0

Unique (cost=44,780.19..45,550.91 rows=154,145 width=62) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Sort (cost=44,780.19..45,165.55 rows=154,145 width=62) (never executed)

  • Sort Key: clmdetn_t.dcps_clm_uid, clmdetn_t.insrt_ts DESC
14. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=15,191.30..25,701.57 rows=154,145 width=62) (never executed)

  • Hash Cond: (clmdetn_t.case_anl_uid = caseanly_t.case_anl_uid)
  • Filter: ((clmdetn_t.case_anl_uid IS NULL) OR ((caseanly_t.anl_stus_cd)::text = 'CLSD'::text))
15. 0.000 0.000 ↓ 0.0 0

Seq Scan on clmdetn_t (cost=0.00..6,591.01 rows=185,618 width=26) (never executed)

  • Filter: (detn_typ_cd IS NOT NULL)
16. 0.000 0.000 ↓ 0.0 0

Hash (cost=12,009.91..12,009.91 rows=182,991 width=9) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Seq Scan on caseanly_t (cost=0.00..12,009.91 rows=182,991 width=9) (never executed)

18. 8.421 590.079 ↑ 8.4 18,373 1

Unique (cost=44,090.69..44,861.41 rows=154,145 width=41) (actual time=575.999..590.079 rows=18,373 loops=1)

19. 141.558 581.658 ↑ 8.2 18,686 1

Sort (cost=44,090.69..44,476.05 rows=154,145 width=41) (actual time=575.997..581.658 rows=18,686 loops=1)

  • Sort Key: clmdetn_t_1.dcps_clm_uid, clmdetn_t_1.insrt_ts DESC
  • Sort Method: external merge Disk: 9872kB
20. 173.602 440.100 ↓ 1.2 178,706 1

Hash Left Join (cost=15,191.30..26,065.57 rows=154,145 width=41) (actual time=165.310..440.100 rows=178,706 loops=1)

  • Hash Cond: (clmdetn_t_1.case_anl_uid = caseanly_t_1.case_anl_uid)
  • Filter: ((clmdetn_t_1.case_anl_uid IS NULL) OR ((caseanly_t_1.anl_stus_cd)::text = 'CLSD'::text))
  • Rows Removed by Filter: 6551
21. 101.410 101.410 ↑ 1.0 185,257 1

Seq Scan on clmdetn_t clmdetn_t_1 (cost=0.00..6,591.01 rows=185,618 width=33) (actual time=0.010..101.410 rows=185,257 loops=1)

  • Filter: (detn_typ_cd IS NOT NULL)
  • Rows Removed by Filter: 1133
22. 79.597 165.088 ↑ 1.0 182,692 1

Hash (cost=12,009.91..12,009.91 rows=182,991 width=9) (actual time=165.088..165.088 rows=182,692 loops=1)

  • Buckets: 131072 Batches: 4 Memory Usage: 2854kB
23. 85.491 85.491 ↑ 1.0 182,692 1

Seq Scan on caseanly_t caseanly_t_1 (cost=0.00..12,009.91 rows=182,991 width=9) (actual time=0.006..85.491 rows=182,692 loops=1)

24. 0.018 0.018 ↓ 0.0 0 2

Index Scan using ix_cssplhdg_t_dcps_case_uid on cssplhdg_t (cost=0.42..8.64 rows=2 width=7) (actual time=0.009..0.009 rows=0 loops=2)

  • Index Cond: (dcps_case_uid = 15299)
Planning time : 4.947 ms
Execution time : 596.614 ms