gp_relfile_node

The gp_relfile_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

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