SingleStore Managed Service

information_schema.MV_COLUMNAR_SEGMENT_INDEX

This view stores information about indexes used to sort columnstore segments.

Column Name

Description

DATABASE_NAME

The name of the related database.

TABLE_NAME

The name of the related table.

INDEX_NAME

The name of a given columnstore segment’s index.

SEGMENT_ID

The ID of a given columnstore segment.

FILE

The name of a given columnstore file.

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 related partition.

ENCODING

The type of encoding for a given column.

UNCOMPRESSED_SIZE

The uncompressed size, in MB, of a given segement index.

COMPRESSED_SIZE

The compressed size, in MB, of a given segement index.

CREATION_TIME

The timestamp when a given columnstore segment 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_OFFSET

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