Postgres
Use the following procedure for monitoring the Postgres 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.
- Select a database from the Select database drop-down list.
The following screen appears along with the various available tabs.
Hardware
The Hardware tab is selected by default. The following widgets are displayed.
| Widget Name | Description |
|---|---|
| CPU usage | CPU utilization of host |
| Memory usage | Memory utilization of host |
| Netowork I/O | Network input/output data in MB |
| Connections & sessions | database 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.
note
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.
Connections
Clicking the Connections tab displays the following widgets as in the following screen.
| Widget Name | Description |
|---|---|
| No. of connections | Database number of connections count |
| No. of sessions | Database number of sessions count |
| Session details | Session details having users and queries count with time |
Metrics
Clicking the Metrics tab displays the following widgets.
| Widget Name | Description |
|---|---|
| Bulk operations | Buffer and block hits count |
| Confis operations | Queries cancelled due to deadlock, pinned buffer, timeout, old snapshot, and dropped tablespaces |
| Tup operations | number of operations count like fetch, delete, insert, returned, and update |
| Xact operations | Commit and rolled back transactions count |