GLOBAL_GS_SEG_DATAFILES

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

GLOBAL_GS_SEG_DATAFILES displays information about data files in all tablespaces on all nodes, which can only be executed on the CN. Only an administrator can query the information.

**Table 1** GLOBAL_GS_SEG_DATAFILES columns
Name	Type	Description
node_name	text	Node name.
file_name	text	Data file name. 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	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.