SHOW NODE

Displays configuration parameter values that are set for a node.

Displays configuration parameter values that are set for a node. If you specify a parameter that is not set, SHOW NODE returns an empty row for that parameter.

Note

If the configuration parameter is set but requires a database restart to take effect, the value shown might differ from the active value.

Syntax

SHOW NODE node-name { parameter-name [,...] | ALL }

Parameters

node-name: Name of the target node.
parameter-name: Names of one or more node-level configuration parameters. To obtain the names of node-level parameters, query system table CONFIGURATION_PARAMETERS.
ALL: Shows all configuration parameters set at the node level.

Privileges

None

Examples

View all configuration parameters and their settings for node v_vmart_node0001:

=> SHOW NODE v_vmart_node0001 ALL;
           name            | setting
---------------------------+---------
 DefaultIdleSessionTimeout | 5 hour
 MaxClientSessions         | 20