COLUMNAR_SEGMENTS

This view stores information about each columnar_segment (column segment).

The view does not include information about deleted segment files that have yet to be garbage collected.

Column Name

Description

DATABASE_NAME

The name of the related database.

TABLE_NAME

The name of the related table.

COLUMN_NAME

The name of the related column.

SEGMENT_ID

The ID of a given segment.

COLUMN_ID

The ID of the related column.

FILE

The name of the file where a given segment is stored relative to the data directory of the node.

HOST

The hostname or IP address for the related leaf node.

PORT

The port number of the related leaf node.

NODE_ID

The ID of the related leaf node.

PARTITION

The ID of the partition on which a given segment is stored.

ROWS_COUNT

The number of rows in a given segment.

DELETED_ROWS_COUNT

The number of deleted rows in a given segment.

ENCODING

The encoding for a given column.

MIN_VALUE

The minimum value of a given column in the segment.

MAX_VALUE

The maximum value of a given column in the segment.

SEGMENT_MIN_VALUE

The minimum value of the sort key column(s) in a given segment.

SEGMENT_MAX_VALUE

The maximum value of the sort key column(s) in a given segment.

UNCOMPRESSED_SIZE

The uncompressed size of a given columnar segment in bytes. Does not include index data.

COMPRESSED_SIZE

The compressed size of a given columnar segment in bytes. Does not include index data.

CREATION_TIME

The timestamp when a given columnstore file was created.

LSN

Log sequence number of the related blob file.

TERM

The term of the database, used to uniquely identify which node was the master of a specific database.

CHECKSUM

The crc32c checksum of the file contents.

FILE_TYPE

The type for a file where a given segment is stored.

OWNS_FILE

Whether or not a corresponding file exists for a given column segment.

FILE_SIZE

The size, in bytes, of a file where a given segment is stored.

FILE_OFFSET

Specifies the offset in the file where a given segment is stored.

Last modified: March 7, 2023

Was this article helpful?