explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rFIR

Settings
# exclusive inclusive rows x rows loops node
1. 0.044 7.960 ↑ 448.7 6 1

Sort (cost=564,271,138.01..564,271,144.74 rows=2,692 width=252) (actual time=7.960..7.960 rows=6 loops=1)

  • Sort Key: (CASE WHEN ((cr_items.content_type)::text = 'content_folder'::text) THEN cr_folders.label WHEN ((cr_items.content_type)::text = 'content_extlink'::text) THEN cr_extlinks.label ELSE cr_items.name END)
  • Sort Method: quicksort Memory: 26kB
2. 0.109 7.916 ↑ 448.7 6 1

Hash Left Join (cost=236.57..564,270,984.64 rows=2,692 width=252) (actual time=7.401..7.916 rows=6 loops=1)

  • Hash Cond: (cr_items.item_id = cr_extlinks.extlink_id)
3. 0.022 0.936 ↑ 448.7 6 1

Hash Left Join (cost=7.77..297,137.39 rows=2,692 width=179) (actual time=0.542..0.936 rows=6 loops=1)

  • Hash Cond: ((cr_revisions.mime_type)::text = (cr_mime_types.mime_type)::text)
4. 0.001 0.797 ↑ 448.7 6 1

Nested Loop (cost=0.00..297,110.73 rows=2,692 width=160) (actual time=0.406..0.797 rows=6 loops=1)

5. 0.008 0.718 ↑ 448.7 6 1

Nested Loop Left Join (cost=0.00..260,234.46 rows=2,692 width=152) (actual time=0.366..0.718 rows=6 loops=1)

6. 0.006 0.656 ↑ 448.7 6 1

Nested Loop Left Join (cost=0.00..238,614.69 rows=2,692 width=116) (actual time=0.322..0.656 rows=6 loops=1)

7. 0.068 0.650 ↑ 448.7 6 1

Index Scan using cr_items_by_parent_id on cr_items (cost=0.00..210,662.82 rows=2,692 width=74) (actual time=0.321..0.650 rows=6 loops=1)

  • Index Cond: (parent_id = 134750901)
  • Filter: (subplan)
8.          

SubPlan (for Index Scan)

9. 0.072 0.582 ↑ 116,645.0 1 6

Nested Loop (cost=0.00..4,250,535.42 rows=116,645 width=0) (actual time=0.097..0.097 rows=1 loops=6)

10. 0.018 0.282 ↑ 20,297.1 19 6

Nested Loop (cost=0.00..923,776.18 rows=385,644 width=4) (actual time=0.031..0.047 rows=19 loops=6)

  • Join Filter: ((p.privilege)::text = (pdm.privilege)::text)
11. 0.060 0.060 ↑ 3.0 1 6

Seq Scan on acs_privilege_descendant_map pdm (cost=0.00..7.15 rows=3 width=11) (actual time=0.010..0.010 rows=1 loops=6)

  • Filter: ((descendant)::text = 'read'::text)
12. 0.024 0.204 ↑ 72,727.2 19 6

Nested Loop (cost=0.00..290,650.30 rows=1,381,817 width=11) (actual time=0.020..0.034 rows=19 loops=6)

13. 0.072 0.072 ↑ 1,367.0 1 6

Index Scan using acs_obj_ctx_idx_object_id_idx on acs_object_context_index c (cost=0.00..104.78 rows=1,367 width=4) (actual time=0.012..0.012 rows=1 loops=6)

  • Index Cond: (object_id = $1)
14. 0.108 0.108 ↑ 18.3 19 6

Index Scan using acs_permissions_object_id_idx on acs_permissions p (cost=0.00..208.20 rows=347 width=15) (actual time=0.007..0.018 rows=19 loops=6)

  • Index Cond: (p.object_id = c.ancestor_id)
15. 0.228 0.228 ↓ 0.0 0 114

Index Scan using party_approved_member_map_pk on party_approved_member_map pamm (cost=0.00..8.61 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=114)

  • Index Cond: ((pamm.party_id = p.grantee_id) AND (pamm.member_id = 133449130))
16. 0.000 0.000 ↓ 0.0 0 6

Index Scan using cr_revisions_pk on cr_revisions (cost=0.00..10.37 rows=1 width=46) (actual time=0.000..0.000 rows=0 loops=6)

  • Index Cond: (cr_items.live_revision = cr_revisions.revision_id)
17. 0.054 0.054 ↑ 1.0 1 6

Index Scan using cr_folders_pk on cr_folders (cost=0.00..8.02 rows=1 width=40) (actual time=0.009..0.009 rows=1 loops=6)

  • Index Cond: (cr_items.item_id = cr_folders.folder_id)
18. 0.078 0.078 ↑ 1.0 1 6

Index Scan using acs_objects_pk on acs_objects (cost=0.00..13.69 rows=1 width=12) (actual time=0.012..0.013 rows=1 loops=6)

  • Index Cond: (acs_objects.object_id = cr_items.item_id)
19. 0.074 0.117 ↓ 1.2 257 1

Hash (cost=5.12..5.12 rows=212 width=42) (actual time=0.117..0.117 rows=257 loops=1)

20. 0.043 0.043 ↓ 1.2 257 1

Seq Scan on cr_mime_types (cost=0.00..5.12 rows=212 width=42) (actual time=0.009..0.043 rows=257 loops=1)

21. 1.608 2.677 ↑ 1.0 5,680 1

Hash (cost=157.80..157.80 rows=5,680 width=77) (actual time=2.677..2.677 rows=5,680 loops=1)

22. 1.069 1.069 ↑ 1.0 5,680 1

Seq Scan on cr_extlinks (cost=0.00..157.80 rows=5,680 width=77) (actual time=0.004..1.069 rows=5,680 loops=1)

23.          

SubPlan (for Hash Left Join)

24. 4.074 4.194 ↑ 1.0 1 6

Aggregate (cost=209,499.81..209,499.82 rows=1 width=0) (actual time=0.699..0.699 rows=1 loops=6)

25. 0.018 0.120 ↓ 0.0 0 6

Bitmap Heap Scan on cr_items ci2 (cost=2,576.71..209,298.22 rows=80,633 width=0) (actual time=0.020..0.020 rows=0 loops=6)

  • Recheck Cond: ((tree_sortkey >= $0) AND (tree_sortkey <= tree_right($0)))
  • Filter: ((content_type)::text <> 'content_folder'::text)
26. 0.102 0.102 ↑ 85,266.0 1 6

Bitmap Index Scan on cr_items_tree_sortkey_un (cost=0.00..2,556.55 rows=85,266 width=0) (actual time=0.017..0.017 rows=1 loops=6)

  • Index Cond: ((tree_sortkey >= $0) AND (tree_sortkey <= tree_right($0)))
Total runtime : 8.253 ms