SESSION_SUBSCRIPTIONS
Lists the session subscriptions in the database. Shows the session view of the node subscriptions. Session subscriptions are used when running queries within the session.
| Column Name | Data Type | Description |
|---|---|---|
NODE_OID |
INTEGER |
The OID of the node. |
NODE_NAME |
VARCHAR |
The name of the subscribed node. |
SHARD_OID |
INTEGER |
The OID of the shard. |
SHARD_NAME |
VARCHAR |
The name of the shard the node is subscribed to. |
IS_PARTICIPATING |
BOOLEAN |
Defines whether or not the subscription is participating in the session. |
Example
=> SELECT * FROM SESSION_SUBSCRIPTIONS; -[ RECORD 1 ]------------------------- node_oid | 45035996273704978 node_name | v_eon_db_node0001 shard_oid | 45035996273704980 shard_name | replica is_participating | t ...