ManageEngine® Applications Manager


PostgreSQL DB Servers

<< Prev

Home

Next >>

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:

Monitor 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.

Connection Statistics

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

Lock Statistics

Parameter

Description

Locks Held

Number of locks held by the indicated session

Locks Wait

Number of locks waiting in the database

Buffer Statistics

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

Disk Usage Details

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

Index Scan Details

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

Query Statistics

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

Transaction Details

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

Table Level Scan Details

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

 

Primary Database Object Statistics

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

 

See Also

 

Creating New Monitor - PostgreSQL Database Server

 

 

<< Prev

Home

Next >>

SAP HANA DB Servers

NoSQL Database Servers