explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zxgG

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 4.006 129.980 ↓ 57.9 1,854 1

Sort (cost=1,631.24..1,631.32 rows=32 width=45) (actual time=129.005..129.980 rows=1,854 loops=1)

  • Sort Key: "_F2".modified
  • Sort Method: quicksort Memory: 163kB
2. 8.721 125.974 ↓ 57.9 1,854 1

Nested Loop Left Join (cost=245.99..1,630.44 rows=32 width=45) (actual time=1.877..125.974 rows=1,854 loops=1)

3. 8.337 69.049 ↓ 57.9 1,854 1

Nested Loop (cost=245.58..1,384.66 rows=32 width=37) (actual time=1.847..69.049 rows=1,854 loops=1)

4. 4.598 6.253 ↓ 19.2 2,017 1

Bitmap Heap Scan on hierarchy (cost=245.16..577.67 rows=105 width=37) (actual time=1.800..6.253 rows=2,017 loops=1)

  • Recheck Cond: (((parentid)::text = 'c0bb88eb-f2ff-4d38-ba9d-5f7c4effded5'::text) AND ((primarytype)::text = 'SironaDocument'::text))
  • Filter: (isversion IS NULL)
  • Heap Blocks: exact=457
5. 0.096 1.655 ↓ 0.0 0 1

BitmapAnd (cost=245.16..245.16 rows=106 width=0) (actual time=1.655..1.655 rows=0 loops=1)

6. 0.683 0.683 ↑ 1.1 2,017 1

Bitmap Index Scan on hierarchy_parentid_idx (cost=0.00..120.41 rows=2,132 width=0) (actual time=0.683..0.683 rows=2,017 loops=1)

  • Index Cond: ((parentid)::text = 'c0bb88eb-f2ff-4d38-ba9d-5f7c4effded5'::text)
7. 0.876 0.876 ↑ 1.0 3,056 1

Bitmap Index Scan on hierarchy_primarytype_idx (cost=0.00..124.45 rows=3,205 width=0) (actual time=0.876..0.876 rows=3,056 loops=1)

  • Index Cond: ((primarytype)::text = 'SironaDocument'::text)
8. 54.459 54.459 ↑ 1.0 1 2,017

Index Scan using misc_id on misc "_F1" (cost=0.41..7.68 rows=1 width=37) (actual time=0.026..0.027 rows=1 loops=2,017)

  • Index Cond: ((id)::text = (hierarchy.id)::text)
  • Filter: ((lifecyclestate)::text <> 'deleted'::text)
  • Rows Removed by Filter: 0
9. 48.204 48.204 ↑ 1.0 1 1,854

Index Scan using dublincore_pk on dublincore "_F2" (cost=0.41..7.67 rows=1 width=45) (actual time=0.025..0.026 rows=1 loops=1,854)

  • Index Cond: ((hierarchy.id)::text = (id)::text)