Amazon Redshift Serverless monitoring
Amazon Redshift Serverless is a fully managed data warehouse service that automatically provisions and scales compute capacity based on your analytics workloads. It eliminates infrastructure management while enabling you to run SQL analytics on data stored in Amazon Redshift, Amazon S3, and other supported data sources.
Overview
Amazon Redshift Serverless monitoring in Site24x7 provides visibility into the performance, availability, compute utilization, storage consumption, and query activity of your serverless data warehouses. It enables you to monitor workgroups, namespaces, and databases from a single console, helping you identify performance bottlenecks, optimize resource utilization, and maintain consistent query performance.
Site24x7's integration with Amazon Redshift Serverless provides monitoring for the following monitor types:
- Redshift Workgroup: Monitors compute capacity, query execution, database activity, workload performance, and usage limits.
- Redshift Namespace: Tracks storage utilization and namespace-level resource information.
- Redshift Database: Monitors database connections, query execution, throughput, latency, and table count.
Benefits of Site24x7's Amazon Redshift Serverless integration
Site24x7's integration with Amazon Redshift Serverless enables you to:
- Monitor compute utilization and workload performance in real time.
- Track database connections, running queries, queued queries, and failed queries.
- Analyze query throughput and execution latency across different query categories.
- Monitor namespace storage utilization and table growth.
- Track compute and data sharing usage limits to avoid unexpected resource exhaustion.
- View workgroups, namespaces, and databases from a unified monitoring interface.
Use cases
Here are a few use cases for Amazon Redshift Serverless monitoring.
Optimize query performance during peak analytics workloads
A retail company uses Amazon Redshift Serverless to analyze sales transactions throughout the day. During peak business hours, dashboard queries begin taking longer than expected. Using Site24x7, administrators observe an increase in queued queries and query wait times while compute capacity remains saturated. Based on these insights, they optimize workloads and adjust resource allocation, reducing query latency before it impacts business users.
Monitor storage growth and database activity
A financial organization stores historical transaction data in Amazon Redshift Serverless for compliance reporting. Over time, storage usage increases steadily across namespaces. Site24x7 helps administrators monitor storage growth, database activity, and table counts, allowing them to archive obsolete data and maintain optimal query performance.
Track compute usage limits
An organization configures compute usage limits to control analytics costs. Site24x7 continuously monitors available and consumed compute quotas, enabling administrators to identify workloads approaching configured limits and take corrective action before reporting jobs are interrupted.
Setup and configuration
To get started with Redshift Serverless monitoring:
- Log in to your Site24x7 account.
- Go to Cloud > AWS > Integrate AWS Account and create a cross-account IAM role to enable Site24x7 to access your AWS resources.
- On the Integrate AWS Account page, select Redshift Serverless from the Services to be discovered list based on your requirement.
Permissions
Ensure that the IAM role used for AWS monitoring includes the following permissions:
- redshift-serverless:ListNamespaces
- redshift-serverless:ListWorkgroups
- redshift-serverless:ListRecoveryPoints
- redshift-serverless:ListSnapshots
- redshift-serverless:ListTagsForResource
- redshift-serverless:ListUsageLimits
- redshift-serverless:GetCredentials
- redshift-serverless:GetWorkgroup
- redshift-serverless:GetNamespace
- redshift-data:ListDatabases
The redshift-serverless:GetCredentials permission is required only for Redshift Database discovery and monitoring.
Polling frequency
Site24x7 queries AWS service-level APIs according to the set polling frequency (from once a minute to once a day) to collect metrics from a Redshift Serverless monitor.
Supported metrics
The supported metrics for Amazon Redshift Serverless monitors are provided below.
Redshift Workgroup
The Redshift Workgroup monitor provides metrics that help you analyze compute utilization, workload activity, query performance, and usage limits.
Compute
| Metric name | Description | Statistics | Unit |
|---|---|---|---|
| Compute Capacity | Average number of compute units allocated during the past 30 minutes, rounded up to the nearest integer. | Maximum | Redshift Processing Unit (RPU) |
| Compute Seconds | Accumulated compute unit seconds used in the last 30 minutes. | Sum | RPU seconds |
| Extra Compute for Automatic Optimization Charged Seconds | Compute unit seconds charged for automatic optimization operations in the last 30 minutes. | Sum | RPU seconds |
Database
| Metric name | Description | Statistics | Unit |
|---|---|---|---|
| Database Connections | Number of active database connections. | Maximum | Count |
| All Queries Running | Number of all running queries. | Maximum | Count |
Running Queries
| Metric name | Description | Statistics | Unit |
|---|---|---|---|
| Insert Queries Running | Number of running INSERT queries. | Average | Count |
| Delete Queries Running | Number of running DELETE queries. | Average | Count |
| Update Queries Running | Number of running UPDATE queries. | Average | Count |
| Load Queries Running | Number of running LOAD queries. | Average | Count |
| Unload Queries Running | Number of running UNLOAD queries. | Average | Count |
| Select Queries Running | Number of running SELECT queries. | Average | Count |
| All Queries Running | Number of all running queries. | Maximum | Count |
| CTAS Queries Running | Number of running Create Table As Select (CTAS) queries. | Average | Count |
| Other Queries Running | Number of running queries that do not belong to the preceding categories. | Average | Count |
Queued Queries
| Metric name | Description | Statistics | Unit |
|---|---|---|---|
| Insert Queries Queued | Number of queued INSERT queries. | Maximum | Count |
| Delete Queries Queued | Number of queued DELETE queries. | Maximum | Count |
| Update Queries Queued | Number of queued UPDATE queries. | Maximum | Count |
| Load Queries Queued | Number of queued LOAD queries. | Maximum | Count |
| Unload Queries Queued | Number of queued UNLOAD queries. | Maximum | Count |
| Select Queries Queued | Number of queued SELECT queries. | Maximum | Count |
| CTAS Queries Queued | Number of queued CTAS queries. | Maximum | Count |
| Other Queries Queued | Number of queued queries that do not belong to the preceding categories. | Maximum | Count |
Successful Queries
| Metric name | Description | Statistics | Unit |
|---|---|---|---|
| Insert Queries Succeeded | Number of successful INSERT queries during the last five minutes. | Sum | Count |
| Delete Queries Succeeded | Number of successful DELETE queries during the last five minutes. | Sum | Count |
| Update Queries Succeeded | Number of successful UPDATE queries during the last five minutes. | Sum | Count |
| Load Queries Succeeded | Number of successful LOAD queries during the last five minutes. | Sum | Count |
| Unload Queries Succeeded | Number of successful UNLOAD queries during the last five minutes. | Sum | Count |
| Select Queries Succeeded | Number of successful SELECT queries during the last five minutes. | Sum | Count |
| CTAS Queries Succeeded | Number of successful CTAS queries during the last five minutes. | Sum | Count |
| Other Queries Succeeded | Number of successful queries that do not belong to the preceding categories. | Sum | Count |
Failed Queries
| Metric name | Description | Statistics | Unit |
|---|---|---|---|
| Insert Queries Failed | Number of failed INSERT queries during the last five minutes. | Sum | Count |
| Delete Queries Failed | Number of failed DELETE queries during the last five minutes. | Sum | Count |
| Update Queries Failed | Number of failed UPDATE queries during the last five minutes. | Sum | Count |
| Load Queries Failed | Number of failed LOAD queries during the last five minutes. | Sum | Count |
| Unload Queries Failed | Number of failed UNLOAD queries during the last five minutes. | Sum | Count |
| Select Queries Failed | Number of failed SELECT queries during the last five minutes. | Sum | Count |
| CTAS Queries Failed | Number of failed CTAS queries during the last five minutes. | Sum | Count |
| Other Queries Failed | Number of failed queries that do not belong to the preceding categories. | Sum | Count |
Query Throughput
| Metric name | Description | Statistics | Unit |
|---|---|---|---|
| Short Query Throughput | Number of queries with latency less than 10 seconds completed each second. | Maximum | Count |
| Medium Query Throughput | Number of queries with latency between 10 seconds and 10 minutes completed each second. | Maximum | Count |
| Long Query Throughput | Number of queries with latency greater than 10 minutes completed each second. | Maximum | Count |
Query Duration
| Metric name | Description | Statistics | Unit |
|---|---|---|---|
| Short Query Duration | Average duration of short running queries. | Maximum | Microseconds |
| Medium Query Duration | Average duration of medium running queries. | Maximum | Microseconds |
| Long Query Duration | Average duration of long running queries. | Maximum | Microseconds |
Query Execution
| Metric name | Description | Statistics | Unit |
|---|---|---|---|
| Query Plan | Total time spent parsing and optimizing SQL statements. | Maximum | Milliseconds |
| Query Wait | Total time spent waiting in the Workload Management (WLM) queue. | Maximum | Milliseconds |
| Query Read | Total time spent executing read queries. | Average | Milliseconds |
| Query Insert | Total time spent executing INSERT queries. | Average | Milliseconds |
| Query Delete | Total time spent executing DELETE queries. | Average | Milliseconds |
| Query Update | Total time spent executing UPDATE queries. | Average | Milliseconds |
| Query CTAS | Total time spent executing CTAS queries. | Average | Milliseconds |
| Query Unload | Total time spent executing UNLOAD queries. | Average | Milliseconds |
| Query Copy | Total time spent executing COPY queries. | Average | Milliseconds |
| Query Commit | Total time spent committing transactions. | Average | Milliseconds |
Usage Limits
| Metric name | Description | Statistics | Unit |
|---|---|---|---|
| Compute Usage Limit Available | Remaining compute quota available for the configured usage limit. | Minimum | RPU hours |
| Compute Usage Limit Consumed | Compute quota consumed for the configured usage limit. | Maximum | RPU hours |
| Datasharing Usage Limit Available | Remaining data sharing quota available. | Minimum | TB |
| Datasharing Usage Limit Consumed | Data sharing quota consumed. | Maximum | TB |
| Usage Limit Consumed Percentage | Percentage of the configured compute or data sharing usage limit that has been consumed. | Maximum | Percentage |
Storage
| Metric name | Description | Statistics | Unit |
|---|---|---|---|
| Redshift Managed Storage Billed Used Space | Amount of billed Redshift Managed Storage currently consumed by the namespace. | Maximum | MB |
| Redshift Managed Storage Ds Used Space | Amount of billed Redshift Managed Storage used for data sharing (DS) within the namespace. | Maximum | MB |
Redshift Namespace
| Metric name | Description | Statistics | Unit |
|---|---|---|---|
| Data Storage | Total storage used by Redshift data within the namespace. | Average | MB |
| Redshift Managed Storage Billed Used Space | Amount of billed Redshift Managed Storage consumed. | Maximum | MB |
| Redshift Managed Storage DS Used Space | Amount of billed Redshift Managed Storage used for data sharing (DS). | Maximum | MB |
| Total Table Count | Total number of user tables. Amazon Redshift Spectrum tables are excluded. | Average | Count |
Redshift Database
The Redshift Database monitor supports all metrics available in the Redshift Workgroup monitor , except for the Compute and Usage Limits metric types.
In addition, it supports the following metric:
| Metric name | Description | Statistic | Unit |
|---|---|---|---|
| Total Table Count | Total number of tables in the database. | Average | Count |
Threshold configuration
To configure thresholds for an Amazon Redshift Serverless monitor:
- Log in to your Site24x7 account.
- Navigate to Admin > Configuration Profiles > Threshold and Availability.
- Click Add Threshold Profile.
- Select one of the following monitor types:
- Redshift Workgroup
- Redshift Namespace
- Redshift Database
- Configure threshold values for the supported metrics.
- Click Save.
Threshold profiles help you proactively detect performance degradation, increasing query latency, storage growth, compute saturation, and workload bottlenecks.
Organize Amazon Redshift Serverless using Monitor Groups
Monitor Groups help you organize Amazon Redshift Serverless resources based on applications, environments, departments, or business units, making it easier to monitor related analytics workloads from a single view.
For example, an organization may maintain separate Redshift Serverless environments for Development, Testing, and Production. By grouping the associated Workgroups, Namespaces, and Databases into dedicated Monitor Groups, administrators can quickly assess the health of each environment and receive consolidated alerts for related resources.
Monitor Groups also simplify dashboard creation, reporting, and notification management across multiple Redshift Serverless deployments.
Capacity Planning
Capacity Planning helps you analyze historical utilization trends and forecast future resource requirements for your Amazon Redshift Serverless environment.
By monitoring metrics such as compute capacity, compute consumption, storage utilization, query throughput, and query duration over time, you can identify workload growth patterns and anticipate future capacity requirements.
For example, if compute utilization continues to increase during business hours over several weeks, Capacity Planning can help estimate future resource demands. This allows administrators to optimize workloads, adjust application scheduling, or redesign queries before increasing workload complexity affects performance or operational costs.
Licensing
Each Amazon Redshift Serverless monitor consumes licenses as follows:
| Monitor type | License |
|---|---|
| Redshift Workgroup | 1 Advanced monitor |
| Redshift Namespace | Free |
| Redshift Database | Free |
Viewing Amazon Redshift Serverless data
To monitor your Amazon Redshift Serverless environment:
- Log in to your Site24x7 account and navigate to Cloud > AWS.
- Select Redshift Workgroup, Redshift Namespace, or Redshift Database.
Monitor data
Redshift Workgroup
Summary
The Summary tab provides an overview of the Redshift Workgroup's health, compute utilization, and query performance. View the events timeline along with key metrics, such as compute capacity, compute seconds, and database connections, to quickly identify workload trends and performance bottlenecks.
Queries
The Queries tab provides an overview of query activity across the Redshift Workgroup. View charts for running, queued, successful, and failed queries, categorized by query type. This tab helps you monitor query execution patterns, identify workload backlogs, detect failed queries, and understand overall database activity.
Database Performance
The Database Performance tab provides insights into the overall performance of the Redshift Workgroup. View the current performance configuration and monitor key workload metrics, including Query Throughput, Query Duration, and Query Runtime breakdown. These charts help you analyze query execution efficiency, identify long-running workloads, and detect performance bottlenecks affecting database operations.
Usage Limit
The Usage Limit tab displays the configured compute and data sharing usage limits for the workgroup. View the Available Quota, Consumed Quota, and Usage Percentage to monitor resource consumption against configured limits.
The Usage Limit tab is displayed only when usage limits are configured for the workgroup in AWS.
Namespace
The Namespace tab lists the Redshift Namespace monitor associated with the selected workgroup. Click the monitor name to view namespace-level storage metrics and configuration details.
Topology View
The Topology View tab delivers a live, resource-centric dependency map. It dynamically traces how your Redshift Workgroup resource is connected to its surrounding AWS infrastructure in real time, enabling faster root cause isolation when alerts fire. If any connected component is in a Critical state, it is marked accordingly within the topology view, along with the outage reason, so you can pinpoint the exact failure point without needing to navigate away from the monitor page. Unlike account-wide topology views, this tab scopes visualization to a single resource, answering the precise question: What does this Redshift Workgroup resource connect to, and what breaks if it does? You can trace the full dependency chain from the individual resource up through its primary parent entities to the Service type, Region, and AWS account levels.
Zia Forecast
A forecast chart displays future points of a performance metric (measurement of resource usage) based on historical time series data. Thirty days of historical data is used to predict what your metric usage will be in the next seven days.
Configuration
The Configuration tab displays the complete configuration of the workgroup, including the associated namespace, base capacity, enhanced VPC routing status, publicly accessible configuration, subnet information, security groups, and other resource properties. Use this tab to review the workgroup configuration and verify deployment settings.
Outages
The Outages tab provides details on an outage's Start Time, End Time, Duration, and Comments, if any.
Notes
The Notes tab displays additional monitor information, including the Resource ID, AWS Region, Licensing Category, Threshold and Availability Profile, Notification Profile, and other monitor-specific details.
Log Report
The Log Report tab provides a consolidated report of the monitor's log status, which can be downloaded as a CSV file.
Alert Logs
The Alert Logs tab displays a chronological list of alerts triggered for the Redshift Workgroup monitor, helping you review alert history, severity, and threshold violations.
Audit Logs
The Audit Logs tab displays a chronological record of configuration changes and management operations performed on the selected Redshift resource. This tab helps you track administrative activities, troubleshoot configuration changes, and maintain an audit trail for security and compliance purposes.
Redshift Namespace
Summary
The Summary tab provides an overview of the namespace's storage utilization and its related metrics. View the events timeline along with key metrics such as data storage, Redshift Managed Storage usage, data sharing storage usage, and total table count to understand storage consumption and monitor database growth.
Snapshots
The Snapshots tab lists all manual snapshots available for the selected Redshift Namespace. View details such as the Snapshot Name, Current Status, Snapshot Size, Retention Period, Creation Time, and Expiration Time. This tab helps you verify snapshot availability and retention, making it easier to manage backup and recovery operations.
Recovery Points
The Recovery Points tab displays the recovery points available for the selected Redshift Namespace. View details including the Recovery Point Identifier, Creation Time, and the time until which the recovery point is available. Use this tab to review available recovery points and verify recovery readiness for point-in-time restore operations.
Database
The Database tab lists all Redshift Database monitors discovered under the selected namespace. Click a database monitor to view database-level performance metrics, query activity, and configuration details.
Configuration
The Configuration tab displays the complete configuration of the namespace, including its Status, Created Date, KMS Key ID, Admin Username, and Lakehouse Registration Status. Use this tab to review the namespace configuration and verify storage and security settings.
Topology View
The Topology View tab delivers a live, resource-centric dependency map. It dynamically traces how your Redshift Namespace resource is connected to its surrounding AWS infrastructure in real time, enabling faster root cause isolation when alerts fire. If any connected component is in a Critical state, it is marked accordingly within the topology view, along with the outage reason, so you can pinpoint the exact failure point without needing to navigate away from the monitor page.
Unlike account-wide topology views, this tab scopes visualization to a single resource, answering the precise question: What does this Redshift Namespace resource connect to, and what breaks if it does? You can trace the full dependency chain from the individual resource up through its primary parent entities to the Service type, Region, and AWS account levels.
Zia Forecast
A forecast chart displays future points of a performance metric (measurement of resource usage) based on historical time series data. Thirty days of historical data is used to predict what your metric usage will be in the next seven days.
Outages
The Outages tab provides details on an outage's Start Time, End Time, Duration, and Comments, if any.
Notes
The Notes tab displays additional monitor information, including the Resource ID, AWS Region, Licensing Category, Threshold and Availability Profile, Notification Profile, and other monitor-specific details.
Log Report
The Log Report tab provides a consolidated report of the Redshift Namespace monitor's log status, which can be downloaded as a CSV file.
Alert Logs
The Alert Logs tab displays a chronological list of all alerts triggered for the Redshift Namespace monitor. This tab helps you review alert history, severity, and threshold violations.
Audit Logs
The Audit Logs tab displays a chronological record of configuration changes and management operations performed on the selected Redshift resource. This tab helps you track administrative activities, troubleshoot configuration changes, and maintain an audit trail for security and compliance purposes.
Redshift Database
Summary
The Summary tab provides an overview of the database's health and query performance. View the events timeline along with key metrics such as database connections and total table count. These metrics help you monitor workload activity and detect performance bottlenecks at the database level.
Queries
The Queries tab provides an overview of query activity across the Redshift Database. View charts for running, queued, successful, and failed queries, categorized by query type. This tab helps you monitor query execution patterns, identify workload backlogs, detect failed queries, and understand overall database activity.
Database Performance
The Database Performance tab provides insights into the overall performance of the Redshift Database. View the current performance configuration and monitor key workload metrics, including Query Throughput, Query Duration, and Query Runtime breakdown. These charts help you analyze query execution efficiency, identify long-running workloads, and detect performance bottlenecks affecting database operations.
Topology View
The Topology View tab delivers a live, resource-centric dependency map. It dynamically traces how your Redshift Database resource is connected to its surrounding AWS infrastructure in real time, enabling faster root cause isolation when alerts fire. If any connected component is in a Critical state, it is marked accordingly within the topology view, along with the outage reason, so you can pinpoint the exact failure point without needing to navigate away from the monitor page.
Unlike account-wide topology views, this tab scopes visualization to a single resource, answering the precise question: What does this Redshift Database resource connect to, and what breaks if it does? You can trace the full dependency chain from the individual resource up through its primary parent entities to the Service type, Region, and AWS account levels.
Zia Forecast
A forecast chart displays future points of a performance metric (measurement of resource usage) based on historical time series data. Thirty days of historical data is used to predict what your metric usage will be in the next seven days.
Outages
The Outages tab provides details on an outage's Start Time, End Time, Duration, and Comments, if any.
Notes
The Notes tab displays additional monitor information, including the Resource ID, AWS Region, Licensing Category, Threshold and Availability Profile, Notification Profile, and other monitor-specific details.
Log Report
The Log Report tab provides a consolidated report of the Redshift Database monitor's log status, which can be downloaded as a CSV file.
Alert Logs
The Alert Logs tab displays a chronological list of all alerts triggered for the Redshift Database monitor. This tab helps you review alert history, severity, and threshold configurations.
Audit Logs
The Audit Logs tab displays a chronological record of configuration changes and management operations performed on the selected Redshift resource. This tab helps you track administrative activities, troubleshoot configuration changes, and maintain an audit trail for security and compliance purposes.
-
On this page
- Overview
- Benefits of Site24x7's Amazon Redshift Serverless integration
- Use cases
- Setup and configuration
- Permissions
- Polling frequency
- Supported metrics
- Threshold configuration
- Organize Amazon Redshift Serverless using Monitor Groups
- Capacity Planning
- Licensing
- Viewing Amazon Redshift Serverless data
- Monitor data