GS_SEG_SPC_REMAIN_SEGMENTS

permanent: permanent.
unlogged: no log.
temporary: global temporary.
temporary2: local temporary.

GS_SEG_SPC_REMAIN_SEGMENTS displays the residual segment information of the index tablespace, including the main fork, fsm fork, and vm fork segments. Only an administrator can query the information.

**Table 1** GS_SEG_SPC_REMAIN_SEGMENTS columns
Name	Type	Description
node_name	text	Node name.
tablespace_name	name	Tablespace name.
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	Data file fork.
block_id	bigint	Start page number of a data extent.
blocks	integer	Data extent size. The value can be 1, 8, 128, 1024, or 4096.
contents	text	Storage content of a data file. Value range: permanent: permanent. unlogged: no log. temporary: global temporary. temporary2: local temporary.
in_used	text	Specifies whether a resource has been allocated. The value can be Y or N.
mapblock_location	text	Position of the extension in the map block. The format is (page_id, offset).
head_file_id	integer	Segment header file ID.
head_block_id	bigint	Page number of the segment header.
usage_type	text	Usage type of the extension. Value range: segment head: segment header. fork head: fork header. level1 page: level-1 page. data extent: data extents.
remain_flag	text	Specifies whether it is a residual extent after the SHRINK operation. The value can be Y or N.
special_data	integer	Special data section of the reverse pointer corresponding to an extent.
ipblock_location	text	Position of the extended reverse pointer. The format is (block_id, offset).