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. Value range: an int4 value in the range [1,5].
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. 2048 to 6143 indicate the bucket nodes of a range bucket table.
forknum	integer	Fork type of a segment object. 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.