Updated on 2024-06-03 GMT+08:00

GS_SEG_DATAFILES

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.