GS_SEG_SEGMENTS
GS_SEG_SEGMENTS displays information about segments in all tablespaces, including tables, indexes, TOAST, TOAST INDEX segments, and fsm fork and vm fork segments. Only an administrator can query the information.
Name |
Type |
Description |
---|---|---|
node_name |
text |
Node name. |
schema_name |
name |
Namespace to which a segment belongs. |
segment_name |
name |
Part object name, which is obtained from pg_class and relname in pg_partition. |
partition_name |
name |
Partition name of the segment object (NULL if the segment object is not partitioned). Source: pg_partition.relname. |
forknum |
integer |
Fork type of a segment object. Value range:
|
segment_type |
text |
Segment object type. Value range:
|
tablespace_name |
name |
Tablespace to which a segment object belongs. |
bucketnode |
integer |
|
head_block_id |
bigint |
Page number of the segment header. |
contents |
text |
Storage content of a data file. Value range:
|
table_name |
name |
Name of the base table to which a segment belongs. |
blocks |
bigint |
Number of logical pages of a segment. |
total_blocks |
bigint |
Number of physical pages of a segment. |
extents |
integer |
Number of logical extents of a segment. |
total_extents |
integer |
Number of physical extents of a segment. |
head_lsn |
text |
Segment header LSN. |
level0_slots |
bigint[] |
Level-0 slot array of segment extent mapping. |
level1_slots |
bigint[] |
Level-1 slot array of segment extent mapping. |
fork_head |
bigint[] |
Fork head array of a segment. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot