Updated on 2026-08-24 GMT+08:00

Viewing DWS Database Details

The Database Monitoring page displays the real-time and historical resource consumption of a database.

Database Monitoring

  1. Log in to the DWS console.
  2. Choose Cluster > Cluster List and locate the cluster to be monitored.
  3. In the Operation column of the target cluster, click Monitoring Panel. The database monitoring page is displayed.
  4. In the navigation pane on the left, choose Monitoring > Database Monitoring.

Database Resource Consumption

You can select a database to view its resource usage and performance metrics. For details about the metrics, see Table 1.

Table 1 Database resource consumption metrics

Metric

Description

Monitoring Interval (Raw Data)

Database Name

Name of the database

180s

Usage (GB)

Used capacity of the database

180s

Monitoring

You can click the monitoring icon to view the number of queries, number of sessions, and capacity of the database.

-

Users

Number of users of the database

180s

Applications

Number of applications of the database

180s

Sessions

Number of database sessions

180s

Active Queries

Number of queries in the database

180s

Inserted Rows

Number of rows inserted by queries in this database

180s

Updated Rows

Number of rows updated by queries in this database

180s

Deleted Rows

Number of rows deleted by queries in this database

180s

Deadlocks

Number of deadlocks detected in this database

180s

Temporary Files

Number of temporary files created by queries in this database

180s

Capacity of Temporary Files

Total amount of data written to temporary files by queries in this database.

180s