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

GS_SEG_DATAFILE_LAYOUT

GS_SEG_DATAFILE_LAYOUT displays the static layout of data files 1 to 5 in segment-page mode. Only the 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.

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.