> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-mintlify-8a08bda2.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> System table containing information about codecs in queue.

# system.codecs

<h2 id="description">
  Description
</h2>

Contains information about compression and encryption codecs.

You can use this table to get information about the available compression and encryption codecs

<h2 id="columns">
  Columns
</h2>

* `name` ([String](/reference/data-types)) — Codec name.
* `method_byte` ([UInt8](/reference/data-types)) — Byte which indicates codec in compressed file.
* `is_compression` ([UInt8](/reference/data-types)) — True if this codec compresses something. Otherwise it can be just a transformation that helps compression.
* `is_generic_compression` ([UInt8](/reference/data-types)) — The codec is a generic compression algorithm like lz4, zstd.
* `is_encryption` ([UInt8](/reference/data-types)) — The codec encrypts.
* `is_timeseries_codec` ([UInt8](/reference/data-types)) — The codec is for floating point timeseries codec.
* `is_experimental` ([UInt8](/reference/data-types)) — The codec is experimental.
* `description` ([String](/reference/data-types)) — A high-level description of the codec.

<h2 id="example">
  Example
</h2>

```sql title="Query" theme={null}
SELECT * FROM system.codecs WHERE name='LZ4'
```

```text title="Response" theme={null}
Row 1:
──────
name:                   LZ4
method_byte:            130
is_compression:         1
is_generic_compression: 1
is_encryption:          0
is_timeseries_codec:    0
is_experimental:        0
description:            Extremely fast; good compression; balanced speed and efficiency.
```