PostgreSQL metrics
-
- UpdatedJan 30, 2025
- 4 minutes to read
- Yokohama
- IT Operations Management
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.
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. |
Metric | Description |
---|---|
pgsql.db.size (Featured metric) |
Provides metrics on the total disk size utilization for each of the PostgreSQL databases on the server. |
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. |
Metric | Description |
---|---|
pgsql.tables_size (Featured metric) |
Provides metrics on the database table size on the server. |