explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hQxf

Settings
# exclusive inclusive rows x rows loops node
1. 81.762 673.202 ↓ 1.1 174,983 1

Unique (cost=44,471.20..45,242.09 rows=154,178 width=41) (actual time=538.430..673.202 rows=174,983 loops=1)

2. 181.218 591.440 ↓ 1.2 178,729 1

Sort (cost=44,471.20..44,856.65 rows=154,178 width=41) (actual time=538.429..591.440 rows=178,729 loops=1)

  • Sort Key: clmdetn_t.dcps_clm_uid, clmdetn_t.insrt_ts DESC
  • Sort Method: external merge Disk: 10,168kB
3. 171.932 410.222 ↓ 1.2 178,729 1

Hash Left Join (cost=15,200.73..26,439.50 rows=154,178 width=41) (actual time=134.037..410.222 rows=178,729 loops=1)

  • 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))
  • Rows Removed by Filter: 6,548
4. 104.474 104.474 ↑ 1.0 185,277 1

Seq Scan on clmdetn_t (cost=0.00..6,592.41 rows=185,658 width=41) (actual time=0.008..104.474 rows=185,277 loops=1)

  • Filter: (detn_typ_cd IS NOT NULL)
  • Rows Removed by Filter: 1,134
5. 63.930 133.816 ↑ 1.0 182,723 1

Hash (cost=12,016.99..12,016.99 rows=183,099 width=9) (actual time=133.815..133.816 rows=182,723 loops=1)

  • Buckets: 131,072 Batches: 4 Memory Usage: 2,855kB
6. 69.886 69.886 ↑ 1.0 182,723 1

Seq Scan on caseanly_t (cost=0.00..12,016.99 rows=183,099 width=9) (actual time=0.004..69.886 rows=182,723 loops=1)

Planning time : 0.288 ms
Execution time : 707.392 ms