Use the following procedure for monitoring the Cassandra database.

  1. Navigate to Database monitoring on the left pane.
  2. Select Postgres from the Select database drop-down list.
  3. Select a service from the Select service drop-down list.

The following screen appears along with the various available tabs.

Postgres Hardware


The Hardware tab is selected by default. The following widgets are displayed.

Widget NameDescription
CPU usageCPU utilization of host
Memory usageMemory utilization of host
Netowork I/ONetwork input/output data in MB
Connections & sessionsdatabase number of connections & sessions count

Query Performance

Clicking the Query Performance tab and selecting the threshold from the Query threshold drop-down list displays the following screen.

Postgres query threshold

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.

Postgres connections
Widget NameDescription
No. of connectionsDatabase number of connections count
No. of sessionsDatabase number of sessions count
Session detailsSession details having users and queries count with time


Clicking the Metrics tab displays the following widgets.

Postgres metrics
Widget NameDescription
Bulk operationsBuffer and block hits count
Confis operationsQueries cancelled due to deadlock, pinned buffer, timeout, old snapshot, and dropped tablespaces
Tup operationsnumber of operations count like fetch, delete, insert, returned, and update
Xact operationsCommit and rolled back transactions count