Use the following procedure for monitoring the Cassandra database.
- Navigate to Database monitoring on the left pane.
- Select Postgres from the Select database drop-down list.
- Select a service from the Select service drop-down list.
The following screen appears along with the various available tabs.
The Hardware tab is selected by default. The following widgets are displayed.
|CPU utilization of host
|Memory utilization of host
|Network input/output data in MB
|Connections & sessions
|database number of connections & sessions count
Clicking the Query Performance tab and selecting the threshold from the Query threshold drop-down list displays the following screen.
You can download the Query Performance table in PDF format by clicking the icon. Only the top 100 entries are downloaded if there are more than 100 entries for downloading.
Clicking the Connections tab displays the following widgets as in the following screen.
|No. of connections
|Database number of connections count
|No. of sessions
|Database number of sessions count
|Session details having users and queries count with time
Clicking the Metrics tab displays the following widgets.
|Buffer and block hits count
|Queries cancelled due to deadlock, pinned buffer, timeout, old snapshot, and dropped tablespaces
|number of operations count like fetch, delete, insert, returned, and update
|Commit and rolled back transactions count