explain.depesz.com

A tool for finding a real cause for slow queries.

Result: YyV

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 2,466.222 14,528.065 ↓ 304,390.0 304,390 1

Sort (cost=26,819.69..26,819.70 rows=1 width=67) (actual time=14,366.814..14,528.065 rows=304,390 loops=1)

  • Sort Key: "_F2".title
  • Sort Method: external merge Disk: 20432kB
2. 208.810 12,061.843 ↓ 304,390.0 304,390 1

Nested Loop (cost=24,782.39..26,819.68 rows=1 width=67) (actual time=761.713..12,061.843 rows=304,390 loops=1)

3. 248.602 8,808.343 ↓ 304,469.0 304,469 1

Nested Loop Left Join (cost=24,782.39..26,815.31 rows=1 width=104) (actual time=761.655..8,808.343 rows=304,469 loops=1)

4. 189.317 5,515.051 ↓ 304,469.0 304,469 1

Nested Loop (cost=24,782.39..26,811.78 rows=1 width=74) (actual time=761.601..5,515.051 rows=304,469 loops=1)

5. 404.067 886.656 ↓ 760.4 317,077 1

HashAggregate (cost=24,782.39..24,786.56 rows=417 width=37) (actual time=761.497..886.656 rows=317,077 loops=1)

6. 482.589 482.589 ↓ 760.4 317,077 1

Seq Scan on ancestors (cost=0.00..24,781.35 rows=417 width=37) (actual time=0.031..482.589 rows=317,077 loops=1)

  • Filter: ('{83119cd4-a94c-4dc6-ba95-4620cfd525c8}'::character varying[] <@ ancestors)
7. 4,439.078 4,439.078 ↑ 1.0 1 317,077

Index Scan using hierarchy_pk on hierarchy (cost=0.00..4.84 rows=1 width=37) (actual time=0.014..0.014 rows=1 loops=317,077)

  • Index Cond: ((hierarchy.id)::text = (ancestors.id)::text)
  • Filter: ((((hierarchy.primarytype)::text = ANY ('{Picture,File,Audio,Video}'::text[])) OR ('{Asset}'::character varying[] <@ hierarchy.mixintypes)) AND ((hierarchy.primarytype)::text = ANY ('{RelationSearch,PublicationRelation,Tag,Tagging,CommentRelation,search_results,Thread,Artwork,Comment,QueryNav,TaskList,DefaultRelation,FilterQuery,Video,MailMessage,ContextualLink,Post,AdministrativeStatus,Picture,Relation,Document,FacetedSearch,File,AdvancedSearch,FacetedSearchDefault,Note,TaskDoc,UserProfile,CollectionSurvey,Audio,BasicAuditSearch,BlogPost}'::text[])) AND ((hierarchy.primarytype)::text = ANY ('{SectionRoot,ArtworkLibrary,ImportRoot,Workspace,RelationSearch,BlogSite,Thread,TemplateRoot,Domain,Artwork,WorkspaceRoot,ImportSet,QueryNav,WebPage,FilterQuery,Video,MailMessage,Forum,PictureBook,ContextualLink,Picture,Relation,Document,Folder,FacetedSearch,ImportFolder,File,AdvancedSearch,WebSite,FacetedSearchDefault,Note,Section,Root,MailFolder,CollectionSurvey,OrderedFolder,Audio,BasicAuditSearch,BlogPost}'::text[])) AND ((hierarchy.primarytype)::text = ANY ('{ArtworkLibrary,SectionRoot,Workspace,ImportRoot,RelationSearch,BlogSite,ManagementRoot,Tag,AdministrativeStatusContainer,Thread,search_results,Space,TemplateRoot,Domain,Artwork,WorkspaceRoot,Comment,ImportSet,QueryNav,TaskList,WebPage,FilterQuery,Video,WCOpenSocial,TaskLists,MailMessage,Forum,ContextualLink,PictureBook,Unit,TaskRoot,Post,WCHtml,AdministrativeStatus,Picture,UserWorkspacesRoot,Document,Folder,ImportFolder,FacetedSearch,WCPicture,File,FacetedSearchDefault,WebSite,AdvancedSearch,Gadget,Note,TaskDoc,HiddenFolder,Section,UserProfile,MailFolder,OrderedFolder,CollectionSurvey,Audio,BasicAuditSearch,CommentRoot,BlogPost}'::text[])))
8. 3,044.690 3,044.690 ↑ 1.0 1 304,469

Index Scan using dublincore_pk on dublincore "_F2" (cost=0.00..3.52 rows=1 width=67) (actual time=0.010..0.010 rows=1 loops=304,469)

  • Index Cond: ((hierarchy.id)::text = ("_F2".id)::text)
9. 3,044.690 3,044.690 ↑ 1.0 1 304,469

Index Scan using misc_pk on misc "_F1" (cost=0.00..4.36 rows=1 width=37) (actual time=0.010..0.010 rows=1 loops=304,469)

  • Index Cond: (("_F1".id)::text = (hierarchy.id)::text)
  • Filter: (("_F1".lifecyclestate)::text <> 'deleted'::text)