# COLUMNAR\_SEGMENTS

This view stores information about each `columnar_segment` ([column segment](https://docs.singlestore.com/db/v9.1/create-a-database/columnstore.md)).

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](https://docs.singlestore.com/db/v9.1/create-a-database/columnstore.md)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. Uncompressed size is the total size of your data before it is compressed bySingleStore. Does not include index data.                                                                 |
| `COMPRESSED_SIZE`    | The compressed size of a given columnar segment in bytes. Compressed size is the total size of your data afterSingleStorehas compressed it into a columnar table.SingleStorehandles this compression automatically. Does not include index data. |
| `FOOTER_SIZE`        | The size of the footer of the columnar segment in bytes.                                                                                                                                                                                         |
| `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_OFFSET`        | Specifies the offset in the file where a given segment is stored.                                                                                                                                                                                |
| `STORAGE_ID`         | Storage ID of the database.                                                                                                                                                                                                                      |
| `COMPUTE_ID`         | ID of the current active compute session for the database.                                                                                                                                                                                       |
| `BLOB_COMPUTE_ID`    | ID of the compute session that wrote the segment. Can differ from`COMPUTE_ID`.                                                                                                                                                                   |

***

Modified at: October 16, 2025

Source: [/db/v9.1/reference/information-schema-reference/segment-column-and-merge-status/columnar-segments/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/segment-column-and-merge-status/columnar-segments/)

(An index of the documentation is available at /llms.txt)