Help Center> Data Warehouse Service> Developer Guide> System Catalogs and System Views> System Views> PGXC_NODE_ENV
PGXC_NODE_ENV
PGXC_NODE_ENV displays the environmental variables information about all nodes in a cluster.
| Name | Type | Description |
|---|---|---|
| node_name | text | Names of all nodes in the cluster |
| host | text | Host names of all nodes in the cluster |
| process | integer | Process IDs of all nodes in the cluster |
| port | integer | Port numbers of all nodes in the cluster |
| installpath | text | Installation directory of all nodes in the cluster |
| datapath | text | Data directory of all nodes in the cluster |
| log_directory | text | Log directory of all nodes in the cluster |
Parent topic: System Views
Last Article: PGXC_INSTR_UNIQUE_SQL
Next Article: PGXC_OS_THREADS
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.