Skip to content
TimescaleDB - Timeseries database for PostgreSQL
  • Timescale.com
  • Try for free
Getting started
Use Timescale
Tutorials
Code quick starts
API Reference
Hypertables & chunks
Distributed hypertables
Compression
Continuous aggregates
Data retention
Actions and automation
Hyperfunctions
Informational views
timescaledb_information.chunks
timescaledb_information.continuous_aggregates
timescaledb_information.compression_settings
timescaledb_information.data_nodes
timescaledb_information.dimensions
timescaledb_information.hypertables
timescaledb_information.jobs
timescaledb_information.job_stats
timescaledb_information.job_errors
timescaledb_experimental.policies
Configuration
Administration Functions
API Reference Tag Overview
Other deployment options
About Timescale
Find a docs page
Try for free
TimescaleDB API reference

Informational Views

TimescaleDB makes complex database features like partitioning and data retention easy to use with our comprehensive APIs. TimescaleDB works hard to provide detailed information about the state of your data, hypertables, chunks, and any jobs or policies you have in place.

These views provide the data and statistics you need to keep track of your database.

Found an issue on this page?

Report an issue!

Keywords

information
PreviousState trackingNexttimescaledb_information.chunks

Related Content

timescaledb_information.jobs
Get information about all jobs registered with the automatic scheduler
timescaledb_information.job_stats
Get information and statistics about automatically run jobs
timescaledb_information.job_errors
Get information about background job errors
hypertable_compression_stats()
Get hypertable statistics related to compression
hypertable_detailed_size()
Get detailed information about disk space used by a hypertable
timescaledb_information.chunks
Get metadata about hypertable chunks