06/07/2023 10:02 | Category: databases

Tags: redshifttuningqueriesdba

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.


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

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

two tables, good and has timestamps.