gp_relation_node

gp_relation_node

The gp_relation_node table contains information about the file system objects for a relation (table, view, index, and so on).

Table 1. pg_catalog.gp_relation_node
column type references description
relfilenode_oid oid pg_class.relfilenode The object id of the relation file node.
segment_file_num integer   For append-optimized tables, the append-optimized segment file number.
persistent_tid tid   Used by Greenplum Database to internally manage persistent representations of file system objects.
persistent_serial_num bigint   Log sequence number position in the transaction log for a file block.