explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NNYH

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

Limit (cost=9,742.67..9,742.72 rows=1 width=797) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Unique (cost=9,742.67..9,742.72 rows=1 width=797) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=9,742.67..9,742.67 rows=1 width=797) (actual rows= loops=)

  • Sort Key: res.id_, res.rev_, res.root_proc_inst_id_, res.proc_inst_id_, res.business_key_, res.parent_id_, res.proc_def_id_, res.super_exec_, res.super_case_
4. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=4,376.60..9,742.66 rows=1 width=797) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4,376.19..7,558.56 rows=381 width=797) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on act_re_procdef p (cost=0.00..1.41 rows=1 width=52) (actual rows= loops=)

  • Filter: ((key_)::text = 'sub-tms-announcement'::text)
7. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on act_ru_execution res (cost=4,376.19..7,525.68 rows=3,147 width=797) (actual rows= loops=)

  • Recheck Cond: ((parent_id_ IS NULL) AND ((proc_def_id_)::text = (p.id_)::text))
8. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=4,376.19..4,376.19 rows=3,147 width=0) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on act_idx_exe_parent (cost=0.00..1,685.43 rows=12,588 width=0) (actual rows= loops=)

  • Index Cond: (parent_id_ IS NULL)
10. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on act_idx_exe_procdef (cost=0.00..2,686.58 rows=9,365 width=0) (actual rows= loops=)

  • Index Cond: ((proc_def_id_)::text = (p.id_)::text)
11. 0.000 0.000 ↓ 0.0

Index Scan using act_idx_var_exe on act_ru_variable (cost=0.42..5.72 rows=1 width=37) (actual rows= loops=)

  • Index Cond: ((execution_id_)::text = (res.id_)::text)
  • Filter: ((type_ IS NOT NULL) AND (text_ IS NOT NULL) AND ((name_)::text = 'deliveryOrderId'::text) AND ((type_)::text = 'string'::text) AND ((tex