Logical size of a table

WITH materialized_views AS (SELECT nspname, relname, 'MATERIALIZED VIEW' AS table_type, 1 AS weight
FROM pg_class INNER JOIN pg_namespace ON pg_class.relnamespace=pg_namespace.oid
INNER JOIN pg_attribute ON pg_class.oid=pg_attribute.attrelid INNER JOIN pg_type ON
pg_attribute.atttypid=pg_type.oid
WHERE relkind = 'm' AND attnum>=1 AND  typrelid=0
UNION SELECT nspname, relname, 'MATERIALIZED VIEW' AS table_type, 
(SELECT Count(*) AS cnt FROM pg_class AS c INNER JOIN pg_attribute AS a ON c.oid=a.attrelid
WHERE c.oid=pg_type.typrelid) AS weight
FROM pg_class INNER JOIN pg_namespace ON pg_class.relnamespace=pg_namespace.oid
INNER JOIN pg_attribute ON pg_class.oid=pg_attribute.attrelid INNER JOIN pg_type ON
pg_attribute.atttypid=pg_type.oid
WHERE relkind = 'm' AND attnum>=1 AND  typrelid<>0),
materialized_views_summary AS (SELECT nspname, relname, table_type, Sum(weight) AS ts
FROM materialized_views
GROUP BY nspname, relname, table_type),
tables_with_no_columns AS (SELECT table_schema, table_name, table_type
FROM INFORMATION_SCHEMA.tables AS t
WHERE NOT EXISTS (SELECT 1
FROM INFORMATION_SCHEMA.columns AS c
WHERE t.table_schema=c.table_schema 
AND t.table_name=c.table_name)
UNION SELECT nspname, relname, 'MATERIALIZED VIEW' AS table_type
FROM pg_class AS c INNER JOIN pg_namespace AS n ON c.relnamespace=n.oid
WHERE NOT EXISTS (SELECT 1
FROM pg_attribute AS a
WHERE c.oid=a.attrelid))

SELECT A.table_schema, T.table_type, A.table_name, 
SUM (CASE
WHEN A.data_type = 'USER-DEFINED'
AND B.relnatts>=0 
THEN B.relnatts
ELSE 1
END) AS ts
FROM information_schema.columns A

LEFT JOIN (
SELECT n.nspname, c.relname, c.relnatts
FROM pg_class c
INNER JOIN pg_catalog.pg_authid u 
ON u.oid = c.relowner
INNER JOIN pg_catalog.pg_namespace n 
ON n.oid = c.relnamespace
WHERE c.relkind IN ('c', 'r')
AND (n.nspname = 'public'
	 OR u.rolname <> 'postgres')
) B
ON A.udt_name = B.relname
AND A.udt_schema = B.nspname
AND A.data_type = 'USER-DEFINED'

INNER JOIN information_schema.tables T
ON A.table_schema = T.table_schema
AND A.table_name = T.table_name

INNER JOIN information_schema.schemata S
ON A.table_schema=S.schema_name

WHERE (A.table_schema = 'public'
OR S.schema_owner<>'postgres')
GROUP BY A.table_schema, T.table_type, A.table_name
UNION SELECT nspname, table_type, relname,  ts
FROM materialized_views_summary
UNION SELECT  table_schema, table_type, table_name, 0 AS ts
FROM tables_with_no_columns
ORDER BY table_type, ts DESC, table_schema, table_name;