awslabs / awslabs/amazon-redshift-utils

Table Size

Open
#590 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
2.8k
Forks
1.2k
PR merge metrics
No merged PRs in 30d

Description

Really confused by the table size calculation provided here.

According to docs, one takes the block size and multiplies by the columns, nodes, slices etc
I'm not seeing the same calculations in the SQL query, only a concatenated string of the components ?
Maybe I am misunderstanding your intent ?

https://aws.amazon.com/premiumsupport/knowledge-center/redshift-cluster-storage-space/
Minimum table size = block_size (1 MB) *
(number_of_user_columns + 3 system columns) * number_of_cluster_nodes *
number_of_table_segments
1MB * (3+3) * 6 *1 = 36 MB

Contributor guide

Open the contributing guide

Research direction

Start by locating the SQL query that calculates table size and compare its concatenated components with the AWS Redshift table-size formula linked in the issue. Verify whether the query accounts for block size, user and system columns, cluster nodes, and table segments; done means the discrepancy is explained and the calculation or its documentation is corrected.

Written by the indexing model from the issue text.

Assessment

Tech stack
aws, sql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.