Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ System Catalogs and System Views/ System Views/ Segment-Page Storage/ GS_SEG_DATAFILES
Updated on 2025-08-19 GMT+08:00
View PDF

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. 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.
Parent topic: Segment-Page Storage