GS_SEG_DATAFILES

0: main fork
1: fsm fork
2: vm fork

GS_SEG_DATAFILES displays information about data files in all tablespaces. Only an administrator can query the information.

**Table 1** GS_SEG_DATAFILES columns
Name	Type	Description
node_name	text	Node name.
file_name	text	Data file name, for example, base/17467/2_fsm.
file_id	integer	Data file ID.
bucketnode	integer	0 to 1023 indicate the bucket nodes of a hash bucket table. 1024 indicates the bucket node of a segment-page ordinary table. 1025 indicates the bucket node of a segment-page global temporary table. 1026 indicates the bucket node of a segment-page unlogged table. 1027 indicates the bucket node of a segment-page local temporary table.
forknum	integer	Segment fork type. Value range: 0: main fork 1: fsm fork 2: vm fork
tablespace_name	name	Name of the tablespace to which a data file belongs.
contents	text	Storage content of a data file. Value range: permanent: permanent unlogged: no log temporary: global temporary temporary2: local temporary
extent_size	integer	Extent size of a data file.
meta_blocks	bigint	Number of allocated metadata pages of a data file.
data_blocks	bigint	Number of allocated data pages of a data file.
total_blocks	bigint	Total number of physical pages in a data file.
high_water_mark	bigint	High watermark of the number of pages used by a data file.
utilization	real	Percentage of used blocks to the total number of blocks, that is, (data_blocks + meta_blocks)/total_blocks.