SingleStore DB

information_schema.COLUMNAR_SEGMENTS

This view stores information about each columnar_segment (column segment). The table 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 directory where a given segment is stored.

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.

COMPRESSED_SIZE

The compressed size of a given columnar segment.

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.