PGXC_NODE

PGXC_NODE stores cluster node information.

**Table 1** PGXC_NODE columns
Column	Type	Description
node_name	name	Node name.
node_type	"char"	Node type. Options: C: CN. D: DN.
node_port	integer	Port number of the node.
node_host	name	Host name or IP address of the node (if a virtual IP address is configured, its value is a virtual IP address).
node_port1	integer	Port number of a replication node.
node_host1	name	Host name or IP address of a replication node. (If a virtual IP address is configured, its value is a virtual IP address.)
hostis_primary	Boolean	Whether an active/standby switchover has occurred on the current node.
nodeis_primary	Boolean	Whether the current node is preferred to execute non-query operations in the replication table.
nodeis_preferred	Boolean	Whether the current node is preferred to execute queries in the replication table.
node_id	integer	Node identifier.
sctp_port	integer	Data channel listening port used by the active node's TCP proxy communication library or SCTP communication library.
control_port	integer	Control channel listening port used by the active node's TCP proxy communication library or SCTP communication library.
sctp_port1	integer	Data channel listening port used by the standby node's TCP proxy communication library or SCTP communication library.
control_port1	integer	Control channel listening port used by the standby node's TCP proxy communication library or SCTP communication library.
nodeis_central	Boolean	The current node is the central node.

Examples

Query the CN and DN information of the cluster.

    
     
       
       
         SELECT * FROM pgxc_node;
  node_name   | node_type | node_port | node_host | node_port1 | node_host1 | hostis_primary | nodeis_primary | nodeis_preferred |   node_id  
 | sctp_port | control_port | sctp_port1 | control_port1 | nodeis_central | read_only 
--------------+-----------+-----------+-----------+------------+------------+----------------+----------------+------------------+------------
-+-----------+--------------+------------+---------------+----------------+-----------
 datanode1    | D         |     55504 | localhost |      55504 | localhost  | t              | f              | f                |   888802358
 |     55505 |        55507 |          0 |             0 | f              | f
 datanode2    | D         |     55508 | localhost |      55508 | localhost  | t              | f              | f                |  -905831925
 |     55509 |        55511 |          0 |             0 | f              | f
 coordinator1 | C         |     55500 | localhost |      55500 | localhost  | t              | f              | f                |  1938253334
 |         0 |            0 |          0 |             0 | t              | f
 datanode3    | D         |     55542 | localhost |      55542 | localhost  | t              | f              | f                | -1894792127
 |     57552 |        55544 |          0 |             0 | f              | t
 datanode4    | D         |     55546 | localhost |      55546 | localhost  | t              | f              | f                | -1307323892
 |     57808 |        55548 |          0 |             0 | f              | t
 datanode5    | D         |     55550 | localhost |      55550 | localhost  | t              | f              | f                |  1797586929
 |     58064 |        55552 |          0 |             0 | f              | t
 datanode6    | D         |     55554 | localhost |      55554 | localhost  | t              | f              | f                |   587455710
 |     58320 |        55556 |          0 |             0 | f              | t
 datanode7    | D         |     55558 | localhost |      55558 | localhost  | t              | f              | f                | -1685037427
 |     58576 |        55560 |          0 |             0 | f              | t
 datanode8    | D         |     55562 | localhost |      55562 | localhost  | t              | f              | f                |  -993847320
 |     58832 |        55564 |          0 |             0 | f              | t
(9 rows)

        

      

    
   