system.codecs - Clickhouse

Contains information about compression and encryption codecs.

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

The system.codecs table contains the following columns (the column type is shown in brackets):

Example

Query:

sql

SELECT * FROM system.codecs WHERE name='LZ4'

Result:

text

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.