amazon-redshift-utils
amazon-redshift-utils copied to clipboard
v_space_used_per_tbl shows 100 pct_unsorted for 1 node cluster
It seems that when cluster has only 1 node, the v_space_used_per_tbl view shows all tables as being 100 pct unsorted.
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.