amazon-redshift-utils icon indicating copy to clipboard operation
amazon-redshift-utils copied to clipboard

v_space_used_per_tbl shows 100 pct_unsorted for 1 node cluster

Open kirill-andr opened this issue 6 years ago • 1 comments

It seems that when cluster has only 1 node, the v_space_used_per_tbl view shows all tables as being 100 pct unsorted.

kirill-andr avatar Mar 31 '18 19:03 kirill-andr

I imported the pct_unsorted from table_info.sql also in this repository. That fixes the computation. See attached for my version of the v_space_used_per_tbl.

mg_v_space_used_per_tbl.txt

mgrabenstein avatar Apr 05 '18 20:04 mgrabenstein