analyze_postgres_privileges.sql

SELECT
    grantee,
    specific_schema,
    routine_name,
    privilege_type
FROM
    information_schema.routine_privileges
WHERE
    specific_schema NOT IN ('pg_catalog', 'information_schema');

SELECT
    defaclrole::regrole AS role,
    nspname AS schema,
    defaclobjtype AS object_type,
    defaclacl AS default_privileges
FROM
    pg_default_acl
        JOIN
    pg_namespace ON pg_default_acl.defaclnamespace = pg_namespace.oid;

SELECT
    grantee,
    table_schema,
    table_name,
    privilege_type
FROM
    information_schema.table_privileges
WHERE
    table_schema NOT IN ('pg_catalog', 'information_schema');