explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zb4ay

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Delete on act_hi_actinst (cost=4,825.35..240,871.12 rows=71,791 width=12) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4,825.35..240,871.12 rows=71,791 width=12) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Scan using act_idx_hi_pro_inst_end on act_hi_procinst ahp (cost=0.29..4.83 rows=1 width=43) (actual rows= loops=)

  • Index Cond: ((end_time_ < '2018-01-01 00:00:00'::timestamp without time zone) AND (end_time_ IS NOT NULL))
4. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on act_hi_actinst (cost=4,825.07..240,148.38 rows=71,791 width=43) (actual rows= loops=)

  • Recheck Cond: ((proc_inst_id_)::text = (ahp.id_)::text)
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on act_idx_hi_act_inst_procinst (cost=0.00..4,807.12 rows=71,791 width=0) (actual rows= loops=)

  • Index Cond: ((proc_inst_id_)::text = (ahp.id_)::text)