|
ManageEngine® Applications Manager PostgreSQL DB Servers | ||
Supported Versions: 8.1 and above
The Availability tab displays the availability history of the PostgreSQL database servers in your network for the past 24 hours or 30 days. The Performance tab displays the Health Status and events for the past 24 hours or 30 days. The List view displays all the PostgreSQL servers that you monitor along with their current availability and health status. You can also perform bulk admin configurations from this view. Click on the individual monitors listed to view the following information:
| Parameter |
Description |
|---|---|
|
Name |
Denotes the name of PostgreSQL database server monitor. |
|
Type |
Denotes the type you are monitoring. |
|
Health |
Denotes the health (Clear, Warning, Critical) status of the PostgreSQL server. |
|
Last Polled at |
Specifies the time at which the last poll was performed. |
|
Next Poll at |
Specifies the time at which the next poll is scheduled. |
|
Availability |
Shows the current status of the server - available or not available. |
| Parameter |
Description |
|---|---|
|
Active Connections |
Number of currently active connections to the database |
|
Total Users |
The total number of users active at the time of data collection |
| Parameter |
Description |
|---|---|
|
Locks Held |
Number of locks held by the indicated session |
|
Locks Wait |
Number of locks waiting in the database |
| Parameter |
Description |
|---|---|
|
Buffer Hits/min |
Total buffer hits (i.e., block read requests avoided by finding the block already in buffer cache) per minute |
|
Block Reads/Min |
Total disk blocks read per minute |
|
Cache Hit Ratio |
The current ratio of buffer cache hits to total requests |
| Parameter |
Description |
|---|---|
|
Disk Usage |
Size of the on-disk representation of all tables in the database in MB |
|
Index usage |
Size of the on-disk representation of all indexes in the database in MB |
| Parameter |
Description |
|---|---|
|
Index scans/min |
Total number of index scans initiated per minute |
|
Index Reads/min |
Total number of index entries returned by index scans per minute |
| Index Fetches/min | Total number of live table rows fetched by simple index scans per minute |
| Parameter |
Description |
|---|---|
|
Row inserts/min |
Total numbers of rows returned by each type of scan per minute |
|
Row Updates/min |
Total of row insertions and updates per minute |
| Row Deletes/min | Total number of rows deleted per minute |
| Parameter |
Description |
|---|---|
|
Total Commits |
Total transactions committed |
|
Total Rollbacks |
Total transactions rolled back |
|
Commits/Min |
Total transactions committed per minute |
| Rollbacks/Min | Total transactions rolled back per minute |
| Parameter |
Description |
|---|---|
|
Sequential Scans/min |
Total number of sequential scans per minute |
|
Table Index Scans/min |
Total number of index scans per minute |
|
Sequential Scan Rows Read/min |
Total number of rows returned by sequential scans per minute |
| Table Index Scan Rows Read/min | Total numbers of rows returned by index scans per minute |
| Parameter |
Description |
|---|---|
|
Total Tables |
Total number of tables in the database server |
|
Total Triggers |
Total number of triggers in the database server |
|
Total Procedures |
Total number of procedures in the database server |
| Size of the Largest Table | Size of the largest table in the database server |
| Largest Table(s) | Largest table in the database server |
Creating New Monitor - PostgreSQL Database Server
Sybase DB Servers |
NoSQL Database Servers |