gp_relation_node

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

columntypereferencesdescription
relfilenode_oidoidpg_class.relfilenodeThe object id of the relation file node.
segment_file_numinteger For append-optimized tables, the append-optimized segment file number.
persistent_tidtid Used by Greenplum Database to internally manage persistent representations of file system objects.
persistent_serial_numbigint Log sequence number position in the transaction log for a file block.

Parent topic: System Catalogs Definitions