explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W4rj

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

Limit (cost=0.00..105.20 rows=1 width=1,717) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Seq Scan on act_ru_job res (cost=0.00..105.20 rows=1 width=1,717) (actual rows= loops=)

  • Filter: ((retries_ > 0) AND ((duedate_ IS NULL) OR (duedate_ <= '2019-11-23 17:50:14.337'::timestamp without time zone)) AND ((lock_owner_ IS NULL) OR (lock_exp_time_ < '2019-11-23 17:50:14.337'::timestamp without time zone)) AND (suspension_state_ = 1) AND ((exclusive_ AND (NOT (alternatives: SubPlan 1 or hashed SubPlan 2))) OR (NOT exclusive_)))
3.          

SubPlan (for Seq Scan)

4. 0.000 0.000 ↓ 0.0

Index Scan using act_idx_job_procinst on act_ru_job j2 (cost=0.14..2.36 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((process_instance_id_)::text = (res.process_instance_id_)::text)
  • Filter: (exclusive_ AND (lock_owner_ IS NOT NULL) AND (lock_exp_time_ >= '2019-11-23 17:50:14.337'::timestamp without time zone))
5. 0.000 0.000 ↓ 0.0

Seq Scan on act_ru_job j2_1 (cost=0.00..10.50 rows=1 width=37) (actual rows= loops=)

  • Filter: (exclusive_ AND (lock_owner_ IS NOT NULL) AND (lock_exp_time_ >= '2019-11-23 17:50:14.337'::timestamp without time zone))