What is PostgreSQL Database?
PostgreSQL, often called Postgre, is an Open Source object and relational database management system (ORDBMS). It is distributed under a System PostgreSQL License, which is similar to a permissive BSD or MIT license. It is the default MacOS Server Database and is also available for Windows, Linux platforms and other Operating Systems.
PostgreSQL Database monitoring
This package monitors a PostgreSQL Database.
This package automatically configures the ServicePilot Agent in order to monitor a PostgreSQL Database by using SQL requests.
The statistics gathered in this way allow PostgreSQL system performance monitoring (Locks, Connection Idle, Connection Activity... ), database statistics performance management (database size, transactions commits, rows inserted, deleted...) as well as indicators on database instance rows.
ServicePilot allows you to build a complete PostgreSQL database performance checklist. Using additional ServicePilot packages to monitor your application and database environment, you can:
- Verify your system and OS works fine with server data
- Ensure your virtualization health with virtual machine metrics
- Tune and monitor database access by searching application data
- Analyze the network impact of database communication by looking at network data
Having a full-stack visibility over PostgreSQL metrics is vital to know how and what caused PostgreSQL performance degradation.