WITH params AS (SELECT 
specific_schema AS routine_schema,
regexp_replace(specific_name,'_[0-9]*$','') AS routine_name,
pg_get_function_identity_arguments(translate(substring(specific_name,'_[0-9]+$'),'_','')::int::oid) AS parameters,
parameter_name,
ordinal_position,
data_type,
parameter_mode
FROM 
information_schema.parameters
WHERE specific_schema NOT IN (SELECT schema_name
FROM INFORMATION_SCHEMA.schemata
WHERE schema_name<>'public' AND
schema_owner='postgres' AND schema_name IS NOT NULL) 
AND NOT EXISTS (SELECT 1
FROM pg_catalog.pg_depend d inner join pg_catalog.pg_proc pc ON d.objid=pc.oid
WHERE EXISTS (SELECT 1 FROM pg_catalog.pg_extension e WHERE d.refobjid=e.oid) AND
pc.proname || '_' || pc.oid = parameters.specific_name))
SELECT p.routine_schema, p.routine_name, p.parameters, p.parameter_mode, p.parameter_name AS suspected_name, p.ordinal_position, p.data_type,
string_agg(p2.parameter_name || ' (' || p2.data_type || ')', ',<br>' ORDER BY p2.ordinal_position) AS more_specific_parameters
FROM params AS p INNER JOIN params AS p2 USING (routine_schema, routine_name, parameters)
WHERE p.parameter_mode=p2.parameter_mode
AND p.parameter_name<>p2.parameter_name
AND (p2.parameter_name ILIKE '%\_' || p.parameter_name 
OR p2.parameter_name ILIKE p.parameter_name || '\_%')
AND p.parameter_name NOT IN ('id','code','kood')
GROUP BY p.routine_schema, p.routine_name, p.parameters, p.parameter_mode, p.parameter_name, p.ordinal_position, p.data_type
ORDER BY p.routine_schema, p.routine_name, p.parameters, p.ordinal_position;