timescaledb_information.data_nodes

Get information on data nodes. This function is specific to running TimescaleDB in a multi-node setup.

Available Columns

NameDescription
node_nameData node name.
ownerOid of the user, who added the data node.
optionsOptions used when creating the data node.

Sample Usage

Get metadata related to data nodes.

  1. SELECT * FROM timescaledb_information.data_nodes;
  3.  node_name    | owner      | options                        
  4. --------------+------------+--------------------------------
  5.  dn1         | postgres   | {host=localhost,port=15431,dbname=test}   
  6.  dn2         | postgres   | {host=localhost,port=15432,dbname=test} 
  7. (2 rows)