Redshiftのskew tableを確認する

amazon-redshift-utilsを使用する

git clone https://github.com/awslabs/amazon-redshift-utils.git

SQL実行

[ec2-user@bastin ~]$ psql -h redshift-cluster.xxxxx.ap-northeast-1.redshift.amazonaws.com -U awsuser -d tickit -p 5439 -f /home/ec2-user/amazon-redshift-utils-master/src/AdminScripts/table_inspector.sql
 schemaname | tablename | tableid | size_in_mb | has_dist_key | has_sort_key | has_col_encoding | ratio_skew_across_slices | pct_slices_populated 
------------+-----------+---------+------------+--------------+--------------+------------------+--------------------------+----------------------
 public     | category  |  203866 |         56 |            1 |            1 |                1 |                        0 |                  100
 public     | date      |  203868 |         88 |            1 |            1 |                1 |                        0 |                  100
 public     | event     |  203871 |         72 |            1 |            1 |                1 |                        0 |                  100
 public     | listing   |  203873 |         88 |            1 |            1 |                1 |                        0 |                  100
 public     | sales     |  203875 |        104 |            1 |            1 |                1 |                        0 |                  100
 public     | users     |  203862 |        168 |            1 |            1 |                1 |                        0 |                  100
 public     | venue     |  203864 |         64 |            1 |            1 |                1 |                        0 |                  100
(7 rows)

列の説明