Redshift :STV_PARTITIONS

Question

Hi All,
I was doing some reading related to stv_partitions. (https://docs.aws.amazon.com/redshift/latest/dg/r_STV_PARTITIONS.html). The example in the link states that the pct_used is evenly distributed across the disk partitions.

I tired the same against the instance I work and see that we have 8 node cluster with 2 disk partions per node. Within each node, only one disk space per node has pct used of 70 while the other show it as 0. Is this something we should be concerned about?

Accepted Answer

Not necessarily something to be concerned about, but it's worth digging into.  Take a look at the query provided here: https://docs.aws.amazon.com/redshift/latest/dg/diagnostic-queries-for-query-tuning.html#identify-tables-with-data-skew-or-unsorted-rows

This will help identify tables that have uneven distribution or a high percentage of rows unsorted and the description on that page tells you the thresholds to look for in your query results.

Redshift :STV_PARTITIONS

Relevant content