List disk usage of PSQL instance per table in the schema public

disk_usage.sql

SELECT
	table_name,
	pg_size_pretty(t_size) AS size_pretty
FROM (
	SELECT
		table_name,
		pg_relation_size(quote_ident(table_name)) AS t_size
	FROM information_schema.tables
	WHERE table_schema = 'public'
	UNION ALL 
	SELECT
		'--ALL TABLES--'::text AS table_name,
		SUM(pg_relation_size(quote_ident(table_name))) AS t_size
	FROM information_schema.tables
	WHERE table_schema = 'public'
	ORDER BY t_size DESC
) C;