"Limit (cost=6652.17..6654.42 rows=50 width=792)" " -> Unique (cost=6652.17..6656.13 rows=88 width=792)" " -> Sort (cost=6652.17..6652.39 rows=88 width=792)" " Sort Key: res.start_time_, res.id_, res.proc_inst_id_, res.business_key_, res.proc_def_key_, res.end_time_, res.duration_, res.start_user_id_, res.start_act_id_, res.end_act_id_, res.super_process_instance_id_, res.super_case_instance_id_, re (...)" " -> Nested Loop Left Join (cost=0.41..6649.33 rows=88 width=792)" " Join Filter: ((self.proc_def_key_)::text = (res.proc_def_key_)::text)" " Filter: (((res.proc_def_key_ IS NOT NULL) AND (self.proc_def_key_ IS NOT NULL)) OR (res.proc_def_key_ IS NULL))" " -> Seq Scan on act_hi_procinst res (cost=0.00..3293.43 rows=88 width=792)" " Filter: ((proc_def_id_)::text = 'leadQualification:35:80494eb9-e60d-11e6-8a76-0aa2e56f42b1'::text)" " -> Materialize (cost=0.41..3354.59 rows=1 width=13)" " -> Unique (cost=0.41..3354.57 rows=1 width=13)" " -> Subquery Scan on self (cost=0.41..3354.57 rows=1 width=13)" " Filter: ((SubPlan 9) = 1)" " -> Unique (cost=0.41..2886.51 rows=8 width=13)" " -> Index Only Scan using act_idx_hi_pro_inst_proc_def_key on act_hi_procinst dkey (cost=0.41..2780.03 rows=42594 width=13)" " SubPlan 9" " -> Result (cost=58.48..58.50 rows=1 width=0)" " InitPlan 2 (returns $2)" " -> Index Scan using act_uniq_auth_user on act_ru_authorization a_1 (cost=0.28..8.31 rows=1 width=0)" " Index Cond: ((type_ = 1) AND ((user_id_)::text = 'jakob.freund@camunda.com'::text) AND (resource_type_ = 6) AND ((resource_id_)::text = '*'::text))" " Filter: ((perms_ & 4096) = 4096)" " InitPlan 8 (returns $8)" " -> Result (cost=41.85..41.86 rows=1 width=0)" " InitPlan 4 (returns $4)" " -> Index Scan using act_uniq_auth_group on act_ru_authorization a_3 (cost=0.28..12.61 rows=1 width=0)" " Index Cond: ((type_ = 1) AND ((group_id_)::text = ANY ('{management,sales}'::text[])) AND (resource_type_ = 6) AND ((resource_id_)::text = '*'::text))" " Filter: ((perms_ & 4096) = 4096)" " InitPlan 7 (returns $7)" " -> Result (cost=16.62..16.63 rows=1 width=0)" " InitPlan 6 (returns $6)" " -> Index Scan using act_uniq_auth_group on act_ru_authorization a_5 (cost=0.28..8.31 rows=1 width=0)" " Index Cond: ((type_ = 0) AND (resource_type_ = 6) AND ((resource_id_)::text = '*'::text))" " Filter: (((user_id_)::text = '*'::text) AND ((perms_ & 4096) = 4096))" " SubPlan 5" " -> Index Scan using act_uniq_auth_group on act_ru_authorization a_4 (cost=0.28..8.31 rows=1 width=36)" " Index Cond: ((type_ = 0) AND (resource_type_ = 6) AND ((resource_id_)::text = (self.proc_def_key_)::text))" " Filter: (((user_id_)::text = '*'::text) AND ((perms_ & 4096) = 4096))" " SubPlan 3" " -> Index Scan using act_uniq_auth_group on act_ru_authorization a_2 (cost=0.28..12.61 rows=1 width=36)" " Index Cond: ((type_ = 1) AND ((group_id_)::text = ANY ('{management,sales}'::text[])) AND (resource_type_ = 6) AND ((resource_id_)::text = (self.proc_def_key_)::text))" " Filter: ((perms_ & 4096) = 4096)" " SubPlan 1" " -> Index Scan using act_uniq_auth_user on act_ru_authorization a (cost=0.28..8.31 rows=1 width=36)" " Index Cond: ((type_ = 1) AND ((user_id_)::text = 'jakob.freund@camunda.com'::text) AND (resource_type_ = 6) AND ((resource_id_)::text = (self.proc_def_key_)::text))" " Filter: ((perms_ & 4096) = 4096)"