CHECK_CLUSTER_HEALTH

Checks the health of the cluster.

Checks the health of the cluster and aggregates the data in the HEALTH_WATCHDOG_BLOCKED_TRANSACTIONS view.

This is a meta-function. You must call meta-functions in a top-level SELECT statement.

Behavior type

Immutable

Syntax

SELECT CHECK_CLUSTER_HEALTH();

Example

=> select check_cluster_health();
                                     check_cluster_health                                                                                                             
-----------------------------------------------------------------------------------------------------------------------
 Cluster State: Not Healthy.
Reason: GCLX QUEUE BLOAT
Description: GCLX queue is too large.
Number of blocked transactions: 2
Hint: Try to resubmit request later or Tune the value of the database parameter GCLXBlockParameter to proceed.

(1 row)

-- On resolving
verticadb21249=> select check_cluster_health();
   check_cluster_health   
--------------------------
 Cluster State: Healthy.

(1 row)

See also

Health Watchdog