WITH cols AS (SELECT table_type, table_schema, table_name, column_name
FROM INFORMATION_SCHEMA.tables LEFT JOIN INFORMATION_SCHEMA.columns USING (table_schema, table_name) 
WHERE 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)
UNION SELECT 'MATERIALIZED VIEW' AS table_type, nspname, relname, attname
FROM pg_class INNER JOIN pg_namespace ON pg_class.relnamespace=pg_namespace.oid
LEFT JOIN pg_attribute ON pg_class.oid=pg_attribute.attrelid 
WHERE relkind = 'm' AND attnum>=1),
col_num AS (SELECT table_type, table_schema, table_name, Count(column_name) AS nr_of_cols
FROM cols
GROUP BY table_type, table_schema, table_name)
SELECT 
table_type, 
Count(*) FILTER (WHERE nr_of_cols=0) AS zero_cols,
Count(*) FILTER (WHERE nr_of_cols BETWEEN 1 AND 10) AS between_1_10_cols,
Count(*) FILTER (WHERE nr_of_cols BETWEEN 11 AND 25) AS between_11_25_cols,
Count(*) FILTER (WHERE nr_of_cols>25) AS more_than_25_cols
FROM col_num
GROUP BY table_type
ORDER BY table_type;