explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XMIa

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 178,822.124 ↓ 0.0 0 1

Nested Loop (cost=216,658.75..1,361,460.30 rows=2,620 width=37) (actual time=178,822.124..178,822.124 rows=0 loops=1)

2. 0.002 178,822.123 ↓ 0.0 0 1

Hash Left Join (cost=216,658.19..1,322,155.33 rows=4,808 width=37) (actual time=178,822.123..178,822.123 rows=0 loops=1)

  • Hash Cond: ((hierarchy.id)::text = ("_F2".id)::text)
  • Filter: ((("_F2".targetdocumentid)::text = 'f23dce09-e815-4bf5-a902-387e80a63988'::text) OR (alternatives: SubPlan 1 or hashed SubPlan 2))
3. 117,644.942 178,822.121 ↓ 0.0 0 1

Bitmap Heap Scan on hierarchy (cost=216,642.57..1,322,092.52 rows=9,569 width=37) (actual time=178,822.121..178,822.121 rows=0 loops=1)

  • Recheck Cond: ((primarytype)::text = ANY ('{SignConfigFolder,SectionRoot,Workspace,SignProofFile,RelationSearch,user_open_tasks_cv,SoshWorkspace,TilesRoot,ManagementRoot,Docum
  • Rows Removed by Index Recheck: 6006437
  • Filter: (((primarytype)::text = 'TaskDoc'::text) OR ('{Task}'::character varying[] <@ mixintypes))
  • Rows Removed by Filter: 8158447
4. 61,177.179 61,177.179 ↓ 1.1 8,633,811 1

Bitmap Index Scan on hierarchy_primarytype_idx (cost=0.00..216,640.17 rows=7,599,644 width=0) (actual time=61,177.179..61,177.179 rows=8,633,811 loops=1)

  • Index Cond: ((primarytype)::text = ANY ('{SignConfigFolder,SectionRoot,Workspace,SignProofFile,RelationSearch,user_open_tasks_cv,SoshWorkspace,TilesRoot,ManagementRoot,D
5. 0.000 0.000 ↓ 0.0 0

Hash (cost=12.50..12.50 rows=250 width=122) (never executed)

6. 0.000 0.000 ↓ 0.0 0

Seq Scan on task "_F2" (cost=0.00..12.50 rows=250 width=122) (never executed)

7.          

SubPlan (forHash Left Join)

8. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on nt_targetdocumentsids "_F3" (cost=4.17..11.29 rows=1 width=0) (never executed)

  • Recheck Cond: ((hierarchy.id)::text = (id)::text)
  • Filter: ((item)::text = 'f23dce09-e815-4bf5-a902-387e80a63988'::text)
9. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on nt_targetdocumentsids_id_idx (cost=0.00..4.17 rows=3 width=0) (never executed)

  • Index Cond: ((hierarchy.id)::text = (id)::text)
10. 0.000 0.000 ↓ 0.0 0

Seq Scan on nt_targetdocumentsids "_F3_1" (cost=0.00..16.50 rows=3 width=90) (never executed)

  • Filter: ((item)::text = 'f23dce09-e815-4bf5-a902-387e80a63988'::text)
11. 0.000 0.000 ↓ 0.0 0

Index Scan using misc_pk on misc "_F1" (cost=0.56..8.16 rows=1 width=37) (never executed)

  • Index Cond: ((id)::text = (hierarchy.id)::text)
  • Filter: ((lifecyclestate)::text <> ALL ('{ended,cancelled}'::text[]))