redshift useful query metrics and logging internal tables

Redshift has quite a few internal tables that are good for viewing information about your cluster's usage patterns. I found this to be particularly useful for determining load on specific queries over time, because these tables are more granular than the AWS Console.

References

• SVL Query metrics - Good for the

metrics but does not have timestamps. Keeps ~6 days of activity on a "reasonably active server".

• STL Query metrics - Deeper detail

of the same table, but still does not have timestamps.

• STL Query - Raw data used in the previous

two tables, good and has timestamps.

• Datetime abbreviations reference