Chapter 51. Metrics
Table of Contents
Key performance indicators of the system can be monitored using charts based on metrics collected by pgpro-otel-collector. For the charts to work properly, you must first install and configure logging and monitoring tools.
Alternatively, you can configure metrics and log collection directly through the web interface for each instance or cluster. For details, see Section 40.10 and Section 41.8.
You can also access SQL metrics that are provided based on planning statistics and SQL statement execution statistics collected by the pgpro_stats extension.
Important
When creating SQL metrics use queries with aggregate functions, such as COUNT, SUM, and AVG. The instance can fail when using metrics based on queries returning more than one row or separate values, for example, SELECT 1.