Use cases

As an 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. PATROL for PostgreSQL provides you the metrics that depict a clear picture of the activity in the PostgreSQL environment. These metrics help you decide whether the attributes in the database need to be adjusted to meet the demands being made on the database.

Consult the following use cases for information on how to achieve value with PATROL for PostgreSQL:

• Managing the database free space
• Monitoring the database transactions
• Tracking the cache size of database
• Tuning the maximum connections in the database
• Using custom SQL queries