explain.depesz.com

PostgreSQL's explain analyze made readable

Result: p9PC

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 1.086 ↓ 3.8 15 1

Limit (cost=27.60..27.61 rows=4 width=676) (actual time=1.082..1.086 rows=15 loops=1)

2. 0.112 1.082 ↓ 3.8 15 1

Sort (cost=27.60..27.61 rows=4 width=676) (actual time=1.081..1.082 rows=15 loops=1)

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

Merge Join (cost=24.91..27.56 rows=4 width=676) (actual time=0.593..0.970 rows=15 loops=1)

  • Merge Cond: (bpmnfilter1_.bpmn_process_id = bpmnproces0_.id)
4. 0.039 0.701 ↓ 3.8 15 1

Merge Join (cost=20.04..29.26 rows=4 width=93) (actual time=0.351..0.701 rows=15 loops=1)

  • Merge Cond: (bpmnfilter1_.bpmn_process_id = bpmnproces3_.bpmn_process_id)
5. 0.073 0.352 ↑ 1,111.6 16 1

Nested Loop (cost=0.42..81,475.27 rows=17,786 width=8) (actual time=0.044..0.352 rows=16 loops=1)

  • Join Filter: (bpmnfilter1_.bpmn_filter_id = assignment2_.id)
  • Rows Removed by Join Filter: 243
6. 0.192 0.192 ↑ 6,951.0 87 1

Index Scan using idx_bpmn_def_filter_relation_bpmn_process_id on sys_bpmn_def_filter_relation bpmnfilter1_ (cost=0.42..54,258.56 rows=604,740 width=16) (actual time=0.014..0.192 rows=87 loops=1)

7. 0.052 0.087 ↑ 1.0 3 87

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

8. 0.035 0.035 ↑ 1.0 3 1

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

  • Filter: (id = ANY ('{2,31,100}'::bigint[]))
  • Rows Removed by Filter: 86
9. 0.149 0.310 ↑ 2.4 52 1

Sort (cost=18.99..19.31 rows=127 width=85) (actual time=0.302..0.310 rows=52 loops=1)

  • Sort Key: bpmnproces3_.bpmn_process_id
  • Sort Method: quicksort Memory: 44kB
10. 0.161 0.161 ↑ 1.9 67 1

Index Scan using idx_sys_bpmn_process_settings_actual_for_process on sys_bpmn_process_settings bpmnproces3_ (cost=0.42..14.55 rows=127 width=85) (actual time=0.074..0.161 rows=67 loops=1)

  • Index Cond: (actual_for_process = true)
  • Filter: actual_for_process
11. 0.170 0.248 ↑ 1.3 52 1

Sort (cost=4.87..5.04 rows=67 width=599) (actual time=0.239..0.248 rows=52 loops=1)

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

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

  • Filter: ((NOT disabled) AND (end_date > '2020-05-22'::date))
Planning time : 1.882 ms
Execution time : 1.369 ms