Table of Contents
Key performance indicators of the system can be monitored using graphs based on metrics collected by pgpro-otel-collector. For the graphs to work properly, you must first install and configure logging and monitoring tools.
You can also access SQL metrics that are provided based on planning statistics and SQL statement execution statistics collected by the pgpro_stats extension.
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.