TimescaleDB maintains metadata about hypertables and provides views to query for the metadata. Views are located in schema timescaledb_information and information about hypertables can be retrieved from timescaledb_information.hypertable.

For example:

SELECT * FROM timescaledb_information.hypertable WHERE table_name = 'data';

This API doc contains more information and examples.

Note that the…