Page tree

As the database administrator, you are responsible for ensuring that PostgreSQL database users can access the database environment and get the information they request in a quick and timely manner. The PATROL for PostgreSQL KM has many metrics that provide you with a clear picture of the activity in the PostgreSQL environment. These metrics will help you decide whether the parameters in the database need to be adjusted to meet the demands being made on the database.

The following are a few examples of how you can use these metrics

Tracking the database cache size 

The PostgreSQL database uses an amount of disk cache to process each transaction. The more transaction requests received by the database the more of the database's allotted cache is used.

You can use the PostgreSQL KM's Database cache usage attribute to set a threshold warning and alarm that will alert you when the threshold value is crossed. If the threshold is crossed, the KM generates an event that can be viewed by the Database cache usage graph.

Database cache usage graph

You can then determine if the disk cache that the PostgreSQL database can use is sufficient for the amount of received transactions, or whether it needs to be increased. 

Adjusting the maximum connections to the database

As connections are made to the PosgreSQL database, you will want to monitor how many connections are made to the database and how many database elements are locked at one time, or are waiting to get a lock.

You can use the PostgreSQL KM's Number of connections,  Number of elements waiting to get a Lock, or Number of locked elements attributes to set a threshold warning and alarm that will alert you when the threshold value for any of these attributes is crossed. For instance, if the number of connections surpasses the attribute's threshold, the KM generates an event that can be viewed by the Number of connections graph.

Number of connections graph

With this graph, you can see the number of connections that the PostgreSQL is handling and decide if the amount needs to be adjusted.

Where to go from here

You can read about additional attributes in the Using topics. These attributes provide valuable data that lets you monitor the activity and health of the PostgreSQL database.