GET CHUNK INFO

The GET CHUNK INFO utility command allows you to retrieve information of specific chunks.

Syntax

SELECT get_chunk_info(<database_name>, <table_id>, [ chunck_id ])

Parameters

Parameter	Description
`database_name`	The database within to search for chunk
`table_id`	The id of the table related to the chunk
`chunck_id`	The id of a specific chunk to search for

Returns

Parameter	Description
`database_name`	The database within the chunk exists
`table_id`	The id of the table related to the chunk
`column_id`	The id of the column related to the chunk
`chunk_id`	The id of the chunk
`extent_id`	The id of the extent
`compressed_size`	The size of the chunk’s compressed data
`uncompressed_size`	The size of the chunk’s uncompressed data

Examples

SELECT get_chunk_info(mfg_ldc_lake, 17271948, 143);

Output:

database_name |table_id |column_id |chunk_id |extent_id |compressed_size |uncompressed_size
--------------+---------+----------+---------+----------+----------------+-----------------
mfg_ldc       |17271948 |16        |143      |142       |9892            |9892
mfg_ldc       |17271948 |17        |143      |142       |8               |39568

Permissions

This utility function requires a SUPERUSER permission.