PostgreSQL DB Servers

Introduction:

This section is common to all the editions of IT360, as per the below constraints;

Professional Edition
Enterprise Edition [Applicable to Probes only, and not applicable / relevant to the Central Server, since the configuration of the monitors happens only at the Probe level. However, you may see these discovered monitors from the Central Server]
MSP Edition [Applicable to Probes only, and not applicable / relevant to the Central Server, since the configuration of the monitors happens only at the Probe level. However, you may see these discovered monitors from the Central Server]

Supported Versions:

IT360 supports monitoring of PostgreSQL 8.1 and above.

Monitored Parameters:

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.

Top

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.

Top