SHOW NODE

Displays configuration parameter values that are set for a node. If a configuration parameter is not set at the node level, SHOW NODE does not return a row for that parameter. If the configuration parameter requires a restart to take effect, the values shown might differ from the active values.

Syntax

SHOW NODE node_name { parameter_name [,...]| ALL }

Parameters

node_name

Name of node for which to show the parameter values.

parameter_name
          

Names of any configuration parameters you want to show.

ALL		

Shows all configuration parameters that are set at the node level.

Privileges

Examples

The following example shows how display all values set for v_vmart_node0001:

=> SHOW NODE v_vmart_node0001 ALL;
name              | setting
------------------+---------
MaxClientSessions | 0
(1 row)