Using

The database administrator can use the PATROL for PostgreSQL KM metrics to monitor the performance of the PostgreSQL database. If the KM generates an event, the database administrator can use that information to adjust (tune) the parameters set in the PostgreSQL database to ensure that the database is working efficiently according to the demands of the users accessing the database.

The following topics contain information about how to use some of the PostgreSQL KM metrics to understand the ongoing performance of the database.

• 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