How can I determine disk space usage by schema?

Use this query, where svv_table_info is the table you’re interested in:

select "schema",sum(size) total_size from svv_table_info group by "schema"