get size of all tables in postgres

get-size.sql

-- https://stackoverflow.com/questions/2596624/how-do-you-find-the-disk-size-of-a-postgres-postgresql-table-and-its-indexes
SELECT
	table_name,
	pg_size_pretty(table_size) AS table_size,
	pg_size_pretty(indexes_size) AS indexes_size,
	pg_size_pretty(total_size) AS total_size
FROM (
	SELECT
		table_name,
		pg_table_size(table_name) AS table_size,
		pg_indexes_size(table_name) AS indexes_size,
		pg_total_relation_size(table_name) AS total_size
	FROM (
		SELECT
			('"' || table_schema || '"."' || table_name || '"') AS table_name
		FROM
			information_schema.tables) AS all_tablets
	ORDER BY
		total_size DESC) AS pretty_sizes;