Monitoring
Monitoring Your PSQL Environment
PSQL is designed for ease of use and minimal administration. At times, however, you may want to monitor various conditions or resources in the PSQL environment. For example, you may need to tune portions of your application and monitor various performance aspects pertaining to the database. Or, you may have adjusted PSQL configuration settings for your business needs and want to monitor the changes from the default settings.
This chapter includes the following sections:
•
Monitoring Database State
•
Monitoring Data File Fragmentation
•
Monitoring Performance Counters
•
Monitoring License Usage
•
Monitoring Database Access
•
Reviewing Message Logs
•
Receiving Email Notification of Messages