Redshift Disk Space issue due to Materialized View

Question

My disk storage is around 6% before creating the Main Materialized View which is nothing but MV which are created on top of other materilized view(sub). Before I do have only sub materialized views during that time my disk space is aroung 6% only but when Main MV's are created the storage is occupied entirely.

I do have 17 sub MV and 18 main MV which are created using the combination sub MV

Is there any possibilities to identify the disk space which are occupied by Materilized views?

I do have 17 sub MV and 18 main MV which are created using the combination sub MV

Is there any possibilities to identify the disk space which are occupied by Materilized views?

Answer

Yes, you can identify the disk space occupied by materialized views (MVs) in your database. These are the way you can do it :-

Query the System View, Analyze Table Size: You can use SQL queries to analyze the size of the tables underlying the materialized views. Since materialized views store the result of a query as a table, you can query the underlying tables to determine their size and calculate the total size of the MVs.

Database Management Tools , Database Documentation https://docs.aws.amazon.com/redshift/ :- Check the documentation of your specific database system for information on how to analyze disk space usage, including materialized views.

Redshift Disk Space issue due to Materialized View

Relevanter Inhalt