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

GS_SEG_DATAFILE_LAYOUT

GS_SEG_DATAFILE_LAYOUT displays the static layout of data files 1 to 5 in segment-page mode. Only an administrator can query the information.

Table 1 GS_SEG_DATAFILE_LAYOUT columns

Name

Type

Description

version

text

Segment-page version. Default value: 1.0.

seg_storage_type

text
  • segment indicates common segment-page data.
  • hashbucket indicates hash bucket data.

file_id

integer

Data file ID. Value range: an int4 value in the range [1,5].

section_id

integer

Data section ID of a data file.

section_type

text

Type of the data file section. Value range:

  • file_header indicates the file header.
  • spc_header indicates the space header.
  • map_header indicates the mapping header.
  • map_pages indicates the mapping page.
  • ip_pages(inverse pointer pages) indicates the reverse pointer page.
  • data_pages indicates the data page.

page_start

bigint

Start page number of the data section.

page_end

bigint

End page number of the data section.

page_count

bigint

Number of pages in the data section.

total_size

bigint

Size of the data section. The unit is byte.
Parent topic: Segment-Page Storage