awslabs / awslabs/amazon-redshift-utils
v_space_used_per_tbl shows 100 pct_unsorted for 1 node cluster
Open
- Dominant language
- Python
- Stars
- 2.8k
- Forks
- 1.2k
- PR merge metrics
- No merged PRs in 30d
Description
It seems that when cluster has only 1 node, the v_space_used_per_tbl view shows all tables as being 100 pct unsorted.
Contributor guide
Research direction
Start by locating the v_space_used_per_tbl view definition and reproducing its output on a one-node cluster. Check why every table is reported as 100 pct_unsorted, then verify that the view reports the expected unsorted percentage for single-node tables.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100