Skip to content

Instantly share code, notes, and snippets.

@frankyaorenjie

frankyaorenjie/redshift_table_vacuum_skew

Created April 25, 2017 03:05
Show Gist options
  • Save frankyaorenjie/742412e7d9da1f618f9a1a28f8d9c1f2 to your computer and use it in GitHub Desktop.
Save frankyaorenjie/742412e7d9da1f618f9a1a28f8d9c1f2 to your computer and use it in GitHub Desktop.
Download ZIP
Redshift table vacuum skew
Raw
redshift_table_vacuum_skew
select tbl as tbl_id, stv_tbl_perm.name as table_name,
col, interleaved_skew, last_reindex
from svv_interleaved_columns, stv_tbl_perm
where svv_interleaved_columns.tbl = stv_tbl_perm.id
and interleaved_skew is not null;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment