explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r3pn

Settings
# exclusive inclusive rows x rows loops node
1. 0.033 711.472 ↓ 69.0 69 1

Unique (cost=5,162.20..5,162.25 rows=1 width=623) (actual time=711.436..711.472 rows=69 loops=1)

  • Output: res.id_, res.rev_, res.proc_inst_id_, res.business_key_, res.parent_id_, res.proc_def_id_, res.super_exec_, res.super_case_exec_, res.case_inst_id_, res.act_id_, res.act_inst_id_, res.is_active_, res.is_concurrent_, res.is_scop
  • Buffers: shared hit=275299
2. 0.387 711.439 ↓ 69.0 69 1

Sort (cost=5,162.20..5,162.21 rows=1 width=623) (actual time=711.435..711.439 rows=69 loops=1)

  • Output: res.id_, res.rev_, res.proc_inst_id_, res.business_key_, res.parent_id_, res.proc_def_id_, res.super_exec_, res.super_case_exec_, res.case_inst_id_, res.act_id_, res.act_inst_id_, res.is_active_, res.is_concurrent_, res.i
  • Sort Key: res.id_, res.rev_, res.proc_inst_id_, res.business_key_, res.parent_id_, res.proc_def_id_, res.super_exec_, res.super_case_exec_, res.case_inst_id_, res.act_id_, res.act_inst_id_, res.is_active_, res.is_concurrent_, res
  • Sort Method: quicksort Memory: 43kB
  • Buffers: shared hit=275299
3. 0.089 711.052 ↓ 69.0 69 1

Nested Loop Semi Join (cost=1.64..5,162.19 rows=1 width=623) (actual time=102.032..711.052 rows=69 loops=1)

  • Output: res.id_, res.rev_, res.proc_inst_id_, res.business_key_, res.parent_id_, res.proc_def_id_, res.super_exec_, res.super_case_exec_, res.case_inst_id_, res.act_id_, res.act_inst_id_, res.is_active_, res.is_concurrent_,
  • Buffers: shared hit=275285
4. 0.000 709.955 ↓ 72.0 72 1

Nested Loop Semi Join (cost=1.09..5,149.91 rows=1 width=633) (actual time=66.581..709.955 rows=72 loops=1)

  • Output: res.id_, res.rev_, res.proc_inst_id_, res.business_key_, res.parent_id_, res.proc_def_id_, res.super_exec_, res.super_case_exec_, res.case_inst_id_, res.act_id_, res.act_inst_id_, res.is_active_, res.is_concur
  • Buffers: shared hit=274612
5. 4.219 52.574 ↓ 77.8 19,985 1

Nested Loop (cost=0.54..3,494.69 rows=257 width=623) (actual time=0.138..52.574 rows=19,985 loops=1)

  • Output: res.id_, res.rev_, res.proc_inst_id_, res.business_key_, res.parent_id_, res.proc_def_id_, res.super_exec_, res.super_case_exec_, res.case_inst_id_, res.act_id_, res.act_inst_id_, res.is_active_, res.is_
  • Buffers: shared hit=25415
6. 0.074 0.074 ↑ 1.0 1 1

Seq Scan on bpm.act_re_procdef p (cost=0.00..5.85 rows=1 width=30) (actual time=0.062..0.074 rows=1 loops=1)

  • Output: p.id_, p.rev_, p.category_, p.name_, p.key_, p.version_, p.deployment_id_, p.resource_name_, p.dgrm_resource_name_, p.has_start_form_key_, p.suspension_state_, p.tenant_id_, p.version_tag_
  • Filter: ((p.key_)::text = 'offer-purchase-mobile-part1_2_2'::text)
  • Rows Removed by Filter: 118
  • Buffers: shared hit=4
7. 48.281 48.281 ↓ 14.2 19,985 1

Index Scan using act_ru_execution_proc_def_id__idx on bpm.act_ru_execution res (cost=0.54..3,474.74 rows=1,410 width=623) (actual time=0.072..48.281 rows=19,985 loops=1)

  • Output: res.id_, res.rev_, res.proc_inst_id_, res.business_key_, res.parent_id_, res.proc_def_id_, res.super_exec_, res.super_case_exec_, res.case_inst_id_, res.act_id_, res.act_inst_id_, res.is_active_, r
  • Index Cond: ((res.proc_def_id_)::text = (p.id_)::text)
  • Filter: ((res.parent_id_ IS NULL) AND (res.suspension_state_ = 1))
  • Rows Removed by Filter: 214
  • Buffers: shared hit=25411
8. 659.505 659.505 ↓ 0.0 0 19,985

Index Scan using act_ru_variable_execution_id__idx on bpm.act_ru_variable (cost=0.55..6.42 rows=1 width=10) (actual time=0.033..0.033 rows=0 loops=19,985)

  • Output: act_ru_variable.id_, act_ru_variable.rev_, act_ru_variable.type_, act_ru_variable.name_, act_ru_variable.execution_id_, act_ru_variable.proc_inst_id_, act_ru_variable.case_execution_id_, act_ru_variable.
  • Index Cond: ((act_ru_variable.execution_id_)::text = (res.id_)::text)
  • Filter: ((act_ru_variable.type_ IS NOT NULL) AND (act_ru_variable.text_ IS NOT NULL) AND ((act_ru_variable.name_)::text = 'deliveryType'::text) AND ((act_ru_variable.type_)::text = 'string'::text) AND (act_ru_va
  • Rows Removed by Filter: 30
  • Buffers: shared hit=249197
9. 1.008 1.008 ↑ 1.0 1 72

Index Scan using act_ru_variable_execution_id__idx on bpm.act_ru_variable act_ru_variable_1 (cost=0.55..6.42 rows=1 width=10) (actual time=0.014..0.014 rows=1 loops=72)

  • Output: act_ru_variable_1.id_, act_ru_variable_1.rev_, act_ru_variable_1.type_, act_ru_variable_1.name_, act_ru_variable_1.execution_id_, act_ru_variable_1.proc_inst_id_, act_ru_variable_1.case_execution_id_, act_ru_v
  • Index Cond: ((act_ru_variable_1.execution_id_)::text = (res.id_)::text)
  • Filter: ((act_ru_variable_1.type_ IS NOT NULL) AND (act_ru_variable_1.long_ IS NOT NULL) AND (act_ru_variable_1.long_ < '1562295720260'::bigint) AND ((act_ru_variable_1.name_)::text = 'deliveryDate'::text) AND ((act_r
  • Rows Removed by Filter: 18
  • Buffers: shared hit=673
Planning time : 1.194 ms
Execution time : 711.620 ms