explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hAvQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.037 3,113.319 ↑ 1.0 50 1

Limit (cost=450,640.07..1,962,451.26 rows=50 width=56) (actual time=3,094.383..3,113.319 rows=50 loops=1)

2. 0.061 3,113.282 ↑ 1.7 50 1

Nested Loop Left Join (cost=450,640.07..2,990,482.87 rows=84 width=56) (actual time=3,094.364..3,113.282 rows=50 loops=1)

3. 0.068 3,112.271 ↑ 1.7 50 1

Nested Loop (cost=450,639.50..2,122,802.34 rows=84 width=56) (actual time=3,094.331..3,112.271 rows=50 loops=1)

4. 0.036 3,111.953 ↑ 6.0 50 1

Nested Loop (cost=450,639.06..2,120,984.73 rows=298 width=27) (actual time=3,094.314..3,111.953 rows=50 loops=1)

5. 0.083 3,111.667 ↑ 5.6 50 1

Nested Loop (cost=450,638.50..2,115,940.82 rows=279 width=27) (actual time=3,094.290..3,111.667 rows=50 loops=1)

6. 4.009 3,110.534 ↑ 27.2 50 1

Hash Join (cost=450,637.94..2,107,226.54 rows=1,361 width=39) (actual time=3,094.230..3,110.534 rows=50 loops=1)

  • Hash Cond: ((bpmpackage.proc_inst_id_)::text = (tasks.proc_inst_id_)::text)
7. 13.484 13.484 ↑ 555.4 2,449 1

Seq Scan on act_ru_variable bpmpackage (cost=0.00..1,250,225.10 rows=1,360,167 width=29) (actual time=0.029..13.484 rows=2,449 loops=1)

  • Filter: ((name_)::text = 'bpm_package'::text)
  • Rows Removed by Filter: 78046
8. 13.788 3,093.041 ↓ 7.2 19,422 1

Hash (cost=450,604.20..450,604.20 rows=2,699 width=28) (actual time=3,093.041..3,093.041 rows=19,422 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1219kB
9. 820.297 3,079.253 ↓ 7.2 19,422 1

Hash Join (cost=307,430.41..450,604.20 rows=2,699 width=28) (actual time=1,029.259..3,079.253 rows=19,422 loops=1)

  • Hash Cond: ((initiatorlink.task_id_)::text = (tasks.id_)::text)
10. 1,231.364 1,231.364 ↓ 1.0 2,342,323 1

Seq Scan on act_ru_identitylink initiatorlink (cost=0.00..114,988.31 rows=2,252,679 width=19) (actual time=0.004..1,231.364 rows=2,342,323 loops=1)

  • Filter: ((type_)::text = 'starter'::text)
  • Rows Removed by Filter: 2935011
11. 8.649 1,027.592 ↓ 1.2 19,422 1

Hash (cost=307,228.45..307,228.45 rows=16,157 width=18) (actual time=1,027.592..1,027.592 rows=19,422 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 984kB
12. 100.615 1,018.943 ↓ 1.2 19,422 1

Bitmap Heap Scan on act_hi_taskinst tasks (cost=155,524.10..307,228.45 rows=16,157 width=18) (actual time=956.778..1,018.943 rows=19,422 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: 14498
13. 8.633 8.633 ↑ 3.4 34,095 1

Bitmap Index Scan on idx_act_hi_taskinst_end_time_up_form_key_up_assignee (cost=0.00..5,168.70 rows=117,614 width=0) (actual time=8.633..8.633 rows=34,095 loops=1)

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

SubPlan (forBitmap Heap Scan)

15. 0.756 0.854 ↑ 16.4 14 1

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

  • Recheck Cond: ((user_id_)::text = 'dovbeta.dmytro'::text)
  • Filter: ((type_)::text = 'candidate'::text)
  • Rows Removed by Filter: 384
16. 0.098 0.098 ↑ 3.5 476 1

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

  • Index Cond: ((user_id_)::text = 'dovbeta.dmytro'::text)
17. 134.816 908.841 ↓ 4,060.3 48,724 1

Hash Join (cost=24,373.71..144,531.89 rows=12 width=9) (actual time=6.521..908.841 rows=48,724 loops=1)

  • Hash Cond: ((link.group_id_)::text = (groups.string_value)::text)
18. 767.551 767.551 ↓ 1.1 725,243 1

Seq Scan on act_ru_identitylink link (cost=0.00..114,988.31 rows=689,300 width=25) (actual time=0.023..767.551 rows=725,243 loops=1)

  • Filter: ((type_)::text = 'candidate'::text)
  • Rows Removed by Filter: 4552091
19. 0.008 6.474 ↓ 2.8 11 1

Hash (cost=24,373.66..24,373.66 rows=4 width=21) (actual time=6.474..6.474 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
20. 0.011 6.466 ↓ 2.8 11 1

Nested Loop (cost=1.14..24,373.66 rows=4 width=21) (actual time=3.378..6.466 rows=11 loops=1)

21. 6.356 6.356 ↓ 11.0 11 1

Index Scan using fk_alf_cass_tqn on alf_child_assoc groupsassocs (cost=0.44..24,359.52 rows=1 width=8) (actual time=3.355..6.356 rows=11 loops=1)

  • Index Cond: (type_qname_id = 95)
  • Filter: ((qname_localname)::text = 'dovbeta.dmytro'::text)
  • Rows Removed by Filter: 8160
22. 0.099 0.099 ↑ 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.008..0.009 rows=1 loops=11)

  • Index Cond: ((node_id = groupsassocs.parent_node_id) AND (qname_id = 92))
23. 1.050 1.050 ↑ 1.0 1 50

Index Scan using store_id on alf_node bpmpackagenode (cost=0.56..6.39 rows=1 width=45) (actual time=0.021..0.021 rows=1 loops=50)

  • Index Cond: ((store_id = 6) AND ((uuid)::text = "substring"((bpmpackage.text_)::text, 25)))
24. 0.250 0.250 ↑ 387.0 1 50

Index Only Scan using idx_alf_cass_pri on alf_child_assoc docnodeassoc (cost=0.56..14.21 rows=387 width=16) (actual time=0.005..0.005 rows=1 loops=50)

  • Index Cond: (parent_node_id = bpmpackagenode.id)
  • Heap Fetches: 0
25. 0.250 0.250 ↑ 1.0 1 50

Index Scan using alf_node_pkey on alf_node docnode (cost=0.44..6.09 rows=1 width=45) (actual time=0.005..0.005 rows=1 loops=50)

  • Index Cond: (id = docnodeassoc.child_node_id)
  • Filter: (store_id = 6)
26. 0.950 0.950 ↓ 0.0 0 50

Index Scan using act_idx_hi_detail_task_id on act_hi_detail lmr_viewshistory (cost=0.57..10,328.22 rows=131 width=9) (actual time=0.019..0.019 rows=0 loops=50)

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