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

column type references description
relfilenode_oid oid pg_class.relfilenode The object id of the relation file node.
segment_file_num integer   For append-only tables, the append-only segment file number.
persistent_tid tid   Used by HAWQ 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.