SHOW_SUBSCRIBED_INSTANCES

SHOW_SUBSCRIBED_INSTANCES lists the cluster workers and their service queues.

Note

If you haven’t already, read the Workload manager guide.

Permissions

To list the service queues, the current role must have the SUPERUSER permission.

Syntax

show_subscribed_instances_statement ::=
   SELECT SHOW_SUBSCRIBED_INSTANCES();

Parameters

None

Notes

This function applies to clusters using the workload manager.

Examples

List service queues and workers

Each worker is assigned an automatic ID, and is subscribed to the 'sqream' queue upon start.

t=> SELECT SHOW_SUBSCRIBED_INSTANCES();
service | servernode | serverip      | serverport
--------+------------+---------------+-----------
sqream  | node_9383  | 192.168.0.111 |       5000
sqream  | node_9384  | 192.168.0.111 |       5001
sqream  | node_9385  | 192.168.0.111 |       5002
sqream  | node_9551  | 192.168.1.91  |       5000

This list shows all cluster nodes, their service names, IPs, and ports.