performance.md

Performance

https://docs.aws.amazon.com/redshift/latest/dg/diagnostic-queries-for-query-tuning.html https://aws.amazon.com/blogs/big-data/amazon-redshift-engineerings-advanced-table-design-playbook-distribution-styles-and-distribution-keys/

Compression and encoding

Check encoding / keys of a table

SELECT
      "column",
      type,
      encoding,
      distkey,
      sortkey
FROM
      pg_table_def
WHERE
      tablename = 'xxx';