How to find the size of a Redshift database

To determine the size of a database in Redshift cluster, use the below query.

SELECT database, SUM(size) as "size in MB"
FROM SVV_TABLE_INFO                       
GROUP BY database;