Monitoring AWS Redshift Serverless

In this post, we will understand how to monitor AWS Redshift Serverless

Photo by Luke Chesser on Unsplash

If you are using AWS Redshift provisioned cluster, you need to monitor the cluster, node and the queries. With serverless, you do not need to worry about monitoring cluster or node as this is managed by AWS. Your monitoring towards compute becomes significantly smaller with it. This enables you to focus on monitoring your query and data performance.

You can get the serverless insights by using system views and CloudWatch metrics.

System Views

System views are the SQL views, available in system schema called pg_catalog. Here is the list of available system views in this schema —

• SYS_CONNECTION_LOG
• SYS_DATASHARE_CHANGE_LOG
• SYS_DATASHARE_USAGE_CONSUMER
• SYS_DATASHARE_USAGE_PRODUCER
• SYS_QUERY_HISTORY
• SYS_QUERY_DETAIL
• SYS_EXTERNAL_QUERY_DETAIL
• SYS_LOAD_DETAIL
• SYS_LOAD_HISTORY
• SYS_LOAD_ERROR_DETAIL
• SYS_UNLOAD_HISTORY
• SYS_SERVERLESS_USAGE