Misc Metrics

The Misc metrics group provides details on:

  • Open locks in the database cluster
  • Which node is currently the leader / master (i.e. accepting writes)
  • Node uptime

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.

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