Skip to content

Epsio HA Deployment

ENTERPRISE DEPLOYMENT ONLY

At this time, Epsio running in "HA mode" is only available for enterprise deployments.

list_instances

The list_instances function/procedure returns information about the status of all Epsio instances (primary and replica nodes) connected to the database. If

Syntax

SELECT * FROM epsio.list_instances();

Output

Column Information
id The ID of the instance
is_primary Whether or not the Epsio instance is the primary node
status The current status of the Epsio instance (running or stopped)
last_heartbeat The last time the Epsio instance sent a heartbeat to the database
is_healthy Whether or not the instance is alive according to check_epsio_status. If this is false, no commands will be sent to this instance.