explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hN6V : 1

Settings
# exclusive inclusive rows x rows loops node
1. 9,296.399 69,270.422 ↓ 1.5 86,367 1

Hash Join (cost=1,492.66..7,472,209.80 rows=59,420 width=53) (actual time=29.377..69,270.422 rows=86,367 loops=1)

  • Hash Cond: (wtd.unit_id = wpud.unit_id)
2. 97.415 121.491 ↓ 1.1 102,629 1

Bitmap Heap Scan on wfm_task_detail wtd (cost=1,480.44..35,789.75 rows=97,177 width=48) (actual time=28.037..121.491 rows=102,629 loops=1)

  • Recheck Cond: (task_end_dt IS NULL)
3. 24.076 24.076 ↓ 1.1 109,717 1

Bitmap Index Scan on idx_wfm_task_detail_proc_id_unit_id_location_cd_1 (cost=0.00..1,456.15 rows=97,177 width=0) (actual time=24.076..24.076 rows=109,717 loops=1)

4. 0.057 0.201 ↑ 1.3 72 1

Hash (cost=9.10..9.10 rows=96 width=12) (actual time=0.201..0.201 rows=72 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 4kB
5. 0.144 0.144 ↑ 1.3 72 1

Seq Scan on wfm_process_unit_dtl wpud (cost=0.00..9.10 rows=96 width=12) (actual time=0.015..0.144 rows=72 loops=1)

  • Filter: (module_id = ANY ('{17,11}'::numeric[]))
  • Rows Removed by Filter: 48
6.          

SubPlan (for Hash Join)

7. 604.569 604.569 ↓ 0.0 0 86,367

Index Scan using partial_idx_wfm on wfm_task_lock_history h (cost=0.00..4.34 rows=1 width=6) (actual time=0.007..0.007 rows=0 loops=86,367)

  • Index Cond: (task_id = wtd.task_id)
8. 59,247.762 59,247.762 ↑ 1.0 1 86,367

Seq Scan on gen_head_of_cir_dtl h (cost=0.00..120.51 rows=1 width=6) (actual time=0.498..0.686 rows=1 loops=86,367)

  • Filter: ((active_to IS NULL) AND (wtd.location_cd = location_id))
  • Rows Removed by Filter: 2,653"Total runtime: 69,292.824 ms