This dashboard lists all monitored Redshift Clusters and contains high-level information on cluster structure, nodes, health status, notable queries and key metrics. The workload metric shows the amount of work the server is doing to respond to user queries and can be used to compare workload against other clusters. Selecting a cluster will navigate to the Cluster Overview page. In the cluster table, when the value in the Nodes column is clicked, it will navigate to the Nodes page and similarly, when the Databases or Tables value is clicked, it will navigate to the Tables page. Other column values will show a time plot when hovered or clicked on.
This page displays the cluster overview with availability, performance, storage metrics and the top 10 alarms and SQL statements. The Workload Breakdown pie chart can be clicked or hovered over for a detailed chart of time spent in different query execution stages for the selected time range. The SQL statements can be ordered by the metrics in the dropdown box.
This page lists all nodes in the selected cluster. Selecting a node will update the bottom section of the page and display performance metrics of the node showing CPU Utilization, Disk Space usage, Network Throughput, Read/Write IOPS, Throughput and Latency. When the Health icon is clicked or hovered on, it displays a list of alarms for that node. All other column values will show a time plot when hovered or clicked on.
This page lists all tables in the selected cluster with information on the size, number of rows, percentage of space used by table and information on sort keys and key distribution. When the health icon is clicked or hovered on, it displays a list of alarms for that table. All other metrics will show a time plot when hovered or clicked on. To filter the list of tables by database, click the select database button on the top left of the table and select one or more databases for which you wish to view the tables.
The Connections page displays the active user sessions and user information. The Sessions Table displays the session information and the associated query information with the user. The Users Table displays a list of database users and their associated privileges. The time plots above display the average number of Database Connections and Network Throughput.
This page displays the key configurations and the current state of the service classes for WLM. When the health icon is clicked or hovered on, it displays a list of alarms for that queue. All other metrics will show a time plot when hovered or clicked on. There is a time plot and a time bar above which displays Average Commit Queue Time and Total WLM Queue Time respectively.
Transactions
This page displays vital information about transactions that currently hold locks on tables in the database. The time plots above display Open Transactions – the number of open transactions during each sample time – and Ungranted Transactions – transactions where the lock has been pending.
The Top Queries table lists top queries and associated information that were executed in the selected page time range. Top queries for each sample period are determined by configuration set in the Agent Properties’ Statement Tracking section. When hovered or clicked on, the query value displays the entire query text.
The S3 Queries table displays Redshift Spectrum queries that have been run on the system in the selected page time range. The S3 queries can be limited by enabling S3 query tracking and providing a limit in # of Top Queries in the Agent Properties’ Statement Tracking section. When hovered or clicked on, the query value displays the entire query text.
This page displays the runtime configuration parameters of the cluster with name, current value, descriptions and other properties.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center