Monitoring the Configuration and Health of Your Cluster
The Spock extension provides several ways you can monitor data health in your Postgres cluster:
- You can query informational tables in the
spockschema to review information about your cluster configuration and status. - The status views
spock.node_status,spock.subscription_status,spock.worker_status,spock.slot_statusandspock.eventsgive a complete picture of a node without reading the server log. - The Spock extension's Lag Tracking utility allows you to review node-specific metrics for replication lag.
- Use Spock's Sync Event utility to watch for a specific transaction to replicate.
- Use the ACE (Active Consistency Engine) to evaluate cluster health.