explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sPR1

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 4,620.649 ↑ 1.0 50 1

Limit (cost=811,750.49..811,751.74 rows=50 width=105) (actual time=4,620.602..4,620.649 rows=50 loops=1)

2. 0.031 4,620.637 ↑ 1.7 50 1

Unique (cost=811,750.49..811,752.59 rows=84 width=105) (actual time=4,620.600..4,620.637 rows=50 loops=1)

3. 18.105 4,620.606 ↑ 1.7 50 1

Sort (cost=811,750.49..811,750.70 rows=84 width=105) (actual time=4,620.598..4,620.606 rows=50 loops=1)

  • Sort Key: tasks.start_time_, (('activiti$'::text || (tasks.id_)::text)), (('workspace://SpacesStore/'::text || (docnode.uuid)::text)), initiatorlink.user_id_, tasks.priority_, tasks.description_, (bool_or(COALESCE(((lmr_viewshistory.text_)::t (...)
  • Sort Method: quicksort Memory: 6007kB
4. 20.940 4,602.501 ↓ 234.8 19,723 1

WindowAgg (cost=811,745.07..811,747.80 rows=84 width=105) (actual time=4,594.769..4,602.501 rows=19,723 loops=1)

5. 82.126 4,581.561 ↓ 234.8 19,723 1

HashAggregate (cost=811,745.07..811,746.33 rows=84 width=105) (actual time=4,565.384..4,581.561 rows=19,723 loops=1)

6. 38.839 4,499.435 ↓ 235.2 19,756 1

Nested Loop Left Join (cost=201,371.67..811,743.18 rows=84 width=105) (actual time=316.633..4,499.435 rows=19,756 loops=1)

7. 13.449 4,046.413 ↓ 234.8 19,723 1

Nested Loop (cost=201,371.10..729,028.98 rows=84 width=92) (actual time=316.604..4,046.413 rows=19,723 loops=1)

8. 13.789 3,894.903 ↓ 66.0 19,723 1

Nested Loop (cost=201,370.66..728,856.19 rows=299 width=63) (actual time=316.589..3,894.903 rows=19,723 loops=1)

9. 34.857 3,743.053 ↓ 70.4 19,723 1

Nested Loop (cost=201,370.10..725,426.36 rows=280 width=63) (actual time=316.565..3,743.053 rows=19,723 loops=1)

10. 34.318 3,274.290 ↓ 14.4 19,723 1

Nested Loop (cost=201,369.54..721,002.69 rows=1,367 width=75) (actual time=316.528..3,274.290 rows=19,723 loops=1)

11. 732.281 2,529.944 ↓ 7.3 19,723 1

Merge Join (cost=201,368.97..326,766.06 rows=2,700 width=64) (actual time=316.487..2,529.944 rows=19,723 loops=1)

  • Merge Cond: ((initiatorlink.task_id_)::text = (tasks.id_)::text)
12. 1,474.255 1,474.255 ↑ 1.9 1,173,137 1

Index Scan using act_idx_tskass_task on act_ru_identitylink initiatorlink (cost=0.43..342,941.96 rows=2,253,413 width=19) (actual time=0.010..1,474.255 rows=1,173,137 loops=1)

  • Filter: ((type_)::text = 'starter'::text)
  • Rows Removed by Filter: 725932
13. 118.660 323.408 ↓ 1.2 19,723 1

Sort (cost=201,368.54..201,408.81 rows=16,110 width=54) (actual time=316.222..323.408 rows=19,723 loops=1)

  • Sort Key: tasks.id_
  • Sort Method: quicksort Memory: 3542kB
14. 103.696 204.748 ↓ 1.2 19,723 1

Bitmap Heap Scan on act_hi_taskinst tasks (cost=48,660.19..200,242.80 rows=16,110 width=54) (actual time=136.683..204.748 rows=19,723 loops=1)

  • Recheck Cond: ((end_time_ IS NULL) AND (upper((form_key_)::text) = 'LMRIDWF:ACTIVITIREVIEWTASK'::text))
  • Filter: ((upper((assignee_)::text) = 'DOVBETA.DMYTRO'::text) OR ((hashed SubPlan 1) AND (assignee_ IS NULL)) OR ((hashed SubPlan 2) AND (assignee_ IS NULL)))
  • Rows Removed by Filter: 14371
15. 9.421 9.421 ↑ 3.4 34,097 1

Bitmap Index Scan on idx_act_hi_taskinst_end_time_up_form_key_up_assignee (cost=0.00..5,181.28 rows=117,272 width=0) (actual time=9.421..9.421 rows=34,097 loops=1)

  • Index Cond: ((end_time_ IS NULL) AND (upper((form_key_)::text) = 'LMRIDWF:ACTIVITIREVIEWTASK'::text))
16.          

SubPlan (forBitmap Heap Scan)

17. 0.624 0.726 ↑ 16.4 14 1

Bitmap Heap Scan on act_ru_identitylink (cost=41.15..5,818.87 rows=230 width=9) (actual time=0.165..0.726 rows=14 loops=1)

  • Recheck Cond: ((user_id_)::text = 'dovbeta.dmytro'::text)
  • Filter: ((type_)::text = 'candidate'::text)
  • Rows Removed by Filter: 387
18. 0.102 0.102 ↑ 4.0 425 1

Bitmap Index Scan on act_idx_ident_lnk_user (cost=0.00..41.09 rows=1,688 width=0) (actual time=0.102..0.102 rows=425 loops=1)

  • Index Cond: ((user_id_)::text = 'dovbeta.dmytro'::text)
19. 17.802 90.905 ↓ 4,093.1 49,117 1

Nested Loop (cost=1.57..37,655.41 rows=12 width=9) (actual time=3.149..90.905 rows=49,117 loops=1)

20. 0.026 5.761 ↓ 2.8 11 1

Nested Loop (cost=1.14..24,388.69 rows=4 width=21) (actual time=3.043..5.761 rows=11 loops=1)

21. 5.625 5.625 ↓ 11.0 11 1

Index Scan using fk_alf_cass_tqn on alf_child_assoc groupsassocs (cost=0.44..24,374.56 rows=1 width=8) (actual time=3.010..5.625 rows=11 loops=1)

  • Index Cond: (type_qname_id = 95)
  • Filter: ((qname_localname)::text = 'dovbeta.dmytro'::text)
  • Rows Removed by Filter: 8165
22. 0.110 0.110 ↑ 4.0 1 11

Index Scan using alf_node_properties_pkey on alf_node_properties groups (cost=0.70..14.09 rows=4 width=29) (actual time=0.010..0.010 rows=1 loops=11)

  • Index Cond: ((node_id = groupsassocs.parent_node_id) AND (qname_id = 92))
23. 67.342 67.342 ↑ 4.2 4,465 11

Index Scan using act_idx_ident_lnk_group on act_ru_identitylink link (cost=0.43..3,127.00 rows=18,968 width=25) (actual time=0.013..6.122 rows=4,465 loops=11)

  • Index Cond: ((group_id_)::text = (groups.string_value)::text)
  • Filter: ((type_)::text = 'candidate'::text)
24. 710.028 710.028 ↑ 9.0 1 19,723

Index Scan using act_idx_var_procinst on act_ru_variable bpmpackage (cost=0.56..145.92 rows=9 width=29) (actual time=0.022..0.036 rows=1 loops=19,723)

  • Index Cond: ((proc_inst_id_)::text = (tasks.proc_inst_id_)::text)
  • Filter: ((name_)::text = 'bpm_package'::text)
  • Rows Removed by Filter: 35
25. 433.906 433.906 ↑ 1.0 1 19,723

Index Scan using store_id on alf_node bpmpackagenode (cost=0.56..3.23 rows=1 width=45) (actual time=0.022..0.022 rows=1 loops=19,723)

  • Index Cond: ((store_id = 6) AND ((uuid)::text = "substring"((bpmpackage.text_)::text, 25)))
26. 138.061 138.061 ↑ 387.0 1 19,723

Index Only Scan using idx_alf_cass_pri on alf_child_assoc docnodeassoc (cost=0.56..8.38 rows=387 width=16) (actual time=0.006..0.007 rows=1 loops=19,723)

  • Index Cond: (parent_node_id = bpmpackagenode.id)
  • Heap Fetches: 179
27. 138.061 138.061 ↑ 1.0 1 19,723

Index Scan using alf_node_pkey on alf_node docnode (cost=0.44..0.57 rows=1 width=45) (actual time=0.006..0.007 rows=1 loops=19,723)

  • Index Cond: (id = docnodeassoc.child_node_id)
  • Filter: (store_id = 6)
28. 414.183 414.183 ↓ 0.0 0 19,723

Index Scan using act_idx_hi_detail_task_id on act_hi_detail lmr_viewshistory (cost=0.57..983.38 rows=131 width=22) (actual time=0.021..0.021 rows=0 loops=19,723)

  • Index Cond: ((task_id_)::text = (tasks.id_)::text)
  • Filter: ((name_)::text = 'lmr_viewsHistory'::text)
  • Rows Removed by Filter: 9