explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EcSe

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 606.641 ↓ 3.8 15 1

Limit (cost=793.98..793.99 rows=4 width=676) (actual time=606.639..606.641 rows=15 loops=1)

2. 0.144 606.638 ↓ 3.8 15 1

Sort (cost=793.98..793.99 rows=4 width=676) (actual time=606.637..606.638 rows=15 loops=1)

  • Sort Key: bpmnproces3_.name
  • Sort Method: quicksort Memory: 30kB
3. 0.049 606.494 ↓ 3.8 15 1

Nested Loop (cost=5.72..793.94 rows=4 width=676) (actual time=13.915..606.494 rows=15 loops=1)

  • Join Filter: (bpmnfilter1_.bpmn_filter_id = assignment2_.id)
  • Rows Removed by Join Filter: 243
4. 0.110 606.359 ↑ 1.4 86 1

Merge Join (cost=5.72..785.22 rows=118 width=684) (actual time=13.896..606.359 rows=86 loops=1)

  • Merge Cond: (bpmnfilter1_.bpmn_process_id = bpmnproces0_.id)
5. 0.085 606.083 ↑ 1.4 86 1

Nested Loop (cost=0.85..91,161.88 rows=117 width=101) (actual time=13.738..606.083 rows=86 loops=1)

6. 605.730 605.730 ↑ 1.8 67 1

Index Scan using idx_sys_bpmn_process_settings_bpmn_process_id on sys_bpmn_process_settings bpmnproces3_ (cost=0.42..90,176.19 rows=118 width=85) (actual time=13.724..605.730 rows=67 loops=1)

  • Filter: actual_for_process
  • Rows Removed by Filter: 763683
7. 0.268 0.268 ↑ 1.0 1 67

Index Scan using idx_bpmn_def_filter_relation_bpmn_process_id on sys_bpmn_def_filter_relation bpmnfilter1_ (cost=0.42..8.34 rows=1 width=16) (actual time=0.003..0.004 rows=1 loops=67)

  • Index Cond: (bpmn_process_id = bpmnproces3_.bpmn_process_id)
8. 0.118 0.166 ↓ 1.3 86 1

Sort (cost=4.87..5.04 rows=67 width=599) (actual time=0.152..0.166 rows=86 loops=1)

  • Sort Key: bpmnproces0_.id
  • Sort Method: quicksort Memory: 34kB
9. 0.048 0.048 ↑ 1.0 67 1

Seq Scan on sys_bpmn_process bpmnproces0_ (cost=0.00..2.84 rows=67 width=599) (actual time=0.016..0.048 rows=67 loops=1)

  • Filter: ((NOT disabled) AND (end_date > '2020-05-22'::date))
10. 0.055 0.086 ↑ 1.0 3 86

Materialize (cost=0.00..3.42 rows=3 width=8) (actual time=0.000..0.001 rows=3 loops=86)

11. 0.031 0.031 ↑ 1.0 3 1

Seq Scan on sys_bpmn_def_filter assignment2_ (cost=0.00..3.40 rows=3 width=8) (actual time=0.012..0.031 rows=3 loops=1)

  • Filter: (id = ANY ('{2,31,100}'::bigint[]))
  • Rows Removed by Filter: 86
Planning time : 2.546 ms
Execution time : 606.829 ms