2019-07-23 15:18:14 MSK rsidata STATEMENT:  select distinct
                registerdo0_.id register_document_link_id,
                registerdo0_.*,
                registerdo1_.*,

                dge.name document_type_name,
                dge.code document_type_code,
                dge1.name card_document_type_name,
                dge1.code card_document_type_code,
                dge1.ext_id card_document_type_ext_id,

                fs.register_document_id fs_register_document_id,
                fs.id fs_id,
                fs.file_name

                from public.register_document_link registerdo0_
                left outer join public.register_document registerdo1_
                on registerdo0_.register_document_id = registerdo1_.id

                left join dic_glossary_element dge
                on dge.code = registerdo1_.document_type_id and dge.active = true

                left join card_document_type carddoctyp1_ on registerdo0_.card_document_type_id = carddoctyp1_.id

                left join public.dic_glossary_type dicglossar2_
                on dicglossar2_.code = 'RI_CardDocumentType'
                left join dic_glossary_element dge1 on dicglossar2_.id = dge1.glossary_type_id and dge1.active =
                true and dge1.ext_id=carddoctyp1_.id::integer

                left join
                (select id,file_name,register_document_id, is_delete
                --,ROW_NUMBER() OVER (PARTITION BY id ORDER BY created_date desc) row_number
                from file_storage
                where register_document_id is not null
                ) fs
                on registerdo0_.register_document_id = fs.register_document_id --and (fs.row_number=1 or fs.row_number is null)


                    where registerdo0_.rec_status_id in (0 , 2)



                    and fs.id is not null
2019-07-23 15:18:14 MSK rsidata LOG:  could not send data to client: Connection timed out