SELECT 
  pg_namespace.nspname AS routine_schema, 
 Count(*) FILTER (WHERE prosqlbody IS NULL) AS number_of_sql_routines_where_body_is_literal,
 Count(*) FILTER (WHERE prosqlbody IS NOT NULL) AS number_of_sql_routines_where_body_is_sql_body
FROM 
  pg_catalog.pg_proc, 
  pg_catalog.pg_namespace,
  pg_catalog.pg_language
WHERE 
  pg_proc.pronamespace = pg_namespace.oid
AND pg_proc.prolang = pg_language.oid
AND pg_language.lanname='sql'
AND pg_namespace.nspname 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 
WHERE EXISTS (SELECT 1 FROM pg_catalog.pg_extension e WHERE d.refobjid=e.oid) AND
d.objid=pg_proc.oid)
GROUP BY pg_namespace.nspname;