slow gallery's query

slow-gallery-113.sql

SELECT external_store_objects.id,                                                                                                                                                | 00:05:41.558663
                                 COALESCE(original_filename, SUBSTRING(local_key FROM '[^/]+$')) AS path,                                                                                                   
                                 external_store_objects.uploaded_on,                                                                                                                                        
                                 gallery_images.id AS gallery_images_id,                                                                                                                                    
                                 gallery_images.description,                                                                                                                                                
                                 gallery_images.user_id,                                                                                                                                                    
                                 gallery_albums.id AS album_id,                                                                                                                                             
                                 gallery_albums.name AS album_name,                                                                                                                                         
                                 gallery_albums.type AS album_type,                                                                                                                                         
                                 gallery_albums.object_type AS album_object_type,                                                                                                                           
                                 gallery_albums.object_id AS album_object_id,                                                                                                                               
                                 community.object_type AS community_album_object_type,                                                                                                                      
                                 community.object_id AS community_album_object_id,                                                                                                                          
                                 COALESCE(community.category_id, gallery_albums.category_id, 0) AS category_id,                                                                                             
                                 content_refs.link,                                                                                                                                                         
                                 COALESCE(gallery_album_images.is_default, false) AS is_default_album                                                                                                       
                         FROM external_store_objects                                                                                                                                                        
                         LEFT JOIN gallery_images                                                                                                                                                           
                                 ON external_store_object_id = external_store_objects.id                                                                                                                    
                         LEFT JOIN gallery_album_images                                                                                                                                                     
                                 ON gallery_album_images.image_id = gallery_images.id AND is_default                                                                                                        
                         LEFT JOIN gallery_albums                                                                                                                                                           
                                 ON gallery_albums.id = gallery_album_images.gallery_album_id                                                                                                               
                         LEFT JOIN gallery_albums community ON (                                                                                                                                            
                                 gallery_albums.object_type = get_huddler_constant('CONTENT_TYPE_GALLERY_ALBUM')::int AND                                                                                   
                                 community.id = gallery_albums.object_id                                                                                                                                    
                         )                                                                                                                                                                                  
                         LEFT JOIN content_refs                                                                                                                                                             
                                 ON content_refs.content_type = gallery_albums.object_type AND content_refs.content_id = gallery_albums.object_id                                                           
                         WHERE external_store_objects.id IN (737822)