explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9LqR

Settings
# exclusive inclusive rows x rows loops node
1. 0.382 4.105 ↓ 1.7 325 1

HashAggregate (cost=320.50..322.38 rows=188 width=19) (actual time=4.017..4.105 rows=325 loops=1)

  • Output: workflowtemplate.workflowtemplateparentid, (count(*)), ('requestor'::text), workflowtemplate.workflowtemplatestatusid
  • Group Key: workflowtemplate.workflowtemplateparentid, count(*), 'requestor'::text
  • Buffers: shared hit=358
2. 0.554 3.723 ↓ 3.4 648 1

HashAggregate (cost=317.21..319.09 rows=188 width=19) (actual time=3.523..3.723 rows=648 loops=1)

  • Output: workflowtemplate.workflowtemplateparentid, count(*), 'requestor'::text, workflowtemplate.workflowtemplatestatusid
  • Group Key: workflowtemplate.workflowtemplateparentid, workflowtemplate.workflowtemplatestatusid
  • Buffers: shared hit=358
3. 1.971 3.169 ↓ 1.3 663 1

Bitmap Heap Scan on pando.workflowtemplate (cost=286.32..308.46 rows=500 width=35) (actual time=1.242..3.169 rows=663 loops=1)

  • Output: workflowtemplate.workflowtemplateparentid, replace(unnest(string_to_array(replace(replace(workflowtemplate.requestoruserids, '['::text, ''::text), ']'::text, ''::text), ','::text)), '"'::text, ''::text), workflowtemplate.workflowtemplatestatusid
  • Recheck Cond: ((workflowtemplate.accountid = 2,910) AND (workflowtemplate.workflowtemplatestatusid < 100) AND (workflowtemplate.requestoruserids ~~ '%2103:QVLcsPX8VFqa%'::text))
  • Heap Blocks: exact=287
  • Buffers: shared hit=358
4. 0.022 1.198 ↓ 0.0 0 1

BitmapAnd (cost=286.32..286.32 rows=5 width=0) (actual time=1.198..1.198 rows=0 loops=1)

  • Buffers: shared hit=71
5. 0.077 0.077 ↑ 1.2 678 1

Bitmap Index Scan on workflowtemplate_accountid_workflowtemplatestatusid_index (cost=0.00..24.22 rows=780 width=0) (actual time=0.077..0.077 rows=678 loops=1)

  • Index Cond: ((workflowtemplate.accountid = 2,910) AND (workflowtemplate.workflowtemplatestatusid < 100))
  • Buffers: shared hit=5
6. 1.099 1.099 ↑ 1.1 738 1

Bitmap Index Scan on workflowtemplate_requestoruserids_index (cost=0.00..261.85 rows=780 width=0) (actual time=1.099..1.099 rows=738 loops=1)

  • Index Cond: (workflowtemplate.requestoruserids ~~ '%2103:QVLcsPX8VFqa%'::text)
  • Buffers: shared hit=66