The following tables list and describe the metrics that are gathered as output from the specified PostgreSQL checks. Entries indicated as Featured metrics are high-visibility metrics that are displayed in the Operator Workspace Metric tab after an alert is generated. These metrics provide the operator with additional information to help them further explore the specified issue.

Table 1. postgresql.check-connections metrics
Metric Description
pgsql.connections.active

(Featured metric)

Provides metrics on the total active connections in the PostgreSQL database.
pgsql.connections.idle

(Featured metric)

Provides metrics on the total idle connections on the PostgreSQL database.
Table 2. postgresql.metric-dbsize metrics
Metric Description
pgsql.db.size

(Featured metric)

Provides metrics on the total disk size utilization for each of the PostgreSQL databases on the server.
Table 3. postgresql.metric-locks metrics
Metric Description
pgsql.locks.AccessShareLock Provides metrics on read-lock mode acquired automatically from queried tables.
pgsql.locks.ExclusiveLock Provides metrics on read-lock mode acquired by LOCK TABLE table for IN EXCLUSIVE MODE statements.
Table 4. postgresql.metric-relation-size metrics
Metric Description
pgsql.tables_size

(Featured metric)

Provides metrics on the database table size on the server.