The number of compensating actions of foreign key constraints

Copy SQL

WITH compensating AS (SELECT CASE WHEN confupdtype='a' THEN 'ON UPDATE NO ACTION'
WHEN confupdtype='r' THEN 'ON UPDATE RESTRICT'
WHEN confupdtype='c' THEN 'ON UPDATE CASCADE'
WHEN confupdtype='n' THEN 'ON UPDATE SET NULL'
WHEN confupdtype='d' THEN 'ON UPDATE SET DEFAULT' END AS compensating_action
FROM pg_constraint AS o INNER JOIN pg_class AS c ON o.conrelid=c.oid
INNER JOIN pg_namespace AS np ON c.relnamespace=np.oid
INNER JOIN pg_authid AS a ON np.nspowner=a.oid
WHERE (np.nspname='public' OR rolname<>'postgres')
AND contype='f' 
UNION ALL SELECT CASE WHEN confdeltype='a' THEN 'ON DELETE NO ACTION'
WHEN confdeltype='r' THEN 'ON DELETE RESTRICT'
WHEN confdeltype='c' THEN 'ON DELETE CASCADE'
WHEN confdeltype='n' THEN 'ON DELETE SET NULL'
WHEN confdeltype='d' THEN 'ON DELETE SET DEFAULT' END AS compensating_action
FROM pg_constraint AS o INNER JOIN pg_class AS c ON o.conrelid=c.oid
INNER JOIN pg_namespace AS np ON c.relnamespace=np.oid
INNER JOIN pg_authid AS a ON np.nspowner=a.oid
WHERE (np.nspname='public' OR rolname<>'postgres')
AND contype='f')
SELECT compensating_action, Count(*) AS number_of_occurrences
FROM compensating
GROUP BY compensating_action
ORDER BY compensating_action;