How to find the size of a schema in Redshift

Use the below query to determine the size of all schemas in Redshift database.

SELECT schema, SUM(size) as "size in MB"
FROM SVV_TABLE_INFO                     
GROUP BY schema                         
order by 2 desc;                        
See also  How to change Quota allocated to a Schema in Redshift database