explain.depesz.com

PostgreSQL's explain analyze made readable

Result: clIy

Settings

Optimization(s) for this plan:

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

Delete on act_hi_actinst aha (cost=0.29..2,073,065.45 rows=30,145,631 width=12) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..2,073,065.45 rows=30,145,631 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=6) (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

Seq Scan on act_hi_actinst aha (cost=0.00..1,771,604.31 rows=30,145,631 width=6) (actual rows= loops=)