NetApp Closes Acquisition of Instaclustr Read the announcement

Misc Metrics

The Misc metrics group provides details on:

  • Number of connections against each node
  • Open locks in each node
  • Which node is currently the leader / master (i.e. accepting writes)
  • Node uptime
  • Node timeline id

Connections Count

The Connections count metric provides the number of connections against each node in the cluster. Please note that a few of the connections are maintained by instaclustr to perform monitoring, replication and SLA checks.

Connections Count

Open Locks

Open Locks
Provides a count of the number of open locks across the database cluster.  To see more detailed information (e.g. what kinds of locks are active), open a psql terminal and run:
select relation::regclass, * from pg_locks where not granted;

For further information on locks in Postgresql, see the official documentation.

Node role & state

Primary

Provides historical data on which node is acting as the master for the cluster.  In a streaming replication cluster, only one node can accept writes serving as the master and replicating those changes to other nodes.

For further information on replication, see the official documentation.

Running

Provides historical data on which nodes are running.  For example, if one of the Postgresql servers in the cluster was restarted as part of maintenance operations, it would return a value of “0” for the period that it was unavailable.

Timeline id

Displays the current timeline of the database node. Everytime a Point-in-Time-Recovery happens, a new timeline will be formed by the cluster to help differentiate WALs generated by different Point-in-Time-Recovery attempts.

For further information on timeline in PostgreSQL, see the official documentation.

By Instaclustr Support
Need Support?
Experiencing difficulties on the website or console?
Already have an account?
Need help with your cluster?
Contact Support
Why sign up?
To experience the ease of creating and managing clusters via the Instaclustr Console
Spin up a cluster in minutes