What is PostgreSQL?
PostgreSQL, often simply "Postgres" is an open-source object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance.
Distributed under a PostgreSQL license which is similar to permissive BSD or MIT licenses, PostgreSQL supports both SQL (relational) and JSON (non-relational) querying. It was the default database for macOS Server and is also available for Windows, Linux, and other operating systems.
How to monitor PostgreSQL?
ServicePilot makes it easy to monitor a PostgreSQL database requiring only a DB account with read privileges. Simply add a resource from the ServicePilot database-postgresql package to your monitoring environment.
The statistics gathered 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 that your system and OS work 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.
How to install a postgresql resource?
- Use your ServicePilot OnPremise installation or a SaaS account.
- Add a new postgresql resource via the web interface (
/prmresources) or via API (
/prmpackagespage), the default ServicePilot agent or another agent will be provisioned automatically.
Details of the postgresql package are located in the
/prmpackagespage of the software.
ServicePilot enables you to deliver IT services faster and more securely with automated discovery and advanced monitoring features.
By correlating the technology POSTGRESQL with APM and infrastructure monitoring, ServicePilot is able to provide a more comprehensive view of an organization's IT environment.
This allows IT teams to quickly identify and diagnose issues that may be impacting application performance, and take corrective action before end-users are affected.