Monitoring Agent for PostgreSQL metrics

The metrics for Monitoring Agent for PostgreSQL resource types collect data for monitoring with IBM Cloud Pak for Multicloud Management. Every Monitoring Agent for PostgreSQL resource type defines a set of dimensions and metrics. The descriptions provide such information as data type, dimension key, and metric unit.

Resource postgreSqlDatabase

Set of Databases of PostgreSQL server that shows monitoring metrics of particular database. The following section lists the metrics, dimensions and components of Resource postgreSqlDatabase.

Metrics

The following metrics are available for the resource.

Tablespace Size

• The size of the table space in MB.
• The type is int.
• The unit is megabytes.

Dimensions

The following dimensions are available for the resource.

Database Name

• The name of the database.
• The type is string.

Node

• The name of the managed system of agent.
• The type is string.

Tablespace Name

• The name of the table space.
• The type is string.

Time Stamp

• This is the local time when the data was collected. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is timestamp.

Component: BufferHitRate

The buffer hit percentage data set provides information about the hit percentage of all buffers that are available for the database. The following section lists the metrics and dimensions of Component BufferHitRate.

Metrics

The following metrics are available for the component.

Buffer Hit Rate Percent

• The database buffer hit percentage. 101 represents 'No active connections'. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is int.
• The unit is percent.

Buffer Hit Rate Percentage

• The database buffer hit percentage.
• The type is int.
• The unit is percent.

Number of Active Connections

• The number of active connections to the respective database.
• The type is int.
• The unit is connections.

Dimensions

The following dimensions are available for the component.

Buffer Hit Rate Database Name

• The name of the database.
• The type is string.

Buffer Hit Rate DB Allow Connections

• Indicates whether the database allows connections.
• The type is string.

Buffer Hit Rate Node

• Name of managed system of agent.
• The type is string.

Buffer Hit Rate Time Stamp

• This is the local time when the data was collected. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is timestamp.

Component: DatabaseQueryCounts

The execution count of SQL statements by the respective databases. The following section lists the metrics and dimensions of Component DatabaseQueryCounts.

Metrics

The following metrics are available for the component.

Query Counts Delete Sql Count

• The number of DELETE SQL statements that ran since the last pg_stat_statements module was enabled or reset.
• The type is int.
• The unit is queries.

Query Counts Insert Sql Count

• The number of INSERT SQL statements that ran since the last pg_stat_statements module was enabled or reset.
• The type is int.
• The unit is queries.

Query Counts Select Sql Count

• The number of SELECT SQL statements that ran since the last pg_stat_statements module was enabled or reset.
• The type is int.
• The unit is queries.

Query Counts Total Count

• The number of SQL statements that ran since the last pg_stat_statements module was enabled or reset.
• The type is int.
• The unit is queries.

Query Counts Update Sql Count

• The number of UPDATE SQL statements that ran since the last pg_stat_statements module was enabled or reset.
• The type is int.
• The unit is queries.

Dimensions

The following dimensions are available for the component.

Query Counts Database Name

• The name of the database.
• The type is string.

Query Counts Node

• Name of the managed system of agent.
• The type is string.

Query Counts Time Stamp

• This is the local time when the data was collected. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is timestamp.

Component: DeadlockInfo

Information about deadlocks. The following section lists the metrics and dimensions of Component DeadlockInfo.

Metrics

The following metrics are available for the component.

Dead Lock Info Dead Locks Count

• The total number of deadlocks, which is the total number of rows in the pg_stat_database_conflicts table.
• The type is int.
• The unit is deadlocks.

Dead Lock Info Total Failed Queries

• The total number of failed queries, which is the total number of rows in the pg_stat_database table. This is available for thresholds, but not in the UI.
• The type is int.
• The unit is queries.

Dimensions

The following dimensions are available for the component.

Dead Lock Info Database Name

• The name of the database.
• The type is string.

Dead Lock Info Node

• Agent node name.
• The type is string.

Dead Lock Info Time Stamp

• This is the local time when the data was collected. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is timestamp.

Component: ResponseTime

ResponseTime. The following section lists the metrics and dimensions of Component ResponseTime.

Metrics

The following metrics are available for the component.

Response Time SQL Statement Response Time

• The response time of the SQL statement in milliseconds.
• The type is double.
• The unit is milliseconds.

Dimensions

The following dimensions are available for the component.

Response Time Database Name

• The database name.
• The type is string.

Response Time Node

• nodename.
• The type is string.

Response Time Time Stamp

• This is the local time when the data was collected. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is string.

Resource postgreSqlInstance

Instances that shows monitoring metrics for PostgreSQL server. The following section lists the metrics, dimensions and components of Resource postgreSqlInstance.

Metrics

The following metrics are available for the resource.

Dimensions

The following dimensions are available for the resource.

Agent Host Name

• Short host name of the agent machine.
• The type is string.

Database Name

• Name of the database.
• The type is string.

Fully Qualified Domain Name

• Fully qualified domain name of this server.
• The type is string.

Host Name

• Short host name of this server.
• The type is string.

Instance Name

• The instance name of the agent that represents PostgreSQL agent.
• The type is string.

IP Address

• IP address of this server.
• The type is string.

node

• Agent system name.
• The type is string.

Port

• TCP port for this server.
• The type is int.

Time Stamp

• This is the local time when the data was collected. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is timestamp.

Component: ApplicationAvailability

The Application Availability attribute group provides information about the availability of the PostgreSQL service. The following section lists the metrics and dimensions of Component ApplicationAvailability.

Metrics

The following metrics are available for the component.

Status

• The status of the PostgreSQL service, such as up or down.
• The type is string.
• The unit is status.

Dimensions

The following dimensions are available for the component.

Application Availability Timestamp

• The local time at the agent when the data was collected. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is timestamp.

Node

• Originnode of Application Availability.
• The type is string.

Component: Connection_Num

The data set provides the number of active connections. The following section lists the metrics and dimensions of Component Connection_Num.

Metrics

The following metrics are available for the component.

Connection Num Maximum Active Connections

• The Maximum number of active connections, which is the total number of rows in the pg_stat_activity table.
• The type is int.
• The unit is Connections.

Connection Num Total Active Connections

• The total number of active connections, which is the total number of rows in the pg_stat_activity table.
• The type is int.
• The unit is Connections.

Connection Number Percent Active Connections

• The Percentage of Maximum number of active connections.
• The type is int.
• The unit is percent.

Dimensions

The following dimensions are available for the component.

Connection Num Node

• Agent system name.
• The type is string.

Connection Num Time Stamp

• This is the local time when the data was collected. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is timestamp.

Component: DB_CPU

The total CPU usage percentage, out of the system, of database processes ("postgres") since they started. The following section lists the metrics and dimensions of Component DB_CPU.

Metrics

The following metrics are available for the component.

CPU Value

• The total CPU usage percentage, out of the system, of database processes ('postgres') since they started.
• The type is int.
• The unit is percent.

Dimensions

The following dimensions are available for the component.

DB CPU Node

• Agent system name.
• The type is string.

DB CPU Time Stamp

• This is the local time when the data was collected. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is timestamp.

Component: DB_Memory

The memory usage of all database processes ("postgres") in MB. The following section lists the metrics and dimensions of Component DB_Memory.

Metrics

The following metrics are available for the component.

Database Memory percentage Memory

• The memory usage of all database processes ('postgres') in %.
• The type is double.
• The unit is Percent (%).

Database Memory Value

• The memory usage of all database processes ('postgres') in MB.
• The type is double.
• The unit is Megabytes.

Dimensions

The following dimensions are available for the component.

Database Memory Node

• Agent System Name.
• The type is string.

Database Memory Timestamp

• This is the local time when the data was collected. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is timestamp.

Component: DB_Num

The total number of databases, both inactive and active. The following section lists the metrics and dimensions of Component DB_Num.

Metrics

The following metrics are available for the component.

DB Num Active Databases Count

• The total number of databases that can be connected to or are active.
• The type is int.
• The unit is databases.

Inactive db num

• The total number of databases that cannot be connected to or are inactive.
• The type is int.
• The unit is databases.

Dimensions

The following dimensions are available for the component.

DB Num Node

• Not Available.
• The type is string.

DB Num Time Stamp

• This is the local time when the data was collected. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is timestamp.

Component: Locksum

The number of locks on which one or more transactions are waiting. The following section lists the metrics and dimensions of Component Locksum.

Metrics

The following metrics are available for the component.

Lock Count Transaction Locks Waiting

• The number of locks on which transactions are waiting.
• The type is int.
• The unit is count.

Dimensions

The following dimensions are available for the component.

Lock Count Node

• Locksum node.
• The type is string.

Lock Summary Time Stamp

• This is the local time when the data was collected. This is not available in the UI by default. It can be made available through dynamic configuration.
• The type is timestamp.