Skip to main content
Get metadata about the s of s. This view shows metadata for the ‘s primary time-based dimension. For information about a ‘s secondary dimensions, the dimensions view should be used instead. If the ‘s primary dimension is of a time datatype, range_start and range_end are set. Otherwise, if the primary dimension type is integer based, range_start_integer and range_end_integer are set.

​
Samples

Get information about the s of a .
Dimension builder by_range was introduced in 2.13. The chunk_creation_time metadata was introduced in 2.13.
CREATE TABLESPACE tablespace1 location '/usr/local/pgsql/data1';

CREATE TABLE hyper_int (a_col integer, b_col integer, c integer);
SELECT table_name from create_hypertable('hyper_int', by_range('a_col', 10));
CREATE OR REPLACE FUNCTION integer_now_hyper_int() returns int LANGUAGE SQL STABLE as $$ SELECT coalesce(max(a_col), 0) FROM hyper_int $$;
SELECT set_integer_now_func('hyper_int', 'integer_now_hyper_int');

INSERT INTO hyper_int SELECT generate_series(1,5,1), 10, 50;

SELECT attach_tablespace('tablespace1', 'hyper_int');
INSERT INTO hyper_int VALUES( 25 , 14 , 20), ( 25, 15, 20), (25, 16, 20);

SELECT * FROM timescaledb_information.chunks WHERE hypertable_name = 'hyper_int';

-[ RECORD 1 ]----------+----------------------
hypertable_schema      | public
hypertable_name        | hyper_int
chunk_schema           | _timescaledb_internal
chunk_name             | _hyper_7_10_chunk
primary_dimension      | a_col
primary_dimension_type | integer
range_start            |
range_end              |
range_start_integer    | 0
range_end_integer      | 10
is_compressed          | f
chunk_tablespace       |
data_nodes             |
-[ RECORD 2 ]----------+----------------------
hypertable_schema      | public
hypertable_name        | hyper_int
chunk_schema           | _timescaledb_internal
chunk_name             | _hyper_7_11_chunk
primary_dimension      | a_col
primary_dimension_type | integer
range_start            |
range_end              |
range_start_integer    | 20
range_end_integer      | 30
is_compressed          | f
chunk_tablespace       | tablespace1
data_nodes             |

​
Returns

NameTypeDescription
hypertable_schemaTEXTSchema name of the hypertable
hypertable_nameTEXTTable name of the hypertable
chunk_schemaTEXTSchema name of the chunk
chunk_nameTEXTName of the chunk
primary_dimensionTEXTName of the column that is the primary dimension
primary_dimension_typeREGTYPEType of the column that is the primary dimension
range_startTIMESTAMP WITH TIME ZONEStart of the range for the ‘s dimension
range_endTIMESTAMP WITH TIME ZONEEnd of the range for the ‘s dimension
range_start_integerBIGINTStart of the range for the ‘s dimension, if the dimension type is integer based
range_end_integerBIGINTEnd of the range for the ‘s dimension, if the dimension type is integer based
is_compressedBOOLEANIs the data in the compressed?

Note that for distributed s, this is the cached compression status of the on the access node. The cached status on the access node and data node is not in sync in some scenarios. For example, if a user compresses or decompresses the on the data node instead of the access node, or sets up compression policies directly on data nodes.

Use chunk_compression_stats() function to get real-time compression status for distributed s.
chunk_tablespaceTEXTTablespace used by the
data_nodesARRAYNodes on which the is replicated. This is applicable only to s for distributed s
chunk_creation_timeTIMESTAMP WITH TIME ZONEThe time when this was created for data addition