GS_SEG_SPC_EXTENTS

GS_SEG_SPC_EXTENTS displays information about the used extents of all tablespaces. The output contains segment heads, fork heads, level-1 pages, data extents. Only the administrator can query the information.

**Table 1** GS_SEG_SPC_EXTENTS
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	Fork type of a segment object. The options are as follows: 0: main fork 1: fsm fork 2: vm fork
block_id	bigint	Start page number of a data extent.
blocks	integer	Data extension size. The value can be 1, 8, 128, 1024, or 4096.
contents	text	Storage content of a data file. The options are as follows: 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	Extended usage type. The options are as follows: segment head indicates the segment header. fork head indicates the fork header. level1 page indicates the level-1 page. data extent indicates data extents.
remain_flag	text	Specifies whether it is a shrink residual extension. 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).