Coverage by routines that have the SQL-standard body

Copy SQL

WITH routine_table AS (SELECT DISTINCT t.table_schema, t.table_name, rtu.routine_schema, rtu.routine_name, pg_get_function_identity_arguments(translate(substring(rtu.specific_name,'_[0-9]+$'),'_','')::int::oid) AS parameters, r.routine_type
FROM information_schema.tables AS t LEFT JOIN information_schema.routine_column_usage AS rtu USING (table_schema, table_name)
LEFT JOIN information_schema.routines AS r USING (specific_schema, specific_name) 
WHERE t.table_type = 'BASE TABLE' AND t.table_schema NOT IN (SELECT schema_name
FROM INFORMATION_SCHEMA.schemata
WHERE schema_name<>'public' AND
schema_owner='postgres' AND schema_name IS NOT NULL))
SELECT table_schema, table_name,
string_agg(routine_schema || '.' || routine_name || '(' || parameters || ') (' || routine_type || ')', ';<br>' ORDER BY routine_schema, routine_name, parameters) AS  list_of_routines,
Count(routine_schema) AS number_of_routines
FROM routine_table
GROUP BY table_schema, table_name
ORDER BY Count(routine_schema) DESC, table_schema, table_name;