explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yjziR

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.333 ↑ 280.0 21 1

Limit (cost=1.75..4.41 rows=5,879 width=1,202) (actual time=0.186..0.333 rows=21 loops=1)

2. 0.035 0.328 ↑ 280.0 21 1

Merge Join (cost=1.75..4.41 rows=5,879 width=1,202) (actual time=0.183..0.328 rows=21 loops=1)

  • Merge Cond: (bpmnfilter1_.bpmn_process_id = bpmnproces0_.id)
3. 0.037 0.174 ↑ 282.7 24 1

Nested Loop (cost=0.28..691.00 rows=6,784 width=606) (actual time=0.057..0.174 rows=24 loops=1)

  • Join Filter: (bpmnfilter1_.bpmn_filter_id = assignment2_.id)
  • Rows Removed by Join Filter: 20
4. 0.089 0.089 ↑ 282.7 24 1

Index Scan using sys_bpmn_def_filter_relation_bpmn_process_id_index on sys_bpmn_def_filter_relation bpmnfilter1_ (cost=0.28..343.74 rows=6,784 width=548) (actual time=0.016..0.089 rows=24 loops=1)

5. 0.024 0.048 ↑ 2.0 2 24

Materialize (cost=0.00..1.29 rows=4 width=58) (actual time=0.002..0.002 rows=2 loops=24)

6. 0.024 0.024 ↑ 1.3 3 1

Seq Scan on sys_bpmn_def_filter assignment2_ (cost=0.00..1.27 rows=4 width=58) (actual time=0.021..0.024 rows=3 loops=1)

  • Filter: (id = ANY ('{1,2,3,5,6,9,12,13,14,17,19,22,25,28,31,32,35,38,41,44,47,50,53,58,59,62,65,68,69,70,71,72,73,76,77,80,83,84,85,88,91,94,97,100,103}'::bigint[]))
7. 0.065 0.119 ↑ 1.0 13 1

Sort (cost=1.47..1.50 rows=13 width=596) (actual time=0.118..0.119 rows=13 loops=1)

  • Sort Key: bpmnproces0_.id
  • Sort Method: quicksort Memory: 26kB
8. 0.054 0.054 ↑ 1.0 13 1

Seq Scan on sys_bpmn_process bpmnproces0_ (cost=0.00..1.23 rows=13 width=596) (actual time=0.023..0.054 rows=13 loops=1)

  • Filter: ((NOT disabled) AND (end_date > to_date('01.10.2018'::text, 'dd.mm.yyyy'::text)))
  • Rows Removed by Filter: 2