SELECT a.st,to_char(pg_total_relation_size(a.st),'999,999,999,999')
FROM (SELECT p.schemaname || '.' || p.tablename AS st FROM pg_tables AS p WHERE p.schemaname = 'public') AS a
ORDER BY a.st
;