explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EQaP

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

Limit (cost=2.37..2.40 rows=1 width=358) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0
→

Unique (cost=2.37..2.40 rows=1 width=358) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0
→

Sort (cost=2.37..2.37 rows=1 width=358) (actual rows= loops=)

  • Sort Key: id_, rev_, event_type_, execution_id_, activity_id_, configuration_, created_, tenant_id_
4. 0.000 0.000 ↓ 0.0
→

Index Scan using act_idx_event_subscr_evt_name on act_ru_event_subscr res (cost=0.41..2.36 rows=1 width=358) (actual rows= loops=)

  • Index Cond: ((event_name_)::text = 'taskStatusChangedMessage'::text)
  • Filter: ((proc_inst_id_)::text = '7b911672-0cd3-11ea-8828-000d3ab1b27a'::text)