sed -i "
9iALTER SCHEMA public OWNER TO merch;
9iSET SESSION AUTHORIZATION 'merch';
/CREATE PROCEDURAL LANGUAGE plpgsql;/d
/CREATE PROCEDURAL LANGUAGE pltcl;/d
/CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler/,/LANGUAGE c;/d
/ALTER FUNCTION public.plpgsql_call_handler() OWNER TO postgres;/d
...
здесь идет обработка некорректных в дампе записей о назначении прав объектам
...
" schema.sql

CREATE OR REPLACE VIEW view_documents AS 
 SELECT d.id, d.save_date, d.exec_date, d.delete_date, d.user_id, u.point_id, u.center_id, u.region_id, u.macroregion_id, d.document_template_id, d.phone_number, d.fields_array, d.users_array, d.dates_array, r.name AS region, m.name AS macroregion, p.code AS point_code, p.town AS point_town, p.address AS point_address, p.trademark AS point_trademark, p.phone AS point_phone, p.email AS point_email, c.name AS center_name, c.code AS center_code, u.name AS user_name, tp.name AS template_name, tp.type_id AS template_type_id, tps.name AS template_type, tp.is_active AS template_is_active, a.value AS status, ( SELECT count(*) AS count
           FROM attributes a
          WHERE a.value = 'Отклонен'::text AND a.document_id = d.id) AS rejects_count
   FROM documents d
   JOIN auth.users u ON d.user_id = u.id
   JOIN auth.macroregions m ON u.macroregion_id = m.id
   JOIN auth.regions r ON u.region_id = r.id
   JOIN auth.points p ON u.point_id = p.id
   JOIN auth.centers c ON u.center_id = c.id
   JOIN attributes a ON d.id = a.document_id AND a.is_last
   JOIN document_templates tp ON d.document_template_id = tp.id
   JOIN document_template_types tps ON tp.type_id = tps.id;

duration:  555 . 684  ms  statement:

                                select foo.*, e.name as executor, r.name as recenser
                                from (
                                        select id, macroregion, region, center_name, center_code, point_town, point_address, point_code,
                                                user_name as creator, point_trademark, region_id,
                                                (save_date at time zone interval '04:00')::date as create_date,
                                                date_trunc('sec', save_date at time zone interval '04:00')::time as create_time,
                                                phone_number, template_name, document_template_id, status,
                                                lindex(avalue(avalue(fields_array, 'attribute'), 'values'),  0 ) as primary_system,
                                                lindex(avalue(avalue(fields_array, 'attribute'), 'values'),  1 ) as sn,
                                                lindex(avalue(avalue(fields_array, 'attribute'), 'values'),  2 ) as abonent_informed,
                                                avalue(avalue(fields_array, 'transaction_on'), 'values') as ton_values,
                                                avalue(avalue(fields_array, 'transaction_off'), 'values') as toff_values,
                                                (to_timestamp(avalue(dates_array, 'Выполнен')::double precision) at time zone interval '04:00')::date as exec_date,
                                                (to_timestamp(avalue(dates_array, 'Выполнен')::double precision) at time zone interval '04:00')::time as exec_time,
                                                (to_timestamp(avalue(dates_array, 'Рецензирован')::double precision) at time zone interval '04:00')::date as recense_date,
                                                (to_timestamp(avalue(dates_array, 'Рецензирован')::double precision) at time zone interval '04:00')::time as recense_time,
                                                (avalue(dates_array, 'Принят')::int - avalue(dates_array, 'Отправлен')::int +  30 )/ 60  as interval_wait,
                                                (avalue(dates_array, 'Выполнен')::int - avalue(dates_array, 'Принят')::int +  30 )/ 60  as interval_exec,
                                                avalue(users_array, 'Выполнен') as executor_id, avalue(users_array, 'Рецензирован') as recenser_id
                                        from offline.view_documents
                                        where macroregion_id = '1'
        and true and region_id = '5' and center_id = '1046' and point_id = '1000050' and true and true and avalue(dates_array, 'Выполнен')::int BETWEEN
                                                extract (epoch from ('2008-5-1'::date))::int and
                                                extract (epoch from ('2008-5-28'::date + interval '1 day'))::int
                                        ) as foo
                                inner join auth.users e on e.id=foo.executor_id
                                inner join auth.users r on r.id=foo.recenser_id
                                ORDER BY primary_system ASC, sn ASC;