explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FuuW

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

Limit (cost=20,495.88..20,495.94 rows=1 width=797) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Unique (cost=20,495.88..20,495.94 rows=1 width=797) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=20,495.88..20,495.89 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 (cost=20,491.89..20,495.87 rows=1 width=797) (actual rows= loops=)

  • Join Filter: ((res.proc_def_id_)::text = (p.id_)::text)
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=20,491.89..20,494.13 rows=1 width=797) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

HashAggregate (cost=20,491.48..20,491.49 rows=1 width=37) (actual rows= loops=)

  • Group Key: (act_ru_variable.execution_id_)::text
7. 0.000 0.000 ↓ 0.0

Index Scan using act_uniq_variable on act_ru_variable (cost=0.54..20,491.48 rows=1 width=37) (actual rows= loops=)

  • Index Cond: ((name_)::text = 'logisticalOrderId'::text)
  • Filter: ((type_ IS NOT NULL) AND (text_ IS NOT NULL) AND ((type_)::text = 'string'::text) AND ((text_)::text = 'e856b4c1-fb2b-46ee-af
8. 0.000 0.000 ↓ 0.0

Index Scan using act_idx_act_ru_execution_id_rev on act_ru_execution res (cost=0.41..2.63 rows=1 width=797) (actual rows= loops=)

  • Index Cond: ((id_)::text = (act_ru_variable.execution_id_)::text)
  • Filter: (parent_id_ IS NULL)
9. 0.000 0.000 ↓ 0.0

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