with pk_columns AS (select 
c.relname as table_name, 
(select a.attname from pg_attribute a where a.attrelid = c.oid and a.attnum = o.conkey[1] and a.attisdropped = false) as column_name
from pg_constraint o inner join pg_class c on c.oid = o.conrelid
inner join pg_namespace as nc on nc.oid=c.relnamespace
inner join  pg_authid AS a on nc.nspowner=a.oid
where (nc.nspname='public' or rolname<>'postgres')
and o.contype='p'  
and cardinality(o.conkey)=1),
pk_columns_pattern AS (select replace(lower(column_name), lower(table_name), '<b>table</b>') as pattern
from pk_columns)
select pattern, count(*) as cnt
from pk_columns_pattern
group by pattern
order by Count(*) desc, pattern;